Finding Your Balance: BI in the Cloud, On Premises, or Both
summary
Clear claims and concrete tools: powerbi desktop is free and updates monthly, with a powerbi Analysis Services connector and gateways enabling real-time querying against on-prem SSAS tabular; Azure SQL Data Warehouse uses pause compute and pay by DWU with MPP and columnstore for large-scale analytics; SQL Server 2016 adds columnstore batch mode yielding multi‑x compression and faster queries; Azure Data Factory vs SSIS is an ETL tradeoff; the connectors and single‑sign‑on setup determine whether the hybrid pipeline actually works.
AI-written summary · about
chapters (26)
- 0:00Intro
- 1:04Technical Assistance
- 2:10PASS SUMMIT 2015
- 6:03Agenda
- 10:15Concepts
- 13:33Classic Data Analysis
- 15:18Power BI 1.0
- 17:17Power BI Current Architecture
- 20:36Welcome to SQL DB
- 22:00SQL DW Elastic scale & performance
- 26:36Where does SQL DW fit?
- 28:34Azure Data Factory-ETL in the Cloud
- 30:12Infrastructure as a Service
- 31:09Azure Data Lake (Not in Public Preview)
- 33:04Cloud vs On-Premises
- 35:47On-Premises BI-SQL 2014
- 37:45SQL Server 2016-BI Enhancements SSIS
- 40:59SQL Server 2016—BI Enhancements Engine
- 44:39SQL Server Data Tools and BIDS
- 45:18Power BI Desktop
- 46:01Excel 2013
- 47:25What Tools Should I Use?
- 47:53Gateways
- 48:57What Does the Gateway Do?
- 49:45This is Going to be 45 minutes at the Pre-Con
- 50:28Summary
related talks
28mBusiness Data Analysis using Power BI by integrating On-Prem Data with Cloud Services
01h 17mPower BI What's New 2019–2020 for Enterprise
52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution
59mPresent and Futures: Roadmap and Strategy
40mSelf-Service ETL: The PowerBI Data Flows
57mBillions of records: the real success story using Microsoft Power BI Embedded
51mThe Microsoft Intelligent Data Platform
01h 01mIntroducing the Reimagined Power BI Platform