Ready to begin your data analysis journey? This module focuses on the crucial first steps: importing and combining data. You'll discover how to leverage Excel's powerful Get and Transform feature, also known as Power Query, to efficiently bring data from various sources into your workbook. Learn the different methods for combining datasets to meet your specific data analysis needs. To get the most out of this module, try importing data from a new source each week.

Welcome to the exciting world of data transformation! Building on your data import skills, this module dives into how you can reshape your data for analysis. You'll learn to pivot data between wide and long formats, group information, and split columns using Power Query's powerful features. These techniques are crucial for preparing your datasets for accurate and insightful analysis. To succeed, practice each transformation step as you learn.

Ever hit Excel's 1 million row limit? This module introduces the powerful Data Model in Excel, allowing you to analyze millions of rows of data, limited only by your computer's memory. You'll learn to define database-like relationships between tables and visualize your data using Power Pivot and advanced cube functions. Master creating dynamic PivotTables from these robust data models. For best results, practice building complex data relationships.

Get ready to elevate your data presentation! In this module, we transition from Excel to Power BI, Microsoft's leading Business Intelligence tool. You'll apply your foundational skills from Power Query and DAX to design and build dynamic, interactive reports and dashboards. Learn to transform raw data into compelling visual stories and share your insights effectively. To master Power BI, experiment with different visualization types for your data.