|
If you have a database and want to create reports and charts
but you need to know SQL to access your database and
are struggling - or you find it's just too difficult and time consuming - well here is the
answer. Tableau Software - data visualisation tool. No need for a SQL tutorial or SQL help or
to learn SQL.
I have a customer who could not readily access
and report on his departmental hospital packaged and specialised database. There was a report
writer provided with the system from one of the big business intelligence software
companies, but it was just too cumbersome and tedious to use. The SQL Language presented a big
learning curve for them. Within minutes of using Tableau he was making reports for his
department!
All you need to understand is the basic
structure of your data and what are the common columns between the tables in your database.
Tableau does the rest.
Here is an example
below. Just drag and drop the data items you need onto the columns and
Rows shelfs - see red lines below. Your data items are all shown on the left in two categories -
dimensions and measures. When you drag them to the row and columns shelf they take the SUM by
default - you can of course readily change this.
The graph to the right suddenly appears giving
you a powerful visualisation of your database data. There are many different chart types
available. You might think Excel can do this but Tableau far exceeds the capabilities of
Excel...you will be surprised.
Now there is no need for complicated SQL WHERE
clauses, all you do is right click on a dimension or filter and Choose 'Quick filter' and
then you can dynamically filter your data using the check boxes. See the example below with the
filter highlighted with the red circle.
To make the visualisation or visualization if your come from the
USA, drag the Product Type to the color shelf and the graph colours give you more visual clues to
understanding your data.
You can add annotations too so help others readily spot
outliers or trends. You can then use the FREE Tableau Reader to distribute your dynamic report or
chart to others. You can even be more sophisticated by making a dashboard and making it available
through Tableau Server software and a Web Browser.
You can make clever reports too see the
example below with running totals..
Tableau comes with a great set of FREE videos showing you exactly how to get the
most out of the product and if you purchase it from us we are always at the end of a phone
call or email to provide you with help.
Tableau has two levels of desktop 'design'
products - Tableau Personal and Tableau Professional
Tableau Personal opens data
from:
Microsoft Excel and Access.
Tableau Professional opens data
from:
Firebird 2.0 or later, Hyperion Essbase 7x and System 9 or later,
IBM DB2 8.0 or later (running on pSeries or xSeries), Microsoft Access 2000 or later, Microsoft
Analysis Services 2000, 2005, or 2008, Microsoft Excel 2000 or later, Microsoft SQL Server 2000,
2005, or 2008, MySQL 3.23 or later, Netezza release 3 or later (requires Netezza ODBC driver
version 3.1.4 or later), Oracle 9i or later, PostgreSQL 7.0 or later, Teradata 6 or later, Text
files, comma delimited format, Vertica 2.2.0 or later.
There is free trial you can download Tableau
Professional Desktop right now and get started. Do not get stuck just send us an
email.
Do not spend your time learning SQL just yet
....get the reports and charts you need NOW using Tableau. You do not need SQL help or
a SQL Tutorial to get started.
Try it for yourself ......Downloads in
minutes. Get started right
away.
Click Here for the System requirements for Tableau Personal
Desktop
Click Here for the System requirements for Tableau
Professional Desktop
Go back to Top of 'No SQL Tutorial required'
page
|
