Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Data Modeling with Microsoft Excel

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
Author (1):
Bernard Obeng Boateng Bernard Obeng Boateng
Profile icon 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 15. Other Books You May Enjoy

Summary

In this chapter, we have applied some of the elements you can use to create your dashboard. You are now familiar with how to use mockups and layouts to set the stage for your dashboard. You learned how to use shapes and cards to project the key indicators in your dashboard. Apart from shapes, we covered how you can create sparklines, which are in-cell charts that can be used when you have limited space to present your visual.

The chapter also discussed the use of conditional formatting to apply icons to your values. We also covered some creative ways to enhance regular charts such as doughnut and area charts and how you can add slicers to add some interaction to your dashboard.

These concepts will give you a good foundation to build more complex dashboards. In the next chapter, we will add some color to what we have built so far.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}