business intelligence

BI Innovations

DATA WAREHOUSING

Business Intelligence and

The Opportunities

• Leaders not given sufficient information to make strategic decisions

• Overwhelmed with too much data

• Conflicting data. No one single version of truth.

• 75% companies fail due to inability to execute well-formed strategies

Today’s Business Intelligence Opportunities

How can we be strategically focused and leverage our IT assets?

Ad-hoc queryBusiness Analysis

- Business Performance

Visualization, Dashboards Collaboration

Performance Framework

Corporate Performance Management (CPM)

Advanced VisualizationTools

Multi-dimensional Analysis Tools

Web Reporting

- Process Monitoring- Customer Performance

High level Analysis

Collaboration

Business Software Evolution

Phase 1 : Storage & Archive

To give management data for day to day management

Manual Data Retrieval

Phase 1: Manual Information Processes

Spread sheet report fordecision making

Semi-Manual Report Preparation

Phase 2 : Discrete System ReportingPhase 2: Separated Applications & Databases

Data marts. Mid-size Data warehouse withBusiness Intelligence

Enterprise Data Warehouse. Business Intelligence and Data mining capabilities

Large database

OLAP On-line Analytical Processing (Query, Dice & Slice, Drill-Down)

Phase 3 : Data Warehouse and Mining

Storage Types

Phase 3: Information Integration

Browser

Internet

Mobile

Extranet

Intranet

Phase 4 : Intranet & InternetPhase 4: Mobility and Access Everywhere

Business Intelligence Evolution …

Phase 5: 360-Degrees Performance Management

• ETL processes unify information from different systems

• Data warehouse stores data in standardized form

• Management dashboards channel information effectively and efficiently to management

• KPI scorecards allow continuous monitoring of strategic execution

• Information access via intranet, internet, virtualized and mobile systems

Complete BI Front-End OLAP Analysis

Advanced Visualization

Tools

Certified by :- Veritest- WinQual Microsoft

BI Tools BI Reports

+

Performa BI Suite

Business Intelligence Suite Benefits:

BI Reports

BI Tools

Drive data consistency and quality Build and share powerful analytics Harness the wealth of available data Make faster and better decisions Deliver single business views across the enterprise Optimize IT resources and productivity

Rich visualizations without complex programming View multiple performance metrics on single screen Greater visibility into critical business information Align everyone towards common goal Enhance collaborative environment Minimum training with user friendly interfaces

• Advanced Visualization Tools

• Patent pending technologies

• Step-By- Step tools. No programming

• Create KPI’s for monitoring

• Complete BI control sets

• Export to Excel, Word,

• Power Point, Email

• Web- Experience – AJAX

• Fast and easy set-up

BI Tools Features

“The latest innovations in BI Visualization tools with patent pending technologies”

BI Tools: User Friendly Type Animation For Menu Selection

BI Tools Features

BI Tools: Alert Buttons on Maps, Gauges and Charts

BI Tools Features

BI Tools: Dashboards with different chart Types

BI Tools Features

BI Tools: Dashboards with ad-hoc analysis capabilities

BI Tools Features

BI Tools: Interactive Organization Chart

BI Tools Features

BI Tools: Strategy Map (Balanced Scorecard)

BI Tools Features

BI Tools: KPI Scorecards By Departments and Individuals

BI Tools Features

BI Tools: KPI By Processes

BI Tools Features

BI Tools: Inventory Management Dashboard

BI Tools Application

BI Tools: Sales Performance Dashboard


BI Tools: Quality of Service Monitoring


Dice and slice

• Ac-hoc Query, Multi-Dimensional Analysis

• Data manipulation and Exploration

• Web Reporting and collaboration

• Drag-n-Drop Pivot Tables

• Indicators and color code

• Export to Excel, PDF, email

• Web- Experience – AJAX

• Rapid deployment

BI Reports

BI Reports Features

BI Reports : 3 D Chart, Business Calculations

BI Reports Features

BI Reports : Color Coded Performance Indicators

BI Reports Features

BI Reports : Graphical Performance Indicators

BI Reports Features

BI Reports : Color Coded Cells For Performance Indicators

BI Reports Features

BI Reports : Histobars (Relative Amounts)

An Integrated platform providing

Advanced Visualization

1.

Provide KPIInformation

2.

Employee Collaboration

3.

BusinessAnalysis

4.

Business Rules& Calculations

5.

WebReporting

6.

Business Intelligence SystemDesign Features

Scalability Interoperability

Availability SecurityManageability

BI PORTAL

Business Intelligence

eB

usin

ess A

pp

licatio

ns

