Data Analytics · Business Intelligence
Stakeholder Reporting at Deep Funding
Recurring analytics reports for 8 stakeholders, built on BigQuery, SQL and Google Analytics.
- Status
- In Production
- Year
- 2025 – present
- Role
- Data Analyst (full-time, remote)
- Client
- Deep Funding
01
Overview
I deliver three recurring reports to eight stakeholders using BigQuery, SQL and Google Analytics. Reconciliation checks keep figures consistent across reports, SQL transformations and scheduled data workflows refresh the reports without manual rework, and each clarified request is documented so it is not asked twice.
- BigQuery
- SQL
- Google Analytics
02
The challenge
Stakeholders making decisions from recurring reports need the figures to agree from one report to the next, and unclear requests were a source of repeated questions and rework.
- Keeping numbers consistent across several recurring reports and many readers
03
System requirements
- Three recurring reports delivered to eight stakeholders
- Reconciliation checks between reports
- Maintained SQL transformations and scheduled data workflows
- A written record of each clarified request
04
Solution architecture
Responsibility
Source data
Google Analytics data and warehouse tables in BigQuery.
05
Implementation
Content needed: real screenshots (desktop and mobile). Generated mockups are never shown as screenshots.
06
Technical decisions
- Reconcile figures across reports so stakeholders can trust each number
- Clarify unclear requests up front and document the answer to avoid repeat questions and rework
- Automate refreshes with scheduled workflows instead of manual updates
07
Results and validation
Content needed: measured results with period and method. Never estimated.
Evidence
- Described on the owner's CV (current full-time role). The reports are internal, so there are no public artifacts.
08
Lessons learned
Content needed: what you would do differently
Content checklist (remove once filled)
- Internal dashboards and reports cannot be shown without the employer's permission. Add a clearly labeled synthetic example instead if you want a visual
- A measured result (for example, hours of manual work removed), only if you can state the period and method
- Confirm the wording is acceptable to share publicly with your employer
09