Business intelligence

From 3-day reports to real-time Power BI

Replacing a three-day manual reporting cycle with dashboards that marketing and executives can check for themselves.

RoleData & Business Analyst, Huawei Technologies
ToolsPower BI · SQL · Excel
TimeframeOct 2024 to present
Impact3-day manual process to near real-time
KPI overviewLive
CONVERSION
CAMPAIGNS
REVENUE
REFRESH
3 days → live

Challenge

Lead KPI reports on conversion, campaigns and revenue took three days of manual work each cycle. By the time numbers reached decision-makers, the moment to act had often passed.

Approach

I rebuilt reporting as automated Power BI dashboards fed straight from campaign and subscriber data, modelled for slicing by segment, channel and campaign.

There are two views: a headline page an executive can read in five seconds, and analyst pages for digging into the why.

Outcome

Reporting went from three days to near real-time. Marketing and executive teams now run their own deep dives, and analyst time goes into explaining numbers instead of assembling them.

By the numbers

3 days → livereporting cycle time
2views: executive and analyst
100%of lead KPIs self-serve
Contact

Have a problem like this one? I’m open to data roles and project work, and I’d be glad to talk it through.