Ignatius306/Sales-insights-using-powerBI

Business sales insight case study using PowerBI, which is connected to a MySQL data source. Once ETL is performed, PowerBI is used to create visualizations to empower data-driven decision-making

Sales-insights-using-powerBI

Gain insights of atliQ hardware company

Table of Contents

1. Problem Statement
2. AIMS report
3. Data Set
4. Data Processing
5. Sales Insights using PowerBI

Problem Statement

Sales Director of AtliQ hardware finds difficulty in analysing the monthly report of production and sales. The objective is to create effective dashboard that tell the details of sales like revenue, profit, sales by branch at a single click and to increase the profit in the next quarter.

AIMS report

Before venturing into the project, the AIMS grid was used for planning and laying the foundation for successful implementation

Data-Set

Sales data set provided by the company contains sales, transaction,markets in the form sql text file.

Fig:Database Schema

Data Processing Using SQL

The data containing Transaction in USD are change into INR.

Fig:SQL

Sales Insights using PowerBI

Fig:PowerBI