Microsoft Business Intelligence Consumer

Report
Microsoft Business Intelligence (BI)
About Me
• Creating
solutions for 20 years
• Traveling consultant at Glenture. Principal Consultant in
Microsoft BI Practice.
• Graduated from
. Also, have MCP and PMP.
• My Email: [email protected]
• Family:
Types of solutions I work
Also, we have created BI solutions in the Manufacturing, Insurance, Financial, Government,
Supply-Chain, and other industries.
Agenda
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
What is Self-Service Business Intelligence (SSBI)
How is one using Governance w/SSBI
Visualizations - MS BI History & Types
Models - MS BI History & Types
MS BI Decision Frameworks – Which one to pick
Start with a sound foundation – The Model
Tips/Takeaways for success
Important Links
What is PowerBI?
Demo
Questions and Comments
What is Self-Service Business Intelligence (SSBI)
 Enables business users to access and work with corporate information without the IT
department’s involvement (except, of course, to set up the data warehouse and data
marts underpinning the business intelligence (BI) system and deploy the self-service
query and reporting tools).
 The self-service approach enables end users create personalized reports and analytical
queries while freeing up IT staffers to focus on other tasks – potentially benefiting both
groups.
 Because self-service BI software is used by people who may not be tech-savvy, however, it
is imperative that the user interface must be intuitive and easy to use. Ideally, the
IT department should help users understand what data is available for BI uses by
providing a metadata dictionary at the business layer level. This will help end users to
focus on the meaning of the data in the BI system, not the technology itself.
 Self-service BI capabilities should be built with a business focus from the start. Training,
on both the data and the self-service applications, is critical for getting business workers
up-to-speed on how they can use the information in the BI system. While self-service BI
encourages users to base decisions on data instead of intuition, it creates the risk of
chaotic reporting within an organization. To mitigate that risk, IT should work with
business units to determine key metrics and an agreed-upon vocabulary, processes for
creating reports and publishing, what privileges are necessary for access to confidential
data and how to define and implement data security policies and privacy policies.
What is Self-Service Business Intelligence (SSBI)
What is Self-Service Business Intelligence (SSBI)
How is one company using Governance w/SSBI
Visualizations - MS BI History & Types
SSRS
1993, 2007 with SSAS
2004 w/SQL Server 2000
PowerView
SQL Server 2012 Tabular & SharePoint 2010,
Excel 2013,
SQL Server 2012 SP1 CU4 SSAS Multidimensional
PerformancePoint
2007 w/SharePoint
PowerMap
Excel 2013, Office 365, Power BI
SharePoint Required
Excel Pivot Table
Models - Microsoft BI History & Types
Multidimensional
Analysis Services
Tabular Analysis
Services
OLAP released SQL
Server 7 in 1998
SQL Server 2012
with
Vertipaq/xVelocity
Tools from CodePlex.com
PowerPivot
SQL Server 2008R2, Excel
2010, SharePoint 2010
with
Vertipaq/xVelocity
MS BI Decision Frameworks - User Types
MS BI Decision Frameworks - Data Size
MS BI Decision Frameworks - Visualizations
MS BI Decision Frameworks - Visualizations
MS BI Decision Frameworks - Visualizations
MS BI Decision Frameworks - Visualizations
MS BI Decision Frameworks - Visualizations
MS BI Decision Frameworks - Models
MS BI Decision Frameworks - Models
Source: http://download.microsoft.com/download/F/F/6/FF62CAE0-CE38-4228-9025-FBF729312698/Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf
Start with a sound foundation –
The Model
Star Schema
(Dimension)
(Dimension)
(Measures)
(Dimension)
1.
2.
3.
4.
5.
(Dimension)
MSBI is geared toward Star Schemas – a Ralph Kimball world; Natively support
snowflake in Multidimensional model and limited support in Tabular with
unidirectional relationships or complex DAX
Build your hierarchies, calculations, KPIs in the model so it can be reused from
many visualizations.
Build similar and consistent (conformed) dimensions in models when possible so
that analysis from different models can be integrated in the future.
Use terms for tables and columns that are easy to understand and consistent
across the organization.
Have a governing body to manage how models are created and deployed.
Tips/Takeaways for Success
1. Gather BI Requirements
2. Map Requirements to the MS BI Decision
Frameworks (User Types, Size, Visualization,
Model)
3. Model your data if needed or leverage an
existing model
4. Start with a small/simple POC in Excel
5. Build out POC to the full scale system
6. Get feedback often
Important Links
http://powerpivotgeek.com/
Extensive Blog for many aspects on PowerPivot
http://www.powerpivotpro.com/the-book/
The First PowerPivot Formulas (DAX) Book Written Specifically for Excel Users
http://www.powerpivotpro.com/
A blog concerning of thoughts on PowerPivot and SharePoint BI
http://blogs.msdn.com/b/analysisservices/
Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly
from the product team.
http://www.microsoft.com/en-us/bi/powerpivot.aspx
Training videos, examples, and other resources straight from Microsoft
http://www.jamesserra.com/archive/2013/11/tabular-model-not-ready-for-prime-time/
Excellent blog on the limitations of the Tabular Model
What is PowerBI?
•
•
•
•
•
•
•
•
Office 365
Excel 2013
PowerQuery
Deep Dive on SQL Saturday
PowerPivot
PowerMap
PowerView
http://www.microsoft.com/en-us/powerbi/
http://blogs.msdn.com/b/powerbi/
Demo
Thank You
and
Questions

similar documents