Dashboards and charts (pick one tool)
Show ESG trends clearly in one reporting tool, with a sound data model, honest chart choices and a plan for refresh and access. You will build a one-page dashboard from a clean table.
- Core
- Beginner
- about 15 hours
- Pick one
Written by the GreenHired editorial teamSources last checked 20 November 2026How we research roadmaps
Whatever the tool, three habits decide whether a dashboard can be trusted: a clean data model, honest charts and a plan for refresh and access. Begin with the question a reader would ask, list the fields that answer it, and only then pick the chart. Pick one tool and learn it properly rather than four badly.
Answering “which site used more electricity?”
A facilities manager asks which site used more electricity this year than last.
What goes in the data model? One table of measurements with the columns site, month, metric, value and unit, plus small lookup tables for sites and dates. If your data arrive as one wide sheet with a column per month, reshape it first, with SQL and Python once the data outgrow a spreadsheet.
Which charts? A bar chart compares sites, a line shows the monthly trend, and one KPI card gives the year-on-year change.
What does the KPI say? Site A used 540 MWh this year and 600 MWh last year (made-up numbers). Change = (540 - 600) / 600 = -10%. Print the unit and the period beside it.
Where should the axis start? At zero for bars. If it starts at 500, the two bars are 40 and 100 units tall, so the 540 bar looks 40% as tall as the 600 bar when the real ratio is 90%.
Choosing the tool
Use the tool your target employers name in their postings. Of the 16 job postings we sampled (UK, EU, US and India; how we research roadmaps), 5 named a BI tool such as Power BI or Tableau and 8 named Excel, so read the adverts you are aiming at before you commit. If you cannot tell, Google’s documentation describes Data Studio as having a no-cost tier, and Excel charts need no extra software.
Tick one box on the map once you have built a real dashboard, and the other alternatives leave your total.
Before you share it
Too many charts, or colour with no meaning, leave readers unable to find the answer. Give each chart one question, and use colour to point at what matters. Check contrast against the W3C rule in the resources.
A dashboard makes a mistake look official, so reconcile every number to the source with the checks from your auditable workbook, and read numbers and finance literacy before showing any intensity or year-on-year figure.
If only one person can refresh a dashboard, write on each page where the data come from and when it was last refreshed, and keep the refresh steps in a note.
What you will learn
- Pick one tool and build a dashboard from a clean table of ESG data.
- Organise data as a simple model: one fact table of measurements and small lookup tables for sites, dates and metrics.
- Choose a chart that fits the question: lines for trends, bars for comparison, tables for exact values.
- Plan how the data refreshes and who may see which sites or metrics.
- Check that colour and labels are readable for people with low vision or colour blindness.
Pick one of these
These are alternatives. Learn the one your employer or course uses; one is enough to complete the topic.
Power BIabout 15 hours
Microsoft's BI tool: learn the data model, a few report pages and scheduled refresh.
Power BI connects to Excel files, databases and cloud sources, builds a model of related tables and lets you design interactive report pages. Connecting a monthly emissions table and a site table, related on site ID, lets you build a trend chart that filters by region. Loading one wide spreadsheet and writing complex calculations to make up for a messy structure is the habit to avoid, and Microsoft's guidance recommends a star schema (a central fact table with surrounding dimension tables) instead.
- Training for Power BI Microsoft Learn · Course
- Understand star schema and the importance for Power BI Microsoft Learn · Guide
- Data refresh in Power BI Microsoft Learn · Guide
- Row-level security (RLS) with Power BI Microsoft Learn · Guide How to show each viewer only the sites or regions they should see.
Tableauabout 15 hours
A visual analytics tool that is strong for exploring data and building interactive views.
Tableau lets you drag fields onto a canvas to build charts and then combine them into dashboards with filters. It suits teams that already use it elsewhere in the business, such as finance or sales. A sustainability analyst, for instance, builds a waste-by-site dashboard that managers filter by month. Tableau Desktop is a commercial product; check Tableau's own site for current licensing and for any free option, because its pricing pages could not be verified in this review. Learn data structure along with the clicks: tidy, long-format data makes every tool easier.
- Tableau Desktop: get started Tableau · Guide Official help pages; the software itself is a commercial product.
Data Studio (formerly Looker Studio)about 12 hours
Google's free reporting tool, good for lightweight dashboards on spreadsheets and Google data; check the product's current name.
Google's documentation now calls the product Data Studio and describes it as a no-cost tool that turns data into reports and dashboards, with viewer filters. A Google Cloud blog post of 11 April 2026 says Looker Studio is returning to the Data Studio name, with a no-cost tier and a paid Pro tier. See the documentation for the data sources it supports. A small team can share a dashboard built from a spreadsheet of energy use, which suits a small budget. Expect it to handle large or complex models less well than paid tools: keep the data simple and pre-cleaned.
- Data Studio documentation Google Cloud · Guide
Excel charts and dashboardsabout 10 hours
Build clear charts and a simple dashboard inside Excel itself; the lowest-friction option, since it needs no extra software.
Excel can produce clean line, bar and combination charts, connected to tables or pivot tables, and arranged on one dashboard sheet with slicers. Example: a one-page sheet with a pivot-driven trend chart, a site comparison bar chart and a KPI box. It needs no extra software and is easy to hand over, which suits small teams. A dashboard that is really a long sheet of pasted values breaks when the data changes, so link everything to tables and the charts will update when you refresh.
- Create a chart from start to finish Microsoft · Guide
Practice task
Using a table of monthly energy and emissions data for several sites (your spreadsheet from the earlier topic is fine), build a one-page dashboard in your chosen tool: a trend line, a site comparison, one KPI card with the year-on-year change, and a note saying where the data comes from and when it was last refreshed. Export it or share a screenshot.
Skills you build
Chart choiceData modelling basicsDashboard designRefresh and access controlAccessible colour
Resources for this topic
Every source here is free. Each link opens the provider's own site in a new tab.
- Visual Vocabulary Financial Times Chart Doctor · Guide A poster that groups chart types by what relationship you want to show.
- Understanding Success Criterion 1.4.3: Contrast (Minimum) W3C Web Accessibility Initiative · Standard The contrast rule behind readable text and chart labels.
- Breakdown of emissions by sector Our World in Data · Dataset Open data you can load into any tool for the practice task.
Live ESG analyst jobs
Roles whose title matches this career path.
Spot a problem with this topic?
Tell us what is wrong, missing or unclear here. Your note is attached to this topic.
Notes are sent from this page with JavaScript on. Without it, write to us on the contact page.