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
Developed a comprehensive data analytics solution analyzing transaction data from 21 restaurants in Paris powered by Tiller by SumUp. The goal was to provide actionable insights into post-COVID revenue recovery and product performance.
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
🚀 Built an Automated Invoice Generation System in Excel
Many small businesses still spend valuable time creating invoices manually.
To solve this problem, I developed an automated invoice system in Excel that instantly generates professional invoices while reducing manual data entry and calculation errors.
Key Features:
✅ Automatic Customer Information Retrieval
✅ Product-Based Dynamic Invoice Generation
✅ Automated Tax Calculations (SGST & CGST)
✅ Auto-Populated Product Details & Pricing
✅ Dynamic Total & Grand Total Calculation
✅ Clean and Professional Invoice Layout
✅ Faster and More Accurate Billing Process
This project demonstrates how Excel can be transformed into a powerful business automation tool without requiring expensive software.
By combining Excel formulas, data validation, lookup functions, and automation techniques, businesses can streamline their billing process and improve operational efficiency.
Tools & Skills Used:
📊 Microsoft Excel
📈 Data Validation
⚡ Excel Automation
🔍 XLOOKUP / Lookup Functions
📋 Invoice Management System
📉 Business Process Automation
Projects like this highlight how automation can save time, reduce errors, and improve productivity in day-to-day business operations.
🎥 Check out the video walkthrough below and let me know your thoughts.
I'm currently open to freelance opportunities involving:
• Excel Automation
• Dashboard Development
• Data Cleaning
• Power BI Reporting
• SQL & Python Analytics
#Excel #ExcelAutomation #InvoiceAutomation #BusinessAutomation #DataAnalytics #MicrosoftExcel #Dashboard #BusinessIntelligence #DataAnalyst #ExcelDashboard #Automation #Reporting #Productivity #DataManagement
East Africa Mobile Money Performance Analysis Dashboard
Prepared by Intersect Analytics | Power BI, Data Analytics & Business Intelligence
Mobile money continues to reshape financial inclusion, digital payments, and economic activity across East Africa. To evaluate the performance of the region's leading operators, Intersect Analytics developed an executive-level Power BI dashboard analyzing transaction activity, user adoption, market share, and growth trends across key markets.
Key Findings
M-Pesa Maintains Regional Leadership
M-Pesa remains the dominant mobile money platform, leading in transaction volumes, active users, and market penetration. Its extensive ecosystem continues to strengthen its competitive position across the region.
Airtel Money Continues to Gain Momentum
Airtel Money has demonstrated strong growth, driven by increasing customer adoption, expanding service offerings, and rising transaction activity across multiple markets.
Digital Financial Services Are Experiencing Sustained Growth
The continued increase in mobile money usage highlights the growing importance of digital financial services in facilitating payments, commerce, savings, remittances, and financial accessibility.
East Africa Remains a High-Growth Market
Kenya, Uganda, Tanzania, Rwanda, and Ethiopia continue to present significant opportunities for financial institutions, fintech companies, investors, and businesses operating within the digital payments ecosystem.
Development Approach
Data was collected from industry publications, operator reports, and financial inclusion research.
Python was utilized for data extraction, cleaning, validation, and preparation using:
• Pandas
• NumPy
• Requests
• BeautifulSoup
• OpenPyXL
The final solution was developed in Power BI using Power Query, Data Modeling, DAX, and interactive visualizations to deliver clear, actionable insights for decision-makers.
Our Services
📊 Power BI Dashboards & Business Intelligence
📈 Financial Analysis & Performance Reporting
🐍 Data Scraping, Cleaning & Preparation
⚙️ Excel & Google Sheets Automation
🗄️ SQL & Database Analytics
🔄 Business Process Automation
Why Organizations Choose Intersect Analytics
We help organizations transform complex data into meaningful business intelligence by combining analytics, automation, and reporting expertise. Our solutions are designed to reduce manual effort, improve operational efficiency, accelerate decision-making, and provide the visibility required to support sustainable growth.
INTERSECT ANALYTICS
Power BI | Business Intelligence | Data Analytics | Automation | Financial Analysis
Decisions Backed by Data. Growth Driven by Insight.
📞 +254 723 632 207
The restaurant had a strong menu and excellent customer experience but struggled to translate that into online engagement. Their social media pages lacked a consistent content strategy, resulting in low reach, minimal audience interaction, and slow follower growth.
KEY CHALLENGES;
Inconsistent posting schedule
Low engagement rates
Limited brand awareness within the local community
Minimal customer-generated content and online conversations
GOALS;
Increase brand awareness and online visibility
Grow the restaurant's social media following
Improve engagement across social platforms
Drive more inquiries and foot traffic through social media
Love the direction of this project. The final result is both visually appealing and professional.
Challenges
View all
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
portfolioreview
The best portfolios tell a story, not just show a grid. Share yours for feedback.
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?
