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 (Custom Column):

if [Age] <= 8 then "5–8"

else if [Age] <= 12 then "9–12"

else if [Age] <= 15 then "13–15"

else if [Age] <= 18 then "16–18"

else "Other" 

• Screen Category (Conditional Column)

• if [Screen Time(hrs)] <= 2 then "Low Screen Time" else if [Screen Time(hrs)] <= 4 then "Moderate Screan Time" else "High Screen Time")

Apply and Close.

3. New Measures (DAX in Power BI)

1. Average Screen Time:

DAX:

Avg Screen Time = AVERAGE(Indian_Kids_Screen_Time[Screen Time(hrs)])

2.    DAX : 

 % Exceeding Limit =

DIVIDE(

  CALCULATE(COUNTROWS(Indian_Kids_Screen_Time),Indian_Kids_Screen_Time[Exceeded Recommended Limit] = TRUE),

  COUNTROWS('Indian_Kids_Screen_Time')

)