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
Excel Reporting & Automation Specialist
Created an Excel PivotTable-based summary and reporting system to organize and analyze timesheet data. The report summarizes project, employee, regular hours, overtime, and employee status information in a clear and structured format. PivotTable reporting makes it easier to review large amounts of data and quickly identify important totals and summaries.
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
Automated Shopify P&L in Google Sheets
Built a reporting workflow that brings Shopify sales data, Meta Ads spend, and COGS into one automated Google Sheets P&L.
The workflow:
🛍️ Shopify API → Sales, orders, refunds & product data
📣 Meta Ads API → Advertising spend & campaign data
📁 Google Drive → COGS file uploads
⚙️ Google Sheets + Apps Script → Data cleaning, calculations & reporting
The final P&L can track:
• Revenue
• COGS
• Gross Profit & Margin
• Ad Spend
• Net Profit
• Product-level profitability
The goal is simple: reduce manual reporting and give the business a clearer view of actual profitability.
Built by Skillytics Consulting for practical ecommerce analytics and automation.
#Shopify #GoogleSheets #AppsScript #EcommerceAnalytics #PAndL #BusinessAutomation #DataAnalytics
Crystal Homes: Real Estate Sales and Rental Analytics Dashboard
End-to-end analytics project for a fictional Nigerian real estate agency. Raw data from Google Sheets went into MySQL, where I built 21 SQL views, then into a 4-page Power BI dashboard covering sales performance, active rental income, lease expiry tracking, portfolio health, and agent/branch performance. It surfaced findings like ₦468M in tracked revenue and cross-branch sales attribution.
Tools: MySQL, Power BI, SQL, Google Sheets
