hadoop big data visualization

Hadoop Based SQL and Big Data Analytics Solution

Hadoop Big Data Visualization

Hadoop Based SQL and Big Data Analytics Solution

What is Data Visualization

Hadoop Based SQL and Big Data Analytics Solution

What is Data Visualization• Data visualization is the presentation of data in a pictorial or graphical format,

meaning "information that has been abstracted in some schematic form, including attributes or variables for the units of information”.

Hadoop Based SQL and Big Data Analytics Solution

What is Data Visualization• Data visualization is the presentation of data in a pictorial or graphical format,

meaning "information that has been abstracted in some schematic form, including attributes or variables for the units of information".

• Main goal of data visualization is to communicate information clearly and effectively through graphical means.

Hadoop Based SQL and Big Data Analytics Solution

What is Data Visualization• Data visualization is the presentation of data in a pictorial or graphical format,

meaning "information that has been abstracted in some schematic form, including attributes or variables for the units of information".

• Main goal of data visualization is to communicate information clearly and effectively through graphical means.

• In the new millennium, data visualization has become an active area of research, teaching and development.

Hadoop Based SQL and Big Data Analytics Solution

What is Data Visualization• Data visualization is the presentation of data in a pictorial or graphical format,

meaning "information that has been abstracted in some schematic form, including attributes or variables for the units of information".

• Main goal of data visualization is to communicate information clearly and effectively through graphical means.

• In the new millennium, data visualization has become an active area of research, teaching and development.

• As more and more data is collected and analyzed, decision makers at all levels welcome data visualization software that enables them to see analytical results presented visually, find relevance among the millions of variables, communicate concepts and hypotheses to others, and even predict the future.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Identify areas that need attention or improvement.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Identify areas that need attention or improvement. Understand what factors influence your customers’ behavior.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Identify areas that need attention or improvement. Understand what factors influence your customers’ behavior. Know which products to place where.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Identify areas that need attention or improvement. Understand what factors influence your customers’ behavior. Know which products to place where. Predict sales volumes.

Hadoop Based SQL and Big Data Analytics Solution

Why Data Visualization?• Visualizations help people see things that were not obvious to them before. Even

when data volumes are very large, patterns can be spotted quickly and easily.• Visualizations convey information in a universal manner and make it simple to

share ideas with others. • It lets people ask others, “Do you see what I see?” And it can even answer

questions like “What would happen if we made an adjustment to that area?• Needs of Data Visualization can be listed as:

Identify areas that need attention or improvement. Understand what factors influence your customers’ behavior. Know which products to place where. Predict sales volumes. Discover how to increase revenues or reduce expenses.

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

• QueryIO provides:

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

• QueryIO provides: Query Manager

All the saved queries can be viewed under Query manager.

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

• QueryIO provides: Query Manager

All the saved queries can be viewed under Query manager. Query Designer

Used to design and save query. Also to edit an existing query.

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

• QueryIO provides: Query Manager

All the saved queries can be viewed under Query manager. Query Designer

Used to design and save query. Also to edit an existing query. Query Viewer

Query Viewer is used to display the result of the query

Hadoop Based SQL and Big Data Analytics Solution

Data Visualization with QueryIO• QueryIO gives you a large numerous options and set of services to help you with

your big data visualization.• QueryIO supports on the fly metadata extraction from the files written onto the

cluster. By default, the metadata for unregistered file types is saved in HDFS-METADATA table in the database. Query builder can be used to query the information extracted from the files.

• QueryIO provides: Query Manager

All the saved queries can be viewed under Query manager. Query Designer

Used to design and save query. Also to edit an existing query. Query Viewer

Query Viewer is used to display the result of the query Spreadsheet Viewer

Use spreadsheet to process and further analyze the query results.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Design / View a QueryTo re-design or view an existing query.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Design / View a QueryTo re-design or view an existing query.

CloneTo create exact copy of an existing query.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Design / View a QueryTo re-design or view an existing query.

CloneTo create exact copy of an existing query.

ExportTo export result of a query as a report in PDF/HTML/XLS format.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Design / View a QueryTo re-design or view an existing query.

CloneTo create exact copy of an existing query.

ExportTo export result of a query as a report in PDF/HTML/XLS format.

EmailTo e-mail result of a query as a report in PDF/HTML/XLS format.

Hadoop Based SQL and Big Data Analytics Solution

Query Manager• All the saved queries can be viewed under Query Manager. • You can load previously saved queries by clicking on respective query IDs.• Operations that can be performed using Query Manager are:

Add / Delete a QueryTo create a new Hadoop SQL query or to delete an existing query.

Design / View a QueryTo re-design or view an existing query.

CloneTo create exact copy of an existing query.

ExportTo export result of a query as a report in PDF/HTML/XLS format.

EmailTo e-mail result of a query as a report in PDF/HTML/XLS format.

ScheduleTo schedule execution of a query.

Hadoop Based SQL and Big Data Analytics Solution

