Creating Dillard's Christmas Dashboard using Tableau Software

Business Intelligent - Memo

Table of Contents
Introduction................................................................................................................................3
Tableau Software.......................................................................................................................3
Dash Board.................................................................................................................................4
Key Performance Indicators for Dashboard...........................................................................5
Recommendations....................................................................................................................11
Conclusion................................................................................................................................12
References................................................................................................................................13
2

Introduction
Main objective of this project is used to creating the Dillard’s Christmas Dashboard
by using the provided data. The creation of dashboard is completed by using the tableau
software.
Here, user needs to play an analytics consultant role for the VP over a district of
Dillard’s' stores in the Christmas season of 2015. Basically, VP is now faced with market
realities that are squeezing his business. The VP perceives the job is at risk if this year
holiday season and his does not go well. So, VP decided to hire the user to help him get a
good understanding of how his stores are doing thus far and also provide the
recommendations on what he might to do drive better profitability.
Coming in to this season, he has not yet set deals targets, but rather his stores are
requesting per-store targets with the goal that neighbourhood the board comprehends what
their objective ought to be.
Note that this objective is for the aggregate real deals which is "SALE_PRICE" in the
TRANSACT table not including returns. Retail deals as a rule breaks the Christmas season
deals in to 2 gatherings, "10-day deals", which are the deals for the 10 days starting on
Thanksgiving and going through 12/5/2015, and "add up to season deals", goes from Thanks
giving Day through 12/31/2015. As a rule, 10-day deals ought to be 25% of your objective
for the Christmas season. Most retail activities additionally give day by day targets, and the
VP you are working for might want to deliver those too.
Although standard fare, for example, income and item deals combine, write down rate
is additionally viewed as a key marker inside retail, as items once in a while move for full
rundown cost. Additionally remember that a few items normal more significant markdown
rates than others, and that should factor in to any proposed suggestions.
Tableau Software
Tableau is a Business Intelligence tool for visually analysis the provided the
information. Clients can create and visualize an intelligent and shareable dashboard, which
describe the density, variations and treads of the information as diagrams and graphs. Tableau
can interface with records, social and Big Data sources to secure and process information.
The software permits data combine and constant joint effort, which makes it extremely
3

original. It is utilized by organizations, scholarly scientists, and several administration
associations for visual data analysis. As a main data visualization tool, Tableau has several
attractive and interesting highlights. It is s incredible data disclosure and investigation
application enables user to answer critical questions in a moment or two. You can utilize
Tableau's simplified interface to visualize the any information, investigate diverse
perspectives, and even join various databases effectively. It does not require any complex
scripting. Any individual who comprehends the business issues can address it with a
perception of the pertinent information. After investigation, imparting to others is as simple
as distributing to Tableau Server. Tableau gives answers for a wide range of businesses,
offices, and data environments.
Dash Board
Here, we are creating the Dillard’s Christmas Dashboard by using the tableau
software. The objective of this dashboard for the aggregate real deals which is
"SALE_PRICE" in the TRANSACT table not including returns. Retail deals as a rule breaks
the Christmas season deals in to 2 gatherings, "10-day deals", which are the deals for the 10
days starting on Thanks giving and going through 12/5/2015, and "add up to season deals",
goes from Thanks giving Day through 12/31/2015. As a rule, 10-day deals ought to be 25%
of your objective for the Christmas season. Most retail activities additionally give day by day
targets. Although standard fare, for example, income and item deals combine, write down
rate is additionally viewed as a key marker inside retail, as items once in a while move for
full rundown cost. Additionally remember that a few items normal more significant
markdown rates than others, and that should factor in to any proposed suggestions (Khan,
2016).
First, we are determining the Sales Target for 10 days sales on the Christmas sales
that is 33% of the one month target sales for assigned stores such as 140 and 141. Then,
create the Dash board based on provided data base. The provided database has one or more
tables such as
 Customer
 Department
 Sku
 Sku_store
4