1
DECLARATION
I, hereby declare that the project work entitled FINANCIALS submitted to the
Department of Commerce, is a record of independent and bonafide project work carried
out by HARI BASKER A & 312300949 under the supervision of Dr. RAJSHREE RAJESH
Assistant Professor, Department of Commerce, Dharmamurthi Rao Bahadur Calavala
Cunnan Chetty's Hindu College.
HARI BASKER A
2
CERTIFICATE
This is to certify that the project report entitled FINANCIALS is a Bonafide record of project
done by HARI BASKER A & 312300949 Under the supervision of Dr. RAJSHREE RAJESH
Assistant Professor, Department of Commerce, Dharmamurthi Rao Bahadur Calavala
Cunnan Chetty's Hindu College, during the Academic Year 2024-2025.
Dr. RAJSHREE RAJESH Dr. K. BHAVANI SELVI Dr. G. KALVIKKARASI
Project Supervisor Assistant Professor & Head Principal
3
Contents
Introduction................................................................................................... 5
Objective .......................................................................................................6
Statement of the Problem...............................................................................7
Tools Used...................................................................................................... 9
Data analysis and interpretation....................................................................12
Charts Included............................................................................................. 15
Output.......................................................................................................... 17
Conclusion.................................................................................................... 18
4
Power BI project:
Introduction
Introduction In today’s data-driven business environment, companies generate vast amounts of data daily.
However, raw data alone is not enough to make strategic decisions—it needs to be processed, analyzed,
and visualized effectively. This is where Power BI, a powerful business intelligence tool developed by
Microsoft, comes into play. Power BI allows organizations to convert raw data into insightful visualizations
and reports, helping businesses make data-driven decisions that enhance efficiency and profitability.
Business Performance Analysis Dashboard:
This Power BI dashboard presents a comprehensive analysis of key business metrics across different
countries and products. The visualizations provide insights into sales, manufacturing costs, profits, and unit
sales, enabling data-driven decision-making.
Key highlights of the dashboard include:
Manufacturing Cost Distribution: A pie chart showcasing the manufacturing price breakdown by country,
identifying cost variations across regions.
Sales Performance: A donut chart illustrating total sales distribution across multiple countries.
Key Metrics: A summary displaying the total manufacturing price (8,564) and the total number of units sold
(156.65K).
Profit Analysis:
A line chart depicting the sum of profit by country, indicating which regions contribute the most to
profitability.
A bar chart analyzing profit by product, highlighting top-performing and underperforming products.
This dashboard, created by A. Hari Basker, serves as a valuable tool for business leaders, helping them
optimize pricing, sales strategies, and resource allocation based on data-driven insights.
5
Objectives
1. Analyze Manufacturing Costs by Country
Identify cost variations across different countries to optimize production expenses.
Understand which regions have the highest and lowest manufacturing costs.
2. Evaluate Sales Performance Across Countries
Compare sales distribution across different geographical locations. Identify countries
contributing the most to total sales and explore growth opportunities in underperforming
regions.
3. Monitor Key Business Metrics
Track total manufacturing price and total units sold to assess overall business performance.
Use these metrics to set benchmarks for future growth and efficiency improvements.
4. Profitability Analysis
Assess the sum of profits by country to determine the most profitable markets.
Identify trends and factors influencing profitability in each region.
5. Product Profitability Assessment
Analyze profits by product category to identify top-performing and low-performing
products.
Use insights to adjust pricing strategies, marketing efforts, and product development.
6. Support Data-Driven Decision-Making
Provide actionable insights for stakeholders to make informed business decisions.
Leverage data visualization to simplify complex business trends and drive strategic planning.
This dashboard serves as a valuable tool for businesses to optimize their operations.
6
Statement of the Problem
In a rapidly evolving business landscape, organizations must continuously optimize their
manufacturing costs, sales strategies, and profitability to maintain a competitive edge.
However, many businesses struggle with efficiently managing these critical financial metrics,
leading to increased costs, revenue loss, and misallocated resources. The Power BI
dashboard presented highlights several underlying challenges that hinder effective decision-
making and strategic planning.
This problem statement aims to identify key inefficiencies in manufacturing pricing, sales
performance, and profitability across different regions and product categories,
demonstrating the urgent need for a data-driven approach to address these concerns.
Key Business Challenges Identified in the Dashboard:
1. High Variability in Manufacturing Costs Across Countries
One of the primary concerns highlighted in the dashboard is the significant variation in
manufacturing prices across different countries. This poses several challenges:
Cost Inefficiencies: Without a comprehensive understanding of where production costs are
highest and lowest, businesses risk allocating resources inefficiently, leading to increased
operational expenses.
Profit Margin Impact: Higher manufacturing costs in certain regions directly reduce profit
margins, making it difficult for the company to maintain cost-effectiveness in pricing.
Decision-Making Constraints: In the absence of clear cost analysis, businesses may struggle
to make informed decisions regarding outsourcing, supplier selection, and production
expansion.
By addressing this challenge, businesses can optimize their production expenses and
improve overall cost efficiency.
2. Unequal Sales Distribution Across Countries
The dashboard reveals that sales performance is not uniform across different regions, with
certain countries contributing significantly more to total sales than others.
7
This imbalance creates several issues:
Revenue Concentration Risk: Over-reliance on a few high-performing regions exposes the
business to potential risks if market conditions in those regions change.
Missed Opportunities: Low sales in certain countries may indicate a lack of market
penetration or ineffective marketing and sales strategies.
Market Expansion Difficulties: Without a clear understanding of regional sales trends,
businesses may struggle to identify new opportunities for expansion and revenue growth.
A deeper analysis of sales trends will enable organizations to reallocate resources, improve
market presence, and diversify revenue streams.
3. Profitability Disparities by Country and Product
Profitability is a key metric for evaluating business success. However, the dashboard shows
significant disparities in profit margins across both countries and product categories, leading
to the following concerns:
Underperforming Products: Some product categories contribute significantly more to profits
than others. Without identifying and addressing low-performing products, businesses may
continue investing in areas that yield lower returns.
Regional Profitability Gaps: Some countries generate substantially higher profits, while
others lag. This could be due to factors such as higher sales volume, lower manufacturing
costs, or better market demand.
Strategic Pricing Challenges: A lack of insight into product profitability may prevent
businesses from setting optimal price points, which could either reduce competitiveness (if
prices are too high) or diminish profit margins (if prices are too low).
By refining their pricing strategy and focusing on high-profit products and regions,
businesses can maximize revenue while reducing inefficiencies.
8
4. Lack of Clear Visibility into Key Performance Indicators (KPIs)
The dashboard presents crucial KPIs, including total manufacturing price and total units
sold, but without deeper analysis, these metrics alone may not provide actionable insights.
Some of the key issues include:
Disconnected Data Insights: Tracking KPIs without understanding the underlying factors
driving them makes it difficult to pinpoint areas for improvement.
Ineffective Target Setting: Businesses need detailed trends and benchmarks to set realistic
and data-backed sales and profitability goals.
Limited Forecasting Ability: Without historical comparisons and predictive insights,
companies may struggle to anticipate market shifts and adapt accordingly.
A comprehensive analysis of these KPIs can help businesses refine their strategic planning
and enhance decision-making.
Tools Used
Tools and Features Used in the Power BI Dashboard
The Power BI dashboard in the image utilizes a variety of data visualization techniques and
tools to represent manufacturing price, sales, and profitability metrics across different
countries and products. Below is a detailed breakdown of the tools and features used in this
dashboard:
1. Data Visualization Tools in Power BI
Power BI provides multiple visualization options to analyze and present data effectively. This
dashboard incorporates:
a) Pie Charts
Usage in the Dashboard:
The "Sum of Manufacturing Price by Country" and "Sum of Sales by Country" are
represented using pie charts.
Purpose:
These charts help in understanding the distribution of manufacturing costs.
9
Power BI Feature Used:
Pie Chart Visualization (available under Power BI’s visualization pane).
Data Labels & Legend Features (used to show percentage values and country names).
b) Line Chart
Usage in the Dashboard:
The "Sum of Profit by Country" is displayed using a line chart.
Purpose:
This visualization shows how profit varies across different countries.
It helps identify trends, such as which countries contribute the most to profitability and
which lag behind.
Power BI Feature Used:
Line Chart Visualization (used to track profit trends over different countries).
Axis Labels & Data Points (used to display country-wise profit values).
c) Bar Chart
Usage in the Dashboard:
The "Sum of Profit by Product" is visualized using a vertical bar chart.
Purpose:
This chart highlights the profitability of different product categories, allowing businesses to
focus on the most profitable ones.
Power BI Feature Used:
Bar Chart Visualization (used for comparative analysis of product profits).
Data Labels (used to show exact profit values for each product).
2. Key Metrics and KPIs Displayed
10
a) Card Visuals
Usage in the Dashboard:
The values "8564" (Sum of Manufacturing Price) and "156.65K" (Sum of Units Sold) are
displayed using card visuals.
Purpose:
These provide a quick glance at critical business metrics without requiring further analysis.
Power BI Feature Used:
Card Visualization (used to display individual numerical KPIs).
3. Data Modeling and Filtering Tools
To make the dashboard dynamic and interactive, Power BI likely uses: a)
Slicers and Filters
Usage in Power BI:
Users can filter data based on country, product type, or time period.
Purpose:
These tools allow users to drill down into specific data points and analyze trends more
effectively.
Power BI Feature Used:
Slicer Visual (allows selection of specific filters).
Filter Pane (used to apply background filters).
4. Data Transformation and Processing Tools
Before visualization, data must be cleaned and structured. The following tools help in data
preparation:
a) Power Query (Data Transformation Tool)
Cleans raw data , and formats values before loading into visualizations.
11
Purpose:
Ensures that the data used in reports is accurate and structured properly.
Power BI Feature Used:
Power Query Editor (for data transformation, merging, and cleaning).
b) DAX (Data Analysis Expressions)
Usage in Power BI:
Custom calculations for profitability, manufacturing costs, and percentage shares.
Purpose:
Used to create calculated columns and measures such as total manufacturing cost, profit
margins, and sales percentages.
Power BI Feature Used:
DAX Formulas (e.g., SUM(), AVERAGE(),DIVIDE() ).
Data Analysis and Interpretation
This Power BI dashboard provides insights into manufacturing price, sales, and profit
analysis across different countries and products. The visualizations help identify key trends,
regional variations, and product performance. Below is a detailed analysis and
interpretation of each section.
1. Manufacturing Price Analysis
Chart: "Sum of Manufacturing Price by Country" (Pie Chart)
The pie chart illustrates the distribution of manufacturing costs across different countries.
Countries included: France, Germany, United States, Canada, and Mexico.
Interpretation:
The largest portion of manufacturing costs comes from France (approximately 30%).
Germany and the United States also have significant shares.
12
Mexico has the lowest manufacturing cost, which could indicate lower production expenses
or lower production volume in that region.
2. Sales Analysis
Chart: "Sum of Sales by Country" (Donut Chart)
The donut chart displays the sales contribution of each country.
Interpretation:
France has the highest sales volume, contributing the most to total revenue.
The United States and Germany follow closely, indicating strong market demand.
Mexico has the lowest sales percentage, suggesting lower demand or limited market
penetration in that region.
KPI: "Sum of Units Sold = 156.65K"
The total number of units sold across all regions is 156.65K.
Interpretation:
If compared with the manufacturing price, we can assess profitability per unit in each
country.
This metric provides insights into production efficiency and sales effectiveness.
3. Profitability Analysis
Chart: "Sum of Profit by Country" (Line Chart)
The line chart visualizes how profitability varies by country.
Interpretation:
France has the highest profit among all regions, suggesting a high sales volume and better
pricing strategies.
Germany and Mexico show a declining trend, indicating lower profit margins or higher costs.
The United States and Canada have lower profits, which could be due to higher production
costs, taxation, or lower sales prices.
Chart: "Sum of Profit by Product" (Bar Chart)
The bar chart represents the profitability of different products.
13
Interpretation:
Phones and Cameras are the most profitable products, suggesting high demand and
premium pricing.
VIT (possibly a niche or emerging product) shows moderate profit levels.
Accessories and Watches generate the lowest profits, which might indicate low sales volume
or aggressive pricing strategies.
Companies may need to reassess pricing, marketing, and production for lower-profit
products.
4. Overall Business Performance and Key Takeaways
KPI: "Sum of Manufacturing Price = 8564"
The total manufacturing cost for all products across all regions is 8564 (currency not
specified).
Interpretation:
When compared with total sales and profit, this metric helps assess cost efficiency and
profitability margins.
If sales revenue is significantly higher, it indicates healthy profit margins. If not, cost
reductions or pricing strategies may need adjustment.
General Business Insights:
1. France leads in both sales and profits, making it the most valuable market.
2. Mexico has lower manufacturing costs but also lower sales, indicating potential for cost-
efficient production if demand increases.
3. Phones and Cameras are the most profitable products, while Accessories and Watches
need strategic improvement.
4. Germany shows declining profits, requiring a re-evaluation of pricing, costs, or
competition in that region.
14
Recommendations for Business Improvement
1. Expand Sales in High-Profit Regions
France is already performing well; focus on increasing market share in Germany and the
United States to maximize revenue.
2. Cost Optimization in High-Cost Regions
The United States and Germany have high manufacturing costs, which should be optimized
by improving production efficiency or renegotiating supplier contracts.
3. Increase Focus on High-Profit Products
Phones and Cameras are top earners. Investment in marketing, innovation, and distribution
for these products can maximize profits.
4. Strategic Pricing For Low-Profit Products
Accessories and Watches contribute little to profits.
Either increase pricing, reduce costs, or phase out unprofitable products.
5. Boost Sales in Mexico
Despite low manufacturing costs, Mexico's sales remain low.
Increase marketing efforts and assess local demand to improve sales performance.
Charts Included
1. Pie Chart:
15
2. Donut Chart:
3. Line Chart:
4. Bar Chart:
16
Output
Name: K.Sudersan
College: DRBCCC Hindu College
NM ID: 0BC2ABC4FEECBFBB4A147AAE9BAFCAAA
17
Conclusion
The Power BI dashboard provides a comprehensive analysis of sales, manufacturing prices,
and profitability across different countries and products. The data reveals that while France
and Germany contribute significantly to manufacturing prices and sales, the profitability
trend declines across regions. High sales figures indicate strong market demand, but lower
profits in certain countries suggest the need for cost control and pricing optimization.
Among products, phones and cameras generate the highest profits, while items like wine
and ampules underperform. To enhance overall profitability, businesses should focus on
optimizing sales strategies in underperforming regions, improving cost efficiency in
manufacturing, and prioritizing high-margin products.
18
