Projects
Acting as a Data Analyst for a super store, the CEO will like to gain insights into
the performance of his stores for the first quater of the year in order to
identify opportunities for growths. Excel formulas were put to you for further analysis intro
calculating the growth rate and profits.
Crime has been recorded in the United States since its founding and
has fluctuated significantly over time, The Washington Post collected data
on more than 52,000 criminal homicides over the past decade in 50 of the
largest American cities. The data included the location of the killing,
whether an arrest was made and, in most cases, basic demographic information
about each victim....
The Danny Ma SQL Challenge was brought by the Data With Danny
virtual data apprenticeship program. In this project, focus was placed on
Pizza Runner and Data Bank.
All analysis was carried out using SQL
A pre-owned vehicle is a vehicle that has been previously owned by one or
more retail owners. These types of cars are available for purchase through
various channels, such as franchise and independent car dealerships, rental
car companies, buy here pay here dealerships, leasing offices, auctions, and
private sale.
The objective of this analysis is to identify the factors that can help in
determining the resale value of a pre-owned car in relation to the market,
and to determine the optimal time for selling.
As an analyst within our dynamic company, I embarked on a comprehensive A/B testing analysis driven by the relentless pursuit
of optimization and excellence. Fueled by our commitment to data-driven decision-making, this analysis aimed to unlock
actionable insights that would propel our campaign strategies to new heights. Delving deep into the intricate world of
A/B testing, our goal was not only to undersatand the nuances of user behavior
but also to uncover strategic pathways for enhancing conversion/engagement metrics.