The aim of this project is to examine and extract meaningful insights from financial data to support decision-making, business strategies, and investment analysis. I used Excel for this analysis.
Below are the questions answered by this analysis:
1. Filtered and removed “Montana” from the products column.
2. Which month and year had the highest profit?.
3. Which country had the highest gross sales?.
4. Which product had the highest sales revenue?.
5. Which segment generated the highest profit?.
6. Which country had the lowest discounts given?.
7. Which product category had the most units sold?.
8. In which month did Germany have the highest sales?.
9. Which segment had the least amounts of units sold?.
10. Which product was sold the most in the Government segment?.
11. Which country had the highest profit in 2014?.
12. Which segment had the highest Gross sales?.
13. Which product showed the highest gross sales in April 2014?.
14. Which month has the highest units sold?.
15. Which country had the highest COGS (Cost of Goods Sold)?.
16. Which segment should the company continue to invest in, based on the highest profit margin?.
17. Which month had the lowest profit in 2014?.
18. Which product had the lowest discounts applied?.
