The Orchard Scales Client Reporting with Rollstack 

The Challenge: Scaling reporting for 10k+ clients and labels

The Orchard, a leading distributor for artists under the Sony Music umbrella, faced a critical last mile data problem. The 5 person analytics team, led by Murali Char, VP of Analytics supports a massive, fast-moving organization whose core mission is to empower creators to grow and adapt. Execs and artists clients all demand regular reporting and deep context given that songs can go viral in an instant across millions of tracks, thousands of artists, and consumption across numerous platforms like Spotify or YouTube.

Despite having a robust data stack built on Snowflake, DBT, and BI tools like Looker and Tableau, the final step of delivery—getting data into thousands of tailored client facing reports and executive decks—was completely manual.

• Unscalable Workflow: Analysts were forced to manually take snapshots from BI dashboards and copy them into presentation decks. This was unscalable for serving nearly 1k employees and over 10k clients.
• Analyst Time Drain: Murali's team spent too much time on data preparation, preventing them from stepping into more valuable advisory roles. Murali also struggled with resource demands and having to decline important stakeholder requests.
• Time-Sensitive Data: The music industry's insights have a very short shelf life, making constant manual updates impractical and quickly rendering reports obsolete.

The Solution: Connect Tableau and Looker to Powerpoint with Rollstack

The Orchard adopted Rollstack to bridge the gap between their BI tools and the presentation layer. Rollstack eliminated manual processes and solved both their repeat reporting needs and their more complex needs of building tailored reports for over 10k clients and labels.

The two phased rollout was fast - the internal pilot only took 6 weeks to deliver value:

• Internal Pilot: The team first targeted and automated internal review decks, proving the concept and achieving buy-in from demanding internal stakeholders.
• Horizontal Scaling: Next, the team scaled reporting to labels and clients. Rollstack connects directly to their Looker and Tableau instances BI, bringing trusted data and visualizations into over 6.5k branded, client-facing decks.

Rollstack empowered Char's team of five analysts to achieve what was previously considered impossible: scaling reporting across their extensive client and label network without dedicating manual resources to each report.

The Impact: Happy, Informed Clients and Execs Thanks to Tailored Reports

Rollstack delivered substantial time savings, increased accuracy, and allowed the analytics team to refocus their efforts on strategic impact.

• Scaled and Tailored reporting: Analysts were finally able to deliver timely, consistent, branded reporting across a global client network delivering greater client and exec satisfaction.
• Exponential Reporting Growth: The volume of reports surged dramatically, growing from an initial pilot phase of 146 client reports per quarter to more than 6.5k client reports per quarter.
• Strategic Focus: Analysts were able to shift their focus from preparing data to building narratives and driving decisions.