Designing Your Data Warehouse from the Ground Up

[@towhee7472]

We live in a world where I can sit at home and get high quality education for my career for free. Amazing. Thank you for this lecture.

[@norpriest521]

Now go get a job 😂

[@PragmaticWorks]

Thanks Tow Hee, so glad you enjoyed it!

[@itneka]

I just read. Sit home and get higj😂😂😂

[@AddissiddA]

Excellent tutorial. Thanks for posting. Explains the whole process in a 1 hr video.

[@PragmaticWorks]

Glad to hear that. Messay, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg

[@xst-k6]

@@PragmaticWorks 32:33 suggests using int datatype for surrogate key -> ProductSK. Since this is a DW wouldn't it be better to use bigint or double? Not rhetorical I really want to know. Thanks.

[@Peter_Lynch]

@@xst-k6 Only if you need a bigint. But performance-wise a normal int is always better.

[@mart1484]

looking forward to watching till the end. Personal Time Stamp 14:22 44:30

[@jackgray1084]

the ads are insane. can't get throught ONE concept before the next ad. every 2 minutes, what kind of learning experience do you hope this would be?

[@MsBelita13]

Thanks for this! A suggestion would be to try keep it a bit more simple and summarised! :)

[@exoticdeven]

Thanks for this wonderful session it is very crisp and clearly explained the fact and dimensions

[@PragmaticWorks]

Glad you enjoyed it (:

[@Techie-time]

If the data is dirty, there can be process corrections and it can be made clean....

[@yoavhead222]

Great video guys, very helpful

[@edwarddelgado9654]

Nice job!

[@ИльяКубашин-й6с]

Thank you for the video!! Can you give an advice, where i can read/watch about designing an olap-cube in SSAS, having a multiple fact tables in my DWH??

[@johnesraelo4614]

what is/are the best practice in building a data warehouse from an existing relational database. meaning; I have an operational database in a retail model and I would like to be able to build a data warehouse form this existing DB.

[@srinivashrc5688]

Big help - Thanks :)

[@PragmaticWorks]

Absolutely! Thanks for watching!

[@SudhirKumar-rl4wt]

Very informative!

[@PragmaticWorks]

Glad you think so!

[@hatemelshesheny814]

Awesome as usual.

[@rodrigoprates1216]

Awesome job, thanks for sharing

[@PragmaticWorks]

Hey Rodrigo, Dustin and I had a lot of fun doing this webinar, glad you enjoyed it!

[@SynonAnon-vi1ql]

10:17 Busterblock 😂. You probably have heard about this 😂😂!!

[@saadrouane6521]

Like that 'somebody went home that day' lol

[@jonaskarlsson477]

Would you say contribution in a municipality is a process or is eath specific contribution a process? Or is payment a better schema (marts)

[@jovyhansen3053]

Very helpful. Thank you!

[@PragmaticWorks]

Glad it was helpful!

[@edwardbernays4523]

How do you deal with sale cancelations and returns? Do we add it to the fact table with negative values?

[@PragmaticWorks]

Hey Edward, with data modeling it always depends on what your ultimate goal is. Adding the returns information to the sales information would create a "Consolidated" Fact table. Generally, I try to avoid this method. I would prefer to keep the returns table as a separate fact table. The sales and returns information would share a lot of the same conformed dimensions and therefore you could easily drill across and see the sales and returns by item. Hope this helps! -Mitchell Pearson

[@edwardbernays4523]

@@PragmaticWorks Makes sense! I like that approach. What about the item cancelation example? Perhaps wait untill an item is shipped before including it in the sales table?

[@EVEMASTER99]

So easy a janitor could do it.

[@prateeksinha2526]

Dustin really loves cheeseballs.

[@ramielkady938]

I just love it when a supposed to be technical-step-by-step tutorial to actually BUILD something turns out to be a HowYouDoin chatter ...

[@ramielkady938]

@Janak Dharmik People pay us to build stuff ... Why would a car mechanical engineer talk for hours - about how to replace engine parts - without actually popping the hood is a real mystery ...

[@michelle.tuv.nguyen]

p

[@kishataylor6963]

Huh ? There is no actual step by step, is that what u are saying ?

[@ramielkady938]

@@kishataylor6963 Yeah .. can believe this ...

[@ervinmusovic5664]

please some practice , its a only theory like always

[@chimerablack4913]

zzz...

[@asadulrehmanasadulrehman1809]

Annoying theory as always

[@norpriest521]

You're more annoying