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

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

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

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

Index

As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.

Add Column tab 52

columns, merging 53

ALL function 97

AND function 97, 106

AppSheet 7

associative colors 235

bridge table 32

calculated columns 87, 88, 112

CALCULATE function 97, 110, 111, 117

CALENDAR function 117

calendar tables 9, 10

creating 72, 73

Caspio 7

charts 157

adding 213-224

creating 159-163

formatting 213-224

client tools

fields, hiding from 82-84

tables, hiding from 82-84

collaboration, Excel 270, 273

considerations 272, 273

inviting, people to 273-275

colors

associative colors 235

gradient colors, using for scale 235-244

key data, highlighting 245

using 235

columns

adding, to data model 69-71

CONCATENATE function 98

conditional formatting 175, 209-212

connections 39...

Why subscribe?

Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals
Improve your learning with Skill Plans built especially for you
Get a free eBook or video every month
Fully searchable for easy access to vital information
Copy and paste, print, and bookmark content

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at packtpub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at customercare@packtpub.com for more details.

At www.packtpub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.