Why Pay Per Course When You Can Get All of Coursera for 40% Off?
10,000+ courses, Google, IBM & Meta certificates, one annual plan at 40% off. Upgrade now.
Get Full Access
Master advanced data analysis techniques through this comprehensive 12-hour 36-minute course covering Excel, Power Query, Power BI, and DAX fundamentals. Learn essential data analysis terminology and explore Microsoft's powerful suite of data tools including Excel formulas, Power Query M code, and Power BI dashboard creation. Develop proficiency in PivotTables with 34 advanced tricks, become skilled in Power Query data shaping techniques, and gain solid foundations in DAX formulas for Power BI and Power Pivot applications. Practice creating effective dashboards through three detailed Power BI examples and tackle complex data modeling challenges including date and time dimension tables, server downtime visualizations, and data model size optimization. Solve real-world business problems such as budget vs actual analysis using both Excel formulas and Power BI solutions, handle many-to-many relationships with bridge tables, and work with multiple fact tables and slowly changing dimensions. Address data type discrepancies, create cross-tab reports with order and ship dates, and build comprehensive team-employee reports using various Microsoft Power Tools approaches.
