News / All News / Article

Penguin Case Study | How Weiming Penguin Helped a Pharmaceutical Company Transform Its Data System by Adding an Intelligent BI Mode

Article images may contain Chinese text.

Amid industry changes including tighter pharmaceutical compliance requirements, continued upgrades to China’s Golden Tax Project in 2026, more refined marketing, and AI pushing for greater workforce efficiency, the inefficiency and fragmented data of traditional data systems have become common challenges for pharmaceutical companies. Weiming Penguin is using specialized solutions to help them overcome data-driven decision-making challenges, attracting widespread industry attention. The key foundations for success in projects like these are as follows:

  •  Clarify requirements: how to assess the core business.

  •  Focus on priorities: how to break down key business activities.

  •  Present the data: data quality and frequency.

  •  Current costs: select the appropriate features and tools to get the job done.

  •  Future flexibility: the initial implementation and subsequent upgrades.

In short, success in projects like these requires both a deep understanding of the industry and its challenges and a keen grasp of senior management’s needs. Current one-time requirements and future iterative upgrades must both be addressed. Only a comprehensive approach can deliver success!

Image

The emergence of a new generation of intelligent BI products incorporating AI capabilities is moving pharmaceutical BI beyond specialized tools with a high barrier to entry and into a new intelligent stage that is accessible to everyone, accurate, and efficient, bringing fresh momentum to digital transformation in the pharmaceutical industry.

Image
Image
PART.
1
Current Conditions and Bottlenecks: The Challenges of Traditional Data Analysis

Traditional data analysis workflows have clear collaboration barriers between business and data departments, making it difficult to unlock data value efficiently. The main challenges fall into four areas:

(1) Slow responses to requests and lengthy decision cycles: After a business department submits a data analysis request, it must pass through multiple steps, including coordination with the data department, data extraction, modeling, and report creation. The process takes an average of 2–5 weeks, far too long to meet the need for timely business decisions.

(2) Difficulty meeting ad hoc needs and a lack of incremental analysis: Traditional BI relies primarily on fixed reports and struggles to address business users’ ad hoc queries and personalized analysis needs. Statistics indicate that approximately 80% of data analysis requests are one-off, ad hoc analyses. Yet technical barriers and process constraints mean that most of these requests are shelved, wasting substantial opportunities to extract additional value from data.

(3) Heavy dependence on technical staff and a disconnect between business and data: Traditional BI is complex to operate, requiring professional IT staff or data analysts to extract data and build models, which makes it difficult for business users to participate directly in data analysis. This model—“business submits requests, technical staff perform the analysis”—distances data interpretation from business scenarios and makes it hard for the results to align precisely with actual decision-making needs.

(4) An imbalance between resource supply and demand, with substantial data waste: Companies have a pronounced imbalance between the numbers of technical staff and business staff. Often, 1 technical or data specialist must handle requests from dozens of business users. Overburdened data departments cannot accommodate every analysis request, ultimately leaving more than 80% of data unused effectively and trapped in a state of “dormant data.”

Traditional BI also presents a steep learning curve and difficulty accessing data in real time. Frontline business users, a core group of data consumers, lack specialized data analysis skills and therefore struggle to uncover data value independently. Meanwhile, sales teams and management working on the go cannot conveniently obtain data support, further limiting the breadth and depth of data-driven decision-making.


PART.
2
Development Trends: Intelligence and Convenience Become the Core Directions

With breakthroughs in large model technology, BI products are undergoing their third major evolution:

  • From traditional customized BI

  • Agile drag-and-drop BI

  • To a new generation of BI centered on “intelligence + convenience”

Technology drives innovation as generative analytics becomes mainstream: Breakthroughs in large models’ semantic understanding and AI-powered intelligent analysis have given rise to generative analytics tools. Through natural language interactions, users can meet their data analysis needs without knowing SQL or modeling techniques. This innovative experience dramatically lowers the barrier to using BI, transforming data analysis from a “specialized operation” into an “everyday conversation.”

Enterprise demand accelerates AIGC adoption: Companies broadly recognize the importance of data-driven decision-making, and more than 60% of Chinese enterprises plan to adopt AIGC as soon as possible to improve production efficiency. Business users increasingly need quick access to figures and flexible analysis. Traditional BI can no longer meet companies’ core needs to reduce costs and improve efficiency, making intelligent BI an inevitable choice for enterprise digital transformation.

