Sales Performance

Motivation 🚀

4. Prompt if you need to create data for your project:
"Provide python code to generate a csv file with data on the [information/columns you want] and name the csv [file name]"
Paste this code into Google Colab, run code, find the file name you gave in the folder, and download! pic.twitter.com/yaRDgPd06Q

— Brittany City (@brittanycity) June 14, 2023

<script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>

My biggest challenge in my data portfolio journey is finding a data set that has enough variety and provides nearly all of the fields necessary to build a standard BI dashboard. After coming across this tweet by Brittany City's suggestion on using ChatGPT to "build your own basic dataset" using the Faker module in Python, I immediately got to work. A software engineer friend (after telling them) was geeked out about a unique use of the module. This method really allowed me to be hands-on with quality checking the data types along with the fields.

Project Goals 🎯

• Generate fake data to populate columns for a Sales Performance dataset using Faker Python package
• import the data into Tableau Public desktop
• Create 4-5 charts in Tableau Public highlighting trends of the data
  • including KPIs, any filters
• update readme file for Github documenting the process and project

Overview of Project 🔍

Customizing all the fields of a randomized and fake dataset (using the Faker module in Python) with 1,000 sales recoreds and creating a Sales Performance dashboard in Tableau Public.

Project Steps

1. Generated "fake" data using Faker to populate
2. Import data into Tableau public desktop
3. Create a dashboard outline to address granular and big picture elements of performance
4. Created 4-5 charts in Tableau Public highlighting the trend of the data

• KPIs
• Filters by Product

Python

1. Libraries installed: Random, Pandas, numpy, Faker

Methods & Technology 💻

• Data tools: Python, Excel
• Data Source: self-created using Faker & inspiration from ChatGPT
• Software: PyCharm, Microsoft Excel, Github, Tableau Public

Featured Deliverables 📊

• Tableau Public - Sales Performance Dashboard
• Sales Performance dataset CSV

Contact 📬

If you have any questions, DM me on Linkedin!

Notes for self:

• CMD + SHFT + V (Markdown Preview)
• Markdown CheatSheet
• Markdown Emoji CheatSheet