Transcript – Analyzing Data in Macrobond

[01 Analytics - intro] 

Once you've found and selected the data to work with the next step is doing something with it the Analytics activity. This is where you’ll be executing calculations, linking your workflow with external resources or tools, and applying customizable chart styles and tables. After watching the video, you should have an idea of which tutorials you want to focus on to help you get started. You’ve heard it before, but it’s worth repeating, getting to know just a few of these features and tools will make a big difference to how effectively you work right from the start.

[02 Analytics - organization] 

The workflow in Analytics is organized from the left to the right: on the left side, you have the Series Browser. Use this to select and add time series to the document. In the middle, you have the Analysis Tree this is where you work with the data you have added. Here, on the right, you have the Presentation area where your work is visualized, either as a table or chart .

[03 Series browser - databases] 

Let's start in the Series browser, here you can select and view all the databases available in Macrobond. At the top you have the Economics database, listed in terms of the different schemas you can use to navigate the data. The Economics database is primarily comprised of local and national sources of data, collected by Macrobond. The different schemas, or database views, include categorycountryregion and source. Scrolling down further, you’ll see third-party databases from of a wide array of data aggregators, such as Eurostat, IMF, OECD and World Bank, to name a few – we call these complementary databases.

[04 Series browser - structure] 

As you see, the data is organized using a tree structure, made up of primary and sub- categories of data. When you select the sub-category the application will generate a list of the available series for that category below.

[05 Series browser – adding series] 

Alternatively you can use the Search field. This will return results are in order of relevance.

[06 Series list – the purpose] 

Opening the series list allows you to make sure the series are in a comparable format and adjusting various parameters if necessary. The parameters for adjustment are frequency, observations, missing values, currency, date range, conversions and forecasts.

[07 Analysis tree – Add analysis] 

Once you've made the necessary adjustments in the Series list, you can go ahead add analyses. For that you'll use the Add function - over here - which allows you to select from a range of different analyses and presentations. Every calculation or presentation that you select is then added as a new branch in the tree structure, which also means it'll define the output of the branches below it.

[08 Analysis tree – Insert analysis] 

While the add button always results in a new branch being added to the end of the tree, using Insert allows you to choose where in the tree you would like to insert a calculation.

[09 Analysis tree – Undo the changes] 

Easily undo changes with the standard Ctrl+Z key command, or select Undo from the Edit menu.

[10 Analysis tree – summary] 

Using the Analyses tree is a powerful tool to help you see and understand the effect of each new analysis on the sequence of calculations.

[11 Formula language] 

You can also perform various analyses using the formula language. Use this if you want to have more flexibility to customize the calculations you apply. The formula language can either be applied to the start of the tree or to a particular section. Here, we are going to recreate a year on year percentage change for industrial production.

[12 Using Macrobond data and analyses in other application] 

The last point for this video is that Macrobond data as well as analyses can be very easily integrated with the variety of third party tools for further analysis.
At this point you should have a good idea of which options you have for analyzing data. Have a look at the Analytics section in the Curriculum for step by step guides on the cases we went through in the video.