Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Author: Markus Ehrenmueller-Jensen (Author)
Publisher finelybook 出版社: O’Reilly Media
Edition 版本: 1st
Publication Date 出版日期: 2024-07-16
Language 语言: English
Print Length 页数: 482 pages
ISBN-10: 109814855X
ISBN-13: 9781098148553
Book Description
Data modeling is the single most overlooked feature in Power BI Desktop, yet it’s what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting point for data modeling, as well as a handy refresher.
Author Markus Ehrenmueller-Jensen, founder of Savory Data, shows you the basic concepts of Power BI’s semantic model with hands-on examples in DAX, Power Query, and T-SQL. If you’re looking to build a data warehouse layer, chapters with T-SQL examples will get you started. You’ll begin with simple steps and gradually solve more complex problems.
This book shows you how to:
- Normalize and denormalize with DAX, Power Query, and T-SQL
- Apply best practices for calculations, flags and indicators, time and date, role-playing dimensions and slowly changing dimensions
- Solve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQL
- Discover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQL
- Work with tables, relations, set operations, normal forms, dimensional modeling, and ETL
About the Author
相关文件下载地址
相关推荐
- Microsoft 365 Copilot At Work: Using AI to Get the Most from Your Business Data and Favorite Apps
- Real-World Edge Computing: Scale, secure, and succeed in the realm of edge computing with Open Horizon
- Salesforce DevOps for Architects: Discover tools and techniques to optimize the delivery of your Salesforce projects
- Unveiling NIST Cybersecurity Framework 2.0: Secure your organization with the practical applications of CSF
- Mastering DevOps on Microsoft Power Platform: Build, deploy, and secure low-code solutions on Power Platform using Azure DevOps and GitHub
- Managing Project Risks, 2nd Edition