1 / 13

SDMX data discovery, query, and visualisation within Excel

SDMX data discovery, query, and visualisation within Excel. Chris Nelson Metadata Technology. Why Integrate with Excel?. Excel is a familiar desktop tool Used to import data (usually as CSV) View data as tables and charts Manipulate data It is not typically used to query data sources

teigra
Télécharger la présentation

SDMX data discovery, query, and visualisation within Excel

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. SDMX data discovery, query, and visualisation within Excel Chris Nelson Metadata Technology

  2. Why Integrate with Excel? • Excel is a familiar desktop tool • Used to import data (usually as CSV) • View data as tables and charts • Manipulate data • It is not typically used to query data sources • Therefore the choreography of accessing data in Excel has multiple steps • This choreography does not lend itself to data discovery and query

  3. Typical Choreography for Data Query and Viewing in Excel query Data Web Service User Interface response Download as CSV save view load

  4. Solution • Develop an add-in for Excel that can: • Interface to a web service that • Delivers information on data sources (what is available) • Delivers information that can be used to query data sources – wherever they are • Queries the data sources • Delivers data and corresponding structural metadata that enables intelligent display of data • Possibility to provide data manipulation useful for statisticians and analysts (extrapolation, seasonal adjustment)

  5. Architecture Simple Web Services for Data Discovery & Visualisation Fusion Cube SDMX Web Service SDMX Web Service SDMX Web Service Structural Metadata Data Quality Metadata

  6. Architecture: Interfaces • REST • JSON Simple Web Services for Data Discovery & Visualisation Fusion Cube • SDMX Web Services SDMX Web Service SDMX Web Service SDMX Web Service Structural Metadata Data Quality Metadata

  7. DataStructure Definition Category Scheme Data Flow Category Categorisation Data Provider Scheme  Drill Down Provision Agreement Data Provider  Query Discover  Register Data Discovery and Query Support in SDMX Registered Data Source Data Source references Content Constraint

  8. Step 1: Select Topic SDMX Structures User View in Excel Ribbon Web Services

  9. Step 2: Select Dimensions DataStructure Definition Data Flow

  10. Step 3: Make Dimension Selections

  11. Step 4: Submit Query User View in Excel Ribbon SDMX Structures Web Services

  12. Step 5: View Data

  13. Step 6: Pivot table

More Related