Need to analyze your data with ZERO programming? Need to analyze your data from different data sources? Need to be able to visually display your data to find patterns? BigSheets allows you to do all of that and more! BigSheets comes with all editions of IBM InfoSphere BigInsights.

It has a familiar spreadsheet-like format with which you, as a business user, can get actionable insights from your data in three easy steps:

  1. Load: Even if your data comes in from different sources with different formats such JSON, CSV, or data from web crawlers, BigSheets can load all of that into a workbook.
  2. Filter: Once you have a workbook, you can create sheets that filter your data to make it more manageable.
  3. Visualize: After you pare the data down, you can begin to visually represent the data to see the big picture. BigSheets provides various charts and diagrams to depict your data.

There are twelve different types of sheets that you can create from your workbook. Each of these sheets provide ways to manipulate your data so that it becomes more manageable. Here are the twelve sheets you can create:

  • Filter
  • Function
  • Load
  • Group
  • Join
  • Union
  • Intersection
  • Complement
  • Limit
  • Distinct
  • Copy
  • Formula

You can specify additional properties for each of those sheets. For example, if you wanted to apply a specific function, there are a number of functions for you to choose from. You can even write your own custom functions. Here are some of the built-in functions you can use:

  • Conditional functions
  • DateTime functions
  • Entity functions
  • HTML and XML functions
  • Math functions
  • Selection functions
  • Text functions
  • Text comparison functions
  • URL functions

I have only listed some of BigSheets’ capabilities. If you want to learn more about BigSheets, be sure to check out the course on Big Data University where you will get a chance to see BigSheets in action and even get to work with it yourself in the BigInsights Quick Start Edition.

You can also check out the interactive visual flow of working with data in BigSheets in the documentation.

Finally, if you want to see how to use BigSheets with Big SQL, check out Lab 4 and Lab 5 of the Big SQL tutorial on Hadoop Dev.

1 comment on"Use BigSheets for Analytics"

Join The Discussion

Your email address will not be published. Required fields are marked *