| Filter by categories. | Filter by skills. |
2023
Current Project: YouTube Analytics Report Automation
Current Project
Currently working in a project involving the use Google API, YouTube Analytics API, utilizing Python for robust statistical analysis and automation.
Insights for an Internet Service Provider
Summary
Utilized Excel for comprehensive data analysis and error rectification in an Internet Service Provider’s billing system, resulting in substantial cost savings. Identified strategic insights, which were presented through a user-friendly dashboard, and proposed proactive error strategies to enhance overall operational efficiency.
Euromonitor: Carbonates - Statistical Analysis & C-Level Presentation
Summary
In response to the client’s need to penetrate the US and/or Mexican soft drinks markets, a comprehensive analysis was conducted covering market performance, trends, and future outlook. Key insights include the establishment of a new status quo during the pandemics. Recommendations for Mexico emphasize health concerns, sustainability, and e-commerce, while in the US, the focus is on using natural ingredients, analysis on flavor, and sustainability. The concise 5-slide presentation ensures the client receives crucial information efficiently for their imminent board meeting.
Mixkit: Growth Potential, SEO and Mini Audit
Summary
In this project, I conducted an in-depth analysis of Googlebot crawls, assessed geo-traffic distribution and conversion rates, and delved into the performance of organic keywords across the top 10 relevant countries. Additionally, I identified and evaluated top-performing pages globally.
Marketing Campaign Results
Summary
In response to a Marketing Campaign Analysis challenge, I conducted a robust ETL pipeline using Pandas, extracting and transforming the data before loading it into MySQL. The subsequent statistical analysis addressed crucial business questions related to web purchases, campaign success, product performance, and channel effectiveness. I identified potential growth opportunities in Mexico based on spending patterns, proposing a strategic focus on web purchases and consumer insights through marketing campaigns. The approach is detailed in the following: Files within a Github Reporitory and a Tableau Dashboard.
Data Wrangling Challenge in Excel: Salary Survey 2021
Summary
This is a challenge I took part in. I handled an eccentric Excel Salary Survey dataset, transforming complex characters and data into usable information. I cleaned up and organized the information, using different tools to find patterns. This challenge provided an opportunity to test my efficiency working in Excel. In this post, I will describe my process.”
Simple Naive-Bayes Implementation
Summary
This is an implementation for a simple naive bayes algorithm, a probabilistic classification algorithm based on Bayes’ theorem, which assumes that the features used to describe an observation are conditionally independent, given the class label. Despite its “naive” assumption of independence, it often performs well in practice, especially for text classification tasks. It is then applied to a dataset that deals with adults profiles and their income.
Self Research: SEO Dunkin
Regression Excercises (StatsModels and Scikit-Learn)
Basic exercises on regression using two Python modules: StatsModels and Scikit-Learn.
Notes and Tutorials
