Buy New
-
To see product details, add this item to your cart.
Ships from: Amazon.com Sold by: Amazon.com
Used - Good
-
To see product details, add this item to your cart.
Ships from: ThriftBooks-Phoenix Sold by: ThriftBooks-Phoenix
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
Purchase options and add-ons
Plan, design, develop, and manage robust Power BI solutions to generate meaningful insights and make data-driven decisions
Purchase of the print or Kindle book includes a free eBook PDF
Key Features
- Master the latest dashboarding and reporting features of Microsoft Power BI
- Combine data from multiple sources, create stunning visualizations and publish Power BI apps to thousands of users
- Get the most out of Microsoft Power BI with real-world use cases and examples
Book Description
Mastering Microsoft Power BI, Second Edition, provides you with an advanced understanding of Power BI to allow you to get the most out of your data and maximize business intelligence. This updated second edition walks through each essential phase and component of Power BI, and explores the latest, most impactful Power BI features.
Using best practices and working code examples, you'll connect to data sources, shape and enhance source data, and develop analytical data models. You'll also learn how to apply custom visuals, implement new DAX commands and paginated SSRS-style reports, manage application workspaces and metadata, and understand how content can be staged and securely distributed via Power BI apps. In addition to this, you'll explore top report and interactive dashboard design practices using features such as bookmarks and the Power KPI visual, alongside the latest capabilities of Power BI mobile applications and self-service BI techniques. Important management and administration topics are also covered, including application lifecycle management via Power BI pipelines, the on-premises data gateway, and Power BI Premium capacity.
By the end of this Power BI book, you'll be confident in creating sustainable and impactful charts, tables, reports, and dashboards with any kind of data using Microsoft Power BI.
What you will learn
- Build efficient data retrieval and transformation processes with the Power Query M language and dataflows
- Design scalable, user-friendly DirectQuery, import, and composite data models
- Create basic and advanced DAX measures
- Add ArcGIS Maps to create interesting data stories
- Build pixel-perfect paginated reports
- Discover the capabilities of Power BI mobile applications
- Manage and monitor a Power BI environment as a Power BI administrator
- Scale up a Power BI solution for an enterprise via Power BI Premium capacity
Who this book is for
Business Intelligence professionals and intermediate Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book useful. An understanding of basic BI concepts is required and some familiarity with Microsoft Power BI will be helpful to make the most out of this book.
Table of Contents
- Planning Power BI Projects
- Preparing Data sources
- Connecting to Sources and Transforming Data with M
- Designing Import, DirectQuery, and Composite Data Models
- Developing DAX Measures and Security Roles
- Planning Power BI Reports
- Creating and Formatting Visualizations
- Applying Advanced Analytics
- Designing Dashboards
- Managing Workspaces and Content
- Managing the On-Premises Data Gateway
- Deploying Paginated Reports
- Creating Power BI Apps and Content Distribution
- Administering Power BI for an Organization
- Building Enterprise BI with Power BI Premium
- ISBN-101801811482
- ISBN-13978-1801811484
- Edition2nd ed.
- PublisherPackt Publishing
- Publication dateJune 30, 2022
- LanguageEnglish
- Dimensions7.5 x 1.61 x 9.25 inches
- Print length712 pages
Frequently bought together

