Skip to main content
UploadLanguage (EN)Support
BusinessMobileSocial MediaMarketingTechnologyArt & PhotosCareerDesignEducationPresentations & Public SpeakingGovernment & NonprofitHealthcareInternetLawLeadership & ManagementAutomotiveEngineeringSoftwareRecruiting & HRRetailSalesServicesScienceSmall Business & EntrepreneurshipFoodEnvironmentEconomy & FinanceData & AnalyticsInvestor RelationsSportsSpiritualNews & PoliticsTravelSelf ImprovementReal EstateEntertainment & HumorHealth & MedicineDevices & HardwareLifestyle
Senturus, profile picture
Uploaded bySenturus
3,714 views

The Business Value of Business Intelligence

The document outlines a webinar by Senturus, a consulting firm specializing in business intelligence (BI) and corporate performance management, highlighting the business value of BI. It covers various case studies, technical solutions, and tools used in BI, such as data mart and dashboards, emphasizing their role in improving decision-making and operational efficiency. Upcoming events and resources are also mentioned, along with contact information for further inquiries.

Data & Analytics◦
The Business Value of Business Intelligence www.Senturus.com Helping Companies Learn From the Past, Manage the Present and Shape the Future
This slide deck is part of a recorded webinar. To view the FREE recording of this entire presentation and download the slide deck, go to www.senturus.com/recorded-webinars.php You will find this—and many other recorded webinars-- under the “Business Intelligence 101”
Agenda 1. Introduction 2. BI Business Case Studies 3. Introduction to BI Architectures & Approaches 4. Demonstration: OLAP Cube Building 5. Upcoming Events, Resources
Introductions Senturus, Inc. – John Peterson • Co-Founder, Chairman & COO • jpeterson@senturus.com – Barry Bisson • Solutions Architect, BI Practice • bbisson@senturus.com – Jim Frazier • Vice President, Sales • jfrazier@senturus.com
Who is Senturus ? • Consulting firm specializing in Corporate Performance Management – Business Intelligence and Enterprise Planning – Platform-independent • Service Offerings – Complete project implementations – Staff augmentation – Assessment and Roadmap consultations – Upgrade & Support packages – Training: • Classroom, Onsite, Remote, Mentoring, Workshops & Webinars • Led by professional trainers and seasoned consultants • Experience & Credentials – 400 clients in a range of industries and geographies – IBM Cognos Platinum Partner, Microsoft Solutions Partner
A few of our 400+ Clients
Shutterfly Objectives • Engage budget owners in variance analysis (BvA) • Trim 5 - 7 days from quarterly close Key Steps • Deployed planning system • Built data mart to consolidate ERP and plan data • Built front-end dashboard tool for plan contributors Technical Solution / Tools (1) Planning system – Cognos Enterprise Planning (2) Data mart – Microsoft SQL Server 2005 (3) BI portal – IBM Cognos 8 BI with Cubes
Finance Data Mart Dashboards Drill to Details Reports Scorecards ERP KPIs Planning GL Oracle Host Analytics SAP Data Mart Cognos Planning Great Plains Hyperion Essbase Lawson Single Source OutlookSoft of Truth JD Edwards Spreadsheets Scenarios: Daily Update “ What If ”, of Actuals Historical
This slide deck is part of a recorded webinar. To view the FREE recording of this entire presentation and download the slide deck, go to www.senturus.com/recorded-webinars.php You will find this—and many other recorded webinars-- under the “Business Intelligence 101”
CRC Health Group Objective • Enable management to compare staffing mix / levels across lines of business and regions Key Steps • Normalize FTE measurements • Map job titles into standard classifications • Integrate data from GL, Payroll, Revenue, Scheduling Technical Solution • Metrics developed: (1) Productive FTEs, (2) Patient Days • Tools leveraged: (1) Data Mart – Microsoft SQL Server 2005, (2) BI portal – IBM Cognos 8 BI with PowerCubes
Labor Data Mart Dashboards Reports Scorecards ERP / GL POS / Transactional Systems Scheduling Systems Labor Mart HR Systems Time Card Systems Payroll Systems & Services AlterPoint Confidential
Labor Dashboard: Overtime
Labor Report: Budget vs. Actual
CRC Results Labor Analytics • Visibility into labor costs by region, by business unit • Ability to compare staffing mix & levels • Promotes sharing of best practices across regions • Over $1M in savings in first year
Other Examples • BBB • Marketing Analytics • Customer & Product Profitability • GL Reporting • Supply Chain / Procurement • HR Analytics • Lead & Opportunity Analysis • Inventory Management
Typical Scenario • All along the value chain, people and systems are generating transactional data • These operational systems are designed for data input & transaction throughput …not for reporting and analysis CRM Planning HR Order Mgmt Budgets Sales Forecasts Labor Costs Sales Territories Customer Contacts Manufacturing Bill-to & Ship-to Line Items Ordering Codes Returns BOMs Production Costs Financials - GL Actuals Each system has the “best” data, with granular details for its Allocations own domain: different versions of truth
Operational Data Source: ERP System • Normalized data structure with thousands of tables built for processing transactions • Obscure table & column names, convoluted hierarchies make analysis & reporting a challenge
Manual ‘Integration’ Heroics • Each system is a separate silo, with different data, incompatible structures, no easy way to link it all together • The result is “Excel hell”, or a garden of homegrown MS Access databases, data dumps and flat files • Manual, time-intensive “point solutions” are costly, inconsistent, and unreliable • Business users unable to leverage timely strategic data across the enterprise Pulling Data Together is a Manual Process
This slide deck is part of a recorded webinar. To view the FREE recording of this entire presentation and download the slide deck, go to www.senturus.com/recorded-webinars.php You will find this—and many other recorded webinars-- under the “Business Intelligence 101”
From Transactions to BI Value Dimensions (Attributes) Measures (Metrics) Date Time Store Product, etc. Qty Price Cost Margin, etc. Added (Rolled-Up) Date Averaged Year Store ID Calculated Product ID … Quarter Store Name Product Name Month Store District Product Class • Most organizations have Week Store Region Product Line mountains of good data Day Store Mgr Product Weight Day name Store Age • It is unavailable, or not well- Shipping Cost … … structured for business users … • BI models and tools render business value from this data BI models & tools render business value from existing data
Dimensions & Hierarchies Calculations & Product Product Consolidations Line Channel Class Margin, Roll-ups… Product District Subclass Measures / Facts Amount, Quantity Store Product (SKU) Units = 10 Price = $17,525 Cost = $8,000 New Region Old Region Day Season Week WTD Territory Versions Scenarios Month MTD Sales Rep Quarter QTD Actuals Year YTD Forecast Period 1 Period 2
ETL These data fields……………………………..……..from these systems Account ID / Customer ID • Billing Order Date / Invoice Date / Ship Date / Paid Date / Return Date • Shipping Sales Rep -> Sales Manager -> VP Sales (last year vs. this year) • Manufacturing Cost of Sales -> Sales Channels (direct & indirect) • CRM Product Cost (by Line Item) / Shipping Cost (by Order) • ERP SKU -> Product Class -> Product Line (last month vs. this month) • GL • Partner Data …can be magically transformed into strategic information, suitable for making management decisions ! • Accurate rollups and calculations require that data be granular at the same level. • Source systems use and store data in different ways, not at the same grain, not in the same format, not following the same business rules. • ETL (aka Data Integration) extracts data from different sources, transforms it into meaningful measures at the right granularity, adds business dimensions and hierarchies
Architectural Approaches (Evolutionary Stages – Can Overlap) • Direct Reporting against Operational Databases • Reporting Instances and Views • Data Warehouse and ETL Layer • Metadata Layer • Self-Service Portal • OLAP Cubes
Reference BI Architecture MS SharePoint, Cognos Connection, BOE Portal Presentation Layer Reporting BO Crystal Query Report Studio Services Web Client Enterprise Studio Cognos Cognos MS OLAP Cubes Hyperion PowerPlay TM1 SSAS Essbase Metadata Layer BO Universe, Cognos Framework Manager Data Warehouse Microsoft SQL Server Oracle MySQL IBM DB2 or Data Marts ETL Layer MS SSIS, Informatica, Pentaho Source Data ERP External Excel In-House Systems Sources Spreadsheets Systems
Multi-Dimensional OLAP Cubes One cell = intersection of each dimension Dimension Value Date Jan Version Dimension Dept 200 Budget Actual Account 6100 Department Dimension Version Actual 200 … Account Dimension 6100 300 Measure Value 6200 400 Amount $1,000 6300 500 6400 Jan Feb Mar Apr Date Dimension
BI Workshop Topics • Technologies • MOLAP, ROLAP • Metadata models Topics • ETL tools for • Reporting & dashboarding tools Discussion • Solution Architectures • Data Mart vs. Data Warehouse • In-memory cubes vs. persistent data store • Self-service vs. content distribution • Business Processes • Source data integrity • Master Data / Metadata management • Project & road map philosophies • Competencies & training
Vendor Comparison – BI Offerings Component Microsoft Cognos Business Objects Oracle Data Integration SQL Server Integration Data Manager Business Objects Warehouse Builder Services (SSIS) Data Integrator (OWB) Data Aggregation SQL Server Analysis PowerPlay Aggregate tables or Essbase, OLAP (OLAP) Services (SSAS) Transformer 3rd party (e.g. SSAS) Option in DBMS Data Abstraction SSAS Designer, Model Framework Universe Designer BI Server Modeler, Modeling Designer (limited to Manager, Essbase Modeler Report Builder) Transformer Report Authoring SQL Server Reporting Report Studio Crystal, BI Publisher, Services (SSRS), WebIntelligence Financial Rpting Excel2007 Analysis Tool PerformancePoint Analysis Studio, WebIntelligence, BI Answers, Analytics (ProClarity), PowerPlay Studio Voyager Essbase Excel 2007 PivotTables (external data) Ad hoc Report Builder, Query Studio, WebIntelligence BI Answers Query/Report PPS Analytics, MS Query Analysis Studio Dashboard PerformancePoint Report Studio, Xcelsius, BI Interactive Authoring Dashboard Designer, Metrics Studio Dashboard Builder Dashboards SharePoint Excel Services Scorecard PerformancePoint Metrics Studio Xcelsius, BI Interactive Authoring Dashboard Designer Dashboard Builder Dashboards Portal SharePoint Cognos Connection Business Objects BI Portal Enterprise Portal
OLAP Cube Building Demonstration To view a free recoding of this demo, go to www.senturus.com/recorded-webinars.php You will find this recording under the Business Intelligence 101 section. It is entitled The Business Value of Business Intelligence.
Upcoming Events & Resources Business Intelligence Workshop • Extended half-day session – September 16 • Hands-on experience with real BI tools On-line Resources • http://www.senturus.com/events.php • http://www.senturus.com/recorded-webinars.php
Senturus PITM Offer • “Prove it to Me” package • Prototype dashboard / report • Package includes: – Requirements analysis, tool selection for prototype – Population of dashboard / report with your sample data – Demonstration of prototype solution – Proposal for production implementation • Rapid Proof of Concept to demonstrate business value • 3 - 5 days, start to finish
Next Steps To discuss how the Senturus “Prove it to Me” offer could help demonstrate the value of BI in your organization, please contact : James Frazier, Vice President of Sales: jfrazier@senturus.com (650) 949-2921 To request a soft copy of this presentation, please contact: sales@senturus.com
This slide deck is part of a recorded webinar. To view the FREE recording of this entire presentation and download the slide deck, go to www.senturus.com/recorded-webinars.php You will find this—and many other recorded webinars-- under the “Business Intelligence 101”
Contact Senturus Senturus, Inc www.senturus.com sales@senturus.com 888-601-6010
The Business Value of Business Intelligence