Book description
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.
Product information
- Title: Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
- Author(s):
- Release date: March 2018
- Publisher(s): Apress
- ISBN: 9781484234778
You might also like
book
Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular
Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power …
book
The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, …
book
Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's …
book
Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics
Analyze company data quickly and easily using Microsoft’s powerful data tools. Learn to build scalable and …