Back

How Ipsen Pharma built one reporting standard with Power BI and Zebra BI 

5 min read
Request a Zebra BI demo

Key Results with Zebra BI

One reporting standard, six functions: replaced fragmented department dashboards across sales, marketing, medical, finance, market access, and leadership with a single company-wide standard.
Market share diagnostics in minutes: a drop that used to stop at the national level can now be drilled to channel, region, and prescriber in the same dashboard.
Dashboards people actually use: the Management Overview became the monthly report leadership reaches for, not one that sits unread.
Self-serve analytics: executives who used to route every data question through the team now find their own answers.
Impact beyond the numbers: in rare disease, faster insights mean patients get life-improving treatments sooner. That's the motivation behind everything the team builds.

This is our reporting standard. We do not accept anything below it anymore.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma 

Ipsen Pharma's five-person Business Excellence team rebuilt analytics across sales, marketing, medical, finance, market access, and leadership on Power BI with Zebra BI. The result: one reporting standard, faster market share diagnostics, and a Management Overview leadership opens every month. 

About Ipsen 

  • Industry: Pharmaceuticals (oncology, rare diseases, neurology) 
  • Featured team: Business Excellence, Munich 
  • Stack: Power BI + Zebra BI 
  • Use cases: Sales performance, market share analysis, executive reporting, salesforce effectiveness 

Robert Anschütz has a story he likes to tell. A few years into his role as Business Excellence Lead at Ipsen Pharma's Munich office, his team had rolled out a new generation of dashboards, all built in Power BI with Zebra BI visuals on top.

He was crossing the cafeteria when a sales rep, a veteran close to retirement, stopped him. The dashboards were great, the rep said. He could finally do, in seconds, things he had always wished he could do. 

For a 5-person team responsible for analytics across a global pharma company active in oncology, rare diseases, and neurology, that minute mattered. 

The Power BI problem: A different dashboard in every meeting 

Ipsen had adopted Power BI as its reporting standard years earlier, but adoption had remained low. Every department had its own dashboards, its own colors, its own shorthand for the same numbers. 

a dashboard redesigned with IBCS recommendations
Sales dashboard with Zebra BI visuals. Disclaimer: The data in the image is fictional and intended solely to demonstrate the layout and structure of the report.

The deeper issue was structural. Reports forced a tradeoff nobody at Ipsen was willing to live with: 

  • Top-level overview yes, but no detail underneath 
  • Full granularity yes, but you lost the headline KPIs 
  • Same metric, different teams marketing, leadership and sales each had their own version 

If I sat in a marketing meeting, I would see a different dashboard than when I sat in a leadership meeting. Different colors, different ways of showing data.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma
Still using a different dashboard in every meeting?
Zebra BI gives every team one reporting standard - same metrics, same visuals, full context at a glance.
Book a demo
Microsoft-certified. IBCS-compliant. Trusted by global enterprises.

First contact with Zebra BI 

Robert had been wrestling with a dataset from a third-party provider. He sketched out how he wanted it visualized, sent the screenshots to his Power BI Reporting Manager, and waited. The reply was short.

"Yes, thank you, but let me show you something."  

What came back was a Zebra BI dashboard built on Robert's data, with every KPI he had asked for at a glance and the granularity sitting one click away. 

I was intrigued the moment I saw it. It finally gave me everything I needed.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma

How Zebra BI became the reporting standard across six functions 

Within months, Zebra BI had moved from one analyst's screen to every report the team built. From there it spread outwards across six functions: 

  • Sales: territory and HCP-level performance 
  • Medical: engagement and reach reporting 
  • Finance: performance versus budget and forecast 
  • Market access: channel and segment tracking 
  • Leadership: Management Overview, every month 

Training rolled out by function. The data-savvy teams got the full toolkit. Top management got a leaner version with the KPIs they used and a path to dig deeper when they wanted to. 

Screenshot of a consolidated financial Power BI dashboard template showcasing earnings vs PY vs plan by region and business unit with Zebra BI
Net earnings with Zebra BI visuals. Disclaimer: The data in the image is fictional and intended solely to demonstrate the layout and structure of the report.

Now this is a standard across the company. You always know how your sales developed, how your market share developed. Everybody looks at the same thing.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma 

Market share analysis in minutes: Diagnosing a drop with Zebra BI 

The clearest proof of the shift shows up when something goes wrong. A market share number drops. Where is it coming from? 

Before Zebra BI, the answer used to stop at the national level. The gap was visible, the cause was not. 

Zebra BI visuals for financial reporting
Revenue dashboard with Zebra BI visuals. Disclaimer: The data in the image is fictional and intended solely to demonstrate the layout and structure of the report.

Now, Robert opens the same dashboard and walks the question down: 

  • National view: confirm the drop 
  • Channel split: hospital or retail? 
  • Region split: east or west Germany? 
  • HCP level: which prescribers are we still seeing? Which are we missing? 
  • Track the recovery: same dashboard, week by week 

Within seconds, we can pinpoint where we're losing. Within minutes we know what to do.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma
Spend more time analyzing, not formatting
Zebra BI standardizes reporting and automates context so your teams focus on insights, not manual corrections.
Talk to a specialist
Microsoft-certified. IBCS-compliant. Trusted by global enterprises.

The Management Overview: Dashboards leadership opens every month 

The crown jewel of the rollout is something Robert's team calls the Management Overview. Four monthly reports, all built on Zebra BI: 

  • General Manager Dashboard: top-level KPIs from the main pharma data sources every German pharma company uses 
  • Executive View: same data, top-level, light filters, for fast scans 
  • Full Granularity View: every dimension, for the analysts who want to dig 

There's nothing worse than creating a Power BI dashboard just for yourself. You want others to make use of it. That's what we achieved.


Robert Anschütz, Business Excellence Lead, Ipsen Pharma 

The ROI: Self-serve analytics and time back for the team 

Asked about ROI, Robert will not give you a hard number. What he will tell you is that the math on his team has changed. Executives who used to route every question through his analysts now find their own answers with self-serve analytics. His team has been freed up to focus on the questions only they can answer. 

And in rare disease, the return goes beyond time saved.  In a rare disease, every patient really counts. If we have a way to better analyze the data and generate insights, that means patients get life-improving treatments at an earlier point in time. That's basically the motivation for our daily work.

Advice for other Power BI teams

Zebra BI brings the best of both worlds. The top-level view, the most important KPIs at a glance, and at the same time the full granularity of the data. It's intuitive. It's easy to understand. People understand what the values actually mean and how they've developed over time.

Top-level overview and full granularity. Now the company-wide standard at Ipsen Pharma.

Turn Power BI into a company-wide reporting standard like Ipsen Pharma


Zebra BI unifies dashboards across every function so your teams always look at the same data and decisions move faster at every level.