Key Features
<ul>
<li>From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all</li>
<li>Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications</li>
<li>Proven development techniques and guidance for implementing custom solutions with DAX and M languages</li>
</ul>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<ul>
<li>Cleanse, stage, and integrate your data sources with Power BI</li>
<li>Abstract data complexities and provide users with intuitive, self-service BI capabilities</li>
<li>Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations</li>
<li>Take advantage of the analytics and predictive capabilities of Power BI</li>
<li>Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security</li>
<li>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</li>
<li>Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution</li>
</ul>About the AuthorBrett 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 SQL Server 2008R2 PowerPivot add-in for Excel 2010. He has contributed to the design and development of Microsoft and Power BI solutions of diverse scale and complexity across the retail, manufacturing, financial, and services industries. Brett regularly blogs and shares technical papers regarding the latest MSBI and Power BI features and development techniques and patterns at Insight Quest. He is also an organizer of the Boston BI User Group.Table of Contents<ol>
<li>Configuring Your Power BI Development Tools</li>
<li>Accessing and Retrieving Data</li>
<li>Building a Power BI Data Model</li>
<li>Authoring Power BI Reports</li>
<li>Creating Power BI Dashboards</li>
<li>Getting Serious with Date Intelligence</li>
<li>Parameterizing Your Power BI Solutions</li>
<li>Implementing Dynamic User-Based Visibility in Power BI</li>
<li>Applying Advanced Analytics and Custom Visuals</li>
<li>Developing Solutions for System Monitoring and Administration</li>
<li>Enhancing and Optimizing Existing Power BI Solutions</li>
<li>Deploying and Distributing Power BI Content</li>
<li>Integrating Power BI with other Applications</li>
</ol>

Microsoft Power BI Cookbook: Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards

Computers & Technology

Powell, Brett

Software

Packt Publishing

Design, create and manage robust Power BI solutions to gain meaningful business insightsKey Features<ul>
<li>Master all the dashboarding and reporting features of Microsoft Power BI</li>
<li>Combine data from multiple sources, create stunning visualizations and publish your reports across multiple platforms</li>
<li>A comprehensive guide with real-world use cases and examples demonstrating how you can get the best out of Microsoft Power BI</li>
</ul>Book DescriptionThis book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization.
BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. 
BI managers will learn how Power BI's tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed.
By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft PowerBI.What you will learn<ul>
<li>Build efficient data retrieval and transformation processes with the Power Query M Language</li>
<li>Design scalable, user-friendly DirectQuery and Import Data Models</li>
<li>Develop visually rich, immersive, and interactive reports and dashboards</li>
<li>Maintain version control and stage deployments across development, test, and production environments</li>
<li>Manage and monitor the Power BI Service and the On-premises data gateway</li>
<li>Develop a fully on-premise solution with the Power BI Report Server</li>
<li>Scale up a Power BI solution via Power BI Premium capacity and migration to Azure Analysis Services or SQL Server Analysis Services</li>
</ul>Who This Book Is ForBusiness Intelligence professionals and existing Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book to be useful. While understanding of the basic BI concepts is required, some exposure to Microsoft Power BI will be helpful.Table of Contents<ol>
<li>Planning Power BI Projects</li>
<li>Connecting to Sources and Transforming Data with M</li>
<li>Designing Import and DirectQuery Data Models</li>
<li>Developing DAX Measures and Security Roles</li>
<li>Creating and Formatting Power BI Reports</li>
<li>Integrating Custom Visuals, Animation and Analytics into Power BI Reports</li>
<li>Designing Power BI Dashboards and Multi-Dashboard Architectures</li>
<li>Managing Application Workspaces and Power BI Content</li>
<li>Managing the On-Premises Data Gateway and Data Refresh Configurations</li>
<li>Deploying Power BI On-Premises with the Power BI Report Server</li>
<li>Creating Power BI Apps and Content Distribution</li>
<li>Administering Power BI for an Organization</li>
<li>Scaling Up with Power BI Premium and SQL Server Analysis Services</li>
</ol>

Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence

