Mastering Microsoft Power BI

Key Features Master all the dashboarding and reporting features of Microsoft Power BI Combine data from multiple sources, create stunning visualisations and publish your reports across multiple platforms A comprehensive guide with real-world use-cases and examples demonstrating how you can get the best out of Microsoft Power BI Book Description Microsoft Power BI is a suite of Business Intelligence tools, designed to help the BI professionals get easier, quick and crucial business insights from their data. This book will demonstrate how you can efficiently use the various features of Power BI to gather insights and share them across your team. This book will be more tailored to medium and larger organisations from a corporate BI/IT perspective and will highlight the tools and services working together. The chapters logically build on each other from the beginning, planning a Power BI project, to building and distributing content all the way to administering and scaling up Power BI. Right from gathering data through various data sources, you will see how you can effectively use Power BI to analyse it. You will understand the steps involved in designing data models that support multiple related business processes to serve as a user friendly platform for analytics and visualization. You will be able to integrate MS Office store of custom visuals to meet specific report needs and build data storytelling and analytical capabilities into your Power BI reports. You will discover how you can create and manage an App Workspace in Power BI and assign administrators and data sources for gateways. You will also understand how you can share your reports securely across multiple platforms such as tablets, smartphones and on cloud, without worrying about customizing them. 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 Power BI. What you will learn Build efficient data retrieval and transformation processes with the M Query Language Design scalable, user-friendly DirectQuery and Import Data Models Develop visually rich, immersive and interactive reports and dashboards Maintain version control and stage deployments across development, test, and production environments Manage and monitor the Power BI Service and the On-Premises Data Gateway Develop a fully On-Premise Solution with the Power BI Report Server Scale up a Power BI Solution via Power BI Premium Capacity and Migration to SQL Server Analysis Services About the Author **Brett Powell** is a Microsoft BI consultant, owner of Frontline Analytics, LLC, a Microsoft Power BI Partner, author of the Microsoft Power BI Cookbook, and organizer of the Boston Business Intelligence User Group. Brett has worked with Power BI technologies since they were first introduced as the SQL Server 2008R2 PowerPivot add-in for Excel 2010 and has contributed to the design and development of Microsoft and Power BI solutions of diverse scale and complexity across retail, manufacturing, financial, and services industries. Brett regularly shares technical blog posts and papers regarding the latest MSBI and Power BI features and development techniques at his Insights Quest blog.