Designing Your Data Warehouse from the Ground Up
Check Out Our SSAS Blog - blog.pragmaticworks.com/topic/... What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session, we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.
If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "youtube30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZread: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
Пікірлер: 44
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
3 жыл бұрын
Now go get a job 😂
@PragmaticWorks
3 жыл бұрын
Thanks Tow Hee, so glad you enjoyed it!
@itneka
2 жыл бұрын
I just read. Sit home and get higj😂😂😂
Excellent tutorial. Thanks for posting. Explains the whole process in a 1 hr video.
@PragmaticWorks
4 жыл бұрын
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
@xst9880
3 жыл бұрын
@@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
2 жыл бұрын
@@xst9880 Only if you need a bigint. But performance-wise a normal int is always better.
Thanks for this wonderful session it is very crisp and clearly explained the fact and dimensions
@PragmaticWorks
2 жыл бұрын
Glad you enjoyed it (:
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.
Awesome as usual.
Would you say contribution in a municipality is a process or is eath specific contribution a process? Or is payment a better schema (marts)
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??
Awesome job, thanks for sharing
@PragmaticWorks
3 жыл бұрын
Hey Rodrigo, Dustin and I had a lot of fun doing this webinar, glad you enjoyed it!
Very helpful. Thank you!
@PragmaticWorks
2 жыл бұрын
Glad it was helpful!
Great video guys, very helpful
Thanks for this! A suggestion would be to try keep it a bit more simple and summarised! :)
looking forward to watching till the end. Personal Time Stamp 14:22 44:30
Nice job!
Very informative!
@PragmaticWorks
Жыл бұрын
Glad you think so!
Big help - Thanks :)
@PragmaticWorks
Жыл бұрын
Absolutely! Thanks for watching!
If the data is dirty, there can be process corrections and it can be made clean....
Like that 'somebody went home that day' lol
How do you deal with sale cancelations and returns? Do we add it to the fact table with negative values?
@PragmaticWorks
2 жыл бұрын
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
2 жыл бұрын
@@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?
10:17 Busterblock 😂. You probably have heard about this 😂😂!!
Dustin really loves cheeseballs.
So easy a janitor could do it.
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
3 жыл бұрын
@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
2 жыл бұрын
p
@kishataylor6963
8 ай бұрын
Huh ? There is no actual step by step, is that what u are saying ?
@ramielkady938
8 ай бұрын
@@kishataylor6963 Yeah .. can believe this ...
zzz...
please some practice , its a only theory like always
Annoying theory as always
@norpriest521
3 жыл бұрын
You're more annoying