The Absolute Guide to Dashboarding and Reporting with Power BI
eBook - PDF

The Absolute Guide to Dashboarding and Reporting with Power BI

How to Design and Create a Financial Dashboard with Power BI – End to End

  1. 163 pages
  2. English
  3. PDF
  4. Available on iOS & Android
eBook - PDF

The Absolute Guide to Dashboarding and Reporting with Power BI

How to Design and Create a Financial Dashboard with Power BI – End to End

About this book

Written by a member of Microsoft's Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access The Absolute Guide to Dashboarding and Reporting with Power BI by Kasper de Jonge in PDF and/or ePUB format, as well as other popular books in Business & Business Intelligence. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Holy Macro! Books
Year
2018
eBook ISBN
9781615472406
Edition
0
Topic
Business
Subtopic
Business Intelligence
Index
Business

Table of contents

  1. Title page
  2. Data Model Tip: Applied Steps and Script View
  3. Data Model Tip: BLANK Values?
  4. Data Model Tip: Comments
  5. Data Model Tip: Creating and Managing Measures
  6. Data Model Tip: Data Types
  7. Data Model Tip: DAX Expressions
  8. Data Model Tip: DAX vs. M
  9. Data Model Tip: Editing a Query
  10. Data Model Tip: Filter Context and CALCULATE
  11. Data Model Tip: Formatting Measures
  12. Data Model Tip: Import vs. DirectQuery
  13. Data Model Tip: Making a Template of Your Measures
  14. Data Model Tip: Query Editor Formulas
  15. Data Model Tip: Remembering That Context Is Always Applied
  16. Data Model Tip: Supported Data Sources
  17. Data Model Tip: The Data Model
  18. Data Model Tip: The DIVIDE Function
  19. Data Model Tip: The Time Intelligence Functions
  20. Data Model Tip: The VALUES Function
  21. Data Model Tip: Understanding How Time Intelligence Functions Work
  22. Data Model Tip: Variables
  23. Power BI Desktop Tip: Bookmarks
  24. Power BI Desktop Tip: Choosing a Version
  25. Power BI Desktop Tip: Drillthrough Filters
  26. Power BI Desktop Tip: Enabling Sync Slicers
  27. Power BI Desktop Tip: Power BI Desktop vs. Excel
  28. Power BI Desktop Tip: Preview Features
  29. Power BI Tip: Cross-Filtering Data
  30. Power BI Tip: Doing Short Iterations and Getting Feedback Often
  31. Power BI Tip: Editing in the Browser
  32. Power BI Tip: How Does Data Refresh Work?
  33. Power BI Tip: Integration with Other Products
  34. Power BI Tip: Power BI Apps
  35. Power BI Tip: Power BI Q&A
  36. Power BI Tip: Publishing Reports
  37. Power BI Tip: Reports vs. Dashboards in Power BI
  38. Power BI Tip: Slicers
  39. Power BI Tip: The Power BI Admin Portal
  40. Power BI Tip: The Power BI Dashboard
  41. Power BI Tip: The Power BI Home Screen
  42. Power BI Tip: Updating Apps
  43. Power BI Tip: Using Custom Visuals
  44. Power BI Tip: Workspace Access
  45. Power BI Tip: Workspaces Preview
  46. Visualization Tip: Bringing Attention Where Attention Is Warranted: KPIs
  47. Visualization Tip: Choosing the Right Calculation
  48. Visualization Tip: Choosing the Right Chart
  49. Visualization Tip: Choosing the Right Colors for a Dashboard
  50. Visualization Tip: Choosing the Right Precision
  51. Visualization Tip: Designing a Clean Report
  52. Visualization Tip: Keeping Space Around the Edges
  53. Visualization Tip: Labeling Appropriately
  54. Visualization Tip: Understanding Sparklines
  55. Visualization Tip: Using Fonts
  56. Visualization Tip: Using Maps
  57. Preface
  58. Acknowledgments
  59. 1 - Introduction
  60. 2 - Understanding Dashboards and Reports
  61. 3 - Collecting and Preparing the Data
  62. 4 - Building the Main Report
  63. 5 - Building Detailed Reports
  64. 6 - Sharing Dashboards and Reports Within an Organization
  65. Index