Microsoft EmployeeWorld Champs BCN Round 1 - Monitoring Commercial Performance
I built this report to answer the Round 1 question for PitchSide Pro, a global football-merchandise retailer - what is driving changes in revenue performance over time, and where should the business focus next to sustain growth? My goal was to give leaders a tool they can use to monitor commercial performance through key KPIs such as Revenue, Profit, Quantity, Discounts, and the Conversion Rate.
I organized the report into five main pages that helps navigate a user from a high-level overview to a specific dimension. The Overview page serves as the Landing page, outlining the key KPIs and summary charts to monitor the commercial performance by Region. To learn more about specific dimensions, users can navigate to the Product and Customer page to see a dimensional breakdown.
Time-period analysis is key to establishing and monitoring trends. To do this, I built a dedicated Trends page where users can change the date dimension on the line chart through bookmaks for more granular analysis. As an added bonus, I included an extra hidden page to allow users to see and export out the data from the Sales and Traffic tables if needed.
I also included information about the report and a data dictionary to provide additional context around the objective of the report, the data included, and how to use and navigate the report. The Data Dictionary in particular was really fun to build out!
Apart from this, I used a mix of bookmarks and field parameters to reduce the number of unique visuals to boost performance without affecting the interactivity of the report. I built out perspectives and enabled the Personalize Visuals feature on select visuals. In a production scenario, this would enable users to change the configuration of visuals on their end and configure them with the dimensions and calculations of thier choice.
1 Reply
Andres73_renaceHelper I
I really liked the overall organization of the report, especially the Overview page that nicely summarizes the key KPIs. As another participant (not a professional), perhaps an order tab or some tooltips on the buttons could add more accessibility and narrative clarity, since with so many filters the intention can feel a bit dispersed. The Customers section looked very neat to me, although the Show Raw Data button feels a bit out of place with the natural flow of that page. Overall, I think adding an extra text or a tooltip that synthesizes what each page shows would give even more value. Great work and congratulations on the effort!
Me gustó mucho la organización general del informe, especialmente la página de Overview que resume bien los KPI clave. Como otro participante (no profesional), quizás un orden tab o algunos tooltips en los botones podrían aportar más accesibilidad y claridad narrativa, ya que con tantos filtros la intención puede dispersarse un poco. El apartado de Customers me pareció muy prolijo, aunque el botón Show Raw Data rompe un poco con la naturalidad de esa página. En general, creo que un texto extra o un tooltip que sintetice lo que muestra cada página le daría aún más valor. ¡Gran trabajo y felicitaciones por el esfuerzo!