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.
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 :))))))
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
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
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!!
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
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.
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 !!!
Very good lecture. Followed it till end. This is what exactly my company is doing and it helped me getting into work easily. Thanks Nags you did a good job.
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.
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.
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 ...
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. :)
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 ?
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.
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.
Hi, Thank you for making this wonderful video. Can you make full length video about how you created SSIS_DW packages in detail? You explained in very well, but as a beginner in SSIS, it will be harder for us to understand.
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!
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
@@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
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
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.
first of all thanks for the video, i have a question why when i create a slowly changing dimension in the historical attributes options phase i select option 2 Use start and end dates i can't find the columns of StartDate and EndDate? do you have an idea please ? because I analyzed everywhere and I did not find a solution. thank you in advance
@@AnalyticswithNags Thanks for your feedback, can you give me your email address so i can send you an explanation with screenshots of the problem, thanks in advance
Slowly Changing Dimension wizard bugged in VS 2022 perhaps? I'm also not getting any values in StartDate or EndDate drop downs. I found no solution, having tried changing from date to datetime, datetime2, changing null vs not null, replacing the view with a table. No solution works. I haven't tried an older version of Visual Studio yet.
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.
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.
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?
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.
Hi Nags, Does the Datawarehouse have to be Dimensional model, where do you store normal data tables, can you have relational model in the datawarehouse ?
@@AnalyticswithNags Could you clarify, because users want the actual textual data from their main table, but in facts there are only FK and measures. i dont want to strip the textual data to create the fact and it won't fit uniquely into dimension table. ??
this toturial is awesome, but i think your should give details on the script part, or make it from scratch, because in my opinion that's the main implementation, how do you pick out tables for datamart and all that referencing
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
How do you do all these tasks in Azure? Can you please create a Modern DW End to End project too? Would be greatly helpful as these tools are becoming legacy systems now.
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
![[[ 4 HOURS ]] SSIS Complete Tutorial - { End to End } Full Course - SQL Server Integration Services](http://i.ytimg.com/vi/G_wG-bzTCZY/mqdefault.jpg)
![[[ 4 HOURS ]] SSIS Complete Tutorial - { End to End } Full Course - SQL Server Integration Services](/img/tr.png)
![[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner](http://i.ytimg.com/vi/VO-MyVMKUC4/mqdefault.jpg)
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
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.
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
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
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 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!
Very good lecture. Followed it till end. This is what exactly my company is doing and it helped me getting into work easily. Thanks Nags you did a good job.
Thanks 😊. Keep learning. Share this channel with friends and colleagues. Talk about this channel if you are in LinkedIn
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
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.
have you make the package ?
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
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
I just want you to know that you've cleared a lot of doubts. Thank a million times.
You're very welcome!
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
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
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
Thanks!
This is a great video for a non-technical person like me to understand end to end BI implementation.
Thank you, Keep Learning.
Many thanks Nags for putting this together. This is a very relevant channel.
Thank you
Thanks for the video, Now I got complete flow from source to destination.
Thanks keep learning 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
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
Thanks for the video.Great explanation. Lot of my doubts got cleared
Thanks keep learning. Share this channel with friends and colleagues
Thank you for this great video , your Chanel have enough content to every one want to start this career
That is absolutely correct
I viewed your videos. All in all, you are doing a great job.
Glad you like them!
Length doesn't matter for this kind of video. Thanks for your effort.
Thanks
simple and crisp explanation. Thanks..
You are welcome
Great Presentation and Concepts were on the spot !.. so Clear
Glad you enjoyed it!
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
You are the best man God bless you and your family
You are so kind
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
Extremely thankful for this video . I also joined your telegram group. Thanks a lot again
Welcome 👍
Thanks for sharing brother.. Eagerly waiting for your updated videos.. It really helps to understand in a very easy manner.🙏
It's my pleasure
Thanks a lot for your time and effort in delivering practical end to end BI Implementation.
Thanks. Share this channel with friends and colleagues
Thank a lot for this content __end to end flow... I appreciate your efforts!!
Thanks keep learning
Thanks a lot for sharing the knowledge.. it helps me a lot
Thanks keep learning. Share this channel with friends and colleagues
Thank you Nags ... stay healthy and stay happy..!!
Thank you, Keep Learning and Sharing knowledge.
I watched this full vedio . its very clear for me. Thanks a lot
Thanks sir for Guiding and helping us
Always welcome
Thanks A lot Nags. I don't have much word to appreciate.
Thank you so much for this. Please make an end to end video for cloud also.
Soon will make a video on cloud
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
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.
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
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
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.
Hi,
Thank you for making this wonderful video. Can you make full length video about how you created SSIS_DW packages in detail? You explained in very well, but as a beginner in SSIS, it will be harder for us to understand.
Awesome Video. Thanks Nags 👍
Our pleasure!
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
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
Nags, you are a wealth of knowledge. Keep it up!
Thank you, Keep Learning and Sharing the Knowledge.
Thank you sir your videos always helps to learn the data technology better 🙌!!
Glad to hear that
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
Appreciate your efforts you put in creating valuable content
It's my pleasure
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
Really thank you sir ......your videos really motivates me to study....
It's my pleasure
Thank you Sir, Great efforts
Most welcome
Hello , from where can i find the SSIS package you did to download it?
You are amazing.. More to see 👀from you.
Thank you! Will do!
This was awesome. Thank you Nags
Thanks. Keep learning. Share this channel with friends and colleagues
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
Thanks, very good tutorial👍👍🌹🌹
Thanks keep learning share this channel with friends and colleagues
Thank you, well explained!
Glad it was helpful!
Thank you Nags for this gem!
Thanks keep learning. If you are in LinkedIn talk about this channel
Great Video... Now I am clear about DW, ETL. Can you share ssis package so i can more learn ssis in paractical way
Will upload soon
@@AnalyticswithNags wait for it
first of all thanks for the video, i have a question why when i create a slowly changing dimension in the historical attributes options phase i select option 2 Use start and end dates i can't find the columns of StartDate and EndDate? do you have an idea please ? because I analyzed everywhere and I did not find a solution. thank you in advance
Not sure about your question
@@AnalyticswithNags Thanks for your feedback,
can you give me your email address so i can send you an explanation with screenshots of the problem, thanks in advance
Slowly Changing Dimension wizard bugged in VS 2022 perhaps? I'm also not getting any values in StartDate or EndDate drop downs. I found no solution, having tried changing from date to datetime, datetime2, changing null vs not null, replacing the view with a table. No solution works. I haven't tried an older version of Visual Studio yet.
@@anthonyvidmar3699 just change it to datetime in both view and dimension
Very interesting and informative video .
Glad you liked it!
thank you so much your sharing help me a lot!!!!!
You're very welcome!
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.
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
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
Thank you for such a useful video, ❤️❤️❤️❤️
Most Welcome, Keep Learning and Sharing.
your contents are really very good
Thank you
Thank you for the detailed explanation. Where could I get the scripts so that I can follow together.
thank you , keep learning
Thank you Nag.
Thanks keep learning
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
@@shadow_gaming_sk Wait for it its in making
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
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!
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
Great Job
Thank you
Thank you! Cheers!
Hi Nags, Does the Datawarehouse have to be Dimensional model, where do you store normal data tables, can you have relational model in the datawarehouse ?
Watch video completely you got all questions answered
@@AnalyticswithNags Could you clarify, because users want the actual textual data from their main table, but in facts there are only FK and measures. i dont want to strip the textual data to create the fact and it won't fit uniquely into dimension table. ??
this toturial is awesome, but i think your should give details on the script part, or make it from scratch, because in my opinion that's the main implementation, how do you pick out tables for datamart and all that referencing
Thanks a lot Nags ❤️ waiting for this eagerly.
You're most welcome, , Keep Learning and Sharing the Knowledge.
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
This is awesome
I am stage the data to ssms now I have to design DWH for sales data what I have to do
After staging you need to design the dimensions modeling first then you can start populating the DW
@@AnalyticswithNags how to implement surrogate key
Thankyou sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks keep learning share this channel with friends and colleagues
@@AnalyticswithNags already done sir 🙏
Very well explained!
Glad you think so!
How do you do all these tasks in Azure?
Can you please create a Modern DW End to End project too?
Would be greatly helpful as these tools are becoming legacy systems now.
That’s after covering all azure related stuffs. That may be planned next year
Thank you very much Nag
You are welcome
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 useful video, can you upload the SSIS solution in the uploads please?
That is for your practice
Really awesome 😎
Thank you! Cheers!
Thanks for this teaching ,it was great, but i didnt get to see where to get the scripts mentioned and those used in the video
sorry we dont maintain much of these
Great video!!
Glad you enjoyed it
Please do you have a video like so with the modern architecture?
Will plan soon
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.
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
SIR, I gain lot of knowledge from your videos. Can u plz share SSIS file path for DWH end to end videos
What file path you are asking about
@@AnalyticswithNags
SSIS packages path for DWH 3 hrs demo class
Hi, Could you be so kindly to share the stored procedure used in this video as well? thank you in advance.
You need to create that is the purpose of the video. Learn and practice