Make data-driven business decisions

Hesham ElElamy – March 2023

 Hesham ElElamy

Partner Technical Specialist – Data & AI

2
• Data-driven companies & Challenges

• Business Analytics Portfolio

• What’s new in Business Analytics at IBM

• Customer Success stories

• Demo – Analytics Content Hub

 Data drives
innovation in
enterprises

4
Your data nerds used
to just be your business Sales
Rapidly respond to
HR
Attract and retain top
analysts and data changing client needs to talent by engaging

scientists.

Now, everyone needs Marketing IT

access to consumable Discover fast changing
customer behavior for
Innovate and modernize
apps and infrastructure for

data for .

Finance Operations
Set reliable forecasts in Continuously improve
volatile conditions for automated processes for
All employees should use for business decisions

Information consumers Don’t use data regularly

Data explorers

Data analysts

Data scientists

About of all employees use data

 EXPECTATION REALITY

Data is in data and the business

Strategy linked to to quickly react

Line of business is on IT

Decisions drive of data/forecast

Business Analytics
 – IBM Business Analytics
Make data-driven business decisions

• Empower every user regardless of skill

• Provide a single point of entry, even in a

siloed world

• Streamline collaboration across organization

• Start with the key capabilities and grow over

time
A solution for every

PLAN, BUDGET AND FORECAST BUSINESS INTELLIGENCE CLOSE, CONSOLIDATE AND REPORT

Break down business unit silos and Clean and connect your data, create Enables finance teams to automate and
quickly create more accurate plans and stunning data visualizations, and show accelerate the financial close with
forecasts all in one platform. where your business is today while minimal IT support.
helping predict what will happen
tomorrow.
IBM Planning Analytics
Start anywhere and go everywhere

Workforce planning IT portfolio planning

Headcount and staffing planning Project planning
Salary & compensation planning IT budgeting

Demand planning Financial planning & analysis

Supply chain planning Strategic planning
Sales & operations planning Capital planning
Inventory planning Expense planning

Promotion planning Sales forecasting

Revenue planning Sales territory planning
Customer profitability Sales quota planning
Customer churn analysis Sales capacity planning
Good decisions are
R&D

Marketing

lead
Inventory
to coordinated execution and
Sales
greater business
performance
Capital Production

Financial

Logistics

Procurement
IBM Cognos Analytics
Cognos Analytics with Watson

Consumer Business analyst

Create Prepare

Visual self Enterprise

Decisions
service thinking

Consume Analyze

Data scientist/steward BI author/developer

Spectrum of analytics users, license roles and personas

Data Scientists and Data Architects

Data
Scientists

System Cognos Analytics Administrator

Administration, Security, Performance Tuning
Administrators
Level of Sophistication

Power Users Cognos Analytics Explorer

Business and Financial Develop interactive reports, Data Exploration, Ad-
Analysts hoc query, Create dashboards & reports,
View/interact with dashboards & reports

Knowledge workers
Employees, Clients, Partners, Suppliers Cognos Analytics Users
Data exploration, Scheduled Reports,
Guided Reporting, Interactive Reports,
Consume Dashboards

Information Viewers and Mobile Consumers Viewer or Mobile

View scheduled or bursted reports,
View interactive dashboards

Number of Users
Cognos Controller
 different
COAs and
GAAP

different
functional
currencies

Consolidated
intercompany IBM Cognos Controller financial
transactions
statements

ownership
adjustments

multiple
legal entities
What’s new
in Business Analytics at IBM
PLAN, BUDGET AND FORECAST BUSINESS INTELLIGENCE CONSOLIDATE AND PERSONALIZE

IBM Planning Analytics IBM Cognos Analytics IBM Analytics Content Hub
Break down business unit silos and Clean and connect your data, create All the Analytical content in one place
quickly create more accurate plans and stunning data visualizations, and show with personalized experience for all
forecasts all in one platform. where your business is today while users.
helping predict what will happen
tomorrow.
 Support Content Connectors
CONSOLIDATE AND PERSONALIZE
Out of the box, IBM Analytics Content Hub supports a variety of
different connectors that enable communication between the
IBM Analytics Content Hub sever and various, market leading,
business systems.

Business Intelligence Platforms Content Systems

1. IBM Cognos Analytics 1. Box

