Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Beginning DAX with Power BI

The SQL Pro's Guide to Better Business Intelligence

Paperback Engels 2018 1e druk 9781484234761
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges.

Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario.

What You'll Learn
Turbocharge your Power BI model by adding advanced DAX programming techniques
Know when to use calculated measures versus calculated columns
Generate new tables on the fly from existing data
Optimize, monitor, and tune Power BI to improve performance of your models
Discover new ideas, tricks, and time-saving techniques for better models

Who This Book Is For
Business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios.

Specificaties

ISBN13:9781484234761
Taal:Engels
Bindwijze:paperback
Aantal pagina's:264
Uitgever:Apress
Druk:1
Verschijningsdatum:31-3-2018
Hoofdrubriek:IT-management / ICT
ISSN:

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

1. Introduction to DAX
2. Variables
3. Context
4. Summarizing and Aggregating
5. Joins
6. Filtering
7. Dates
8. Debugging and Optimizing
9. Practical DAX

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Beginning DAX with Power BI