Business_Insights_360 Power BI Project

Welcome to my Business Insights 360 Power BI project repository!

Overview

Business Insights 360 is a comprehensive Power BI dashboard designed to empower AtliQ Hardware with actionable insights across Finance, Sales, Marketing, Supply Chain, and Executive View. This repository houses the project files and documentation. This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.

Features

• Finance View: Detailed financial analysis, including revenue, expenses, and profit margins.
• Sales View: Insights into product and customer performance.
• Marketing View: Analytics to enhance marketing strategy.
• Supply Chain View: Optimization metrics for efficient supply chain management.
• Executive View: Metrics critical for top-level decision-makers.

Live Dashboard

Explore the live dashboard here

Key Achievements

• Customization: Tailored for AtliQ Hardware's specific needs.
• Data Integration: Seamless integration from Excel, CSV, and MySQL sources.
• Visualizations: Engaging charts and visuals for better data understanding.
• Performance Optimization: Achieved a 5% increase in report efficiency.

Getting Started

1. Clone this repository.
2. Open the project in Power BI Desktop.
3. Explore the data model and visualizations.

Data Sources

The dashboard seamlessly collects and utilizes data from two primary sources:

• MySQL Database: Facts and Dimensions for all departments are retrieved from a MySQL database.
• Excel/CSV Files: Targets, Market Share data, and related information are sourced from Excel/CSV files.

Prerequisites

• Power BI Desktop
• DAX Studio(TO REDUCE FILE SIZE)
• SQL
• DAX language
• Project Charter file

Business Related Terms

• Gross Margin, Gross Margin %
• Gross Sales, Gross Sales %
• Pre-invoice deductions and Post invoice deductions
• Net sales, Net Invoice Sales
• Net Profit and Net Profit %
• COGS(cost of goods sold)
• YTG (year to go)
• YTD ( year to date)
• Direct, retailer, consumer, and distributors

Conclusion

This dashboard answers many business questions based on different scenarios. This report can be used to make data-driven decisions to make AtliQ more profitable.

How to Contribute

Contributions are welcome! Feel free to open issues or submit pull requests.