Mastering Microsoft Power BI

內容描述

Key FeaturesMaster all the dashboarding and reporting features of Microsoft Power BICombine data from multiple sources, create stunning visualisations and publish your reports across multiple platformsA comprehensive guide with real-world use-cases and examples demonstrating how you can get the best out of Microsoft Power BIBook DescriptionMicrosoft 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 learnBuild efficient data retrieval and transformation processes with the M Query LanguageDesign scalable, user-friendly DirectQuery and Import Data ModelsDevelop visually rich, immersive and interactive reports and dashboardsMaintain version control and stage deployments across development, test, and production environmentsManage and monitor the Power BI Service and the On-Premises Data GatewayDevelop a fully On-Premise Solution with the Power BI Report ServerScale up a Power BI Solution via Power BI Premium Capacity and Migration to SQL Server Analysis Services