INF30004 - Business Intelligence and Data Visualization Assignment

Assignment Task

ACME Bikes Emporium Gearing Up for Global Growth

ACME Bikes Emporium (ACME), a well-established international retailer with a diverse range of bicycles, is poised for its next big challenge - global expansion. Despite their international presence, navigating the complexities of managing inventory across new markets requires specialised expertise. This is where Zenith Advisory, a leading Australian consulting firm, steps in to become a trusted partner in ACME's growth journey.

Shifting Gears: A Competitive Landscape

The global bicycle market is witnessing a surge in demand, fuelled by a growing focus on health and environmentally conscious transportation. However, this growth comes with increased competition. Local and international players are vying for market share, demanding efficient inventory management to meet fluctuating customer demands.

Navigating Headwinds: Challenges on the Road

ACME faces several hurdles in its global expansion. Each market has unique customer preferences for bike types (e.g., electric bikes in urban areas, mountain bikes in off-road terrains) and varying seasonal trends. Additionally, factors like import regulations, diverse infrastructure, and unpredictable global supply chains can significantly impact inventory management strategies.

The Power of Data-Driven Decisions

In this dynamic environment, leveraging on data, analytics, and Business Intelligence, is crucial for ACME to optimise its warehouse, supply chain & inventory management across its expanding global network. By partnering with Zenith Advisory, ACME gains access to a team of Australian specialists with a deep understanding of international logistics and retail best practices.

Zenith Advisory: The Australian Edge

You are a young analyst working for Zenith Advisory. Zenith Advisory boasts a proven track record of helping international companies like ACME Bikes Emporium navigate the complexities of global expansion. Their team of data analytics experts, based in Australia, brings a unique perspective:

• Global Market Knowledge: Zenith understands the nuances of international markets, including import regulations, infrastructure variations, and regional customer preferences for specific bike categories (e.g., high demand for kids' bikes in certain regions).
• Australian Expertise: Zenith leverages its Australian context to identify potential synergies between existing operations and the planned global expansion. This could involve optimising Australian warehouses as distribution hubs for specific regions or utilising established Australian supply chains.
• Data-Driven Recommendations: Through in-depth analysis of ACME Bikes Emporium' historical inventory data (including details on the almost 60 bike types across 7 categories), Zenith will identify trends, potential inefficiencies, and opportunities for optimisation. Their recommendations will be tailored to adjust safety stock levels, refine forecasting models, and ensure optimal inventory levels across international warehouses.

A Collaborative Approach: Meeting Expectations

Ultimately, ACME expects Zenith Advisory to deliver a comprehensive data analysis report. This report will outline current inventory management practices, identify potential challenges specific to each region/market, and provide data-driven recommendations to optimise inventory levels for each bike category across the global network. This collaboration will empower ACME Bikes Emporium to make informed decisions for a smooth transition into new markets, ensuring they stay ahead of the competition and achieve sustainable growth.

By partnering with Zenith Advisory and leveraging their Australian expertise in data analytics, ACME Bikes Emporium can navigate the complexities of global expansion, ensuring a successful journey towards becoming a leading global bicycle retailer.

However, while the Chief Operating Officer of ACME is undoubtedly impressed by Zenith Advisory's reputation, standard due diligence procedures dictate a closer look at their capabilities. To ensure they are making the best investment, ACME has provided Zenith with a sample dataset (i.e., historical supply chain/warehouse/inventory data) representative of their current inventory management practices. This sample serves as a test run, allowing Zenith to showcase their expertise in transforming raw data into meaningful and actionable insights (and/or foresights). By reviewing the results of Zenith's analysis, ACME will gain a clear understanding of the depth and value Zenith can bring to their global expansion strategy through data-driven analysis.

Your Tasks

At this stage, your senior manager has asked you to do a preliminary analysis of the data. You have been given some tasks to provide a report based on the Case description and the dataset. You are to produce a brief report containing analyses of:

1. The quality of the dataset: clearly and systematically addressing the quality issues in the dataset, whether the issue(s) is significant enough for the purpose of further analysis, and more importantly, how you would approach the shortcomings in the dataset. Note that even with our best data technician’s effort, there are still data that’s incomplete and/or potentially suss. You are to find a way to address the best method to address any potential data integrity issue(s) as part of your effort in this task;

2. Using your data analytics skills, provide 6 interesting insights based on descriptive analytics of the data. You get to determine which area you want to showcase. However, you need to be able to articulate as to why your chosen insights would be of interest and of value to the client. Remember, you are to showcase "insights" from your analysis of the data, not merely describing the numbers. Each of the insights need to be supported by appropriate data visualizations;

3. Based on your understanding of the data, provide 2 recommendations for further data enrichment to enhance and facilitate more advance analysis for the client. Remember, the recommendations for data enrichment needs to be sensible and viable.

Some Ideas for Your Considerations

There are many ways in which you can approach the data. At the end, it will depend on your ability to understand the data and your skills with Tableau.

To help you further, below are some possibilities you can consider. Remember, there are more.

• Inventory Levels by Item Category and Region which may encompasses:
  • Analysis on the on-hand inventory levels for different item categories across all warehouses.
  • Comparative analysis on any significant variations in trends and/or patterns of inventory levels across different regions (USA, India, Turkey, UK).
  • Identify potential seasonality trends in inventory levels for specific item categories.
• Demand Analysis which may encompasses:
  • Analysis of outflow data to identify trends in demand for different item categories across all warehouses.
  • Trend analysis on seasonal fluctuations in demand for various products.
  • Comparative analysis on actual demand patterns with existing forecasts to identify trends and/or any discrepancies.
• Warehouse Performance which may encompasses:
  • Analysis of inventory management metrics like stockout rates and average inventory turnover for each warehouse.
  • Utilise maps to visualise warehouse locations and overlay them with performance metrics to identify potential regional trends.
  • Analyse if specific warehouses are experiencing higher stockout rates or carrying costs compared to others.

This INF30004 – Management has been solved by our PHD Experts at My Uni Paper.