Introduction A US shopping mall is running an e-commerce as one of its sales channels. To support this, they run several paid search engine ad campaigns throughout June to November 2021. Objectives You’re tasked to make a dashboard to monitor the performance of the paid search marketing campaigns run by the company…

Data imputation and regression analysis on 3400 Hollywood movies — Introduction and Objectives About 700 movies are released to the masses each year in America. Released movies must compete against each other to gain as much revenue as possible. The objectives of this project are using regression analysis on the given dataset to find out: The relationships between the predictors and the movie…

Data wrangling with pandas and querying with pandasql — Objective Olist is a Brazilian e-commerce platform. The user in this platform can buy and sell various products ranging from computer accessories to beauty products. In this project, I conducted a descriptive analysis to explore these 2 topics: How well is the company’s growth in general? (Monthly GMV) How is the…

A Business Analysis utilizing Probability Theory — Introduction Bike sharing systems are new generation of traditional bike rentals where whole process from membership, rental and return back has become automatic. Through these systems, user is able to easily rent a bike from a particular position and return back at another position. Currently, there are about over 500 bike-sharing…

A descriptive analysis on a restaurant’s meal delivery service — Business Context A (hypothetical) restaurant is providing a meal delivery service for its customers. It serves various meal options, supported by fulfillments placed on various locations. Objective The restaurant wants to understand the demand of its delivery service for the last 3 months (12 weeks). The Dataset The dataset contains the delivery order data from…