Starting a bootcamp is exciting! The very first project we did in the Data Science bootcamp at WBS Coding school is all about learning SQL and using it to analyse a given data set. The following scripts, charts, and presentation were created in the first 2 weeks of the bootcamp.
Important
The topic of the project was: should a Eniac, a well established European company that sells high-end apple products and product accessories, use the warehouse and delivery services of a big Brazilian company called Magist to expand into the Brazilian market. The fictitious scenario takes place in 2018, long before Covid and AI-Chat bots. The goal is: explore the data and come to a conclusion whether Magist is a good fit for Eniac's expansion into Brazil.
I learned to make queries in MySQL Workbench, create charts in Tableau based on the insights I gained from my queries, and finally got to work on and present the results with my teammate to the rest of the group in a Canva presentation.
- learn about SQL and its functions
- install and get familiar with MySQL Workbench
- try first queries and look through data
- start the analysis by answering business questions about our fictitious use case
- gather the insights from the different queries and visualise it using Tableau
- do not start hating Tableau because it has almost too many options
- prepare and practice a presentation with your charts and arguments in Canva
Credits for the ficitious dataset go to: WBS Coding School
Any mistakes in the code or a way to make it more elegant? Reach out if you have any feedback on the code as every comment can be a learning opportunity.
Credits for being a great instructor: @afarrag
Credits for my team member on this project: @Suparna-Das-89
Source for the data on market shares: statcounter