Google acquisitions samples with vizualizations

Categories: Excel Functions

Google has acquired around 184 companies as of October 2015, with its largest acquisition being the purchase of Motorola Mobility, a mobile device manufacturing company, for $12.5 billion. Not all the acquisition figures are available but aggregating all the public known amounts, Google has spent atleast 28 billion USD on acquisitions.

With the recent re-structuring, Google became a subsidiary of Alphabet Inc., which now owns most of the parts.

Using infocaptor dashboard software, we analyze the list of companies, products and services that Google has acquired since 2001.



How To Create a Pivot Table For Your Dashboard


When creating a dashboard it usually helps to have as many options as possible available to you. While most users know how to create common and standard tables and charts, there are a number of additional charting and tabling features available in Excel which are often neglected by inexperienced users. A Pivot Table is one such feature.

Pivot Tables allow users to flip the columns and rows of the table to provide detailed information on certain aspects of your data. For example these tables can be used to summarize and analyse data in a number of ways. They can also be used to present data in a customisable layout, with calculations and subtotals. There really is a wide variety of uses to which pivot tables can be put, and it is worth spending some time researching all of the possibilities.

In order to set up a Pivot Table you must initially select the data that you wish to use, then click on Insert, followed by Pivot Table. You must then choose a cell in which to place your table. Once this has been done you will be faced with a number of options. You can set up the table any way you want using drag and drop to place the data that you wish to analyse in the table. Once the table has been created you can then format it as you choose.


Using the Excel Camera Tool


The Excel Camera Tool is one of those tools that often gets neglected by Excel users. However this handy feature  can be used effectively when creating dashboards, to provide detailed ’snapshots’ of your charts.

The Camera Tool is very appropriately described by its title. It allows users to select a portion of their chart and then create a mirror image or snapshot of this segment. The most useful aspect of this feature however is that it allows you to resize the mirror image, and then reposition it wherever you choose.

In order to enable the Camera Tool, you must first add it to your Excel toolbar. This can be done by going to Menu, choosing Tools and then Customize. From there you will need to select Commands, and then go to Tools which will be in the Commands tab. You will then be able to locate a small camera icon, which you must drag onto your Excel toolbar.

When the Camera Tool is enabled, all you have to do is to is select the cells in your chart that you wish to copy. Then click on the camera icon in your toolbar and then click anywhere on the page to display your snapshot. This can then be resized, to provide a larger or smaller image of your highlighted area.


Effectively Using Excel Dashboard For Your Business Intelligence Needs


When you are managing a company of any size, your business intelligence software is one of your greatest tools. If a crisis suddenly occurs, you need to have a concise, precise but detailed overview of your business’ status so as to make the best decisions. The same applies if an unmissable opportunity arises. You need to know exactly how your business is performing before you can confidently expand or invest in any other enterprises.

With Excel Dashboard you are always completely up-to-date. You can preset this performance management software to provide you with daily reports. This report can contain whatever information you require, and can consist of gauges, charts, maps and tables.

You can choose to highlight any particular areas of your business that you believe require particular attention, but presetting the graph or chart generator. For example, if you wanted to draw immediate attention to any profits that dipped below a certain point, you could instruct Excel Dashboard to colour these data points differently to the rest of the chart.

If you need to determine financial risk or investment performance, Excel Dashboard will quickly generate a detailed and accurate overview of the determining factors. You may need to get an idea of a customer demographic for a particular product, and key information points associated with it. Again, Excel Dashboard can transform your market research data into a clear and concise business report. Whatever your business intelligence needs, Excel Dashboard can provide the solution.


How to build Excel Dashboards – 12


Previous – Excel Dashboard Tutorial – 11

How do you share your Excel Dashboard with users?

Now that you have built the dashboard, you can share the dashboard in multiple ways.

Create a PDF output of the dashboard and send as email attachment.

Click on the PDF icon on the toolbar as shown below and it will instantly create a PDF output


PDF output



” Create Static HTML output. Click on the HTML icon on the toolbar. This option creates a static html page that you can put in on the web. Users cannot interact with the dashboard. It is just a snapshot image of the dashboard at the time the output was generated. It does not refresh automatically. You will need to regerate the output again when the data is refreshed.

” Desktop Sharing. You can put the dashboard definition file (icv) on a file share directory and other users can view the dashboard through the Dashboard viewer. You may need separate license for dashboard viewers for desktop.


Go to Menu Create ‘ Publish to web and it will generate a file that you can put it where the dashboard web server is and it will render the output. The look and feel is different with this option


The web version is using a flash charting engine to the desktop Java chart engine.
Details of converting the desktop to web version are not covered in the document. Please refer online at any of our websites for more details

You can download the complete tutorial as PDF
” Web Sharing: In this option, you can publish the dashboard to web and the dashboard is available real time with all the dashboard parameters and refresh actions


How to build Excel Dashboards – 11


Previous – Excel Dashboard Tutorial

Sales Dashboard using Excel


We built the above dashboard completely from scratch.

  • We defined Calculations
  • We defined date hierarchies
  • We built Date Filters
  • We built Date Parameters
  • We built Bar Charts
  • We built Pie Charts
  • We cleaned the dashboard layout

Next – Share Excel Dashboard with other Users


How to build Excel Dashboards – 8


Previous – Excel Dashboard Tutorial – 7

Create Pie Chart

We will now create a pie chart by product name





It is nice to know that the revenue distribution is not dominated by a single product.

We can now change the “Category name parameter” to see the product distribution for other category


By Category = Beverages


Summary of steps so far
” Create a foundation table portlet (Qlet)
” Add Calculations and any derived columns
” Add Date hierarchy columns as needed
” Create Date parameters if needed
” Create drop down list of values as parameters
” Create charts using the base Qlet
” Delete the foundation portlet when not needed and you are done with the dashboard design
” Arrange the remaining portlets in desired format.

Once you are done with all the Qlets (query/table portlet) and Glets (graphic portlets), it is advisable to save the dashboard file, copy the file and work on the new file for finishing and polishing the dashboard.

Next – Excel Dashboard Tutorial – 9