Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Data Modeling with Microsoft Excel

You're reading from   Data Modeling with Microsoft Excel Model and analyze data using Power Pivot, DAX, and Cube functions

Arrow left icon
Product type Paperback
Published in Nov 2023
Publisher Packt
ISBN-13 9781803240282
Length 316 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Author (1):
Arrow left icon
Bernard Obeng Boateng Bernard Obeng Boateng
Author Profile Icon Bernard Obeng Boateng
Bernard Obeng Boateng
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Part 1: Overview and Introduction to Data Modeling in Microsoft Excel
2. Chapter 1: Getting Started with Data Modeling – Overview and Importance FREE CHAPTER 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

Preface

Data Modeling with Microsoft Excel is an essential resource for anyone looking to harness the full potential of Microsoft Excel in data analysis.

This book delves deep into the advanced features of Excel, specifically focusing on Power Pivot, Data Analysis Expressions (DAX), and Cube Functions. These tools are pivotal for anyone working with large datasets and seeking to perform complex data modeling and analysis efficiently.

This book is not just about learning the functionalities; it’s about understanding how to apply these tools in real-world scenarios to derive meaningful insights from your data. Whether you are a business analyst, a data scientist, or someone who regularly works with data in Excel, this book will equip you with the skills to transform the way you interpret and present data, enhancing your analytical capabilities and decision-making processes.

lock icon The rest of the chapter is locked
Next Section arrow right
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 $19.99/month. Cancel anytime
Banner background image