Data Analysis: Exploring Regional Sales and Profitability Trends

The provided analysis examines sales and profitability data across different regions and product categories, based on graphical tables and filters. The analysis highlights country-level comparisons, revealing that France had the largest negative profit while Spain had the smallest. It further breaks down the data to state-level performance, identifying states with maximum and minimum negative profits. The analysis categorizes products into furniture, office supplies, and technology, noting that overall sales were highest in 2016 and that technology products had the highest demand. The central region showed the highest sales, with consistent growth in the technology sector. Comparisons between the three regions reveal that technology products consistently drove the most sales. The analysis also examines sales by product sub-category, noting consistent year-over-year growth from 2013 to 2016, with significant growth in bookcases, copiers, phones, and storage in 2016. The assignment brief describes the use of interactive dashboards and filters to analyze sales and profit data by region, sub-category, and year, and focuses on how these tools can identify profitable areas and eliminate wasteful ventures. The analysis focuses on regional comparisons and the impact of different product categories on overall profitability.

Following explanation has been provided as per the given graphical table
and information.
According to the given country wise data, if country level comparison
were made, central region country, France, has delivered maximum
negative profit among all 9 given countries and smallest negative profit
has shown by, north region country, Spain, among all 9 countries.
As per the given data, all 9 countries do not have same number of states,
like for Netherlands, it was 11 states and for France and Germany it was
just one state each.
Upon analyzing given data individually for all countries, it was found that,
for countries like Spain, Germany, Italy and Denmark negative profit was
less than or equal to 1K, whereas, shown negative profit for Portugal ,
Ireland and Sweden, was between 1K to 3K and for Netherlands and
France it was between 3K to 4K.
If it is taken individually for all state of given 9 countries, maximum
negative profit was shown by Stockholm (Sweden) and then North Brabant
(Netherland). And, for States like Central Juteland (Denmark), Setubal
(Portugal), Cantabria and Extremadura (Spain) it has shown minimum
Negative profit.
Product were primarily categorized under three heading, these were,
Furniture, Office supplies and Technology. If sales of all the products were
taken together maximum sales were recorded in 2016 compared to 2013,
2014 and 2015. Whereas, technology sector has shown highest demand
but in product related to office supplies was lowest in demand.
Central region has maximum sales in products like phones, storage,
bookcases and copiers. Northern region has shown maximum sales in
copiers, bookcases, phones and storage and in southern region it was
observed that appliances, bookcases and copiers has shown maximum
sales sub category wise product.
Overall it is observed that, combined sales of all the three regions have
shown maximum (in numbers) in bookcases, copiers, phones and storage.
As per the given data of three regions, that is, central, north and south, it
was found that, maximum sales in all the products was in Central region
and Technology sector has shown consistent growth to previous year.
North and south regions have shown more or less same trend in sales
growth. If comparison were made, it was found that in all the three
regions maximum sales was recorded in technology sector. After
technology second highest sales was witnessed in furniture product.
Sales of Envelopes, fasteners, labels, paper and suppliers were always
remaining less in all the given three regions every year.

On analyzing the given data in sales by product sub category following
points was being observed.
Sales growth year on year has increased consistently almost in all product
sub categories wise from 2013 to 2016 with a very few exceptions. In the
year 2016 sales growth was at maximum in products (sub category) like
Bookcases, copiers, phones and storage, which was (in numbers)
approximately 20K growth recoded.