Data Modeling with Microsoft Excel
Model and analyze data using Power Pivot, DAX, and Cube functions
Created by Bernard Obeng Boateng
Discover how to harness Excel's advanced data modeling tools to analyze and visualize information from multiple sources. Learn to build relationships, create calculations with DAX and Cube functions, and design interactive dashboards that drive better business decisions.
Packt | Nov 2023 | 316 min
What You Will Learn
You will work with real data sets and follow step-by-step guidance to normalize, transform, and model data for analysis. As you progress, you'll practice building relationships, writing calculations, and applying best practices to create meaningful dashboards that showcase your findings.
Key Features
- Connect and model data from multiple sources using Power Pivot and Excel's Data Model
- Create flexible calculations and key metrics with DAX and Cube functions
- Design interactive dashboards to visualize insights and support decision making
Target Audience
Ideal for Excel users who want to manage and analyze large data sets more efficiently. If you already know the basics of tables and PivotTables and are ready to deepen your skills with Power Pivot, DAX, and advanced modeling, you'll find practical techniques to save time and deliver better insights.
