A Practical Guide to TIBCO Spotfire for Business Analytics

Import data from the Ohio DNR site, load well header and production data, set up an OGBC connection to an Access database, and load tables into Spotfire for analysis.

Download, combine, and prep well production data by quarter from 2017–2018, including oil, gas, brine, and days on production, using ETL workflows for integrated analytics in Spotfire.

Open Spotfire, browse local files, and import databases and worksheets, set data types, embed tables, and build data relationships for location-based analytics.

Learn to manage data tables and create relationships across multiple data sets. Import databases into spot fire and use filter relationships and column links to build efficient analytics dashboards.

Discover how to build dashboards in Tibco Spotfire, slice data, create calculated columns, integrate datasets, and visualize with scatter plots, time series, box plots, and maps.

Create custom calculated data columns in Spotfire using if statements to validate values like effective lateral length, filter out outliers, and build new columns for production tables.

In Tibco Spotfire data canvas, add daily rate columns for oil, gas, and brine in production table, link data with left outer join, and compute gas rate per thousand feet.

Create and analyze box plots to explore parameter statistics, color by column, and filter invalid data while examining lateral and stage length for Utica and Marcellus in the Appalachian Basin.

explore spatial visualizations with map charts in Spotfire by using feature layers and marker layers, linking shapefiles to data tables, customize colors with saved color schemes, and enable interactive exploration.

Discover how to build a Spotfire dashboard by creating calculated columns, integrating data, and visualizing data with scatter plots, time series, box plots, and map charts.

Create interactive dashboards in TIBCO Spotfire by building data tables, applying marker layers and map markings, and linking selections across tables and scatter plots for deeper drill-downs.

Design a professional dashboard by integrating different markings and marking relations, using a drawdown approach to unify visualizations, and building custom property controls to limit user access and reduce clutter.

Recap the essential Spotfire skills—from managing data sets and building filter relationships to crafting visualizations and advanced dashboard features—to analyze data and uncover insights through a hands-on state data project.

Celebrate completing the course and apply the built data analytics dashboard and its unique functionalities to your data and analytics needs. Continue leveraging the power of technology and data science.