Management Control

Topic 8:
Business Strategy and Data Analytics and Visualization

Adjunct Lecturer: Chamnab Nhel

Academic Year: 2024-2025
OVERVIEW

1. Overview of Business Strategy 5 Minutes

2. Data Analytics Overview

25 Minutes

3. Data Visualization Overview

4. Demo: Data Visualization Via Tableau 5 Minutes

5. Keys Takeaway and Q & A 10 Minutes

1
1. Overview Business Strategy: A Definition
What Is A Competitive Advantage?
What Is Good Strategic Management?
1. Objective
2. Scope (What, How, Where, for Whom).
3. Logic Of Advantage.
Microeconomics And Value Creation.
Good Strategies Are Built On Strong Arguments
Good Strategic Statement?
Good Strategies Require……..
Competing For Uniqueness.
2. Data Analytics Overview

Source: https://www.visualcapitalist.com/how-much-data-is-generated-each-day/ 2
 Global Market Trend

Source: https://www.grandviewresearch.com/industry-analysis/data-analytics-market-report 3
 3 Types of Data Analytics
“The use of math and statistics to drive meaning
from data to make better business decisions.”
Prescriptive
Analytics
How Can We
Make It Happen?
Predictive
Analytics
What Will
Happen?

Value
Diagnostic
Analytics
Why Did It
Happen?
Descriptive
Analytics
What
Happened?

Difficulty

4
Business Intelligence vs Analytics

5
 Top 10 Fortune Companies in 2023
$638.78 B
1
$554.02 B
2 Ex: Amazon uses predictive analytic for
3 $502.35 B (trends, patterns, exceptions) of
customers' historical shopping data to
4 $473.53 B predict the probability of a customer to
buy a product with the date-time
information
5 $435.3 B

6 $401.77 B

7 $383.28 B
Ex: Optum uses business and data
8 $359.98 B analytic for prediction of disease, early
detection of disease and discovery of
9 $347.8 B new drugs.
10 $346.17 B

Source: https://www.statista.com/statistics/263265/top-companies-in-the-world-by-revenue/ 6
BI Analyst Jobs Market Trends 2024

7
Digital Skill Roadmap In Cambodia

8
3. Data Visualization Overview

9
3. Data Visualization Overview

10
Data Visualization: CMO Dashboard

11
Data Visualization: CIO Dashboard

12
Data Visualization: CFO Dashboard

13
 Data Visualization: Manufacturing Dashboard
Overview 2023 On Time in Full Deliveries (OTIF)

Inventory Turnover Average OOS Rate Average OTIF Rate In Full Deliveries On Time Deliveries
In Full on Time Deliveries
100% Average in Full Rate
13 2 90.5% 90
80%

60%

18.9 4.2% 75.3% 90 40%

20% Average on Time Rate

78.8% 90
0%
W 1'23 W 2'23 W 3'23 W 4'23 W 5'23 W 6'23 W 7'23 W 8'23 W 9'23

Out of Stock Rate ( OOS) Inventory Turnover (in Days)

4.6% 4.9% 4.9% 4.8%

4.0% 5.3% 4.9% 4.3% 19.5 Inventory to
3.3% 4.5% 17.3 17.9 12,8
2.8% 3.2% 3.5% 4.2% 16.7 Sales Ratio
2.6% 14.5 11.2 14.2 13.5

Average
Mon Tue Wed Thu Fri Sat Sun 00 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 19,4 Inventory Turnover
by day of the week by hour of the day
2016 2017 2018 2019 2020 2021 2022 2023

Products Sold with in Freshness Date Average Time to Sell ( in Days)

95% 90%
89% Food & Beverages 5.3
82%
Household Care 12.5

Personal Care 15.3

< 3 days 3-7 days 8 - 14 days 15-28 days
Tobacoo 24.5
Freshness Duration

14
 Data Visualization: KPIs Dashboard
Delighted NPS Score Standard Customers Growth Rate CA Customer Locations Net Income vs Projections

302.5K
22.87% 1,240 YTD Net
52%
Income
76.9 226

Customer Distribution Top Customer Locations Sales By Representative

Steve Jenkins
Startup 14.20%
HIGH Alan Cozza
Dob Gelson
Fireball 4.44% Steph Kimball
Jason Jones
Jeremy Hinklel
Standard 67.46% Jody Kimbrell
Grow 13.90% Michelle Stevens
Mike Covey
Diego Garcia
LOW
Shelly Smith
0K 10K 20K 30K 40K 50K