Design, develop, and master efficient Power BI solutions for impactful business insights Key Features <ul>
<li>Get to grips with the fundamentals of Microsoft Power BI </li> <li>Combine data from multiple sources, create visuals, and publish reports across platforms </li> <li>Understand Power BI concepts with real-world use cases </li> </ul> Book Description 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 your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: <ul>
<li>Microsoft Power BI Quick Start Guide by Devin Knight et al. </li> <li>Mastering Microsoft Power BI by Brett Powell </li> </ul> What you will learn <ul>
<li>Connect to data sources using both import and DirectQuery options </li> <li>Leverage built-in and custom visuals to design effective reports </li> <li>Administer a Power BI cloud tenant for your organization </li> <li>Deploy your Power BI Desktop files into the Power BI Report Server </li> <li>Build efficient data retrieval and transformation processes</li>
</ul> Who this book is for Microsoft Power BI Complete Reference Guide is for those who want to learn and use the Power BI features to extract maximum information and make intelligent decisions that boost their business. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, then Learning Path is for you. It consists of real-world examples on Power BI and goes deep into the technical issues, covers additional protocols, and much more. Table of Contents <ol>
<li>Getting Started with Importing Data Options</li> <li>Data Transformation Strategies</li> <li>Building the Data Model</li> <li>Leveraging DAX</li> <li>Visualizing Data</li> <li>Using a Cloud Deployment with the Power BI Service</li> <li>Planning Power BI Projects</li> <li>Connecting to Sources and Transforming Data with M</li> <li>Designing Import and DirectQuery Data Models</li> <li>Developing DAX Measures and Security Roles</li> <li>Creating and Formatting Power BI Reports</li> <li>Applying Custom Visuals, Animation, and Analytics</li> <li>Designing Power BI Dashboards and Architectures</li> <li>Managing Application Workspaces and Content</li> <li>Managing the On-Premises Data Gateway</li> <li>Deploying the Power BI Report Server</li> <li>Creating Power BI Apps and Content Distribution</li> <li>Administering Power BI for an Organization</li> <li>Scaling with Premium and Analysis Services</li>
</ol>

Microsoft Power BI Complete Reference: Bring your data to life with the powerful features of Microsoft Power BI

Knight, Brian

Knight, Devin

Pearson, Mitchell

Quintana, Manuel

Review\n"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\n"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)\n"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\nPlan, 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 in the PDF format. Key Features Mas

Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition

Deckler, Greg

Computer Science

Build effective analytical data models, reports, and dashboards using the advanced features of Power BI <h4>Key Features</h4> <ul> <li>Updated with new recipes on query optimization, aggregation tables, Power BI API, and paginated reports</li> <li>Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications</li> <li>Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques</li> </ul> <h4>Book Description</h4> Microsoft Power BI is a leading business intelligence and data analytics platform that provides tools and services for deriving insights from data. With revised practical recipes, Microsoft Power BI Cookbook, Second Edition helps you navigate Power BI tools and their advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. This cookbook provides advanced design and development tips, and guidance on enhancing existing Power BI projects. The updated edition enables you to implement evergreen frameworks that will stay relevant as Power BI updates. Get familiar with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. Microsoft Power BI Cookbook, Second Edition enables Power BI's functional programming languages of DAX and M to come alive and deliver powerful solutions to common business intelligence challenges. <h4>What you will learn</h4> <ul> <li>Cleanse, stage, and integrate your data sources with Power Query (M)</li> <li>Remove data complexities and provide users with intuitive, self-service BI capabilities</li> <li>Build business logic and analysis into your solutions via the DAX programming language and dashboard-ready calculations</li> <li>Implement aggregation tables to accelerate query performance over large data sources</li> <li>Create and integrate paginated reports</li> <li>Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets</li> <li>Integrate other Microsoft data tools into your Power BI solution</li> </ul> <h4>Who this book is for</h4> This book is for BI professionals who wish to enhance their knowledge of Power BI and 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 an extremely useful resource. Familiarity with Power BI and working with datasets is essential. This book is not for beginners.

Microsoft Power BI Cookbook: Gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases

Microsoft Power BI Cookbook: Convert raw data into business insights with updated techniques, use cases, and best practices

Programming

Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence

See the best price to sell, buy, or rent books by Powell, Brett. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Powell, Brett