Child-Abuse-Data-Analysis

Problem Statement:

In the critical domain of child welfare, gaining insights into child abuse cases is essential. The provided dataset, named "Data," captures information about child abuse cases across different states, including details on childcare factors. The challenge is to analyze this dataset comprehensively, extract meaningful insights, and create a model that enhances decision-making in the context of child protection.

Objective:

The primary objective is to gain insights into child abuse cases across different states, focusing on various factors associated with childcare.

Dax Calculation:

Create measure table mentioned in the screenshot attached

Data Visualizations:

1. Create column chart to show top 5 states with child care providers by state.
2. Create doughnut chart to show top states with highest child legal guidance.
3. Create funnel chart to show top 5 perpetrators states.
4. Create column chart to show top 6 state with highest parent by state.
5. Create KPIs as cards for total parents, total states, top perpetrators, total unmarried parents, total foster parents.
6. Total child day care providers, total multiple relationship