[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI

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

Рет қаралды 224,770

Күн бұрын

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

Пікірлер: 422

@AnalyticswithNags 2 жыл бұрын

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 2 жыл бұрын

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

@vasoochigava5213 2 жыл бұрын

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 Жыл бұрын

subtitle pls

@at-share7690 Жыл бұрын

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

@mahletmekuria1839 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning

@nseworld5521 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

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

@devarajanmurugesan3142 Жыл бұрын

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 Жыл бұрын

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

@CeylonStats 14 күн бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Thanks keep learning. Share this channel with friends and colleagues

@Gaddy199 2 жыл бұрын

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 2 жыл бұрын

Thanks keep learning. Share this channel with friends and colleagues

@Jack-km7ec 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

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

@kingsfordgokah6240 Жыл бұрын

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

@AnalyticswithNags Жыл бұрын

Thank you

@ossimisylvestre7484 Жыл бұрын

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 Жыл бұрын

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

@sanmaj100 7 ай бұрын

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

@rameezriaz1697 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thank you, Keep Learning and Sharing the Knowledge.

@surajbatra8004 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thank you, Keep Learning.

@pankajmittal84 Жыл бұрын

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 Жыл бұрын

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

@pedrojesusrangelgil5064 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

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

@naveenkrishna9606 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

It's my pleasure

@vzntoup 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

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

@TheKanand Жыл бұрын

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

@AnalyticswithNags Жыл бұрын

Glad you enjoyed it!

@zaheerabbas97 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks. Share this channel with friends and colleagues

@MarQKis 10 ай бұрын

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

@AnalyticswithNags 8 ай бұрын

You're very welcome!

@rajkumarrajan8059 4 ай бұрын

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

@AnalyticswithNags 4 ай бұрын

Glad it was helpful!

@surajpatil3579 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning

@vickarkhan Жыл бұрын

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 ?

@AnalyticswithNags Жыл бұрын

Glad it was helpful! Sure will do in future

@reshusharma4000 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Most welcome, Keep Learning and Sharing the Knowledge.

@vinayl910 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thank you, Keep Learning and Sharing knowledge.

@asrithap2134 2 жыл бұрын

Appreciate your efforts you put in creating valuable content

@AnalyticswithNags 2 жыл бұрын

It's my pleasure

@simurgsmyrna Жыл бұрын

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 Жыл бұрын

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

@ranjansrivastava9256 10 ай бұрын

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

@AnalyticswithNags 9 ай бұрын

Watch SSIS playlist

@TheBudkai 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Check career guidance playlist

@user-zl8qu5zh8b 8 ай бұрын

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

@AnalyticswithNags 8 ай бұрын

Thanks keep learning. Share this channel with friends and colleagues

@nvkjobs3446 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

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

@bhaskarswaero7687 2 жыл бұрын

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 2 жыл бұрын

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

@bhaskarswaero7687 2 жыл бұрын

@@AnalyticswithNags Sure

@naresh71124 2 жыл бұрын

Thanks a lot Nags ❤️ waiting for this eagerly.

@AnalyticswithNags 2 жыл бұрын

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

@pavithragb4052 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning share this channel with friends and colleagues

@chlee1078 Жыл бұрын

Thank you, well explained!

@AnalyticswithNags Жыл бұрын

Glad it was helpful!

@kemelewf1531 Жыл бұрын

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

@AnalyticswithNags Жыл бұрын

Glad you like them!

@deepinderbaidwan5145 2 ай бұрын

Awesome Video. Thanks Nags 👍

@AnalyticswithNags Ай бұрын

Our pleasure!

@manishpatil5617 Жыл бұрын

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

@AnalyticswithNags 11 ай бұрын

Glad to help

@Hemach-d6q 3 күн бұрын

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

@abhishekghimire3539 6 ай бұрын

simple and crisp explanation. Thanks..

@AnalyticswithNags 4 ай бұрын

You are welcome

@ikmalzulkifli5272 20 күн бұрын

Thank you Nags for this gem!

@AnalyticswithNags 3 күн бұрын

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

@earnmoneyonline1758 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thank you, Keep Learning and Sharing the Knowledge.

@nicholas_comuni 2 жыл бұрын

Very well explained!

@AnalyticswithNags Жыл бұрын

Glad you think so!

@nattawattragunsintum8365 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

You're very welcome!

@Dobariya-vn7jk 7 ай бұрын

Thanks!

@saifullahkowshir 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Most Welcome, Keep Learning and Sharing.

@MySisao Жыл бұрын

You are the best man God bless you and your family

@AnalyticswithNags Жыл бұрын

You are so kind

@kebincui 2 жыл бұрын

Thanks, very good tutorial👍👍🌹🌹

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning share this channel with friends and colleagues

@cathrerinezetadrones3169 6 ай бұрын

Great video!!

@AnalyticswithNags 6 ай бұрын

Glad you enjoyed it

@Pirate_Hunter_Zoro11x 2 ай бұрын

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

@AnalyticswithNags Ай бұрын

Glad to hear that

@rroy1283 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thank you! Will do!

@baderalzuraiq9968 2 жыл бұрын

Great content 👍

@AnalyticswithNags 2 жыл бұрын

Glad you think so! Keep Learning

@WasimKhan-yi1et 2 ай бұрын

Thank you Sir, Great efforts

@AnalyticswithNags 2 ай бұрын

Most welcome

@MohamedSuliman-bx8ds 2 ай бұрын

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

@AnalyticswithNags Ай бұрын

That is absolutely correct

@ojusyummyreceipes7198 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

It's my pleasure

@murshed210 2 жыл бұрын

Thank you Nag.

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning

@replytosant 2 жыл бұрын

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.

@AnalyticswithNags 2 жыл бұрын

Soon will make that video

@MrBeebster 8 ай бұрын

Great Job Thank you

@AnalyticswithNags 8 ай бұрын

Thank you! Cheers!

@rajashekhar.jeshollu278 2 жыл бұрын

Thank you very much Nag

@AnalyticswithNags 2 жыл бұрын

You are welcome

@swarupasahu700 Жыл бұрын

Very interesting and informative video .

@AnalyticswithNags Жыл бұрын

Glad you liked it!

@tanmoysaha4865 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Soon will make a video on cloud

@kavithareddy6597 2 жыл бұрын

Thank you so much

@AnalyticswithNags 2 жыл бұрын

You're most welcome

@nagarjunaambati3141 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks

@onlineaccount-wh2yx 8 ай бұрын

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

@AnalyticswithNags 8 ай бұрын

Welcome 👍

@srinivasr662 2 жыл бұрын

Thanks a lot nag sir

@AnalyticswithNags 2 жыл бұрын

Thank you, Keep Learning and Sharing knowledge.

@vw13650 8 ай бұрын

Thanks sir for Guiding and helping us

@AnalyticswithNags 8 ай бұрын

Always welcome

@seema_shahabkhan 2 жыл бұрын

Thanks a lot Nags

@AnalyticswithNags 2 жыл бұрын

Always welcome

@litudora2984 Жыл бұрын

Really awesome 😎

@AnalyticswithNags Жыл бұрын

Thank you! Cheers!

@divyangjain3963 Жыл бұрын

amazing thanks alot

@AnalyticswithNags Жыл бұрын

Most welcome 😊

@DineshKumar-lo6mh 2 жыл бұрын

Thank you very much sir

@AnalyticswithNags 2 жыл бұрын

Most welcome, Keep Learning and Sharing knowledge.

@bankimdas9517 2 жыл бұрын

Thanks a lot Nags sir

@AnalyticswithNags 2 жыл бұрын

Always welcome, Keep Learning and Sharing

@stepsofstockmarket9437 10 ай бұрын

your contents are really very good

@AnalyticswithNags 4 ай бұрын

Thank you

@mulintkarthikeya7539 2 жыл бұрын

Tahnk you so much sir....

@AnalyticswithNags 2 жыл бұрын

Most welcome

@balavenugopal3269 2 жыл бұрын

Thanks lot bro

@AnalyticswithNags 2 жыл бұрын

Welcome, Keep Learning

@aadarshchoudhary9648 Жыл бұрын

Thanks nags

@AnalyticswithNags Жыл бұрын

Thanks keep learning

@Munichandra_Reddy 2 жыл бұрын

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 2 жыл бұрын

It is sql server integration services SSIS playlist

@Mousudha 3 ай бұрын

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 3 ай бұрын

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

@arslanakram8314 4 ай бұрын

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 4 ай бұрын

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

@sumiyatisumiyati3557 3 ай бұрын

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

@anilpothuru5651 2 жыл бұрын

Thank u verry much sir 👏👏🙏🙏

@AnalyticswithNags 2 жыл бұрын

Welcome, Keep Sharing with Friends and Colleagues , Keep Learning

@anilpothuru5651 2 жыл бұрын

@@AnalyticswithNags Sure sir I will share

@The_emotional_kalam 2 жыл бұрын

Awesome 👍

@AnalyticswithNags 2 жыл бұрын

Thank you! Cheers!

@The_emotional_kalam 2 жыл бұрын

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

@bchandra912 2 жыл бұрын

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 2 жыл бұрын

Already uploaded, check the channel playlist.

@gauravkataraGK 6 ай бұрын

nice

@AnalyticswithNags 6 ай бұрын

Thanks

@zeuswell 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 2 жыл бұрын

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

@imransadiq5851 2 жыл бұрын

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 Жыл бұрын

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.

@musthakhahammed6535 2 жыл бұрын

Great

@AnalyticswithNags 2 жыл бұрын

Thanks keep learning share this channel with friends and colleagues

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

@mvijayk1622 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Our Planned next in End to End series is DAX.

@usmansharifshaik1187 2 жыл бұрын

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

@shadow_gaming_sk 2 жыл бұрын

I am waiting for DAX complete series

@AnalyticswithNags 2 жыл бұрын

@@shadow_gaming_sk Wait for it its in making

@imransadiq5851 2 жыл бұрын

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

@AnalyticswithNags Жыл бұрын

Let me check

@livingstonechuma3404 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Thanks for your feedback. We won’t share the ppt

@christopheralmonteperalta4950 Жыл бұрын

I send email you analytics with nags

@deebandheiveehan9889 2 жыл бұрын

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 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

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

@marcq1588 10 ай бұрын

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 8 ай бұрын

Please check the playlist available in the channel

@chinnakotlaprakash7490 2 жыл бұрын

Thak you soo much bro

@AnalyticswithNags 2 жыл бұрын

Welcome, Keep Sharing with Friends and Colleagues , Keep Learning

@chinnakotlaprakash7490 2 жыл бұрын

@@AnalyticswithNags deffanently I will share with my friends

@vickarkhan Жыл бұрын

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 Жыл бұрын

Sure will do in future

@vickarkhan Жыл бұрын

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

@siddharth5355 Жыл бұрын

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

@AnalyticswithNags Жыл бұрын

Thanks keep learning share this channel with friends and colleagues

@siddharth5355 Жыл бұрын

@@AnalyticswithNags already done sir 🙏

@badrinath9103 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Will try to do soon

@sergeyt4118 2 жыл бұрын

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 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 2 жыл бұрын

@joyo2122 2 жыл бұрын

it is the same procedure

@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

@JARAME_ 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Will plan in future.

@ananthm6731 2 жыл бұрын

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

@AnalyticswithNags 2 жыл бұрын

Yes that is what Power bi dataset as a source in power BI. I explained in this video. kzfaq.info/get/bejne/ep6IasSIyNzPhoU.html

@MilanDhanjee 8 ай бұрын

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

@AnalyticswithNags 8 ай бұрын

Thank you! Cheers!

@prashantvarun23 Жыл бұрын

God of Power BI and SQL

@AnalyticswithNags Жыл бұрын

Thank you

@lucamel8766 Жыл бұрын

Hello sir. Tx for putting together such an informative video. I cannot follow some of the SSIS steps implemented in the video. Will you be able to publish the ssis packages used? It will help greatly to understand it

@AnalyticswithNags Жыл бұрын

Watch the Ssis playlist to understand better. We will not share any of the files