IBM Cognos 8 Analysis

IBM Cognos 8 Analysis

IBM Cognos 8 Business Intelligence Enables more users to make better, faster decisions Full range of BI capabilities: all user communities receive relevant information how, when and where it is needed Open enterprise-class platform: IT leverages a platform that cost effectively scales to meet growing user demands Frameworks and proven practices: projects get off to the right start with expertise to ensure success on the journey to performance management Office Mobile Web Reporting Analysis Dashboards Search Scorecarding

IBM Cognos Addresses Broad Analysis Needs Analytical Analytical Reporting Reporting Drill Drill Top down view Drillable reports Sort top & bottom Review then query Market shifts Product ranking Trending Trending Analytical Reporting Slice Slice and and Dice Drill Dice Personal exploration Compare & contrast Rotate and nest Work disconnected Sales trend analysis Market analysis Analytical Scenario Reporting Modeling Drill What-if Model scenarios Reorganize, reshape Compare scenarios Save versions Financial analysis Profitability analysis

Business users BUSINESS USER Personality Analysis isn’t their day jobs, but they seek more answers Like formatted or simple reports and help on what to look at Requirements Self serve for additional insight Access anywhere Simple, intuitive interface

Addressing Analysis – Analytical Reporting Analytical Reporting Drill Top down view Why isreports this Drillable Sort top & bottom customer Review then query performing poorly? Market shifts Product ranking IBM Cognos 8 BI Reporting Managed Reporting Ad hoc query BUSINESS USER Reporting & Query Guided analysis with prompted reports Managed pathways via context linkages (drill through, drill down, drill anywhere) Pre-built reports against OLAP sources Ad hoc analysis for BI

Light Analysis

Drill Down and Show me the Numbers

Reporting and Dashboarding

When Analytical Reporting is not enough BUSINESS ANALYST Personality Performs analysis on a more regular basis Answers questions for others Needs more freedom to explore information in new ways Sometimes has their own data and calculations Requirements BUSINESS USER Wants to see factors that determine performance over time Needs different views or perspectives of the same information Wishes to group sets of locations, products in unique ways Typically resorts to Excel to perform calculations they want

Addressing Analysis – Trending Trending Slice and Dice Analysis Personal exploration Why is the % Compare & contrast Rotate and nest growth in UK Work disconnected greater than Germany? Sales trend analysis Market analysis IBM Cognos 8 BI Analysis IBM Cognos 8 BI Café Express authoring Deep comparative analysis Easy exploration by business dimensions Side by side comparisons Multiple perspectives and heirarchies Filtering and custom sets Express authoring MS Office integration BUSINESS ANALYST

Deep Comparative Analysis Explore performance across multiple dimensions

Express Authoring

Express Authoring

Using the Office Mode to Access BI

Addressing Analysis – Trending Trending Slice and Dice Café Personal exploration Why is the % Compare & contrast Rotate and nest growth in UK Work disconnected greater than Germany? Sales trend analysis Market analysis IBM Cognos 8 BI Analysis IBM Cognos 8 BI Café Express authoring Leverage existing Excel skills to identify factors that affect performance from different points of view Navigate data as in Analysis Studio Save to central BI server for sharing Excel specific – cell based calculations, enter own data, build own formulae, etc Core data automatically refreshed Combine trusted data source and local data BUSINESS ANALYST And now can access Relational data

When Café is not enough FINANCIAL ANALYST Personality Lives for analysis of lots and lots of data, usually finance data Uses analysis to test new business hypotheses or scenarios Loves Excel for more than a custom formula here and there Wants to frequently restructure data and save versions of work Requirements BUSINESS ANALYST Wants to use Excel for almost everything they do Needs to create, destroy, save different versions of data Dislikes IT systems as feel they slow down or restrict them Sees little need to distribute results of their analyses broadly

Addressing Analysis – Scenario Modelling Scenario Modeling What-if Model scenarios Reorganize, reshape Why is product Compare scenarios margin low and Save versions what-if I change my approach? Financial analysis Profitability analysis IBM Cognos TM1 Scenario Modelling Determine new business approaches by evaluating alternate business scenarios Blend analysis with what-if development Quickly construct, deconstruct multiple models on very large data sets Write-back to secure governed location Familiar Excel interface with none of the downsides FINANCIAL ANALYST Integrated with Cognos 8

The three styles of analysis Broad Usage (Consumers) Analytical Reporting Drill Focussed (Financial Analyst) Trending Slice and Dice Scenario Modeling What-if Top down view Drillable reports Sort top & bottom Review then query Personal exploration Compare & contrast Rotate and nest Work disconnected Model scenarios Reorganize, reshape Compare scenarios Save versions Market shifts Product ranking Sales trend analysis Market analysis Financial analysis Profitability analysis IBM Cognos 8 BI Reporting IBM Cognos 8 BI Analysis IBM Cognos 8 BI Café IBM Cognos TM1

The three styles of analysis Broad Usage (Consumers) Analytical Reporting Drill Focussed (Financial Analyst) Trending Slice and Dice Scenario Modeling What-if Top down view Drillable reports Sort top & bottom Review then query Personal exploration Compare & contrast Rotate and nest Work disconnected Model scenarios Reorganize, reshape Compare scenarios Save versions Market shifts Product ranking Sales trend analysis Market analysis Financial analysis Profitability analysis IBM Cognos 8 BI Reporting IBM Cognos 8 BI PowerPlay IBM Cognos 8 BI Café IBM Cognos TM1

User Populations for Business EXECUTIVE BUSINESS MANAGER Fast access to relevant information to make better operational decisions OPERATIONAL LINE MANAGER Continuously monitor up-to-the minute operational KPIs to take corrective action CASUAL USERS Receive scheduled, personalised content and subscribe to most relevant to their role At-a-glance view of operational and financial performance FINANCIAL ANALYST Model various business scenarios to propose alternate plans BUSINESS ANALYST Freedom to explore and analyse data from multiple sources

User Populations for IT REPORT AUTHORS Provide timely, quality, relevant content to large, diverse community IT DIRECTOR Address business requirements and meet SLAs within budget DATA MODELLER & DATA ANALYST Reflect business needs in models and rapidly adapt to change CTO, ARCHITECT IT ADMINSTRATOR Proactively maintain quality of service to business even as user demands grow Fit with existing infrastructure standards and support evolution to enterprise SOA architecture

Cognos Software Services for C8 v4 Guardian Services Full Curriculum & Training Paths Migration & Upgrade Services Instructor Led Off-shore Services BICC Services e-Learning Customer Resource Center Online & Assisted Support Product Continuation

Thank You! Questions?