How to use Microsoft Excel for ETL, Data Modelling and Analytics - Full Tutorial under 30 minutes!
#excel #dataanalysis #msexcel #powerquery #powerBI #etl #datamodelling
#excel2016 #dataanalytics #microsoftexcel
** Data lake and Data Vault Tutorials **
What is a Data Vault? | 3NF vs Dimensional model vs Data Vault | Quick Starter Guide in 2020 - • What is a Data Vault ?...
What is a Datalake (2019) | Data lake vs Data Warehouse (English Subtitles) - • What is Data Lake (202...
** Check out our technology and google cloud tutorials playlists**
1) Latest technology tutorial (2020) -
• What is a Data Vault ?...
2) Google Cloud Platform Beginner Series (2020) -
• Google Cloud Platform ...
Hi Friends, I am Anshul Tiwari and welcome to our youtube channel ITkFunde.
About this video -
In this video we will use Microsoft Excel 2016 for designing an end to end BI solution. This will include ETL (extract, transform and load), data modelling and data analytics all performed within Excel.
We all know Excel is a powerful tool however with Excel Power Query we now have the ability to run advanced data analysis all within Microsoft excel.
In this leads than 30 minutes tutorial, we will learn -
1. Extract sales data from csv files
2. Load it into Excel 2016 using Power Query
3. Transform data as per business requirement
4. Build a dimensional data model within excel
5. Create a custom query to fetch Total Sales by Product Category
6. Create a dashboard in excel
Please follow the below article to enable Excel Power Query add-in in Excel 2013 , excel 2010 versions -
support.micros...
**Credit and Free Resources**
Free Sample Sales Data - github.com/gra...
**Social Links**
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde...
Instagram - / itkfunde
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!
Негізгі бет How to use Microsoft Excel for ETL, Data Modelling and Analytics - Full Tutorial under 30 minutes!
No video
Пікірлер: 81