Business Analytics

1
Business Analytics

• Your Competitive Edge

2

• Do you differentiate between reporting and
  analytics?

3
Analytics Defined

• Transforming data into information, getting it
  into the right hands, at the right time and in
  the correct format to be used for timely
  decision-making

4
As Businesses Become More Complex

• End-to-end business management application
  installations
• Multiple branches, profit centers, business units
  and/or companies
• More than one remote location
• Traveling employees
• Possible integration with line-of-business
  applications and external data sources
• Companies with more than 100 employees and/or
  revenue more than 25 million
• Companies with internal IT staff

5
And Decision-making Becomes More Than an Art

• Lots of data but little information
• Silos of data
• Fragmented reporting
• Varying levels of aggregation
• Non analytical reporting
• Manual and slow reporting process
• Limited customization
• Getting right information to the right people at
  the right time
• Inability to allow users to self-service
• Alternative to all above is a huge expense

6
Just Reporting Solutions Are Not Enough
7
Dilbert Too Feels the Pain
8
The Businesses Are Focused Here
9
Which Translates To
10
To Summarize, The Needs Are

• Single view of truth
• Reporting performance
• Scalability
• Multi-dimensional analysis for a
  multi-dimensional business
• Data consolidation
• Secured access to information
• Reporting automation
• Customizability
• And more

11
Transaction System Reporting

• OLTP - Database optimized for data entry and not
  for data access
• ODBC, JDBC, OLE DB or proprietary interface
• Time sensitive reporting
• Burden on the transaction database

12
Data Mart Reporting

• Feed transaction data to data mart database
• Delayed but optimized reporting
• View data across multiple business dimensions
  (OLAP)
• Singular focus and scalability

13
Needs by Role
14
Needs by Usage
15
Enterprise Data Warehouse

• Combine data from multiple OLTP databases
  single source
• Business rules to source data including
  standardization, consolidation and cleansing
• Cost to implement

16
How Does Analytics Help?
http//www.gantrygroup.com/pdf/Gantry20BI20Trend
s20Presentation5_11.pdf
17
Where Does Analytics Help?
http//www.gantrygroup.com/pdf/Gantry20BI20Trend
s20Presentation5_11.pdf
18
Reporting and Analytics Options

• Sage Accpac Insight
• ACCPAC Query
• ACCPAC Sales Optimizer
• Sage Accpac Options Uni Sales Analysis
• ACCPAC Financial Link Professional
• ACCPAC CFO/KPI
• ACCPAC Financial Reporter (FR)
• Business Objects Crystal Enterprise/Reports
• F9
• Other (Cognos, Brio, SAS, Hyperion, etc.)

19
Apples vs. Oranges
20
Insight vs. Query

• Simple and quick
• No support for end-to-end applications
• No graphing, charting
• No external data sources
• No budgeting and consolidations
• No reporting automation and scheduling
• No drill-down
• No Web deployment
• No row/column level security
• No multi-dimensional analysis
• OLTP database based

21
Insight vs. Financial Link Professional

• Simple and quick
• Limited to General Ledger only
• No graphing, charting
• No external data sources
• No budgeting and basic consolidations
• No reporting automation and scheduling
• Drill-down but no drill-around
• No Web deployment
• No row/column level security
• No multi-dimensional analysis
• OLTP database based

22
Insight vs. Crystal Reports/Enterprise

• Generic reporting tool
• First five viewing users included for free
• Customization as complex as that in Insight
• No differentiation between financial and
  operational data
• No budgeting and consolidations
• Drill-down limited by report design
• No drill-around
• No row/column level security
• No multi-dimensional analysis
• OLTP database based

23
Summary

• Business Analytics
• Proactive information
• Faster and better-informed decisions
• Edge over your competitors

24
QA