Customers who viewed this item also viewed
- Learn Microsoft Power BI: A comprehensive, beginner-friendly guide to real-world business intelligencePaperbackFREE Shipping by AmazonGet it as soon as Tuesday, Sep 22
- Data Visualization with Microsoft Power BI: How to Design Savvy DashboardsPaperbackFREE Shipping by AmazonGet it as soon as Monday, Sep 21
- Microsoft Power BI For Dummies (For Dummies (Computer/Tech))PaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Monday, Sep 21
- The Definitive Guide to DAX: Mastering the semantic model expression language for Microsoft Power BI, Fabric, and Excel (Business Skills)PaperbackFREE Shipping by AmazonGet it as soon as Monday, Sep 21
- The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)PaperbackFREE Shipping by AmazonGet it as soon as Monday, Sep 21
Customers also bought or read
- The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Paperback$49.93$49.93FREE delivery Mon, Sep 21 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Mon, Sep 21 - Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence
Paperback$71.88$71.88FREE delivery Tue, Sep 22 - Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more
Paperback$30.32$30.32Delivery Tue, Sep 22 - Learn Microsoft Power BI: A comprehensive, beginner-friendly guide to real-world business intelligence
Paperback$44.99$44.99FREE delivery Tue, Sep 22 - Workflow Automation with Microsoft Power Automate: Use business process automation to achieve digital transformation with minimal code
Paperback$33.42$33.42Delivery Tue, Sep 22 - Learn Microsoft Power Apps: The definitive handbook for building solutions with Power Apps to solve your business needs
Paperback$29.99$29.99Delivery Tue, Sep 22 - Microsoft Power BI Cookbook: Convert raw data into business insights with updated techniques, use cases, and best practices
Paperback$37.98$37.98FREE delivery Tue, Sep 22 - Power BI for Beginners: A Step-by-Step Guide to Mastering Power BI and Advancing Your Career
Paperback$19.99$19.99Delivery Tue, Sep 22 - Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level
Paperback$43.20$43.20FREE delivery Thu, Sep 24 - Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation
Paperback$21.26$21.26Delivery Tue, Sep 22 - Extending Power BI with Python and R: Perform advanced analysis using the power of analytical languages
Paperback$36.20$36.20FREE delivery Tue, Sep 22 - Learning Microsoft Power BI: Transforming Data into Insights
Paperback$37.72$37.72FREE delivery Mon, Sep 21 - Microsoft Power Apps Cookbook: Build user-friendly apps, troubleshoot challenges, and navigate the evolving Power Apps landscape
Paperback$34.99$34.99Delivery Tue, Sep 22 - Microsoft Power BI For Dummies (For Dummies (Computer/Tech))
Paperback$27.99$27.99Delivery Mon, Sep 21 - Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
Paperback$25.45$25.45Delivery Tue, Sep 22 - Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas
Paperback$31.22$31.22Delivery Tue, Sep 22 - Supercharge Power BI: Power BI is Better When You Learn To Write DAX
Paperback$20.59$20.59Delivery Tue, Sep 22 - Microsoft Power BI Quick Start Guide: Bring your data to life through data modeling, visualization, digital storytelling, and more, 2nd Edition
Paperback$58.41$58.41FREE delivery Tue, Sep 22 - Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)
Paperback$40.73$40.73FREE delivery Oct 1 - 6 - Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365) (Business Skills)
Paperback$43.41$43.41FREE delivery Sep 23 - 28 - Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
Paperback$24.50$24.50Delivery Mon, Sep 21 - Power BI for Beginners: The 7-Day Method to Build Dashboards and Become a Data Strategist (Video Course Included)
Paperback$19.95$19.95Delivery Tue, Sep 22 - Power BI for the Excel Analyst: Your Essential Guide to Power BI
Paperback$33.34$33.34Delivery Tue, Sep 22
From the Publisher
What are the key topics from your book?
- A guide to mastering expert techniques and the full capabilities of Power BI for effective data analytics and business intelligence
- Details dashboarding and reporting features of Microsoft Power BI
- Explores how to combine data from multiple sources, develop visualizations, and publish reports across multiple platforms to support business analysis
- Discusses implementation and real-world use cases to explain how to get the best out of Microsoft Power BI
An interview with Gregg Deckler and Brett Powell
How does your book differ from other books on Microsoft Power BI?
Most Power BI books tend to focus on a single topic, such as DAX or Power Query. Many others are geared toward the novice Power BI user or cover how to perform tasks, but not when or why to use them. This book has a holistic, real-world approach to the implementation of Power BI as an enterprise business intelligence platform that other books lack.
What’s new in this edition?
- Most impactful features and enhancements since the first edition, such as composite models, aggregation tables, incremental refresh, deployment pipelines, paginated reports, Power Automate, and more
- Covers new BI licensing and administrative features
- Covers what were previously distinct enterprise BI tools in the first edition, such as Analysis Services and SQL Server Reporting Service
What kind of readership is this edition best suited for?
Like the first edition, the second edition contains content relevant to several personas in Power BI, ranging from report authors and BI developers to BI managers and architects.
What things should a reader consider when using Microsoft Power BI within their own organizations and practices?
It is important to take a holistic approach to the deployment of Power BI within an organization. Similarly, it is important to maintain a disciplined approach to Power BI projects. By keeping the big picture in mind and being systematic, the overall implementation is made efficient, effective, and provides the most value to the enterprise.
What are the key takeaways from your book?
- The different roles in Power BI projects
- The different tools Power BI developers and administrators utilize in their roles
- The latest features and recommended practices related to Power BI roles
- Planning and designing a model to take advantage of new dataset features such as composite models
- Real-world planning aspects of implementation
- Creating Power BI reports, dashboards, scorecards, Excel reports, and paginated reports
Learn Microsoft Power BI
|
Mastering Microsoft Power BI: Expert techniques to create interactive insight...
|
Microsoft Power BI Cookbook: Convert raw data into business insights with upd...
|
Expert Data Modeling with Power BI - Second Edition: Enrich and optimize your...
|
Data Governance Handbook: A practical approach to building trust in data
|
|
|---|---|---|---|---|---|
| Customer Reviews |
4.3 out of 5 stars 44
|
4.3 out of 5 stars 202
|
4.0 out of 5 stars 40
|
4.8 out of 5 stars 101
|
3.9 out of 5 stars 32
|
| Technology Used | Microsoft Power BI, Fabric, Copilot | Microsoft Power BI | Microsoft Power BI | Microsoft Power BI, DAX, Power Query | Data governance frameworks, metadata, data lineage, quality, architecture, operations, and automation |
| Reader Knowledge Level | Beginner | Intermediate | Intermediate to Advanced | Intermediate to Advanced | Basic understanding of data and business needs |
| Description | Learn quickly with real-world examples to build insightful dashboards and turn raw data into actionable business intelligence | Get the most out of Microsoft Power BI with real-world use cases and examples | Unlock the full potential of Power BI with recipes and techniques on advanced data tools and AI | Learn advanced data modeling techniques to make the most of Power BI | Covers data governance strategies, business alignment, and real-world execution for data professionals and leaders |
Editorial Reviews
Review
"This book provides an end-to-end analysis of Power BI tools and features, from planning a Power BI project to distributing Power BI apps to large groups of users. You will be familiarized with all the fundamental concepts and see how Power BI datasets, reports, and dashboards can be designed to deliver insights and rich interactive experiences [...]. I highly recommend this book to any new or existing Power BI users who want to learn what features and functionalities Power BI provides, as well as how they can quickly take advantage of their data."
--Leon Gordon, Thought Leader at Forbes Technical Council, Microsoft Data Platform MVP, and Partner at Pomerol Partners
"Greg and Brett wrote this book with a very interesting premise, to deepen Power BI knowledge at every step of the development process. In this book, you will see application cases and examples that are used on a daily basis, at a basic, intermediate, and advanced level. I recommend that you take a look because you will learn new things. Without any doubt, with this book, no matter your level, you'll improve your knowledge on each feature of Power BI."
--Luca Piattelli, Business Intelligence Project Manager and Professor, and Power BI Summit 2022 Speaker (Power BI español virtual conf)
"Thanks to the authors, Greg and Brett, for another excellent Power BI book from Packt. The beauty of this book is that it covers complete end-to-end concepts in Power BI, with great examples and screenshots to enhance the reading experience. This is a one-stop solution for any Power BI scenarios."
-- Hariharan Rajendran, Microsoft MVP (Data Platform), Microsoft Certified Trainer, and Senior BI Architect.
"I really enjoyed reading this book. A great go-to resource for professionals learning topics, such as data preparation, modeling, report creation, and analytics enrichment, as well as a source for advanced tips, and chapters for well-rounded professionals planning Power BI projects, architecture, environment and artifact management, and tenant settings for full-scale enterprise deployment."
-- Pedro Reis, Microsoft Data Platform MVP, Leader of the Power BI Portugal community
"This book, written by two well respected and expert authors in the Power BI community, provides in-depth coverage from fundamental concepts to the latest Power BI tools and features. Whether you are a Power BI architect, admin, PM, manager, or a designer/developer, you will find this book is a handy reference guide to concepts, features, and techniques to enhance your role's deliverables. It's a must read book for any Power BI professional who wants to take their Power BI knowledge to the next level."
-- Ashraf Ghonaim, Strategic Management and Analytics Consultant, Microsoft Data Platform MVP
"As someone who works with Power BI on a daily basis, I still find it challenging to understand every area of the Power BI solution. Considering the breadth of the platform, it's hard to be a "master of everything," but this book gives you an overview of almost all concepts relevant to Power BI. I'd recommend this book as a learning resource and a reference guide, as it provides you with a good starting point to explore further and understand concepts and features in the Power BI ecosystem."
-- Nikola Ilic, Data Mozart and Microsoft Data Platform MVP
"It's wonderful how the authors give their view on Corporate BI vs Self Service BI, accounting for considerations like having a central enterprise model versus having people build their own dashboards, while also maintaining reliability. However, where the book really impressed me is in how to manage workspaces and distribute your content."
--Rick De Groot, Data Platform MVP - Blogger behind 'BI Gorilla' - Power BI Consultant
About the Author
Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and the Dynamic Communities User Group/Power Platform Summit.
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.
Product details
- Publisher : Packt Publishing
- Publication date : June 30, 2022
- Edition : 2nd ed.
- Language : English
- Print length : 712 pages
- ISBN-10 : 1801811482
- ISBN-13 : 978-1801811484
- Item Weight : 2.88 pounds
- Dimensions : 7.5 x 1.61 x 9.25 inches
- Best Sellers Rank: #400,868 in Books (See Top 100 in Books)
- #15 in Microsoft SQL Server
- #27 in Presentation Software Books
- #93 in Business Intelligence Tools
- Customer Reviews:
About the authors

I am a Vice President at a global consulting services firm. In addition, I am a 7-time Microsoft MVP for Data Platform. As an active member in the Columbus IT community, I founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and have presented at many different conferences and events including Dog Food, SharePoint Saturday, CloudDevelop and M3. I am also the author of Microsoft Hates Greg's Quick Measures (MSHGQM) tool and the associated YouTube channels Microsoft Hates Greg and DAX For Humans.

I own and operate Frontline Analytics, a data and analytics consulting firm focused on Microsoft business intelligence solution design and development. In 2017 I wrote the Microsoft Power BI Cookbook and in early 2018 I completed my second book, Mastering Microsoft Power BI.
The Power BI Cookbook is a large collection of design and development techniques to derive greater value from Power BI and its related technologies including the DAX and M programming languages. Mastering Microsoft Power BI provides an end-to-end overview of Power BI including project planning, content development, distribution, and administration. Additionally, I'm the co-organizer of the Boston Business Intelligence User Group and I regularly post technical articles on my blog, Insight Quest.


















