I am interested in data staging and i would love to know how it really works. Do you have like a video or link where you showed how to stage a data ?

This is an Amazing series. Great going @leapfrogBI

Excellent information and very relevant.

Hi, thanks for the informative video. I have a question: You mention that we can track the changes of the customer by connecting primary and mini dimension table to a factless fact table. So that means the data model will have 2 fact tables and 2 dimension tables: the transactional fact and factless fact tables, and both primary and mini dimension tables will be connected to these two fact tables?

In a few years everyone will be dying to go back on prem.

6 years later and KZbin shows me my video in my feed. Ha. Regardless, I still think failure to plan for change is the single biggest reason for DW failure.

عمل جيد شكرا لك افدتني كثيرا

thanks a lot

Bravo ... nice work Bruv. My thanks to you

great content, thanks a lot

Really helpful and easy, thanks!

MashaAllah, Simple and Nice Video

Very interesting video. Thank you for putting this out there.

you are the best ! thank you

Awesome!

the best lecturer

thank you sir.❤️

talk faster, i had to speed up the video

Great Content.

Anno 2021 still holds true! Good video.

Thank you very clear, this helped a lot

Yes, Agile is best suited for BI development process. but challenge is client need to be trained properly to understand their priorities that fit in Agile

This was an excellent series. Concise and easy to follow. Enjoyed every bit of it. Thank you for making this available.

I disagree with equating data warehouse development to BI. A data warehouse can be a source for BI, but so can streaming data or Big Data for that matter. Data Warehouse development doesn't lend itself easily to an Agile approach as it is a type of project hard to devide into small chunks that will fit into a sprint and also have a working version at the end of each sprint to test. As for testing/deployment, having DevOps CI/CD in place should be a requirement these days, but most companies are not ready for it. A data warehouse development needs in depth documentation, which is not something an Agile approach typically allows for, which will trip you up further down the road as I've experienced many times. The trick obviously is a balancing act of having a waterfall approach but at the same time make the initial phase as iterative as possible from both IT and Business side of things, which, I mean, is a no brainer for any sort of chance of success. The risk that during design phase requirements will have changed by the time you start developing is a real one of course, but Data Warehouse Automation would be a possible solution to that. Starting with a pilot is usually the way it is handled Once BI enters into the fray and I do think indeed that's where I agree with your assessment, an intense iterative approach, preferably by using an Agile/Scrum methodology would be the way to go for the reasons you mentioned. With BI I mean the presentation layer of the system, either Reporting environment or Analytics environment or both, support by an abstraction layer between the data warehouse and the presentation layer, which can be established in various ways, from data marts, to using (materialized) views, data lakes, cubes etc. each having their pros and cons. Besides, at this point data warehouse is boohood in favour of data virtualization, with which I totally disagree, but that is another topic. I'd also advice to have proper data governance in place, including master data and reference data management, data lineage, data quality and data catalog as the lack of these is also a huge cause of problems, especially when it comes to change and incident management, but I realize this cannot be all done at once, but it should be on the roadmap.

Type 3 missing ? :)

Hmmm, i've tried to copy the code out through the video's but it looks like there are several methods that aren't shown (WriteJob, CreateJob etc etc) which means i can't finish the application. There's also some changes to System.Data.SqlClient which require you to go through EF6. Is it possible for you to package up and share the source code for the console application? This suits the need I have at the moment to a tee. Happy to reach out via email if you'd prefer. Thanks!

is this video still up to date on the field?

This will be interesting, i hope this process is still relevant i had a flick through the series and it's in depth. Hoping to follow it and reproduce it from start to finish. Appreciate you taking the time to make such thorough content.

Great interview question! Lol

This is helpful thank you

Great explanation

Me who watched it in 1.25 speed Build a Data Mart in 11 Minutes

That was a great explanation! Thank you.

If your dimension is growing almost as fast as the fact then we may have a degenerate dimension. Good point Also the DD gets its origin in the source system. not in the data warehousing system

Best explanation yet

Not sure if this question makes sense but for a joined fact and dimension table how is the joined table's primary key chosen when the two tables' primary keys are not the same?

Great video. Thank you for putting this out there.

"surrogate key has no business meaning" concluded all.

Your explanation was simple and clear. Thank you 😊

But isn't the mini dimension no longer SCD2 where before it was?

I've really learned somenthing here. Thank you.

Perfect!

Amazing SERIES. It's been a long time but I hope to see more series like this in the future

this video deserves so much more views... thanks sir!

Very good video, thanks for sharing your knowledge

Every time you get the reports, you delete and fill the object table with new videos?

Hi!! Could you tell me how you control the quota of free requests that you have with the API?

On your website I do not see the resources of the example followed in the video. Are they public? Thks.

I didn't know that the AVGN was also a data expert!

Thank you so much that was helpful. Does the OAuth 2.0 Authorization mean that I need to have the username and password for the youtube account in order to get the report?