Skills that make the work valuable
- Dimensional modeling
- Dashboard development
- Metric definition
- Report access controls
Build proof, not just a list
Build a sales and returns dashboard from fictional order records with a documented metric dictionary. Show reconciliation to source totals, role-specific views, and a clear explanation of refresh timing and exclusions.
How to price this work as a freelancer
Agree on metric definitions, dashboard audiences, refresh requirements, and source systems before estimating report pages. Quote data modeling and stakeholder validation as real work. Licensing, scheduled refresh failures, access permissions, and metric changes can create ongoing costs beyond the initial dashboard build.
Start with the income you need to replace
Required hourly rate = (target salary + benefits budget + annual business expenses) ÷ (annual billable hours × share of revenue retained after fees).
For illustration, $100/hour × 25 billable hours/week × 48 working weeks = $120,000 revenue. After $20,000 in business expenses, that leaves $100,000 profit before personal taxes. Replacing a $100,000 salary plus $15,000 in benefits under those assumptions takes $112.50/hour, with no percentage fees.
These are editable planning assumptions, not rates surveyed for business intelligence analyst work. Your personal taxes, location, contract terms, and workload still affect the comparison.
Employee or freelancer?
Working as an employee
Employment supports ongoing relationships with finance and operations teams who own key definitions. You may inherit reporting tools and inconsistent source systems that constrain how quickly dashboards can change.
Running a freelance business
A reporting package can have clear deliverables and training requirements. Its usefulness depends on agreed definitions and refresh ownership, so secure stakeholder signoff and define who maintains the data connections.
Where this career could take you
- 01Reporting Analyst
- 02Business Intelligence Analyst
- 03Business Intelligence Lead
An example path, with room for lateral moves or specialization. Progression depends on opportunities and demonstrated work; these steps do not imply a timetable or salary increase.
Try one small next step
Create a metric dictionary for a fictional shop before building its dashboard. Ask two people to interpret the same chart and revise definitions when their answers differ.