Subject : Management information system.

Problem Statement:

From your place of work, identify a specific working scenario you are familiar with, gather relevant data. Using this data, develop an interactive dashboard that is suitable for use by the Manager. Clearly describe the scenario, identify the data sources, describe the data, prepare the data model, select the KPIs, define the type of charts/visualizations/plot/graph/reports, and mention the analysis you plan to implement. The dashboard should showcase 4-6 KPIs along with 6-8 charts on suitable measures chosen from your data for analysis relevant to the chosen scenario. Prepare a formatted Dashboard in Microsoft PowerBi / Tableau (If you wish, you can use any other similar Visualization Software excepting MS Excel). Take screen grabs of your data, the entire dashboard pages together with the corresponding visualizations to demonstrate the implementation. Use them in your report along with the detailed description of the approach, the scenario, the data model used and the details of visualizations.

Deliverables in the submission:

a. Description of the use case / scenario and the overall goal of the dashboard.

b. Snapshot of the data. This would be around 15-20 records of data, together with a brief explanation of the features (columns or attributes) considered. If you have your data obtained from multiple tables, clearly show the complete data model.

c. Brief description of each visualizations together with the data sources connected to the viz.

d. Description of each KPI defined in your dashboard

e. Screen grabs of Dashboard showing all the components of the dashboard. Screen grabs can also showcase any interactive behaviour of the reports.

f. Comprehensive analysis together with insights observed.

g. Your observed deductions, lessons learnt and recommendations.