Transcript Document

Superhero Power BI
Peter Myers
Bitwise Solutions
[email protected]
http://www.linkedin.com/in/peterjsmyers
Defining
Business Intelligence
A broad category of applications and technologies for gathering,
storing, analyzing, sharing and providing access to data to help
enterprise users make better business decisions
(Continued)
BI is no longer a luxury afforded by a larger companies
— it is now considered an essential part of the IT portfolio
(Continued)
Corporate BI
Corporate BI
1: Clients
2:
3:
4:
5:
6:
7:
8:
The data
Data
Staging
Manual
sources
warehouse
need
may
use
cleansing
areas
warehouse
various
access
access
can
may
isbe
may
periodically
simplify
data
tools
to
mirrored/replicated
manages
data
be
sources
torequired
query
thedata
populated
data
directly
the
to
for
warehouse
data
cleanse
analyzing
tofrom
warehouse
reduce
dirty
data
population
and
contention
data
sources
reporting
Data Warehouse
Data Sources
Data Marts
Staging Area
Client
Access
Manual
Cleansing
Client
Access
Corporate BI (Continued)
Self-Service BI
Self-Service BI (Continued)
Self-Service BI: Advantages
Self-Service BI: Disadvantages
Self-Service BI: Disadvantages (Continued)
Managed BI
Managed BI (Continued)
Demo
Exploring a Power BI Solution
Summary
Introducing Microsoft
Business Intelligence
Strategy and Vision
Business User Experience
Business Collaboration Platform
Information Platform
Familiar User Experience
Self-Service Access and Insight
Data Exploration and Analysis
Predictive Analysis
Data Visualization
Contextual Visualization
Integrated Content and Collaboration
Thin Clients
Dashboards
BI Search
Content Management
Information Platform
Data Warehousing
Integration Services
Master Data
Data Quality
Analysis Services
• Data Modeling and Data Mining
Reporting Services
Excel
Note: The next generation of
Power BI tools (in preview)
disconnect from Office and Excel
Excel: Complete and Powerful SSBI Tool
Access
• Power View
• Power Map
Share
Clean
Visualize
Mash-up
Explore
Resources
http://www.microsoft.com/bi
http://office.microsoft.com/excel
http://www.powerbi.com
http://blogs.msdn.com/b/powerbi/
Demo
Exploring a Conventional Excel Solution
Developing
Power BI Solutions
Data Modeling with
Power Pivot
(Continued)
Deliverables
Development Methodology
Optional
Demo
Introducing Power Pivot
Opportunities
Opportunities (Continued)
Resources
http://www.microsoft.com/en-us/bi/powerpivot.aspx
http://social.technet.microsoft.com/wiki/contents/articles/1088.dax-resourcecenter.aspx
Resources (Continued)
http://www.microsoft.com/download/en/details.aspx?id=28572
Data Acquisition with
Power Query
(Continued)
Data Source Types
Data Source Types (Continued)
Demo
Introducing Power Query
Opportunities
Resources
http://www.microsoft.com/en-us/download/details.aspx?id=39379
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2014/DBI-B324
http://go.microsoft.com/fwlink/?LinkID=320633
Resources (Continued)
Power Pivot
Reporting
Covered in later topics
PivotTables
PivotCharts
Excel CUBE Functions
Apps for Office
•
•
•
•
•
Charts
Embedded images
Conditional formatting
Slicers
Timelines
•
•
•
•
•
Sparklines
Hyperlinks
Outlining
CUBE functions
Apps for Office
Demo
Reporting with the Excel CUBE Functions
Opportunities
Resources
http://msdn.microsoft.com/en-us/library/office/jj220082.aspx
Data Visualization with
Power View
Example
Data Model Preparation
Data Model Preparation (Continued)
Data Model Preparation (Continued)
Report Design
Demo
Introducing Power View
Opportunities
Data Visualization with
Power Map
Development Methodology
Optional
Demo
Introducing Power Map
Opportunities
Resources
http://www.microsoft.com/en-us/download/details.aspx?id=38395
Power BI
Sharing and
Collaboration
(Continued)
Power BI for Office 365
Power BI Sites
Power View Forecasting
Power BI Q&A
Query and Data Management
Query and Data Management: Monitoring
Windows Mobile BI App
Cloud-Based Data Refresh
Internet Accessible
• Microsoft Azure SQL Database
• SQL Server in a Microsoft
Azure Virtual Machine
• OData services:
• Basic or anonymous authentication
• SharePoint lists
• Project Online feeds
On-Premises
• SQL Server 2005 and above
• Oracle 10g, 11g and 11gR2
• Power Query connections to
these data sources:
• SQL Server 2005 and above
• Oracle 10g, 11g and 11gR2
Cloud-Based Data Refresh
Demo
Exploring the Power BI Site
Opportunities
Opportunities (Continued)
Resources
http://www.powerbi.com
http://blogs.msdn.com/b/powerbi/
Next Generation
Power BI (Preview)
Power BI Designer
Power BI Designer (Continued)
Power Query
Power Pivot
Power View
Power BI Dashboards
Out-of-the-Box Connectors
New Data Visualizations
Live connectivity to SQL Server Analysis Services
Live
Connectivity
Native Mobile Apps
Developer APIs
Summary
Summary
Unleash the Superhero in You! 
Empowering Users with Self-Service in Excel
Discover
Analyze
Visualize
Search and combine public and
internal data with Power Query
Model & analyze 100’s of millions
of rows lightning fast with Power
Pivot
Explore and visualize data in new
ways with Power View and Power
Map
Connecting and Collaborating in Office 365
Share
Find
Q&A
Mobile
Share queries & workbooks and
refresh from on-premises data with
BI Sites
Find answers with search-based
data visualization in Q&A
Stay connected from anywhere with
HTML5 and the Power BI mobile
app
Resources
Resources (Continued)
http://blogs.msdn.com/b/powerbi/archive/2013/10/16/get-ready-get-set-for-thepower-bi-demo-contest.aspx
https://www.facebook.com/microsoftbi/app_112813808737465
Resources (Continued)
http://bit.ly/srn2015_spbi
Explore Everything PASS Has to Offer
Free SQL Server and BI Web Events
Free 1-day Training Events
Regional Event
This is Community
Business Analytics Training
Local User Groups Around
the World
Session Recordings
PASS Newsletter
Free Online Technical Training