business intelligence ulrika leufvén system engineer microsoft ab making better decisions faster
TRANSCRIPT
![Page 1: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/1.jpg)
Business Intelligence
Ulrika LeufvénSystem Engineer
Microsoft AB
Making Better Decisions Faster
![Page 2: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/2.jpg)
Agenda
Business Intelligence overviewMicrosoft’s BI PlatformSQL Server Accelerator for Business
Intelligence (SSABI)
![Page 3: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/3.jpg)
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 GroupSource: Gartner Group
![Page 4: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/4.jpg)
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
![Page 5: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/5.jpg)
”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
![Page 6: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/6.jpg)
Business Intelligence Architecture
Data Marts Data Marts and cubesand cubes
RelationalDW
Database
SourceSourceSystemsSystems
ClientsClients
•Query ToolsQuery Tools•ReportingReporting•AnalysisAnalysis•Data MiningData Mining
OLAP Cubes
Data extraction Data extraction Designing and processing Performing multi- Designing and processing Performing multi- and transformation and transformation OLAP cubes OLAP cubes dimensional analysis dimensional analysis
11 3322
![Page 7: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/7.jpg)
Why Microsoft BI Platform?
Microsoft SQL Server 2000 is the fastest way to deliver enterprise database
solutions
Microsoft OfficeThe world's
leading suite of productivity software
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
![Page 8: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/8.jpg)
BI – all around you…
SQL Server 2000 and Analysis Services
MapPoint
Office Web Components
Cognos
Commerce Server Project 2002
XML
![Page 9: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/9.jpg)
SQL Server Accelerator for BIThe SQL Accelerator for BI enables you to rapidly develop and deploy customized analytical applications
without long and costly development cycles.
![Page 10: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/10.jpg)
What problems are we trying to solve?
Analytical apps are key to BI as an “everyday 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
![Page 11: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/11.jpg)
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
![Page 12: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/12.jpg)
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
![Page 13: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/13.jpg)
SourceSourceSystemsSystems
DTSDTS DTSDTS
Analytics BuilderAnalytics Builder
ETLETLData Warehouse Data Warehouse
DBDB
• Snowflake schema• Support for SCD• Surrogate keys
StagingStagingDbDb
• Raw tables• Rich pre-built
time dimension
CubesCubes
• Special calculatedmeasures (KPIs)
• Built-in partitioning by time (optional)
OLEDB for OLAPOLEDB for OLAPUIUI
• StandardReports
• Variousclient tools supported
AnalyticsAnalyticsBuilderBuilderWorkbookWorkbookArchitecture
![Page 14: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/14.jpg)
Demo
Analytics Builder Workbook
![Page 15: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/15.jpg)
Reporting application overview
Generic solution includes rich set of predefined reports: the reporting application
Choose your client tool: Excel, MSDA, ProClarity, (or any other)- 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 and
integrate with the BI Accelerator framework
![Page 16: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/16.jpg)
Demo
Client Views
![Page 17: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/17.jpg)
Customer benefits
Accelerator for BI Time to Market Customized SolutionFocus on business issues not technologyReduce RiskLower barrier to entry to BI
![Page 18: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/18.jpg)
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
![Page 19: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/19.jpg)
Shell Canada“By using the BI Accelerator for all of our future development we will ensure consistency in design and implementation. This also enables us to deliver functionally rich business solutions in a low cost and easy to maintain method.”
Dan BainbridgeTeam Leader – Data WarehouseShell Canada
Retail Analytics Solution
Business Situation•800 Shell retail locations throughout Canada.•Same site analysis is difficult/ Sales Mix•Hard to view the big picture•Not able to disseminate information to end users•Cannot pinpoint what factors effect revenue and cost
Solution Goals
•Empower end users to analyze their business•Provide consolidated reporting environment•Understand the factors that affect revenue and cost•Consolidate reports•Distribute reports efficiently and effectively•Flag areas of concern•Provide flexible analysis of attributes
•Category Analysis •Customer analysis •Promotion Analysis •Sale Mix•Same Site analysis
![Page 20: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/20.jpg)
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
![Page 21: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/21.jpg)
Staging database
![Page 22: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/22.jpg)
Subject Matter Database
![Page 23: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/23.jpg)
Subject Matter Db: Datamodell för Sales kub
![Page 24: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/24.jpg)
Analysis Database Cubes
![Page 25: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/25.jpg)
Klientvyer
Färdiga rapporter- Excel 2002- Microsoft Data Analyzer- Proclarity- DSP- Öppet för övriga klienter...
Nyckeltal definierade och presenterade på ett överskådligt sätt
Lätt att ändra och anpassa
![Page 26: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/26.jpg)
DemoKlientvyer
![Page 27: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/27.jpg)
Data Transformation Services
Använd DTS för logik och dataflödesstruktur DTS paketen är lätta att anpassa Konsistent användning av parametrar (globala
variabler) för fler valmöjligheter Noggrann felhantering
- Skickar felaktiga rader till felhanteringstabeller
Parallellism- Automatiskt uttnyttjande av flera processorer
![Page 28: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/28.jpg)
Exempel på ett paket för tabellimport
All packages begin with these setup steps
Find data file; truncate table; load data – modify this section to pull from non-flat source
Log status to the event log table
![Page 29: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/29.jpg)
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
![Page 30: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/30.jpg)
![Page 31: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/31.jpg)
Mer information
www.microsoft.com/solutions/bi Faktablad
- SSABI
http://www.microsoft.com/sql/techinfo/BI/ http://www.microsoft.com/office/business/
intelligence/default.asp MsPress ”Making Better Business Intelligence
Decisions Faster” MSDN
![Page 32: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/32.jpg)
Shell Canada“By using the BI Accelerator for all of our future development we will ensure consistency in design and implementation. This also enables us to deliver functionally rich business solutions in a low cost and easy to maintain method.”
Dan BainbridgeTeam Leader – Data WarehouseShell Canada
Retail Analytics Solution
Business Situation•800 Shell retail locations throughout Canada.•Same site analysis is difficult/ Sales Mix•Hard to view the big picture•Not able to disseminate information to end users•Cannot pinpoint what factors effect revenue and cost
Solution Goals
•Empower end users to analyze their business•Provide consolidated reporting environment•Understand the factors that affect revenue and cost•Consolidate reports•Distribute reports efficiently and effectively•Flag areas of concern•Provide flexible analysis of attributes
•Category Analysis •Customer analysis •Promotion Analysis •Sale Mix•Same Site analysis
![Page 33: Business Intelligence Ulrika Leufvén System Engineer Microsoft AB Making Better Decisions Faster](https://reader036.vdocuments.us/reader036/viewer/2022062404/551beaac550346c3588b6296/html5/thumbnails/33.jpg)
Enmax Energy
Retail AnalyticsRetail Analytics SolutionSolution
Business SituationBusiness Situation•Deregulated market in 2001Deregulated market in 2001•New methodology for operation and settlement New methodology for operation and settlement •Analysis of Settlement data is time consumingAnalysis of Settlement data is time consuming•Hard for business users to identify problem areas Hard for business users to identify problem areas during settle processduring settle process
Solution GoalsSolution Goals•Need ability to do historical analysis to improve Need ability to do historical analysis to improve settlement forecastssettlement forecasts•Need to have better understanding of power usage to Need to have better understanding of power usage to decrease tariffsdecrease tariffs
•Settlement Analysis Settlement Analysis •Load Shape AnalysisLoad Shape Analysis•Customer Enrollment analysisCustomer Enrollment analysis•ForecastingForecasting
“This product also shaved 16-18 weeks of back-end plumbing development time off the project, by installing a solid infrastructure, allowing dimensional modelers to focus on building strategic business prototypes for key stakeholders. ”
Michael Matrick Vice President, Business Solutions Quadrus Development Inc