Excursions by AdventureW​orks

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

 

 

 

eyJrIjoiZGFjNWVjZmUtNDU3Mi00MmU5LWI1YTEtMjE5YzdkMGU4ZjdhIiwidCI6IjU3NGMzZTU2LTQ5MjQtNDAwNC1hZDFhLWQ4NDI3ZTdkYjI0MSIsImMiOjZ9