Energy Analytics with Power BI and IoT: A Hands-On Guide

Explore the ESP32 board: dual-core CPU, onboard Wi-Fi and Bluetooth, security features like secure boot and flash encryption, and power management for rapid IoT prototyping.

Explore the ESP32 power requirements, including 2.2–3.6 V operation, onboard LDO regulator, USB and Vin powering options, and ultra-low sleep current ideal for wearable IoT devices.

Master the esp32 board pinout and specifications, including v in, 3.3v, ground, usb, boot and reset buttons, and gpio, pwm, adc, dac, touch, i2c, spi, and serial interfaces.

Program the ESP32 using Arduino IDE, MicroPython, or ESP-IDF, and explore form factors from development boards to modules, with breadboard projects and onboard peripherals.

Install the Arduino IDE on Windows, Mac, or Linux, download Arduino IDE 2.2.1, accept the license, choose installation scope, and finish setup to write, compile, and upload programs to hardware.

Add the Esp32 Arduino Core URL in Arduino IDE preferences, install Esp32 boards via boards manager, then select the Esp32 dev kit v1 to write, compile, and upload programs.

Learn to blink an led with an esp32, wiring led to digital pin 25 through a 30 ohm resistor, and uploading a loop that toggles high and low every second.

Learn how the pgdm 004t ac energy meter sensor measures voltage, current, power, energy, and power factor with a current transformer and voltage divider, plus uart output.

Interface the PZEM-004T ac energy meter sensor with the ESP32, wiring voltage, current, and power paths, and monitor real-time energy data across no-load and bulb-load cases.

Install the PZEM004TV30 library in the Arduino IDE via Library Manager, then use the library examples to read electrical parameters from the PZEM004T energy monitor via serial with ESP32.

Learn to read voltage, current, power, energy, frequency, and power factor from the pgdm 0 0 40 sensor using Esp32 over uart, and print results via serial.

Explore Thingspeak, an IoT cloud platform that collects, visualizes, analyzes, and acts on sensor data using HTTP and MQTT, Matlab integration, and support for Arduino, ESP32, Raspberry Pi.

Learn how to create a Thingspeak account, set up a weather station channel with temperature, humidity, and light intensity fields, and manage API keys for HTTP data exchange.

Explore how Thingspeak rest api enables IoT devices to send and update sensor data to the cloud using http endpoints, api keys, and field parameters.

Create three Thingspeak channels with six fields for voltage, current, power, energy, frequency, and power factor to analyze no load, one bulb load, and two bulb loads in Power BI.

Connect the ESP32 to wifi, read voltage, current, power, energy, frequency, and power factor, and send real-time data to the Thingspeak cloud via an http get request.

Install power BI desktop by visiting the power BI site, selecting desktop, and downloading the appropriate 64-bit or 32-bit installer; run it to launch Power BI and view the interface.

Explore Power BI desktop’s interactive data visualization and data sources such as spreadsheets, databases, and cloud platforms, and master features like the ribbon, Get Data, Transform Data, and visuals.

Explore how categorical and numerical data drive visuals such as bar charts, tree maps, line charts, pie charts, gauge charts, and scatter charts for energy analytics with Power BI.

Explore Power Query for data cleaning and transformation, learn to remove duplicates, filter rows, split and merge columns, and load cleaned data into Power BI.

Connect Power BI to Thingspeak using REST API data from three channels, publish publicly, import with Power Query, and rename fields like voltage, current, power, energy, frequency, and power factor.

Clean and transform energy data in power bi, remove errors, standardize zeros, add load-level indicators, merge datasets, extract time features, and build dax energy and cost metrics.

Create a Power BI energy usage dashboard to analyze smart home power consumption with gauges, line and area charts, comparing one versus two bulb loads and costs in INR.

Create and style a Power BI energy analytics dashboard by designing a new page, applying backgrounds and title formatting, and assembling top visuals into polished card and gauge charts.

Design and customize the energy analytics dashboard visuals in Power BI, including line, bar, and area charts, with bold titles, bold axis labels, and precise color and range settings.

Analyze energy data to show how adding bulbs increases electrical load and power use, and how energy consumption grows over time; save by switching to LED bulbs and using daylight.