Aesthetics Market Model
🎯 BRIEF
The Aesthetics Market Model is a proprietary market model specifically designed to provide insights into the aesthetics market, which includes data on trends, demand, patient preferences, competitive landscape, and more. It is based on proprietary data sources, such as point-of-sale data and survey data, and incorporates other factors such as demographic data, economic indicators, and regulatory changes to provide a comprehensive analysis of the aesthetics market. The model provides extensive market insights by analyzing point-of-sale and other data for aesthetics markets at the practice, patient, and product levels thereby enabling the clients to identify the information that moves their business forward.
🔧 TOOLS
Python, SQL, Snowflake, Tableau, pandas, re, scikit-learn, Matplotlib
🤝 CONTRIBUTION
Developed an NLP multi-class classifier in Python to extract product information from point-of-sale (POS) alternative data, uncovering market intelligence insights for 15+ aesthetics products in 3 new markets.
Innovated a mapping tool in Python with advanced regular expressions capabilities, leading to a 40% increase in the total dollar value of transactions mapped.
Automated pricing standardization of 1M+ transactions every week through text extraction and confidence interval.
Built an optimized ETL (Python, SQL, Jinja2) pipeline, incorporating new data logic to reduce redundancy and ensure fail-proof operation.
Designed and automated 15+ Tableau dashboards, providing enhanced insights into brand loyalty, basket analysis, and pricing elasticity.
Collaborated with clients to gather requirements, generate insights from market intelligence data, and deliver custom analytical solutions.
Assumed ownership of the newly implemented ETL pipeline, actively taking the lead in resolving any issues that arose.
Successfully onboarded a new full-time research analyst, providing comprehensive training on efficiently generating deliverables through the newly implemented ETL system.
🏆 ACHIEVEMENTS
Drove a 20% increase in sales by expanding product offerings to 3 new markets.
Reduced mapping runtime by 60%, improving efficiency and TAT for deliverable generation.
📷 SAMPLE VIEW