Problem:
A leading U.S. television and media company needed to strengthen its decision-support capabilities and improve operational efficiency by:
- Enabling root cause analysis and deeper sales performance insights
- Supporting instant data exploration and accurate sales price forecasting
- Improving inventory analysis and management
- Reducing time-consuming manual dashboard analysis and report generation
- Streamlining the lengthy and labor-intensive dashboard development process
Approach:
- Built a custom agent that can leverage LLM capabilities to interpret the user queries quickly
- Connected data sources (Bigquery, Gsheets, Excel reports) to the agent as an MCP(Model Context Protocol) extension
- For interactive visualizations, added a custom extension that accommodates the LLM to generate charts like bar, line, scatter, pie, etc.
Impact:
- Transitioned from static dashboards and manual reporting to conversational analytics on direct data sources.
- Delivered fast, contextual insights to accelerate decision-making and improve agility.
- Reduced manual effort across reporting and analysis workflows.
- Eliminated the need for multiple data downloads and uploads.
- Improved time efficiency by simplifying complex root cause analysis.
- Enabled deeper market intelligence with insights into traffic and revenue behavior.
- Provided strategic consultation to ensure campaigns consistently meet their goals.
