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

Creating relationships using primary and foreign keys

A relationship in a data model is a connection between two entities. Entities are objects that represent real-world things, such as people, places, or things. Relationships can be one-to-one, one-to-many, or many-to-many.

A one-to-one relationship means that each entity in one table is related to exactly one entity in another table. For example, a customer table might have a one-to-one relationship with an address table. Each customer would have exactly one address.

A one-to-many relationship means that each entity in one table can be related to multiple entities in another table. For example, a product table might have a one-to-many relationship with an order table. Each product can be ordered multiple times.

A many-to-many relationship means that each entity in one table can be related to multiple entities in another table and vice versa. For example, a student table might have a many-to-many relationship with a course...