Learning Microsoft Power BI: Transforming Data into Insights

Description

Microsoft Power BI is a data analytics and visualization tool powerful enough for the most demanding data scientists, but accessible enough for everyday use for anyone who needs to get more from data. The market has many books designed to train and equip professional data analysts to use Power BI, but few of them make this tool accessible to anyone who wants to get up to speed on their own. This streamlined intro to Power BI covers all the foundational aspects and features you need to go from "zero to hero" with data and visualizations. Whether you work with large, complex datasets or work in Microsoft Excel, author Jeremey Arnold shows you how to teach yourself Power BI and use it confidently as a regular data analysis and reporting tool. You'll learn how to: Import, manipulate, visualize, and investigate data in Power BI Approach solutions for both self-service and enterprise BI Use Power BI in your organization's business intelligence strategy Produce effective reports and dashboards Create environments for sharing reports and managing data access with your team Determine the right solution for using Power BI offerings based on size, security, and computational needs 1. Introduction to Power BI What is Power BI? Power BI Components Power BI Desktop The Power BI Service The Power Platform How Did We Get to Power BI? SQL Server: Microsoft’s Relational Database SQL Server Analysis Services Multidimensional: One Small Step into BI SQL Server Reporting Services: Pixel-Perfect Reporting, Automated Reports, and More Excel: A Self-Service BI Tool Power Pivot Important New Functionality that Leads to Power BI Power BI Desktop is Born Power BI Desktop Under the Hood VertiPaq: The Storage Engine What Makes Power BI Different from its Competitors? Why Power BI, and Examples of Its Use Across the Globe Summary 2. The User Interface I: Report and Data Views Report View: Home Section of the Ribbon The Clipboard Subsection The Data Subsection The Clipboard Subsection The Insert Subsection The Calculations Subsection The Final Subsections: Sensitivity and Share Report View: The Insert Tab The Pages Subsection The Visuals Subsection The AI Visuals Subsection The Power Platform Subsection The Elements Subsection Report View: The Modeling Tab The Relationships Subsection The Calculations Subsection The Page Refresh Subsection The What If Subsection The Security Subsection The Q&A Subsection Report View: The View Tab The Themes Subsection The Scale to Fit Subsection The Page Options Subsection The Show Panes Subsection Report View: Help Section The Community Subsection Report View: External Tools Section The Pane Interface of the Report View Visualizations Pane Fields and Filters Panes A Quick Rundown of the Other Panes Data View Table and Column Tools Summary