Analysis Case Study Final

Analysis Case Study Final 

Introduction
The main purpose of this analysis is to provide IntelliGents Technologies with practical
insights, which will eventually help this large tech company to spread its arms across nations,
therefore utilizing different markets across various sectors.
I was given sales and profit data of Q4 2021 and the year 2026. The data was thoroughly
cleaned and analyzed for the purpose of finding trends and strategic significance across various
nations. This research and analysis will allow the company’s authorities to make well informed
business decisions, which will eventually enhance company’s growth and promote company’s
positioning across various nations.
In the analysis, I will mainly focus on Sri lanka’s market and will provide actionable
insights that will eventually help the stakeholders to form sound business strategy.
However, our home country, Australia serves as a substandard or benchmark for this study.
So, by comparing and contrasting the performance between Sri lanka and Australia, I will try to
discover trends, patterns, strengths, or weaknesses of our business.
In my analysis, I try to address critical questions such as:
Which month and year had the most profit? By analyzing the monthly and yearly profit
trends, we can identify peak periods of profitability and eventually, understand the seasonal
impact on business performance.
In which country is the company seeing the most success? By comparing different metrics
such as sales, profits, discounts, manufacturing price, selling price between Australia and Sri
Lanka, we can determine which country is performing better overall.
Which product is the most popular for each sector and each country? By evaluating the
profit and sales data for each product within different sectors and across both nations, we can
identify the top-performing products.
Which product and sector should the company continue to invest in? Analyzing the growth
potential of different products and sectors helps in making informed investment decisions.
What are the top-performing products and sectors across different markets? Identifying
products and sectors that are consistently performing well across markets assist in strategizing
for future growth and expansion.
What are the month wise sales and profits across different products and sectors?
Understanding the month wise sales and profit distribution helps in planning marketing and
sales strategies effectively.
Which product is outrightly dominating the charts? By comparing the sales, profit margins,
and market share of various products, we can identify the leading product.
Which sector is outrightly dominating the charts? Evaluating the overall performance of
different sectors allows us to spot the most successful sector.
Data and Methodology
Data Source
The analysis of IntelliGents Technologies, presented in this study is based on a comprehensive
dataset that includes various metrics for products and sectors across Australia and Sri Lanka.
The data encompasses information on sales, profits, discounts, manufacturing prices, and units
sold, among other features.
Methodology
To analyze and visualize the data, we employ Power BI, a powerful business analytics service
that provides interactive business intelligence and visualization capabilities.
Data Import: The dataset (IntelliGentsTech 23S2B.csv) was imported into Power BI for initial
exploration and visualization.
Data Cleaning:
Handling Missing Values: Missing data points were identified and addressed. In cases where
the data was missing, appropriate measures such as imputation were employed to ensure the
integrity of the data.
Data Transformation:
Calculating Derived Metrics: Additional metrics such as profit margins, average prices, and
discount rates were calculated to provide deeper insights into the data.
Aggregating Data:So the data was aggregated by product and sector to enable a higher-level
analysis and eventually have the comparison between Australia and Sri Lanka.
Visualization: Various types of visualizations, including bar charts, line graphs, and scatter
plots, were created in Power BI to highlight key trends and insight. These visualizations were
instrumental in identifying metrics, comparing patterns, and drawing relevant conclusions.
Key Insights and Analysis
Using Power BI, several key insights were identified, such as::
● Profit and sales distribution across products and sectors.
● The impact of discounts on sales performance.
● Seasonal trends in profitability.
● Sector-specific cost and pricing analysis.

Analysis Case Study Final Exam,Analysis Case Study Final Test,Analysis Case Study Final Flashcard,Analysis Case Study Final quiz,Analysis Case Study Final Practice,Analysis Case Study Final Practice test,Analysis Case Study Final Practice flashcard,Analysis Case Study Final Practice exam,Analysis Case Study Final Study guide,Analysis Case Study Final Practice questions,Analysis Case Study Final Questions,Analysis Case Study Final Practice questions and answers,Analysis Case Study Final Questions and answers,Analysis Case Study Final pdf,Analysis Case Study Final quizlet,Analysis Case Study Final reddit,Analysis Case Study Final Answer sheet,Analysis Case Study Final Answer key,Analysis Case Study Final Pdf free,Analysis Case Study Final Exam help,Analysis Case Study Final Cheat sheet,Analysis Case Study Final quiz bank,Analysis Case Study Final Questions bank,Analysis Case Study Final Practice Guide,Analysis Case Study Final Guide,Analysis Case Study Final Testbank,Analysis Case Study Final Practice Answers,Analysis Case Study Final Answers,Analysis Case Study Final Exam prep,Analysis Case Study Final Prep,Analysis Case Study Final Pdf download,Analysis Case Study Final Flashcards,Analysis Case Study Final Real questions,Analysis Case Study Final Actual questions,Analysis Case Study Final Real Questions and answers,Analysis Case Study Final Actual Questions and answers,Analysis Case Study Final Exam review,Analysis Case Study Final Review,Analysis Case Study Final Exam questions,Analysis Case Study Final Exam questions and answers,Analysis Case Study Final Practice test pdf,Analysis Case Study Final Practice test quizlet,Analysis Case Study Final Practice test Reddit,Analysis Case Study Final Practice test quizlet multiple choice,Analysis Case Study Final Exam study guide,Analysis Case Study Final Practice test free,Analysis Case Study Final Test questions,Analysis Case Study Final Exam study guide,Analysis Case Study Final Practice exam free,Analysis Case Study Final Practice tests free,Analysis Case Study Final Exam practice test,Analysis Case Study Final Exam test questions,Analysis Case Study Final Exam questions and answers,Analysis Case Study Final Exam practice test