Big Ways Small Businesses are Leveraging Analytics to Gain Insights

on YouTube ↗01h 06m

" summary

Power BI sits on top of a SQL POS using Power Query and Excel/Power View to build live dashboards that track sales, inventory, noise and tap temperatures, customer voting and tips. Karaoke added on Wednesdays raises weekly sales after launch; vendor promotions double monthly product sales (peaks ≈ $5.1–5.4k vs a $3k average). Inventory shrink drops from ~$5k/month loss (≈ $75k/year) after automated comparisons and KPIs. The setup uses Power Query, Power BI dashboards, and streaming live data and it works.

AI-written summary · about

" chapters (11)

1. 0:00Power BI introduction
2. 1:03Power BI use case
3. 3:11Small business data challenges
4. 7:25Connecting to POS systems
5. 8:48Live interactive demo
6. 15:55Owner dashboard analysis
7. 29:42Employee dashboards
8. 40:06Vendor dashboards
9. 53:55Traditional vs Power BI
10. 58:12Data-driven decisions
11. 1:00:00Q&A

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 25mData interpretation for B2B SaaS tools: how to bring informed business decisionsMarko Dragic · DSC Croatia 2022
• 51mAggregations in Power BIMarco Russo · SQLBits 2024
• 58mPower BI for DevelopersPeter Myers, Laurent Amar · NDC London 2019
• 01h 01mIntroducing the Reimagined Power BI PlatformJen Underwood · PASS BA Marathon 2015
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016