Power BI + Smartsheet Data Visualization Design

Job ID: 40543619

Budget: £20 – £250 GBP

Seeking a Power BI + Smartsheet Visualization Expert

I need a specialist to design a highly robust, executive-grade analytics layer across Power BI and Smartsheet. The goal is to turn operational data into clear, actionable visuals with automated refresh and reliable governance.

Scope:

Build interactive Power BI dashboards (KPIs, trends, drilldowns, alerts) with strong performance on large datasets.
Integrate Smartsheet (reports, sheets, control center) as a governed data source/workflow hub.
Design a clean data model (star schema, DAX measures) and row-level security.
Create reusable templates, documentation, and a simple handover playbook.
Key Requirements

Proven portfolio of advanced Power BI dashboards (DAX, Power Query, performance tuning).
Hands-on Smartsheet expertise (Data Shuttle/DataMesh, Reports, Control Center, permissions).
Experience with data architecture, gateway/refresh, and RLS.
Strong UX for executives and operations; mobile-friendly layouts.

Nice to Have:

Python/R for advanced transformations.
Power Automate for alerts/workflows.
Azure (Synapse, Data Lake) or SQL for scalable back end.
Deliverables:

2–3 production-ready Power BI reports with KPI summary, drill-through, and export.
Smartsheet-connected datasets with scheduled refresh and documented lineage.
Data dictionary, DAX catalog, and admin guide.
Performance benchmarks and testing results.
Tags to select:
Power BI
Microsoft Power BI
Smartsheet
Data Visualization
Business Intelligence
Dashboard Development
KPI Dashboards
Executive Reporting
Data modelling