An upgraded user experience makes accessibility for everyone essential: BI users are expanding from data specialists to all business employees and management, with “everyone a data analyst” becoming an industry goal. This requires BI products to break down technical barriers through simpler operations, more natural interactions, and more intuitive results, allowing users at different organizational levels and skill levels to get started quickly.

Image

PART.
3
Intelligent BI’s Capabilities and Advantages: Reshaping the Data Analysis Paradigm

By deeply integrating large models with traditional BI technology, intelligent BI products establish a new analysis model based on natural language questions and answers. Their core capabilities and advantages include the following:

(1) Accessible Interaction: A Data Analysis Assistant Anyone Can Use

Intelligent BI uses natural language questions and answers as its primary interaction method, completely breaking down traditional BI’s technical barriers. Business users do not need to learn SQL or complex drag-and-drop operations. They can simply state a request in everyday language, such as “Show the distribution of consumption revenue excluding tax by revenue region for 2023,” and the system will automatically understand their intent and generate analysis results. This beginner-friendly interaction model transforms data analysis from an “exclusive skill” for specialists into a “general-purpose tool” for all employees, serving business users, management, and other user groups.

(2) High-Efficiency Output: Responses in Seconds and Simpler Workflows

Intelligent BI dramatically shortens the data analysis workflow, delivering answers to questions within seconds. Through a Multi-Agent collaboration framework, the system breaks complex questions into subquestions and automatically performs a series of operations, including intent recognition, parameter extraction, data validation, and SQL generation, without manual intervention. This not only cuts the traditional weeks-long analysis cycle to seconds but also replaces the lengthy process of “business submits a request–IT extracts the data–analysis is returned.” Business users gain control of the data analysis process, significantly improving their efficiency.

(3) High-Precision Analysis: Adaptability Across Scenarios and Accuracy Assurance

Intelligent BI has strong capabilities for handling complex scenarios and can accurately address a wide range of data analysis needs:

Multi-table joins and intelligent table selection: Users do not need to concern themselves with data table structures. The system automatically matches relevant tables based on the semantics of a question and supports analysis across joined tables—for example, joining sales and inventory tables to calculate “out-of-stock product figures for 2024”;

Knowledge base enablement: By adding business terminology, calculation logic, and other content to the knowledge base, the system can understand industry jargon and company-specific metrics, such as “KA customers” and “gross profit margin,” eliminating semantic ambiguity and improving analysis accuracy;

Multidimensional interpretation and attribution: In addition to producing data results, the system can automatically generate analysis reports from multiple perspectives. It supports in-depth interpretation through time-series analysis, anomaly detection, and attribution of fluctuations, and can even use multilevel drill-downs to pinpoint the core causes of data fluctuations.

(4) Coverage Across Scenarios: Multiplatform Support and Flexible Expansion

Intelligent BI supports deployment across mobile devices, PCs, and embedded interfaces, meeting users’ analysis needs anytime, anywhere. Whether business users are conducting in-depth analysis in the office or managers are quickly checking data on the way to visit a client, they can conveniently obtain the information they need. The system also supports a variety of scenarios, including calculations, rankings, comparisons, and composite metrics. From basic metric queries to complex correlation analysis and trend forecasting, it comprehensively covers the data analysis needs of enterprise operational decision-making.

(5) High-Value Enablement: Lower Costs, Greater Efficiency, and Better Decisions

Intelligent BI creates substantial value for companies through the twin drivers of “cost reduction” and “efficiency improvement.” On the cost side, it reduces reliance on specialist data staff, lowering personnel and communication costs. On the efficiency side, it accelerates the cycle from data collection to decision-making, fully unlocking data value. More importantly, intelligent BI brings data-driven decision-making into every aspect of enterprise operations, helping business users quickly identify problems and seize opportunities while supporting management in making more evidence-based strategic decisions, enabling digital transformation to take root throughout the enterprise.

The upgrade from traditional BI to intelligent BI is more than an iteration of technological tools—it is a transformation in the way data analysis is conceived. It breaks down barriers between data and business, making data a decision-making tool that everyone can use and providing a core driver for companies competing in the digital era. As large model technology continues to evolve, intelligent BI will undoubtedly deliver value across more industries and scenarios, leading companies into a new stage of data-driven decision-making.

Image


Image

If your company faces digital transformation challenges such as slow responses from traditional BI, difficulty uncovering data value, or inadequate alignment with business needs, please contact Weiming Penguin. We will provide a customized intelligent BI solution for the pharmaceutical industry to support your company’s transformation.

WeChat_Image_20250316165946.jpg