Expert data analyst proficient in excel and data automation
Budget: $250 – $750 USD
I need an experienced data analyst who can turn raw figures from our internal database into a clear, action-oriented dashboard. The end goal is to optimize our operational processes and calculate ROI.
Here’s what I’m looking for:
• Extract and clean data directly from our internal database, setting up a refresh pipeline I can maintain without coding.
• Build a dynamic tracker in Excel or Google Sheets (whichever better fits the data volume) that calculates daily, weekly, and monthly sales.
• Design an intuitive sales dashboard that surfaces trends, segments, and outliers at a glance, with filters for date range and product line.
• Document the workflow so future updates or metric additions are straightforward.
Accuracy, speed, and a knack for presenting insights visually are essential. If you have a proven track record with Excel dashboards, Google Sheets formulas, and database connections, I’d love to see examples and hear how you would approach this build.
Here’s what I’m looking for:
• Extract and clean data directly from our internal database, setting up a refresh pipeline I can maintain without coding.
• Build a dynamic tracker in Excel or Google Sheets (whichever better fits the data volume) that calculates daily, weekly, and monthly sales.
• Design an intuitive sales dashboard that surfaces trends, segments, and outliers at a glance, with filters for date range and product line.
• Document the workflow so future updates or metric additions are straightforward.
Accuracy, speed, and a knack for presenting insights visually are essential. If you have a proven track record with Excel dashboards, Google Sheets formulas, and database connections, I’d love to see examples and hear how you would approach this build.
Related categories:
PHP
Visual Basic
Excel
MySQL
Data Extraction
Data Visualization
Data Analysis
Google Sheets