Home

User Manual - Economics & Country Risk

Contents

1. Russian Ruble pyi l British Pound Indian Rupee Fs D Japanese Yen 2 l Chinese Yuan C L Swiss Franc Fri T Local Currency E OK g Cancel l Help Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 71 J When you have a smart workbook selected use Settings to specify settings for that one particular workbook overriding any global default settings for all smart workbooks settings SmatWorkbook Settings E f Export i Format f Date Range if Advanced Smart Workbooks smart Workbook HealthSSs Profits EU Use application defaults Use these settings Ranking r Limit to top 15 FOWE Ranking Currency U S Dollar cF Rebasing Base Year 2009 E Rebase indices M Febase real values Report Defaults O Show Functions In Columna C Show Empty Rows fa mh ra h al my 4 OK J Coa Cancela ciel 7 Most options can be set at either the global or workbook level Note that at the workbook level you can choose to use application defaults or to use settings specific to a workbook Global Preferences and Smart Workbook Settings Explained Tab Option and Description Advanced WNon Refreshable Sheets Do not generate refreshable Excel sheets When exporting smart workbooks to Excel DataInsight Web creates Excel documents that can be updated directly within Excel using Excel s built in External Data capabilities Check this bo
2. Custom Formula Creating Groups Creating a group is the simplest way to put different tree components together Just click on your selections or use the right click context menu to select them name the group and click Save Once saved your customized group will appear in your My criteria marked with a G for easy identification gO MyGroup Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 85 Creating Aggregations To create an aggregation under concept geography or industry 1 Select Aggregation as the type find your selections in the tree select your aggregation method name your concept and click Save g3 WIS Speta Industry Aggregates T Al Sectors Total A 0 C Al Private Non Agriquitural C P exc L All Goods Sectors A D WH gh Technotogy Goods 02423 030 032 0335 0353 lv Medium Technology Goods D24x23 D29 031 034 0352 0359 T All Service Sectors oF All Private Service Sectors G P exd L High Technology Services 1642 65 166 J67 K71 K72 K73 M N Consumer Oriented Industries D15 016 018 019 0221 02691 0323 0333 036 650 652 H M N 092 P Tourism amp Leisure H 092 0369 Aggregation Method AVG Custom Formula 2 Your custom criteria aggregation will be available under the My node for subsequent sessions of the smart datagroup It will be marked with an A for easy identi
3. Climate Percent Change Year Ago Moving Average PEAY ACMOY AY Climate Percent Change Annualized CAGE Matural Log LO Convert Daily to Weekday Convert ta Compound Annual Growth F Replace selection xo Fu n Add Series Function Definitions Percent Change Percent Change Year Ago PCH x Percent change of x lag 1 x x 1 1 100 Climate Climate A Vv Columns Settings The change in data from one period to another expressed as a percentage of its value in the first of the two periods The percentage change in data from a year ago PCHY A x Applying Functions to Data Function Definitions Datalnsight Web User Guide 34 Percent Change Year Ago Moving Average Percent Change Annualized Natural Log Convert Daily to Weekday Convert to Annual percent change of x x x p 1 100 p is the number of periods in each year The percent change of a moving average is a method for smoothing data by averaging a fixed number of consecutive years and then calculating the percentage change of the data from the previous year over year moving average PCHYA MOVAVG n x Percent change year ago of the moving average of x lag n The smoothed year over year growth rate of a value over a specified period of time CAGR Compound annual growth rate of x lag 1 x x 1 p 1 100 p is the number of periods in each year Returns the natural logarithm of X using
4. Workbook Aruba RC Billing Code optional 4507111 Users that share this workbook with you will see your billing code on its Advanced tab for workbook settings Workbook Settings Advanced VVYorkbook Copy of Aruba RC Use application detauts Use these settings 4507111 Scenario 2 You assign a billing code to all your workbooks as a default using global preferences and the billing code appears on the Advanced tab T Log out Feedback F Help Global Preferences Advanced Biling Code optional 4507111 When you share this workbook other users will see nothing in the Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 50 Billing Code field when they look at the workbook settings Columns Workbook Settings Advanced Workbook Copy of Aruba RC1 Use application defauts Use these settings Billing Code optional Rows per Rows per page page Dio not lirnit Select the number of rows from 10 to unlimited which will be returned by search Note that search results are limited to 1 000 series and DataInsight Web will display an alert to indicate how many results it finds hore than 10000 matches Showing 1000 results Sharing Look fe a M Look for shared items Shared Select to see your colleagues shared tems Items When you select the check box in this pane shared items appear as branches under the nam
5. AUG 2004 SEP 2004 OCT 2004 NOW 2004 DEC 2004 WEFA BANK NAME S SERIESTYPE START DATE END DATE LAST UPDATE m Displays the table in a new window without the browser menu or toolbars Values Across New Window When available will group or ungroup the data values on the Do not group Data Table tab Viewing Data Option Icons for the Series List and the Data Table Views Datalnsight Web User Guide 20 Sharing Items The Sharing options under Global Preferences allow you to share your saved Items with your colleagues Sharing workbooks is only possible if your global preferences are set correctly T Log out Q Feedback P Help Global Preferentes a a Export Format Date Range Advanced Smart Workbooks W Look for shared tems Select to see your colleagues shared tems Sharing is OW Sharing is on our colleagues can see your shared tems TURN OFF SHARING s j G OK i Cancel f Help Look for Shared Items r Look for shared tems Select to see your colleagues shared tems When you select the check box in this pane shared items appear as branches under the names of your colleagues at the bottom of the navigation pane You can view shared items even if you have your own sharing off F SHARED TEMS E Drzazgow ski Wojciech P 2 Grzywinski Kamil a Ba Jachas Dominik a Ld Klingenberg Adam al 4 Pajak Wojtek Y Radzimski Roland T WORKBOOKS iat governm
6. Bank Category Description MEURQEUROSTAT International Economic Historical Ra i ACPERM US Regional Historical Annual County Building Perm Ie ADOT International Economic Historical IMF Annual Direction of Trade AGGS ESTAT International Economic Historical Eurostat s Annual Matianal 4 AGPRICE Industry Forecast Monthly updated aqricuttural AGR Industry Historical US Agriculture AKFOR US Regional Forecast by State US Regional Short Term Fore AKFORLT US Regional Forecast by State US Regional Long Term Fore ALFOR US Regional Forecast by State US Regional Short Term Fore Page q lotia H j Category Search Use category search to find series based on specific criteria such country industry concept brand or vehicle type Datalnsight Web Datagroups Related series are grouped into datagroups Smart datagroups or categories such as U S Regional Global Economy and Financial Markets The actual categories available to you will depend on your specific IHS Global Insight subscription Finding and Selecting Data Category Search Datalnsight Web User Guide Building a Category Search by Criteria Selection is Datalnsight Web J Logout fPreferences Feedback P Help APPLICATIONS Availabe Criteria Selected Criteria FORECAST Ceography Geography F T HETORCAL e Concept 2 Ci AnP Frequency Q Keyword Search Y Source fe Afghanistan Global Economy a ff Global Regions Concept OL Financial Marke
7. British Pound t Indian Rupee R2 E Japanese Yen 4 Chinese Yuan JD Swiss Franc Fri Local CUFFENCY Type Select whether you want to group your output in your report by dimension or rank your output by data Layout Select how you want your report preview format to look either tab stacked or side by side See Preview Display Layouts for more information Selected Criteria Select whether you want your selected criteria to be hierarchical or flat A Flat selection is often useful for sorting the resulting data Hierarchical Pe s Hierarchical Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide Selected Criteria Concept J Revenue Value Added Prices Employment Average Hourly Earnings Costs Profit amp Productivity M Revenue Nominal Jv Revenue Real Productivity Industry B NAICS Industry Classification for RR NR etc a M 23 Total Construction Jv 2332 Residential Construction Nonresidential Construction 230 Heavy Construction Public selected Criteria Concept Iv Revenue Nominal fv Revenue Real I Productivity Industry M 23 Total Construction M 2332 Residential Construction Iv 2333 Nonresidential Construction M 230 Heavy Construction Public Frequency Visualization Select whether you want your frequencies to display as mixed or separate Example of Mixed Frequency Visualization Teltecommunit
8. DRINTL INTLINE GLOBAL 2007 04 2007 O4 INQBCWESNS TA O IFO WORLD ECONOM 3 Concept Business Climate 8 Items DRIINTL INTLINE GLOBAL 2007 O4 2007 O4 NOBCWESNS OC Q IFO WORLD ECONOM DRIINTLINTLINE GLOBAL 200704 2007 O4 INQBCWESNS iIN O IFO WORLD ECONOM DRINTL INTLINE GLOBAL 2007 O4 2007 O4 JBCWESNS AA G IFO WORLD ECONOM DRIINTL INTLINE GLOBAL 2007 04 2007 O4 INQBCWESNS HK O IFO WORLD ECONOM DRUINTL INTLINE GLOBAL 2007 04 2007 O4 INQBCWESNS S1 0 IFO WORLD ECONOMI DRIINTL INTLINE GLOBAL 2007 Q4 2007 O4 INQECWESNS AA 0 IFO WORLD ECONOM DRUINTL INTLINE GLOBAL 2007 O04 2007 O4 JBCWESNS WE O IFO WORLD ECONOM DRINTL INTLINE GLOBAL 200704 2007 O4 INQBCWESNS NA O IFO WORLD ECONOM 3 Concept Economic Situation at Present 2 Items DRINTL INTLINE GLOBAL 2007 Q4 a a Page 4 of 1 x Excel Export Values Down New Window 2007 Q4 INQORWESNS TH a Group by CONCEPT ag IFO WORLD ECONOM a d A Vv Columns Settings Once displayed the series in the table can be grouped by using the drop down list at the bottom of the page as shown Saving Data Working with Series in a Workbook Datalnsight Web User Guide 29 Working with Series in a Workbook You can copy and delete series in a workbook via a right click context menu or by drag and drop for copying and by using your Delete key for removal You must use the context menu to move series from one workbook to another You can also add series to a workbook manually by using
9. M MN Health amp Socal Services Word Industry Service Sem Available Criteria Concent Geography Industry J My Industries SJ Industry from ISIC Rev 3 Preview Geography Curren 2004 2005 2006 2007 B Concept Operating Profits Gross Nominal 19 Items 20926 222458 23077797 269656 20154 213921 22188384 259230 2106 77 2323 40 253 20 6965 59 73 799 7710 15 1857 47 1937 09 45332 70 48946 55 67179 52 70143 19 3440 08 3561 03 1895 04 1638 05 26539 10 26605 24 Netherlands 12570 63 12548 86 13025 70 95492 Portugal 2468 13 2827 45 18288166 M372 Spain milion 9716 43 10189 37_ 10366 02 aj i N Health amp Social Services Western Europe million European Union million 4 Austria million Selected Criteria 3 Concept A Investments and Profits a Profits M Operating Profits Gross Nominal I Operating Profits Gross Real 3 Geography a C world 75 gM Western Europe 17 a European Union 15 a C European Monetary Union 12 IM austria I Belgium M Finland Belgium million Finland 1726 29 4530391 64092 63 2090 52 1809 62 million France million Germany million Greece million ireland million Ttaly million 24276 26 million million Using Smart Datagroups Previewing Smart Datagroup Layouts Datalnsight Web User Guide 64 Smart Datagroup Options Smart datagroup featu
10. naming and saving the workbook File Download Do you want to open or save this file z 1 Name MiscCosts9 2009 2009 10 08 xls L Type Microsoft Excel Worksheet 16 0KB From divw4 ihsglobalinsight com Open N Save While files from the Internet can be useful some files can potentially harm Your computer IF vou do not trust the source do not open or save this file What s the risk Depending on your browser configuration you may be prompted to open or save the Excel document Export All Exports all series of the open workbook to Excel and opens Excel when you choose the Open button If you choose the Save button you will be asked to select the location for naming and saving the workbook File Download Do you want to open or save this file 2 Name GDP_ 009 10 08 xls JH Type Microsoft Excel Worksheet 16 0K6 From diw ihisglobalinsight com Open N Save While files from the Internet can be useful some tles can potentially harm your computer IF you do not trust the source do not open or save this file What s the nek Viewing Data Option Icons for the Series List and the Data Table Views Datalnsight Web User Guide fx Functions ABC Add Series Data Table x Excel Export Values Down 18 Allows you to apply functions to selected time series and to replace the line item or add an additional line to the table containing the function See Applying Func
11. 7 Save the Read Only copy under a different workbook name and it will be editable Note If you delete rows or columns of data after exporting your data to Excel these will reappear after you refresh Using the Smart Datagroup Report Wizards The report wizard walks you through the process of creating a report for a Smart Datagroup and since the selections offered within each wizard are specific to that datagroup using this tool makes report generating both efficient and simple for you Additionally you can export your report to Excel or save your report as a smart workbook where data is automatically refreshed as new data become available Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide 95 Smart Datagroup FAQs Below you will find a list of many frequently asked questions and answers about Smart Datagroups and Smart Workbooks What is a Smart Datagroup How do I set Default Settings for my Smart Workbooks How do I create my own Custom Geography Concept or Industry Can I apply functions to the data in my Smart Datagroup How can I create a report with one Concept in Percent Change PCH and all the concepts in Base Value I ve changed the date range for my report but the new dates are not reflected in the Preview data display table Can I display a report in more than one currency How do I rearrange the order of the rows in my report How do I rearrange the order of the colu
12. GedkNeme Prot a a lt lt lt o a a Cc Long Label o Note Not all the columns listed below are applicable for all data Bank Name s Name of the categorized database associated with the series Benchmark date for the index calculation Manufacturer or trade name Economic or Financial concept definition of the series Series name assigned using the legacy DRI naming convention Moac Last historical data period for forecast data Viewing Data Customizing the Results Data Columns Datalnsight Web User Guide End Date Frequency Geography Industry Classification Last Update Long Label Real Nominal Seasonal Adjustment Series ype Short Label LastUpdate Real Nominal Sale EZE Source Unit LWEFA Mnemonic Key Indicator Product Series Status Source Start Date Unit WEFA Mnemonic Key Indicator Product series Status Under Revision 14 The date of the last observation of time series data Number of time intervals of the time series expressed as Daily through Annual Country or defined region for the time series Representation of a specific industry or sector for the series Date the time series data was last updated with new values and or revisions Detailed description of time series When present indicates whether a time series is real or nominal Valid values are Real Nominal o
13. Row Label Base Period Company Concept Preferences Vv Preferences DatalInsight Web offers many options to customize the way your data will display and export Preference options are available at a global level where defaults can be specified for the entire application as well as at the workbook level where an individual workbook may have its own unique settings See Preferences and Settings for more information Finding and Selecting Data Table Browser Datalnsight Web User Guide Viewing Data 12 After you click Go the results of your category search will appear in the columns in the middle of the page See Keyword Search for information about keyword searching Search example gdp and russia or japan gt Advanced More than 10000 matches Showing results 1 25 of 1000 an Statistical Discrepancy Expenditure Apyj United Kingdom QUARTERLY Gross Domestic Product per Capita Georgia Gross Domestic Product per Capita Georgia Government Consumption Macedonia Imports of Goods and Services Macedonia Exports of Goods and Services Macedonia Gross Domestic Product per Capita Georgia Gross Domestic Product per Capita Georgia Gross Capital Formation Bulgaria Current Account Balance as of Nomi Nigeria Fiscal Balance as a Percentage of GDP Egypt Tax Revenue Tunisia a G x Save Selected Save All Export Selected Export All QUARTERLY QUARTERLY QUARTERLY QUARTERLY QUARTERLY ANNUAL ANNUAL QUA
14. The Purchasing Analyzer provides fast access to select industry concepts and allows you to breakout industry input costs start Date Range Select industries Statistics Purchasing Analyzer Purchasing Analyzer provides fast access to select industry concepts and allows you to breakout industry input costs Ready to get started Previous J Puretosirngy Arnatyser Salad Gores ee Ialoried Seledri ihh ob kriisi Heed a _ ireng Products fe timine pejla Fuel Cs okin Hap D Seo Megane Diery mE C Liht Fuel s Cbig Ott amp eapi 8 Cron end Stet E Bectrores Compren A TT ran aed Sied Purchasing Analyzer Using Purchasing Analyzer Datalnsight Web User Guide 59 Using Purchasing Analyzer Here is an overview of the steps that you will find in the Purchasing Analyzer wizard 1 Give the date range and frequency of the time series data Purchasing Analyzer Date Range Date Range Select the date range 10 years history before today 10 years forecast atter today Frequency ANAUAL f QUARTERLY 2 Find an industry by entering an industry keyword or by moving down the branches and nodes of the data tree directly and select it Purchasing Analyzer Select Industries Select Industries Industry Keyword E Energy Products Iron and Steel Nonferrous Metal Products 7 Fabricated Metal Products To Chemicals and Allied Products l Build
15. area use the View gt Toolbars gt External Data menu options Horrrial L Page Break Preview Task Pane Ctri F 1 Formula Bar Formatting status Bar External Data K Customize Accessing the Refresh All Feature in Excel 2007 To refresh the smart workbook data in Excel 2007 use the Refresh Al option on the Data tab Aam aL Al Z AnA O O OS E Yo 2 EEE Ciad J _ Home Insert Page Layout Formulas Data gt From Access Eaj Connections From Web h Properties i From Othe Existing Refresh i om Text Sources Connections All Hi Shee sol Get External Data Connections Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide 92 Refreshing the Data in Excel 2003 and 2007 To refresh the data in a smart workbook in Excel 1 Ze 3 After making modifications or opening a previously saved smart workbook click the Refresh button on the External Data toolbar in Excel 2003 or click on Refresh All on the Data tab in Excel 2007 to pull in the latest data OR Formulas Data h P l Connections L Fi Pefresh Dat A Properties Refresh Data ar ail 5 Edit Links connections For Excel 2007 only When you export a Workbook to Excel 2007 you will see a Security Warning alert Click Options click Enable this content and then click OK Security Warning Data connections have been disabled Al
16. 53 Using Cost Analyzer Here is an overview of the steps that you will find in the Cost Analyzer wizard 1 Give the date range and frequency of the time series data Cost Analyzer Date Range Date Range Select the date range for your workbook below 10 years history before today 10 years forecast after today Frequency fe GUARTERLY C ANNUAL f FISCAL YEAR ez 2 Select series by entering a commodity group keyword and or a mnemonic or by selecting the branches and nodes of the data tree directly Cost Analyzer Select Series Select Series Commodity group keyword Mnemonic search ener By Industry By Geography C Display mnemonics 3 D Nonelectrical Machinery a Japan Japan Corp Goods Price Index General Mach and Equip Japan Corp Goods Price Index General Mach and Equip S United States J United States PPI General Industrial Machinery and Equipment United States PPI Turbines and Turbine Generator Sets 3 Electrical Machinery 3 Canada i Canada PPI Electric Motors and Generators Source Statistics Canada Global Insig France France PPI CPF 27 11 Motors Generators and Transformers Price Ex vvorks a tay 3 Select any percent change type statistics that you want to have applied to the selected series and how you want the output grouped Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide Cost Analyzer Statistics S
17. Business Climate Tl Copy of Business Climate 3 Business Climate 1 Allows you to share a workbook with your entire work group and displays a shared workbook icon in front of it g Business Climate To remove sharing right click the workbook again and select Stop sharing this item TA Business Climate Delete Copy Rename hove Stop sharing this tem Export View Data Table Saving Data Using the Context Menu for Workbooks Datalnsight Web User Guide 28 Export View Data Table Depending on your browser configuration you may be prompted to open or save the Excel document File Download Do you want to open or save this file Name SE Asia Sales Territory 2009 10 06 xls Type Microsoft Excel Worksheet 16 0KB From div ihsglobalinsight com Open Save J While files from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or kz save this file What s the risk Note When you click Save a Save as dialog box will appear for you to save your workbook to your system Displays the Data Table page with the series data in it Alternately you can click on the Data Table tab in the workbook to see the table Business Climate 12 Series Data Table 01 Aug 2011 EE Composite Index Today Bank Name s Data Edge End Date Last Update Mnemonic Shor Label 3 Concept All Industries 1 Item
18. D Manufacturing aM 015 Food amp Beverages z 021 Paper amp Pulp aM B24 Chemicals Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 80 The Context Menu The right click context menu offers quick ways of working with the selection tree Word Industry Service Available Criteria Concept a My Concepts 3 Domestic Consumption amp External Trade gt Apparent Consumption Check Apparent Consumption z Apparent Consu M Apparent Consu Check all next level Exports Exports of Indust I Exports of Indust Expand all 3 Imports Collapse all E Imports of Industh Imports of Industry Product Real Geography Industry Uncheck all next level Selected Criteria Concept 3 Domestic Consumption amp External Trade 3 Apparent Consumption Iw Apparent Consumption Nominal z Apparent Consumption Real Checking and un checking all next level options require you to highlight a parent node first and then click on the appropriate menu option You can see how this works in the example above As the system selects the sub nodes for you those selections appear in the Selected Criteria area automatically Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 81 Expanding and collapsing the various branches of the tree are also highlight and select processes Word Industry Service Available Criteria Preview Concept i My Con
19. M134RCBCGD M M134RCBCGKE M m Business Climate Ge 1 2 2 untitled workbook 2 3 Y Tables 4 MI34RCBCWALM 5 a Fiii Germany Eiji taty M134RCBCWU M M 134RCEBCGECDUA M Saving Data Working with Series in a Workbook Datalnsight Web User Guide Applying Functions to Data You can apply a function to a time series and either replace the time series or add a line with the function underneath the target series To apply a function to a series 1 Select one series in the Series List by clicking on it or to select multiple adjacent series use Shift click or to select multiple non adjacent series use Ctrl click Business Climate Composite Index cow m in e ow N SS Ea Mnemonic INQEBCWESNS oOc O INQBCWESNS inN Q INQBCWESNS TA 0 INQORWESNS TH O JBCWESNS AA4 0 JORWESNS AA O NQOAWESNS AA Q INQBCWESNS HK O INQECWESNS S1 0 INQ BCWESNS A4 0 JBCWESNS WE O INQBCWESNS N4 0 Page 4 of 1 x Export Selected Export All 12 Series Series List Data Table Bank Name s DRINTL INTLINE GLOBAL DRIINTL INTLINE GLOBAL DRIINTL INTLINE GLOBAL DRIINTL INTLINE GLOBAL DRIINTL INTLINE GLOBAL DRIINTL INTLINE GLOBAL OBUNT INT 1 OFA Percent Change PCH Percent Change Year Ago PCHY A 01 Aug 2011 Fa Today Concept Business Climate Business Climate All Industries Economic Situation at Presen Business Climate Economic Situation at Presen Foonomic Situation over Nex Climate
20. NOSGGRN NOSGSWN NOSGDEN NOSGNONM NOSGPGN NOSGAUN NOSGUKNM NOSGFNM NOSGSPN NOSGFRA NOSGWEN NOSGES5N NOSGEUN NOSGBEN 915 97 2090 52 2290 47 2413 93 3015 16 2468 15 2106 77 23392 35 1726 29 9716 43 45303 91 20926 1 36 201546 58 17349 83 56965 58 68 4954 3 03 405910 42 493176 71 Operating Profits Gross Nominal Operating Profits Gross Real Regular Ranking Rank a r j Geographie Start Date 2004 By Industry s Ranking EndDate 2014 Criteria Select functions to be applied to that data for all rows of output Select End Date to display the data values without a function applied Function Definitions End Date Diff Percent Change The last data point of your end year The difference between comparison values Diff x Simple difference X x The change in data from one period to another expressed as a percentage of its value in the first of the two periods Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 69 PCH x Percent change of x lag 1 x x 1 1 100 Compound Annual The smoothed year over year growth rate of a value Growth Rate over a specified period of years CAGR x Compound annual growth rate of x lag 1 x x 1 p 1 100 p is the number of periods in each year ere Select the time span by year for your data End Date 1990 1997 1998 1999 2000 2001 20
21. S Department of the Treasury Procurement U S Department of the Treasury Miltary Personnel U S Department of the Treasury Environmental Protection Agency U S Department of the Treasury Agriculture U S Department of the Treasury Note Click on Go to refresh the mnemonics if you change the display preference of series already appearing in the results list Only the merged series will display differently as in the examples above Do not generate refreshable Excel sheets When exporting a workbook DataInsight Web creates Excel documents that can be updated directly within Excel using Excel s Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 49 Billing code built in External Data toolbar Check this box to disable this feature See Exporting Data to Excel for more information Billing Code optional An optional billing code which is recorded during your data usage and can be used to track data usage for billing purposes for those users that accrue data usage related charges Note about Billing Codes and Sharing The billing code comes from the source workbook when the source workbook has a workbook level billing code specified using the button at the bottom of the screen Examples Scenario I You set the billing code at the workbook level and the billing code appears on the Advanced tab for workbook settings Workbook Settings Advanced
22. User Guide 36 Compound Lagged 1 period Annual Percent Change PCH Growth Percent Change Year Ago PCHYA Lagged n Lagged 2 periods Lagged 3 periods Percent Change Year Ago Moving Average PCHYA MOVAVG periods Lagged 4 periods Percent Change Annualized CAGR Lagged 5 periods Natural Log LOG Lagged 6 periods Convert Daily to Weekday Lagged 7 periods Convert to Lagged amp periods Compound Annual Growth Lagged 9 periods E Replace selelection Lagged 10 periods Lagged 11 periods fx gg p Functions Lagged 12 periods CAGR n x Compound annual growth rate of x lag n x x n p n 1 100 p is the number of periods in each year 2 Click on the Function button at the bottom of your screen and make your function selection 3 Optional Un select the Replace selection option if you want to see each series you selected repeated with the function applied to it as a separate row Applying Functions to Data Function Definitions Datalnsight Web User Guide 37 Exporting Data to Excel You can export category and keyword search results or the contents of a workbook into a Microsoft Excel spreadsheet to open and work with and or to save on your system for later use Exporting Category Search Results To export category search data or workbook data to Excel 1 Select one series in the Series List by clicking on it or to select multiple adjacent series use Shift click or to select multiple n
23. ihs globalinsight com Excellpdate aspxtid eyJhcihM ae Uy16dHI12SwideNicmShb Ww UidiInaSvhdGgilc0exBlTjo4LCipeCi6nj40Nbes Some Files can contain viruses or otherwise be harmful bo your computer It is important bo be certain that this File is From a trustworthy source Would vou like bo open this File A status screen will appear Opening https www ihs globalinsight corm Excelpdate aspx id eyJhcLhMUyI6 dHI12SwidenicmShb yy UiGiInaSvhdegiLoexBlljo4lC Ip2CI6Nj40NDe9 BERG Cancel 6 Current data will appear in an updated read only copy of your workbook if it has multiple tabs Sh Help2_2010 4 19 13_57_Sixls Read Only E Created on Mon 19 Agr 2010 1 57 PM EDT 18 57 GMT Rank Currency Une industry 2008 2015 Percent Change i 2006 100 M Health and Social Serices IF 2005 100 0 Socal and Personal Sernces a 2005 100 O92 Recreational Cultural and Sporting 4 2006 100 Sanitation Trade Organizations Other Seraces 090 081 O83 TL million WS Dollar M Health and Social Seraces ISS 413 813 51 VOSS 2 million US Dollar Sanitation Trade Organizations Other Serices 090 001 093 85634 19 152 137 36 Pt Sis 3 million US Dollar 0 Social and Personal Seraces 136 910 48 241 290 03 ie 24 5d million US Dollar O92 Recreational Cultural and Sp rmig 21 216 29 69 153 48 4 0 Save the Read Only copy under a different workbook name and it will be editable Note If you delete rows
24. is browser based data navigation and retrieval tool with desktop class performance You can use Datalnsight Web to e Find the data you need e Browse view save and export from a library of service specific pre defined tables e Save your data in workbooks e Share your data with colleagues e View and pivot data on screen e Export data to Excel e Apply Functions to data Additionally powerful applications and smart datagroups are also available for use in DataInsight Web depending on your subscription e Cost Analyzer allows you to tactically analyze a single buy or strategically evaluate an entire supply chain performance to know if your suppliers prices are inflated or not e Purchasing Analyzer provides access to select industry concepts and allows you to break out industry input costs e Smart Datagroups provide access to multi dimensional databases of IHS Global Insight data Documentation and Support For the most up to date information about DataInsight Web and our business in general check our web site www IHS com For telephone support In the United States contact the Client Resource Center at 1 800 933 3374 Outside of the United States please contact your sales representative For email support send your request to CustomerCare ihs com Introduction and Overview Documentation and Support Datalnsight Web User Guide Z Finding and Selecting Data Use keyword and category search to find s
25. is sharing G Copy of Sample workbook G untitled workbook 11 G untitled workbook 12 G Business Climate Bp Saving Data Working with Series in a Workbook Datalnsight Web User Guide 30 Adding Series to Workbooks by Mnemonic DataInsight Web has a feature that lets you add series to a workbook using series mnemonics To add series by mnemonic to a workbook 1 Select a workbook on the left and it will open to display the series contained in it igs Datalnsight Web HISTORICAL Business Climate Germany P SMART DATAGROUPS Composite Index T SAVED TEMS Y gt Workbooks 3 Daily Series Tml Belgium Series Business i Tat untitled workbook hinemonic 1 Mi34RCBCWU M 2 Mi34RCBCGCOUAM 2 MI34RCBCCSUM Series count 16 Y amp Tables 4 M134RCBCMFULM Ff Germany 5 M134RCBCCSAM FTF taty 6 M134RCBCTTULM 2 Click Add Series and a dialog box will open for you to enter the mnemonics of the series to be added to the open workbook Press Enter after typing each series to go to the next line hinemonic Concept 1 MI34ICBCRA M Retail Trade 2 MIS4ICBCTTEA M Manufacturing 3 M13CBCTTUA M Manufacturing 4 M134CBCTTWA M Manufacturing 5 M134RCBCCSA M Construction 6 M134RCBCCSU M Construction T M134RCBCCSUA M Construction e MI3RCBCGECDUA M Consumer Good 9 M13RCBCGD M Durable Consum 10 M134RCBCGKE M Investment Capiti 11 M134RCBCGM M All Industries 12 Mi34RCBCMFULM Manufacturing 13 M134RCB
26. of the most often used commands Mowe Export Share this tem View Data Table Command _ Description Delete Copy Rename Removes the workbook and its contents completely You will receive a confirmation window before removal Alternately you can select the workbook and use your delete key Confirm Delete Delete workbook Business Climate which contains 12 series Yes fim C Cancel Makes a copy and places it at the bottom of the workbook tree G Copy of series Tml Copy of untitled workbook 13 G untitled workbook 11 Tm untitled workbook 12 Tanl Copy of Sample workbook T Copy of Business Climate Displays the name of the selected workbook in an editable field for adjustment Alternately you can change the name in the Workbook Name field within the workbook Saving Data Using the Context Menu for Workbooks Datalnsight Web User Guide 2 Move Share this item Displays the Browse Workbook dialog box with the workbook tree in it To move a workbook s position under another select the workbook that will be immediately above it and then click OK Alternately you can drag and drop the name into the desired position in the tree as shown Browse Workbook Please select destination work boos fighmgtgdggth new G dfhfdgfdg T Copy of untitled workbook 13 xt hgj G Copy of Frankey is sharing G Copy of Sample workbook G untitled workbook 11 G untitled workbook 12 G
27. or columns of data after exporting your data to Excel these will reappear after you refresh Exporting Data to Excel Refreshing a Datalnsight Web Workbook in Excel Datalnsight Web User Guide 43 Preferences and Settings DataInsight Web offers many options to customize the way your data will display and export Preference options are available at a global level where defaults can be specified for the entire application as well as at the workbook level where an individual workbook may have its own unique settings Preferences and Settings Overview Use Preferences to set global defaults for all workbooks v Preferences Global Preferences Export Format Date Range Advanced if sharing Jf Style Preferences Location f Formatted zzz Plain FE Riovy Column ok J cancel Hela Preferences and Settings Preferences and Settings Overview Datalnsight Web User Guide J When you have a workbook selected use Settings to specify settings for Bh that one particular workbook overriding any global default settings for all ERE workbooks Workbook Settings Workbook SE Asia Sales Territory Use application detautts Use these settings Style f Formatted Plain Location Rovy Column CK Cancel p Help Most options can be set at either the global or workbook level 44 Note that at the workbook level you can choose to use app
28. that you can select a tabular display of criteria using the Sheet by list Regular 6 Ranking Preview Currency Unit Industry Mnemonic oS Concept Operating Profits Gross Nominal 1 Item million US Dollar MW Health amp Soci NOSGESN 20 3 Concept Operating Profits Gross Real 1 Item 2005 100 NM Health amp Soci ROSGESN 20 No groups 5 f Concept m A Fj European Union 15 Denmark Sue q Kingdom Regular Group By Concept Sheet By Seograch Industry Select to rank your output by data Note that Regular is the default selection for reports but you can change the default to Ranking using the Smart Workbook Settings tab within Preferences or Settings explained below Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide Preview Rk B Industry N Health amp Social Services 15 Items 1 wo OO sj mW in A W Po Currency Unit million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar milion US Dollar million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar million US Dollar Geography Turkey Greece Sweden Denmark Norway Portugal Austria United Kingdom Finland spain France Western Europe European Union European Monet Belgium Mnemonic NOSGTKN
29. to see available tables 2 When a table is selected a new column appears with information specific to the table This information includes the name of the table a brief description the frequencies that are available for the table and the number of versions available 3 To view the table on screen simply press View Table APPLICATIONS SnapShot sii lable 3 Gross Domestic Pro rs af Administration National Accounts Fi Table 1 Real Gross Domestic Pr Employment i l Cost Analyzer Prices 5 Purchasing Analyzer Industrial Production Table 3 Gross Domestic i smart Report Wizard hemaii lead ad alae of Pa Product aml ee eo he H Smart Ranking Wizard iain guido aS SS Table Browser 4 FORECAST HISTORICAL Row Label 2006 Q3 2006 04 2007 O14 2007 O2 20 b SMART DATAGROUPS Gross domestic product 12 950 40 1303640 13056 10 13173 60 132 E SAVED TEMS onal Come j necitny Ta oe n EH o 2na gt a 5 Ep h SHARED TEMS Personal consumption expenditures 9 073 89 9 156 31 9 209 21 9244 z Durable goods 1 178 98 1195 21 1 210 07 1 227 05 E Motor vehicles and parts 398 17 397 27 399 44 405 14 AL Furniture and household equipment 2f2 11 271 93 274 98 272 81 i Other 151 54 153 33 154 93 156 94 1 Nondurable goods 2 005 92 2 031 67 2 038 21 2 037 50 Zt Food 662 97 672 13 673 22 669 53 Gi Clothing and shoes 329 16 334 04 335 17 330 04 J Fage alofa b FI a v Export Save Hide Table Today Date Columns Prefe
30. trust the source do not open or i h ter If do not trust th do not i save this file What s the risk Hide Show Table Hide table Show table This option alternately hides and shows the current table on your screen Note Hiding the table will give you more space to view the library of available tables Finding and Selecting Data Table Browser Datalnsight Web User Guide 9 Date history before today forecast after today Select the date range in a number of years quarters months or observations in the past and in the future Note This selects the date range relative to TODAY it does not determine the data edge of individual series Custom OStart Date x Custom Start Date f First available value 20 observations before today 0 O 20 observations up to end date r Fixed date 25 Sep 2009 First available value Select to export time series data beginning with the first observation of the data that exists in our database Number of values before Enter the number of observations years quarters or months to or after today export starting with today and going back into time for historical data or ahead into the future for forecast data Number of values up to Enter the number of observations years quarters or months to end date export going back into time from the end date you specify in the following section Fixed Date Enter an end date or select it by clickin
31. workbook 11 Bank Name s DataEdge EndDate LastUpdate Mnemonic Short Label untitled workbook 12 de yan cl 3 Concept All Industries 1 Item Composite Index DRUNTL INTLINE GLOBAL 200704 2007 O4 INQBCWESNS TA 0 IFO WORLD ECONOMIC SUR oS Coagept Business Climate 8 Items DRIINTL INTL GLOBAL e007 04 2007 O4 INQECWESNS 0Cc Q IFO WORLD ECONOMIC SUR DRINTL INTLINE GLOP 200704 2007 Q4 INQBCWESNS iN O IFO WORLD ECONOMIC SUR DRIINTL INTLINE GLOBAL 200704 2007 Q4 JBCWESNS A4 0 IFO WORLD ECONOMIC SUR DRIINTL INTLINE GLOBAL 200704 2007 O4 INQECWESNS HK Q IFO WORLD ECONOMIC SUR DRUNTL INTLINE GLOBAL 20U0MQ4 2007 Q4 INQBCWESNS S1 0 IFO WORLD ECONOMIC SUR DRIINTL INTLINE GLOBAL 2007 Q4 al 24 INQBCWESNS A4 Q IFO WORLD ECONOMIC SUR DRIINTL INTLINE GLOBAL 200704 2007 Q4 JBCWESNS WE Q IFO WORLD ECONOMIC SUR DRIINTL INTLINE GLOBAL 2007 04 2007 O4 BECWESNS NAO IFOWORLD ECONOMIC SUR gt 3 Concept Economic Situation at Present 2 Items 4 DRIINTLINTLINE GLOBAL 2007 Q04 2007 Q4 INQORWESNS TH W IFO WORLD ECONOMIC m 4 Page 4 oT 1 F x Group by CONCEPT EE X m ga A Excel Export Values Down New Window Columns These settings will remain in the workbook until you change them See_Preferences and Settings for more information Saving Data Using the Context Menu for Workbooks Datalnsight Web User Guide 26 Using the Context Menu for Workbooks Right click on a workbook in the Workbooks tree to display a context menu
32. 02 2003 2004 x Start Date 7004 i 70414 End Date Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 70 Smart Workbook Preferences and Settings DataInsight Web offers many options to customize the way your data will display and export Preference options are available at a global level where defaults can be specified for the entire application as well as at the workbook level where an individual workbook may have its own unique settings Subscribers to smart datagroups like WIS have special preference options applicable to smart workbooks that they create to work with smart datagroup data See Preferences and Settings for information about the other tab options available to all DataInsight Web users Use Preferences to set global defaults for all smart workbooks wv Preferences Global Preferences ES Fenaaa a T a E a a k OR Export Format Date Range Advanced Smart Workbooks Sharing ae vi Ranking Limit to top ane Preferences E Ranking Currency U S Dollar cF w Ranking Criteria CAGR Rebasing Base ear 2009 ka E Febaze indices W Rebase real values Report Defaults Type Regular Ranking Lael cm cS ep Selected Criteria Hierarchical Flat Frequency Mixed Separate visualization start 004 oF End A014 F O Show Functions In Columns O Show Empty Rows Output Currency I U S Dollar Brazilian Real R T Euro
33. 1 B32 Formatting Options You will find the formatting options by clicking Preferences or Settings and then going to 90 the Format tab there See Preferences and Settings for information about the Format tab Format Date Range Smart Workbooks Orientation Across 12 3 Down 2 3 Decimal Places 2 Display dates as Start of period w Highlight forecasts ooo YS Note that forecasted data can be highlighted for easy recognition Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide 91 Smart Workbook Options These powerful options for smart workbooks are only be available for subscribers to Smart Datagroups See Smart Workbook Preferences and Settings for information about them Refreshing a Smart Workbook in Excel You can update your Smart Workbook in Excel 2003 using External Data toolbar and in Excel 2007 using the Data tab If your Smart Workbook contains one sheet your data will be refreshed within that workbook If your Smart Workbook contains multiple sheets the data will be refreshed in a new read only workbook which you can save under a different name to be able to modify it For more information see the Generating Smart Datagroup Reports section of this guide Accessing the External Data toolbar in Excel 2003 To display the External Data toolbar in Excel 2003 if it does not appear in the Excel toolbar
34. 100 p is the number of periods in each year Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 66 Allows you to open or save your data in an Excel workbook The preview indicates how the worksheet will look File Download l x Do you want to open or save this file Name Word Industry Service 009 09 11 xls HHL Type Microsoft Excel Worksheet 45 0KB Open Save h While files from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file What s the nek Use the Refresh icon to pull the latest data into your smart datagroup when 2 the preview panel displays the need for it or you see an asterisk notation after Refresh Preview O R Preview Preview Allows you to save your current selections in a new or existing smart workbook and to create a new folder for it when desired Browse Saved Smart Workbooks Please Select destination folder Y gt Smart Workbooks 4 Ge Healthcare iat Healthcare Forecast CF jhage Noa VIS ta Copy of save from SRA 1 4 ealthSS_EL Em Mewe folder Note A quick way to save your selections on the fly is to create a smart Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 67 workbook and keep it selected before you make your selections Select whether you want to group your output in your report by criteria Note
35. 2 Items 452020 Compu MyFormulai million US Dollar 452010 Comm MyFormulal million US Dollar 3 Concept Operating Profits Gross Real 2 Items 452020 Compu MyFormulal 2000 100 452010 Comm MyFormulal 2000 100 If you create your formula like this Hungary Czech Republic Hungary Poland Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 89 This will appear in your preview son Industry Geography Currency Unit J Concept Operating Profits Gross Nominal 2 Items 452020 Compu MyFormula million US Dollar 452010 Comm MyFormula million US Dollar 452020 Compu MyFormula2 2000 100 452010 Comm MyFormula2 2000 100 Generating Smart Datagroup Reports x o Once your select your smart datagroup criteria use Export to open a smart workbook in Excel You can also refresh your data from within Excel unless you have set your Preferences or Settings to create non refreshable workbooks on the Advanced tab Table in DataInsight Web Preview Geography Curren 2004 2005 2006 Portugal muon 408 13 Spain milion 9716 43 10189 37 10366 02 Denmark milion 2413 93 2483 62 1831 50 3543 7 Sweden milion 2290 47 2426 82 2629 53 3051 20 3425 19 3426 88 United Kingdom milion 23392 35 25956 43 2719502 3132407 3136217 2896110 Norway milion 3015 16 3513 87 3761 33 540 26 5497 91
36. 3 Global Preferentes Advanced Billing Code optional 4507111 When you share this workbook other users will see nothing in the Billing Code field when they look at the workbook settings Workbook Settings Advanced Workbook Copy of Aruba RO Use application defaults Use these settings Billing Code optional Smart Ranking Workbooks Ranking E Limit ta top 15 wo Fos Ranking Currency U S Dollar F Ranking Criteria CAGR Select to limit ranking to the top five through twenty five rows of your table or leave unchecked to rank all the values without limits Select ranking currency and criteria using drop down lists Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 74 Function Definitions for Ranking Criteria End Date The last data point of your end year Diff The simple difference between comparison values Diff end value start value Percent Change The change in data from one period to another expressed as a percentage of its value in the first of the two periods PCH x Percent change of x lag 1 x x 1 1 100 Compound Annual The smoothed year over year growth rate of a value over a Growth Rate specified period of years CAGR x Compound annual growth rate of x lag 1 x x 1 p 1 100 p is the number of periods in each year Note Ranking functions are not evaluated on the values lagged by 1 period Ranking always displays only two perio
37. 4483 20 ie Switzerland million 4106 72 4262 92 4366 99 4981 47 5988 43 6235 20 Turkey milion 915 97 1203 39 1219 73 1632 20 2073 98 2004 60 Concept Operating Profits Gross Real 6 Items Western Europe 2005 21574 220456 22135572 232329 64 23860 246607 15 European Union 2005 20575 215921 215034 61 223675 48 22962 237418 66 Austria 2005 2123 85 2323 40 2462 34 2407 22 2561 19 2747 59 Belgium 2005 714L37 7377 99 7576 658 7346 56 7978 99 a005 29 2005 1798 52 1657 47 1915 89 2029 94 2025 99 2134 92 a MAAS Page fi ofz OD N Health amp Social Services Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide Smart Workbook in Excel A E F E E F i 2 e GLOBAL Tiss Nsicht UVatalnsight Web z 6 Created on Fri 11 Sep 2009 12 27 Phi EST 17 27 GMT 7 5 Geography Currency Unit 2004 2005 2006 2007 10 Operating Profits Gross Hominal A ee 11 Western Europe 17 12 European Union 15 million US Dollar 201 546 213 921 37 221 353 a4 259 330 37 13 Austria million US Dollar 2106 77 2325 40 2534 20 26 14 milion US Dollar 6 965 z 73r 8 7710 13 15 F 16 F 56 993 07 Vv 50 1354 18 165 82 13 2 430 8 a 1 345 21 16 49 23 12 0 24 D 13 74 2 sneer us Dor 2 0472 2 62953 30512 ot 31 324 07 oF S 29 Turkey million US Dollar D 5 7 1 203 a 1 z J
38. 5 1s Average Price of Imported Crude Oil Received by Refineries S barrel 2 Average Price of Imported Crude Oil Received by Refineries PCHYA S barrel QUARTERLY 19740101 2017 10 01 2007 03 13 3 West Texas Intermediate Crude Oil Spot Price S barrel QUARTERLY 1983 01 01 2017 10 01 2007 05 15 4 West Texas Intermediate Crude Oil Spot Price PCHYA S barrel QUARTERLY 1983 01 01 2017 10 01 2007 03 13 Information Start Date Jan 1963 a End Date Mow 2007 Last Update 2007 12 28 Frequency MCOMTALY DRI Series Name UHNSLO M WEFA Series Name UHNSLO M Lv At the bottom left of your screen there is a dual purpose panel for displaying a graph or information for one or more series that you select in the results area Displays a graph of the selected series you can choose up to 5 series for your graph Information Displays time series information for the most recent time series you have selected To graph series 1 Select a series by clicking on it Use Shift click or Ctrl click to select multiple series 2 Each series up to 5 will appear as a different line color in the chart Information Viewing Data Switching from the Series List to a Data Table On screen Datalnsight Web User Guide 16 Switching from the Series List to a Data Table On screen Saved Items Y G Workbooks GDP copy i Delete CODY wa G Copy o py Rename G DG My G MiscCo JF Tables Export a View Data Table chart T e
39. 6716 00 49459943 00 Alabama 37656400 00 38193461 00 Alabama 23794431 00 24233038 00 Alabama 9531354 00 9312566 00 Notes on Frequency Selection When there are multiple frequencies selected DataInsight Web works like this Examples A Q M frequencies are selected Selected time 2000M2 2001M2 M Annual Iw Quarterly Start 2000 bw M2 M tonthly End 2001 hiz Periods selected 2000M2 2000M3 2000Q2 2000M4 2000M5 2000M6 2000Q3 2000M7 2000M8 2000M9 2000Q4 2000M10 2000M11 2000M12 2001 2001Q1 2001M1 2001M2 Selected time 2000M10 2001M1 IM Annual M Quarterly Start 2000 M10 M Monthly End 2004 htt Periods selected 2000Q4 2000M10 2000M11 2000M12 2001 2000Q1 2000M1 Selected time 2000M1 m Annual M Quarterly Start Z000 Lw hli m Monthy Ena 2O14 e hii Periods selected 2000 2000Q1 2000M1 2000M2 Therefore if the selected period is also a beginning of the less frequent period that period will also get selected e g 2000Q1 will also include 2000 2000M4 will also include 2000Q2 when 2000M1 includes Q1 and 2000 as a whole This only behaves like this if the less frequent period is available and you select it Start Date End Date Select the time span by year for your data Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 79 Show Functions in Columns E show Functions In Columns Toggle to show and hide functions
40. All Export Selected Export All m Select either the Export Selected or Export All option Note when selecting Export All it is not necessary to make series selections first Exporting Data to Excel Exporting Category Search Results Datalnsight Web User Guide 38 3 Depending on your browser configuration you may be prompted to open or save the Excel document Mame Workbook 2011 09 06 xls Type Microsoft Office Excel 97 2003 Worksheet From diw qa gii q cam wen sae _ eas r i While files from the Internet can be useful some files can potentially harm your computer IF pou do not trust the source do not open or save this file What s the risk If you select Open Excel will display a preformatted table that you can adjust using Excel functionality and then print or save Ef Workbook_2011 09 06 1 xls Compatibility Mode Ooz 3 oa 4 Created on Tue 6 Sep 2011 5 18 PM EDT 22 18 GMT 5 6 F ret Ae es Ere Short Label 8 Urban Wage Earners and Clerical Workers United States CPIWR US M CONSUMER PRICE INDEX 1995GII ALL ITEMS WAGE EARNERS SA U United States CONSUMER PRICE INDEX 1982 84 ALL ITEMS WAGE EARNERS NSA United States CPIW US M CONSUMER PRICE INDEX 1982 84 ALL ITEMS WAGE EARNERS SA L United States Dec 2007 M111PSTTR1 M CONSUMER PRICE INDEX URBAN WAGE EARNERS AND CLERICAL WORKERS If you select Save a Save As dialog box appears for you to
41. E R E ET ETE 81 Addins a Custom Criterion 10 the TEE iiien a A E E AE E E a 82 Modityine ot Deleting a Custom C tena Selecione E ie mame 83 Defining Groups or Aggregates and Applying Formulas cccccccccccsseeccccceeee nnn eeeseeeeeeeeaaeeeeeeeeeeeaaaaeeeseeseeeaaaaees 84 Creatine LOUPS tiii a eh cial T E ait EAEE E E EEEE 84 Caa A COTCOAIONS aa a wabeueiy nbtanehe uaeiedn oclaceae ddteiden eiaeehi a aenaocianehs Waa tte 85 Canne Ty OPE MUI AS 3 huss cen itera Sunset Sicha Betas E ik alae Dae Lucca den bk ert Saleen TEA delete anata 86 GENERATING SMART DATAGROUP REPORTS aiius iioii n cous utes coon a a ebcpdeGandomeeausossaueescnuees 89 Forman OPONSE sires esa aiei OTE T SEAN eae La Eb La UOTE a ai a iene tase re ee 90 Smar WOTKDOOK OC PIONS lt 6 sear TOE Meee daa cea E ton tach cas kek ca cad ba ap seed a tome meas E shea aoa 9 Retreshinie a Smart WOrk DOOKU EXC CM srek e uals dead atatwaaceelaenthelenauanetorncdvatevenate 91 Accessing the External Data toolbar in Excel 2003 cccccccccccccsseesssssesseesecccccccsccneecsessssesseececcessceneneasssssseseas 91 Accessing the Refresh All Feature in Excel 200 Ferers aneia aa a E A T 91 Remeshine the Data mExCEel2003 md 200er R A TAER scat 92 Using the Smart Dataeroup Report Wizards serisi i rin nin a e RE REON E N RA 94 SMART DATAG ROU BA OS oa aaa a Ae ara EEDA OSKE A EA EASAN OSRE ORG 95 Contents Datalnsight Web User Guide 1 Introduction and Overview DatalInsight Web
42. ECMFUA M Manufacturing mi SS lc re i iam om Fage 1of1 x x f Export Selected Export All Functions Saving Data Working with Series in a Workbook Datalnsight Web User Guide 31 Alternately you can paste a list of series copied from a text editor like Windows Notepad into the dialog by using the right click context menu available there lolx Fil Edit Format View Help Ore IC DF26H D F28H 0 Cut DFod C Be Paste Add Series by Mnemonic Undo Unda faut aop Delete Delete N Select All Select All Add 3 After you click on Add a Results dialog will appear M134RCBCGKE M MI34RCBCWA M e HISTORICAL J Add Series by Mnemonic P SMART DATAGROUPS M1IS4ICRCTTEA M SAVED TEMS WMIS4SRCBCGD M gt Workbooks Tm Daily Series G Belgium Series Tm Business Climate Ge G untitled workbook 2 GS Tables Eiji Germany FTF taty amp Smart Workbooks EG Smart_wbk_options_hel Ko Help ct Helps QI PA Workbooks e SHARED TEMS a q Cancel Results 4 series found Saving Data Working with Series in a Workbook Datalnsight Web User Guide 32 4 Click OK to complete the process and the additional series will appear in the workbook Results 4 series found P HISTORICAL SMART DATAGROUPS Business Climate Germany P Composite Index YT SAVED TEMS Y Workbooks G Daily Series Mnemonic G Belgium Series M134CECTTEA M
43. ETT TEE E CEE ET ETS TEE NENT E 3 CATE OR RE eats cscs ese hs E E be ne nein E S 4 Datalnsight Web Data grou cccccccccccccccccccceneseeccecceeeeeeeeeeeeeeeeaeeeeeeeeeeeee eee eeeeeeeeeeaaeeeeeeeeeeeesaaaeeeeeeeeeesaaasseeeeeeeeaaagees 4 Building a Category Search by Criteria Selection cccccccccccssseeesccccceee ae eeeeeeeeeeeeeaeeeeeeeeeeeeaaaaeseeeeeeeeaaaaseeeeeeeeaaaaees 5 FAP DE M EP saves A mss os west E creas nsec A E oe bans seatis emia b tenauiei tne usage et theres E 6 Usne TS TOC OWS Cio arrr riras ricors Ee e Ee EAE EEEE EENE EEE a 6 Table BOS AG OIG edariren E aE E E E N E E A E EEE EEEN 7 Save e E E A ee SEER RSENS nee Ege Te Te ee OTe PEER ET REED Cee Ee 7 TOE ess yaaa A E cea dene ectagee meson T A E 8 Hide Show Table eee ee ee ene ne eS ee ee ey eer ee ee eee an ee te ane eee Renee 8 Dilenen 9 Set amount of history and TOLECAS le avascarccsanwaseasesdiesnaebdeapnvaadte ndawiinsctentadeinanntineauslvadeseanntdrinanndsdeeoawvleaaudanitdedaeiisasteatddvacexhet 9 CUSTO ae a E E E E E E E E RET Oe E N 9 Colma sca ne e a a a i nis Ses ide a a scenes sas 10 Prel a ce nsec AE E EAEE EAEE EEE oor ETE eT a eel cle aseptic ihc eS ole dio vad cesedet te eid ac eee 11 Vy NG TA a vescevessecsessscacsacescouceusisentasesteedssusdeaceacseesceuesvevdauessevsesssaceeesiies 12 PREFERENCES FOR EXPORTING DATA isos veccsacdecaatieeteccscaceecescexmanaaadandaabenwuesecadehesns deus caaaidawdaabewensanaceuenia deuwocsmulawasaness 12 CUSTOMIZING THE RES
44. From div ihsglobalinsight corn Open Save h harm your computer IF you do not trust the source do not open or 0 While files from the Internet can be useful some files can potentially kz save this file What s the risk 6 Close the Download dialog to return to DataInsight Web Purchasing Analyzer Using Purchasing Analyzer Datalnsight Web User Guide 62 Using Smart Datagroups A Smart Datagroup is a categorized data set designed to support enhanced features for additional analytics such as currency conversion and rebasing multi dimensional data display sorted by user defined criteria and statistical ranking As a subscriber to a smart datagroup you have more options available to you than our regular workgroup subscribers A smart datagroup pulls data derived from several sources directly from the IHS Global Insight database Previewing Smart Datagroup Layouts The smart datagroup layout icons help you customize the display of your preview Icon Mode How it looks Tab Wii ord js ry a E Criteria Prewiew Available Criteria Selected Criteria Concent Concept Geography SJ Investments and Profits 3 Profits Ireduestry l M Oper ating Profits Gross Nominal A My Ingusitries r _ F Operating Profits Gross Rea 3 Industry from ISIC Rev 3 a Geography E 37 World 75 aM western Europe 17 _ A_B Agriculture a O C Mining D Manufacturing oie F European Union 15 E Util
45. IHS Datalnsight Web V4 3 User Manual February 22 2012 The Source for Critical Information and Insight 2011 IHS All Rights Reserved All trademarks belong to IHS or its affiliated and subsidiary companies all rights reserved www ihs com DatalInsight Web February 22 2012 2007 2012 IHS and its affiliated and subsidiary companies all rights reserved All other trademarks are the property of IHS and its affiliated and subsidiary companies This product including software data and documentation are licensed to the user for its internal business purposes only and may not be disclosed disseminated sold licensed copied reproduced translated or transferred to any third party IHS 15 Inverness Way East Englewood Colorado 80112 303 736 3000 Datalnsight Web v4 2 User Guide i Contents INTRODUCTION AND OVERVIEW esesesesesesesecsscscscsesecesosesesesecececscsosesesesesesesesesececscseseseseseseseseseososcecsesesesesesesesesese 1 DOCUMENTATION AND SUPPORT sssicccensseuaccenecavarscnedcedenssveweueaseuaatenacauanseodiedvaisveuecensnuneiaiaceuessmesse ivaiseeuecansnenetisacawascnedves 1 FINDING AND SELECTING DA DA esessssescsesesesesesecesesecscscsesesesesesesesececesccsoseseseseseseseseseossecsesesesesoseseseseseseseseoseseso 2 G iG Pal Se Sy 2 Gc Ea en eee eee ee eee eee ee eer EEE 3 Po SCF assccccecatenees cai eae piece ga RAE Ho SNL aA HGO 3 FORO O 6 SRC RE ERR CE TERE RTE CET CRORE ERT
46. RTERLY ANNUAL ANNUAL ANNUAL Historical Historical Historical Historical Historical Historical Historical Historical Historical Historical Historical Historical Preferences for Exporting Data If you want to set your preferred download settings as defaults or customize the settings for a specific workbook see Preferences and Settings for information on customizing these settings The following sections will show you how to Go More Results 1955 01 2009 04 2010 03 30 1996 O1 2009 Q4 2010 03 26 1996 G1 2009 04 2010 03 26 2002 01 2009 04 2010 03 22 200201 2009 04 2010 03 22 2002 Qi 2009 04 2010 03 22 1996 2009 2010 03 26 1996 2009 2010 03 26 1996 O1 2009 04 2010 03 11 1997 2008 2009 11 24 2002 2009 2010 04 19 1991 2009 2010 04 06 e a ao vV Columns Rearrange add or remove data columns using the Columns button Select series to graph and view the information a Switching between the series list and the data table Preferences Viewing Data Customizing the Results Data Columns Datalnsight Web User Guide 13 Customizing the Results Data Columns Columns Use the Columns button at the bottom of the page to display the Custom Columns dialog There you can drag and drop the buttons to add remove and rearrange the result columns before or after you retrieve your results Custom Columns Use drag and drop to select and arrange columns
47. ULTS DATA COLUMNS Saisnsnacsausssionsicnnipsosnaitoeudusaeneensnieesapdbansieatanavenwneawuneientnadoteatucevarapanexaent 13 SERIES GRAPH INFORMATION DISPLAY cides ccoscecceniccvascsxacsbadsnceveceguaevssdbacwasvenndseandecevessanads nesdbdawwaveandidendees eccanaceuadtbaxs 15 SWITCHING FROM THE SERIES LIST TO A DATA TABLE ON SCREEN ccsceccsceccsceccececcccucescecscscescscescscesescesescucecs 16 OPTION ICONS FOR THE SERIES LIST AND THE DATA TABLE VIEWS cccscescecececcceceececescscecescecescecccscescncueesces 17 SHA RING ITEMS wowissecesesecteacescdccssecscanciccccececedscaseaccecesascsscnsceccaceudscsedesesccaseeduesccessoccaveseeusedeusedcaceedcecseucduubaveceeededecssess 20 LOOK FOR A 0G aa ecerntg creatine a ors arn ane A E AEE EE EE wb wk dm enna insted ancien eed AEEA S 20 A BPS IRE ho nV E sere ener eae ene gn eee ee eye ee eee eee ee 23 PAVO DATA eecsced ease curccccenececeaeceecesecacecceucuswccesscodececuaesecssecascaneesenecosencvaceausencaeacacuddensnsecceseeodeceasesusensuwaececucnecesaeeacceer 24 I ORT BOOT eases ceteces eters sere ge bone mutes tice pst tise rac boheme cence cis omseieotia st mediocre ba eencnnd ese bastions steer menees 24 USING THE CONTEXT MENU FOR WORKBOOKS cccscesceccececccceccccececececcsceccececcececeecsceecsceecsceecscuseecesescusescecesencess 26 WORKING WITH SERIES IN A WORKBOOK c cscecceccececcecececcscescscscscuccscuccscsceecsceecscececescscescscescscesescesescscescsceset
48. a Datalnsight Web Workbook in Excel Datalnsight Web User Guide 40 Accessing the Refresh All Feature in Excel 2007 To refresh workbook data in Excel 2007 use the Refresh All option on the Data tab SH80 72 e Home Insert Fage Layout Formulas Data From Access 4 E E H Connections rom Web Properties From Other Existing Refresh a 5 a Tand R m E A a r romText Sources Connections All Edit Links Get External Data Connections Refreshing Data in Excel 2003 and 2007 To refresh the DataInsight Web data in an Excel workbook 1 After making modifications or opening a previously saved DataInsight Web workbook click the Refresh button on the External Data toolbar in Excel 2003 or click on Refresh All on the Data tab in Excel 2007 to pull in the latest data Formulas Data 2 Connections LL Faai h AF Properties Refresh aai Refresh Data alll 22 Edit Links Connections For Excel 2007 only When you export a Workbook to Excel 2007 you will see a Security Warning alert Click Options click Enable this content and then click OK Security Warning Data connections have been disabled Options RS iP Al i f ey Le2vvbm FtZSl6lkoCT1dFUIMILCJOeXBllioxLCliaWxsav ax INSIG Security Alert Data Connection Created on Fri Data Connection 5 Data connections have b
49. a base of 2 71 LOG x Converts seven day data to five day data by eliminating the data for the weekend Daily Mon Sun to Weekday Mon Fri Annual Quarterly Monthly Convert series method This function can Interpolate a lower current frequency to a higher one 1 e Annual to Monthly Please select frequency conversion method Use defaults In most cases using default conversion methods will produce desiresg results f Specify methods Select specific conversion methods as needed Low to High Applying Functions to Data Function Definitions Datalnsight Web User Guide Method Spline Prorate Linear Geometric Repeat AND 35 Example Convert GDP A Spline Convert GDP A Prorate Convert GDP A Linear Convert GDP A Geometric Convert GDP A Repeat This function can Collapse a higher current frequency to a lower one 1 e Quarterly to Annual Please select frequency conversion method Use defaults In most cases using default conversion methods wi produce gJesirsd resu its f Specify methods Select specific conversion methods as needed Method Average First Last Maximum Minimum Range Spread Total Example Convert GDP Q Average Convert GDP Q First Convert GDP Q Last Convert GDP Q Maximum Convert GDP Q Minimum Convert GDP Q Range Convert GDP Q Spread Convert GDP Q Total Applying Functions to Data Function Definitions Datalnsight Web
50. arch results appear in the columns below Search example gdp and russia of japan Advanced Go More than 10000 matches Showing rows 1 to 25 from 1000 results Bank Name s Mnemonic Concept al GEMS GEMS1 GLOBAL ATS9ONGDPZ A Gross Domestic Product Market Prices GEMS GEMS1 GLOBAL AISOVNGDPZ A Gross Domestic Product Market Prices BOP IMFBOP BOO1 C111 4 Exports of goods and services as a To of BOP IMFBOP BO01 C112 4 Exports of goods and services as a To of BOP IhMFBOP BOO C122 4 Exports of goods and services as a To of ae IMFAME ADNIA A Fynorte of annda and services az a Shon Page q of40 P FI Advanced Search You may add additional criteria to narrow your search by clicking on the Advanced link when you select a Keyword Search option in the Navigation pane search gdp example gdp and russia of japan Advanced ui Data Source All Global Economy E lMnemonic contains Frequency Annual Bank Bank List Using this feature with a keyword or phrase you can select a specific Data Source Mnemonic or partial mnemonic Frequencies and one or more banks from a bank list Mnemonic contains Bank Bank List gt ends with matches expression ita Finding and Selecting Data Keyword Search Datalnsight Web User Guide 4 Search multiple banks by using Shift click to select adjacent banks and Ctrl click to select individual banks Browse Bank
51. aton Recession Residential Criteria Preview Regions 200s 200501 200502 200503 200504 Alabama 2243620124 00 55291770200 SS7381458 00 563577359 589742607 00 Alabama 491905176 00 11S600901 00 121898008 00 124179923 126425344 00 Alabama 19995443200 48616716 00 49459943 00 50502479 00 51275294 00 Alabama 540968777 00 3765840000 38193461 00 3882694500 39407971 00 Alabama Q7937096 00 2379443100 242733038 00 24723788 00 25185839 00 Alabama 3991687 1 00 9531354 00 98125866 00 10116711 00 10456240 00 Alabama B26170219 00 2OSPISS7T2 00 20576993900 206941533 Z208240274 00 Alabama 246405974 00 61356006 00 61fS05179 00 62400159 00 62807206 00 Alabama 29352 7439 00 Tot 3300 00 Totan 00 F343925960 00 736 4099 00 Alabama 205 766359 00 213 260175 00 FISET S1476163 00 317656104 00 Alabama Te450547 00 1945901000 1862308100 T9 3259300 19830863 00 Example of Separate Frequency Visualization 212247063 00 16713155500 103730027 00 4462467 7 00 Gire FoSo3 00 250008502 00 77 Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 78 Telecommunication Recession Residential Criteria Preview Regions 2005 2006 Alabama 14736315 00 1487937 7 00 Alabama 1017450971 00 1120083946 00 Alabama 417465170 00 449010041 00 Alabama 1546697 70 00 167519676 00 Alabama 130361794 00 13017 7198 00 Regions 200501 200502 Alabama 652917 702 00 For oo 1455 00 Alabama 119600901 00 121699008 00 Alabama 4361
52. cepts 4 Domestic Consumption amp External Trade 4 Indicators of Sector Risks 4 Investments and Profits tS Output amp Input iS Input Purchases OpEx Check Input Purchases OpEx Index of Purchases of Inputs Check all next level I Index of Operating oie ol as iets ET i Index of Purchases of I puts j Uncheck all next level Operating Expenditures Real Purchases of Inputs amp Supplies Expands Purchases of Inputs amp Supplies Collapse all Production Index for Industry H Sales Gross Output 4 Value Added A Price Indices Working with Custom Criteria When you need to reuse any of the criteria frequently smart datagroups have a method of remembering them for easy selection every time you run a report Each criteria node offers a way for you to group aggregate or create formulas using selected components and to save these custom criteria for subsequent use Custom Criterion Icons There are three action icons to use in the My criteria area Icon What it does Allows you to group aggregate and apply formulas to your custom criteria items Allows you to modify your previously created custom criteria x Allows you to delete your custom criteria Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 82 Adding a Custom Criterion to the Tree To create a custom concept geography or industry 1 Click on the boxed plus sign to the right of
53. cess 29 Using the Context Menu for Series in a WOrkKDOOK ccccccccccccsssseeeseceee ceca eeeseeeeeeeeaaeeeeeeeeeeeaaeeeeeeeeeeesaaaaeeeeeeeeaas 29 Adding Series to Workbooks by MnemoniC sscccccccccccesneeeeseeceee en eeeseeeeeeee ee eeeeeeeeeee aaa es eseeeeeeeeaaaasseeeseseaaaaeneeeess 30 APPLYING FUNCTIONS FO DA DA iecivcsccscecicciscessatesesccciecsessvessdecsectcssterbesssiscosceasuscadseccesessenstbesebuielacacssecessesdecevest 33 FUNCTION DEFINITION Sched cteneaienececvoxevedacacnsdsteddadeneslensceavecesesseacesdekeddadenedoaascoaveceuasecacwsdeteddsdeacvleidconwecteasscaceseebecien 33 BP XOPOR TING DA TA TOEXCEL pasina 37 EXPORTING CATEGORY SEARCH RESULTS cccsceccsceccececcececcececcecscescscscscsccscuscececeececeecececscnscscesescesescscscecsencess 37 REFRESHING A DATAINSIGHT WEB WORKBOOK IN EXCEL cccecceceececeecececcecsccecuccececeececescscescscesescssescusesceceeencess 39 Accessing the External Data toolbar in EXCe 120O3 occccccccccsccccccccceccneeeeeceeeeec aa eeseeeeeeeaaaeeneeeeeeseeaaaaeseeeeeeeaaaaaeeeees 39 Accessing the Refresh All Feature in Excel 2007 ccccccccccssesccccccceccnseseseeceeeeeaaeeeseeeeeeeeaaeeseeeeeeeeaaaeeaseeeeeesaaaaaneeees 40 Retreshins Data m Excel 2003 and 200 T esros Ei D E R a Ei 40 PREFERENCES AND SETTINGS sesesseseseesesessesescosesesccsesecseseccosesesscsesececseceosesesecsesesecsescoseseseosesesecsesessesescosesesseseo 43 PREFERENCES AND SETTINGS OVERVIEW s seesecc
54. ds start and end The functions which determine the ranking are calculated always on the base of these two periods Rebasing Rebasing Base ear 2009 Rebase indices m Rebase real values The main objective of rebasing a series is to update the base year to a more current year Select the base year for rebasing from the scrolling list and then choose to rebase the indices real values or both Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 79 Rebasing Base ear Generic Formula for Rebasing Rebased_series series series old base period series new base period Note For real monetary values it is a little bit different Rebasing for Real Monetary Values Rebased_series series LinkedNominalSeries new base period series new base period Where LinkedNominalSeries is the value of the corresponding nominal monetary value Example For the WIS smart datagroup Total Sales Gross Output Real uses the value of Total Sales Gross Output Nominal Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 76 Report Defaults Report Defaults Type C Regular Ranking Layout ca cS eo Selected Criteria Hierarchical Flat Frequency Mixed Separate visualization Start 2004 Erd 2014 F a Show Functions In Columns a Show Empty Rows Output Currency M US Dollar E Brazilian Real R Euro t8 Russian Ruble py6
55. e The View Data Table option of the workbook context menu displays the Data Table within the selected workbook with the series data in it Alternately you can click on the Data Table tab above the column headers of the series list to display the table Series List Data Table i L Geography Series Pe On the Data Table tab the series in the table can be grouped by using the drop down list at the bottom of the screen EU Growth Rates 44 Series 20 observations history before today TE Somoe iie 0 observations forecast after today Move Data Table hina Smelting and Pressing QUARTERLY JPPISEMNS Rubber and Plastic Products IPPIRBNS Rolled Products JPPIFMMRSt Aggregate Prices JPPICHNS i Plastic Products 9 23 2009 JPPIPLNS C Aggregate Prices 2009 02 JPPIPPNS K Ferrous Metal Materials QUE Do not group JIPPIRMMOTI Group by CONCEPT 4 E AA EEA Excel Export Values Down New Window Columns Settings Viewing Data Switching from the Series List to a Data Table On screen Datalnsight Web User Guide 17 Option Icons for the Series List and the Data Table Views Tab Icon Description Series List Depending on your browser configuration you may be prompted to open or save the Excel document Export selected Exports the selected series of the open workbook to Excel and opens Excel when you choose the Open button If you choose the Save button you will be asked to select the location for
56. e field when they look at the workbook settings Workbook Settings Advanced VWorkbook Copy of Aruba RO Use application defauts Use these settings Billing Code optional Sharing Items Look for Shared Items Datalnsight Web User Guide 23 Sharing is ON OFF Sharing is OW Sharing ton Your colleagues can see your shared tems TURN OFF SHARING When you turn sharing on in this pane your colleagues will see the items that you have marked for sharing To mark a workbook for sharing right click on it in the navigation pane and select Share this item from the context menu that appears Your shared items will appear in the lists of your colleagues Y Workbooks 4 SE Asia Sales Territory Delete Copy Rename Move Share this tem Export View Data Table ifntnocrte td i To stop sharing right click on the item again and select Stop sharing this item Y gt Workbooks 4 meee OE ee Copy Fename Move Stop sharing this term fe Export View Data Table A A AA AAAA When you turn sharing off in this pane your colleagues cannot see the items that you have marked for sharing Sharing Items Sharing is ON OFF Datalnsight Web User Guide 24 Saving Data Workbooks Workbooks are containers you can create to save organize and manage time series To create a workbook manually 1 Once you find the time series you want see Findi
57. een blocked If you choose to enable data connections your 6 Bank Name computer may no longer be secure Do not enable this content unless you trust the source of this file Slovenia File Path nternet Files Content IES SNVHD9DN sub_series_ 2 2010 04 09 1 xls 9 KEYIND KEYI 2 3 A unknown content recommended 23 Open the Trust Center 3 OK K aa Exporting Data to Excel Refreshing a Datalnsight Web Workbook in Excel Datalnsight Web User Guide 41 3 Login with your MyInsight credentials You only have to do this once per Excel 2003 or 2007 session Connect to theglobalinsight com 4 The server at MyInsight Login requires a username and User name s by Insight User ID Password Mylnsight Password Remember my password _ cont 4 If you exported a smart workbook containing a single tab current data will be pulled in and the refresh process will be complete If you exported a workbook containing multiple tabs a download link will display Click it ONCE as it indicates and go on to step 5 Eimicosoftexe o Bile Edit view Insert Format Tools Data Window Help Adobe POF 7 lala oe BiB Miser crc Bo B 10 B 4 SS 2 Oo A ob ee ia xt on Exporting Data to Excel Refreshing a Datalnsight Web Workbook in Excel Datalnsight Web User Guide 42 5 Click OK to open the refreshed copy of your workbook Microsoft Office x Opening http Hawi
58. en the refreshed copy of your workbook Microsoft Office X a Opening Atos ii ihs globalinsight com fExcellpdate aspxrid ey hci hM s UyI dHJizZSwidsNicmS5hb UiO Jna hdagiL T J0esBlIjo4LC I pZCI6NjADNDBES Some files can contain viruses or otherwise be harmful to your computer It is important to be certain that this File is From a trustworthy source Would vou like to open this File ox IL Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide 94 A status screen will appear Opening http ihs globalinsight com fExcelipdate asp id eyJhcLAMUyT6dHI1 2SwidkNlcmShbwLiciInasvhdGegilCidexBlTjo4lc IpZCI6hNj40NDE9 6 Current data will appear in an updated read only copy of your workbook if it has multiple tabs E Help _2010 4 19 13_57_S xls Read Only Rank Currency nag industry 2006 2015 Percent Change 2006 100 Mi Health and Social Serices 2006 100 O92 Recreational Cultural and Sporting R 1 Wie 2006 100 O Social and Personal Sernces 3 4 2006 100 Sanitation Trade Organizations Other Seraces 080 091 O95 1 million WS Dollar Mj Health and Social Sernnices 153 B08 39 415 619 51 TUS million US Dollar Sanitation Trade Organizations Other Seraces 090 001 O95 85 694 19 152 137 36 Pr e million US Dollar 0 Social and Personal Serices 136 910 48 241 230 83 ih 24 million WS Dollar O92 Recreational Cultural and Sporting 31 216 29 69 153 48 4 07
59. ent debt consolidated poland gdp When you clear the check box in this pane no shared items appear in the navigation pane Sharing Items Look for Shared Items Datalnsight Web User Guide 21 APPLICATIONS FORECAST HISTORICAL T YTF YT Y SAVED ITEMS Note about Billing Codes and Sharing The billing code comes from the source workbook when the source workbook has a workbook level billing code specified using the button at the bottom of the screen Examples Scenario I You set the billing code at the workbook level and the billing code appears on the Advanced tab for workbook settings EE Columns Workbook Settings Advanced Workbook Aruba Rl Use application detautts e Use these settings Billing Code optional 4507111 Sharing Items Look for Shared Items Datalnsight Web User Guide 22 Users that share this workbook with you will see your billing code on its Advanced tab for workbook settings Workbook Settings Advanced VVorkbook Copy of Aruba RC Use application detauts Use these settings Billing Code optional 4507111 Scenario 2 You assign a billing code to all your workbooks as a default using global preferences and the billing code appears on the Advanced tab T Log out Feedback P Help Global Preferences Advanced Billing Code optional 4507111 When you share this workbook other users will see nothing in the Billing Cod
60. eries to view export or store in a workbook To begin a keyword search click on the Keyword Search selection under Forecast or Historical in the left hand navigation pane The keyword text box then appears for you to enter your search term or phrase Y HISTORICAL Q Keyword Search example gap and russia of Japan Q Global Economy There is also a Keyword Search under the Selected Criteria pane to further filter your results HISTORICAL j Available Criteria Selected Criteria Q Keyword Search Geography Geography E Global Economy a v Asia Pacific a Iw Asia Pacific C Financial Markets i 7 Europe Emerging Q U S Economy 4 Europe Western Q U S Regional 7 Latin America and Caribbean c Pricing and Purchasing Hist a Middle East amp North Africa Q Industry a Other Aggregates E SMART DATAGROUPS Sub Saharan Africa Y SAVED TEMS a 7 USA and Canada gt Workbooks Concept G Daily Series Source Keyword Keyword searching is a technique that allows the search for the occurrence of words in time series documentation A keyword is a word or phrase found in the documentation that identifies it to you in some way Finding and Selecting Data Documentation and Support Datalnsight Web User Guide 3 Keyword Search Basic Search To perform a basic search enter partial or full words or expressions in the Search field and press Enter or click Go The se
61. es of your colleagues at the bottom of the navigation pane Y SHARED ITEMS a 2 Drzazgqowski Wojciech P 2 Grzywinski Kamil a 2 Jachas Dominik gt z Klingenberg Adam a z Pajak Wojtek Y Radzimski Roland WORKBOOKS it government debt consolidated poland gdp When you clear the check box in this pane no shared items appear in the navigation pane APPLICATIONS P FORECAST gt HISTORICAL B SAVED ITEMS See Billing Code above for an important note about sharing Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 51 Sharing is ON OFF Sharing is OW Sharing is an Your colleagues can see your shared tems TURN OFF SHARING When you turn sharing on in this pane your colleagues will see the items that you have marked for sharing To mark a workbook for sharing right click on it in the navigation pane and select Share this item from the context menu that appears Your shared items will appear in the lists of your colleagues Y Workbooks SE Asia Sales Territory Delete Copy Rename Move Share this tem Export view Data Table A G A A AAAA To stop sharing right click on the item again and select Stop sharing this item gt Workbooks 4 G SE Asia Sales Territory Delete Copy Rename Mowe Stop sharing this term m Export view Data Table i When you turn sharing off
62. fe ewJic32vvbmFtzSl6lkoCT1ld FUIMILCJOeXBllioxLCliaWxsav 2 x we Microsoft Office Security Options INSIC Security Alert Data Connection 2 3 4 Created on Fri Data Connection 5 Data connections have been blocked If you choose to enable data connections your 6 Bank Name computer may no longer be secure Do not enable this content unless you trust the amea source of this file 2 Slovenia File Path C 4 nternet Files Content IES SNVHD9DN sub_series_2_2010 04 09 1 xls 3 KEYIND KEYI om unknown content recommended A 23 Open the Trust Center 3 0k Cancel Login with your MyInsight credentials You only have to do this once per Excel 2003 or 2007 session User name E Meinsh User 1D Password My Iraaght Password Remember my password Lae E Using Smart Datagroups Generating Smart Datagroup Reports Datalnsight Web User Guide 93 4 If you exported a smart workbook containing a single tab current data will be pulled in and the refresh process will be complete If you exported a smart workbook containing multiple tabs a download link will display Click it ONCE as it indicates and go on to step 5 lox File Edit view Insert Format Tools Data Window Help Adobe PDF Bal 5 be 4 anap HD Insert air chart f Tl b E 4 EEEE al t B23 6 CLICK ONCHTO DOWNLOAD UPDATED WORKBOOK Ea 10 i Ha KH c i ho 15 5 Click OK to op
63. fication Industry My Industries GI Health ss GO MyGroaup AT TechGoodsAv Indi ly from ISIC Rev 3 Industry from GICS Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 86 Creating Formulas To create a custom concept geography or industry with a formula as part of it 1 Select Formula as the type a Industry from ISIC Rev 3 E A_B Agriculture al c Mining E C10 Coal Mining T C12 Oil amp Gas Mining B C12 Mining of uranium amp thorium ores E Energy Mining C10 C11 E Mining of Metals amp Quarry C12 C13 C14 2 gt Manufacturing a E Utilities E F Construction Aggregation Method Custom Formula PF c11 of amp Gas Mining l i ey ey a 2 Drag and drop your components into the Custom Formula textbox Place your cursor between each component and either click on the appropriate button or type in the operator 3 Click on the Check Formula button to verify the validity of the formula you created and if the system confirms that your formula is valid a green check will appear to the right of the formula textbox Custom Formul Sar 4 Name your custom criteria and click Save Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide Type a Industry from ISIC Rev 3 D 4_8 Agriculture al 0 Mining E C10 Coal Mining T C11 Ol amp Gas Minin
64. g a C12 Mining of uranium amp thorium ores Energy Mining C10 C11 E Mining of Metals amp Quarry C12 C13 C14 a D Manufacturing a E utilities r F Construction Aggregation Method Custom Formula Save as 87 5 Your custom criteria with formula will be available under the My node for subsequent sessions of your smart datagroup It will be marked with an F for easy identification B My Industries GE Health 85 co MyGroup OT TechGoodsAy E _ Mining ilGas H Indry from ISIC Rev 3 Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 88 User Defined Calculation Order Calculation order is very important in your custom formula When you define two or more calculations using custom components the order in which they are carried out is the order in which you defined the calculations In some cases you may need to modify the calculation order to obtain correct results For example if you wanted to use the result obtained from calculating two formulas to calculate the value of a third one the first two formulas must be calculated together first to obtain the correct final results Formula Examples If you create your formula like this Hungary Poland Hungary Czech Republic El wt ee te ets et ae This will appear in your preview Criteria Preview Industry Geography Currency Unit 3 Concept Operating Profits Gross Nominal
65. g once on the date and using the calendar tool provided Finding and Selecting Data Table Browser Datalnsight Web User Guide 10 1E JOS ae gt Su Mo Tu Th Fr Sa Fixed date EE Eel 1 3 4 5 a 10 11 12 15 17 18 14 22 r 24 25 26 29 1End Date End Date f Last value Today 0 observations before today Fixed date 25 Sep 2009 Last value Select to export time series data ending with the last observation of the data that exists in our database Today Select to use today s date as the end date Number of values before or Enter the number of observations years quarters or months to after today export starting with today and going back into time for historical data or ahead into the future for forecast data Fixed Date Enter an end date or select it by clicking once on the date and using the calendar tool provided Fixed date 25 Sep ALEN Columns Columns Finding and Selecting Data Table Browser Datalnsight Web User Guide 11 Use the Columns button at the bottom of the screen to display the Custom Columns dialog where you can add remove and reorder the columns you would like displayed for your series You can change the selected columns by drag and drop and you can also double click on a column to flip it from right to left or vice versa Custom Columns Use drag and drop to select and arrange columns Available Columns Selected Columns Bank Mamels
66. ick on the Edit icon to the right of the custom criteria that you want to modify 3 My Concepts GD OpProfitsMR Output amp Input 2 The Edit Custom Concept dialog appears for you to make your changes Click Save to complete your modification A Output amp Input a Investments and Profits a Domestic Consumption amp External Trade a Price Indices 4 Indicators of Sector Risks Aggregation Method Custom Formula 3 My Concepts GL OpProfitsNR 4 Output amp Input Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 84 Defining Groups or Aggregates and Applying Formulas My criteria nodes allow you to customize your selections and save them for use whenever you access the smart datagroup again 4 My Industries fh 3 Industry from ISIC Rev 3 To start the process click on the plus icon to the right of your My criteria node and a Create custom dialog appears for your selections ype a 0 Manufacturing 3 015 Food amp Beverages 7 TEPP ncheck D15 Food amp Beverages Iv 0155 Beverages ais i Food Products 0151 0152 0153 01 Check allnext leve fh E D 16 Tobacco Products Uncheck al next je E D17 Textiles Jal angi xpand a E D18 Weeanng Appare 019 Leather Footwear Collapse al 020 Wood Products exclude furniture 021 Paper amp Pulp gl 022 Printing amp Publishing Aggregation Method
67. illon US Dollar a M European Union 15 Tables A ST Europesn Monetary Union 12 z EE Smart Workinn Spain million US Calar b 59 Smart Workbooks FF Austria a wt E n a I Belgium l Pagel af TTi H M Frl jx Regular Group By ao Start Date 2004 vi Functor Ranking Sheet By 1a End Date 2014 Preferences Portugal mikon LS Cuar Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 65 Smart Datagroup Icons and Options Options available when a smart datagroup 1s selected a Regular kA Export Refresh Save Ranking PLING noms f x Regular Export Refresh Ranking Icon Option What it does f Allows you to apply functions to your data x MW Base Value Base Functions W Percent Change PCH E Moving Average MOVAVG E Compound Annual Growth CAGR 2004 2005 O 4 lt _ i Function Definitions Base Value The raw data Percent Change The change in data from one period to another expressed as a percentage of its value in the first of the two periods PCH x Percent change of x lag 1 x x 1 1 100 Moving Average A method for smoothing data by averaging a fixed number of consecutive years MOVAVG n x Moving average of x lag n Compound The smoothed year over year growth rate of a value Annual Growth over a specified period of years Rate CAGR x Compound annual growth rate of x lag 1 x x 1 p 1
68. in columns Show Empty Rows E Show Empty Rows Toggle to show and hide empty rows Output Currency The currencies in which you would like your results expressed Selecting Local Currency will display data for each country in its local currency e g United Kingdom data will appear in pounds China data will appear in yuan etc You can select as many currency types as you want for your output Smart Datagroup Criteria Selection When you need to reuse any of the criteria frequently smart datagroups have a method of remembering them for easy selection every time you run a report Each criteria node offers a way for you to group aggregate or create formulas using selected components and to save these custom criteria for subsequent use You make your selections in the Available Criteria panel and they appear in the Selected Criteria panel Working with Custom Criteria below gives information about the My criteria nodes of the selection trees Available Criteria Selected Criteria Concept 3 Output amp Input 3 Value Added I Value Added Nominal IM Value Added Real 3 Geography Geography Industry 4 My Industries 4 Industry from ISIC Rev 3 3 My Geographies Industry from GICS grap IM BRIC a C world 75 al western Europe 17 40 European Union 15 ao European Monetary Union 12 M France we Germany al Asia Pacific 17 M China I Vietnam 3 Industry 3 Industry from ISIC Rev 3 aL
69. in this pane your colleagues cannot see the items that you have marked for sharing Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 52 Cost Analyzer The Cost Analyzer tool allows you to tactically analyze a single buy or strategically evaluate an entire supply chain performance to know if your suppliers prices are inflated or not The Cost Analyzer wizard walks you through the process of building a workbook of commodity and economic time series Your workbook is saved and the data within it automatically refreshed as new data becomes available Cost Analyzer eo cn Apply Wiehe ese De bire Bo ies lee Sorbet ee ed ee veg Cost AnahWzer walks you through the process of building a workbook of commodity and economic timeseries Your workbook amp saved and the data within t automatically refreshed as new data becomes available Ready to get started Shel Label ag ast Gam Cort Pars Lad Foie Feuer ee Agere ays Gare PG Pori Peis Deag Mle AL AL eerie Sangh ryu em Lene Prise scars Agr T Songhua Sangha MAN Pers Price Deras amp AET Sayisi Mod Dice bans a eee PP ay gepritted AIL Forban H bean Cal NS Port Prior Da Apert pe m mM L oben Sateen Fan Level Price Pepai Agaat B C o a z E O PASA Vaik Pee L Prine Ba Ai A E oF k aT Jit ee ey rs a V Preferences Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide
70. ing Materials Machinery amp Equipment Electronic Components E H E E E Paper and Packaging i Transporation Equipment and Logistics Purchasing Analyzer Using Purchasing Analyzer Datalnsight Web User Guide 3 Select concepts to apply to your selected series 60 Purchasing Analyzer Concept and Input Cost Breakdown Concepts Select concepts to include in spreadsheet applied to the selected series fv Prices 2 V Input Costs 2 Jf Productivity Adjusted Input Cost ca Productivity 2 F Demand CP Jf Show Input Cost Breakdown Group resuits by Concept Industry Back Next fy C Hein gt 4 Select any statistics to apply to your selected series Purchasing Analyzer Statistics Statistics select any statistics you vould like applied ta the selected series Percent Change J Percent Change Year Ago Percent Change Year Ago Moving Average Percent Change Annualized Next fhm C He Purchasing Analyzer Using Purchasing Analyzer Datalnsight Web User Guide 61 5 Select Download for workbook creation and select to open or save the Excel workbook using the dialog that appears Purchasing Analyzer Download Download Your Purchasing Analyzer Excel document is ready for downoad Back I Close E Help File Download x Do you want to open or save this file Name Purchasing4nalyzer 2010 12 09 xls HH Type Microsoft Excel Worksheet
71. ing your custom geography it will appear in the My Geographies node in the Geography Criteria tree For more information see Smart Datagroup Criteria Selection Can Apply Functions to the Data in my Smart Datagroup Once you have selected your criteria click on the Functions button at the bottom right of the screen You can apply Percent Change Moving Average and or Compound Annual Growth rates to the data in your report Selected functions will be applied to all the data in your report How Can I Create a Report with One Concept in Percent Change PCH and all the Concepts in Base Value After selecting your Concepts you can apply functions to specific Concepts in the Selected Criteria panel Simply right click on any Concept and check the function you would like applied to that Concept I ve changed the Date Range for my Report but the New Dates are not Reflected in the Preview Data Display Table After changing Smart Datagroup options on the bottom of the screen you need to click the Refresh button to apply these changes The word Preview in the display pane title bar has an asterisk next to it 1 e Preview to represent when a refresh is needed Can Display a Report in More than One Currency You can display your data in single or multiple currencies Click on the Preferences button and go to the Smart Workbooks tab to modify the Output Currency for your report All of your Selected Criteria will be displayed in the cur
72. ities al European Monetary Union 12 IY Austria we Belgium IW Fir ana w France ca Germany lv Greece M Ireland Iw Tha n Tus Pile hie el os le F Construction aC G Wholesale amp Retail Trade _ H Hotels amp Restaurants a O 1 Transport Storage amp Telecommunication a 2 Financial Intermediation O Real Estate amp Business Activites L Public Administration amp Defense Compulsory Social Security O Education lv iN Health amp Socal Services Using Smart Datagroups Previewing Smart Datagroup Layouts Datalnsight Web User Guide Stacked 00 Side by side 63 Word Industry Service Available Criteria Concept Geography Industry L My DULL B Investments and Profits E Profits I Operating Profits Gross Nominal I NM Health amp Social Services I Operating Profits Gross Real I 0 Social amp Personal Services 3 Geography I P Private Household Services x a world 75 JM Westem Europe i7 Preview Geography Curren 2004 2005 2006 3 Concept Operating Profits Gross Nominal 19 Items 20926 222458 230777 97 20154 213921 221583 84 2106 77 2323 40 2534 20 6965 58 7377 99 7710 19 1726 25 1857 47 1537 03 299304 95 28 7551 51 332135 19 318929 56 269656 19 30649 2593230 97 H Westem Europe millon European Union milion 29358 Austria mili n Belgium milion T Finland milion
73. lication defaults or to use settings specific to a workbook Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 45 Global Preferences and Workbook Settings Explained Option and Description Tab Export Format Style Location Orientation Decimal Places Display dates as Formatted This style displays a table that has formatting applied to it to make it more attractive and easier to see the column and row headers Results are grouped with each grouping item having its own row header with the members of the group below it Example If grouping by country there will be a row with the name of the country and the following rows will contain the series for that country Data that has Data Edge information associated with it will be displayed according to the Highlight Forecast selection of the Format tab Plain This style is an Excel spreadsheet without formatting and is recommended when the sheet is being used programmatically or as the input to another process where style information and grouping could be a problem With plain style each grouping item does not appear on a row by itself like in Formatted Instead the grouping items are repeated in their own column so each row has this information 1 1 The cell location row number and column number is where you would like the data to start in the generated Excel document Orientation i p g f Acros
74. mnemonics See Adding Series to Workbooks by Mnemonic for more information Note Workbooks can contain a maximum of 1000 series Using the Context Menu for Series in a Workbook To use the context menu for the series in a workbook select one or more series and then right click for the menu Business Climate 12 Series 01 Aug 2011 Composite Index Today Series List hine monic Bank Name s Concept 1 DRINTLINTLINE GLOBAL Business Climate 2 DRINTL INTLINE GLOBAL Business Climate 3 Ha DRIINTL INTLINE GLOBAL All Industries 4 ih TORY DRIINTL INTLINE GLOBAL Economic Situation at Presen 5 Select Al DRINTL INTLINE GLOBAL Business Climate 6 ta ced all DRIINTL INTLINE GLOBAL Economic Situation at Presen T DRIINTL INTLINE GLOBAL Economic Situation ower Nexd g AEBe funetien DRINTL INTLINE GLOBAL Business Climate inf Clear function DRIINTL INTLINE GLOBAL Business Climate 10 INQBCWESNSm A4 0 DRINTL INTLINE GLOBAL Business Climate 11 JBCWESNS WE O DRIINTL INTLINE GLOBAL Business Climate 12 INQBCWESNS NA O DRINTLINTLINE GLOBAL Business Climate When you move or copy series using this menu a Browse Workbooks dialog box appears for you to choose the target workbook from a list or create a new workbook as the target After you move or copy both workbooks in the Workbooks panel display disk icons as they are automatically saved Browse Workbook Please select destination workbook bag G Copy of untitled workbook 13 G Copy of Frankey
75. mns in my report How can I organize the data in my report by Geography Concept or Industry Can I change the layout of the Criteria panels and data Preview display How do I refresh my Smart Workbook in Excel What is a Smart Datagroup A Smart Datagroup is a categorized data set designed to support enhanced features for additional analytics such as currency conversion and rebasing multi dimensional data display sorted by user defined criteria and statistical ranking How Do Set Default Settings for my Smart Workbooks Click on the Preferences button to modify and save Global Preferences The Smart Workbooks tab options are preferences that apply only to Smart Workbooks created using the Smart Datagroup navigation the WIS Report Wizard and the WIS Ranking Wizard Smart Datagroup FAQs Generating Smart Datagroup Reports Datalnsight Web User Guide 96 How Do I Create my own Custom Geography Concept or Industry In the Smart Datagroup Geography Concept or Industry criteria selection drawer click on the to the right of the top node 1 e My Geographies My Concepts or My Industries to access the screen to define custom groups For example to create your custom geography click on the plus sign to the right of the My Geographies node This will open the Create Custom Geographies screen where you can define a Group of Countries and optional Aggregation Method or Custom Formula and name your custom geography After sav
76. ng and Selecting Data for more information select one or more of them and click on the Save Selected button at the bottom of the webpage ob CG Save Selected Save All To save all of your results click Save All without selecting anything Either action will display a Browse Workbook dialog for you to save a new workbook in the Data Sources pane The new workbook will appear with the name selected and ready for you to type the workbook name Hint You can also right click in the workbook area and select Save or Save All from the menu that appears Browse Workbook Please select destination workbook Y gt Workbooks 3 untitled workbook 10 gt Business Climate f a Saving Data Workbooks Datalnsight Web User Guide 25 2 To set the name press Enter To open the workbook click once on it in the Workbooks data tree gt G Business Climate ies losthhhhr Series count 1 Note The number of series in a workbook will appear in a tool tip as you hover over the workbook s name Once the workbook is opened you can Rename it by clicking once on it in the workbook data tree Use the Settings button to change the settings for a specific open workbook overriding the defaults set on the global Preferences tab 4S untitled workbook 10 Business Climate 12 Series 01 Aug 2011 D Copy of sdsadsad Today g Copy of ca25 G Copy of untitled workboc Data Table XG untitled
77. on adjacent series use Ctrl click APPLICATIONS j Available Criteria Selected Criteria gt FORECAST P Geography Geography Es F Y HISTORICAL Concept E E USA and Canada Fiegen a National Accounts A tad Sofas Q Keyword Search j i l Bl V United States ae ee 5 7 Physical Output and Capacity C nt Global Economy A CUER Q Financial Markets e ee B Economic indicators i B Prices z i Q U S Economy 1 14 2011 a amp 7 Prices 6 oon B W Consumer Price Index a p7 Consumer Price index ce ee p Producer Price index P SMART DATAGROUPS i Surveys 2 E 7 Wholesale Trade and Retail Sales hd Workbooks 4 4 2 untitled workbook 10 Source Keyword 5 S i or oe Results count 10 Ta Copy of caz5 i l a Concept Geography Frequency End Date Mnemonic Shon Labe A e Urban Wage Earners and Clerical Workers United States MONTHLY Dec 2007 CPMVRG US M CONSUMER hgk E 3 Urban Wage Earners and Clerical Workers United States MONTHLY Dec 2007 CPM NS US M CONSUME fdgf i Urban Wage Earners and Clerical Workers United States MONTHLY Dec 2007 CPM US M CONSUME G Copy of series losthhhht Y Start Date End Date Last Update Frequency Urban Wage Earners and Clerical Workers United States MONTHLY Dec 2007 CPMVRNS US M CONSUMER Urban Wage Earners and Clerical Workers United States MONTHLY Dec 2007 M111PS1TTR1 M CONSUMEF Jan 1913 4 F Dec 2007 Page 1 lof 4 2008 01 16 G amp AA 7 Save Selected Save
78. onics Use VVEFA Mnemonics When there are series that have both a DRI and WEFA series name 1 e the series have been merged this selection allows you to set which name you want displayed f Use DRI Mnemonics Available Criteria Selected Criteria Concept Concept 3 U S Economic Indicators 2 z Source Frequency Y industry Classification B fw Government Finance SOUTCE fw United States USA More than 1955 matches Showing results 1 25 of 1000 ore Results Mnemonic Source GOUTZNS LEG M GOUTZNS GSA M GEFFOICUB_U M GOUTMLFRDNS M GOUTMLPRNS M GOUTMLMPNS M GOUTZNS EPA IM GOUTZNS 00A4 M Concept Legislative Branch U S Department of the Treasury General Services Admininstration U S Department of the Treasury FDIC Corporation U S Department of the Treasury Procurement U S Department of the Treasury Procurement U S Department of the Treasury Miltary Personnel U S Department of the Treasury Environmental Protection Agency U S Department of the Treasury Agriculture U S Department of the Treasury fe Use WEF A Mnemonics More than 1955 matches Showing results 1 25 of 1000 lore Results P Mnemonic Source GEFLEGUB_U M GEFGSAUB_U M GEFFDICUB_U M GOUTMLPRONS M GOUTMLPRNS M GOUTMLMPNS M GEFOEPUB_U M GEFDAGUB_U M Concept Legislative Branch U S Department of the Treasury D General Services Admininstration U S Department of the Treasury FDIC Corporation U S Department of the Treasury Procurement U
79. outs How Do I Refresh my Smart Workbook in Excel You can update your Smart Workbook in Excel 2003 using External Data toolbar and in Excel 2007 using the Data tab If your Smart Workbook contains multiple tabs the data is refreshed in anew workbook For more information see Refreshing a Smart Workbook in Excel Smart Datagroup FAQs Generating Smart Datagroup Reports
80. r NA Denomination of the unit Indexes are not scaled For some forecast data scale and unit are combined in the Unit column When present indicates whether a time series is seasonally adjusted Valid values are SA NSA or NA Indicates whether a time series is historical or forecast This column often includes forecast details indicating what type of forecast series it 1S Abbreviated form of the Long Label The organization from which the data is obtained The date of the first observation of time series data Standard of measurement e g currency percentage index and exchange rate For some forecast data scale and unit are combined in this column Series name assigned using the legacy WEFA naming convention No longer applicable This column will be removed in a future release No longer applicable This column will be removed in a future release No longer applicable This column will be removed in a future release No longer applicable This column will be removed in a future release Viewing Data Customizing the Results Data Columns Datalnsight Web User Guide 15 To expand a result column s width place your cursor on the line between the column headings slowly until it displays as a two sided arrow shown in a red box below After that drag the column to the right until it becomes the desired size Concept i Last Update 1974 0101 2017 10 0t 2007 05 1
81. rences 01 Aug 2011 Finding and Selecting Data Table Browser Datalnsight Web User Guide Table Browser Actions Save This option saves a table in your Saved Items area for quick access in future sessions When you click the Save icon a dialog appears for you to either select a destination folder for your saved table This dialog also allows you to create new folders Browse Saved Tables Piegs select destination older Ge Tables National Accounts SDP Outlook New tolder To create a new folder 1 Click New Folder 2 Name the folder in the textbox that appears in the Tables list see above 3 Click Save and your saved table will appear in DataInsight Web in its new folder Y gt Tables 4 tii Global Investment Grade tii Canada til Commitments of Traders Al National ce nts GDF O Smart Workbobr amp Finding and Selecting Data Table Browser Datalnsight Web User Guide 8 Export This option allows you to export the current table into an Excel workbook Depending on your browser configuration you may be prompted to open or save the Excel document File Download Do you want to open or save this file Name Table 3 Gross Domestic_Produc_2009 10 08 xls H Type Microsoft Excel Worksheet 64 0KB From diw4 ihsglobalinsight com Open Save gt While files from the Internet can be useful some files can potentially arm Your computer IF you do not
82. rency s you have selected How Do I Rearrange the Order of the Rows in my Report After selecting your criteria you can rearrange the order for any Concept Geography or Industry by dragging and dropping them within the tree in the Selected Criteria panel The order reflected in the tree will be the order of the rows in your report How Do Rearrange the Order of the Columns in my Report Currently you cannot rearrange the order of the columns in your report Smart Datagroup FAQs Generating Smart Datagroup Reports Datalnsight Web User Guide 97 How Can I Organize the Data in my Report by Geography Concept or Industry When the Regular radio button in highlighted you can use the Group by drop down list to organize the data in your report by Geography Concept or Industry Additionally you can further group the data by sheets in the workbook by using the Sheet by drop down list Alternatively you can also rank the data by clicking on the Ranking radio button You can rank by Geography Concept or Industry and select a ranking criterion of either End Date Difference Percent Change or Compound Annual Growth Rate Can Change the Layout of the Criteria Panels and Data Preview Display In the upper right hand corner of the Smart Datagroup display panels there are three icons to modify the display in Tab Mode Stacked Mode or Side by Side Mode For examples of the layout for each of the options see Previewing Smart Datagroup Lay
83. res allow you to apply functions to your data export your data and selected formatting to a new or existing Excel workbook refresh your data with the latest information and save your criteria for use over subsequent smart datagroup sessions A smart datagroup like World Industry Service or WIS pulls yearly data derived from several sources directly from the IHS Global Insight database ys INSIGHT Datalnsight Web LJ Logout w Preferences Feedback F Help g Word Industry al Word Industry Service g Energy A C Telecoms Concep Geograghy Currency unit 200 a Heaslincsr Geg apy i 3 Concept Operating Profits Gross Nominal velaoe Criteria Preview Cy Au tome ite inmsit 1 Publie Adn ere Com Westem Europe milon US Dollar q Agriculture L Public Adminetaten amp Detense Com a iM Education European Union millon US Dollar T HISTORICAL n E K Ausia milon LS Disi L Keyword Search k l Selected Criteria algum millon LS Dallar C Global Economy C Financial Markets QC U S Economy 3 Concept x a dand miton US Dollar SJ Investments and Profits a Profits QLU S Regional I Operating Profits Gross Nomina Y SMART DATAGROLPES F Operating Profits Groce Real Greece milon US Collar 1 3 Geography Ea Ireland million LS Dollar SAVED ITEMS a world 75 Italy million US Dallar Prence milion WS Dallar Germany millon US Dallar TE Pis a e C Workbooks 3 M Western Europe 17 Netherlands m
84. s 1 2 2 Down 2 3 Indicate whether you want values in rows or columns by making a selection here Decimal Places 2 ie Select the number of decimal places to be displayed Note When exporting data full values will be exported to Excel This setting determines the format Excel will apply to the data Once in Excel data can be reformatted to show additional decimal places Display dates as Start of period Start of period k For dates that do not pertain to a single calendar day such as 2000 Q1 or 2000 select whether these dates should be passed to Excel Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 46 Date Range Highlight forecasts Set amount of history and forecast Custom as the start or end of the period in question Example For 2001 Q1 data export this to Excel as 1 Jan 2001 start of period or 31 Mar 2001 end of period ff Highlight forecasts i For data where a data edge is reported this preference lets you display forecast values in the highlight color of your choice for both DatalInsight Web tables and Excel spreadsheets after you export them F Set amount of history and forecast 20 observations history before today T observations forecast after today Select the date range in a number of years quarters months or observations in the past and in the future Note This selects the date range relati
85. save the workbook after renaming it if necessary to any location on your system hy a Documents My Documents Ed My Computer METE File name Workbook_201 1 09 06 xls Save as type Microsoft Office Excel 97 2003 Worksheet Cancel p Exporting Data to Excel Refreshing a Datalnsight Web Workbook in Excel Datalnsight Web User Guide 39 Refreshing a Datalnsight Web Workbook in Excel You can update your workbook in Excel 2003 using External Data toolbar and in Excel 2007 using the Data tab You also can disable this feature on the Advanced tab under the Preferences menu option J Log out Preferences Feedback F Help Global Preferences Date Range Sevanced Smart Workbooks Default order for catego Search O Concept iAlpafbetically Concept tafder in Tree Display mnepronics preferences Ce DRI Mnemonics Use WEF A Mnemonics M Do not generate refreshable Excel sheets Billing Code optional Rows per page Do not limit Accessing the External Data toolbar in Excel2003 To display the External Data toolbar in Excel 2003 if it does not appear in the Excel toolbar area use the View gt Toolbars gt External Data menu options a Normal U Page Break Preview Task Pane Ctrl F Toolbars Formula Bar status Bar External Data k Customize Exporting Data to Excel Refreshing
86. ssncacedecousantuewes de sacuwanadetzcacwbecousaaeeeceusseuaeanabetedaswbeaeusdadouseadsscuieseubecseas 43 GLOBAL PREFERENCES AND WORKBOOK SETTINGS EXPLAINED cccscecesceccececcececeececescscescscucescecescecscscesescusesces 45 OS PNA VR aevaccscas ce cevaet ne nenc ee ce ceuecsezenievccecsacaesaceccusceodanceutcoscausesevantuanecssuteccuecsszeasevcteceacsssubencusseeduacsuacescoucesecest 52 USNOLOSTANALY ZER onenn iani AE E E E E EA ETENEE 53 Contents Datalnsight Web v4 2 User Guide ii SAVNE VOUT WOTKDOOK sirier OEE AAEE TE EA 56 PURCHASING ANALY ZER asioucssecuevshuccwcucasseecseccccusnccsecasvsanecxauexege EAA VESE EANES E ORAE Eaa 58 USING PURCHASING ANALYZE R myisi arnari ania a a a n a a a a a a 59 USING SMART DA TAG ROUBS aneo ae eaS A OOE O OTOA 62 PREVIEWING SMART DATAGROUP LAYOUTS vic ceswsisacs ia tanceacataecesSetniueaea a ceca tater a E N 62 SMART DA TAGROUP OPTIONS urrina EE RA aesciceosnaunaaaicaaiaus cae ace ce aaa 64 smart Datagroup TCONS and OPO eas diac Nati eh tetas yeas aati ees ea ee ee eet 65 Smart Workbook Preferences and Settings vices eke AGRA 70 Global Preferences and Smart Workbook Settings Explained 0 cccccccssssssessceeececeeeceeeeeaeeseesseeeeeeeeceseeeeeeasaeaeseseeeess 71 SMART DATAGROUP CRITERIA SELECTION gschaces sevaisues i an aa a a a e 79 TEC OENE M ERU a E ET E A TOET E EEE E E E E ET SO WOKING wilh CUSTONE ETUTU crass te EE aE E sd chaste esata ET EE EEE E ENTE 8l CUS COM E eO CON S eree E
87. tatistics Select any statistics you vould like applied to the selected series Percent Change Jv Percent Change Year Ago gt Grouping Group output by country or concept f By country f By concept 54 4 Select if you want a composite index name it make your selections and apply weights to 1t Cost Analyzer Composite Index Composite Index 4 composite index can be created by applying weights to existing series W Create a composite index Mame hy PPI Index Base Date 2011 G1 Base Frequency QUARTERLY Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide 59 Cost Analyzer Apply Weights Apply Weights Check the series to include in your composite index and enter weights Weights Short Label Geography W i 10 100 United States PPI General Industrial Machine United States al Cost Analyzer Ready Ready Create Workbook or download Your choice Save Series as a workbook to use again in tuture Download the data right away veithout saving Create Workbook Excel Download x Cost Analyzer Workbook Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide Saving Your Workbook Cost Analyzer Ready Ready Create Workbook or download Your choice Save series as a workbook to use again in future Download the data right away without saving Create Workbook Excel Download x Workbook Cost Analyzer Workbook crea
88. ted Take me there 56 When you click Save you have the option of loading the table into DataInsight Web by clicking Take me there or not by clicking Close Cost Analyzer Ready Ready Create Workbook or download Your choice Save Series as a workbook to use again in tuture Download the data right away veithout saving Create Workbook Excel Download x Workbook Cost Analyzer Workbook created Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide 57 In DataInsight Web you can change the name of the workbook name and modify your index if you selected one and manipulate the table easily using the options provided Cost Analyzer Workbook 4 Series 10 years history before today Fl 10 years forecast after today index Frequency QUARTERLY Hy PFI Index j H j ARTI BE index Name Base Period 2011 Qi Base Frequency quar ERL Series Lit Data Table Composite index Weghts j Source Series Type Series Status eS Sa ee ESS ESS E 2 PCHYA wW 3 10 100 BLS Global Insight Forecast Cost E i PLAYA BLS Global mnaighi Forecast x p D Y Export Selected Export All Functions Coumns Settings See Preferences and Settings Exporting Data to Excel and Applying Functions to Data for more information about the Cost Analyzer screen elements Cost Analyzer Using Cost Analyzer Datalnsight Web User Guide Purchasing Analyzer 58
89. the top node in that dimension My Concepts for example Concept My Concepts 4 Output amp Input 4 Investments and Profits 4 Domestic Consumption amp External Trade Price Indices Indicators of Sector Risks 2 A My Concepts dialog appears for your selections Select the type find your selections in the tree name your concept and click Save a Output amp Input a Investments and Profits a Capital Expenditures Capex a Depreciation Profits W Operating Profits Gross Nomina Index of Gross Operating Profits Nominal a Operating Profits Gross Real Index of Gross Operating Profits Real l Net Operating Profits net of depreciation Nominal Index of Net Operating Profits net of depreciation Nomina Aggregation Method Lustom Formula Guide to Types Group Two or more selections that make up a unit Aggregate A unit of two or more selections taken into account as a whole by using a mathematical operator on the components Formula A unit of two or more selections made into an expression by using a customized formula on the components Using Smart Datagroups Smart Datagroup Criteria Selection Datalnsight Web User Guide 83 3 Your custom criteria will be available under the My node for subsequent sessions of the smart datagroup Concept Modifying or Deleting a Custom Criteria Selection To modify a custom concept geography or industry 1 Cl
90. tions to Data for more information Allows you to add new series to the series list This feature opens the Add Series by Mnemonic dialog and allows you to type or paste series mnemonics into it This feature also verifies that the mnemonics that you add are correct by looking for them in our database and in the series list before added them there Results 4 series found Results 4 series found 4 already exist in workbook Mo series added to workbook See Applying Series to Workbooks by Mnemonic for more information Depending on your browser configuration you may be prompted to open or save the Excel document Exports the series of the open workbook to Excel and opens Excel when you choose the Open button File Download Do you want to open or save this file Name CPI 2009 10 08 xls HI Type Microsoft Excel Worksheet 16 0K6 From div ihsglobalinsight com Open NI Save While files from the Internet can be useful some files can potentially harm Your computer IF you do not trust the source do not open or save this file What s the risk Toggles the orientation of the table Values Down Viewing Data Option Icons for the Series List and the Data Table Views Datalnsight Web User Guide 19 WEFA BANK NAME 5 SERIESTYPE START DATE END DATE LAST UPDATE WEFA SERIES NAME DRI SERIES NAME FREQUENCY SHORT LABEL Values Across J d om I re i 5 i i i i l 4 71
91. ts E Z Economic indicators US Economy 1 14 2014 Source Q US Regional E e Gibal Regiona b SMART DATAGROUPS T SAVED TEMS b Vorkbooks b QJ Tables population gt Ea PROE Showing 1 to 20 from 118 results i eee Concept Geography Frequency a A E E E Female afghanistan ANNUAL Hale Afghanistan ANNUAL Women Ages 15 49 Afghanistan AHHUAL Crude Death Rate Afghanistan ANNUAL ears 04 amp ighanistan ANNUAL itart Date 1950 Ra ind Date 2050 Page ilor Hl ast Update 2008 07 21 m om UA O CO Ay Save Selected Save l Export Selected Export All Columns Preferences To retrieve time series data 1 Pick a Datagroup and the Available Criteria drawers will appear for that source 2 Click on the checkbox in front of your selections and they will appear in the Selected Criteria panel on the right 3 Optionally filter frequencies and scenarios by making selections from the corresponding buttons on the right Oo Q Frequency and Scenario 4 Now click on Go to view the results of your query Finding and Selecting Data Category Search Datalnsight Web User Guide 6 Table Browser The Table Browser allows you to browse view save and export from a library of service specific pre defined tables Using the Table Browser 1 Make your selections from left to right by clicking on them once As you click a list of choices for each selection appears in a new column to the right as you drill down
92. ve to TODAY it does not determine the data edge of individual series Start Date be Custom Start Date First available value f 20 observations before today O 20 observations Upto end date Fixed date 26 Jul 2010 E First available value Select to export time series data beginning with the first observation of the data that exists in our database Number of values before or after today Enter the number of observations years quarters or months to export starting with today and going back into time for historical data or ahead into the future for forecast data Number of values up to end date Enter the number of observations years quarters or months to export going back into time from the end date you specify in the following section Fixed Date Enter an end date or select it by clicking once on the date and using the calendar tool provided Preferences and Settings Global Preferences and Workbook Settings Explained Datalnsight Web User Guide 4 Advanced Default order for Category Search aff sui 2010 z Su Me Tu We Th Fr Sa f Fixed date 26 Jul 2010 4 J 4 5 6 T 8 g 10 1i Az WS A4 15 7 Ar 18 19 20 21 22 233 M 25 26 27 28 25 30 31 End Date End Date Last value f Today p nan E Retore oy O Fixed date 26 Jul 2010 Last value Select to export time series data ending with the last observation of the data that exists in our database Toda
93. x to disable this feature See Generating a Smart Datagroup Report for more information Billing code Billing Code optional An optional billing code which is recorded during your data usage and can be used to track data usage for billing purposes for those users that accrue data usage related charges Note about Billing Codes and Sharing The billing code comes from the source workbook when the source workbook has a workbook level billing Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 72 code specified using the button at the bottom of the screen Examples Scenario 1 You set the billing code at the workbook level and the billing code appears on the Advanced tab for workbook settings Workbook Settings Advanced Workbook Aruba RG Use application defaults Use these settings Billing Code optional 4507111 Users that share this workbook with you will see your billing code on its Advanced tab for workbook settings Workbook Settings Advanced Workbook Copy of Aruba RO Use application detauits Use these settings Billing Code optional 4507111 Scenario 2 You assign a billing code to all your workbooks as a default using global preferences and the billing code appears on the Advanced tab for your selected workbook T Log out Feedback T Help Using Smart Datagroups Smart Datagroup Options Datalnsight Web User Guide 7
94. y Select to use today s date as the end date Number of values before or after today Enter the number of observations years quarters or months to export starting with today and going back into time for historical data or ahead into the future for forecast data Fixed Date Enter an end date or select it by clicking once on the date and using the calendar tool provided f Jul 2010 z Su Me Tu We Th Fr Sa Fixed date 4 2 3 4 5 6 Ff B g 10 11 Az Ws f4 AS 6 A7 18 19 20 21 22 233 M 25 26 27 285 295 30 31 Default order for category search Concept Alphabetically f Concept Order in Tree When ordering series by concept by clicking on the column header to sort ascending or descending the default behavior is to sort alphabetically This control lets you change the sorting behavior so that sorting is not done alphabetically but is done by the order of the concept in Available Criteria in category search For example if concepts appear in category search in Available Criteria in this order Sales Cost of Goods Sold Gross Profit Preferences and Settings Global Preferences and Workbook Settings Explained Display mnemonics preferences Non Refreshabl e Sheets Datalnsight Web User Guide 48 Expenses Net Profit this preference when set for Concept Order in Tree will display results in this same order not alphabetically Display mnemonics preferences Use DRI Mnem

Download Pdf Manuals

Related Search

Related Contents

DSC-HX5  Modelo 2040    Severin AT 2516 toaster  USER'S MANUAL    User Manual TeraStation iSCSI TS  MAN-VP-SINLINE-U K - Innovative Instruments    indoor positioning with a view to team sport track- ing  

Copyright © All rights reserved. Failed to retrieve file