Site Visitors Overview Inbound Leads Revenue By Type

4

371 39% 30.78% 12 Months Top Category Revenue Growth

450
2 400
350 600
300
250
200 400
150
100
0 50 200
24-May
25-May
26-May
27-May
28-May
29-May
30-May
31-May
1-Jun
2-Jun
3-Jun
4-Jun
5-Jun
6-Jun
7-Jun
8-Jun
9-Jun
10-Jun
11-Jun
12-Jun
13-Jun
14-Jun
15-Jun
16-Jun
17-Jun
18-Jun
19-Jun
20-Jun
21-Jun
22-Jun
23-Jun

0
Jan-30
Jan-34
Jan-38
Jan-42
Jan-46
Jan-50
Jan-54
Jan-58
Jan-62
Jan-66
Jan-70
Jan-74
Jan-78
Jan-82
Jan-86
Jan-90
Jan-94
Jan-98
Jan-02
Jan-06
Jan-10
Jan-14
Jan-18
Jan-22
0
Jun July Aug Sep Oct Nov
Unique Visitors Site Visitors Page views

15
Data Visualization Process

16
 BI Techniques for Effective Analysis

o Extracts insights from transactional data which help to understand different

Data Mining aspects of business
o Identifies customer demographics to product sales to employee performance

o Collects raw data from various sources, including sensors and IOT devices,
Data
o Keeps data ready for further analysis and extraction of insights, like
Warehousing customer demographics

Data o Transforms data into graphs and charts that are easier to understand
Visualization o Transforms complex and confusing data into information that’s easy to digest

Predictive o Identifies potential customers based on behavior and demographics

Analytics through predictive analytics

17
Data Visualization Tools

18
 Impact of BI on Decision-Making
Manage data quality better Optimise employee performance
o Extracts, distribute and manage data towards o Creates more human experience for the users
producing better analysis by optimizing their workdays
o Identifies underlying KPIs of Data from database.

Visualize data better Improve quicker operational decisions

o Converts textual data into impressive visual o Provides managers with different insights into
presentations for analysts and decision-makers company processes and consumer behavior
o Makes apparent patterns, correlations, outliers
and relationships

Sharpen decision-making accuracy

o Detects and sort business without human intervention,
o AI and data scientists build intelligent models to help executives
connect to key business events.
19
 Challenges in Data Visualization

Integrating data from various

source systems 01 02 Data quality issues

o Employ a data warehouse as a central o Gather data for analysis, data

repository for business intelligence data. quality problems can be fixed once
o Such as integrating data without putting it the data has been acquired
into a database system o Lack of knowledge among users
about the necessity of effective
o data management

Data silos with

03 04 End-user training
inconsistent information

o Get siloed data with variable o Requires the participation of

permission levels and security corporate leaders, managers
settings is a need for successful BI and their training

20
4. Demo: Data Visualization Via Tableau

21
 04 Simple Justification

Type Excel Tableau

Productivity 1 Unit 9 Units
Service Turnaround Time: 1h 30 min 10 min
# of sub-steps processes: 20 steps 5 Steps

Daily
Daily Hours Monthly Hours Save Yearly Hours
Transactions Average Save Time
Spent Save

Reporting-Process 50 X ~80 Min 67 1340 16,080

X 20 X 12

Total 67 1340 16,080

MONTLY HOURS SAVED YEARLY HOURS SAVED

22
 5. Keys Takeaway and Q&A
Business Intelligence (BI) is so critical and has high job demand. BI and BA aim to
help managers make more informed and better decisions to guide the business.

Organizations that can harness Big Data Analytics effectively will be able to
create significant value and competitive advantages

Data mining in business analytic process will discover meaningful correlations,

patterns and trends in nonobvious relationships

Data has to be processed and managed to be useful for Data Mining, Business
Intelligence and Analytics

23
 Today Quotes!

“ If we do what we always did, we get what we always got. ” - Henry Ford

24
5. Q&A

Thanks

26
 Additional Reading Resources

• Learn how organizations are competing on analytics.

• Learn how data analytics can boost your business growth.

• Learn about the benefits of using big data analytics in businesses.

27