Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Data & Analytics Intermediate

Energy Bill & Load Profile Analytics: kWh, Peak Demand & Tariffs

Analyse a small business's 15-minute smart-meter data: kW vs kWh, hourly load profiles with AVERAGEIFS, peak demand and load factor, a time-of-use bill, demand charges and peak shaving, night baseload, weather normalisation with degree days and a three-tariff comparison dashboard: 8 graded labs with illustrative tariffs.

8 lessons 8 labs 1.9 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Convert six hours of 15-minute smart-meter readings into kWh and separate energy (kWh) from demand (kW).
  • Turn 192 readings (Friday and Saturday) into an hourly load profile per day type, find the peak hour and chart both profiles.
  • Calculate average demand and load factor month by month and for the whole period, and find the peakiest month.
  • Price June's consumption hour by hour on a time-of-use tariff and work out the peak share and the average price per kWh.
  • Split six bills into energy cost and demand charge and value a plan that caps the monthly peak by staggering the ovens.
  • Measure the bakery's night baseload from a week of hourly data, its share of the weekly energy and what it costs per year.
  • Fit monthly kWh against heating degree days, split weather-driven from baseline use and restate the year for normal weather.
  • Price twelve months of consumption on three tariffs with one formula, pick the cheapest, calculate the saving and highlight the winner of every month.

About this course

Your electricity bill hides a story that only interval data can tell. Starting with 15-minute meter readings, you convert kW into kWh and build an average daily load profile by hour with a chart. Peak demand and load factor show how spiky consumption is, and an hourly lookup prices every interval under a time-of-use tariff. You estimate what lowering the peak would save on demand charges, separate baseload from variable load to find equipment that runs when nobody is there, and normalise consumption for weather with degree days and a fitted line. A final dashboard compares tariffs and totals the savings. Useful for facility and energy managers, sustainability staff, small business owners and engineering students.

Curriculum

Course content

8 lessons · 8 labs · 1.9 h · final exam

  1. kW vs kWh: Turning 15-Minute Meter Readings into EnergyLab12 min4 checked tasks
    Unlocked when you buy the course
  2. Daily Load Profiles: Average kW by Hour with AVERAGEIFS (and a Chart)Lab16 min4 checked tasks
    Unlocked when you buy the course
  3. Peak Demand & Load Factor: How Peaky Is the Load?Lab13 min4 checked tasks
    Unlocked when you buy the course
  4. Time-of-Use Tariff: Pricing Every Hour with an Approximate LookupLab15 min4 checked tasks
    Unlocked when you buy the course
  5. Demand Charges & Peak Shaving: What a Lower Peak SavesLab14 min4 checked tasks
    Unlocked when you buy the course
  6. Baseload vs Variable Load: What Runs When Nobody Is There?Lab14 min4 checked tasks
    Unlocked when you buy the course
  7. Weather Normalisation with Degree Days: SLOPE, INTERCEPT & a Scatter ChartLab15 min4 checked tasks
    Unlocked when you buy the course
  8. Tariff Comparison & Savings DashboardLab16 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Data & Analytics courses →
$9.99one-time payment
Buy course