These training sessions were recorded live during 2020/2021.
Click on a link in the grid to open the recording, or scroll down the page to see the Agendas and a links to the recordings.
Below are the Agendas for each of the above sessions. You can also click on the Session name to open the recording.
Accrual Reporting
recorded in August 2020
What Accruals are
How to run the Accruals Master Report
Explanation of the columns in the Report
Saving the Report in Sigma
How to run the Accruals per Account by Month EI Report
Explanation of the columns in the Report
Available Help
Adding additional data to Sites for Benchmark Reporting
recorded in August 2020
- What additional data can be added?
- Floor Area, Population, Occupancy, Degree Days etc
- How to add additional data to a Site
- How to add the data value
- How to add additional data using the Data Wizard
- How to add additional data in bulk
- How to view and update additional data
- Reporting
- Sigma Reports
- Energy Intelligence Reports
Adding Asset Types for commodities e.g Solar Generation, EV Charging, Heating/Cooling etc (Release 12.21)
recorded in November 2020
- Data Selector changes
- Editor Changes
- Estate Management changes
- Viewing Meter Relationships
- Assigning Meter Relationships and Assets individually
- Adding new Asset Types
- Assigning Meter Relationships and Asset Types in bulk
- Data Edit Spreadsheet
- Tag CSV files
- Creating Items such as Account, Meter, Supply Points etc
- Online User Manual updates
Adding Bespoke Emission Factors and New Password Security (Release 12.25)
recorded in March 2020
- How to add bespoke GHG Conversion Factors
- How to import Consumption Data in bulk
- Improvements to the Password security
Bill Entry
recorded in September 2020
- Tips on entering Bills
- Amending the view to suit your needs and the supplier format
- Specific Validation for manual Bills
- Moving between Bill Entry/EDI Batch Management/Estate Management
- Available Help
Budgeting
recorded in June 2020
- Determining your Budget Figures
- How to create a Budget Group
- How to add Accounts, Meters or Monitoring Points to the Budget Group
- How to add Target figures (if required)
- How to view/manage the Budget once created
- Help Files
Checking the Quality of your Sigma Database
recorded in September 2021
- Reports to identify issues with the database set up
- Best Practice Set Up
- Rectifying the issues
- Reports to help identify gaps / accuracy in data
- Online User Manual updates
Creating Multiple GHG Categories to enhance GHG Reporting - Release 12.29
recorded in August 2021
- Updating an existing Commodity to include a second GHG Category
- Creating a new Commodity with a second GHG Category
- Recap on the changes to Emissions Reporting Period (Release 12.28
EDI Automation
recorded in May 2020
- Setting up EDI Automation
- What gets automated?
- Email notifications
- Where to view the automated schedule
Editing Data in Bulk in Sigma
recorded in July 2020
- Exporting data in bulk
- Sites, Accounts, Meters etc
- Updating data in bulk
- Address details, Meter Locations. Channel IDs etc
- Property Keys
- Reporting on what Data (Accounts, Meters etc) is attached to a Supply Point
- Changing Contract and Account number in bulk
- Available Help
Emission Factor Reporting Period Configuration & Adding Commodities in Bulk (Release 12.28)
recorded in July 2021
- Changing the Emission Reporting Period
- Adding Commodities in Bulk
Energy Intelligence Reporting
recorded in June 2020
- Overview of what data goes into EI
- Overview of EI
- Different types of Reports (known in EI as views)
- Example Reports, including:
- Monthly Consumption and Cost – using billing data
- Emissions (Pie Chart) – using best available data
- How to mark Reports as Favourites / Bookmarks
- How to export/schedule Reports, including sending reports to non Sigma Users and embedding links
- Example Dashboard
- Help files
Energy Intelligence Report Editing
recorded in July 2020
- Columns
- Renaming Columns
- Changing Column widths
- Reordering Columns
- Adding Prefixes and Suffixes
- Adding Totals, Averages etc
- Filtering Options
- Adding/amending User Filters
- Adding/amending Predefined Filters
- Linking Filters (drilling down from Site Group to Site)
- Moving the location of a Filter
- Adding a Logo to a Report
- Available Help
EI Report Editing
Recorded May 2021
- Amending existing Filters
- Changing from/to User Filters and Predefined Filters
- Adding additional Filtering
- Such as Assets, Property Keys etc
- Additional options on Filtering
- Hiding existing Columns
- Amending Column Header names and Filter Names
- Removing or replacing existing graphs
- Adding Company Logo to a report
- Saving the revised report
- New Reports in Energy Intelligence
Energy Viewer
recorded in July 2020
- Using the Energy Viewer
- Setting up Users for the Energy Viewer
- Restricting Access to certain Sites
- Available Help and Video
Entering Manual Meter Readings
recorded in July 2020
- Inputting Manual Readings
- In bulk
- Via the Energy Viewer
- Reporting on last entered Meter Readings
- Exporting Meter Readings
- Validating Billed consumption against Manual Meter Readings
- Self Read Values Report
- Available Help
Estate Setup and Maintenance
recorded in May 2020
- Setting up a Site
- Setting up the Supply Point, Account, Meter and Channels in one go
- Setting up Supply Points, Accounts, Meters and Channels separately
- Linking these to a Supply Point
- Changing Account Numbers (and Suppliers)
- Changing Meters
- Closing Sites
- Location of Help Files
Forecasting Consumption and Emissions Data
recorded May 2021
- Methodology of Forecasting Consumption and Emissions Data
- Configuration options for Estimation Techniques and Forecasting
- Sample Energy Intelligence Report
- Emissions Summary Dashboard
GHG Scope 3 Reporting (Release 12.24)
recorded in March 2021
- How to add Commodities such as Waste, Transport, Business Travel, Commuting, Supply Chain etc
- How to add Consumption Data Items to aid Scope 3 reporting
- Additional Emission Factors added to EI
- How to view improvements to the Emissions Summary Dashboard
Hints, Tips and Shortcuts for Sigma
recorded in September 2020
- Refreshing the data
- Expanding the screen
- Searching tips
- Hints and tips around Sigma
Identifying Data Gaps using the Data Monitoring Activity
recorded in May 2020
- Overview of the Data Monitoring Activity
- How to set up a Data Gap Strategy (so that Sigma will look for gaps in Half Hourly Data every night)
- How to view those Gaps
- How to fill Gaps automatically (if required)
Importing AMR Data
recorded in June 2020
- Checking the Periodic Channel is set up correctly
- Finding the right Importer
- Importing the data
- Importing the data automatically
- Spot checking/viewing the imported data
- Unmatched Data process
- Monitoring the Data
Managing your Estate
recorded in May 2020
- How to view all of the Supply Points, Accounts, Meters & Channels attached to a Site
- How to edit/create new Items
- How to change/manage Contracts
- How to manage/add Associated Data
- How to link seamlessly to other Activities such as Bill Entry and Reporting
- Location of Help Files
Monitoring Trends in HH Data
recorded in August 2020
- Explanation of the two available Trend Strategies
- Fixed Profile Strategy
- Dynamic Profile Strategy
- How to set up a Trend Strategy
- How to create daily/weekly/monthly emails with notifications of anomalies
- How to work through Notifications and investigate further
- How to add notes and close a Notification
Query Management
recorded in June 2020
- What is a Query in Sigma?
- Identify existing Queries
- How to create a Query from various activities such as
- EDI Billing
- Bill Entry
- Estate Management
- Reporting
- How to manage Queries
- Filtering Options in the Query Management Activity
- Reporting on Queries
- Help Files
Recharging your Tenants using Sigma
Learn how Sigma can help you recharge part of your Estate to Departments or
Tenants
recorded in July 2020
- Produce bills for tenants using your metered or billed consumption values
- produce paper bills
- produce a file for your Accounts System
- View the additional elements of Sigma required to recharge tenants
- Manage change of tenancies within Sigma
Recording your data for Energy Compliance
recorded in September 2020
- Understanding what details can be recorded
- How to record data such as DECs and EPCs
- How to attach the documentation
- Available Help
Refreshing EI Data and Emissions Dashboard (Release 12.23)
recorded in February 2021
- Refreshing Energy Intelligence data as and when required
- Changes to the Best Available Data in Energy Reporting
- Ability to personalise the preferences of the data used
- New Emissions Dashboard based on Best Available Data
- Introducing the Energy Intelligence Directory of Reports
- Data Integrity Improvements – warning messages
- Changing the Water symbol in Sigma
Reporting on Half Hourly Data
recorded in June 2020
- A selection of reports in the Reporting Activity, including
- Site Monthly Profile
- General Graph & Table
- Daily Consumption Exception
- Channel Day Compare/Channel Week Compare
- A selection of reports in Energy Intelligence Activity, including
- Channel Day Compare
- Site Analysis Dashboard
- Browsing Data
- Available Help
Setting up Validation
recorded in May 2020
- Understanding EDI pre-set validation
- Understanding what validation currently exists on your database
- How to add new validators
- Including variables and tolerances
- Validator setup – best practice examples
- Understanding failed validation
Understanding and Running a Report in Energy Intelligence
recorded in October 2021
- Understanding Energy Intelligence
- Layout
- Folders
- Searching for Reports
- Best Available Consumption Data View
- Opening and understanding a Report
- Filtering options
- Exporting a Report
- Closing a Report
- Right click options
- My Favourites Folder
- Refreshing the data
- Energy Intelligence Report Directory
Using the Accounting System Interface for Billing Data transfer
recorded in August 2020
- Understand the function of the Interface
- Understand the options available in creating the file
- All bills, specific EDI file, specific commodity, a Site or Site Group, date ranges etc
- Create a file
- View/Extract the transfer files
- View the extracted date in the bill
Validation - Understanding Query/Failed Validation Issues
recorded in June 2021
Viewing the Query / Failed Validation
Understanding / Investigating the Failed Validation message
10 Example Validators
Setting a query to deal with the issue at a later date
Viewing / Amending existing Validator criteria
Online User Manual