Chinook Music
SQL based analysis for music store
Tools : SQL/Tableau/Excel/Powerpoint
Chinook Music Store, a renowned provider of digital music, is seeking to refine its sales and marketing strategies to enhance profitability and customer satisfaction. Leveraging the sample dataset available from Chinook’s database, the aim is to extract actionable insights that will inform the development of targeted sales and marketing initiatives..
Analysis is focused to assist Chinook Sales and Marketing departments through sales analysis, customer segmentation, and product performance evaluation, culminating in strategic recommendations to drive business growth and success.
Rockbuster
SQL based analysis for movie rental company
Tools : SQL/Tableau/Excel/Powerpoint
Rockbuster Stealth LLC is a movie rental company that operates worldwide through video rental stores. Faced with heavy competition from streaming services like as Netflix and Amazon Prime, the Rockbuster Stealth management team intends to develop an online video rental business using its current movie licenses.
Analysis is focused to assist Rockbuster Stealth’s Business Intelligence (BI) department with the launch strategy for its new online video service.
Instacart
Python based analysis for online grocery store
Tools : Python/Jupyter notebook/Numpy/Seaborn/Matplotlib
Instacart is an online retail service provider for groceries across 14000 cities in the USA and Canada. Instacart combines various retail stores online through their platform for their customer’s grocery needs and provides pick and delivery service. The company provides its service through its website and app.
Analysis was done to uncover more information on Instacart´s sales patterns through exploratory data analysis, derive insights, and suggest strategies for better segmentation based on key questions.
Book your stay
Python based analysis for online hotel booking platform
Tools : Python/Numpy/Seaborn/Matplotlib/Pylab/Tableau
Book Your Stay is a fictional online hotel booking platform representing leading global hotel chains that are planning to expand their market in Southeast Asian marketing covering seven countries.
Analysis was done to uncover the Southeast Asian market segment´s (Travellers) behaviour in hotel booking related to different factors for developing market entry strategy
Influenza season
Excel and Tableau-Based analysis for recruitement firm.
Tools : Excel/Tableau
During the annual influenza season United States, There is an increased number of flu cases, leading to an increase in hospitalizations. medical facilities rely on temporary staff from a medical staffing agency to battle this situation.
The objective of the analysis is to identify optimal timing, location, and quantity of staff deployment across medical facilities in USA
GameCo
Excel-Based analysis for an online video game company
Tools :Excel/Powerpoint
GameCo is a fictional video gaming company, planning its 2017 marketing budget with the assumption that regional sales are consistent.
The analysis aims to validate the assumptions offer insights into regional markets, and suggest how to allocate the marketing budget effectively
