DIAGONISTIC DATA ANALYSIS

Diagnostic analytics help answer questions about why events happened. Diagnostic analytics techniques supplement basic descriptive analytics, and they use the findings from descriptive analytics to discover the cause of these events. Then, performance indicators are further investigated to discover why these events improved or became worse. Generally, this process occurs in three steps:

1. Identify anomalies in the data. These anomalies might be unexpected changes in a metric or a particular market.

2. Collect data that's related to these anomalies.

3. Use statistical techniques to discover relationships and trends that explain these anomalies.

Project Summery: Atliq Hardware Sales Data Analysis.

Database name: db_dump.sql

Overview: CodeBasics certified exploary data analysis project as i have been assigned as a data analyst in Atliq Hardware and been assigned a project to make a intractive PowerBI dashboard that will helps understand the company growth situation.

My task starts with a meeting with various stack holders, IT team and other higher authorities of the company. we decided to follow AIMS GRID method to managing this project.

The AMIS GRID Component I Used In The Project

PURPOSE

1. What do we want to achieve?

2. What to do in order to achieve it?

In our case, the purpose would be to make a Power BI Dashboard that shows sales insights of different regions & markets of india and to understand the trend in sales based on previous reports and study why there was a decrease and finally increase sales in the down performing markets.

STAKEHOLDERS

Which teams or Who from the company will be involved?

In our Atliq Hardware's case the following teams will be involved

* General Sales Director

* Regional Sales Managers

* Product Managers

* Data and Analytics Team (This is where I am now!)

* IT or Software Engineers Team

END REASULT

1. After the project is over what do we want to achieve?

I want to increase sales insight. Instead a solid platform where the result can be projected.

In our Atliq Hardware case, this will be a Power BI Dashboard which is automated and provides sales insights which are quick and latest thereby data driven decision making can be implemented. This will help the sales director and regional managers to look into real time information on the sales numbers.

SUCCESS CRITERIA

Defining how the project was successful after the completion of the project for which company may have spent few million dollars. We need to specify the exact success criteria

In our Atliq Hardware case,

1. We want the sales team to make better decisions and prove say 12% cost savings.

2. Bring in powerful sales insights dashboards with latest up to date information.

3. Avoid manual data gathering through excel which can save 20% of their business time thereby they can invest that time in other value added tasks.