Тёмный

Designing Your Data Warehouse from the Ground Up 

Pragmatic Works
Подписаться 240 тыс.
Просмотров 154 тыс.
50% 1

Check Out Our SSAS Blog - blog.pragmaticw... 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...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com

Опубликовано:

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 45   
@towhee7472
@towhee7472 3 года назад
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
@norpriest521 3 года назад
Now go get a job 😂
@PragmaticWorks
@PragmaticWorks 3 года назад
Thanks Tow Hee, so glad you enjoyed it!
@itneka
@itneka 2 года назад
I just read. Sit home and get higj😂😂😂
@AddissiddA
@AddissiddA 4 года назад
Excellent tutorial. Thanks for posting. Explains the whole process in a 1 hr video.
@PragmaticWorks
@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
@xst-k6
@xst-k6 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
@Peter_Lynch 3 года назад
@@xst-k6 Only if you need a bigint. But performance-wise a normal int is always better.
@srinivashrc5688
@srinivashrc5688 Год назад
Big help - Thanks :)
@PragmaticWorks
@PragmaticWorks Год назад
Absolutely! Thanks for watching!
@edwarddelgado9654
@edwarddelgado9654 Год назад
Nice job!
@jovyhansen3053
@jovyhansen3053 2 года назад
Very helpful. Thank you!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad it was helpful!
@jackgray1084
@jackgray1084 2 месяца назад
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?
@johnesraelo4614
@johnesraelo4614 3 года назад
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.
@SynonAnon-vi1ql
@SynonAnon-vi1ql 4 месяца назад
10:17 Busterblock 😂. You probably have heard about this 😂😂!!
@ИльяКубашин-й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??
@prateeksinha2526
@prateeksinha2526 3 года назад
Dustin really loves cheeseballs.
@EVEMASTER99
@EVEMASTER99 2 года назад
So easy a janitor could do it.
@Techie-time
@Techie-time 3 года назад
If the data is dirty, there can be process corrections and it can be made clean....
@mart1484
@mart1484 Год назад
looking forward to watching till the end. Personal Time Stamp 14:22 44:30
@MsBelita13
@MsBelita13 4 года назад
Thanks for this! A suggestion would be to try keep it a bit more simple and summarised! :)
@yoavhead222
@yoavhead222 Год назад
Great video guys, very helpful
@exoticdeven
@exoticdeven 2 года назад
Thanks for this wonderful session it is very crisp and clearly explained the fact and dimensions
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed it (:
@saadrouane6521
@saadrouane6521 4 года назад
Like that 'somebody went home that day' lol
@jonaskarlsson477
@jonaskarlsson477 3 года назад
Would you say contribution in a municipality is a process or is eath specific contribution a process? Or is payment a better schema (marts)
@SudhirKumar-rl4wt
@SudhirKumar-rl4wt 2 года назад
Very informative!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you think so!
@hatemelshesheny814
@hatemelshesheny814 Год назад
Awesome as usual.
@rodrigoprates1216
@rodrigoprates1216 3 года назад
Awesome job, thanks for sharing
@PragmaticWorks
@PragmaticWorks 3 года назад
Hey Rodrigo, Dustin and I had a lot of fun doing this webinar, glad you enjoyed it!
@edwardbernays4523
@edwardbernays4523 2 года назад
How do you deal with sale cancelations and returns? Do we add it to the fact table with negative values?
@PragmaticWorks
@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
@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?
@ervinmusovic5664
@ervinmusovic5664 4 года назад
please some practice , its a only theory like always
@ramielkady938
@ramielkady938 3 года назад
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
@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
@michelle.tuv.nguyen 3 года назад
p
@kishataylor6963
@kishataylor6963 11 месяцев назад
Huh ? There is no actual step by step, is that what u are saying ?
@ramielkady938
@ramielkady938 11 месяцев назад
@@kishataylor6963 Yeah .. can believe this ...
@chimerablack4913
@chimerablack4913 4 года назад
zzz...
@asadulrehmanasadulrehman1809
@asadulrehmanasadulrehman1809 4 года назад
Annoying theory as always
@norpriest521
@norpriest521 3 года назад
You're more annoying
Далее
Analysis Services Multidimensional vs Tabular
59:18
Просмотров 4,8 тыс.
Building an Enterprise Data Warehouse
21:20
Просмотров 28 тыс.
ПОЮ ВЖИВУЮ🎙
3:19:12
Просмотров 879 тыс.
Design a Data Warehouse | System Design
14:08
Просмотров 24 тыс.
Dimensional Modeling - Declaring Dimensions
55:32
Просмотров 24 тыс.
Processing Slowly Changing Dimensions with ADF Data Flows
1:10:53
Beginner to T-SQL [Full Course]
2:45:54
Просмотров 312 тыс.
What is a Data Warehouse?
8:21
Просмотров 97 тыс.