60-Minute Demo: Microsoft BI Tools on SAP Data

on YouTube ↗01h 02m

" summary

Live demo links Microsoft BI stack to SAP: PowerPivot + Excel 2013 loads a SQL staging copy, creates relationships and DAX measures, and publishes interactive Power View on SharePoint. Connectivity uses Theobald extractors as an Extract DeltaQ via SSIS package that initially pulls 8,258 rows and then picks up a single-row change on delta runs; optionally builds an SSAS cube and exports interactive PowerPoint slides.

AI-written summary · about

" chapters (15)

1. 0:00Microsoft BI tools on SAP data
2. 2:55Demo scenario setup
3. 7:33Import sales data to PowerPivot
4. 11:50Relationships and column names
5. 16:08DAX advanced calculations
6. 20:39Connect SAP with third-party tools
7. 27:56Extract SAP data with SSIS DeltaQ
8. 36:28Import SAP customer data
9. 38:14Analyze sales with charts
10. 43:05Format and finalize analysis
11. 44:31Publish reports to SharePoint
12. 51:12Schedule and refresh data
13. 53:19Power View dashboard with maps
14. 56:43Real-time SAP via Analysis Services
15. 1:00:41Summary and Q&A

" related talks

• 52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solutionPawel Potasinski · SQLBits 2023
• 57mBillions of records: the real success story using Microsoft Power BI EmbeddedIrina Dragunova · NDC Oslo 2020
• 51mThe Microsoft Intelligent Data PlatformBuck Woody · SQLBits 2023
• 40mSelf-Service ETL: The PowerBI Data FlowsDennes Torres · Data Con LA 2020
• 19mAzure SQL MI End-to-end Demo Party for DBAs and DevsNiko Neugebauer, Dr. Dani Ljepava · SQLBits 2023
• 09mConversation with Mark Thienpont, Lead Expert BI/HANA Consultant, Delaware ConsultingMark Thienpont · Cloud Foundry Summit Europe 2017
• 01h 01mIntroducing the Reimagined Power BI PlatformJen Underwood · PASS BA Marathon 2015
• 59mFinding Your Balance: BI in the Cloud, On Premises, or BothJoey D'Antoni · 24 Hours of PASS: Summit Preview 2015