Explore the evolving landscape of Business Intelligence (BI) in this 59-minute conference talk from PASS Data Community Summit. Delve into the advantages and challenges of cloud-based, on-premises, and hybrid BI solutions. Learn about classic data analysis techniques, Power BI architecture, and Azure services like SQL DB, SQL DW, and Data Factory. Discover the latest BI enhancements in SQL Server 2014 and 2016, including improvements to SSIS and the database engine. Gain insights into tool selection, gateway functionality, and the role of Excel and Power BI Desktop in modern BI workflows. Equip yourself with the knowledge to make informed decisions about your organization's BI strategy and implementation.
Overview
Syllabus
Intro
Technical Assistance
PASS SUMMIT 2015
Agenda
Concepts
Classic Data Analysis
Power BI 1.0
Power BI Current Architecture
Welcome to SQL DB
SQL DW Elastic scale & performance
Where does SQL DW fit?
Azure Data Factory-ETL in the Cloud
Infrastructure as a Service
Azure Data Lake (Not in Public Preview)
Cloud vs On-Premises
On-Premises BI-SQL 2014
SQL Server 2016-BI Enhancements SSIS
SQL Server 2016—BI Enhancements Engine
SQL Server Data Tools and BIDS
Power BI Desktop
Excel 2013
What Tools Should I Use?
Gateways
What Does the Gateway Do?
This is Going to be 45 minutes at the Pre-Con
Summary
Taught by
PASS Data Community Summit
