Rebooting your SME Data Analysis Strategy

on YouTube ↗45m

" summary

Combines SQL ERP rows, weekly retail Excel files and budget spreadsheets into a single model using Power Query and Power BI, adds a master product mapping, and publishes to the service; moves shared ETL into Power BI dataflows stored in Data Lake Gen2 and uses an enterprise gateway for on‑premise access. Automates email attachments to a network share and triggers dataset refresh with Power Automate save attachment and refresh, and captures Twitter sentiment via Cognitive Services into Azure SQL. Demo succeeds, dashboard value rising from 47k to 51k.

AI-written summary · about

" chapters (18)

1. 0:00Intro
2. 1:00PowerPoint
3. 1:18Agenda
4. 1:42Data Projects
5. 2:52Business Requirement
6. 3:51Phase 1 Power BI
7. 5:35Data Sources
8. 7:06Getting Data
9. 8:06Power Query
10. 12:43Data Model
11. 13:54Building a Report
12. 16:23A Critique
13. 17:10Data Flows
14. 20:22What are Data Flows
15. 23:53SharePoint Site
16. 28:28Power BI Reports
17. 30:07Teams Environment
18. 33:02Demo

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 01h 03mFrom Data to Insight – Views from Microsoft FinanceMarc Reguera · PASS Business Analytics Conference 2013
• 40mSelf-Service ETL: The PowerBI Data FlowsDennes Torres · Data Con LA 2020
• 51mSupercharge Power BI with Azure Synapse AnalyticsMathias Halkjaer · SQLBits 2023
• 25mFrom Data Warehouse To Self-service BI: Our Journey To Data MeshYassine Trad, James Allum · Big Data LDN 2022
• 50mPower BI + Azure Synapse Analytics: Beginning your journeyPatrick LeBlanc, Adam Saxton · SQLBits 2023