![]() ![]() Instead of simply describing listed functions and syntax and leaving you to guess when they should be applied, he illustrates their use so you can see the why as well as the what. Variables are linked with "context" early, as they're deeper ranging than they seem, and pave the way to summarising, aggregating and joining - seemingly obvious subjects but not when they're internal to a data model rather than just standalone queries. So it quickly extends the intro with confident walk-through's full of useful observations - no surprise because you'll often find Phil Seamark on the forums, answering questions to real problems. ![]() About the Authorĭon't be put off by "beginning" in the title - this comparatively slim book packs great value by focusing on the DAX you need to work real BI. Philip writes for the Power BI community site, and is a speaker at many industry events, Microsoft Ignite, Data Insights, Power BI User Groups, SQL Saturdays, and more. He is an experienced database and BI professional with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios. Philip Seamark, a Senior BI architect with Trade Me and a Microsoft Data Platform MVP with more than 25 years of commercial experience delivering business applications across multiple technologies. 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. Discover new ideas, tricks, and time-saving techniques for better modelsīusiness intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool.Optimize, monitor, and tune Power BI to improve performance of your models.Generate new tables on the fly from existing data.Know when to use calculated measures versus calculated columns.Turbocharge your Power BI model by adding advanced DAX programming techniques.Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. 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. 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.īeginning 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |