The Absolute Guide to Dashboarding and Reporting with Power BI, 2nd Edition
- Length: 156 pages
- Edition: 2
- Language: English
- Publisher: Holy Macro! Books
- Publication Date: 2019-03-01
- ISBN-10: 1615470573
- ISBN-13: 9781615470570
- Sales Rank: #986399 (See Top 100 Books)
Written by a member of Microsoft’s Power BI team, this book provides a practical step by step guide on creating a financial dashboard using Power BI desktop and the PowerBI.com service.
The book contains 6 chapters:
- Introduction. Here I introduce the book, business intelligence and provide some history on Power BI
- Understanding Dashboards and Report. Here we talk about what dashboards and reports are and how they are used in Power BI. Finally we talk about how to decide what to put on your reports and dashboards.
- Collecting and preparing data. Here we install Power BI desktop, import data into Power BI and do some mashup using Power Query. We also discuss data modelling tips and tricks and start with some DAX (can’t have a book without DAX right :)).
- Building the main report. Here we will create the main report in Power BI Desktop, using the data model he set up in Chapter 3. We create various data visualizations needed for his report (and talk about which visualization to use when).
- Building detailed reports. Here we dive into more detailed report building with more DAX examples, sync slicer, custom visuals defining crossfiltering.
- Sharing dashboards and reports within and organization. In this Chapter we are going to upload our report to PowerBI.com and collaborate with others on our solution using workspaces. Finally we will distribute it to the users in our organization with Apps.
After following all these steps it will provide a full end to end overview to build a financial dashboards, including downloads for all the steps and samples.
Title page Data Model Tip: Applied Steps and Script View Data Model Tip: BLANK Values? Data Model Tip: Comments Data Model Tip: Creating and Managing Measures Data Model Tip: Data Types Data Model Tip: DAX Expressions Data Model Tip: DAX vs. M Data Model Tip: Editing a Query Data Model Tip: Filter Context and CALCULATE Data Model Tip: Formatting Measures Data Model Tip: Import vs. DirectQuery Data Model Tip: Making a Template of Your Measures Data Model Tip: Query Editor Formulas Data Model Tip: Remembering That Context Is Always Applied Data Model Tip: Supported Data Sources Data Model Tip: The Data Model Data Model Tip: The DIVIDE Function Data Model Tip: The Time Intelligence Functions Data Model Tip: The VALUES Function Data Model Tip: Understanding How Time Intelligence Functions Work Data Model Tip: Variables Power BI Desktop Tip: Bookmarks Power BI Desktop Tip: Choosing a Version Power BI Desktop Tip: Drillthrough Filters Power BI Desktop Tip: Enabling Sync Slicers Power BI Desktop Tip: Power BI Desktop vs. Excel Power BI Desktop Tip: Preview Features Power BI Tip: Cross-Filtering Data Power BI Tip: Doing Short Iterations and Getting Feedback Often Power BI Tip: Editing in the Browser Power BI Tip: How Does Data Refresh Work? Power BI Tip: Integration with Other Products Power BI Tip: Power BI Apps Power BI Tip: Power BI Q&A Power BI Tip: Publishing Reports Power BI Tip: Reports vs. Dashboards in Power BI Power BI Tip: Slicers Power BI Tip: The Power BI Admin Portal Power BI Tip: The Power BI Dashboard Power BI Tip: The Power BI Home Screen Power BI Tip: Updating Apps Power BI Tip: Using Custom Visuals Power BI Tip: Workspace Access Power BI Tip: Workspaces Preview Visualization Tip: Bringing Attention Where Attention Is Warranted: KPIs Visualization Tip: Choosing the Right Calculation Visualization Tip: Choosing the Right Chart Visualization Tip: Choosing the Right Colors for a Dashboard Visualization Tip: Choosing the Right Precision Visualization Tip: Designing a Clean Report Visualization Tip: Keeping Space Around the Edges Visualization Tip: Labeling Appropriately Visualization Tip: Understanding Sparklines Visualization Tip: Using Fonts Visualization Tip: Using Maps Preface Acknowledgments 1 - Introduction 2 - Understanding Dashboards and Reports 3 - Collecting and Preparing the Data 4 - Building the Main Report 5 - Building Detailed Reports 6 - Sharing Dashboards and Reports Within an Organization Index
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.