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

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.

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

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

What delete Stage src??

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.

Can you please share those SSIS packages so we can replicate what you're doing for practice ? Thanks!

your contents are really very good

dear teacher , Can Chinese subtitles be added?

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

Dear Nag, i'd like to ask about power BI. When i get data from SQL server database connection, i'm able to create new column however i want. But when i get data from SSAS connection, i cannot create any new column (either dimension or measure). But it seems that in your video, you are able to create new column. Do you perharps know about this problem? Thank you.

why don't we just use power query to import all the data from different databases and model them into Power BI?

first of all thinks for the content, have been watching some of your videos this last week, they have the right ammount of content needed!

also i needed to comment, your english is pretty good, bur for gods sakes try to pronounce better Warehouse, its like you are saying data borrow XD

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

Hi @AnalyticswithNags, Tried to recreate the Incremental load package. However, received the following error:

TITLE: Microsoft Visual Studio
------------------------------

Error at Constraint: The variable "$Project::IsFirstTime" was not found in the Variables collection. The variable might not exist in the correct scope.

Error at Constraint: Attempt to parse the expression "@[$Project::IsFirstTime]==1" failed and returned error code 0xC00470A6. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.



------------------------------
BUTTONS:

OK
------------------------------

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

Can i extract data from cloud services using ssis

hey nag, can u enable subtitle for this great work
thank you

Is there any vedio on API. Because the interviewer asked me weather i know how to extract data through Api.

Can someone help me please listing all the softwares used in this vid?🙏🏻🙏🏻🙏🏻

I need English text subtitles😭😭😭

get date you missed out and ssis package created already what was point of making video?

can you make a single which covers also ssis package with this , most of ssis package since you have completed already which is not helpful for any

how are you double clicking all tables being selected and executed ?

Hi, Excellent course, could you please tell me where are the SSIS packages? I don't see them in the description.

Thanks a lot, so what can i do for having a data base AdventureWorks2014? want to download it

Sir there are no start date or end date options in my start date column and end date column in slowly changing dimensions and I have followed the steps correctly.
Please respond

Please, What's the Statement of Get Last Sale Date ?

God of Power BI and SQL

i get this error when trying to run the Dim.Reseller procedure "Cannot insert the value NULL into column 'ResellerName', table 'AWN_DW_Demo.dbo.DimReseller'; column does not allow nulls. INSERT fail" any fixes?

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

Im having serious problems with mapping from source to destination is there any way you van help?

Hie Nags i have questions
In my company there is OlTP Database So Do i need backup That OlTP Database in new Database and then after create staging Database
Or do i directly that my oltp database use as my source and No need to backup then i do directly staging work .?
Thanku for Videos it is really helpful ❤

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

Really awesome 😎

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

Sir ..is this video will be enough to know each and every concepts of data warehous.i want to become power bi developer so i have learned Excel , SQL server , power bi +dax , so know i want to learn dataa warehouse so plz tell me is this video enough or do I need to go for another platform..plzzz reply me and also suggest me that according to you what else I need to learn for becoming power bi developer

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

Very interesting and informative video .

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 ?

please dont fall prey to any of skillnation courses

good tutorial but i can't find the ssis file to follow with you.thanks

Why did you delete the staging table at the end of the Fact tables loading? That shows that you must fill it completely (and not incrementally) from the source next time.

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.

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?

Thanks nags

Could you please also share the SSIS_Staging and SSIS_DW VS solutions with us?

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

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.