Beginning DAX with Power BI

The SQL Pro’s Guide to Better Business Intelligence

Business & Finance, Industries & Professions, Industries, Nonfiction, Computers, General Computing, Programming
Cover of the book Beginning DAX with Power BI by Philip Seamark, Apress
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Philip Seamark ISBN: 9781484234778
Publisher: Apress Publication: March 31, 2018
Imprint: Apress Language: English
Author: Philip Seamark
ISBN: 9781484234778
Publisher: Apress
Publication: March 31, 2018
Imprint: Apress
Language: English

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.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

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.

More books from Apress

Cover of the book Cosmos DB for MongoDB Developers by Philip Seamark
Cover of the book MariaDB and MySQL Common Table Expressions and Window Functions Revealed by Philip Seamark
Cover of the book Pro React 16 by Philip Seamark
Cover of the book Scratch by Example by Philip Seamark
Cover of the book Practical Linux Infrastructure by Philip Seamark
Cover of the book Visual Studio Lightswitch 2015 by Philip Seamark
Cover of the book Traders at Work by Philip Seamark
Cover of the book Big Data Bootcamp by Philip Seamark
Cover of the book Modern Data Access with Entity Framework Core by Philip Seamark
Cover of the book Go Recipes by Philip Seamark
Cover of the book Beginning Oracle PL/SQL by Philip Seamark
Cover of the book Grow Your Global Markets by Philip Seamark
Cover of the book Fast Track UML 2.0 by Philip Seamark
Cover of the book Digital Audio Editing Fundamentals by Philip Seamark
Cover of the book Learn Unity for Android Game Development by Philip Seamark
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy