Description
MUST HAVE THE PROGRAM TABLEAU to be able to do the assignment
Using the data attached
Complete the industry analysis and background information exploration. The charts (of our data) include:
Bar charts and year by year trend lines on: Total sales; Channel sales; Pricing profile;
Seasonality of the above;
2. Show the top 5 firms and ‘Others’ to see industry concentration. Plot the total sales and avg price; show how these firms used channels in different ways. Contrast these with industry trend.
You should create ~20 sheets in Tableau, and try to form a story around what you have observed.
3. Based on what you see so far, what are some strategic questions you can ask to these data, and can explore further?
What information do you need in order to answer each question?
Explanation & Answer
Kindly check on the attached and let me know if you've got any queries
Attached.
Surname: 1
Student Name:
Professor Name:
Course Number:
Date:
Tableau –Marketing
We will start by import our excel file which will be our source of information:
This will import the data as below:
Surname: 2
We will then go to sheet 1 of the application so that we can complete the industry analysis and
background information exploration.
Surname: 3
We will need to come up with bar charts which will have a year by year analysis of the trend
lines for:
First we will start by converting the orderdate from general to date then reimport the excel sheet
Total sales
The following chart indicates the total sales over the three year period. From the chart it is clear
the highest sales were experienced on the year 2006 with a record high total sale of $ 17,
841,127. The second highest sale over the same year period was on 2007 with total sales of
$15,188,288. The lowest sale was experienced in 2005 with the sales being $10,780,184.
Surname: 4
Channel Sales
Surname: 5
Pricing profile
This will be categorized based on the Company_id and the amount being paid for the product
and against the channel used to sell the product. From this, we can be able to tell that Channel C
appears to have being experiencing the highest price changes over the years while Channel O
had and almost even price change in products over the years.
Surname: 6
Based on Seasonality:
Our case, seasonality will have to be measured based on looking at which months that has the
highest pricing and total sales over each of the three years and according to the moths and this
will tell us when there was seasonal buying withing the years.
From the above, we can notice that in 2005, the was an increase in sales over the last...