Title: Beginning DAX with Power BI: The SQL Pro?s Guide to Better Business Intelligence
Publisher: Apress
Publication Date: 2018
Language: English
ISBN 10: 1484234766
ISBN 13: 9781484234761
Binding: paperback
Condition: Very Good
Weight: 18 ounces

About this title

Synopsis

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.

About the Author

Philip Seamark is an experienced Data Warehouse and BI Consultant with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. He is recognized for his analytical, conceptual, and problem-solving abilities with more than 25 years of commercial experience delivering business applications across a broad range of technologies. His expertise runs the gamut from project management, dimensional modeling, performance tuning, ETL design, development and optimization, report and dashboard design to installation and administration.

In 2017 he received a Microsoft Data Platform MVP award due to his contributions to the PowerBI community site, as well as speaking at many data, analytic, and reporting events around the world. Philip is also the founder and organizer of the Wellington Power BI User Group.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Sale & Shipping Terms

Terms of Sale

We guarantee the condition of every book as it's described on the AbeBooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days. This does not affect your statutory consumer rights includ...

More Information

Shipping Terms

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 14 business days	3 to 6 business days
First item	US$ 5.50	US$ 18.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.