
This is the introductory lecture in this course. The Instructor will start with fast brife on himself. The a high level over view on this course and whom should take this course.
TIBCO Spotfire is one of the fast growing Business Intelligence tools. You can use Spotfire to analyze your data using different types of charts.
In this course you will learn first how to connect to data. Then how to prepare your data by joining different data sets or even merge them together. You can introduce new calculated field and do dome data quality enhancements as well.
The next step is to visualize your data. Here you can realize the massive power of Spotfire. You can build amazing visualizations and dashboards with couples of clicks.
Finally you can examine the powerful data exploration feature which enable you to write a question and Spotfire will display the most suitable graph for this, thanks for the natural language processing engine which can translate your questions into graphs.
In TIBCO Spotfire you can connect to any type of the following data sourses:
External files: like excel files and CSVS
Relational databases: like Oracle, Teradata, MS SQL, IBM DB2
Big data platforms: cloudara, Hadoop, hortonworks, Spark, Hive, Impala
In this lecture you will learn how to connect to an Excel file. The first step to do that is to browse to a file. In this course we will use super store sales file. This file contains 3 sheets
Orders: contains order details like order ID, date, product info, state and regin, sales, quantities...etc
return: this sheet contains a list of returned orders
people: this file contains the region and corespondent people
you can use the connection to file wizard to:
Change data type
show or hide columns
show or hide rows
After importing a data set you can do one of the following:
Join your data set (Table) with other dataset.
union it with another data set.
Learn to connect to a data source, analyze the city dimension and location, and generate insights with details, data type conversions, and recommended charts.
Explore data canvas workflows in Tibco Spotfire, building relationship diagrams between orders and returns, applying joins and transformations, and choosing live, extracted, or mixed data loading modes for visualization.
Create tabular format charts in Spotfire, including simple tables, cross tables, and summary tables, with filters and metrics for region and subregion, and statistics such as average and standard deviation.
Explore bar charts in Tibco Spotfire, learning shot types, orientation, color by category, and how to compare regions using stacked, side-by-side, and 100 percent stacked bars.
Explore how to use a pie chart to visualize sales by shipping routes, with slices representing each route's contribution to total sales, and learn to customize colors, size, and labels.
Learn to sort data by value and rank top entries in Tibco Spotfire, using click-to-sort, ascending or descending order, reverse, and advanced sorting from appearance, plus segment-by-value and top-N ranking.
Explore by searching shows how to ask natural language questions in TIBCO Spotfire and automatically generate the right visualizations, from line charts to scatter plots, with autocomplete.
Spotfire is an extremely powerful enterprise-grade analytical platform for deriving valuable business insights. It is smart, secure, flexible and scalable tool that provides data visualization, discovery, wrangling and predictive analytics capabilities.
This course is a practical guide that will help you to understand the process of creating data visualization in spotfire. In this course you will learn:
How to connect to Data
How to prepare your data using "Data Canvas"
How to Visualize your data
How to explore by search.