Discover how SR Analytics transformed Awe Inspired’s operations with innovative solutions, empowering them to optimize inventory and drive growth. Learn how the collaboration delivered actionable insights, streamlined processes, and prepared the company for future success.

Awe Inspired is a mission-driven fine jewelry brand based in Los Angeles, California. The company specializes in creating meaningful, high-quality pieces that celebrate empowerment and resilience. Awe Inspired has captivated a loyal audience with its Goddess Collection and other iconic designs, fostering a deep connection with customers worldwide.

Since its launch five years ago, Awe Inspired has grown into a prominent name in the jewelry industry, achieving an impressive 40% year-over-year growth. This success is built on a foundation of exceptional craftsmanship and a commitment to giving back, with a portion of every sale donated to charities supporting women and communities in need.

As the business has scaled, Awe Inspired’s operational complexity has increased, requiring advanced solutions to manage inventory, streamline operations, and maintain its growth momentum.

Awe Inspired’s fast growth brought several operational challenges, especially in managing their inventory. As the company introduced more products, their inventory size grew rapidly. This tied up a lot of capital and made their operations more complex.

Managing their wide range of products, including bundles and sets, became difficult. On top of that, they were working with more vendors to source raw materials, which required better organization and clearer data.

Their existing tools didn’t give them the insights they needed. Without proper visibility into their inventory data, it was hard to plan demand or optimize stock levels, which led to inefficiencies in their operations.

Challenges Summary:

• SKU Growth: A five- to ten-fold increase in SKU count tied up capital and added complexity.
• Product Diversity: Managing sets and bundles increased stock management challenges.
• Vendor Management: Sourcing from numerous vendors required enhanced tier management.
• Data Gaps: Limited visibility hindered decision-making and demand planning.

To tackle their operational challenges, Awe Inspired partnered with a trusted team of SR Analytics they had worked with before. The company relied on experts who could deliver results quickly and efficiently.

The project started with integrating data from platforms like Shopify, Cin7, Airtable, Excel, and Google Sheets. Using ETL (Extract, Transform, Load) processes, all the data was consolidated into a centralized data warehouse in Google BigQuery. This setup provided a solid foundation for creating a reporting system tailored to Awe Inspired’s needs.

A suite of BI reports was then developed in Power BI to provide actionable insights into inventory management and operational efficiency. Throughout the process, the team ensured smooth communication by using dedicated Slack channels, regular feedback sessions, and shared documents for tracking progress.

The proactive and well-structured approach made collaboration seamless. The team’s professionalism and clarity in communication ensured that the project ran smoothly and met expectations.

Solution Summary:

• Integrated data from Shopify, Cin7, Airtable, Excel, and Google Sheets.
• Built a centralized data warehouse in Google BigQuery.
• Developed a Power BI reporting solution tailored to inventory management needs.
• Ensured seamless communication and collaboration.

“The solution significantly improved how Awe Inspired operated. By automating reporting processes, the team could save time and reduce workload, allowing them to focus on more strategic tasks. This efficiency helped free up resources equivalent to almost half a full-time employee.”

Inventory management also saw immediate results. With tighter controls, the company was able to reduce excess stock levels and improve how they managed inventory. Enhanced visibility gave them the ability to make better decisions, such as positioning products more effectively and adjusting their sales strategies based on inventory levels.

These improvements laid the groundwork for a stronger future. Awe Inspired now relies on this new system for their day-to-day operations and has engaged the team to explore other areas of optimization, including e-commerce and site performance.

Impact Summary:

• Efficiency Gains: Reporting automation reduced workload by nearly half an FTE.
• Inventory Optimization: Improved visibility led to reduced excess inventory levels.
• Strategic Insights: Integrated inventory data into sales and merchandising strategies.
• Long-Term Partnership: Positioned SR Analytics as the BI agency of record for future projects.

Awe Inspired’s journey highlights how a clear vision and effective collaboration can lead to transformative results. But achieving operational excellence in today’s complex business environment requires more than just ambition.

That’s where SR Analytics comes in. We specialize in empowering businesses like Awe Inspired to overcome operational challenges, streamline processes, and unlock the full potential of their data. Whether you’re looking to optimize inventory, improve reporting, or drive strategic insights, SR Analytics is your trusted partner.

Why wait? Explore our solutions today and see how we can help you achieve your business goals.