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

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ส.ค. 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
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 426

  • @AnalyticswithNags
    @AnalyticswithNags  2 ปีที่แล้ว +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 2 ปีที่แล้ว +1

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

    • @vasoochigava5213
      @vasoochigava5213 2 ปีที่แล้ว +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 ปีที่แล้ว

      subtitle pls

    • @at-share7690
      @at-share7690 ปีที่แล้ว

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

  • @mahletmekuria1839
    @mahletmekuria1839 2 ปีที่แล้ว +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

  • @nseworld5521
    @nseworld5521 ปีที่แล้ว +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  ปีที่แล้ว +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 ปีที่แล้ว +2

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

  • @CeylonStats
    @CeylonStats หลายเดือนก่อน +2

    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.

  • @seema_shahabkhan
    @seema_shahabkhan 2 ปีที่แล้ว +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  2 ปีที่แล้ว

      Thanks keep learning. Share this channel with friends and colleagues

  • @Gaddy199
    @Gaddy199 2 ปีที่แล้ว +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  2 ปีที่แล้ว

      Thanks keep learning. Share this channel with friends and colleagues

  • @devarajanmurugesan3142
    @devarajanmurugesan3142 ปีที่แล้ว +6

    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  ปีที่แล้ว

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

  • @Jack-km7ec
    @Jack-km7ec 2 ปีที่แล้ว +3

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

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

  • @ossimisylvestre7484
    @ossimisylvestre7484 ปีที่แล้ว +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  ปีที่แล้ว +1

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

  • @naveenkrishna9606
    @naveenkrishna9606 2 ปีที่แล้ว +4

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

  • @vickarkhan
    @vickarkhan ปีที่แล้ว +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 ?

  • @kingsfordgokah6240
    @kingsfordgokah6240 ปีที่แล้ว +1

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

  • @rameezriaz1697
    @rameezriaz1697 2 ปีที่แล้ว

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Thank you, Keep Learning and Sharing the Knowledge.

  • @TheKanand
    @TheKanand ปีที่แล้ว +1

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

  • @simurgsmyrna
    @simurgsmyrna ปีที่แล้ว +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  ปีที่แล้ว

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

  • @sanmaj100
    @sanmaj100 8 หลายเดือนก่อน

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

  • @pedrojesusrangelgil5064
    @pedrojesusrangelgil5064 2 ปีที่แล้ว +4

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

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

  • @vinayl910
    @vinayl910 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thank you, Keep Learning and Sharing knowledge.

  • @rajkumarrajan8059
    @rajkumarrajan8059 5 หลายเดือนก่อน +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

  • @pankajmittal84
    @pankajmittal84 ปีที่แล้ว +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.

    • @AnalyticswithNags
      @AnalyticswithNags  ปีที่แล้ว

      Yes. That’s true only Power BI alone not enough

  • @zaheerabbas97
    @zaheerabbas97 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Thanks. Share this channel with friends and colleagues

  • @surajpatil3579
    @surajpatil3579 2 ปีที่แล้ว +3

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

  • @asrithap2134
    @asrithap2134 2 ปีที่แล้ว +2

    Appreciate your efforts you put in creating valuable content

  • @reshusharma4000
    @reshusharma4000 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Most welcome, Keep Learning and Sharing the Knowledge.

  • @surajbatra8004
    @surajbatra8004 2 ปีที่แล้ว +2

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

  • @MarQKis
    @MarQKis 10 หลายเดือนก่อน +1

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

  • @ranjansrivastava9256
    @ranjansrivastava9256 10 หลายเดือนก่อน +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. :)

  • @chlee1078
    @chlee1078 ปีที่แล้ว +1

    Thank you, well explained!

  • @nvkjobs3446
    @nvkjobs3446 2 ปีที่แล้ว +2

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

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

  • @naresh71124
    @naresh71124 2 ปีที่แล้ว

    Thanks a lot Nags ❤️ waiting for this eagerly.

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

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

  • @vzntoup
    @vzntoup 2 ปีที่แล้ว

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

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

  • @pahadianalyst
    @pahadianalyst 14 วันที่ผ่านมา

    This was awesome. Thank you Nags

    • @AnalyticswithNags
      @AnalyticswithNags  6 วันที่ผ่านมา

      Thanks. Keep learning. Share this channel with friends and colleagues

  • @Hemach-d6q
    @Hemach-d6q 23 วันที่ผ่านมา

    I watched this full vedio . its very clear for me. Thanks a lot

  • @user-zl8qu5zh8b
    @user-zl8qu5zh8b 8 หลายเดือนก่อน +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  8 หลายเดือนก่อน

      Thanks keep learning. Share this channel with friends and colleagues

  • @bhaskarswaero7687
    @bhaskarswaero7687 2 ปีที่แล้ว +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.

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thanks for the kind words. Please spread the word and Reach us to many needy learners.

    • @bhaskarswaero7687
      @bhaskarswaero7687 2 ปีที่แล้ว

      @@AnalyticswithNags Sure

  • @deepinderbaidwan5145
    @deepinderbaidwan5145 2 หลายเดือนก่อน +1

    Awesome Video. Thanks Nags 👍

  • @abhishekghimire3539
    @abhishekghimire3539 6 หลายเดือนก่อน +1

    simple and crisp explanation. Thanks..

  • @rajibdash3316
    @rajibdash3316 8 วันที่ผ่านมา

    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.

    • @AnalyticswithNags
      @AnalyticswithNags  6 วันที่ผ่านมา

      Thanks 😊. Keep learning. Share this channel with friends and colleagues. Talk about this channel if you are in LinkedIn

  • @WasimKhan-yi1et
    @WasimKhan-yi1et 3 หลายเดือนก่อน +1

    Thank you Sir, Great efforts

  • @nicholas_comuni
    @nicholas_comuni 2 ปีที่แล้ว +1

    Very well explained!

  • @manishpatil5617
    @manishpatil5617 ปีที่แล้ว +1

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

  • @kemelewf1531
    @kemelewf1531 ปีที่แล้ว +2

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

  • @earnmoneyonline1758
    @earnmoneyonline1758 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thank you, Keep Learning and Sharing the Knowledge.

  • @Dobariya-vn7jk
    @Dobariya-vn7jk 8 หลายเดือนก่อน

    Thanks!

  • @pavithragb4052
    @pavithragb4052 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Thanks keep learning share this channel with friends and colleagues

  • @saifullahkowshir
    @saifullahkowshir 2 ปีที่แล้ว +3

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

  • @cathrerinezetadrones3169
    @cathrerinezetadrones3169 7 หลายเดือนก่อน +1

    Great video!!

  • @murshed210
    @murshed210 2 ปีที่แล้ว +1

    Thank you Nag.

  • @baderalzuraiq9968
    @baderalzuraiq9968 2 ปีที่แล้ว +1

    Great content 👍

  • @nattawattragunsintum8365
    @nattawattragunsintum8365 2 ปีที่แล้ว +1

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

  • @kebincui
    @kebincui 2 ปีที่แล้ว +1

    Thanks, very good tutorial👍👍🌹🌹

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Thanks keep learning share this channel with friends and colleagues

  • @ikmalzulkifli5272
    @ikmalzulkifli5272 หลายเดือนก่อน

    Thank you Nags for this gem!

    • @AnalyticswithNags
      @AnalyticswithNags  23 วันที่ผ่านมา

      Thanks keep learning. If you are in LinkedIn talk about this channel

  • @Pirate_Hunter_Zoro11x
    @Pirate_Hunter_Zoro11x 2 หลายเดือนก่อน

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

  • @MrBeebster
    @MrBeebster 9 หลายเดือนก่อน +1

    Great Job
    Thank you

  • @MySisao
    @MySisao 2 ปีที่แล้ว +1

    You are the best man God bless you and your family

  • @rroy1283
    @rroy1283 2 ปีที่แล้ว +2

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

  • @swarupasahu700
    @swarupasahu700 ปีที่แล้ว +1

    Very interesting and informative video .

  • @rajashekhar.jeshollu278
    @rajashekhar.jeshollu278 2 ปีที่แล้ว +1

    Thank you very much Nag

  • @litudora2984
    @litudora2984 ปีที่แล้ว +1

    Really awesome 😎

  • @srinivasr662
    @srinivasr662 2 ปีที่แล้ว +1

    Thanks a lot nag sir

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thank you, Keep Learning and Sharing knowledge.

  • @MohamedSuliman-bx8ds
    @MohamedSuliman-bx8ds 3 หลายเดือนก่อน +1

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

  • @ojusyummyreceipes7198
    @ojusyummyreceipes7198 2 ปีที่แล้ว +1

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

  • @vw13650
    @vw13650 9 หลายเดือนก่อน +1

    Thanks sir for Guiding and helping us

  • @kavithareddy6597
    @kavithareddy6597 2 ปีที่แล้ว +1

    Thank you so much

  • @replytosant
    @replytosant 2 ปีที่แล้ว +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.

  • @TheBudkai
    @TheBudkai 2 ปีที่แล้ว +1

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

  • @tanmoysaha4865
    @tanmoysaha4865 2 ปีที่แล้ว +1

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

  • @divyangjain3963
    @divyangjain3963 ปีที่แล้ว +1

    amazing thanks alot

  • @DineshKumar-lo6mh
    @DineshKumar-lo6mh 2 ปีที่แล้ว +1

    Thank you very much sir

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Most welcome, Keep Learning and Sharing knowledge.

  • @stepsofstockmarket520
    @stepsofstockmarket520 11 หลายเดือนก่อน +1

    your contents are really very good

  • @onlineaccount-wh2yx
    @onlineaccount-wh2yx 9 หลายเดือนก่อน +1

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

  • @seema_shahabkhan
    @seema_shahabkhan 2 ปีที่แล้ว +1

    Thanks a lot Nags

  • @bankimdas9517
    @bankimdas9517 2 ปีที่แล้ว

    Thanks a lot Nags sir

  • @mulintkarthikeya7539
    @mulintkarthikeya7539 2 ปีที่แล้ว +1

    Tahnk you so much sir....

  • @balavenugopal3269
    @balavenugopal3269 2 ปีที่แล้ว +1

    Thanks lot bro

  • @aadarshchoudhary9648
    @aadarshchoudhary9648 ปีที่แล้ว +1

    Thanks nags

  • @anilpothuru5651
    @anilpothuru5651 2 ปีที่แล้ว +1

    Thank u verry much sir 👏👏🙏🙏

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Welcome, Keep Sharing with Friends and Colleagues , Keep Learning

    • @anilpothuru5651
      @anilpothuru5651 2 ปีที่แล้ว

      @@AnalyticswithNags
      Sure sir
      I will share

  • @gauravkataraGK
    @gauravkataraGK 7 หลายเดือนก่อน +1

    nice

  • @ArtisticKalam
    @ArtisticKalam 2 ปีที่แล้ว +1

    Awesome 👍

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thank you! Cheers!

    • @ArtisticKalam
      @ArtisticKalam 2 ปีที่แล้ว

      @@AnalyticswithNags bro please make something in performance tuning in SQL sever with practical examples

  • @Mousudha
    @Mousudha 4 หลายเดือนก่อน

    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  4 หลายเดือนก่อน

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

  • @livingstonechuma3404
    @livingstonechuma3404 2 ปีที่แล้ว +1

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

  • @zeuswell
    @zeuswell 2 ปีที่แล้ว +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  2 ปีที่แล้ว

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

  • @mvijayk1622
    @mvijayk1622 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +2

      Our Planned next in End to End series is DAX.

    • @usmansharifshaik1187
      @usmansharifshaik1187 2 ปีที่แล้ว

      @@AnalyticswithNags if this can be done then it will be more helpful for us bro

    • @shadow_gaming_sk
      @shadow_gaming_sk 2 ปีที่แล้ว +1

      I am waiting for DAX complete series

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      @@shadow_gaming_sk Wait for it its in making

  • @deebandheiveehan9889
    @deebandheiveehan9889 2 ปีที่แล้ว +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  2 ปีที่แล้ว

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

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

  • @musthakhahammed6535
    @musthakhahammed6535 2 ปีที่แล้ว +1

    Great

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Thanks keep learning share this channel with friends and colleagues

    • @musthakhahammed6535
      @musthakhahammed6535 2 ปีที่แล้ว

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

  • @sergeyt4118
    @sergeyt4118 2 ปีที่แล้ว +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  2 ปีที่แล้ว

      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  2 ปีที่แล้ว

      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 2 ปีที่แล้ว

      it is the same procedure

    • @hirenparmar8253
      @hirenparmar8253 2 ปีที่แล้ว

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

  • @bchandra912
    @bchandra912 2 ปีที่แล้ว +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.

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Already uploaded, check the channel playlist.

  • @arslanakram8314
    @arslanakram8314 5 หลายเดือนก่อน

    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  4 หลายเดือนก่อน

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

    • @sumiyatisumiyati3557
      @sumiyatisumiyati3557 4 หลายเดือนก่อน

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

  • @siddharth5355
    @siddharth5355 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  ปีที่แล้ว +1

      Thanks keep learning share this channel with friends and colleagues

    • @siddharth5355
      @siddharth5355 ปีที่แล้ว

      @@AnalyticswithNags already done sir 🙏

  • @imransadiq5851
    @imransadiq5851 2 ปีที่แล้ว +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  2 ปีที่แล้ว

      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.

  • @imransadiq5851
    @imransadiq5851 2 ปีที่แล้ว

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

  • @marcq1588
    @marcq1588 10 หลายเดือนก่อน +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.

    • @AnalyticswithNags
      @AnalyticswithNags  9 หลายเดือนก่อน

      Please check the playlist available in the channel

  • @badrinath9103
    @badrinath9103 2 ปีที่แล้ว +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

  • @vickarkhan
    @vickarkhan ปีที่แล้ว +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  ปีที่แล้ว +2

      Sure will do in future

    • @vickarkhan
      @vickarkhan ปีที่แล้ว +4

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

  • @Munichandra_Reddy
    @Munichandra_Reddy 2 ปีที่แล้ว +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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      It is sql server integration services SSIS playlist

  • @nagarjunaambati3141
    @nagarjunaambati3141 2 ปีที่แล้ว +2

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

  • @ananthm6731
    @ananthm6731 2 ปีที่แล้ว +1

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

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว

      Yes that is what Power bi dataset as a source in power BI. I explained in this video.
      th-cam.com/video/D8X7aWcvkVQ/w-d-xo.html

  • @chinnakotlaprakash7490
    @chinnakotlaprakash7490 2 ปีที่แล้ว

    Thak you soo much bro

    • @AnalyticswithNags
      @AnalyticswithNags  2 ปีที่แล้ว +1

      Welcome, Keep Sharing with Friends and Colleagues , Keep Learning

    • @chinnakotlaprakash7490
      @chinnakotlaprakash7490 2 ปีที่แล้ว

      @@AnalyticswithNags deffanently I will share with my friends

  • @JARAME_
    @JARAME_ 2 ปีที่แล้ว +2

    Hi anna
    Please upload PWBI report server realtime tutorials
    Thanks a lot for this video Anna

  • @ArunKumar-xq4gp
    @ArunKumar-xq4gp 2 ปีที่แล้ว

    Thanks Sir for such a excellent video.Can you please share me the links for the documents so that i can practice Sql codes etc.