Interactive PowerBI Example: eMarket Scorecard
All data has been randomized, masked, and altered for demo purposes only. Videos will highlight functionality and tangible business insights.
The eMarket Scorecard is a dashboard that allows users to understand where they rank in the market, the trends of what is occurring, and dive deep into the report to take action at the item-level. It is similar in data structure to the POS report, however this is specifically online data.
The Scorecard view gives a high-level snapshot. The Business & Subcategories for the whole market are shown alongside Company sales and share. Looking at Supplements, the way to interpret the data is that the Company has a 30.2% share of Vitamins in the last 4 weeks. Compared to last year’s share (33.1%), that is a basis-point decline of 2.9 (AKA 2.9%). Even though the Company’s Vitamin sales have increased by 3.1%, the market of Vitamins has increased by 13% - so the Company is under pacing the market. In the metrics selection, users can choose 1P Sales, Units, 1P Units, & Ad Spend.
The next page Top N Brands represents the market dynamics of which brands control the most share, and how those brands are performing. As an example, select “Beverages” in the Business filter. The top 20 brands will show up, with their sales & share changes shown. The blue-highlighted Aquatic & BottledUp brands are Company-owned. Notice how the top 20 brands represent 61.8% of the share. The remaining brands represent the other 38.2%. Using the Top N Selection filter, pick “10”. It will filter the report to the top 10 brands, representing 46.8% of the market. The “Supplements” business differs - as the top 10 brands make up ~80% of the share. The “Supplements” market is more top-heavy, representative of an oligopoly. Yet the “Beverages” market is more competitive. Click the “Item” button to do this same analysis by item.
The next page Brand KPIs is tailored to answer the question: why? Filtering for Supplements - the brand Vitalmins rises to the top. In one view users can see the changes & relative weighting of sales, units, traffic, organic traffic, paid traffic, other traffic, Top-of-search spend, ASP (Average Sale Price), & Conversion rate. Without diving into all the metrics, users can easily see that Brand 79 has emerged with unprecedented growth take share away from Vitalmins.
The next page KPI Trends shows similar information but over a timeline.
The final page Item Monitoring is where deep-dive item-level analysis can be performed. Nearly 70+ metrics are available to glean the reason why the market has changed in the way it did. As an example, filtering for “Supplements” and Brand 79, it lists the 4 items of that brand. The first 2 items show growth, while the other 2 items are new entrants.