Category Archives: Business Information

Zanran – great for data in tables, charts and graphs

I regularly mention Zanran (http://www.zanran.com/) in my workshops on search and business information, and it often finds its way into the Top Tips compiled by the delegates at the end of the day.

Zanran is not a Google alternative. Rather than search the text of web pages it extracts and indexes numerical data presented as tables, charts and images in PDF reports, spreadsheets and ordinary web pages. You can simply type in your search terms but there are additional options for narrowing down the search by location of the web server, specifying an individual site, selecting a time period and limiting by file type.

The results page lists the files it has found with an extract highlighting the content containing your terms. In this example I am looking for data on agricultural methane emissions in the UK.

Zanran search results

To the left of each entry is a thumbnail. Moving the cursor over the thumbnail brings up a preview of the page containing the relevant chart, table or image. This enables you to immediately assess the relevance of the data without having to download and go through a lengthy document.

Zanran document preview

If you click on the thumbnail or the title to view the whole document you have to register (free of charge) as copies of the indexed documents are stored by Zanran. If you prefer to go to the original document click on the URL button attached to the summary of the page 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 them down. Registering with Zanran is by far the easier option. Also, rather than deluge you with documents from a single site, as Google all too often does, Zanran gives you a link telling you if and how many other results are available on a site.

How does it compare with Google? Well, Google did come up with relevant results for my search but I had to spend a lot of time ploughing through them to identify the best documents. And Google did not pull up in the first 100 results the very useful archived UK government documents that Zanran gave me.

Google v Zanran

If you are looking for data or statistics Google still does a very good job but I recommend you also run a  search in Zanran. It may well come up with a real gem, as it often has for me.

 

Information on companies in Israel

All companies in Israel must register with The Registrar of Companies at the Ministry of Justice (http://www.justice.gov.il/MOJEng/) and the tax authorities. The register can be searched at http://havarot.justice.gov.il/ using part or all of a company name in English or Hebrew, or by entering the company number.

Israel - Register of Companies

The search interface and the results are in Hebrew but if you are using Google Chrome the built-in translator does a reasonable job of translating the text into English.

Israel Company Register search  translated

Free information on a company includes type of company, address, legal status and purpose of the company.

Israel Company Register free information

Additional information such as details of directors, total authorized capital, division of share capital, shareholders, charges and liabilities is priced. It is at this point that the Google translation starts to fail, so if you need more than just confirmation that the company exists it is best to use a commercial service that can run your search and translate the documents. One such company is IsraelBizReg (http://www.israelbizreg.com/).

IsraelBizReg is a division of KYC Israel, an Israeli due diligence firm. They offer English translated company reports in three formats: basic, detailed, and a full company file. You can search the database free of charge to see if your company is in the register. If you cannot find it IsraelBizReg will perform a company search free of charge. The basic report costs $50, detailed is $100 and the full company file is $150.

IsraelBizReg

Another company that provides similar services is UK based 7Side (http://www.7side.co.uk/). Like IsraelBizReg it is pay as you go and they offer a translation service.

7Side International Data and Documents
7Side International Data and Documents

A summary of what is available and the costs involved for International Registry Documents and Reports all available in 1 hour is at http://www.7side.co.uk/moreinfo/International_Registry_and_Documents_Service.pdf.

The price list for English translated International company overviews is at http://www.7side.co.uk/moreinfo/marksales/7Side_ICO_Reports.pdf.

ICAEW’s gateways and guides to business information

There are many excellent business resources on the web but finding them is not always easy, and Google does not always come up with the best and most relevant. This is where gateways such as the ones compiled by the Institute of Chartered Accountants in England and Wales (ICAEW) come into their own. Their Library and Information Service have pulled together a number of guides on topics such as international company registration, SMEs, startups, country resources and industry guides.

International company registration
http://www.icaew.com/en/library/subject-gateways/business-management/company-administration/knowledge-guide-international-company-registration

The guides cover official and unofficial information sources from the print collection of the ICAEW Library & Information Service and recommended websites on the internet. Some resources are for members only but many sections are open to all. It is worth spending some time working your way through the menus to get an idea of the range of information that is available.

The Library and Information Service main page is at http://www.icaew.com/en/library

PNC Christmas Price Index Surges 4.8 Percent In 2012

Prices for six items in “The Twelve Days of Christmas” song on par with 2011, but drought causes swans and geese prices to soar 

Christmas has many traditions and one of the more recently established ones is the Christmas Price Index compiled by PNC Wealth Management.

The 29th annual survey reveals that an improving US economy coupled with a severe drought that caused increased feed costs for large birds resulted in a 4.8 percent surge in the 2012 PNC Christmas Price Index. Based on the gifts in the holiday classic, The Twelve Days of Christmas,” the price tag for the PNC CPI is $25,431.18 in 2012, $1,168 more than last year.

“The rise of the PNC CPI is larger than expected considering the modest economic growth we’ve had over the past 12 months,” said Jim Dunigan, managing executive of investments for PNC Wealth Management. “Despite some weak spots in the economy, consumer balance sheets are improving along with consumer confidence, which means this may still be a spirited holiday season.”

PNC Wealth Management also tabulates the “True Cost of Christmas,” which is the total cost of items gifted by a True Love who repeats all of the song’s verses. True Loves must spend over $107,300.24 for all 364 gifts, a 6.1 percent increase on last year.

PNC Christmas Price Index 2012

Swans rose by 11.1 percent whilst six items (the Partridge, Two Turtle Doves, Four Calling Birds, Eight Maids-A-Milking, Nine Ladies Dancing and 10 Lords-A-Leaping) remained the same price as last year.

The prices for 11 Pipers Piping ($2,562.00) and 12 Drummers Drumming ($2,775.50) are up 5.5 percent

The Three French Hens were up 10.0 percent and the Five Gold Rings soared 16.3 percent.

As the only unskilled labourers in the PNC CPI the price for the eight Maids-a-Milking is represented by the minimum wage. With the US minimum wage flat at $7.25 per hour hiring the maids this year will not increase labour costs.

For those True Loves who prefer the convenience of shopping online, PNC Wealth Management also calculates the cost of “The Twelve Days of Christmas” gifts purchased on the Internet. True Loves will pay a grand total of $40,440 to buy the items online, which is 1.5 percent more than last year and almost $580 more than this year’s traditional index.

In general, Internet prices are higher than their non-Internet counterparts because of premium shipping costs for birds and the convenience factor of shopping online,” Dunigan said.

The full press release is at http://pnc.mediaroom.com/index.php?s=3473&item=133834 and the index itself  is at http://content.pncmc.com/live/pnc/microsite/CPI/index.html. The site includes an interactive scavenger hunt where visitors can take a trip around the world to locate the 12 gifts of Christmas.

Historical data can be downloaded as a spreadsheet from:

http://content.pncmc.com/staging/pnc/microsite/CPI/2012/downloads/PNC_CPI_Historical_Data_2012.xlsx

Top tips for business information

Here are the Top Tips for business information compiled by the participants of my latest business information workshop held on November 15th, 2012 in London. The set of slides that was the starting point for the workshop can be found on authorSTREAM at http://www.authorstream.com/Presentation/karenblakeman-1601945-business-information-key-web-resources/

  1. Zanran http://zanran.com/ A search tool for  identifying charts, graphs and tables of data 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. Very useful if you are looking for industry statistics.

Zanran

  1. University library subjects guides. If you are looking for some good starting points on a subject seek out some university library subject guides. These list resources that are only available to their own students and staff but may also include links to relevant publicly accessible resources that have been assessed for quality.
  2. Socialmention http://socialmention.com/ Several social media search tools were covered in the workshop but this one received a special mention as a good general all round social media tool. It covers images, blogs, Twitter, Facebook, audi0 and bookmarks. If you are monitoring a topic you can set up email and RSS alerts.
  3. Companies House http://www.companieshouse.gov.uk/ The official registry for UK companies. Other services such as Company Check (http://companycheck.co.uk/) and DUEDIL (http://www.duedil.com/), which repackage Companies House data, may provide more information free of charge but it is always worth double checking with Companies House to see if there is more up to date information and to get a full of list of the documents that are available on a company. The history and list of documents that can be ordered for a company is informative in itself. On the Companies House web site use the Find Company Information to locate the company in the register and then click on “Order information for this company”. You will then see a list of available documents. Titles such as “Struck off and dissolved” and “Application for administrative restoration” would suggest that perhaps you ought to investigate further before doing business with the company.
  4. LinkedIn groups A couple of the workshop participants regularly use LinkedIn groups for research questions. Look for groups set up by professional and official bodies relevant to your subject.
  5. Twitter If you are looking for a professional, research or trade association that may be able to help with your research you only need to find just one organisation on Twitter covering your topic. Then, to find others that might be useful, see who that organisation is following.
  6. Millionshort http://millionshort.com/. If you are fed up with seeing the same results from Google again and again give Million Short a try.  Million Short runs your search and then removes the most popular web sites from the results. Originally, as its name suggests, it removed the top 1 million but the default has changed to the top 10,000. The principle remains the same, though.  Exclude the more popular sites and you could uncover a real gem. The page that best answers your question might not be well optimised for search engines or might cover a topic that is so “niche” that it never makes it into the top results.
  7. Biznar http://www.biznar.com/ Biznar is a federated search engine that runs your search in real-time in about 70 resources. There is a list on the Advanced Search screen where you can deselect individual or groups of resources. The results are combined into a single list and organised on the left hand side of the screen into folders such as Topics, Authors, Publications, Publishers and Dates. These are computer generated but can help you narrow down your search. A bit erratic at times and sometimes comes up with odd results but people still thought it was worth including in the Top Tips list.
  8. DUEDIL http://www.duedil.com/. This service repackages Companies House data and provides some of it free of charge. The feature that won DUEDIL a place in the Top Tops is the “Group” visualisation that illustrates the connections between the company you are researching, its parent companies and subsidiaries. You have to create an account (free at the moment) to access all of the information.

DUEDIL

  1. SCoRe http://www.score.ac.uk A catalogue of current and historical printed company reports held in UK libraries. The catalogue does not provide links to digitised documents but is a very quick and easy way of identifying libraries that hold hard copy reports. The participating libraries include London Business School, the British Library, Manchester Business School, City Business Library, Guildhall Library, Strathclyde University and the University of Warwick. A full list is available at http://www.score.ac.uk/collections.asp.

Company information: Luxembourg and Belgium

I am updating the official registries section of  my business sources listings (http://www.rba.co.uk/sources/registers.htm) and there are changes to the entries for Luxembourg and Belgium.

The Registre de Commerce et des Sociétés – Accueil (http://www.rcsl.lu/) is the official register of companies and associations in Luxembourg. The search options are limited to company name or number and the interface is in German and French. Searching and company name, address and contact details are free of charge. Documents are priced.

Legilux Sociétés et Associations has more search options at http://www.legilux.public.lu/entr/search/index.php and it provides a history of the documents filed by a company. This is a free service but for the documents themselves you have to go back to the Registre de Commerce et des Sociétés where there is a charge per document.

In Belgium the KBO Public Search (http://economie.fgov.be/nl/ondernemingen/KBO/Pubd/PuS/)
enables you to search for public information on every registered active enterprise and establishment. Search by company number, name, branch number or name, address and municipality. Each record provides name, company number, activities, address, contact details and links to other sites for official documents and annual reports. The search interface is available in Dutch and French. The information is in Dutch or French and is free.

The CBSO (Central Balance Sheet Office) section of the National Bank of Belgium (http://www.bnb.be/) has the accounts of companies, associations and foundations active in Belgium. The search interface is available in Dutch, French, German and English and the services is free.

Many thanks to Inez de Bois for the information and updates.

Doing Business in the United Kingdom and France

Compiled and published by Bryan Cave LLP, Doing Business in the UK is an excellent summary of what is involved in setting up a business in the UK and the associated legislation. As well as describing the various types of company it also covers director’s duties, UK taxation, employment law, business immigration, intellectual property, data protection and competition law. There is a similar publication on Doing Business in France. Both are free of charge.

Business information key web resources presentation

This is the presentation that formed the basis of the business information workshop that I facilitated on 17th May 2012.

If you do not see the embedded presentation above you can go direct to the file on authorSTREAM at http://www.authorstream.com/Presentation/karenblakeman-1430353-business-information-key-web-resources/

The top tips can be found at http://www.rba.co.uk/wordpress/2012/05/28/business-information-workshop-top-tips/

Business Information Workshop – Top Tips

The TFPL business information workshop held on May 17th in London turned out to be quite an intense day with plenty of questions and much discussion between the participants regarding the services and resources they use. When it came to the participants nominating their Top Tips at the end of the day there was a bit of umming and ahhing initially but they soon picked up speed and we ended up with eleven. Here they are.

1. BL BIPC industry Guides The British Library Business Information and IP Centre’s industry guides were very popular. You probably already know about the BL Business Essentials wiki Industries pages (http://bl-business-essentials.wikispaces.com/Industries) but these have now been expanded into a series of 30 PDF guides at http://www.bl.uk/bipc/dbandpubs/Industry%20guides/industry.html highlighting relevant industry directories, databases, publications and websites. One of the participants who had been using the guides since they were launched said that they are regularly updated and everyone was impressed that a named person responsible for the guide is clearly shown on each one.

2.  Zanran  http://zanran.com/ A search tool for  identifying charts, graphs and tables of data in PDFs and Excel spreadsheets. Run your search and Zanran comes up with PDF and spreadsheet files that match your criteria. Very useful if you are looking for industry statistics.

3. Slideshare http://www.slideshare.net/ Looking for a conference presentation, an expert on a particular subject, overview or background on an industry then look in Slideshare. One workshop participant commented that they wished they had known about this a couple of weeks ago.

4.  SCOTBIS  http://scotbis.nls.uk/  A national information service aimed at Scottish businesses and based on the business resources at the National Library of Scotland but, nevertheless, useful information for those of us not based in Scotland. SCOTBIS provides its users with a free enquiry service and also offers fee-based research and other charged services.

5.  Don’t just Google – try other search tools! If you are carrying out a general web search don’t just Google. You may find the information you are looking for more quickly using alternatives such as Bing.com, DuckDuckGo.com, Yandex.com, Blekko.com

6.  Advanced search commands. Familiarise yourself with the advanced search commands, in particular ‘site:’  for searching within a single site and ‘filetype:’. Look for PowerPoints for presentations, spreadsheets for data and statistics, or PDF for research papers and industry/government reports. Note that filetype:ppt will not pick up the newer .pptx so you will need to include both in your search, for example.

filetype:ppt OR filetype:pptx

You will also need to include .xlsx if you are searching for Excel spreadsheets and .docx for Word documents.

7.  BUSLIB-L  – an email based discussion list that addresses all issues relating to the collection, storage, and dissemination of business information regardless of format. To join the list, go to http://list1.ucc.nau.edu/archives/buslib-l.html where there are also searchable archives.

8.  Bureau van Dijk’s M&A Portal http://www.mandaportal.com/ A gateway to news, events, research and analysis on mergers and acquisitions worldwide. Some of the information on the portal home page is free of charge and there is a free search option for tracking down deals and rumours contained in BvD’s Zephyr database. The deals can be sorted by value, date or status. Basic information is free but you can purchase the full details from the Zephyr database using a credit card. The cost of the reports varies depending on the amount and type of information available.

9. Mergers and Acquisitions Review (Thomson Reuters). This was recommended by one of the workshop participants. Free quarterly summaries and reviews of M&A activity, for example http://dmi.thomsonreuters.com/Content/Files/4Q11_MA_Legal_Advisory_Review.pdf and http://dmi.thomsonreuters.com/Content/Files/4Q11_MA_Financial_Advisory_Review.pdf

10. Official Company Registers. A first port of call for many of us when checking up on a company. Most registers’ sites will offer an English language interface for searching but the information is usually in the local language. To locate searchable online official registers try one of the following:

http://www.rba.co.uk/sources/registers.htm

http://www.commercial-register.sg.ch/home/worldwide.html

http://www.companieshouse.gov.uk/links/introduction.shtml#reg

11. ISI Emerging Markets http://www.securities.com/ Provides news, company information, industry reports and M&A from over 100 emerging markets. Much of the content is unique to ISI Emerging Markets. This was another service that was highly recommended by one of the workshop participants.

Useful industry information guides from the British Library BIPC

Evaluated listings and subject guides from people who know the sectors are the quickest way to home in on good quality sources of information. The British Library Business and IP Centre (BIPC) has, for a long time, had a wiki at http://bl-business-essentials.wikispaces.com/Industries listing web-based resources on a number of industries. These have been expanded into a very useful series of 30 PDF guides at http://www.bl.uk/bipc/dbandpubs/Industry%20guides/industry.html highlighting relevant industry directories, databases, publications and websites.

 British Library Business & IP Centre Industry Guides

All of the guides show when they were last updated and the name of the person who has edited the guide. Not all of the resources are freely available on the web but you can access the information for free in the Business & IP Centre at the British Library, St Pancras. You will need a Reader Pass; details on how to obtain one can be found at http://www.bl.uk/bipc/visitus/howtouse/index.html.

The resources are split into Directories, Business Advice Sources, Market Research and Statistics, Trade Magazines and Newsletters, and Internet Resources. Even if you cannot make it to the BIPC to access the publications these guides are valuable pointers to the key sources of information on industry sectors. Highly recommended.