Calculating moving average & adding recession bands Objectives Using the Smoothing analysis Displaying recession series as fill range Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to do next. Video (Note that since making this video we have further developed some elements in app and our … Continue reading “Case #10”

Finding Data In this example, we are using three time series on Germany: Retail Trade, Consumer expectations and a recession indicator. Therefore, we will use the “Country & Region” view.   To find the Retail Trade series, go to: Country & Region > Germany > Trade > Domestic Trade > Retail Trade > Constant Prices  … Continue reading “Worksheet – Case #10 – Calculating moving average & adding recession bands”

Using Correlation to determine the best lag Objectives Finding the optimal lag based on the correlation between series Using the Lag analysis Circling several values of a series Solution If you get stuck, use the video or worksheet to see what to do next. If you need more detailed help, have a look at the … Continue reading “Case #9”

Finding Data In this case, we will reuse the document from Case #3 which can be downloaded here. As such, all data needed for this exercise can be found in the document. Document preparation Reverting adjustments As we are reusing a document, some adjustments need to be reverted from the earlier case. Select “Time chart” … Continue reading “Worksheet – Case #9 – Using Correlation to determine the best lag”

Finding Data In this example, we are using two main indicators for Japan’s GDP and Industrial Production. One easy way to find these data is to use the “Concept & Category” database, as it limits the amount of data available in the tree. To find the series go to: Concept & Category > National Accounts … Continue reading “Worksheet – Case #4 – Working with series that have different frequencies”

Working with series that have different frequencies Objectives Combining data with different frequencies Adjusting the frequency conversion method Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to do next. Video (Note that since making this video we have further developed some elements in app and our … Continue reading “Case #4”

Finding Data You need to find data on loans to households for all the Euro area countries. In this example we’ve used harmonized series from the ECB. There are two approaches you can try. Concept & Region Select Concept & Category and then the following: Concept & Category > Money, Banking & Credit > ECB … Continue reading “Worksheet – Case #8 – Using Cross Section to analyze a group of series”

Using Cross Section to analyze a group of series Objectives Finding data using Concept & Category Using the Cross Section analysis on several series Using stripes as layout to represent percentiles Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to do next. Video (Note that … Continue reading “Case #8”

Create a Scatter Chart Objectives Creating a scatter chart Editing the appearance of the chart Using basic dynamic properties to write text Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to do next. Video (Note that since making this video we have further developed some … Continue reading “Case #7”

Finding Data To find the business surveys used for the IFO Clock, go to: Country & Region > Germany > Surveys & Leading Indicators > Business Surveys > Ifo > Business Surveys > Trade & Industry > Germany Locate and select the following series: Business Situation, Index, SA Business Expectations, Index, SA Add them to … Continue reading “Worksheet – Case 7 – Create a Scatter Chart”