Data Modeling with Microsoft Excel. Model and analyze data using Power Pivot, DAX, and Cube functions - Helion
Tytuł oryginału: Data Modeling with Microsoft Excel. Model and analyze data using Power Pivot, DAX, and Cube functions
ISBN: 9781803236926
stron: 316, Format: ebook
Data wydania: 2023-11-30
Księgarnia: Helion
Cena książki: 85,49 zł (poprzednio: 94,99 zł)
Oszczędzasz: 10% (-9,50 zł)
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.
By the end of this 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.
Osoby które kupowały "Data Modeling with Microsoft Excel. Model and analyze data using Power Pivot, DAX, and Cube functions", wybierały także:
- Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
- Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
- Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
- Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)
- Od hierarchii do turkusu, czyli jak zarządzać w XXI wieku 58,64 zł, (12,90 zł -78%)
Spis treści
Data Modeling with Microsoft Excel. Model and analyze data using Power Pivot, DAX, and Cube functions eBook -- spis treści
- 1. Getting Started with Data Modeling – Overview and Importance
- 2. Data Structuring for Data Models
- 3. Preparing your Data for the Data Model
- 4. Data Modeling with Power Pivot
- 5. Creating DAX Calculations from your Data Model
- 6. Creating Cube Functions from your Data Model
- 7. Communicating insights from your Data Model using Dashboards
- 8. Visualization Elements for your Dashboard
- 9. Choosing the right Design Themes
- 10. Publication and Deployment