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
Alison Macfie, profile picture
Uploaded byAlison Macfie
473 views

Tdwi march 2015 presentation

This document summarizes a TDWI (The Data Warehouse Institute) meeting in Sydney, Australia in March 2015. The meeting agenda included a presentation on "Business Intelligence - A Self-Service Future?" by Patrick Spedding from Rocket Software. The presentation discussed the shift toward self-service business intelligence driven by factors such as mobility, analytics, and empowering individual users. It outlined how self-service BI is changing roles and organizations and what elements are imperative for self-service offerings. The document provided an overview and background of the meeting host, presenter, and topics discussed.

Data & Analytics◦
Related topics:
Advanced Analytics•
Welcome! TDWI Sydney Chapter March, 2015
2 The Data Warehouse Institute (Australian Chapter) is the premier source for BI and Data Warehouse thought leadership in Australia. This special interest group continues to attract a strong following from senior IT professionals in leadership, management and technical positions. TDWI Australia hosts regular member focussed technology meetings on a range of topics within the BI and MDM space. Using real life examples from our member base or from vendors and delivery partners – we strive to deliver proven thought leadership in helping technologists make informed decisions. TDWI member meetings attract a wide range of professionals with a vested interest in BI and MDM themes.
3 Today’s Agenda 5.30pm Welcome – TDWI Australia 5.35pm Presentation – Patrick Spedding Business Intelligence - A Self-Service Future? 6.30pm Refreshments and Networking
4 Welcome to Patrick Spedding Presenting Business Intelligence - A Self-Service Future?
5 Business Intelligence - A Self-Service Future? Patrick Spedding Managing Director, BI R&D Rocket Software
6 Agenda What is Self-Service Business Intelligence? Key drivers towards Self-Service Business Intelligence The issues with traditional BI Evolution of Analytics and Mobile: the new Sweet Spot How this shift has impacted roles/organizations Imperative elements for Self-Service offerings © 2014 Rocket Software, Inc. All Rights Reserved.
7 Digital Disruption: The Future of BI “By 2017, most business users and analysts in organisations will have access to self- service tools to prepare data for analysis.” © 2014 Rocket Software, Inc. All Rights Reserved. Gartner “Managed BI self-service will continue to close the business and technology gap.” Forrester “Visual data-discovery, an important enabler of end user self-service, will grow 2.5x faster than the rest of the market, becoming a requirement for all enterprises by 2018”. Forbes The balance of power in the BI and analytics sector is shifting from IT to general business users. But what does the democratisation of BI mean for business? What are the opportunities, challenges and pitfalls? And who are the real winners and losers? One Thing is Clear
8
9© 2014 Rocket Software, Inc. All Rights Reserved.
10 Digital Reinvention © 2015 Rocket Software, Inc. All Rights Reserved.
11 Shift from Cost Reduction to Growth/Transformation © 2015 Rocket Software, Inc. All Rights Reserved.
12 Individual-Centered Economy © 2015 Rocket Software, Inc. All Rights Reserved.
13 The Mobile Transformation © 2015 Rocket Software, Inc. All Rights Reserved.
141414 “Given the remarkably fast pace of innovation and change, if you’re not focused on speed, you’re dead in the water. Creativity without speed is useless. Old rules and standard operating procedures don’t lead to innovation” Speed “Today’s markets demand speed. Speed trumps all else.” (Nolan Bushnell “Finding the Next Steve Jobs”) © 2015 Rocket Software, Inc. All Rights Reserved.
15 Traditional Enterprise Analytic Architecture Copyright @ 2012 See-Change Solutions15 Analytical Structures Modeling Base Tables Scoring Base Tables Analytical Mart Warehouse Exploitation layer Data Integration Transformations Appliances Structured SAP Mainframe PSoft Windows Semi- Structured Other Sources Un- Structured Real Time High Volume Batch Web Services Message Queues Data Management LayerData Preparation Layer OLAP BI Analytics
16 Typical Information Architecture – A ‘Hoarding’ Culture Slow data stifles innovation…16 Analytical Structures Modeling Base Tables Scoring Base Tables Analytical Mart Warehouse Exploitation layer Data Integration Transformations Appliances Structured SAP Mainframe PSoft Windows Semi- Structured Other Sources Un- Structured Real Time High Volume Batch Web Services Message Queues Data Management LayerData Preparation Layer OLAP BI Analytics Flex
171717 We have lots of data… but are we making better decisions?? © 2013 Rocket Software, Inc. Data Sources ERP SCM CRM Data Warehouse GL GL GL Reporting And is this the result? Design and development issues Complex macros and formulas used to manipulate and derive calculation Data integration and quality issues Wrong data or wrong time Manually intensive and slow processes Data integration, error checking, progress checking, aggregation Invalid access and fraudulent usage Limited auditing and controls “Hidden cells”
18 A/NZ BI Survey - Results Copyright @ 2012 See-Change Solutions Yes: No: 89.94% 10.06% *Sample size = 228 Q: Are any of your existing query & reporting processes carried out using spreadsheets? 185 22 Yes (89.4%) No (10.4%) 87 133 8 Able to create (38.16%) Rely on others (58.33%) Able to create Rely on others No ability to create Q: Are business users across your organisation able to create their own ad-hoc reports, or do they rely on others to amend/change existing reports? 38.16% 58.33% 3.51%
19 The Double Revolution of Mobility and Analytics © 2015 Rocket Software, Inc. All Rights Reserved.
20© 2015 Rocket Software, Inc. All Rights Reserved. The Evolution of Information Gathering and Analysis
21© 2015 Rocket Software, Inc. All Rights Reserved. The Evolution of Information Gathering and Analysis
22 The Evolution of Information Gathering and Analysis © 2015 Rocket Software, Inc. All Rights Reserved.
23© 2014 Rocket Software, Inc. All Rights Reserved.
24© 2014 Rocket Software, Inc. All Rights Reserved.
252525© 2013 Rocket Software, Inc. "There's a great democratisation of data going on. Rather than the numbers belonging to the experts, they belong to all of us - and data journalism is part of that reclaiming of the facts." 1) This is a dataset 2) Here’s another 3) Here are some tools NOW GO BE SELF-SERVICE” “Anyone can do it. Data journalism is the new punk”
26 User Experience Driven Innovation
272727© 2013 Rocket Software, Inc.  Kanso – Simplicity  Elimination and omission  Shizen – Naturalness  Restraint: refinement over elaboration  Shibumi – Elegance  Elegant simplicity and articulate brevity Self-Service = Simplicity “The simplest way to achieve simplicity is through thoughtful reduction” (John Maeda)
28 Buyer/User Profile • Excel Savvy, mastering all functionality from pivot tables to complex function support • Well-versed in data and knows what enterprise systems they need to access for each business need Pain Points • Needs an easy to use data prep tool to easily connect to and enhance data • Looking to replicate excel functionality within dashboards Persona Profiles & Pain Points © 2015 Rocket Software, Inc. All Rights Reserved. Buyer/User Profile • Believes in analyzing data to support business decisions. • Reputation is on the line, needs to be able to make the right business decisions. Pain Points • Needs a quick and easy way to access all the data sources required. • Wants a simple tool that allows creation of dashboards at a moment’s notice. Influencer Profile • Burdened by demands of users throughout the org requesting visualizations. • Cares about system/data reliability, scale, security and worthiness Pain Points • Wants flexibility to run on- premise or in the cloud, one that’s easy to administer • Doesn’t want to hire more BI focused support staff C-Level Exec & Line of Business User Business Unit Controller, Business/Financial Analyst VP/Director of IT, Director of System Operations
29 From Complexity to Clarity © 2015 Rocket Software, Inc. All Rights Reserved. A Business Intelligence Solution for Line of Business Managers and Senior Level Executives who need an intuitive, self-service offering that empowers them to access any data and create visual interactive dashboards that expose trends, outliers, historical details, and information so they’re equipped to share information and make better, more informed business decisions.
30 End-to-End Self-Service Data Discovery © 2015 Rocket Software, Inc. All Rights Reserved. Business Need • Connecting disparate data across the enterprise • A single solution for enrichment & discovery • No time for data warehouse development • Access to siloed desktop sources From Desktop to Relational, MultiValue, Mainframe, OLAP, and more No need to purchase additional products Business Need • Intuitive environment to create dashboards • Easy and quick data exploration & analytics • Business user solution • Views for trending, outliers, comparison • Proactive notification of issues Self-service, Guided navigation, Drag-and- drop dashboard creation, One-click drilldown to pinpoint focused data Proactive pre-built analytic functions Auto Alerts for proactive action, Intelligent Filters Business Need • Easily share data views with team • Instant and live discussion within data portal • Ongoing communication on issues • Share with individuals, team, internal and external • Templating for reuse and easy adoption Instant messaging, share dashboards, personal & team annotations Create and share dashboard templates Share & Collaborate
31 Guidance for BI and Data Discovery Decision Makers © 2014 Rocket Software, Inc. All Rights Reserved. • Recognise that bring-your-own BI tools is an unstoppable movement (similar to BYOD) and will require IT, line of business, and analytics groups to collaborate closely while recognising each other's core competencies • Deploy fit-for-purpose tools to address different BI and analytics use cases such as performance management, operational intelligence, and visual discovery and exploration • Instead of development of BI/analytics assets, IT should focus on data governance, security, training, and vendor management Source: IDC DAT-A-GLANCE “Self-Service BI and Data Discovery, March 2015
32 Questions?
33 Thank You! Patrick Spedding Managing Director, BI R&D Rocket Software Connect with me. psedding@rs.com @spedding
Thank you Patrick Spedding. Thanks to IAG for hosting this evening’s meeting. Please stay and enjoy some time to catch up with friends and colleagues.