Power BI Datamart - What, How and Why?

on YouTube ↗19m

" summary

Power BI Datamarts creates a fully managed Azure SQL database inside Power BI Service (requires Premium), ingests multiple sources (Excel, SQL Server, Dataflows), exposes an automatic Power BI dataset and a SQL endpoint for SSMS or custom queries. It runs Power Query online for transforms, offers a model view to create relationships and DAX measures, supports visual SQL queries that show generated SQL, includes row‑level security and incremental refresh (preview), and suits exploration and quick proofs of concept rather than mature production use.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to Data Marts
2. 1:25What are Data Marts?
3. 2:24Creating and Transforming Data
4. 6:26Data Modeling and Relationships
5. 8:16Creating Measures
6. 9:15Visual and SQL Querying
7. 12:24Data Governance and Security
8. 14:15Why Use Data Marts?
9. 16:11Q&A and Conclusion

" related talks

• 01h 17mPower BI What's New 2019–2020 for EnterpriseRubén Pertusa · Global Azure Virtual 2020
• 57mBillions of records: the real success story using Microsoft Power BI EmbeddedIrina Dragunova · NDC Oslo 2020
• 45mUnderstanding Microsoft DataverseAdewale Yusuf · Power Platform Virtual Conference 2021
• 59mFinding Your Balance: BI in the Cloud, On Premises, or BothJoey D'Antoni · 24 Hours of PASS: Summit Preview 2015
• 01h 02m60-Minute Demo: Microsoft BI Tools on SAP DataMichael Raheem · PASS Business Analytics Conference 2013
• 01h 01mIntroducing the Reimagined Power BI PlatformJen Underwood · PASS BA Marathon 2015
• 28mBusiness Data Analysis using Power BI by integrating On-Prem Data with Cloud ServicesVinod Unny · Rootconf Cloud Server Management (Delhi) 2018
• 40mSelf-Service ETL: The PowerBI Data FlowsDennes Torres · Data Con LA 2020