Manu Romo

Mathematician, Computer Scientist & Artist

Here are a few Data projects I’ve been working on while learning. Make sure to go inside each post to see the whole info.

Posts

Insights for an Internet Service Provider

  • 2 min read

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.

Read More

Euromonitor: Carbonates - Statistical Analysis & C-Level Presentation

  • 2 min read

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.

Read More

Mixkit: Growth Potential, SEO and Mini Audit

  • 1 min read

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.

Read More

Marketing Campaign Results

  • 2 min read

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.

Read More