TY  - BOOK
AU  - Ehrenmueller-Jensen,Markus
TI  - Data modeling with Microsoft Power BI: self-service and enterprise data warehouses with Power BI 
SN  - 9781098148553
AV  - QA76.9.D26 E37 2024
PY  - 2024///
CY  - Sebastopol, CA
PB  - O'Reilly Media
KW  - Microsoft Power BI (Computer file)
KW  - Database design
KW  - Computer programs
KW  - Data structures (Computer science)
KW  - Business intelligence
KW  - Data processing
KW  - Big data
KW  - Bases de données
KW  - Conception
KW  - Logiciels
KW  - Structures de données (Informatique)
KW  - fast
KW  - Electronic data processing
KW  - Informational works
KW  - lcgft
KW  - Documents d'information
KW  - rvmgf
N1  - Includes index
N2  - 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
ER  -