IMAT 5166: Business Intelligence of Walmart: A Case Study Report

This report provides a detailed analysis of Walmart's business intelligence (BI) systems, focusing on a proposed credit control dashboard. It examines Walmart's corporate strategy, mission, and behaviors, highlighting the importance of monetary cleanliness and identifying issues in credit management. The report proposes a BI system to address these issues, outlining its technical architecture, cost-benefit analysis, and risk assessment. The proposed system aims to improve credit control through a performance management dashboard linked to the Balanced Scorecard, incorporating key performance indicators (KPIs) and data from a data warehouse. The report includes a discussion on the current technical infrastructure and the benefits of implementing the proposed BI system, such as enhanced customer relationships and improved financial performance. The report also provides a risk assessment and a detailed cost-benefit analysis of the proposed system, projecting a net benefit of $150,400 over one year. The report is a comprehensive business case for improving Walmart's credit control using BI systems.

0Running head: BUSINESS INTELLIGENCE OF WALMART
BUSINESS INTELLIGENCE OF WALMART
Name of the Student:
Name of the University:
Author’s Note:

1BUSINESS INTELLIGENCE OF WALMART
Introduction: -
This report explains and presents a plan to implement an innovative performance management
dashboard for credit control within WALMART which associates into the existing Balanced
Scorecard. WALMART is an US based biggest multinational organization who controls the
sequence of several department stores,supermarkets and grocery shops. In this report the writer
can propose modern business intelligence systems with respect to the different factors. In this
report also provide the track where BI system aligns WALMART business strategy.
Management Support Systems are processor based systems that are used by the organization
managers and employer. In this report also shows that how the WALMART are using MSS
system. Risk assessment and Cost benefit analysis are also the part of these report. The writer of
these report are provide two appendix section where they describe the clear overview of IS
structure and MSS structure of WALMART.
Discussion:-
Corporate Strategy:-
As defined in first appendix, ensuing the variations to the multinational retailer sector as
a significance of the service law and the outline of commercial Structures, WALMART has seen
an inflow of improved rivalry. Most importantly, this business structure permit authorized
stakeholder to invest in several retailer sector and as like this has bring about the new candidates
into the market like as Co- Operative commercial facilities. Business shareholder are also
temporary their individual financial stresses onto retailer businesses, supposing more reasonable
pricing arrangements and the setup the proper standby of per hour rates with permanent

2BUSINESS INTELLIGENCE OF WALMART
subscriptions. The administrative team of WALMART trying to present a modern corporate
structure which can be recognize business value, plans and behaviours.
Missions of WALMART:-
The main vision of WALMART is to deliver the most reliable remarkable client
experience to each time and each client. For fulfilling this vision WALMART are trying to make
a proper strategy. If WALMART made a good relationship between key sectors and innovative
technology then WALMART can enhance their client and business.
Proper Behaviours and Standards of WALMART:-
Behaviours Standards
Monetary Cleanliness Generate some business strategy
Responsiveness of market values Proper decision making approach
Concentration in the Business Client Maintain the development continuity
Innovation and Leadership Respect the every team member
The upper discussion behavior and standards should be maintains by the WALMART
organization. If WALMART are trying to satisfy their business mission then should utilizing six
sigma methodologies for eliminating the waste process and improve greater competitive benefits.
Monetary Cleanliness is the critical aspect in the achievement of any business organization but in
the current financial downturn several trade sector have gone into management due to poor
monetary cleanness. Following points are discussing about the factors of poor financial
cleanliness in Retail sector.
 Weekly Billing Cycles increasing the prime time for money receipts.
 Possession of Debit. In some times workers are not accountable for recovering the debit.

3BUSINESS INTELLIGENCE OF WALMART
 If the business cheaters are cheat any business money then it can be barrier for enhancing
