Introduction

  • 2 minutes

As with any project, a good starting point when designing reports is to define clear goals. In your reporting project, those goals should strive to help you determine the:

  • Audiences of your reports.
  • Report types.
  • User interface requirements.
  • User experience requirements.

This module provides examples based on a scenario of the Contoso Skateboard Store company, which specializes in direct-to-consumer skateboard sales. To modernize their workflow and gain a deeper understanding of their product sales and inventory management, the company needs to create a set of reports to deliver data to their employees.

Screenshot shows an example Power BI report from the Contoso Skateboard Store.

Currently, the finance and supply chain divisions operate in vertical silos. These divisions use data differently, which resulted in many inconsistencies in how they interpret the data when making decisions. These inconsistencies often led to disagreements and misalignment at the executive level because the numbers don't match.

Also, the company currently consumes this information by using formats that aren't optimized for a modern workforce. To this end, employees commonly spend many hours creating reports on demand by using disparate data sources. These reports answer simple questions like "What were our sales in the Los Angeles area last month?" These reports contributed to a duplication of effort, resulting in an overlapping of reports that might occasionally use different calculation logic over the same data.

The company is committed to developing a new suite of reports to meet the following business requirements:

  • Promote a standard view of their data and business logic that is a single source of truth across all divisions.
  • Ensure reports deliver up-to-date data that's no older than 24 hours for sales and one hour for inventory.
  • Create modern sales and inventory reports accessible at any time by their employees, whether they're in the office, working from home, or on the road. Reports used by finance managers, supply chain managers, and data analysts.
  • Design reports that feel natural and are user-friendly.
  • Publish reports that have sufficient depth of detail and enable report consumers to discover new insights.
  • Apply consistent corporate brand standards.