Business Intelligence Dashboards

PeformaBusiness Intelligence Suite

Multidimensional Analysis

iCubeOLAP

Data Warehouse

Business Intelligence

Access S

ecu

rity

ERP RDMSDesktop CRM External DataMain frame

Financial Customer

& Growth ProcessLearning Internal

Sales Dashboard

Set Targets

$120 M

Aus

t.

N.Z

.Ja

pan

S’p

ore.

H.K

.

Config. Chart

MTD SALES

Performa : BI TECHNOLOGY

Performa BI Suite Architecture

OLAP Market Share by www.olapreport.com

Performa is based on Microsoft OLAP technology

BI Suites: Competitive Analysis

Top reasons to choose Performa BI Suite

“You can now experience the power and benefits of Enterprise BI Suite at affordable pricing with Performa”

Analytics, Dashboards, Reporting, KPI’s all bundled into ONE SINGLE product

Best ROI and pricing (Enterprise BI Suite at `Non-Enterprise’ pricing)

Commercial- The BEST pricing

Equivalent or more features compared to typical Enterprise BI Suite

User friendly interface- Minimal user training Robust, scalable and proven platform - High performance Latest and proven technologies (.Net, AJAX) Patent pending technology (USA) Web-based browser (100% thin client) Rapid deployment and easy maintenance

Team of experienced and dependable professionals in BI and Data Warehouse

Technical- The BEST BI Suite

Professional Services- Experienced and Dependable

BI Reports Features

BI Reports : 3 D Chart, Business Calculations

Size Efficiency: Foodmart Cube: 4.43 MByte

Application - HR Workforce

Application – Government Depts & Agencies

Strategic planning and KPI settingStrategy implementation and executionProgram implementation and executionCustomer satisfaction surveysProcess turnaround time monitoringStaff workload and performance monitoringVendor service level and delivery monitoringBudgeting and cost control

Application – Municipalities/ Local Governments

Revenue planning and managementQuit rent collection monitoringVendor management and Quality of Service monitoringHealth, environmental and disease controlBusiness and population censusLicensing and renewal monitoringCost budgeting and controlSafety and crime monitoring

Application – Telecommunications Industry

Market, user behavior and competitive studiesCustomer, revenue and usage analysisCredit control and collection monitoringVendor management and Quality of Service monitoringInfrastructure maintenance and cost analysisMobile maintenance teams - usage and job analysisSafety and health incident monitoringOutage and response time analysisCost budgeting and control

Application – Retail & Supermarket Services

Market and competitive studiesCustomer, revenue and purchasing behavior analysisProduct profitability & gross margin analysisInventory control and monitoringOverheads budgeting and controlBranch/agency performance and cost analysisWorking capital usage and profitability reporting

Application – Banking & Financial Services

Market and competitive studiesCustomer, revenue and behavior analysisProduct profitability & margin spread analysisCredit control and collection monitoringOverheads budgeting and controlBranch/agency performance and cost analysisPortfolio growth and profitability reporting

Application – Construction & Property Dev.

Property market and competitive studiesSales uptake and unit analysisProject/ phase profitability & cost analysisFinancial cost control & monitoringOverheads budgeting and controlSub-contractor performance and delivery analysisMachinery maintenance & usage controlMaterial & inventory control

Mitsui

MINDEF

Performa has been used in…

Our users at DHL Asia Pacific (> 20 countries) found the DataMIcron’s Performa user friendly with functionality that meet our requirements. I am confident Performa has the potential in the global market place.

Ganesan ThambipillayHead-Account Mgmt

Yong Tong NyeSenior Manager IT Dept

It has been 3 years that Epson use DataMicron’s Performa, and the IT Dept found it to be very stable and easy to maintain. The 200 users find it very useful in multi dimensional analysis.

Khairilanwar Abd. HamidGeneral Manager ICT

My experience with DataMicon has been encouraging. At my previous company, Time Reach the implementation was very successful. Now at CIMA, we have just awarded DataMicron to implement our BI project based on good track record.

User Testimonials

Overall Solution Architecture

Plant-ware Accpac Budget

Other data sources (eg

using Excel)

DATASOURCES

DATAWAREHOUSE

Microsoft Analysis Services

Microsoft Data Services

OLAP Cube

Microsoft Integration ServicesDATA EXTRACTION,TRANSFORMATION

& LOADING

Red Book Excel Files

Red BookExcel Files

THANK YOUTHANK YOU

business intelligence

Technology

bi visualization tools

processes bi tools features

charts bi tools features

individuals bi tools

easy setup bi tools

step tools

performa bi suite

management data