Power BI Operations Dashboard Developer

Posted 2 weeks ago

Only freelancers located in the U.S. may apply.U.S. located freelancers only

Summary

Seeking a Power BI developer to build the first phase of an operations dashboard for a small services company. We report on four locations. Data comes from a read-only SQL database from our field operating system. We provide the schema, server, and credentials. No API work, no Excel imports. Phase 1 scope: connect to the database, build a ticket-level fact table with a date table and supporting dimensions, write roughly a dozen DAX measures, and deliver one weekly operations table showing month-to-date on top with each week below, broken out by location. Publish to the Power BI service with a working scheduled refresh. The data model should carry every ticket-level field from the schema, not just the fields this page displays, because we plan to add pages later. Requirements: strong Power Query and M with native SQL query folding, solid DAX, incremental refresh, and experience publishing with scheduled refresh. Fixed price with a written acceptance checklist. The measures must reconcile to our existing spreadsheet on the same inputs before payment releases. Done means the numbers tie, not that the page looks right. This is the first milestone of a larger project. Good work leads directly to more.

  • Less than 30 hrs/week
    Hourly
  • 1-3 months
    Duration
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Tableau
Microsoft Excel PowerPivot
Nice-to-have skills
Microsoft Excel
Data Analysis
Activity on this job
  • Proposals:50+
  • Last viewed by client:2 weeks ago
  • Interviewing:
    12
  • Invites sent:
    15
  • Unanswered invites:
    4
About the client
Member since Dec 7, 2011
  • United States
    Madison8:57 AM
  • $5.7K total spent
    12 hires, 0 active
  • 80 hours

Explore similar jobs on Upwork

Build BrightGauge DashboardsFixed-price‐ Posted 3 weeks ago
Data Visualization
Dashboard
Business Intelligence
ConnectWise Automate
ASIO
KPI Metric Development
Information System classHourly‐ Posted 2 weeks ago
Tableau
Dashboard
Looker Studio
Data Visualization
Microsoft Power BI
Python
Microsoft Power BI Data Visualization
Business Intelligence
Data Modeling
Data Science
Analytics
ETL Pipeline
Data Management
Database Design
Database Architecture

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