Global market store Data Using Power BI
Global Super Store, a retail giant, has relied on Excel for their data analysis needs.
However, with advancements in technology, they decided to migrate to Power BI for
enhanced business intelligence capabilities. They have approached you to build a
comprehensive dashboard with their data up to 2019. Below are the specified
requirements and the corresponding business problems that this dashboard aims to
solve.
This dashboard should aim to empower Global Super Store with actionable insights,
enabling them to make data-driven decisions and improve their overall business
performance. Each visual should be crafted to address specific business questions
and challenges, providing a clear and informative representation of their data.
1- Global Super Store wants to quickly assess its overall performance through key
metrics. The management needs a concise overview of:
● What is our total revenue generated so far?
● How profitable have we been over the years?
● How many orders have we successfully processed?
● How many consumers have we served?
2- The sales team is looking to identify trends over the years to inform their
strategy. They need to see how their annual sales perform Over the year and on
the same graph they also want to know the overall trend and sales of their store
over the years.
3- Marketing and finance teams need to understand the seasonality and
profitability trends to optimise their campaigns and budgets. Sales and finance
teams are working together for this cause, they need a graph that can help them
understand.
● How do our sales and profits fluctuate month by month?
● Are there particular months where profits significantly
increase or decrease, indicating potential seasonal trends?
4- The regional managers are keen to understand the performance of different
markets to allocate resources effectively.
● They need to know Which markets are generating the most
sales and profits.
● Are there specific markets where we need to focus our efforts
to boost performance?
5- To Boost their business, Global Superstore thought of planning their business
quarterly. For that they need to know their overall sales for each quarter.
6- After these visuals are built, management would like to incorporate a feature
allowing them to select specific segments and categories. This functionality should
dynamically adjust all the graph values based on the selected category and
segment, providing a tailored view of their data