You're reading from Data Modeling with Microsoft Excel Model and analyze data using Power Pivot, DAX, and Cube functions

Product type Paperback

Published in Nov 2023

Publisher Packt

ISBN-13 9781803240282

Length 316 pages

Edition 1st Edition

Languages

DAX

Tools

Excel

Concepts

Data Analysis

Author (1):

Bernard Obeng Boateng

View More author details

Table of Contents (16) Chapters

Preface

1. Part 1: Overview and Introduction to Data Modeling in Microsoft Excel

2. Chapter 1: Getting Started with Data Modeling – Overview and Importance FREE CHAPTER

3. Chapter 2: Data Structuring for Data Models – What’s the best way to layout your data?

4. Chapter 3: Preparing Your Data for the Data Model – Cleaning and Transforming Your Data Using Power Query

5. Chapter 4: Data Modeling with Power Pivot – Understanding How to Combine and Analyze Multiple Tables Using the Data Model

6. Part 2: Creating Insightful Calculations from your Data Model using DAX and Cube Functions

7. Chapter 5: Creating DAX Calculations from Your Data Model – Introduction to Measures and Calculated Columns

8. Chapter 6: Creating Cube Functions from Your Data Model – a Flexible Alternative to Calculations in Your Data Model

9. Part 3: Putting it all together with a Dashboard

10. Chapter 7: Communicating Insights from Your Data Model Using Dashboards – Overview and Uses

11. Chapter 8: Visualization Elements for Your Dashboard – Slicers, PivotCharts, Conditional Formatting, and Shapes

12. Chapter 9: Choosing the Right Design Themes – Less Is More with Colors

13. Chapter 10: Publication and Deployment – Sharing with Report Users

14. Index

Why subscribe?

15. Other Books You May Enjoy

Part 2: Creating Insightful Calculations from your Data Model using DAX and Cube Functions

This part is tailored to provide you with a comprehensive understanding of how DAX and Cube Functions can be used to create sophisticated calculations in Excel, thereby adding a new dimension of analysis to your data models. This section serves as a primer on how to create both measures and calculated columns using DAX. The section starts with the basics of DAX, helping you to understand the syntax and fundamental concepts. This chapter presents Cube Functions as a flexible alternative for incorporating calculations into your data model. You will be guided through the process of using these functions to retrieve data from Power Pivot, offering a different approach compared to DAX. The section also compares and contrasts Cube Functions with DAX, helping you understand when and how to use each effectively.

This section has the following chapters:

Chapter 5, Creating DAX Calculations...

The rest of the chapter is locked

You're reading from Data Modeling with Microsoft Excel Model and analyze data using Power Pivot, DAX, and Cube functions

Table of Contents (16) Chapters

Part 2: Creating Insightful Calculations from your Data Model using DAX and Cube Functions

Authors (1)

Personalised recommendations for you

You're reading from Data Modeling with Microsoft Excel Model and analyze data using Power Pivot, DAX, and Cube functions

Table of Contents (16) Chapters

Part 2: Creating Insightful Calculations from your Data Model using DAX and Cube Functions

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you