You're reading from Data Modeling with Microsoft Excel

Product type Book

Published in Nov 2023

Publisher Packt

ISBN-13 9781803240282

Pages 316 pages

Edition 1st Edition

Languages

Concepts

Data Analysis

Author (1):

Bernard Obeng Boateng

Table of Contents (16) Chapters

Preface

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

Chapter 1: Getting Started with Data Modeling – Overview and Importance

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

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

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

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

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

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

Part 3: Putting it all together with a Dashboard

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

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

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

Chapter 10: Publication and Deployment – Sharing with Report Users

Index

Why subscribe?

Other Books You May Enjoy

Understanding the different types of schemas (snowflake and star)

When you create a data model, the arrangement of the dimension and fact tables can help you understand how the data flows from the dimension tables to filter the fact tables containing our key measures.

At the heart of our analysis are the key measures we will calculate from our fact tables. These fact tables are normally placed at the lower section of the data model, and our dimension tables are placed on top.

In certain layouts, you can also place the fact tables in the middle surrounded by dimension tables. This type of layout where several dimension tables are connected to one or multiple fact tables placed below or at the center of the dimension tables is called a star schema.

Figure 4.17 – Star schema in a data model

This is a common layout or schema for most data models. It ensures that your calculations are well optimized because it has only dimension tables of one level...