[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - { End to End }
Vložit
- čas přidán 1. 07. 2024
- ▬▬▬▬▬▬▬▬ DATA WAREHOUSE FULL COURSE ▬▬▬▬▬▬▬▬
0) 00:00 - Topics
1) 04:02 - Introduction
2) 12:03 - Data Warehouse Architecture
3) 17:25 - Data Warehouse Terminologies
4) 44:10 - Business Case Study
5) 46:28 - Data Warehouse Designing
6) 1:04:37 - Data Warehouse Implementation
7) 1:23:14 - SSIS
8) 1:56:29 - Surrogate Key
9) 1:58:54 - Slowly Changing Dimension
10) 2:27:00 - Adding data to Dimension and Incremental Load
11) 2:37:02 - Deploy SSIS Package and SQL Agent Schedule
12) 2:47:31 - SSAS Tabular Model
13) 2:54:13 - Creating Power BI Reports
Installing SQL Server and SSDT SSMS
• Installing SQL Server ...
Adventure works OLTP Database download
github.com/Microsoft/sql-serv...
AWN Data warehouse Database Scripts
drive.google.com/file/d/1-oEO...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬
Telegram Channel - t.me/analyticswithnags
Linkedin Page - / analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro - Věda a technologie
Dear Viewers, As the End to End Series are well received , We have made another video in End to End Series about Data warehouse with SQL SSIS SSAS and Power BI its now available for you.
We have put in Huge amount of time and effort to make this let it reach all the needy learners.
Kindly SHARE it with your Social Circle / Groups - Friends and Colleagues ,
who are in learning phase to Master in Analytics.
Thank you. Team AWN.
KEEP LEARNING and SHARING KNOWLEDGE.
Remember - Data is your Asset.
sure will defintely share this toeveryone
hope more new things which is practically used in daytoday job
brilliant channel but when it comes to this amazing video. trust me all the value it could have is pretty much lost. because of just generally overviewing everything and saying go and check out ssis and ssas tutroials a had it done but still nah men whole idea of teachenig something is lost for me :))))))
subtitle pls
Can you add subtitles please? I have difficulty with the language and it will help a lot if you add subtitles
I have taken several courses on youtube but your videos comprises all the necessary activities to perform Data Engineering in one set. All my questions and doubts are answered here. OMG...you're amazing when you explain! I wish there was more than "Like" button
Thanks keep learning
Thank you for this great video, now I have a clear idea how the entire flow works from database to warehouse to SSAS to Power BI. Cleared my data warehouse concepts
Thanks keep learning. Share this channel with friends and colleagues
This is a classic end to end Data warehouse or BI Developement lifecycle. If anyone wants to understand the entire architecture of the BI, I would recommend this video. Great Work as you always do!!
Thanks keep learning. Share this channel with your connections if you are in LinkedIn
This video is awesome!!! Your time and effort to make such videos are greatly appreciated . I have experience over these technologies but you videos put things in perspective and ease it away...Continue doing ...
Thanks keep learning. Share this channel with friends and colleagues
Such an amazing video. Never knew how data warehousing was done, you made it very simple. Thanks Nags
Thanks for business enquiry contact us on analyticswithnags@gmail.com
Many thanks Nags for putting this together. This is a very relevant channel.
Thank you
Thank you very much for your lessons. For the past few months, I have learned and practiced your courses and projects and that's it, I have just obtained a position as IT Project Manager in charge of business intelligence in a big company. I will start soon. Thank you for your time, explaining us Business Intelligence best practices !!!
This is lot to me. Thanks keep learning share this channel with friends and colleagues
I watched many videos for DW but this is simply amazing the way you demonstrated the live demo is amazing!! This is the career changing video for me
Glad it was helpful!
Thanks A lot Nags. I don't have much word to appreciate.
Nags so extraordinary tutorial, no enough words to thank you!!!!, please keep it going
Thanks for your feedback. Keep learning share this channel with friends and colleagues
This is the best tutorial on the Net I have found so far. You deserve more than just my like!
Wow, thanks for your feedback. share this channel with friends and colleagues
Great Presentation and Concepts were on the spot !.. so Clear
Glad you enjoyed it!
This is a great video for a non-technical person like me to understand end to end BI implementation.
Thank you, Keep Learning.
Dear Nag, for me, as a data analyst, your vids is one of the most interesting i found on YT. Tons of work you made to teach us and to prepare materials, i think such a hard work must be sponsored by us. Why don`t I see appropriate button, hah?
Hi thanks for your feedback. Not sure what button you are speaking about. I already enabled thanks button for this video.
Email to analyticswithnags@gmail.com to discuss about sponsorship.
Talk about this channel in LinkedIn that would be grateful
@@AnalyticswithNags Dear Nag, by sponsorship, he probably means an option to pay you via Patreon, etc.
I just want you to know that you've cleared a lot of doubts. Thank a million times.
You're very welcome!
Nags, you are a wealth of knowledge. Keep it up!
Thank you, Keep Learning and Sharing the Knowledge.
Thanks a lot for your time and effort in delivering practical end to end BI Implementation.
Thanks. Share this channel with friends and colleagues
Hands-down one of the best single video compilation of precisely to the point end-to-end DWH implementation. Absolutely amazing. Any plans of composing similar such video using the Modern Cloud DWH tools such as ADF, ASA etc. in Azure ?
Glad it was helpful! Sure will do in future
Thank you Nags for this gem!
I am SAP BI/BW4 Hana consultant and learning POWER BI. For Power BI- SSIS, SSAS also required. Background concepts of all the Data warehouse tools are similar specially like the Surrogate key for the Dimension table and the same key used in the Fact table. Very well explained all these topics.
Yes. That’s true only Power BI alone not enough
Thank you Nags ... stay healthy and stay happy..!!
Thank you, Keep Learning and Sharing knowledge.
Thanks for sharing brother.. Eagerly waiting for your updated videos.. It really helps to understand in a very easy manner.🙏
It's my pleasure
Thank a lot for this content __end to end flow... I appreciate your efforts!!
Thanks keep learning
First of all, I would like to thank you for preparing such a detailed tutorial. I have never seen a training that conveys all the processes in a single session so well. Congratulations. I look forward to your modern DWH trainings with Azure Synapse and Azure Data Factory :)
I would only have one question for this session: I was wondering about the code in the Delete Stage Src (Execute SQL task) in the Refresh_SalesFact package in the SSIS_DW project.
Thanks keep learning share this channel with friends and colleagues. If you are in LinkedIn talk about this channel
Thanks for the video.Great explanation. Lot of my doubts got cleared
Thanks keep learning. Share this channel with friends and colleagues
Thanks for the video, Now I got complete flow from source to destination.
Thanks keep learning share this channel with friends and colleagues
I worked at a shitty company for 3 years and forgot all this stuff. Thank you for the refresher! Very valuable information.
Check career guidance playlist
Appreciate your efforts you put in creating valuable content
It's my pleasure
simple and crisp explanation. Thanks..
You are welcome
Thank you, well explained!
Glad it was helpful!
Great tutorial sir... Thanks much.. I will share this with my colleagues and friends... Worth sharing it.. 👍
Most welcome, Keep Learning and Sharing the Knowledge.
I viewed your videos. All in all, you are doing a great job.
Glad you like them!
Very well explained !!! Very big thanks to you Naga. This video is very useful for the resources who are new or expert in Data Warehouse ETL pipelines. It's like an eye opener for all. Naga sir, If you create a separate video on the SSIS packages step by step by taking the same example which you have used in this session it will be very very appreciable. :)
Watch SSIS playlist
Really thankful to you sir because of you I am having the basic overview and great learning view ahead to my carrier
Glad to help
Thank you very much Anna. Present days everybody without profit, they will not do anything. But you're very great, without profit you will did awesome work. You are spending more valuable time for us. Millions thanks Anna.
Thanks for the kind words. Please spread the word and Reach us to many needy learners.
@@AnalyticswithNags Sure
Thanks anna, great video for beginners end to end process. thanks once again keep posting videos like this.
Thanks keep learning. Share this channel with friends and colleagues. Talk about this channel in LinkedIn if have an account
Thanks, very good tutorial👍👍🌹🌹
Thanks keep learning share this channel with friends and colleagues
Awesome Video. Thanks Nags 👍
Our pleasure!
Thank you for such a useful video, ❤️❤️❤️❤️
Most Welcome, Keep Learning and Sharing.
Thanks a lot Nags ❤️ waiting for this eagerly.
You're most welcome, , Keep Learning and Sharing the Knowledge.
You are the best man God bless you and your family
You are so kind
Very well explained!
Glad you think so!
Thank you Nag.
Thanks keep learning
I enjoyed this video from start to 1:24:00, but for those who are absolute beginners to SSIS, please be aware that after 1:25, the video does not provide a complete SSIS package to populate data in the stage. If you are new to SSIS, I recommend gaining a basic understanding of SSIS first before proceeding with this video. There are other tutorials available that can help you get started with SSIS from scratch. Once you have a foundation, this video will be much more beneficial. And I also recommend to the Creator please pin this message and provide all links needed to follow your video otherwise lot of people devastated and there is no point of creating these kind of amazing tutorials.
thank you so much your sharing help me a lot!!!!!
You're very welcome!
Thank you sir your videos always helps to learn the data technology better 🙌!!
Glad to hear that
Thank you Anna really appreciating your works for providing free lectures of entire power bi and msbi ....
Thank you, Keep Learning and Sharing the Knowledge.
Thank you for this great video , your Chanel have enough content to every one want to start this career
That is absolutely correct
You are amazing.. More to see 👀from you.
Thank you! Will do!
Great video!!
Glad you enjoyed it
Thank you Sir, Great efforts
Most welcome
Great Job
Thank you
Thank you! Cheers!
Great content 👍
Glad you think so! Keep Learning
Thanks!
Really thank you sir ......your videos really motivates me to study....
It's my pleasure
Thank you very much Nag
You are welcome
Very interesting and informative video .
Glad you liked it!
Thank you so much for this. Please make an end to end video for cloud also.
Soon will make a video on cloud
Thanks sir for Guiding and helping us
Always welcome
Thank you very much Sir for excellent demonstration. I learned lot of things and understand things which I was missing since long time. Request you please have same end to end demo on Azure ADF. Thanks.
Soon will make that video
Extremely thankful for this video . I also joined your telegram group. Thanks a lot again
Welcome 👍
Really awesome 😎
Thank you! Cheers!
Thank you so much
You're most welcome
Thanks a lot nag sir
Thank you, Keep Learning and Sharing knowledge.
your contents are really very good
Thank you
amazing thanks alot
Most welcome 😊
Thanks a lot Nags
Always welcome
Thank you very much sir
Most welcome, Keep Learning and Sharing knowledge.
Hi Sir! Your video was incredibly helpful; it provided clarity on the entire data flow from database to warehouse to SSAS to Power BI. Could you please share the PowerPoint presentation used in the explanation? It would be greatly appreciated! Thank you for your excellent content!
Glad to hear that, we don't maintain it , will try to get and post if possible
Tahnk you so much sir....
Most welcome
Length doesn't matter for this kind of video. Thanks for your effort.
Thanks
Hello Nags - very comprehensive educational video. I learned quite a lot from it. I wanted to know if SSIS and SSAS are part of MSFT Visual Studio, or MSFT SQL Server? I will follow the entire end-to-end process from your tutorial to get real hands-on experience. I have all the pre-requisite tools, except MSFT VS.
Also, which screen recording and playback tool do you use? I am looking for something very lightweight. Thank you.
Watch career guidance playlist. Which explains what to learn in which sequence
Awesome 👍
Thank you! Cheers!
@@AnalyticswithNags bro please make something in performance tuning in SQL sever with practical examples
Thanks a lot Nags sir
Always welcome, Keep Learning and Sharing
Thanks lot bro
Welcome, Keep Learning
Hello , from where can i find the SSIS package you did to download it?
Thank u verry much sir 👏👏🙏🙏
Welcome, Keep Sharing with Friends and Colleagues , Keep Learning
@@AnalyticswithNags
Sure sir
I will share
Thanks nags
Thanks keep learning
Thank you for the great video. the question is that when loading data from source to staging do we include all attributes of source table in the staging? and what if the source tables are denormalized and in staging we want to have all related deformalized tables in one table?
It depend on the datawarehouse architect who design the solution , for future use and other considerations also plays a part in it , you can consult your arch in the project.
Thank you immensely, AWN. You are akin to the Sun, illuminating the path of knowledge for countless students who may not have access to costly courses. May you be blessed with the greatest rewards for your selfless service.
One question: From where can I get the SSIS file? please upload it as well because I am not able to create it. Or at least upload the video showing SSIS file creation for this project.
you can download online github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works
@@AnalyticswithNags
I don't find SSIS sln file to refresh in table sir, can you help me find which file in github you mentioned? Thankyouu
Thanks you so much nag sir.
Could you please do power bi real time project videos. Please sir upload it will very much useful.
Already uploaded, check the channel playlist.
Thank you for the great content. Can you please tell which attribute you used for look up Currency dimension ?
Let me check
Thanks for sharing looking for complete Dax, Nag bro👏✌
Our Planned next in End to End series is DAX.
@@AnalyticswithNags if this can be done then it will be more helpful for us bro
I am waiting for DAX complete series
@@MrChinna143143 Wait for it its in making
Best tutorial I have come across so far, keep up the good work sir, any chance you can share your PowerPoint Document?
Thanks for your feedback. We won’t share the ppt
I send email you analytics with nags
thank you! could you please also share a similar scenario case (or links to where it could be found if you know and its not competing with your webinars?) to realize the same DWH cycle build using PostgreSQL?
No where in internet explaining or implementing the Data warehouse. That is why we made this video.
Even in PostgreSQL you need to implement the same way , it is implemented using SQL server in this video
No where in internet explaining or implementing the Data warehouse. That is why we made this video.
Even in PostgreSQL you need to implement the same way , it is implemented using SQL server in this video
it is the same procedure
@@AnalyticswithNags you are right. it took me week to find this video. i have tried every online educational site, but no where it was practical explanation. thanks
nice
Thanks
Very interesting learning tutorial. Thank you for the time and efforts you have put into these videos.
My question is where can I find the videos related to the creation of the SSIS packages you are using in this project?
Maybe this could have been mentioned in the "requirements" at the start of the tutorial? Because now I am here and stuck, trying to figure out which videos I have to find to catch up with the missing requiremenets. I heard you saying to check out the SSIS tutorial, but there are so many videos... Is there some in particular that are about creating these exact packages you have here?
I appreciate your help.
Please check the playlist available in the channel
Great
Thanks keep learning share this channel with friends and colleagues
@@AnalyticswithNags Thank you for the reply.
Sir,
I would like to learn more about modern data warehouse. Especially in the Azur synapse analytics. I created a Microsoft account. But to use the synapse, it shows to use the card details or use any student mail. Could you please let me know if there is any way to learn and use the synapse for a trial period atleast?
thanks for sharing the SQL code, could you please share the SSIS packages as well. this would immensely help in practicing this tutorial end-to-end.
Sure will do in future
Could you please add a link in the description to download the SSIS packages used in the tutorial
Hello Nagendira, It's a great video and thanks for your knowledge share, Kindly attach the SSIS project files for executing the DTS flow.
No. The whole objective of the video is to make people learn and practise the DW on their own.
No. The whole objective of the video is to make people learn and practise the DW on their own.
In this video that ssis package concept related, videos are not there in channel
you explained the concept, if you will share, what will happen.
It is help to lots of people, after they will understand SSIS concepts after that they will look forward ssis
It is sql server integration services SSIS playlist
Thank you very much for this. I'm trying to follow this step by step. I can't find the link to your SSIS packages
Thank you! Cheers!
Hi, In the section of the video- datawarehouse implementation, for future how to remember all the scripts( AWN STG AND AWN DW scripts) while doing everything own, can it be learnt with practice?
Yes
In the Data Flow Task for the Address Table did you use 2 separate OLE DB Sources and tables to get the data that you wanted into erp.PersonAddress?
Yes
@@AnalyticswithNags Is it discussed in the video because I don't see it, unless I overlooked it. Thanks
hi sir ,please make a sample video for collection of document required for designing end to end report development .... I mean documents witch are used in real time report projects... thanks
Will try to do soon
In case of large datasets, would the DAX queries created in the PBI report using direct query (using the DW) load slowly as compared to pre-calculated DAX measures in SSAS?
As you highlighted, one of the purpose of Direct query is meant for large data models, If this direct query slowing down the performance, you need to go for SSAS tabular / Azure Analysis services.
This is what most of the Enterprise Level BI solution will follow
As you highlighted, one of the purpose of Direct query is meant for large data models, If this direct query slowing down the performance, you need to go for SSAS tabular / Azure Analysis services.
This is what most of the Enterprise Level BI solution will follow
Thankyou sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks keep learning share this channel with friends and colleagues
@@AnalyticswithNags already done sir 🙏
Good detailed explanation.Can't we implement semantic layer in PowerBI?
Yes that is what Power bi dataset as a source in power BI. I explained in this video.
czcams.com/video/D8X7aWcvkVQ/video.html
Please do you have a video like so with the modern architecture?
Will plan soon