Power BI Project on Indian Kids Screen Time 

Indian Kids Screen Time Dataset

Problem Statement : 

To analyze the impact of screen time on children in India, focusing on their primary devices, educational-to-recreational balance, and associated health issues, and to derive insights for parents, educators, and policymakers using Power BI visualization and analytics

Step-by-Step Workflow in Power BI

1.    Data Upload

1. Open Power BI Desktop → Home → Get Data → CSV/Excel → load your dataset.

2. Verify column data types:

• Age → Whole Number

• Gender, Primary_Device, Health_Impacts, Urban_or_Rural → Text

• Avg_Daily_Screen_Time_hr, Educational_to_Recreational_Ratio → Decimal

• Exceeded_Recommended_Limit → Boolean

2.  Data Transformation (Power Query)

1. Go to Transform Data → Power Query.

2. Clean column names (rename for readability):

   • Avg_Daily_Screen_Time_hr → Screen Time (hrs)

   • Educational_to_Recreational_Ratio → Edu/Rec Ratio

3. Handle Health_Impacts:

   • Split column by delimiter (comma ,) → results in multiple impacts (Poor Sleep, Eye Strain, Anxiety).

   • Optionally create a Health Count column → number of issues per child.

4. Derived columns:

   • Age Group (Conditional Column):

     • <=12 → Kids

     • 13-15 → Early Teens

     • 16-18 → Late Teens

   • Screen Category:

     • <2 hrs → Low

     • 2–4 hrs → Moderate

     • >4 hrs → High

Apply and Close.

3. New Measures (DAX in Power BI)

1. Average Screen Time:

DAX:

Avg Screen Time = AVERAGE('ScreenData'[Screen Time (hrs)])

2. % Exceeding Limit:

DAX: 

% Exceeding Limit = 

DIVIDE(

  CALCULATE(COUNTROWS('ScreenData'), 'ScreenData'[Exceeded_Recommended_Limit] = TRUE),

  COUNTROWS('ScreenData')

)