Logi Analytics Maturity Model

Logi Analytics Maturity Model 1
Student’s Name
Institutional Affiliation
Professor
Date

Logi Analytics Maturity Model 2
Calculations of sales representatives output and their respective bonus of 3M Supplies
Logi Analytics Maturity Model
The Logi Analytics Maturity Model is a data analysis framework used in assessing the overall
ability of a firm to effectively practice its data exploration and arrive at optimal decisions using
various stages or levels (Muntean, Bologa, Corbea, & Bologa, 2019). The model can be broken
down into five different segments which include, company chaos, company development,
company alignment, company integration, and company optimization.
Under the company chaos level, the firm is highly dependent on the ad hoc and spreadsheet data
analysis. Every activity in the firm is considered to be a one-off thing. Predicting activity success
if done by a different person, is usually just guesswork. The dominant organizational reports
available at this point are only financial reports. Typically, the information shared is considered a
process artifact that thorough planning by the concerned individual. Thus, it means that there is
no available analytics strategy available in the firm (Lennerholt, van Laere, & Söderström,
2019). The analysis process leads to the development of skewed and incorrect data, and it is
generally used for reactionary purposes.
The company development stage witnesses the development of elaborate business processes. The
firm adopts tighter control measures over the means of processes and operations in order to
ensure meeting customer demands. Departments take reliable tools that meet their analysis
requirements for daily use. The data generated is utilized strategically. Adoption of more
advanced data analytic tools such as Microsoft Excel is used. The derived data is used in making
informed decisions relating to various processes and how they can be improved.

Logi Analytics Maturity Model 3
Company alignment resolves the overall need of the management to apply the data analytics
techniques practices in the company to address the overall requirements of the company.
Conventional data analysis and storage features are developed in the company, so everyone in
the firm can access it more easily. More elaborate and accurate analysis methods are adopted,
such as the development of business intelligence competency centers (BICC), which leads to the
creation of a standardized strategy in choosing business intelligence tools (Król, & Zdonek,
2020). The overall data is measured using scorecards and dashboards to determine the overall
performance of the organization. The advanced tools are used in modeling the data necessary for
decision-making purposes.
Company data analysis integration focuses on the need of the company to use the collected data
across the firm. The analytics investment done in the company is required to return on the
investment. Sophisticated data analysis tools are used to attain business insight into the firm
(Gardner 2017). The insight gained is useful in enabling new business processes, transforming
various operations, and creating new value in the business.
Optimized data-driven performance in a firm covers the utilization of the integrated data into the
decision-making process (Lennerholt, van Laere, & Söderström, 2019). Occasions of
incorporating analytics into the decision-making process are sort time and again.
Analysis of 3M Supplies firm using delta plus model and the excel pivot
The pivot table is used to extract from sales made by 3M Supplies sales representatives for
various school items. The data contains the number of sales made by each sales rep and the
region they operate from.
1/1/201
9 Jardine
Centr
al Shipped Pencil 2.99 36 107.64

Logi Analytics Maturity Model 4
1/2/201
9
Howar
d East Shipped Pencil 2.99 95 284.05
1/3/201
9
Andre
ws West Shipped Binder 4.99 50 249.5
1/4/201
9
Howar
d East Shipped Binder 4.99 60 299.4
1/7/201
9
Andre
ws West Shipped Binder 4.99 27 134.73
1/8/201
9
Sorvin
o West Shipped Pencil 2.99 56 167.44
1/9/201
9 Jardine
Centr
al Shipped Pencil 2.99 90 269.1
1/10/20
19
Andre
ws West Shipped Pencil 2.99 75 224.25
1/11/20
19
Sorvin
o West Canceled Pencil 2.99 32 95.68
1/14/20
19 Jardine
Centr
al Shipped Pen 1.99 74 147.26
1/15/20
19
Howar
d East Canceled Binder 4.99 60 299.4
1/16/20
19
Andre
ws West Shipped Desk 275 2 550
1/17/20
19 Jardine
Centr
al Pending Pencil 2.99 90 269.1
1/18/20
19
Howar
d East Pending Binder 4.99 29 144.71
1/21/20
19 Parent East Pending Desk 275 1 275
1/22/20
19 Jardine
Centr
al Canceled Pencil 2.99 20 59.8
1/23/20
19
Howar
d East Backorder Pencil 2.99 35 104.65
1/24/20
19
Andre
ws West Backorder Binder 4.99 81 404.19
1/25/20
19 Gill
Centr
al Shipped Desk 275 2 550
1/28/20
19
Howar
d East Backorder Desk 275 3 825
1/29/20
19
Andre
ws West Canceled Pen 1.99 56 111.44
1/30/20
19 Jardine
Centr
al Shipped Binder 4.99 28 139.72
1/31/20
19
Howar
d East Backorder Pencil 2.99 12 35.88
2/1/201
9
Howar
d East Shipped
Pen
Set 4.99 16 79.84
2/4/201
9
Howar
d East Shipped
Pen
Set 4.99 48 239.52
2/5/201 Howar East Pending Pen 1.99 64 127.36