Beginning DAX with Power BI
The SQL Pro's Guide to Better Business Intelligence
|Price||$25.03 - $39.99
|Format||Paper book / ebook (PDF)|
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.
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.
by Philip Seamark, Thomas Martens
Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft's leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Server Ana...
Price: $30.08 | Publisher: Apress | Release: 2019
by Steve Ivie
Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales an...
Price: $35.99 | Publisher: Packt Publishing | Release: 2015
by Neil Dunlop
In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft's Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps.While Beginni...
Price: $18.76 | Publisher: Apress | Release: 2015
by Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell
Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life.In this Learning Path, you will learn to create powerful interactive reports by visualizing...
Price: $49.99 | Publisher: Packt Publishing | Release: 2018
by Reza Rad
Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing a...
Price: $38.20 | Publisher: Apress | Release: 2018
by Marco Russo, Alberto Ferrari
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn...
Price: $43.99 | Publisher: Microsoft Press | Release: 2019
by Alberto Ferrari, Marco Russo
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It's meant for rea...
Price: $28.39 | Publisher: Microsoft Press | Release: 2017
by Dan Clark
Understanding your company's data has never been easier than with Microsoft's new Power BI package for Excel 2013. Consisting of four powerful tools - Power Pivot, Power View, Power Query and Power Maps - Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between Excel users...
Price: $5.98 | Publisher: Apress | Release: 2014