QueryIO Query Manager Screenshot

Hadoop Based SQL and Big Data Analytics Solution

Query Designer

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query .

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query.• Query designer is composed of two modules:

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query .• Query designer is composed of two modules:

Query Builder

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query .• Query designer is composed of two modules:

Query Builder Report Builder

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query .• Query designer is composed of two modules:

Query Builder Report Builder

• Query Builder• This module is used for defining an SQL query.• Using query builder you can construct queries that you want to execute on

your data.• From choosing a query ID, to constructing a query using on click drop down

on fields SELECT, FROM, WHERE, GROUPBY, ORDERBY, HAVING gives you a great and easy interface for creating an SQL query.

Hadoop Based SQL and Big Data Analytics Solution

Query Designer• Query Designer is used to design a Hadoop SQL Query .• Query designer is composed of two modules:

Query Builder Report Builder

• Query Builder• This module is used for defining an SQL query.• Using query builder you can construct queries that you want to execute on

your data.• From choosing a query ID, to constructing a query using on click drop down

on fields SELECT, FROM, WHERE, GROUPBY, ORDERBY, HAVING gives you a great and easy interface for creating an SQL query.

• Report Builder• Using report builder interface of QueryIO, you can build reports to present

the contents of the queries that you can perform using the query builder.• It comprises of Report Designer, Chart Designer, Chart Preferences etc.

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header Group Header

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header Group Header Column Header

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header Group Header Column Header Column Details

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header Group Header Column Header Column Details Group Footer

Hadoop Based SQL and Big Data Analytics Solution

Report Designer• Report Designer is used to customize:

Report Header Group Header Column Header Column Details Group Footer Report Footer

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer is used to customize the design of your chart.

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer is used to customize the design of your chart.• It lets you customize each and every minute details related to your chart, which

allows you to represent and visualize your data exactly the way you want.

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer is used to customize the design of your chart.• It lets you customize each and every minute details related to your chart, which

allows you to represent and visualize your data exactly the way you want.• QueryIO provides support for numerous chart type namely

Line Chart Bar / Tube / Cone Chart Pie Chart Area Chart Bubble Chart Scatter Chart Meter Chart Stock Chart Difference Chart Gantt Chart Pyramid Chart Radar Chart

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer can be used to:

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer can be used to:

Add/Delete ChartTo add a new chart for the current Query or delete an existing chart.

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer can be used to:

Add/Delete ChartTo add a new chart for the current Query or delete an existing chart.

Clone ChartTo create exact copy of an existing chart.

Hadoop Based SQL and Big Data Analytics Solution

Chart Designer• Chart Designer can be used to:

Add/Delete ChartTo add a new chart for the current Query or delete an existing chart.

Clone ChartTo create exact copy of an existing chart.

Edit Chart PreferencesTo edit the chart preferences for selected chart.

Hadoop Based SQL and Big Data Analytics Solution

Chart Preferences• Chart Preference UI is divided into three sections :

Hadoop Based SQL and Big Data Analytics Solution

Chart Preferences• Chart Preference UI is divided into three sections :

First section shows the configurable categories.

Hadoop Based SQL and Big Data Analytics Solution

Chart Preferences• Chart Preference UI is divided into three sections :

First section shows the configurable categories. Second section displays live preview of the chart. Any update in the

properties are instantly reflected to the preview.

Hadoop Based SQL and Big Data Analytics Solution

Chart Preferences• Chart Preference UI is divided into three sections :

First section shows the configurable categories. Second section displays live preview of the chart. Any update in the

properties are instantly reflected to the preview. Third section displays all the configurable properties that can be applied on

the chart, according to selected category.

Hadoop Based SQL and Big Data Analytics Solution

SpreadSheet Viewer

Hadoop Based SQL and Big Data Analytics Solution

SpreadSheet Viewer• QueryIO provides support for spreadsheet viewer, an excel like spreadsheet with

all the layers of business intelligence.

Hadoop Based SQL and Big Data Analytics Solution

SpreadSheet Viewer• QueryIO provides support for spreadsheet viewer, an excel like spreadsheet with

all the layers of business intelligence.• Result of all the queries executed can be viewed in Spread Sheet Viewer for

further processing.

Hadoop Based SQL and Big Data Analytics Solution

SpreadSheet Viewer• QueryIO provides support for spreadsheet viewer, an excel like spreadsheet with

all the layers of business intelligence.• Result of all the queries executed can be viewed in Spread Sheet Viewer for

further processing.• Spreadsheet viewer allows sheet creation, viewing, and editing processes. It also

supports Undo & redo, Merge-able cells, Easy creation of custom formula functions and variables, full screen mode for better viewing, printing reports and many more features.

Download QueryIO Now!http://QueryIO.com/download/big-data-analytics-download.html

OR

Take a Demohttp://demo.QueryIO.com/queryio

Hadoop Based SQL and Big Data Analytics Solution

“Its Free”