1 / 24

Business Intelligence

Microsoft. Business Intelligence. Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions. Complete and integrated BI offering Widespread delivery of intelligence through Microsoft Office Enterprise grade and affordable.

tobias-schroeder
Download Presentation

Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Business Intelligence

  2. Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions • Complete and integrated BI offering • Widespread delivery of intelligence through Microsoft Office • Enterprise grade and affordable

  3. Pervasive BI Strategic Tactical Operational Execs Strategic Value Analysts/ Middle Mgrs Ops Number of decisions

  4. BI Applications and Analytical Clients DevelopmentTools BI Platform

  5. Analytic Applications (Office Business Applications) End-user Tools (Office) BI Platform (SQL Server) Complete Offering

  6. Microsoft Business IntelligenceAn end-to-end integrated offering Business Scorecarding (Business Scorecard Manager 2005) Scorecards, Analytics, Planning (PerformancePoint Server 2007) AdvancedAnalytics (ProClarity 6.1) Performance Management Applications Collaboration and Content (Office SharePoint Server 2007) End-user Analysis (Excel 2007) Analysis Analysis Services Reporting Reporting Services Integration Integration Services BI Platform SQL Server 2005 RDBMS

  7. Integrate Analyze Report • Data acquisition from source systems and integration • Data transformation and synthesis • Data enrichment, with business logic, hierarchical views • Data discovery via data mining • Data presentation and distribution • Data access for the masses Business Intelligence Platform

  8. Integration ServicesBreakthrough ETL Capabilities • Enterprise ETL platform • High performance • High scale • More trustworthy and reliable • Best in class usability • Rich development environment • Source control • Visual debugging of control flow and data • Great range of transforms out-of-the-box • Highly extensible • Custom tasks • Custom enumerations • Custom transformations • Custom data sources

  9. SQL Server Integration ServicesNew Paradigm for the ETL Platform • Data Cleansing • Provides data mining and AI expertise • Domain-independent data cleansing • Fuzzy lookup • Lookup on approximate matches • Do not reject if row could be correct! • Tune for best match • De-duplication • Eliminate approximate duplicates • “Windows XP”, “WinXP”, etc. • Tune for confidence • Managing Slowly Changing Dimensions • E.g. Sales organization changes • E.g. Customer movement • E.g. Product category changes

  10. Analysis ServicesEnhanced OLAP and Data Mining Capabilities • Unified Dimensional Model • Pro-active caching • Advanced Business Intelligence • Key Performance Indicators • Custom Aggregations and Semi-Additive Measures • Web services • Data Mining in the platform • Integrated Developer Tools • Failover Clustering plus… • Logistic Regression • Linear Regression • Text Mining Decision Trees Clustering Time Series Naïve Bayes Sequence Clustering Association Neural Net Introduced in SQL Server 2000

  11. Datamart Reporting Tool (3) Datamart Reporting Tool (2) Enterprise Business Intelligence (BI) – Today Data Source Data Model Tool MOLAP Online Analytical Processing (OLAP) Browser (1) MOLAP OLAP Browser (2) data warehouse (DW) Reporting Tool (1)

  12. MOLAP OLAP Browser (1) MOLAP OLAP versus Reporting OLAP Browser (2) Datamart Reporting Tool (3) Datamart Reporting Tool (2) Duplicate Data Duplicate Models Enterprise BI – A Messy Reality Data Source Data Model Tool DW Reporting Tool (1)

  13. Relational Versus OLAP Reports

  14. Relational Reporting OLAP Cubes • * Multiple fact tables • * Full richness the dimensions’ attributes • * Transaction level access • * Star, snowflake, 3NF… • * Complex relationships: Multi-grains, many-to-many, role playing, indirect… • * Recursive self joins • * Slowly changing dimensions • * Multidimensional navigation • * Hierarchical presentation • * Friendly entity names • * Powerful MDX calculations • * Central KPI framework • * “Actions” • * Language translations • * Multiple perspectives • * Partitions • * Aggregations • * Distributed sources The Unified Dimensional ModelThe Best of Relational and OLAP The Unified Dimensional Model

  15. OLAP Browser (1) OLAP Browser (2) Datamart Datamart Enterprise BI – With A UDM Data Source Data Model Tool MOLAP MOLAP UDM Reporting Tool (2) Reporting Tool (1) DW BI Applications

  16. OLAP Browser (1) OLAP Browser (2) Datamart Datamart Enterprise BI – With A UDM Data Source Data Model Tool MOLAP MOLAP UDM Reporting Tool (2) Reporting Tool (1) DW BI Applications A single dimensional model for all OLAP analysis and Relational reporting needs

  17. UDM XML/A or ODBO Analysis ServicesHigh-level Architecture Analysis Services Spreadsheets SQL Server Datamart BI Front Ends DW Teradata Ad Hoc Reports Rich Reports Oracle DB2 LOB Cache Dashboards

  18. Business Intelligence Enhancements Add data-aware “smarts” Autogenerated KPIs, MDX scripts, translations, currency… Data Mining 10 Mining Algorithms Smart applications XML standards for Data Access & Web services integration $$ saving for customers integrating our solution with other systems Unified Dimensional Model Powerful business information modeling Cross platform data integration Integrated Relational & OLAP views KPIs & Perspectives Proactive caching Real-time data in OLAP Cubes Very fast and flexible analytics SQL Server Analysis ServicesNew Paradigm for the Analytics Platform

  19. Business IntelligenceKey Performance Indicators • Calculations that drive visual indicators • Quick and easy way to “manage by exception” • Set and Monitor Goals • Monitor the trend, up or down

  20. SQL Server 2005 Analysis Services Data Mining • New Algorithms • Two enhanced • Eight new algorithms • New Visualizations • Enhanced tools • custom visualizations • Deep Integration • OLAP, DTS, and Reporting Integration • .NET programming model • Completely extensible framework

  21. SQL Server 2005 Analysis Services Data Mining • Banking • Anti-Money Laundering • Credit Risk Management • Credit Scoring • Customer Retention • Fraud Detection • Marketing Automation • Operational Risk Management • Performance Management • Risk Management • Web Analytics Service

  22. 8 new algorithms, 10 in total Graphical tools/wizards 12 embeddable viewers SQL Server 2005 makes it easier Tightly integrated with AS, DTS, Reporting Integration with Web/Office apps Business Knowledge Data Mining Relative Business Value OLAP Reports (Ad Hoc) Reports (Static) Easy Difficult Usability Value of Data Mining SQL Server 2005

  23. Complete Set of Algorithms plus… • Logistic Regression • Linear Regression • Text Mining Decision Trees Clustering Time Series Naïve Bayes Sequence Clustering Association Neural Net Introduced in SQL Server 2000

  24. SQL Server 2005 Analysis Services Data Mining • Decision Trees - Predict the odds that a future behavior will occur • Association Rules - Provides insight into relationships of certain actions • Sequence Clustering - Used to group or cluster data based on a sequence of previous events • Neural Nets - Training a neural network on historical data, neural network analysis can identify the most relevant characteristics and use those to classify applicants • Text Mining - Analyze the free text • Naïve Bayes – Show linkage between characteristics and metrics • Logistic Regression – A specialized variation of Decision Trees • Linear Regression – A specialized variation of Neural Nets • Time Series – Predict metrics (i.e., sales) based on patterns

More Related