Master Energy & Sustainability Analysis using Excel and BI

Master Energy Analysis using ExceI and Power BI: Renewable and Sustainable Solutions

Created by: Syed Rakiul Huq
Instructor of Energy Analysis and Data Analysis using Excel

What Will I Learn?

• Learn how to use powerful functions like XLOOKUP, VLOOKUP, and INDEX & MATCH to efficiently retrieve and manage energy and sustainability data.
• Gain the skills to predict energy and sustainability usage with precision using Degree Days and regression analysis.
• Master advanced techniques such as CUSUM (Cumulative Sum) analysis to identify energy-saving opportunities.
• Learn to calculate key financial metrics like Payback Period, Benefit-Cost Ratio (BCR), and understand the Time Value of Money.
• Use Excel to evaluate the financial viability of energy efficiency and sustainability projects, helping you make informed investment decisions.
• Understand how to use Excel for energy and sustainability portfolio analysis, helping you prioritize projects based on their economic and environmental impact.
• Learn how to visualize energy data in Power BI to uncover actionable insights.
• Learn how to use DAX in Power BI
• Fundamentals of Energy Analysis
• Fundamentals of Carbon Accounting
• Sustainability Reporting Frameworks (GRI, TCFD)
• Renewable Energy Data Analysis
• Data Cleanse and Heat Map Visualization using Power BI
• Wind Energy Data Analytics
• Solar Energy Data Analytics

Requirements

• No experience needed. You will learn everything you need to know.

Target audience

• Energy Analysts,Energy Managers,Energy Engineers,Sustainability Consultants
• Data Analysts in the Energy Sector
• Financial Analysts in the Energy Sector
• Facility Managers and Sustainability Officers
• Engineering Students and Recent Graduates
• Data Analysis Enthusiasts
• Data Analysts curious about Energy Sector and Sustainability Sector
• Energy Analysts curious about leveraging the power of data
• Renewable Energy Consultants
• Wind Energy Consultants
• Solar Energy Consultants