Category Archives: Business Information

Statista: statistics, industry and market data

Statista (http://www.statista.com/) is a portal for statistics, market data, market research and survey results. It aggregates data on over 600 international industries from more than 18,000 sources, including market researchers, trade organizations, scientific journals, and government databases. You can get a rough idea of what the service covers from the list of topics at http://www.statista.com/topics/, although this does give the impression that it is heavily US biased, which is not the case.

Searching Statista is straightforward. The default is to include what it calls word fragments, so a search on the term bank will also find banking. This can be changed to identical words if you require an exact match. To search for phrases place double quote marks around your terms, and documents containing a specific term can be excluded by prefixing the word with an exclamation mark. You can ‘OR’ terms by inserting the vertical bar symbol (|) between them, for example dog | cat. To refine your search further use the options on the right hand side of the results page. These include date of publication, region, free/fee-based/all, and category.

Trying to view the data and charts that you find can be a frustrating process as most of the information is only available on subscription. There is a limited amount of free information but you still have to register for what Statista calls its basic free access. The premium account for an individual user is USD 49/month and runs for a minimum of 12 months. This is automatically renewed so make sure you cancel before the year is up if you no longer wish to use it. The corporate subscription is USD 199.90/month. Again the subscription runs for 12 months. A free trial is available for the corporate service but not for individual users. Prices for universities, libraries and education are available on request.

On the results page you can easily identify the subscription content by the red plus sign next to the chart icon to the left of the result. A red ‘P’ indicates a priced report that is free to corporate clients but can be purchased by basic and premium account holders.

Statista Results Page

Clicking on a result takes you to a page where the data is displayed as a chart or graph depending on what Statista thinks is the most appropriate for that statistic, but you can change the representation if you wish. There are also options for downloading the data in various formats and links to the original source.

Statista chart and download options

Information is provided on the source and includes title of the original document, the publisher, publication date, time period covered by the survey and the geographical regions covered. Statista also adds notes such as definitions of terms used in the original report and observations on possible missing data.

Statista metadata and report information

Much of the information on Statista can be found by via Google or Bing using advanced search commands and options, but you will probably have to wade through a significant amount of irrelevant information before you find the data you need. Statista can certainly save you a considerable amount of time, and the data displays are a great way of helping you identify the potential usefulness of a report, as can the metadata and notes.

Is the subscription worth it? It is definitely cost effective for corporates in terms of saving search time and ensuring accuracy and quality of information. I have had good feedback about Statista from several of my clients. I am not so sure about individual users. Some of my own research is highly specialised and I am not convinced that Statista covers all of the areas of interest to me. It is difficult for me to assess its value without trialing the full service first, and there are no pay as you go options such as a day or weekly rate. I might even consider paying for a month’s access for a project but it is a full year’s subscription or nothing. Nevertheless, I recommend you take a serious look at it and if you are contemplating a corporate subscription you can ask for a free trial. It is now on my list of essential research tools.

Top Tips from SWAMP

Swansea_20130624_400
View from Swansea Central Library

Towards the end of June I headed off to Swansea Central Library to facilitate a workshop on search tools and techniques for finding business information and statistics. The session was organised for the libraries of the wonderfully named SWAMP – South West and Mid Wales Partnership.

We had fantastic views from the library of the sea and shore line so they did very well to remain focused on the work in hand. The top tips that the group suggested at the end of the day were a mixture of search techniques and business information sites.

1. Persistence.
Don’t give up and don’t get stuck in a rut. If your first attempts fail to produce anything useful try a different approach to your search. Try some of the tips mentioned below: use advanced search commands, a different search tool or go direct to a website that covers your subject area or type of information.

 2. Verbatim.
Google automatically looks for variations on your search terms and sometimes drops terms from your search without telling or asking you. To beat Google into submission and make it run your search exactly as you have typed it in, click on ‘Search tools’ in the menu above your results, then click on the arrow next to ‘All results’ and from the drop down menu select Verbatim.

3. Private Browsing.
To stop search engines personalising your results according to your previous searches and browsing behaviour, find out where the private browsing option is in your browser (in Chrome it is called Incognito). This ignores all cookies and past search history and is as close as you can get to unfiltered results.

Short cuts to private browsing in the main browsers are:

Chrome – Ctrl+Shift+N

FireFox – Ctrl+Shift+P

Internet Explorer – Ctrl+Shift+P

Opera – Ctrl+Shift+N

Safari – click on Safari next to the Apple symbol in the menu bar, select Private Browsing and then click on OK.

4. The site: command.
Include the site: command in your search to focus your search on particular types of site, for example site:ac.uk, or to search inside a large rambling site. You can also use -site: to exclude sites from your search. For example, if you are searching for information on Wales and Australian websites mentioning New South Wales keep coming up include -site:au in your search.

5. The filetype: command.
Use the filetype: command to limit your research to PowerPoint for presentations, spreadsheets for data and statistics or PDF for research papers and industry/government reports. Note that in Google filetype:ppt and filetype:xls will not pick up the newer .pptx and xlsx formats so you will need to incorporate both into your strategy, for example filetype:ppt OR filetype:pptx, or run separate searches for each one. In Bing.com, though, filetype:pptx will pick up both .ppt and .pptx files.

6. Guardian Data Store (http://www.guardian.co.uk/data/)
For datasets and visualisations relating to stories in the news. This is proving to be a very popular site on both the public and in-house workshops. As well as the graphs and interactive maps the source of the data is always given and there are links to the original datasets that are used in the articles.

7. Company Check (http://www.companycheck.co.uk/)
Company Check repackages Companies House data and provides 5 years of figures and graphs for Cash at Bank, Net Worth, Total Liabilities and Total Current Liabilities free of charge. It also  lists the directors of a company. Click on a director’s name and you can view other current and past directorships for that person.

8. BL BIPC industry Guides
The British Library Business Information and IP Centre’s industry guides at  http://www.bl.uk/bipc/dbandpubs/Industry%20guides/industry.html highlight relevant industry directories, databases, publications and web sites. Excellent starting points if you are new to the sector.

9. Web archives for documents, pages and sites that are no longer “live”.
Most people know about the Internet Archive’s Wayback Machine at http://www.archive.org/and its collection of snapshots of websites taken over the years. There is also a collection of old UK government webpages at http://www.nationalarchives.gov.uk/webarchive/, and the British Library has a UK web archive at http://www.webarchive.org.uk/ukwa/.

10. Keep up to date
Keep up to date with what the search engines are up to, changes to key resources and new sites. Identify blogs and commentators that are relevant to your research interests and subject areas and follow them using RSS or email alerts.

Company Check: free UK company and director information

Company Check (http://companycheck.co.uk/) and its sister website Company Director Check are two of the more popular services on my business and search workshops. They repackage official information from Companies House and provide much of it free of charge. I first reviewed them in 2011 (http://www.rba.co.uk/wordpress/2011/07/20/company-information-company-check-gives-more-uk-data-for-free/ and http://www.rba.co.uk/wordpress/2011/11/14/free-uk-company-information-company-director-check/) and since then there have been many updates and additions. A recent change is that company and director information have been pulled together on the Company Check website making it easier to flip between companies and directors. Data on companies in Ireland is also now available.

Companies and directors can be searched from the same search box. You then select the appropriate entry from a list of possible matches. The company summary is free of charge and includes a business overview, data on its status and business activities, and a list of trading addresses.

CompanyCheck1

 

Also free of charge are the accounts and list of directors but you have to register (free of charge) to view the information. There are options for logging in with your Facebook, Twitter or Google account but if you prefer you can register a user name and password.

Five years of key financials (cash at bank, net worth, total current liabilities and total current assets) are shown as graphs and more detailed information is displayed in the Company Accounts Table.

CompanyCheck2

 

The financial statements submitted to Companies House can be downloaded free of charge as PDFs. Other documents lodged at Companies House such as “Change of director’s details” or “Allotment of securities” are listed under the Documents tab and are £2 each.

The Credit Risk information (risk score, credit limit, payment data and key factors) and Charges (mortgages and County Court Judgments) are priced. For a single company the price is £4.99 + VAT, which gives you 30 days unlimited access to all premium credit data on that company for 30 days. If you are likely to be researching more than four companies on a regular basis it is worth upgrading to the All Companies options costing £20 + VAT. This gives you 30 days unlimited access to credit data across every company and director.

Current directors and secretaries for a company are listed free of charge. Previous directors and secretaries are part of the subscription service. The free director profile includes an overview, their registered details and a summary of the companies of which they are or have been a director. This can be more informative as a way of identifying connections between companies and other directors than looking at the company records in isolation. The full director report reports are £8.99 and include credit risk, CCJs, mortgages and charges, and a summary for each current appointment with key information taken from the associated company report.

CompanyCheck3

For both companies and directors you can set up free alerts and add them to a dashboard. This is an easy way to compare results for companies, with negative and positive changes in key financials shown as red or green arrows pointing up or down.

COmpanyCheckDashboard

Company Check is not the only service providing free access to some of UK Companies House and Ireland company data. DueDil (http://www.duedil.com/) and Bizzy (http://bizzy.co.uk) are two others that are worth looking at. I understand, though, that Company Check  is working on additional services that are due for launch in the next few months. It will be interesting to see what they come up with.

Direct marketing lists for market and industry sector information

When it comes to researching a market or industry sector the major national and international players are generally well covered by the established market research publishers. If you are looking at a highly specialised sector, are interested in smaller companies or just want to know who is doing what in a town or county then direct marketing lists can be the cheaper and better option. The source I often use is a UK based service called MarketingFile.com (http://www.marketingfile.com/). They have been around for a while but continue to update their services and ensure that the databases they offer are regularly checked and cleaned.

MarketingFile’s lists are divided into business and consumer marketing and further segmented by communication channel: postal, email, fax or telemarketing lists. You can drill down further and specify key job roles, industry sectors, geographic areas and company size. For consumer lists you can segment by criteria such as geographic areas, household finances, interests, investments, cars driven and charities supported.

For each list there is information on coverage, pricing and selection criteria.

MarketigFile Selection Criteria

You have to register to search the lists but registration is free of charge. The search screen makes it easy to select and combine multiple criteria and the number of results (counts), which is sometimes all one needs to know, is free.

MarketingFile Search

The full data is charged on a per record basis and you can also opt to have only those records that include named contacts. If you are on a limited budget or want to test a sample of the data you can request a specific number of records for example 50, 100, 200, 1000.

MarketingFile have extended their services and now offer complementary services such as printing and posting of letters, postcards and inserts. They have a 100% Delivery Guaranteed offer on email and postal lists which offers 50p per item towards your postage for mail “goneaways” and 5p – 10p per item towards broadcast costs for email hard bounces.

It is not always easy to identify the most appropriate list for your research. Rather than waste time trying different lists I’d recommend that you contact their helpline, which is based in the UK. They will be able to give advice on the best strategy for your research or project.

Factiva discontinues pay as you go service

Factiva is discontinuing its pay as you go option for occasional users as part of a “strategic refocus”. Instead of an annual fee of $69 plus a per document charge of $2.95, there will now be a fixed monthly fee of $249/month. This allows you to download up to 100 documents a month with additional articles above this limit being charged at $2.95 each. The new pricing will take effect on 30th April 2013 and, for existing customers, will be payable from their next renewal date.

I have not used Factiva for over a year and, to be honest, I haven’t missed it at all. Much of my research is highly specialised and I find that I am using industry specific sources and scientific papers more and more. Nevertheless, it is a great shame that Factiva has taken this step. Many of the people I work with appreciate the quality of the service but few use it often enough to warrant the $249 monthly fee.

Thanks to everyone who sent me details of the changes.

Business information slides and top tips

My latest business information workshop, organised by TFPL, was held yesterday in London. A large chunk of the session was taken up with exploring and discussing web sites but we also looked at how advanced search options and commands can be used to focus on higher quality business information. An edited version of the slides is available on authorSTREAM at http://www.authorstream.com/Presentation/karenblakeman-1775787-business-information-key-web-resources/ and Slideshare at http://www.slideshare.net/KarenBlakeman/business-information-key-web-resources-19252576.

Towards the end of the afternoon the participants were asked to come up with a list of top 10 tips and tricks. Two more were submitted to me by email soon after, so we have a dozen in total.

1. Verbatim
Google automatically looks for variations on your search terms and sometimes drops terms from your search without telling or asking you. Neither of these are very helpful if you are looking for a company or a person. Quote marks around phrases or individual words do not always force an exact match or inclusion in the search. If you want Google to run your search exactly as you have typed it in, click on ‘Search tools’ in the menu above your results, then click on the arrow next to ‘All results’ and from the drop down menu select Verbatim.

2. Reading Level
Try ‘Reading level’ if Google is failing to return any research or business related documents for a query. Run your search and from the menu above the results select ‘Search tools’, ‘All results’ and from the drop menu ‘Reading level’. Options for switching between basic, intermediate and advanced reading levels should then appear just above the results. Google does not give much away as to how it calculates the reading level and it has nothing to do with the reading age that publishers assign to publications. It seems to involve an analysis of sentence structure, the length of sentences, the length of the document and whether scientific or industry specific terminology appears in the page.

3. Guardian Data Store http://www.guardian.co.uk/data
This section of the Guardian posts articles, charts, graphs and maps on stories in the news using official government data, datasets collected and published relevant organisations and sometimes data obtained via Freedom of Information (FoI) requests. Links to the original datasets are provided so that you can download the raw data.

4. filetype:
Use the filetype: command to limit your research to PowerPoint for presentations, spreadsheets for data and statistics or PDF for research papers and industry/government reports. Note that in Google filetype:ppt and filetype:xls will not pick up the newer .pptx and xlsx formats so you will need to incorporate both into your strategy, for example filetype:ppt OR filetype:pptx, or run separate searches for each one. In Bing.com, though, filetype:pptx will pick up both .ppt and .pptx files.

5. site:
Include the site: command in your search to focus your search on particular types of site, for example site:gov.uk. You can also use -site: to exclude a site or group of sites from your search, for example:

potato yields forecasts 2013 site:gov.uk -site:www.gov.uk

to run the search on UK government web sites but excluding the new www.gov.uk site.

6. Duedil chart
Duedil (http://www.duedil.com/)  is one of several companies that repackage Companies House data and makes some of available free of charge. The workshop participants particularly liked the company Group visualisations.

Duedil company Group visualisation
Duedil company Group visualisation

 

7. Company Check http://www.companycheck.co.uk/ and Company Director Check http://company-director-check.co.uk/
Like Duedil, both of these services repackage Companies House data. Company Check provides 5 years of figures and graphs for Cash at Bank, Net Worth, Total Liabilities and Total Current Liabilities free of charge and lists the directors of a company. Click on a director’s name and you are taken to the Company Directory Check where you can view other current and past directorships for that person.

8. RSS feeds
Several of those attending the workshop already use, or are considering using, RSS feeds as a means of monitoring events and companies. Google is closing down Google Reader but Phil Bradley has lists of alternatives at http://philbradley.typepad.com/phil_bradleys_weblog/2013/03/20-alternatives-to-google-reader.html and
http://philbradley.typepad.com/phil_bradleys_weblog/2013/03/even-more-33-google-reader-alternatives.html

9. BL BIPC industry Guides
The British Library Business Information and IP Centre’s industry guides at http://www.bl.uk/bipc/dbandpubs/Industry%20guides/industry.html highlight relevant industry directories, databases, publications and web sites. Excellent starting points if you are new to the sector.

10. Domain Tools http://www.domaintools.com/
A useful tool for identifying who owns the domain name of a web site. Alarm bells should start ringing in your head if the owner is hiding behind an agent or a privacy protection service.

11. GBRdirect http://www.gbrdirect.eu/
A single point of access to the official company registries of 22 European countries. As well as searching for companies your can search company appointments and personnel for some countries, and verify VAT numbers. The amount of information that is disclosed varies depending on the country and details of what is available is included in the price list at http://gbrdirect.eu/priceList.aspx. The information that it finds will be in the original language.

12. Numeric range
This command is unique to Google. Use it for anything to do with numbers – years, temperatures, weights, distances, prices etc. Simply type in your two numbers separated by two full stops as part of your search. For example: world oil demand forecasts 2015..2030

This workshop is being held again on Thursday, 19th September 2013 in London. The content will have changed by then – in fact, some things have already changed! – and participants are encouraged to let us know the areas and topics in which they are particularly interested and areas of research that cause them problems. This enables me to tailor the event to the needs of those attending. Hands-on practical sessions are included so that everyone has a chance to try out the sites and techniques for themselves. Further details of the day are on the TFPL website.

Workshops on business information

Zanran search on UK beef imports

A reminder that I am running two business information workshops in London in April.

The first is “Introduction to Business Research” on Thursday, 18th April. This workshop provides an introduction to many areas of business research including statistics, official company information, market information, news sources and how to build search strategies. It will cover explanations of the jargon and terminology, regulatory issues, assessing the quality of information, primary and secondary sources. Further information is available on the TFPL website.

The second is “Business information: key web resources”, which is being held the day after on Friday 19th April. This workshop looks in more detail at the resources that are available for different types of information, alerting services and free vs. fee. It also covers search strategies for tracking down industry, market and corporate reports. Details are on the TFPL website.

Both workshops include practical sessions during which you can follow the exercises provided, try out some of the enquiries you’ve recently had to tackle, or just generally explore. I am on hand during the practicals to help out with searches or advise on how to approach a particularly difficult piece of research. Be warned, though, you will be asked at the end of day to nominate, as a group, your top 10 search tips and tips. That’s when the arguments get serious!

Last year’s London workshop Top Tips are at http://www.rba.co.uk/wordpress/2012/11/25/top-tips-for-business-information/. More recently a group in Manchester came up with a very interesting combination of search techniques and business resources (see http://www.rba.co.uk/wordpress/2013/03/07/top-tips-on-search-and-business-information/).

Firmica – Slovenian company formations

I don’t usually review organisations that provide company formation services but Firmica.si  is worth a mention. As well as help with setting up or selling a business in Slovenia they provide some very useful information on procedures and doing business. The information and related content is under Frequently Asked Questions. The whole site is in Slovene so you will need to dust off Google translate, or a similar tool, if your knowledge of the language is limited.

Top tips on search and business information

Yesterday, I was in Manchester leading a workshop on search techniques and business information. As well as looking at sources of information we went through some advanced search techniques, so the the top tips that the participants suggested at the end are an interesting mix of business sites and search commands.

1. DomainTools http://www.domaintools.com/
If you want to find out who is behind a web site try Domain Tools. Type in the URL of the web site under the Whois Lookup tab and DomainTools will look for details of who owns it in the domain name registries. However, if the owner of the site really does not want to be identified they may hide behind an agent or a service such as http://privacyprotect.org/.

2. Personalise Google news  and web search for location
Personalisation of search results is not always a bad thing. Google tries to work out your location from your IP address but it does sometimes get it wrong. Or you may want to specify a more precise location so that Google gives priority to content more directly relevant to you. Run a web search and then click on the cog wheel in the upper right hand area of the screen. Select ‘Search settings’ from the drop down menu. On the the next page select ‘Location’ from the menu on the left hand side and enter a location in the box provided.

In Google News, click on the cog wheel in the upper right hand area of the page. You should then see options on the right hand side for personalising topics and below those an ‘Advanced’ link. Click on the link and on the next page go to the ‘Create a custom section’ on the right hand side of the screen. Under ‘Add a local section’ you can enter a town, city or post code.

3. Company Check and Company Director Check
http://companycheck.co.uk/ and http://company-director-check.co.uk/
These related sites repackage data from Companies House and offer access to a lot of it free of charge, although you will have to register to some of it. Company Check provides 5 years of figures and graphs for Cash at Bank, Net Worth, Total Current Liabilities and Total Current Assets. You can also download accounts, and monitor a company for financial changes or for when new accounts are filed. The directors are listed and you can click through on a name to view their record on Company Director Check and see details of current and past directorships. Credit and risk reports are priced.

4. Zanran http://zanran.com/
This is a search tool for searching information contained in charts, graphs and tables of data and within formatted documents such as PDFs, Excel spreadsheets and images. Enter your search terms and optionally limit your search by date and/or format type. Zanran comes up with a list of documents that match your criteria with thumbnails to the left of each entry. Hover over the thumbnail to see a preview of the page containing your data and further information on the document. If you click on the title to view the whole document you may have to register (free of charge) as the title link sometimes takes you to copies of the indexed documents that are stored on Zanran. If you prefer to go to the original document click on the URL button next to the summary of the page in the results and click on the link that is then revealed. Unfortunately, you may see “page not found” especially if it is on a UK government department web site. Many of these have now been closed and their content archived making it difficult to track down the document.

5. intext:
Google’s automatic synonym search can be helpful in looking for alternative terms but if you want just one term to be included in your search exactly as you typed it in then prefix the word with intext:. For example UK public transport intext:biodiesel. It also stops Google dropping that term from the search if it thinks the number of results is too low. 

6. filetype: to search for document formats or types of information
For example PowerPoint for experts or presentations, spreadsheets for data and statistics, or PDF for research papers and industry/government reports. Include filetype immediately followed by a colon (:) immediately followed by the file extension in your search strategy.

For example

waste vegetable oil energy generation filetype:pptx

Note that filetype:ppt will not pick up the newer .pptx so you will need to run searches on both. You will also need to look for .xlsx if you are searching for Excel spreadsheets and .docx for Word documents. The Advanced Search screen file type box does not search for the newer Microsoft Office extensions.

7. Google Finance for historical share prices
https://www.google.co.uk/finance
As well viewing historical graphs for share prices you can download the data as a spreadsheet. The data goes back to 1999 but you can only download one year at a time. You can change the date ranges in the boxes above the table on the Historical prices page. You can also specify a much shorter time span than a year, or put the same date in both boxes if you want a price for just one particular day. To access the data, first search for your stock on the Google Finance home page. Then from the menu on the left hand side of the screen select ‘Historical prices’.

8. Verbatim
Google automatically looks for variations of your terms and no longer looks for all of your terms in a document. If you want Google to run your search exactly as you have typed it in, click on the ‘Search tools’ in the menu above your results. A second menu will then appear. Click on ‘All results’ and then Verbatim at the bottom of the drop down menu.

9. ‘Clear’ your search options when you start a new search
If you use the menus above your results to refine your search, for example by using Verbatim or Translated foreign pages, use the ‘Clear’ option to return to the Google default. Otherwise your choices will be applied to the next search.

10. Disappearing sites and documents
Web sites close down, documents are deleted, and industry guidelines and standards are superseded. If you know the URL of where the document or page used to be try the Internet Archive Wayback Machine (http://archive.org/). Type in the URL of the page or document in the box next to the ‘Take Me Back’ button and click on the button. If it is in the database you should then see a calendar showing the snapshots and dates that are available. For UK government web sites a similar service is available at http://www.nationalarchives.gov.uk/webarchive/.

If you do not have an old URL or even a title of the document then it is time to start hunting around to see if it has been archived by a different web site. One of the workshop participants gave the example of trying to track down old engineering specifications and lapsed industry guidelines on deep sea oil exploration. The standard Google search techniques were not working. Thinking that Norwegian oil companies have a lot of expertise in this area, they changed the strategy to searching Norwegian web pages and used Google’s ‘Translated foreign pages’ search option (Click on ‘Search tools’ in the menu above the results, then ‘All results’ and select ‘Translated foreign pages’. Archive copies of the original documents, which were in English, were found!

Forthcoming workshops

I am running three workshops in April on business information and search. All three have a practical element so that you can try out resources and techniques for yourself.

Introduction to Business Research

This is being organised by TFPL and will be held in London on Thursday, 18th April. This course provides an introduction to many areas of business research including statistics, official company information, market information, biographical information and news sources. It will cover explanations of the jargon and terminology, regulatory issues, assessing the quality of information, primary and secondary sources. Further information is available on the TFPL web site at http://www.tfpl.com/services/coursedesc.cfm?id=TR1116&pageid=-9&cs1=&cs2=f

Business information: key web resources

This is also being organised by TFPL in London and is being held on Friday, 19th April. This workshop looks in more detail at the resources that are available for different types of information, alerting services and free vs. fee. It also covers search strategies for tracking down industry, market and corporate reports. Further information is available at http://www.tfpl.com/services/coursedesc.cfm?id=TR945&pageid=-9&cs1=&cs2=f

Make Google behave: techniques for better results

This is a very popular workshop and is being organised by UKeiG. It is being held in Manchester on Tuesday, 30th April.

Topics include:

  • How Google works
  • Recent developments and their impact on search results
  • How Google personalises your results and can you stop it?
  • How to use existing and new features to focus your search and control Google
  • How and when to use Google’s specialist tools and databases
  • What Google is good at and when you should consider alternatives

The workshop will be repeated in London on Wednesday, 30th October. Details and booking information are on the UKeiG website at http://www.ukeig.org.uk/trainingevent/make-google-behave-techniques-better-results-karen-blakeman