Data Analyst Needed – SQL Data Extraction & Power BI Dashboard for Sales Reporting

Posted 4 weeks ago

Worldwide

Summary

We are a retail business with our transactional data stored in a relational database (SQL Server). We need an analyst who can write efficient SQL queries to extract and transform the data, then build a clean, interactive Power BI dashboard for our management team. What I need: Write SQL queries to extract and join data from 4–5 tables (orders, customers, products, regions, returns) Transform and aggregate the data (monthly summaries, YoY comparisons, category breakdowns) Build a Power BI dashboard with: Revenue and profit trends (monthly/quarterly) Regional sales performance map Product category breakdown Return rate analysis Dashboard should be clean, filter-friendly, and usable by non-technical staff Tech stack: Database: SQL Server (we will share read-only credentials) Visualization: Power BI Desktop (.pbix file as deliverable) Data size: ~50,000 rows across 5 tables Deliverables: Documented SQL scripts (.sql file) Power BI dashboard file (.pbix) 1-page summary of key findings Timeline: 7–10 days

  • $400.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Data Analysis
SQL
Microsoft Power BI
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:4 weeks ago
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Jun 1, 2026
  • India
    3:17 PM

Explore similar jobs on Upwork

Local Lead GenerationHourly‐ Posted 2 weeks ago
Web Scraping
Data Scraping
Data Extraction
Lead Generation
Data Entry
Data Mining
Data Collection
Data Processing
Web Scraping Framework
Web Crawler Framework
Web Scraping Software
Web Scraping Plugin
Web API
Search Tool
Search Engine
Microsoft Word
Data Entry
Administrative Support
Microsoft Excel

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo