Data Modeling in Excel with Power Query and Power Pivot

Businesses run on data, but manually cleaning and combining spreadsheets wastes hours of valuable time. This text-only course helps you break free from tedious manual tasks by mastering the core data transformation and modeling features inside Excel. You will learn how to build robust, automated data pipelines that turn raw, messy files into polished reports. By understanding how these tools work together, you can handle millions of rows of data with ease. What you'll learn: - Import and clean messy data from multiple sources using Power Query; - Connect disparate tables and design efficient relational data models using Power Pivot; - Write foundational DAX (Data Analysis Expressions) formulas to calculate key business metrics; - Automate recurring data transformation workflows to save hours of manual updates; - Apply industry-standard data modeling concepts, including star schemas and lookup tables. You will start with foundational data concepts and essential terminology before moving step-by-step through written explanations, practical scenarios, and structured formula exercises. This course is designed for Excel users who want to elevate their data analysis skills, with no advanced technical background required. Start transforming your data workflow today.