Table of Contents

This notion page consists of the following:

• Technical Documentation
  • ETL Pipeline Design
  • Database Design
• Data Analytic Documentation

High Level Overview

Project objective and purpose

The objective of this project is to run advanced analytics and produce insights on utility spendings. This will be used to track the costs of utilities, and also provide insights into how usage affects costs, but also the increase in rates for utility companies.

The main utilities focused on this project are:

• Electricity
• Water
• Gas

The goal of this project is to:

• [ ] Create a source-of-truth for utility invoices and data (cost, rate, usage etc.)
• [ ] Create a dashboard view to be able to quickly view and analyse trends
• [ ] Be able to compare current invoice rates to other future providers

Architecture Diagram