Skip to main content
Have a personal or library account? Click to login
Supercharge Excel Cover

Supercharge Excel

Learn How to Write DAX for Power Pivot

Publisher:Packt Publishing Limited
By:  and    
Paid access
|Mar 2025
Product purchase options
Description

Unlock Excel's full potential with data modeling and DAX. Learn step-by-step techniques to elevate your data analysis game.

Key Features

  • Comprehensive coverage of foundational to advanced DAX functions
  • Step-by-step approach with practical examples
  • Adequate bridge between Excel skills to Power BI proficiency

Book Description

This guide empowers you to master Excel and Data Analysis Expressions (DAX), guiding you from the basics of data modeling to advanced DAX functions. You'll begin by learning how to load and structure data effectively, then dive into essential DAX functions like SUM, COUNT, and FILTER, which are crucial for accurate data manipulation. As you progress, the book covers advanced concepts such as context transition, calculated columns, and time intelligence, enabling you to perform sophisticated data analyses.

By incorporating hands-on exercises, the guide ensures that you can apply what you've learned to real-world scenarios. You'll also explore advanced topics like disconnected tables and cube formulas, expanding your ability to create dynamic models and dashboards. Towards the end, the guide introduces transitioning from Excel to Power BI, helping you leverage your Excel expertise in a more powerful environment.

This book is perfect for technical professionals and Excel power users looking to enhance their data analysis skills and transition smoothly to Power BI. By the end, you'll have the knowledge and tools to take your data modeling and analysis to the next level.

What you will learn

  • Understand data modeling concepts
  • Load and transform data efficiently
  • Apply DAX functions
  • Use iterators for advanced calculations
  • Implement context transition techniques
  • Master advanced Excel-to-Power BI skills

Who this book is for

Ideal for data analysts, Excel users, and business intelligence professionals looking to deepen their data modeling and DAX skills. Basic knowledge of Excel is recommended, but no prior experience with DAX or Power BI is required.

Table of Contents

  1. Concept: Introduction to Data Modelling
  2. Concept: Loading Data
  3. Concept: Measures
  4. DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
  5. Concept: Filter Propagation
  6. Concept: Lookup Tables and Data Tables
  7. DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
  8. DAX Topic: Calculated Columns
  9. DAX Topic: CALCULATE()
  10. Concept: Evaluation Context and Context Transition
  11. DAX Topic: IF(), SWITCH(), and FIND()
  12. DAX Topic: VALUES() and HASONEVALUE()
  13. DAX Topic: ALL(), ALLEXCEPT(), and ALLSELECTED()
  14. DAX Topic: FILTER()
  15. DAX Topic: Time Intelligence
  16. DAX Topic: RELATED() and RELATEDTABLE()
  17. Concept: Disconnected Tables
  18. Concept: KPIs
  19. Concept: Multiple Data Tables
  20. Concept: Cube Formulas
  21. Moving from Excel to Power BI
  22. Next Steps on Your DAX Journey
PDF ISBN: 978-1-83664-674-7
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 219
Related subjects:
Computer sciences,
Computer sciences, other
BISAC subjects:
COM054000,
COM062000,
COM021050
Thema subjects:
UFC,
UNA,
UYZM,
UN

People also read