Free online courseExcel and Power BI Data Analysis Fundamentals (Excel, Power Query, PivotTables, DAX)

Course Description

Excel and Power BI Data Analysis Fundamentals is a free online course designed to help you build practical skills for working with data using the tools many teams rely on every day. You will learn how to move from raw data to clear insights by combining core Excel techniques with modern workflows in Power Query, PivotTables, Power Pivot, DAX, and Power BI Desktop.

The course starts by grounding you in what data analysis is and how to think about reliable, well-structured data sets. You will practice working with proper tabular layouts, Excel Tables, and logical tests, then progress into spreadsheet formulas with an emphasis on efficient, up-to-date approaches that support dynamic analysis.

As you advance, you will learn how PivotTables can summarize and explore data quickly, and how to communicate results through effective tables, charts, and conditional formatting. You will then shift into data preparation with Power Query, focusing on importing, cleaning, and transforming data so your analysis is repeatable and easy to refresh.

Next, you will compare common modeling approaches and understand when classic lookup functions make sense versus when to use Power Query or a data model. You will also get introduced to Power Pivot concepts for working with larger data sets, building relationships, and creating measures with DAX. The course concludes by connecting these skills to Power BI Desktop, reinforcing data modeling fundamentals and the end-to-end workflow from Excel-based analysis to business intelligence reporting.