Super Kmart Executive Dashboard Review, Profits and Sales Growth Recommendations Report

Super Kmart
Executive Dashboard Review, Profits and
Sales Growth Recommendations
Report

Table of Contents
Executive Summary.........................................................................................................................3
Executive Insight – questions for the senior managers...................................................................4
Introduction......................................................................................................................................5
Business intelligence tools...............................................................................................................6
What Business Intelligence (BI) tool was used?.............................................................................7
SAP Lumira..................................................................................................................................7
Assumptions....................................................................................................................................8
Performance Dashboards.................................................................................................................9
CEO Dashboard...........................................................................................................................9
What is clear from the above table?.......................................................................................10
What can made out of this?....................................................................................................11
The dashboard for the director of sales......................................................................................12
What is clear from the above table?.......................................................................................14
What can made out of this?....................................................................................................14
The dashboard for the director of marketing.................................................................................14
What is clear from the above table?.......................................................................................15
What can made out of this?....................................................................................................16
Recommendations..........................................................................................................................16
QSR Code......................................................................................................................................17
References......................................................................................................................................18

Executive Summary
Super Kmart is associate yankee monumental box distributor headquartered in Hoffman
Estates, Illinois, in the US. The organization was consolidated in 1899 as S. S. Kresge
Corporation and renamed to Kmart Corporation in 1977. The most store with the Kmart
name opened in 1962. At its high in 2000, Kmart worked two,171 stores together with
one zero five Super Kmart Center areas. This report seeks to analyze the performance
of the store in terms of the sales and the profits for the year between 2014 and 2017.
The following were the key findings we were able to gather from the analysis
 Growth in sales was recorded over the years apart from 2015 when there was a
slight decline.
 Profits recorded rose from 2014 to 2017 recording positive growth rates
throughout
 Negative relationship between discount amount and profits made
 Positive relationship between discount amount and sales made

Executive Insight – questions for the senior managers
The input from the ELT administration group (the company CEO, director in charge of
Sale, director in charge of Marketing, director in charge of Finance, director in charge of
Logistics) distinguished various center inquiries which should have been tended to:-
 What is the breakdown of offers income (month to month, yearly and in light of
locale inclusion)
 How is the business performing year to date from a deals and benefit point of
view when contrasted with past money related periods?
 How does sales compare per product category?
 How does profit compare per product category?
 Can customer segmentation be identified based on the breakdown of the product
revenue?
 Is there possibility to segment the products based on the type of the customer,
region, and product profitability?
 What role does shipment mode play in terms of profit and sales?
 Does the number of quantity purchased vary based on region, month or year?
In response to the crucial inquiries raised above, the guide to the main or rather the key
dashboard guide can be separated into 4 key zones: Sales, Profitability, Product and
Customer Loyalty. The dashboards are intended to give wide and distinctive levels of
perceivability over these four territories for every one of the official practical heads
(Aarons, 2009).

 A portion of the plan around the official dashboard fuses the accompanying
reasoning:
 Information is composed in a consistent and consecutive way
 Condensed, fundamentally as outlines
 Dashboard reports to fit on one screen (PC work area)
 Ensure consistency in the arrangement of the outlines
 Minimal utilization of words or insignificant illustrations to guarantee center around
the real dashboard result.
 Provide suitable profundity of data in view of administration level. In view of this, the
table beneath characterizes the individual abnormal state dashboards approach
separated crosswise over four key business zones (Sales, Profitability, Costs and
Customer Loyalty) the intended interest group, the information displayed and the
perception choice picked.
Introduction
Globalization implies organizations over the world approach comparative assets,
including materials, parts, items and even individuals. As organizations likewise utilize
comparable advances, rivalry is causing business procedures to merge towards
comparable guidelines (Rodriguez, Daniel, Casati, & Cappiello, Toward Uncertain
Business Intelligence: The Case of Key Indicators, 2010). This is leaving the nature of a
business' basic leadership as its primary means for out-playing out its rivals.
Digitization, in the interim, is driving down expenses and causing commoditization.
Intangibles empower a business to separate from its rivals. They are as of now the
primary drivers of the esteem that a business can make. The nature of its basic

leadership empowers a business to adjust more quickly than its rivals to the chances
and dangers exhibited by the advanced age and the improvements in its business
sectors (Ross, 2013). It is additionally the key elusive that opens the possibility to create
different intangibles inside the business, for example, its focused position, its image's
notoriety, the nature of its kin, its scholarly capital and how well it actualizes its choices
(Nikolić, Dakić, & Ružić-Dimitrijević, 2013). Organizations should in this way address
the danger of predisposition in basic leadership by guaranteeing that their chiefs don't
superfluously practice individual judgment in view of past understanding or influenced
by close to home thought processes (Sidorova, Torres, & Beayeyz, 2014). Rather, they
should expect to be estimated and judicious. Choices ought to be founded on confirm
given by important data and on tenacious examination with an emphasis on partner
esteem (Kohavi & Simoudis , 2002).
Business intelligence tools
Business Intelligence (BI) includes the methods and developments used by attempts for
examination of information identified with business data (Rodriguez, Daniel, Casati, and
Cappiello, 2010). There are a few business knowledge instruments that can bolster
basic leadership. This report will just feature and give points of interest of two generally
utilized Business Intelligence Tools that assistance separate knowledge from the
business information to help basic leadership through demonstrating and investigation.
Business insight can be utilized by undertakings to help an extensive variety of business
choices going from operational to vital (Chaudhuri, Dayal, & Narasayya, 2011).
Essential working choices incorporate item situating or valuing. Vital business choices