Automate data cleaning, build relational data models, and analyze millions of rows using Excel's hidden BI tools.
Sub Category
- Microsoft
{inAds}
Objectives
- Automate tedious data extraction and cleaning workflows using Power Query, eliminating manual updates.
- Build robust relational data models using Power Pivot to seamlessly connect multiple data tables.
- Write powerful DAX formulas to calculate advanced business intelligence metrics and KPIs.
- Analyze massive datasets (millions of rows) without slowing down or crashing your Excel workbooks.
Pre Requisites
- Students should have a solid working knowledge of basic Excel, including how to write standard formulas (IF, VLOOKUP) and how to create standard PivotTables. You will need a Windows PC with Excel 2016, 2019, or Office 365 installed (Note: Power Pivot is not fully supported on Mac versions of Excel).
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)