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

Key FeaturesFrom connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it allOver 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile ApplicationsProven development techniques and guidance for implementing custom solutions with DAX and M languagesBook 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 learnCleanse, stage, and integrate your data sources with Power BIAbstract data complexities and provide users with intuitive, self-service BI capabilitiesBuild business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculationsTake advantage of the analytics and predictive capabilities of Power BIMake your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level securityUnderstand 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 refreshesIntegrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solutionAbout 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 ContentsConfiguring Your Power BI Development ToolsAccessing and Retrieving DataBuilding a Power BI Data ModelAuthoring Power BI ReportsCreating Power BI DashboardsGetting Serious with Date IntelligenceParameterizing Your Power BI SolutionsImplementing Dynamic User-Based Visibility in Power BIApplying Advanced Analytics and Custom VisualsDeveloping Solutions for System Monitoring and AdministrationEnhancing and Optimizing Existing Power BI SolutionsDeploying and Distributing Power BI ContentIntegrating Power BI with other Applications