topic Excursions by AdventureW​orks in Data Stories Gallery https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Excursions-by-AdventureW-orks/m-p/20121#M113 <P>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).&nbsp; We have an individual report for analyzing sales, orders, customers, social media (marketing), resellers, and have a CEO level scorecard.&nbsp; I’ll go through each report with a brief description and show off its features.</P> <P>&nbsp;</P> <P><STRONG>“Day Scorecard” </STRONG></P> <UL> <LI>Shows health of entire company at once</LI> <LI>Page Level Filter Utilization</LI> <LI>Sleek Look</LI> </UL> <P>&nbsp;<STRONG>“Social Media”</STRONG></P> <UL> <LI>Ticker (Custom Visualization) – Conversion Rate</LI> <LI>Custom KPI’s (Showing whether current conversion rate meets company standards)</LI> <LI>Effective use of Highlight feature&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;​&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;​&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</LI> </UL> <P><STRONG>“Orders”</STRONG></P> <UL> <LI>Slicer (by year)</LI> <LI>Custom KPI’s (requiring 20% increase in sales)</LI> <LI>Line chart comparing previous year&nbsp;</LI> </UL> <P><STRONG>“Products”</STRONG></P> <UL> <LI>Drill down&nbsp;</LI> </UL> <P><STRONG>“Customers”</STRONG></P> <UL> <LI>Map integrated with Pie Charts (showing customer number by state/region) <UL> <LI>Relative success nationally and internationally (Highlightable)</LI> <LI>Slicer&nbsp;</LI> </UL> </LI> </UL> <P><STRONG>“Reseller”</STRONG></P> <UL> <LI>Unstacked Area chart (shows change in last year)</LI> <LI>Country “Bullet” slicer</LI> <LI>Gauge</LI> </UL> <P>Learn more about this report from the author by watching this video:&nbsp;<A title="https://www.youtube.com/watch?v=FNahmeFKiB8" href="https://www.youtube.com/watch?v=FNahmeFKiB8" target="_blank">https://www.youtube.com/watch?v=FNahmeFKiB8</A></P> <P>&nbsp;</P> <P>&nbsp;<img></img></P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZGFjNWVjZmUtNDU3Mi00MmU5LWI1YTEtMjE5YzdkMGU4ZjdhIiwidCI6IjU3NGMzZTU2LTQ5MjQtNDAwNC1hZDFhLWQ4NDI3ZTdkYjI0MSIsImMiOjZ9</SPAN></P> Tue, 28 Jun 2016 23:03:58 GMT ScottAdams 2016-06-28T23:03:58Z Excursions by AdventureW​orks https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Excursions-by-AdventureW-orks/m-p/20121#M113 <P>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).&nbsp; We have an individual report for analyzing sales, orders, customers, social media (marketing), resellers, and have a CEO level scorecard.&nbsp; I’ll go through each report with a brief description and show off its features.</P> <P>&nbsp;</P> <P><STRONG>“Day Scorecard” </STRONG></P> <UL> <LI>Shows health of entire company at once</LI> <LI>Page Level Filter Utilization</LI> <LI>Sleek Look</LI> </UL> <P>&nbsp;<STRONG>“Social Media”</STRONG></P> <UL> <LI>Ticker (Custom Visualization) – Conversion Rate</LI> <LI>Custom KPI’s (Showing whether current conversion rate meets company standards)</LI> <LI>Effective use of Highlight feature&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;​&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;​&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</LI> </UL> <P><STRONG>“Orders”</STRONG></P> <UL> <LI>Slicer (by year)</LI> <LI>Custom KPI’s (requiring 20% increase in sales)</LI> <LI>Line chart comparing previous year&nbsp;</LI> </UL> <P><STRONG>“Products”</STRONG></P> <UL> <LI>Drill down&nbsp;</LI> </UL> <P><STRONG>“Customers”</STRONG></P> <UL> <LI>Map integrated with Pie Charts (showing customer number by state/region) <UL> <LI>Relative success nationally and internationally (Highlightable)</LI> <LI>Slicer&nbsp;</LI> </UL> </LI> </UL> <P><STRONG>“Reseller”</STRONG></P> <UL> <LI>Unstacked Area chart (shows change in last year)</LI> <LI>Country “Bullet” slicer</LI> <LI>Gauge</LI> </UL> <P>Learn more about this report from the author by watching this video:&nbsp;<A title="https://www.youtube.com/watch?v=FNahmeFKiB8" href="https://www.youtube.com/watch?v=FNahmeFKiB8" target="_blank">https://www.youtube.com/watch?v=FNahmeFKiB8</A></P> <P>&nbsp;</P> <P>&nbsp;<img></img></P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZGFjNWVjZmUtNDU3Mi00MmU5LWI1YTEtMjE5YzdkMGU4ZjdhIiwidCI6IjU3NGMzZTU2LTQ5MjQtNDAwNC1hZDFhLWQ4NDI3ZTdkYjI0MSIsImMiOjZ9</SPAN></P> Tue, 28 Jun 2016 23:03:58 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Excursions-by-AdventureW-orks/m-p/20121#M113 ScottAdams 2016-06-28T23:03:58Z