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
ā¢ 1d
š Marketing Campaign Analysis | Excel & Business Insights
How can businesses better understand their customers, spending behaviour, and marketing campaign performance?
For this project, I analysed a marketing campaign dataset containing approximately 2,240 customer records using Microsoft Excel.
What I worked on:
ā
Analysed customer demographics and income patterns
ā
Compared average spending across six product categories
ā
Evaluated marketing campaign acceptance rates
ā
Identified records with missing income values
ā
Built a dashboard using PivotTables, KPIs, charts, and a country slicer
Key Findings:
š¹ Customer Demographics: Graduation was the largest education group, with 1,127 customers.
š¹ Spending Patterns: Wines had the highest average spending among the six product categories.
š¹ Campaign Performance: The latest marketing campaign achieved a 15% acceptance rate.
The goal was to turn raw customer data into clear, accessible insights that could support further marketing analysis and business decision-making.
Tools & Skills: Microsoft Excel | PivotTables | Data Analysis | Data Visualization | KPI Reporting | Dashboard Development
I'm building my portfolio around practical data analysis and business-focused insights.
If you need help analyzing spreadsheets, understanding customer data, or building Excel dashboards, feel free to get in touch!
#DataAnalytics #MicrosoftExcel #DataAnalysis #ExcelDashboard #MarketingAnalytics
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
Episode #6: The bank balance is NOT your profit.
āI have AED 250,000 in the bank, so Iām doing great.ā
Not necessarily. Look at whatās actually inside that balance:
š£ AED 100,000 is a bank loan. You have to pay it back.
š” AED 60,000 is customer advances. You havenāt delivered the work yet.
šµ AED 15,000 is VAT collected. It belongs to the tax authority.
šµ AED 45,000 is your own capital that you put in.
š¢ AED 30,000 is the actual profit.
Cash and profit are different things, for three reasons:
1ļøā£ Timing. An invoice youāve sent is profit, but it isnāt cash until the customer pays.
2ļøā£ Non-cash costs. Depreciation lowers your profit, but no money leaves the bank.
3ļøā£ Not your money. Loans, advances, VAT and capital all add to your balance without adding to your profit.
Profit = Revenue earned ā Expenses incurred.
Earned ā received. Incurred ā paid.
Before you spend, ask:
ā
Did customers pay me, or did I only invoice them?
ā
Is any of this a loan, advance, VAT or my own capital?
ā
Which bills and taxes are still due?
ā
What is my real profit this month?
If you canāt answer these, your bank balance is giving you a false picture of how the business is doing.
Next up: Episode 7. Follow along so you donāt miss it.
Counting Crux |
#Accounting #UAEBusiness #Profit #CashFlow #Bookkeeping #Founders #DubaiBusiness #SmallBusiness
Cash flow and profitability are two different things. Understanding where your money comes from and where it needs to go is essential for making smarter business decisions.
Understanding Vaccine Cold-Chain Performance
I used stimulated data to examine the effect of storage equipment and associated variables on vaccine excursion.
I downloaded the Vaccine Cold Chain Management dataset from Hugging Face using Python. I organized and combined the data from regional vaccine stores, district hospitals, and rural health posts using MySQL, then used Tableau Public to build an interactive dashboard exploring equipment functionality, staff training, temperature compliance, vaccine wastage, and power outages.
Three key insights were uncovered.
Rural health posts recorded the highest heat and freeze excursion rates.
Longer power outages were associated with lower temperature compliance.
Reliable equipment alone isn't enough. Staff training and proper maintenance matter too.
Very interesting š
Verity is an AI-assisted text analysis project designed to examine text patterns and present an interpretable score based on its analysis. The project explores how technology can help users assess written content through structured analysis and accessible feedback.
Verity is an AI-assisted text analysis project designed to examine text patterns and present an interpretable score based on its analysis. The project explores how technology can help users assess written content through structured analysis and accessible feedback.
I contributed...