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 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 Other Books You May Enjoy

Summary

Beyond creating your dashboard in Excel, you have now learned about various ways you can share, collaborate on, and publish your final work. Now you know how to keep your workbook safe with the Protect Sheet and workbook features and share it online. Using OneDrive, SharePoint, and Power BI, you can reach a wider audience and make your data work harder. The skills you’ve learned in this chapter will help you share your Excel dashboard effectively, keeping it flexible for updates while making sure the data stays accurate.

As we wrap up this book, reflect on the skills you’ve gained and consider how they’ll aid you in creating an effective data model in Excel and building an interactive dashboard that will provide your users with key insights for decision-making.

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}