methodbi 552
TRANSCRIPT
-
7/28/2019 MethodBI 552
1/34
Business Intelligence
Ulrika LeufvnSystem Engineer
Microsoft AB
Making Better Decis ions Faster
-
7/28/2019 MethodBI 552
2/34
Agenda
Business Intelligence overviewMicrosofts BI Platform
SQL Server Accelerator for BusinessIntelligence (SSABI)
-
7/28/2019 MethodBI 552
3/34
Business Intelligence
Making better decisions faster- Critical decisions per week have tripled over the last five
years- Dedicated analytical personnel have decreased by 50% over
the last five years
Converting Data into Information- Available business data is growing exponentially
Source: Gartner Group
-
7/28/2019 MethodBI 552
4/34
Some history
Press Release: October 29, 1996- Microsoft acquires Panorama OLAP Technology
SQL Server 7.0, 1999- OLAP Services
SQL Server 2000 (8.0) , 2000- Analysis Services
-
7/28/2019 MethodBI 552
5/34
Microsoft rocking the industry
Microsoft and Hyperion joint market leaders in 2001 Microsoft: #1 product chosen (80%) if evaluated and
compared to others
Analysis Services deployment grew 60% Microsoft OLAP market revenue almost doubled in 2001
Source : The OLAP Report, March 7th, 2002
-
7/28/2019 MethodBI 552
6/34
Business Intelligence Architecture
Data Marts
and cubes
Relational
DW
Database
Source
Systems
Clients
Query ToolsReportingAnalysisData Mining
OLAPCubes
Data extraction Designing and processing Performing multi-
and transformation OLAP cubes dimensional analysis
1 32
http://swedenshare/tsp/My%20Documents/ulrikale/Local%20Settings/Temporary%20Internet%20Files/OLK4/diagrams/SalesStar.htmhttp://swedenshare/tsp/My%20Documents/ulrikale/Local%20Settings/Temporary%20Internet%20Files/OLK4/diagrams/SalesStar.htm -
7/28/2019 MethodBI 552
7/34
Why Microsoft BI Platform?
MicrosoftSQL Server 2000 is thefastest way to deliverenterprise database
solutions
Microsoft OfficeThe world's
leading suite of productivitysoftware
SQL Server 2000 Comprehensive, integrated scalable
RDBMS:- Data Transformation
Services- Analysis Services (OLAP
and Data mining)- Metadata Services- English Query facility
Office XP Excel - Built-in PivotTable
Service Web components for custom
development Digital Dashboard Data Analyzer
-
7/28/2019 MethodBI 552
8/34
BIall around you
SQL Server 2000and Analysis Services
MapPoint
Office WebComponents
Cognos
CommerceServer Project 2002
XML
-
7/28/2019 MethodBI 552
9/34
SQL Server Accelerator for BIThe SQL Accelerator for BI enablesyou to rapidly develop and deploy
customized analytical applicationswithout long and costlydevelopment cycles.
-
7/28/2019 MethodBI 552
10/34
What problems are we trying to solve?
Analytical apps are key to BI as aneveryday thing- Skills gap constrains growth of BI
Solution Providers- Deploying the infrastructure is difficult and
costly- Hard to leverage best practices and content
Customers- Analytical apps take too long to build- Historically high risk of failure- No generic analytical app can meet all
customer requirements out of the box
-
7/28/2019 MethodBI 552
11/34
Our approach
Our solution:- Enables rapid iterative development for the
analytical application- Encapsulates domain expertise in a common
structure Data model KPIs (measures and metrics) Reporting application ETLM lifecycle
Focus on business requirementsCodify best practicesFacilitate re-use of content and design
-
7/28/2019 MethodBI 552
12/34
Accelerator for BI Components
Solution components- SSABI tool- Predefined content- Prescriptive Architectural Guidance
-Client Views
What the customer gets- Enterprise-ready analytical application- Customized to their requirements- Open and extensible system
-
7/28/2019 MethodBI 552
13/34
SourceSystems
DTS DTS
Analytics Builder
ETL
Data WarehouseDB
Snowflake schema Support for SCD Surrogate keys
StagingDb
Raw tables Rich pre-built
time dimension
Cubes
Special calculatedmeasures (KPIs)
Built-in partitioningby time (optional)
OLEDB for OLAP UI
StandardReports
Variousclient toolssupported
AnalyticsBuilderWorkbookArchitecture
-
7/28/2019 MethodBI 552
14/34
DemoAnalytics Builder Workbook
-
7/28/2019 MethodBI 552
15/34
Reporting application overview
Generic solution includes rich set of predefined reports: thereporting application
Choose your client tool: Excel, MSDA, ProClarity, (or anyother)
-We ship a similar set of reports in each tool
- Not identical, because tool features differ
What happens when you customize the schema?- Our client generator components, written by the tool vendors fix the
reports for you
-Any tool vendor beyond our first 3 could write a client generator andintegrate with the BI Accelerator framework
-
7/28/2019 MethodBI 552
16/34
DemoClient Views
-
7/28/2019 MethodBI 552
17/34
Customer benefits
Accelerator for BITime to MarketCustomized Solution
Focus on business issues not technologyReduce RiskLower barrier to entry to BI
-
7/28/2019 MethodBI 552
18/34
Partner benefits
Add more value to customers- Focus on business value not plumbing- Extend solutions
Better implementations- Reduce deployment risk for clients- Best practices
Leverage IP- Reuse IP across clientele- Knowledge uniformity
-
7/28/2019 MethodBI 552
19/34
Shell Canada
By using the BI
Accelerator for all ofour future developmentwe will ensureconsistency in design
and implementation.This also enables us todeliver functionally richbusiness solutions in alow cost and easy tomaintain method.
Dan Bainbr idge
Team Leader Data
Warehouse
Shell Canada
Retail AnalyticsSolution
Business Situation
800 Shell retail locations throughout Canada.Same site analysis is difficult/ Sales MixHard to view the big pictureNot able to disseminate information to end usersCannot pinpoint what factors effect revenue and cost
Solution Goals
Empower end users to analyze their businessProvide consolidated reporting environmentUnderstand the factors that affect revenue and costConsolidate reportsDistribute reports efficiently and effectivelyFlag areas of concern
Provide flexible analysis of attributes
Category AnalysisCustomer analysisPromotion AnalysisSale Mix
Same Site analysis
-
7/28/2019 MethodBI 552
20/34
More Information
www.microsoft.com/solutions/bi www.microsoft.com/sql/techinfo/bi www.microsoft.com/office/business/intelligence/ [email protected] New book Making Better Decisions Faster
MsPress
-
7/28/2019 MethodBI 552
21/34
Staging database
-
7/28/2019 MethodBI 552
22/34
Subject Matter Database
-
7/28/2019 MethodBI 552
23/34
Subject Matter Db: Datamodell fr Sales kub
-
7/28/2019 MethodBI 552
24/34
Analysis Database Cubes
-
7/28/2019 MethodBI 552
25/34
Klientvyer
Frdiga rapporter- Excel 2002- Microsoft Data Analyzer- Proclarity-
DSP- ppet fr vriga klienter...
Nyckeltal definierade och presenterade p ett verskdligtstt
Ltt att ndra och anpassa
-
7/28/2019 MethodBI 552
26/34
DemoKlientvyer
-
7/28/2019 MethodBI 552
27/34
Data Transformation Services
Anvnd DTS fr logik och datafldesstruktur DTS paketen r ltta att anpassa Konsistent anvndning av parametrar (globala
variabler) fr fler valmjligheter Noggrann felhantering
- Skickar felaktiga rader till felhanteringstabeller
Parallellism
-Automatiskt uttnyttjande av flera processorer
-
7/28/2019 MethodBI 552
28/34
Exempel p ett paket fr tabellimport
All packagesbegin withthese setupsteps
Find data file; truncatetable; load data modifythis section to pull fromnon-flat source
Log status to theevent log table
-
7/28/2019 MethodBI 552
29/34
Agenda
Nyheter inom Business Intelligence- Microsoft Data Analyzer- MapPoint
-Project 2002
- SharePoint Portal Server
SQL Server Accelerator for Business Intelligence- Introduktion- Arkitektur
-Verktyget
- Klientvyer
Mer information
-
7/28/2019 MethodBI 552
30/34
-
7/28/2019 MethodBI 552
31/34
Mer information
www.microsoft.com/solutions/bi Faktablad
- SSABI
http://www.microsoft.com/sql/techinfo/BI/ http://www.microsoft.com/office/business/
intelligence/default.aspMsPress Making Better Business Intelligence
Decisions FasterMSDN
http://swedenshare/tsp/BI/SSABI%20Data%20Sheet.dochttp://swedenshare/tsp/BI/SSABI%20Data%20Sheet.doc -
7/28/2019 MethodBI 552
32/34
Shell Canada
By using the BI
Accelerator for all ofour future developmentwe will ensureconsistency in design
and implementation.This also enables us todeliver functionally richbusiness solutions in alow cost and easy tomaintain method.
Dan Bainbr idge
Team Leader Data
Warehouse
Shell Canada
Retail AnalyticsSolution
Business Situation
800 Shell retail locations throughout Canada.Same site analysis is difficult/ Sales MixHard to view the big pictureNot able to disseminate information to end usersCannot pinpoint what factors effect revenue and cost
Solution Goals
Empower end users to analyze their businessProvide consolidated reporting environmentUnderstand the factors that affect revenue and costConsolidate reportsDistribute reports efficiently and effectivelyFlag areas of concernProvide flexible analysis of attributes
Category AnalysisCustomer analysisPromotion AnalysisSale Mix
Same Site analysis
-
7/28/2019 MethodBI 552
33/34
Enmax Energy
Retail AnalyticsSolution
Business Situation
Deregulated market in 2001New methodology for operation and settlementAnalysis of Settlement data is time consumingHard for business users to identify problem areasduring settle process
Solution Goals
Need ability to do historical analysis to improvesettlement forecastsNeed to have better understanding of power usage todecrease tariffs
Settlement AnalysisLoad Shape AnalysisCustomer Enrollment analysisForecasting
This p roduct
also s haved 16-18
weeks of b ack-end
p lumbing development
t ime off the pro ject , by
instal l ing a sol idinfrastructu re, al lowin g
dimension al modelers
to focus on bu i ld ing
strategic busin ess
prototypes for key
stakeholders.
Michael Matr ick VicePresident, Busin essSolut ions QuadrusDevelopm ent Inc
-
7/28/2019 MethodBI 552
34/34
Frgor?