
Microsoft Power BI Cookbook
Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards
Brett Powell(Author)
Packt Publishing
Published on 27. September 2017
Book
Paperback/Softback
802 pages
978-1-78829-014-2 (ISBN)
Description
Publisher's note: This edition from 2017 is outdated and does not make use of the most recent Power BI updates. A new third edition, updated to the latest release is now available in color
Key Features
From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all
Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications
Proven development techniques and guidance for implementing custom solutions with DAX and M languages
Book DescriptionMicrosoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data.
This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence.
This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.What you will learn
Cleanse, stage, and integrate your data sources with Power BI
Abstract data complexities and provide users with intuitive, self-service BI capabilities
Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations
Take advantage of the analytics and predictive capabilities of Power BI
Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security
Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes
Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution
Who this book is forThis book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful.
Key Features
From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all
Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications
Proven development techniques and guidance for implementing custom solutions with DAX and M languages
Book DescriptionMicrosoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data.
This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence.
This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.What you will learn
Cleanse, stage, and integrate your data sources with Power BI
Abstract data complexities and provide users with intuitive, self-service BI capabilities
Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations
Take advantage of the analytics and predictive capabilities of Power BI
Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security
Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes
Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution
Who this book is forThis book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful.
More details
Language
English
Place of publication
Birmingham
United Kingdom
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 43 mm
Weight
1467 gr
ISBN-13
978-1-78829-014-2 (9781788290142)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions

Author Test | Brett Powell
Microsoft Power BI Cookbook
Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards
E-Book
06/2024
1st Edition
Packt Publishing Limited
€58.99
Available for download
Persons
Brett Powell is the owner of and business intelligence consultant at Frontline Analytics LLC, a data and analytics research and consulting firm and Microsoft Power BI partner. He has worked with Power BI technologies since they were first introduced as the PowerPivot add-in for Excel 2010 and has been a Power BI architect and lead BI consultant for organizations across the retail, manufacturing, and financial services industries. Additionally, Brett has led Boston's Power BI User Group, delivered presentations at technology events such as Power BI World Tour, and maintains the popular Insight Quest Microsoft BI blog.
Content
Table of Contents
Configuring Your Power BI Development Tools
Accessing and Retrieving Data
Building a Power BI Data Model
Authoring Power BI Reports
Creating Power BI Dashboards
Getting Serious with Date Intelligence
Parameterizing Your Power BI Solutions
Implementing Dynamic User-Based Visibility in Power BI
Applying Advanced Analytics and Custom Visuals
Developing Solutions for System Monitoring and Administration
Enhancing and Optimizing Existing Power BI Solutions
Deploying and Distributing Power BI Content
Integrating Power BI with other Applications
Configuring Your Power BI Development Tools
Accessing and Retrieving Data
Building a Power BI Data Model
Authoring Power BI Reports
Creating Power BI Dashboards
Getting Serious with Date Intelligence
Parameterizing Your Power BI Solutions
Implementing Dynamic User-Based Visibility in Power BI
Applying Advanced Analytics and Custom Visuals
Developing Solutions for System Monitoring and Administration
Enhancing and Optimizing Existing Power BI Solutions
Deploying and Distributing Power BI Content
Integrating Power BI with other Applications