BUSINESS INTELLIGENCE
ROLE
Data & Business Analyst, Huawei Technologies
TOOLS
Power BI · SQL · Excel
TIMEFRAME
Oct 2024 to present
IMPACT
3-day manual process → near real-time
Lead KPI reporting on conversion, campaign performance and revenue movement took three days of manual work per cycle. By the time numbers reached decision-makers, the moment to act on them had often passed. Deep dives were expensive, so they rarely happened.
I rebuilt the reporting pipeline around automated Power BI dashboards fed directly from campaign and subscriber data. The design principle: every metric a marketing lead or executive asks about weekly should be self-serve, current and drillable. I modelled the data for fast slicing by segment, channel and campaign, and designed dashboard views for two distinct audiences: executives who need the headline in five seconds, and analysts who need to interrogate the “why” underneath it.
Reporting went from a 3-day manual process to near real-time. Marketing and executive teams now run monthly and ad-hoc deep dives on performance gaps and emerging trends themselves, and analyst time moved from assembling numbers to explaining them.
BY THE NUMBERS
3 days → live
reporting cycle time
2
audiences served: executive & analyst views
100%
of lead KPIs self-serve and drillable
