The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Competitor Market Research
I researched six Barcelona restaurants using public business information and built a structured competitor benchmark. The analysis covered positioning, cuisine, format, published pricing signals, offer differences and source verification.
I organized the findings into an Excel research database, price benchmark and positioning analysis to make competitor information easier to compare and review.
Portfolio case based on public business data.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
One quarterly number almost got double-counted across two reports.
Two dashboards were quietly tracking overlapping data. Caught before it went out now there's one source of truth the reports pull from, not two that can disagree.
→ A good number is only as good as the one place it actually comes from
Great catch before it shipped. I like the “one source of truth” framing - pulling reports from one validated source makes it much harder for a duplicate dashboard to quietly skew the number again.
Project title: Credit Card Customer Segmentation and Behavior Analysis
Context: Analyzed 7,000+ credit card transactions from a course dataset, which I cleaned and preprocessed, to understand customer value and spending behavior and to design differentiated marketing and promotion strategies.
My role: Individual project. I built a structured dataset from the raw data, ranked customers with an RFM model, and designed two custom indicators for activity (CAI) and stability (CRI) to track behavior changes over time.
Methods and tools: R, SPSS, Excel. RFM, K-means clustering, ANOVA, chi-square tests, t-tests.
Outcome: A single demographic variable such as age or gender is a limited basis for targeting. Adding behavioral indicators made differences between customer groups visible over time and supported more precise resource allocation. For example, within the "about to churn" segment, customers aged 21-30 showed a declining CAI and a significantly stronger churn trend than other age groups. I recommended targeted campaigns for this group, such as partnering with apparel brands they prefer and offering rewards to raise card usage.
Business analysis, Is the most common and in-demand fields globally. To keep operations seamless, decision-makers need analysts who precisely match their project goals.
About Me
I am a versatile data analyst capable of handling diverse datasets regardless of row count. I focus on thoroughly understanding core project goals to deliver precise, detail-oriented insights. My primary areas of interest include sports and product analytics.
Overview
Based on an Excel pivot table analysis, this online retail project identifies the top six customers by revenue across different countries. Regardless of Recency, Frequency, or total units purchased, Dutch and British customers generated the highest overall revenue indicating high-volume purchases or premium product selections.
