Using data from the AdventureWorks database, we’ve created some executive and manager level reports for a mock, eComerse company that sells activity vouchers/tickets (think cruise excursion). We have an individual report for analyzing sales, orders, customers, social media (marketing), resellers, and have a CEO level scorecard. I’ll go through each report with a brief description and show off its features.
“Day Scorecard”
- Shows health of entire company at once
- Page Level Filter Utilization
- Sleek Look
“Social Media”
- Ticker (Custom Visualization) – Conversion Rate
- Custom KPI’s (Showing whether current conversion rate meets company standards)
- Effective use of Highlight feature
“Orders”
- Slicer (by year)
- Custom KPI’s (requiring 20% increase in sales)
- Line chart comparing previous year
“Products”
- Drill down
“Customers”
- Map integrated with Pie Charts (showing customer number by state/region)
- Relative success nationally and internationally (Highlightable)
- Slicer
“Reseller”
- Unstacked Area chart (shows change in last year)
- Country “Bullet” slicer
- Gauge
Learn more about this report from the author by watching this video: https://www.youtube.com/watch?v=FNahmeFKiB8
