Data Modeling with Microsoft Excel

eBook Details:

• Paperback: 316 pages
• Publisher: WOW! eBook (November 30, 2023)
• Language: English
• ISBN-10: 1803240288
• ISBN-13: 978-1803240282

eBook Description:

Data Modeling with Microsoft Excel: Save time analyzing volumes of data using a structured method to extract, model, and create insights from your data

Microsoft Excel’s BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data.

Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations.

This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You’ll also understand how to create powerful and flexible measures using DAX and Cube functions.

• Implement the concept of data modeling within and beyond Excel
• Get, transform, model, aggregate, and visualize data with Power Query
• Understand best practices for data structuring in MS Excel
• Build powerful measures using DAX from the Data Model
• Generate flexible calculations using Cube functions
• Design engaging dashboards for your users

By the end of this Data Modeling with Microsoft Excel book, you’ll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.