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:
-
Identify anomalies in the data. These anomalies might be unexpected changes in a metric or a particular market.
-
Collect data that's related to these anomalies.
-
Use statistical techniques to discover relationships and trends that explain these anomalies.
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.
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.
In our Atliq Hardware's case the following teams will be involved
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.
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,