the business economic condition.
These difficulties to Monetary Cleanliness have initiated a supplementary project connecting to
Credit Control inspecting difficulties to active credit management. This project recognized that a
deficiency of suitable administration information, proprietorship of debt from subscriber, was
having a harmful outcome on credit management.
Business Intelligence System Proposal:-
Outline:-
It was recognized in the above-mentioned active credit management project that Credit
Control did not sense like they had suitable reflectiveness of all debt at a proper level.
WALMART administration should target operational support which can be create the good
impact in these organization’s credit management. A brainstorming period was directed with
core associates of credit control, containing the team executive and a credit supervisor along with
the WALLMART monetary department.

4BUSINESS INTELLIGENCE OF WALMART
With the help of this proposal WALMART are easily address these issues and enhance
their business economic standard. If these organization are follow credit management report
then they easily identify their existing problems. First of all these organization should identify
the several business quantity and also identify the receivers of the quantity. The following tables
are identifying measures and receivers of WALMART.
Business quantity (Measures) Receiver
Debit Amount Business client partners of
Bill percentage WALMART business head
Bill Revenues Subscribers and Earners
Regular Debtor days Administrator of Practice area

5BUSINESS INTELLIGENCE OF WALMART
Development of business work Finance
Working days Finance
To confirm the regularity of recording and a particular resource of fact for performance
management, the current demonstration will be comprehensive to include the original Credit
Control metric. The WALMART organization should strictly follow the rules and regulation for
changing internal structures. The existing management team and employees of WALMART will
try to implement the financial calculation through the user acceptance. It is expected that the
progress work essential for this execution will take around 4 weeks and net benefit210000 US $,
with probable corrupt debtor loss of 50000 US $. The expected profits of this proposal and net
gain will be 150,400US $ over1 year.
Plan Arrangement:-
Several medium and large business retail organization in the recent financial decline went
out of commercial due to deficiency of cash flow. This plan endeavours to grab this difficulties
by giving administration at several stages the suitable data to cope with debt. By recognizing
customers that have huge debt ratio or are disreputably late payers, discussions can be had to
simplify faster payment of bills, thus enhancing cash flow. This approach should be measured
with due regard of the customer attention behaviour recognized by the WALMART
administrator, but with the data presented within this dashboard controlling can choose whether
suitable budgets can assumed to exact customers in definite circumstances.

6BUSINESS INTELLIGENCE OF WALMART
Current Technical Application:-
The current Technical application of WALMART is established via joined architecture
from frequent unequal source systems. The architecture of WALMART is totally depends on the
SQL server where the information are replicated from source structure databases through direct
stored process calls. The current credit management of WALMART are no exception to this, and
have been constructed utilising SQL Server Broadcasting Facilities drawing the records from the
simulated system records through SQL Stored Process calls. These reports have been constructed
over a period of maybe eight years, with some of these being reviews of even older legacy
Crystal reports. There are around 20 current credit management reports in reality.
This method has controlled to a quantity of problems with the current report mechanism. At first
nobody distinguishes which of the reports to go to for the normal answers they need. The current
report measures are excessively multifaceted and not built for rapid broadcasting analysis. In
these report have been constructed by several people finished time, many of whom have gone,
and report logic has been misplaced as it was not completely recognized. This method has not
occasioned in a particular truth source for reports, many of which are inaccurate or outdated.
Necessarily it is presently very problematic to cope debt to fulfil the Board’s apparition of
monetary cleanliness.
Suggested Business Intelligence:-
The purpose is for entire administration evidence to be carried through the innovative
data warehouse to eliminate any disjointed and imprecise reports from presence, thereby
realizing a particular source of fact. Like it is completely suitable for this suggestion to utilise the
data warehouse as faced to utilising the remaining mechanisms. The data of WALMART is
made using the Wherescape technical architecture.Wherescape is an IDE for developing,

