Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

Retail

New ERP & Enhanced BI Capabilities Power Manufacturer

New ERP & Enhanced BI Capabilities Power Manufacturer

After a recent ERP migration, a large packaging manufacturing company was struggling to understand the new BI environment and create critical business reports for leadership. In a matter of weeks, UDig became familiar with the Qlikview BI capabilities as well as the unique client business and operational requirements for reporting. The consultant wrote custom ETL scripts to enhance the data prep process feeding the BI tool. Once data was properly transformed, the consultant built custom reporting for the client leadership to highlight key performance indicators (KPIs). Company leadership now has quick access to critical performance metrics like contribution margin to help identify opportunities for improvement in operations.

How We Went from Ideas to Impact

  • The Idea

    Align out-of-the-box reporting capabilities with company's operational and strategic performance metrics.

  • The Process

    Apply database and BI expertise to Qlikview environment and extract valuable reporting out of new ERP.

  • The Impact

    Create custom code in backend ETL processes to integrate with Qlikview for seamless report building.

  • Company leadership now has quick access to critical performance metrics like contribution margin to help identify opportunities for improvement in operations.

The Idea

A large packaging manufacturing company recently migrated to a new Enterprise Resource Planning (ERP) software: EFI Radius. The ERP came with built-in Qlikview BI reporting, but the out-of-the-box reports were not in alignment with the company’s standard definition of operational and strategic performance metrics.

The BI tool based in Qlikview had analytic potential, but it was complex to understand how out-of-the-box reports were built or how to create new custom reports for leadership. Qlikview implements a unique flattened data schema, but it was foreign to internal analysts who were comfortable with traditional database structures and more user-friendly BI software. Client turned to UDig to apply database and BI expertise to the Qlikview environment and extract valuable reporting out of the new ERP.

The Impact

By client request, UDig consultant worked with ERP vendor to learn foundational and advanced features within the Qlikview BI environment. Consultant’s extensive experience with database structures and report design sped up the knowledge transfer compared to what the client was capable of on its own.

UDig consultant created custom C++ code in the backend ETL process to load and transform data elements needed for the client’s most critical KPIs. The data was transformed to integrate with the Qlikview flattened database schema for seamless report-building. Consultant built custom reports for company leadership that provide insight to critical metrics like customer and job contribution margin, annual KPIs to budget, and more. Consultant expertise in Qlikview can now be used as needed by the client to quickly develop new reports or revise existing reports.

  • How We Did It
    Dashboard UI/UXData Identification & EnrichmentInteractive BI Application
  • Tech Stack
    Qlikview BIEFI Radius

Digging In

  • Retail

    Empowering Store Associates with an AI-Enabled Customer Experience

    A fortune 500 retailer offers a breadth of products to customers. From hardware to livestock supplies and beyond, at any point, employees must be able to guide customers to the right products for their needs. However, rarely can an employee know all options available to the customer for every product category. As a result, the sales process can become a challenging customer service experience. Needing to streamline how team members help customers and increase sales, an industry-leading company turned to UDig to help develop an AI enabled artificial intelligence solution. They wanted to build a UX prototype to visualize their future-state vision and then bring that solution to life. Ready for the challenge, our team moved quickly to help them create their custom AI software.

  • Retail

    Leveraging Computer Vision (AI) to Optimize the Retail and Sales Experience

  • Retail

    AI Video Analytics is Revolutionizing Retail Operations

    In today’s fast-paced retail landscape, understanding customer behavior and optimizing store operations are crucial for staying competitive. Retailers constantly seek innovative solutions to enhance customer experiences and improve efficiency. Thanks to recent advancements in computer vision and AI, leveraging cutting-edge technologies has become pivotal for addressing various challenges in the retail industry. With the integration […]

  • Retail

    Visioning Success:  How Tractor Supply is Leveraging Computer Vision (AI)

    During this session, we will dive into a real-world example and technical demonstration highlighting Tractor Supply’s success with their “TractorVision” solution in partnership with UDig. Discover how computer vision solutions have enabled Tractor Supply to optimize team member productivity and create a personalized customer experience.

  • Retail

    Boosting Customer Insights and High-Quality Sales Leads for Clayton

    When designing a new home, every buyer has different desires, needs, and circumstances. Homebuilders need to understand these motivations and be able to quickly determine which customers are serious about buying. Without this insight, the sales process becomes bogged down with customers window shopping. So, when Clayton wanted to revamp their sales strategy, they knew they needed a digital experience that could streamline the process. They sought to create a 3D tool that would allow homebuyers to customize their home online through a seamless digital path to ownership. With an idea for their future, Clayton turned to UDig to help them bring their digital vision to life.

  • Healthcare

    Increasing Digital Buyers and Boosting Growth through a Creative Product Strategy

    Health Products Xchange (HPX) is an emergency healthcare supply provider serving the needs of medical facilities and professionals. When disruptions hit the global supply chain, medical providers must find alternative supply sources without sacrificing patient care. HPX aims to be the industry’s answer. However, the COVID-19 pandemic and resulting global supply-chain disruption challenged their growth vision. HPX was struggling to boost adoption of their platform, which they believed was perfectly positioned for the marketplace. So, HPX engaged UDig to help them build a strategy for digital growth and design a better way forward.

  • Retail

    Improve Customer Experience and Inform Buyers with Detailed, Supplementary Information

    Customers understand why credit decisions were made and can view vehicles they are pre-approved for with one click.

  • Retail

    Modernized Website Improves Overall User Experience for a Large Homebuilder’s Mortgage Business

    A company-wide modernization effort prompted our client, the mortgage arm of a large homebuilder, to update their public-facing website. The overhaul included new, important functionality previously not available to their customers online and a complete re-imagination of their user experience.