Analyze, transform, and model data using Power BI, Power Query, DAX, and applied statistics. Deliver advanced visualizations and predictive insights that effectively communicate findings and support stakeholder understanding.
Overview
Syllabus
- Introduction to the Advanced Data Analytics Course
- In this first lesson, we'll introduce data analytics and the need for it. We'll take a brief look a each of the lessons to give students a feel for where we will be spending our time.
- Advanced Data Analytics
- This lesson focuses on the steps of data analysis. We'll also look at specific tools and techniques for analysis including how to construct and interpret histograms and linear regressions.
- Power Query Transformations
- In this lesson, we’ll dive deep into Power Query to retrieve and organize data. We'll take an in-depth look at M, the language of Power Query that helps in the data cleanup process.
- DAX Functions
- This lesson focuses on the DAX language to measure, analyze and understand data, including custom formulas, calculated measures, columns, and tables, and common DAX errors.
- Advanced Visualizations
- The focus of this lesson will be learning to create or edit advanced visualizations to analyze and present information, with the goal of drawing conclusions.
- Market Analysis Report for National Clothing Chain
- You'll use your analytics skills to create a market analysis report for an online clothing retailer using real-world data to better understand different population groups and industries.
Taught by
Joseph Lozada