Sales Analysis With Python and Tableau
I frequently wonder why marketing managers work with the seasons as I pursue a major in marketing. adding a seasons tab to an excel table and doing ab tests
For instance, if you run an e-commerce website, you may learn about people’s purchasing habits by looking at your Google Analytics target type or inventory history (because history repeats itself, according to nice nilesh).
Let’s explore the facts and fully comprehend.
Python, Pandas, Excel, and Tableau are required for the project.
We must first construct a project document in Python before downloading the data from this site.
To comprehend sales seasons and the demand cycle, we are employing two separate data sets.
I’ll get into the technical aspects because tableau will be used to convey the tale.
Steps
1. using PD to import a data set
2. Learn more about the null variable
3. Include a date column while analysing time series.
4. Use.str.replace to replace any unuse text.
5. Drop the useless column
6. download a tidy dataset
Github link
Which month have have highest sales?
From dashboard we can say Feb month have highest sales.
from item code i understand only few items are salleing lot.
Item description show paper craft little bird
Young audience more intrested in this item. for that we migh need to understand buyer persona.
Persona might include => young age person who are entreprenour in nature. he might be re sales item to hes website and feb must be season for him or we must have some sales on this month
Which one is second buyer type?
Coporate, we should use ad money to targer more coporate which can increase sales and profile
we can do more data analysis with data
https://public.tableau.com/shared/G5M895BHW?:display_count=n&:origin=viz_share_link
