Company-Analysis-using-Power-BI

Power Bi | Visualization | Dax | Measures

Overview

Welcome to the Company Analytics Dashboard repository! This Power BI dashboard offers a comprehensive view of product dynamics, enabling data-driven business decisions. Explore various facets of our products, from sales performance to customer satisfaction metrics.

Title :- Company Analytics Dashboard

Created by :- Vishnupriya Kathirvel

Tool used:-

• Microsoft Excel
• Microsoft Power Query
• Microsoft Power BI
• Dax Query
• Data modeling

Cleaning and Analyzing using Power Query

• Open CSV file and connect to your Company Analytics Data
• Use Power Query to clean and transform the data
• Apply all necessary cleaning steps, such as removing duplicates, renaming columns, changing data types and date format
• Create a parameter to select the desired data based on a specific condition

Load and Apply the cleaned data into Power BI

• Exploring and Manipulate Some Data Using DAX Query with DAX Query, we can effectively manipulate and analyze the data to provide insights for visulization and identify areas for improvement for Company Analytics.

• Create Measures and columns Using DAX functions such as count, sum, calculate, related, divide, multiply function for exploring some clean data for improve dashboard KPI in PowerBI.

Key Features

Slicers: based on year and continent Filter data by date and continent and adjustement price.

KPI: to check monthly revenue, orders, returns target to previous month.

Product Anlysis: Analyze the product monthly orders, revenue, profit and adjusted price .

Weekly trend: Analyze the product weekly return, profit.

Cards: Top ptoduct in company based on profit and orders.

Multi-Card Analysis: Dive deeper into product profit and adjustment profit metrics with multi-card visuals.

Bar Charts: Visualize product sub-category based on total profit,orders and revenue.

Gauge: Experience Distribution: Understand the distribution of employee experience levels.

Dashboard

Click there to View the Company Analysis Dashboard on Power BI 👇👇👇

https://app.powerbi.com/reportEmbed?reportId=212c73cb-74d9-475c-873e-6830e27f2a1d&autoAuth=true&ctid=e37c7dd6-dcf4-4f50-9aa4-85bd6bb08877