As a Data Analyst, I had the opportunity to work on numerous projects that spanned various domains. These projects allowed me to apply and enhance my skills in analyzing complex datasets, identifying patterns, predicting trends, and deriving meaningful insights. My work ranged from user behavior and sales data analysis to Power Plant Energy-related projects.
The Power Market Ad Analysis project aimed to identify strategies to boost the acceptance rate for Power Market's advertising campaigns. The approach was to leverage consumer data and insights gathered from previous specialized ads, with the goal of increasing the success rate by at least 15% for the upcoming campaigns.
Various Python tools were used, including Matplotlib, Pypylot, Seaborn, and Statsmodels. Data cleaning and organization were carried out using Excel and Open Refine, which helped minimize outliers that deviated from the overall format of the data. The project involved performing a time series analysis on over a decade's worth of advertisement data from Power Market, which allowed us to build a comprehensive overview and forecast of the company's ad strategy.
As part of our strategic goals for the new year, we aim to broaden our subscription base. In the prior year, subscriptions significantly contributed to our revenue, leading to increased sales. Our management team seeks the assistance of the analytics team to develop a series of visuals that accurately depict the demographics of our current subscribers. This information will provide valuable insights as we strive to expand our online store's subscriber base.
My
Projects
The American Energy Market Regulator (AEMR) project focused on maintaining the reliability of the U.S. domestic energy network by minimizing outages. Notably, an increase in submitted outages by energy providers during 2016 and 2017 prompted a review. The primary concerns addressed were Energy Stability and Market Outages, along with Energy Losses and Market Reliability. The project utilized Excel and Tableau for data organization, visualization, and analysis. After cleaning and organizing data, a comprehensive review was created, detailing the impact of outages from 5 different facilities over two years. The key focus was the growing energy loss from high-risk outages originating from specific facilities.
