1 / 17

Exploring IEA statistics with Beyond 20/20

Exploring IEA statistics with Beyond 20/20. Energy Statistics Training Paris, 4-8 March, 2013 Gustav Boëthius Monthly Oil Statistics. Presentation overview. What is Beyond 20/20? Accessing IEA data with B20/20 Data layout in B20/20 Nesting dimensions, viewing notes

mostyn
Download Presentation

Exploring IEA statistics with Beyond 20/20

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exploring IEA statistics with Beyond 20/20 Energy Statistics Training Paris, 4-8 March, 2013 Gustav Boëthius Monthly Oil Statistics

  2. Presentation overview • What is Beyond 20/20? • Accessing IEA data with B20/20 • Data layout in B20/20 • Nesting dimensions, viewing notes • Examples of other B20/20 features • Charts, time series, sorting data, exporting data • Further information and practical exercises

  3. What is Beyond20/20? • A programme toaccess and view statistical data • Easy to display multi-dimensional datasets • File extension: .ivt - IEA publishes energy data in this format

  4. Accessing IEA data with B20/20 Annual, quarterly services and monthly gas http://wds.iea.org

  5. Accessing IEA data with B20/20 http://mods.iea.org/ Monthly Oil Data Service

  6. Accessing IEA data with B20/20 1 2 Download .ivtfile

  7. Data layout in B20/20

  8. Data layout in B20/20 Dimensions Active dimension Elements in the active dimension

  9. Nesting dimensions (drag and drop)

  10. Viewing notes on elements

  11. Examples of other B20/20 features Charts Time series Export to Excel Frequency

  12. Other features:Displaying data on a chart Hurricane Gustav Hurricane Katrina Insert chart Select data and then View > Chart or click on

  13. Other features:A range of chart options Change chart type Right click > Chart options Format chart Double click on the element Copy a chart Right click > Copy

  14. Other features:Time series options – set frequency For closing stock levels Remember to choose “Last Values”

  15. 26 September 2012 Other features:Sorting data To sort data 1. Select a dimension 2. Click on 3. Remember to choose “Data” as a field 4. Choose increasing or decreasing

  16. Other features:Exporting data to Excel • Select data, copy and paste it to Excel • File > Save as .xls

  17. Further information • B20/20 Manual Next: Practical exercises B2020.1 - Hiding elements and displaying chart B2020.2 - Sorting data B2020.3 - Exporting to Excel B2020.4 - Pie chart

More Related