7BUSINESS INTELLIGENCE OF WALMART
designing, positioning and effective data infrastructure from data vaults and data warehouses to
data marts and data lakes. The Raw Data from business databases is removed. The data could be
extent across multiple systems various systems. The data is prepared and converted into the data
warehouse. Using BI system the WALMART’s usercan ask ad-hoc reports and conduct several
analysis.
The transaction systems of WALMART could be provide for into product database and
add product data line. First of all these organization should change a product expense. Similarly,
in a BI query that would be effected for the product subject area could be did the calculation of
innovative product line or modification in product price increase the revenues. If WALMART
are increase their communication skills via advertise in different medium then it should be
helpful for the user.BI system demand that could be performed would be newclient’s number and
added due to the budget modification. Propose BI system can also enhance the WALMART

8BUSINESS INTELLIGENCE OF WALMART
customer’s security and deliver their transaction details very quickly. These propose systems can
enhance the WALMART business quality and increase profit.
Cost Benefit Analysis:-
Benefits:-
The investigation of the suitable investors and the budgets of this proposal, the CBA has been
led. As this plan proposes to generate current arrangement most of the perceptible costs such as
hardware are not appropriate. The examination is over an one year period and, as shown below,
the net investments are estimated to be in the region of 150400 US $.
Tangible Analysis:-
Every month cash collection 15000 US $.
Yearly Cash collection 15000*12 = 180000 US $
Reduce monthly cash for poor debt = 2500 US $
Yearly cash reduce 2500*12= 30000 US $.
Total = (180000+30000) = 210000 US $.
Intangible Analysis:-
Reduced debtor days (by between 3and 5 days) to support with faster payment of bills counting
employer costs. Distinct fact resource. Enhanced Subscriber performance. Enhanced client-
organization connections. Access to inventive design.
Costs:-
Tangible:-
Business Analysis (In one day) 250 US $ = 250*1= 250 US $.

9BUSINESS INTELLIGENCE OF WALMART
Business Intelligence Authority (4days) at 400 US $ (Per day) = 400*4 =1600 US $.
Development Time (one developer in 15 days) at 200 US $ (Per day) = 200*15=3000 US $
Test timing (Credit Analyst in 5 days) at 150 US $ (Per day) = 150*5=750 US $
Credit Control Team (Minimum 7 days) at 500 US $ = 500*7 = 3500 US $
Training cost = 500 US $.
Loss of bad debt clients = 50000 US $
Total Cost = 59600 US $.
So Total net benefit = Total Profit- Tot cost
= (210000 – 59600) US $
= 150400 US $
Detail Deliverable:-
Balanced Scorecard:-
Financial View:-
The information accessible is the balance and the financial statements. In addition
advertising reports, internal plan and management process are also available. In this table shows
how WALMART measure their target and execute this properly.

10BUSINESS INTELLIGENCE OF WALMART
Objective Measure Target Action
Total Assets Revenue Percentage Yearly increment 7% Increase Revenue
Increase Employee Revenue Employee Yearly increase 5% in
after 2 Years
Increase technical
efficiency
Return Investment Return on Investment Yearly increases 3% Reduce Operational
Cost.
KPI of WALMART:-
With the help of KPI dashboard WALMART are trying to implement their business
process and analyse the advertisement details. These advertisement details are trying to achieve
the future executed plan.
Customer View:-
Objective Measure Target Action
Enhance Number of Average
WALMART’s
Increase 6%
Customer (In every 3
Satisfy the existing
customer

11BUSINESS INTELLIGENCE OF WALMART
Customer customer Size years)
Customer Positive
Feedback
Customer Rating
system
Increase 15%
customer
feedback(Yearly)
Improve product
quality and
reasonable price
Decrease Customer
Compliance
Customer Complaints Reduce 4% Customer
complaint (every 2
years)
Improve quality and
product stock.
Credit control system:-
WALMART Credit Control information are utilizing in a mark dashboard will be
enhanced through the reporting Services. The dashboard is reveal at a highest level of pre
described metrics. WALMART will illustrate appropriate trends of these metrics over the
existing financial year a different colour accordingly.
Risk assessment:-
The WALMART risk assessment is based on Moss and Atre’s Risk Assessment Matrix,
the following risk assessment are demonstrating in different color.
Technology (LOW)