Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
Original price was: $49.99.$37.99Current price is: $37.99.
Price: [price_with_discount]
(as of [price_update_date] – Details)
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 in the PDF format.
Key FeaturesMaster the latest dashboarding and reporting features of Microsoft Power BICombine data from multiple sources, create stunning visualizations and publish Power BI apps to thousands of usersGet the most out of Microsoft Power BI with real-world use cases and examplesBook Description
Mastering Microsoft Power BI, Second Edition, provides an advanced understanding of Power BI to get the most out of your data and maximize business intelligence. This updated 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 will connect to data sources, shape and enhance source data, and develop analytical data models. You will 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. Furthermore, you will 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. Additionally, important management and administration topics are 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 will be confident in creating sustainable and impactful charts, tables, reports, and dashboards with any kind of data using Microsoft Power BI.
What you will learnBuild efficient data retrieval and transformation processes with the Power Query M language and dataflowsDesign scalable, user-friendly DirectQuery, import, and composite data modelsCreate basic and advanced DAX measuresAdd ArcGIS Maps to create interesting data storiesBuild pixel-perfect paginated reportsDiscover the capabilities of Power BI mobile applicationsManage and monitor a Power BI environment as a Power BI administratorScale up a Power BI solution for an enterprise via Power BI Premium capacityWho 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 ContentsPlanning Power BI ProjectsPreparing Data sourcesConnecting to Sources and Transforming Data with MDesigning Import, DirectQuery, and Composite Data ModelsDeveloping DAX Measures and Security RolesPlanning Power BI ReportsCreating and Formatting VisualizationsApplying Advanced AnalyticsDesigning DashboardsManaging Workspaces and ContentManaging the On-Premises Data GatewayDeploying Paginated ReportsCreating Power BI Apps and Content DistributionAdministering Power BI for an OrganizationBuilding Enterprise BI with Power BI Premium
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
Publisher : Packt Publishing; 2nd ed. edition (June 30, 2022)
Language : English
Paperback : 712 pages
ISBN-10 : 1801811482
ISBN-13 : 978-1801811484
Item Weight : 2.68 pounds
Dimensions : 9.25 x 7.52 x 1.46 inches
[ad_2]
J. Davis –
Excellent Book
Iâve been trying to learn power bi on Udemy, but it wasnât cutting it. This book really fills in the gaps.
Kristy –
My favorite Power BI book! Covers it all.
As a relatively new person to Power BI, I have several books. This one is by far my go to for information.I’ve become an accidental Power BI report builder/troubleshooter/administrator for our company in my growing list of BI duties. So at first I used this book for specific things as they came up – which it is great for. Right to the point, without unneeded fluff. Some examples: 1. ) Using M. We had a specific issue with an error message returning an indication that the problem was in an M query in one of our PBI RS reports. This area helped me get up to speed quickly on what I needed to know to troubleshoot this (previously had zero M experience). (Chapter 3: Connecting to sources and transforming data with M)2.) Row level security. We were setting up some new PBI apps where this was a requirement based on user’s role. This can be a little tricky and this helped us get it up and running quickly. (Chapter 5: Developing DAX Measures and Security Roles)3.) Gateways. Our gateway was already setup, but we had some troubleshooting and I needed to get my head wrapped around the concept .This chapter greatly helped with that. (Chapter 11: Managing the On-Premises Data Gateway)4.) Apps. As mentioned in #2, we were setting up new PBI Apps (some with external users). We also had reports that didn’t fall under our app requirements. Really great info here on how to set them up, explanation of them, content distribution, subscriptions options, and how to analyze in Excel.5.) Administering Power BI. Helped me with us setting up external users, thinking in the realm of data governance, and navigating the Admin portal. (Chapter 14: Administering Power BI for an Organization).6.) Paginated reports. We are moving some of our reports off of legacy systems (including SSRS) and one of the items we’ve been stuck at with PBI is paginated reports. There is an entire chapter on this that helped me work through issues our contractor was having with a current report and to give us a roadmap for planning our report system migration. (Chapter 12: Deploying Paginated Reports)Lots of other great stuff here. I really love the format and it is true to its title covering both development and administrating of Power BI. At over 600 pages, it bucks the new trend of books that seem a bit light. I really appreciate the initial chapter of Planning a Power BI project as it encourages you to take a step back and design with the users in mind, gives best practices for planning your overall setup, and sets the tone for the rest of the book. Lastly, I REALLY appreciate that the authors included information for both PBI Service and PBI Report Server. PBIRS seems to have a lack of information available out there, and this is the first book I’ve seen where it regular includes references to both.Highly recommended for both newbies and people that may have a lot of experience in one area of PBI, but need to expand their knowledge in other areas.
Kindle Customer –
Awesome reference book for Power BI developers!!
This book would be an excellent resource for someone focusing more on the back-end(Developer) and Administrative aspects of Power BI.It is very well organized, explaining start to finish the process of the development, creation, distribution, and maintaining the reports in the Tenant.I have worked in Power BI mostly as a report writer/author. The book would help me improve and get more of a technical background honing my development/admin skills.There are several pluses:Templates & practice files are provided to follow along.Using SQL and M to transform data.Nice review of the creation of DAX and MeasuresOne important thing to know is that you must have a Power BI license with tenant access to truly have an interactive experience with the book.I would highly recommend this book to any of my colleagues and friends who want to learn more in depth technical knowledge of Power BI.
Stan Bice –
Highly recommended book on Power BI
This is the most complete book on Power BI that I have read. The book is very detailed and digs deep into the concepts and patterns to be an effective Power BI developer and data analyst.The section in the book on the Power BI licenses is very well written and complete. Licensing Power BI is not a straight-forward topic. The use of written text, diagrams, and scenarios will really help the reader understand and determine their licensing needs. The authors explain the differences of shared and dedicated capacity and how that impacts the implementation costs and deployment of Power BI.The authors did a great job on using the data profiling capabilities within Power BI. Data profiling is a feature that keeps you within the Power BI application to analyze data and not needing to know how to query data from a SQL data source.Another topic that is necessary to understand is preparing, connecting and transforming the data from various data sources. The book is successful in completely explaining how data sources are implemented in a Power BI solution. Choosing and using the best storage modes is explained very well. The book covers the various storage modes and which ones to utilize based on your data sources.I was very impressed with the level of depth using the Power Query M language. There were several implementation tips that I learned for the first time. I felt that I learned so much more on the Power Query M language when reading the book. The authors did not just explain and show how to use the Power BI user interface, but they successfully showed examples for writing and editing Power Query M code, from beginning and advanced capabilities.I also found the Power Query M language topics of incremental data refreshes, using parameters, and implementing functions and keywords to be complete and go very deep. Using third-party tools and extensions to create Power BI solutions faster and more efficient was very impressive, as well. These topics will really help readers understand and confidently implement the learning.I was very impressed by how the authors explain how to access and import the data. This book really digs deep into the features and capabilities of Power BI on integrating and implementing a solution. The book included features that I have not previously seen. The content is very detailed and very-well written.I strongly recommend this book as required reading to learn and effectively use the features that Power BI provides. This would be a great addition to data analysts and Power BI users of all knowledge levels. There is plenty to read and learn.
Amazon Customer –
Super informative.
Ribeiro –
Book to support future tutoring on Power BI. Great book for starters and advanced users.
Sarabjit –
Book having very useful contact, good to learnBut screen shot are blurBook binding if poor u can see as compared to other. Book the book binding is not upto the mark
cameron robinson –
The book does what it says helps you master PowerBI however it arrived in a normal amazing box (not a problem) however the book is damaged, its edges are marked uplifted and dented⦠kind of disappointing for the book that I looked forward to being damaged when it got here. I donât believe it was the courier either as they seemed to care for my package instead of throwing it..
Amazon Customer –
Very much disappointed with the black and white picture edition. How visualization can be seen in grey scale. Nearly the cost of book is 2k+