This dataset provides insights into energy consumption patterns based on various building characteristics and environmental factors. It includes data for different building types, their square footage, the number of occupants, appliances used, average temperature, and the day of the week. The objective is to create a predictive model that estimates energy consumption using these attributes.
This dataset is ideal for training machine learning models, such as linear regression, to forecast energy needs based on building features. The insights derived from this data can help optimize energy consumption, understand demand patterns, and improve energy management across diverse building types and conditions.
Dataset can be downloaded from Kaggle: https://www.kaggle.com/datasets/govindaramsriram/energy-consumption-dataset-linear-regression?select=train_energy_data.csv
Suggested Power BI Dashboard Visuals:
- Energy Consumption by Building Type
- Visualization: Bar Chart or Pie Chart
- Purpose: Show the distribution of energy consumption across different building types (Residential, Commercial, Industrial).
- Energy Consumption vs. Square Footage
- Visualization: Scatter Plot
- Purpose: Identify correlations between a building’s size and its energy usage.
- Average Energy Consumption by Day of the Week
- Visualization: Line Chart or Column Chart
- Purpose: Highlight energy usage trends across weekdays and weekends.
- Energy Consumption vs. Number of Occupants
- Visualization: Bubble Chart or Scatter Plot
- Purpose: Analyze how the number of occupants influences energy consumption.
- Energy Consumption vs. Average Temperature
- Visualization: Line Chart or Heatmap
- Purpose: Show the impact of temperature on energy consumption patterns.
- Appliance Usage Impact on Energy Consumption
- Visualization: Stacked Bar Chart
- Purpose: Illustrate how the number of appliances used affects energy consumption across building types.
- Comparative Analysis of Energy Consumption (Weekday vs. Weekend)
- Visualization: Clustered Bar Chart
- Purpose: Compare energy consumption trends for weekdays and weekends.
- Energy Consumption per Square Foot by Building Type
- Visualization: Treemap
- Purpose: Visualize energy consumption efficiency across building types relative to square footage.
- Interactive Map (Optional)
- Visualization: Map Chart (if geolocation data is available)
- Purpose: Display energy consumption geographically for better spatial analysis.
- Summary Card or KPI Indicators
- Visualization: KPI Tiles
- Purpose: Highlight key metrics such as total energy consumption, average energy consumption per building, or peak energy usage.
Each visual can be made interactive, allowing users to filter by specific building types, days of the week, or temperature ranges to gain deeper insights.