[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - { End to End }

Sdílet
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

Komentáře • 419

  • @AnalyticswithNags
    @AnalyticswithNags  Před 2 lety +86

    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.

    • @devendergusain8974
      @devendergusain8974 Před 2 lety +1

      sure will defintely share this toeveryone
      hope more new things which is practically used in daytoday job

    • @vasoochigava5213
      @vasoochigava5213 Před 2 lety +1

      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 :))))))

    • @christopheralmonteperalta4950
      @christopheralmonteperalta4950 Před rokem

      subtitle pls

    • @at-share7690
      @at-share7690 Před rokem

      Can you add subtitles please? I have difficulty with the language and it will help a lot if you add subtitles

  • @mahletmekuria1839
    @mahletmekuria1839 Před 2 lety +38

    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

  • @seema_shahabkhan
    @seema_shahabkhan Před 2 lety +15

    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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Thanks keep learning. Share this channel with friends and colleagues

  • @devarajanmurugesan3142
    @devarajanmurugesan3142 Před rokem +5

    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!!

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem

      Thanks keep learning. Share this channel with your connections if you are in LinkedIn

  • @Gaddy199
    @Gaddy199 Před 2 lety +9

    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 ...

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Thanks keep learning. Share this channel with friends and colleagues

  • @Jack-km7ec
    @Jack-km7ec Před rokem +3

    Such an amazing video. Never knew how data warehousing was done, you made it very simple. Thanks Nags

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem

      Thanks for business enquiry contact us on analyticswithnags@gmail.com

  • @kingsfordgokah6240
    @kingsfordgokah6240 Před rokem +1

    Many thanks Nags for putting this together. This is a very relevant channel.

  • @ossimisylvestre7484
    @ossimisylvestre7484 Před rokem +3

    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 !!!

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem +1

      This is lot to me. Thanks keep learning share this channel with friends and colleagues

  • @rajkumarrajan8059
    @rajkumarrajan8059 Před 4 měsíci +1

    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

  • @sanmaj100
    @sanmaj100 Před 7 měsíci

    Thanks A lot Nags. I don't have much word to appreciate.

  • @pedrojesusrangelgil5064
    @pedrojesusrangelgil5064 Před 2 lety +4

    Nags so extraordinary tutorial, no enough words to thank you!!!!, please keep it going

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Thanks for your feedback. Keep learning share this channel with friends and colleagues

  • @vzntoup
    @vzntoup Před 2 lety

    This is the best tutorial on the Net I have found so far. You deserve more than just my like!

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Wow, thanks for your feedback. share this channel with friends and colleagues

  • @TheKanand
    @TheKanand Před rokem +1

    Great Presentation and Concepts were on the spot !.. so Clear

  • @surajbatra8004
    @surajbatra8004 Před 2 lety +2

    This is a great video for a non-technical person like me to understand end to end BI implementation.

  • @nseworld5521
    @nseworld5521 Před rokem +34

    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?

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem +1

      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

    • @ajaykumarnadimpalli6850
      @ajaykumarnadimpalli6850 Před rokem +2

      @@AnalyticswithNags Dear Nag, by sponsorship, he probably means an option to pay you via Patreon, etc.

  • @MarQKis
    @MarQKis Před 9 měsíci +1

    I just want you to know that you've cleared a lot of doubts. Thank a million times.

  • @rameezriaz1697
    @rameezriaz1697 Před 2 lety

    Nags, you are a wealth of knowledge. Keep it up!

  • @zaheerabbas97
    @zaheerabbas97 Před 2 lety +1

    Thanks a lot for your time and effort in delivering practical end to end BI Implementation.

  • @vickarkhan
    @vickarkhan Před rokem +3

    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 ?

  • @ikmalzulkifli5272
    @ikmalzulkifli5272 Před 8 dny

    Thank you Nags for this gem!

  • @pankajmittal84
    @pankajmittal84 Před rokem +2

    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.

  • @vinayl910
    @vinayl910 Před 2 lety +1

    Thank you Nags ... stay healthy and stay happy..!!

  • @naveenkrishna9606
    @naveenkrishna9606 Před 2 lety +4

    Thanks for sharing brother.. Eagerly waiting for your updated videos.. It really helps to understand in a very easy manner.🙏

  • @surajpatil3579
    @surajpatil3579 Před 2 lety +3

    Thank a lot for this content __end to end flow... I appreciate your efforts!!

  • @simurgsmyrna
    @simurgsmyrna Před rokem +5

    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.

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem

      Thanks keep learning share this channel with friends and colleagues. If you are in LinkedIn talk about this channel

  • @user-zl8qu5zh8b
    @user-zl8qu5zh8b Před 7 měsíci +1

    Thanks for the video.Great explanation. Lot of my doubts got cleared

    • @AnalyticswithNags
      @AnalyticswithNags  Před 7 měsíci

      Thanks keep learning. Share this channel with friends and colleagues

  • @pavithragb4052
    @pavithragb4052 Před 2 lety +1

    Thanks for the video, Now I got complete flow from source to destination.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Thanks keep learning share this channel with friends and colleagues

  • @TheBudkai
    @TheBudkai Před rokem +1

    I worked at a shitty company for 3 years and forgot all this stuff. Thank you for the refresher! Very valuable information.

  • @asrithap2134
    @asrithap2134 Před 2 lety +2

    Appreciate your efforts you put in creating valuable content

  • @abhishekghimire3539
    @abhishekghimire3539 Před 5 měsíci +1

    simple and crisp explanation. Thanks..

  • @chlee1078
    @chlee1078 Před rokem +1

    Thank you, well explained!

  • @reshusharma4000
    @reshusharma4000 Před 2 lety +1

    Great tutorial sir... Thanks much.. I will share this with my colleagues and friends... Worth sharing it.. 👍

  • @kemelewf1531
    @kemelewf1531 Před rokem +2

    I viewed your videos. All in all, you are doing a great job.

  • @ranjansrivastava9256
    @ranjansrivastava9256 Před 9 měsíci +2

    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. :)

  • @manishpatil5617
    @manishpatil5617 Před 11 měsíci +1

    Really thankful to you sir because of you I am having the basic overview and great learning view ahead to my carrier

  • @bhaskarswaero7687
    @bhaskarswaero7687 Před 2 lety +4

    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.

  • @nvkjobs3446
    @nvkjobs3446 Před 2 lety +2

    Thanks anna, great video for beginners end to end process. thanks once again keep posting videos like this.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

      Thanks keep learning. Share this channel with friends and colleagues. Talk about this channel in LinkedIn if have an account

  • @kebincui
    @kebincui Před 2 lety +1

    Thanks, very good tutorial👍👍🌹🌹

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Thanks keep learning share this channel with friends and colleagues

  • @deepinderbaidwan5145
    @deepinderbaidwan5145 Před měsícem +1

    Awesome Video. Thanks Nags 👍

  • @saifullahkowshir
    @saifullahkowshir Před 2 lety +3

    Thank you for such a useful video, ❤️❤️❤️❤️

  • @naresh71124
    @naresh71124 Před 2 lety

    Thanks a lot Nags ❤️ waiting for this eagerly.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

      You're most welcome, , Keep Learning and Sharing the Knowledge.

  • @MySisao
    @MySisao Před rokem +1

    You are the best man God bless you and your family

  • @nicholas_comuni
    @nicholas_comuni Před rokem +1

    Very well explained!

  • @murshed210
    @murshed210 Před 2 lety +1

    Thank you Nag.

  • @CeylonStats
    @CeylonStats Před 2 dny

    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.

  • @nattawattragunsintum8365
    @nattawattragunsintum8365 Před 2 lety +1

    thank you so much your sharing help me a lot!!!!!

  • @Pirate_Hunter_Zoro11x
    @Pirate_Hunter_Zoro11x Před měsícem

    Thank you sir your videos always helps to learn the data technology better 🙌!!

  • @earnmoneyonline1758
    @earnmoneyonline1758 Před 2 lety +1

    Thank you Anna really appreciating your works for providing free lectures of entire power bi and msbi ....

  • @MohamedSuliman-bx8ds
    @MohamedSuliman-bx8ds Před měsícem +1

    Thank you for this great video , your Chanel have enough content to every one want to start this career

  • @rroy1283
    @rroy1283 Před 2 lety +2

    You are amazing.. More to see 👀from you.

  • @cathrerinezetadrones3169
    @cathrerinezetadrones3169 Před 6 měsíci +1

    Great video!!

  • @WasimKhan-yi1et
    @WasimKhan-yi1et Před 2 měsíci +1

    Thank you Sir, Great efforts

  • @MrBeebster
    @MrBeebster Před 8 měsíci +1

    Great Job
    Thank you

  • @baderalzuraiq9968
    @baderalzuraiq9968 Před 2 lety +1

    Great content 👍

  • @Dobariya-vn7jk
    @Dobariya-vn7jk Před 7 měsíci

    Thanks!

  • @ojusyummyreceipes7198
    @ojusyummyreceipes7198 Před 2 lety +1

    Really thank you sir ......your videos really motivates me to study....

  • @rajashekhar.jeshollu278
    @rajashekhar.jeshollu278 Před 2 lety +1

    Thank you very much Nag

  • @swarupasahu700
    @swarupasahu700 Před rokem +1

    Very interesting and informative video .

  • @tanmoysaha4865
    @tanmoysaha4865 Před 2 lety +1

    Thank you so much for this. Please make an end to end video for cloud also.

  • @vw13650
    @vw13650 Před 8 měsíci +1

    Thanks sir for Guiding and helping us

  • @replytosant
    @replytosant Před 2 lety +1

    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.

  • @onlineaccount-wh2yx
    @onlineaccount-wh2yx Před 8 měsíci +1

    Extremely thankful for this video . I also joined your telegram group. Thanks a lot again

  • @litudora2984
    @litudora2984 Před rokem +1

    Really awesome 😎

  • @kavithareddy6597
    @kavithareddy6597 Před 2 lety +1

    Thank you so much

  • @srinivasr662
    @srinivasr662 Před 2 lety +1

    Thanks a lot nag sir

  • @stepsofstockmarket9437
    @stepsofstockmarket9437 Před 10 měsíci +1

    your contents are really very good

  • @divyangjain3963
    @divyangjain3963 Před rokem +1

    amazing thanks alot

  • @seema_shahabkhan
    @seema_shahabkhan Před 2 lety +1

    Thanks a lot Nags

  • @DineshKumar-lo6mh
    @DineshKumar-lo6mh Před 2 lety +1

    Thank you very much sir

  • @Mousudha
    @Mousudha Před 3 měsíci

    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!

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 měsíci

      Glad to hear that, we don't maintain it , will try to get and post if possible

  • @mulintkarthikeya7539
    @mulintkarthikeya7539 Před 2 lety +1

    Tahnk you so much sir....

  • @nagarjunaambati3141
    @nagarjunaambati3141 Před 2 lety +2

    Length doesn't matter for this kind of video. Thanks for your effort.

  • @zeuswell
    @zeuswell Před 2 lety +2

    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.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Watch career guidance playlist. Which explains what to learn in which sequence

  • @pahadidostDevBhandari
    @pahadidostDevBhandari Před 2 lety +1

    Awesome 👍

  • @bankimdas9517
    @bankimdas9517 Před 2 lety

    Thanks a lot Nags sir

  • @balavenugopal3269
    @balavenugopal3269 Před 2 lety +1

    Thanks lot bro

  • @fadwaAshraf
    @fadwaAshraf Před měsícem +1

    Hello , from where can i find the SSIS package you did to download it?

  • @anilpothuru5651
    @anilpothuru5651 Před 2 lety +1

    Thank u verry much sir 👏👏🙏🙏

  • @aadarshchoudhary9648
    @aadarshchoudhary9648 Před rokem +1

    Thanks nags

  • @imransadiq5851
    @imransadiq5851 Před rokem +1

    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?

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem

      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.

  • @arslanakram8314
    @arslanakram8314 Před 4 měsíci

    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.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 3 měsíci

      you can download online github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works

    • @sumiyatisumiyati3557
      @sumiyatisumiyati3557 Před 3 měsíci

      @@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

  • @bchandra912
    @bchandra912 Před 2 lety +1

    Thanks you so much nag sir.
    Could you please do power bi real time project videos. Please sir upload it will very much useful.

  • @imransadiq5851
    @imransadiq5851 Před rokem

    Thank you for the great content. Can you please tell which attribute you used for look up Currency dimension ?

  • @mvijayk1622
    @mvijayk1622 Před 2 lety +1

    Thanks for sharing looking for complete Dax, Nag bro👏✌

  • @livingstonechuma3404
    @livingstonechuma3404 Před rokem +1

    Best tutorial I have come across so far, keep up the good work sir, any chance you can share your PowerPoint Document?

  • @sergeyt4118
    @sergeyt4118 Před 2 lety +3

    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?

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      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
      @AnalyticswithNags  Před 2 lety

      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

    • @joyo2122
      @joyo2122 Před 2 lety

      it is the same procedure

    • @hirenparmar8253
      @hirenparmar8253 Před 2 lety

      @@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

  • @gauravkataraGK
    @gauravkataraGK Před 6 měsíci +1

    nice

  • @marcq1588
    @marcq1588 Před 9 měsíci +1

    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.

  • @musthakhahammed6535
    @musthakhahammed6535 Před 2 lety +1

    Great

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

      Thanks keep learning share this channel with friends and colleagues

    • @musthakhahammed6535
      @musthakhahammed6535 Před 2 lety

      @@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?

  • @vickarkhan
    @vickarkhan Před rokem +4

    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.

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem +2

      Sure will do in future

    • @vickarkhan
      @vickarkhan Před rokem +4

      Could you please add a link in the description to download the SSIS packages used in the tutorial

  • @deebandheiveehan9889
    @deebandheiveehan9889 Před 2 lety +1

    Hello Nagendira, It's a great video and thanks for your knowledge share, Kindly attach the SSIS project files for executing the DTS flow.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      No. The whole objective of the video is to make people learn and practise the DW on their own.

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      No. The whole objective of the video is to make people learn and practise the DW on their own.

  • @Munichandra_Reddy
    @Munichandra_Reddy Před 2 lety +4

    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

  • @MilanDhanjee
    @MilanDhanjee Před 8 měsíci +1

    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

  • @vinipowerbi
    @vinipowerbi Před rokem +2

    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?

  • @llciii
    @llciii Před 2 lety +1

    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?

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Yes

    • @llciii
      @llciii Před 2 lety

      @@AnalyticswithNags Is it discussed in the video because I don't see it, unless I overlooked it. Thanks

  • @badrinath9103
    @badrinath9103 Před 2 lety +1

    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

  • @surajbatra8004
    @surajbatra8004 Před 2 lety +1

    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?

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

      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

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety +1

      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

  • @siddharth5355
    @siddharth5355 Před rokem +1

    Thankyou sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

    • @AnalyticswithNags
      @AnalyticswithNags  Před rokem +1

      Thanks keep learning share this channel with friends and colleagues

    • @siddharth5355
      @siddharth5355 Před rokem

      @@AnalyticswithNags already done sir 🙏

  • @ananthm6731
    @ananthm6731 Před 2 lety +1

    Good detailed explanation.Can't we implement semantic layer in PowerBI?

    • @AnalyticswithNags
      @AnalyticswithNags  Před 2 lety

      Yes that is what Power bi dataset as a source in power BI. I explained in this video.
      czcams.com/video/D8X7aWcvkVQ/video.html

  • @alainsoppoprisogodor3629
    @alainsoppoprisogodor3629 Před 11 měsíci

    Please do you have a video like so with the modern architecture?