About

Project Overview I’m looking for an experienced Looker Studio / Data Visualisation expert to build two premium, fully-custom dashboards: 1. Content Performance Dashboard (Instagram, TikTok, YouTube, Facebook) I currently track detailed post-level metrics in Google Sheets, including: New Followers per post Follows/Views % Profile Visits Saves Shares Comments Likes DM Leads Completion rate Average watch time Performance score (Strong / Elite / Weak) Pillars Hooks Content type I want this turned into a clean, visual, decision-ready Looker Studio dashboard with: Top performers (by new followers / saves / shares / views / DM leads) Trend lines (followers gained per day/week) Filters (platform, date range, score, content pillar, content type) Multi-page layout Easy comparison between posts Branded visual design Custom calculated fields where needed 2. Daily Finance Dashboard I also track my daily balances across multiple accounts (Wio GBP, Wio AED, Jija, Crypto, Revolut, Monzo), along with: Daily totals Investments Staff costs Closers Fees Owed amounts Net available cash I need this transformed into a visual financial control panel with: Daily net-worth trend Account balance breakdown (line or stacked chart) Category spending breakdown (bar/pie chart) Weekly/monthly burn rate Forecasting visuals Net position after liabilities Alerts/conditional formatting (e.g., low balances) What I Need From You Deep experience with Looker Studio (not a beginner) Ability to create clean, modern, branded dashboards Ability to transform messy/raw data into structured visual insights Understanding of key KPIs for: Content performance Social analytics Cashflow & financial tracking Ability to build: Calculated metrics Filters Multi-page layouts Drill-down tables Good communication & ability to follow a clear KPI-driven brief Willingness to guide best practices for future scalability Data Sources Google Sheets (primary source for both dashboards) Deliverables Two complete Looker Studio dashboards Clean, branded visual layouts Full setup with filters & navigation Calculated fields set up correctly Easy-to-understand user flow Documentation or brief walkthrough on how to update data in the future