2. IBM Cognos 10 2. File System
3. IBM Planning Analytics 3. Google Drive
4. IBM TM1 4. Microsoft SharePoint
5. Looker 5. Microsoft SharePoint
6. Microsoft Power BI Online
7. Microsoft SSRS 6. Microsoft OneDrive
8. MicroStrategy
9.
10.
Oracle BI (OBIEE)
Qlik Sense
IBM Analytics Content Hub
11. Qlik View
12. Salesforce CRM All the Analytical content in one place
13. SAP Analytics Cloud with personalized experience for all
14. SAP Business Objects
15. Splunk users.
16. Tableau
17. ThoughtSpot
18. TIBCO Spotfire

For scenarios where a connector is required that isn’t available out of the box, the IBM Analytics Content Hub also enables
organizations to build their own connectors, using the Connector SDK, and plug the new system into the IBM Analytics Content Hub
architecture.
Customer Success Stories
 American
University of
Cairo
Outcome
Using data to Business Challenge
In order for AUC to reach their goal of providing access to
⎻ Make students lives better, easier, and
allowing them to be more effective and
improve the data, they had to ensure that data governance and security successful.
⎻ Allowing decision makers/stake-holders
university were both properly in place, data standards and definitions
were well laid out, and were able to provide all
to make better informed/data driven
decisions.
experience stakeholders with access to data.
“As long as you have the right
Solution platform and the right support, the
AUC deployment a business intelligence platform along sky's the limit.”
with Cognos and Db2 Warehouse on Cloud to support Dr. Iman Megahed
decision makers/stake-holders to make better decisions Chief Strategy and Institutional
Effectiveness Officer
based on information. The business platform runs on
batches of information nightly from the data warehouse
which then transforms the data points into KPI’s. These Solution Components
⎻ IBM Cognos Analytics
KPI’s are then visualized by Cognos. ⎻ IBM Db2 Warehouse on Cloud

Industry: Education
Geography: Middle East & Africa
 Outcome
Makes planning on Business Challenge ⎻ Focus on optimizing the technology
Ancestry was looking for an enterprise performance as opposed to managing the
the IBM Cloud part management solution for its financial planning and infrastructure.
of their DNA analysis (FP&A) processes, the company needed a ⎻ Positive uptime and site stability.
⎻ Access to real-time information.
tool that could handle its “super-cube,” which held
51 quintillion cells of data. “We've had a great partnership with
IBM and Data 41 to really drive our
Solution usage forward. And you get the most
value out of planning analytics”
The Ancestry team looked at seven different
products before choosing IBM Planning Analytics, Curtis Tripoli
VP, Financial Planning & Analysis
powered by IBM TM1 to accommodate the Ancestry

company’s super-cube of data.

Solution Components
⎻ IBM Planning Analytics on the IBM
Cloud

Industry: Computer Services

Geography: North America
Aliaxis Group

Business Challenge Outcome

Implementing a The Brussels-based corporate finance department of rapidly growing industrial
⎻ Implemented corporate performance
leader Aliaxis Group was managing the group consolidation, reporting,
Business Analytics budgeting, and forecasting processes using an old instance of IBM Cognos management automation that was
essential for the fast close process
Controller, almost out of support. The introduction of a monthly fast-close
and Corporate process and changing transfer pricing requirements made the need for a ⎻ Automated management reports are
linked to the operational processes and
future-proof business analytics solution and corporate performance
Performance management even more urgent. fully integrated in a financial reporting
and planning solution
Management Solution
The team designed and implemented a completely new instance of IBM
program with IBM Cognos Controller that provided an integrated consolidation model, using Solution Components
actual data provided from the corporate data warehouse and serving as the
Cognos sole solution for the consolidation process. The solution allows for a fully ⎻ IBM Cognos Controller
automated data upload process, replacing the previous manual upload, and
provides an efficient and reliable solution for the budgeting, planning, and
forecasting processes. The successful implementation of the Business
Analytics and Corporate Performance program enabled Aliaxis Group to
significantly add value to its analytical capabilities, both for regular business
users and expert controllers.

Industry: Industrial Products

Geography: Europe
Demo - Analytics Content Hub
 Q&A
Thank you
 References
• http://download.1105media.com/tdwi/Remote-
assets/Events/2017/Chicago/ExpertSpeaker-Self-Service-
Analytics_ECKERSON.pdf

• Aberdeen report: The ROI of sales planning analytics

• IBM Watson Advertising internal campaign results

• Amplified FP&A: Harnassing Analytics To Link Strategic With Operational

Planning

• ZX Ventures Case Study: https://www.ibm.com/case-studies/zx-ventures

• GameStop Case Study: https://www.ibm.com/case-studies/GameStop-2

• Deloitte Canada Case Study: https://www.ibm.com/case-studies/deloitte-

canada-analytics-data-lake
• https://www.idc.com/getdoc.jsp?containerId=US47139921