Data Modeling with Microsoft Power BI

Self-Service and Enterprise Data Warehouse with Power BI

Paperback Engels 2024 1e druk 9781098148553
€ 81,41
Levertijd ± 16 werkdagen
Gratis verzonden

Samenvatting

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

Specificaties

ISBN13:9781098148553
Taal:Engels
Bindwijze:paperback
Aantal pagina's:750
Uitgever:O'Reilly
Druk:1
Verschijningsdatum:31-5-2024
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

Foreword
Preface
Who Is This Book For?
What Is Data Modeling?
What Is Power BI?
What Is So Special About a Power BI Data Model?
What Is DAX?
What Is Power Query?
What Is SQL?
A New Release Every Few Weeks
How to Read This Book
Installing Necessary Software
Additional Tools
Demo Files
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments

I. Data Modeling 101
1. What Is a Data Model?
Data Model
Basic Components
Entity
Tables
Relationships
Primary Keys
Surrogate Keys
Foreign Keys
Cardinality
Combining Tables
Set Operators
Joins
Join Path Problems
Entity Relationship Diagrams
Data Modeling Options
Types of Tables
A Single Table to Store It All
Normal Forms
Dimensional Modeling
Granularity
Extract, Transform, Load
Ralph Kimball and Bill Inmon
Data Vaults and Other Anti-Patterns
Key Takeaways

2. Building a Data Model
Normalizing
Denormalizing
Calculations
Flags and Indicators
Time and Date
Role-Playing Dimensions
Slowly Changing Dimensions
Type 0: Retain Original
Type 1: Overwrite
Type 2: Add New Row
Type 3: Add New Attributes
Type 4: Add Mini-Dimensions
Types 5, 6, and 7
Hierarchies
Key Takeaways
Afgekapt op 63 regels

Managementboek Top 100

€ 81,41
Levertijd ongeveer 16 werkdagen
Gratis verzonden

Rubrieken

Producten

    Auteurs

      Trefwoorden

        Artikelen

          Data Modeling with Microsoft Power BI