TIBCO Cloud Spotfire Data Visualization and Analytics | Lorenz DS | Skillshare

TIBCO Cloud Spotfire Data Visualization and Analytics

Lorenz DS, BI & DWH Solutions Architect

TIBCO Cloud Spotfire Data Visualization and Analytics

Lorenz DS, BI & DWH Solutions Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Lessons (1h 45m)
    • 1. Introduction

      4:06
    • 2. Installation and Setup

      3:06
    • 3. Loading, Preparing and Associating Data

      4:33
    • 4. Importing Data from a Local File

      6:25
    • 5. Importing Data from a Data Connection

      6:50
    • 6. Modeling Relationships in the Data Panel View

      7:41
    • 7. Building a Dashboard

      5:09
    • 8. Preparing our Sales Dashboard - Exercise

      4:09
    • 9. Building a Detailed List of Orders and Returns - Exercise

      10:30
    • 10. Building a Chart and Boxplot with Shipments - Exercise

      13:42
    • 11. Building a Stacked Chart for Sales by Product Category - Exercise

      6:06
    • 12. Building a Treemap with Sales by Customer Segment - Exercise

      6:37
    • 13. Building a KPI and Trendline Chart - Exercise

      7:29
    • 14. Visualizing a Dashboard

      2:57
    • 15. Custom Filters and Dynamic Filtering - Exercise

      4:31
    • 16. Adding Tags and Bookmarks to your Dashboard - Exercise

      5:13
    • 17. Publishing your Dashboards on TIBCO Cloud

      5:35
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

5

Students

--

Projects

About This Class

Learn the essentials of TIBCO Cloud Spotfire 7.13 through this step-by-step tutorial. This course takes you through the basics of TIBCO Spotfire, how to integrate your application with different data sources, manage data, build visualizations and sheets and share your insights in TIBCO Cloud!

..Learn to build dashboards with TIBCO Spotfire 7.13 from scratch!

..Learn some of the most common mistakes made when building building sheets and visualizations..

..Share your insights with your team and publish your dashboard to TIBCO Cloud!

Good luck and hope you enjoy the course.

Pre-requisites:

  • Basic knowledge of Business Intelligence and Visualization.

  • Some experience with Visualization tools would be helpful, but not required.

Course content:

The course consists of the following modules:

  • Introduction, Installation and Setup

  • Data Loading - Load Data from a Local File/Database Connection

  • Data Loading - Exercises

  • Build Dashboards- Visualizations

  • Build Dashboards - Exercises

  • Sharing Insights - Presenting Insights with TIBCO Cloud

  • Sharing Insights - Exercises

  • Final Quiz

Who should follow this course?

  • Students that want to learn the basics of TIBCO Spotfire

  • Business Analysts and Designers who are already familiar with other visualization tools and want to learn TIBCO Spotfire.

  • Managers considering using TIBCO Spotfire within their organization.

What you’ll learn

  • Understand the components and main functionality of TIBCO Spotfire.
  • Load data from different sources (ODBC, Web files, Salesforce etc.) to your TIBCO Spotfire application.
  • Manage data within your TIBCO Spotfire Application.
  • Build dashboards within TIBCO Spotfire Application.
  • Build visualizations within your TIBCO Spotfire Application.
  • Publish your dashboard to TIBCO Cloud and share insights with your team.

Are there any course requirements or prerequisites?

  • Basic knowledge of Business Intelligence and Visualization.
  • Some experience with Visualization tools would be helpful, but not required.

Who this course is for:

  • Students that want to learn the basics of TIBCO Spotfire
  • Business Analysts and Designers who are already familiar with other visualization tools and want to learn TIBCO Spotfire.
  • Managers considering using TIBCO Spotfire within their organization.
  • Anyone who has used TIBCO Spotfire before and considers using TIBCO Spotfire.

Meet Your Teacher

Teacher Profile Image

Lorenz DS

BI & DWH Solutions Architect

Teacher

Hi there!

Hi there. My name is Lorenz, I am a certified IT professional with several years of experience working as a consultant and functional analyst, mainly in the Business Intelligence domain.

Working experience:

I have worked for clients within the Energy and Financial sector, and have been involved in the roll-out of Business Intelligence and Data Warehouse projects and the implementation of BI solutions.

As an instructor, I want to share my knowledge and experience in BI and Data Visualization software. During these courses, I will explain the basic concepts, but also tips and tricks for creating Visualizations and Reports that best suit your purpose or the purpose of your end-user.

Course topics... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Hello, My name is Lawrence and welcome to this course on TIBCO Spotfire. Within this course, we're going to learn about TIBCO Spotfire. And we're going to look at some of the basic functionalities within Spotfire. We're going to learn how to load data from various data sources in Spotfire, build dashboards, and also publish those dashboards in TIBCO Spotfire clouds. So for some of you who don't know TIBCO Spotfire, TIBCO Spotfire is a visualization software that is used to create dashboards. Spotfire can handle multiple data sources like local files, database connections, and even web services to upload data to the Spotfire environment. Afterwards, Spotfire can create dashboards using those data that has been uploaded. Spotfire also has the possibility of using visual recommendations and can recommend certain visualization types based on the data that you provide to Spotfire. It is also tightly integrated with TIBCO Cloud, which is the Cloud environment where you can publish. Your dashboards are also publish data sources on TIBCO Cloud. Of course, there are different versions of Spotfire and within this tutorial, we're going to look at TIBCO Cloud Spotfire, which comes with the desktop version of TIBCO Spotfire Cloud analyst, which is integrated with the typical Cloud environment. Of course, you also have the enterprise version, which is the Spotfire platform, which is a client, server, private hosted environment. You also have typical Cloud Spotfire enterprise, which is the Spotfire platform, but then on a Cloud environment. And then you also have Spotfire Amazon Cloud services, which is an AWS integration service for Amazon. So this is when you want to integrate Spotfire with Amazon Web Services. Within this tutorial, we're just going to focus on TIBCO Cloud Spotfire, which also comes with a free trial version. And we're first going to look at TIBCO Spotfire Cloud analysts, which is a desktop interface where you can develop your dashboards. And it's basically your workbench where you want to develop. It's also available both online and offline and can be integrated with typical clouds. This is a basic example of one of the dashboards that we're going to build within DEP go cloud analysts. Afterwards we're going to publish this dashboard on typical clouds. Within typical Cloud, you can create organizations and you can also configure which user can edit or view the dashboards that you publish on your typical Cloud environments. So this is an overview of the complete course. We're going to start with installing and setting up the get-go cloud on our desktop and creating an account on the typical Cloud environment. After that, we're going to load data from a simple Excel file that you can download in this course to TIBCO Spotfire. And we're going to load this data into Spotfire and also try to load data. Another data source, which is a web service. After that, we're going to build our dashboard, which consists of six different sheets. And within each sheet we're going to add some visualizations. At the end of each section. We're also going to do a small quiz just to test our knowledge on each of the topics represented within this section. And at the end are also going to look at how we can share our dashboard on TIBCO clouds and how we can present this dashboard using filters, tax and bookmarks. So this is an overview of the entire course. If you have any questions, just send me a message and good luck with the rest of the course. 2. Installation and Setup: So before we get started, let's first have a look at how we can request a trial to the TIBCO Spotfire Cloud environments. So to get started, we first have to fill in a registration form on the typical website and request our 30 day free trial to TIBCO Spotfire Cloud analyst. So when we request this trial, we will get access to the tip go cloud environments and also get a desktop application which is called the typical Spotfire Cloud and lists where we can develop dashboards which we want to publish. Two typical Cloud. After this 30 day free trial has expired, you can of course, to subscribe to the paid version. Go. So if you just go to the link with the registration form and then fill in this registration form. You can actually request your own Spotfire trial. So after you completed the registration form, you will see this screen where you can actually download Spotfire on your desktop. And you can click on the link in here. This will start the downloading process of google Cloud Spotfire Analyst on your desktop. Or you can of course, continue working within your browser. Once the download is complete, you can just click on this and start the setup process and just click through the setup steps to install typical Cloud Spotfire on your desktop. So once the setup of Spotfire on your desktop is complete, you can just close this window. And what you see here is your TIBCO Spotfire cloud environment, where you can publish the analysis that you have made with typical Cloud Spotfire Analyst on your desktop. Within typical cloud, you have different folders that you can share with other users. And you also have your own organization folder. To create a new analysis. You can do it directly in TIBCO Spotfire Cloud. Or you could open the version on your desktop and then publish your analysis to its Spotfire Cloud environment. Before you log on with TIBCO Spotfire on your desktop, you will always have to sign in to your typical Cloud accounts by filling in your email address that you used to register your Cloud accounts. Once you log in, you will see a message on the background that the authentication is successful and TIBCO Spotfire will launch on your desktop. And you can see that you're connected to typical Cloud. When you see that your online at the bottom left corner of your screen. 3. Loading, Preparing and Associating Data: So once your installation is set up, you can start loading data in Spotfire. There are different data sources that we can use to load data and Spotfire. For example, we can add data from a local file. We can add data that we have stored in the library on typical Cloud. And we can add a data connection, which can be, for example, a connection to a database or a web service. So after we've added our data source, we can start importing the data from our data source by going to add data tables. And we can add the tables that we want to import to Spotfire. So when you want to load a local file from your desktop in Spotfire, you simply can go to add local file and select one of the local files that you want to add. For example, this can be an Excel file, or it can be a flat file, a text file, for example, a CSV, or just irregular standalone database. Once you start importing this file, you will get some basic configuration settings where you can, for example, configure the different datatypes of your columns. And you can specify whether these are an integer, a date, string, and so on. You can also include and exclude the rows that you want to at your datasets that you want to import. And also do some basic transformations and data cleansing. You will also get a preview window and have a look at which data you're actually importing. You can also add a data connection. A data connection uses a data connector to connect to an external database or web service. For example, within Spotfire, you have many different types of data connectors that you can use. For example, you can connect to a SQL Server database, to an Oracle database, Salesforce open data. You can even import data from Google Analytics and so on. When you use a data connection, Spotfire will not store the data itself, but only the metadata that is used to connect to your data source. This includes all the connection parameters you need to connect to your database. For example, authentication methods, username, password, and so on. And you can also specify how you want to load the data, which tables you want to load, some basic transformations and so on. So when you're working with large datasets, in general, it's better to use a data connection. Then storing data from a local file within Spotfire. Within the exercises, we're going to load data from a local Excel file and also load data from a data connection just to see the difference between both options. And you can either store both your local file that you have on your desktop, on the spot via Cloud library. Or you can store your data connection file also on the library. So once you have connected to your data source, you can start adding the tables from your data source. And within the data panel source view, you can actually see all the transformations from your data source until the end target table that you're going to use within your analysis. There are different ways you can join tables or inner joins, left, right outer join, and full outer joins. An inner join is basically when we want to join all the rows that occur in both table a and B. You also have a left or right outer join where we only want to have rose from one of the tables and match the data from the existing rows within the table. And we have a full outer join where we want to have all the rows from both tables. Within Spotfire, you can also add new calculated columns. For example, you can add up or combined two columns within your tables into a new calculated column. What we're going to do next is load the data from our local sales order Excel file that you can download from this tutorial. And we're going to load this file into Spotfire. We're also going to have a look at an example with an open data web service data connection just to see the difference between loading data from a local file and loading data from a data connection. After that, we're going to import the tables from our Excel data source. And we're going to prepare and do some basic transformations in order to load those tables into Spotfire. 4. Importing Data from a Local File: So in this exercise, we're going to load the data from an Excel file to TIBCO Spotfire. There are different ways that we can load data into Spotfire. For example, we can go to File at data tables or click on the Add Data Tables I can in here. Or you could also go to Add Data and select one of the options. So you can add data from a local file. You can add data from the library, where you can select a data file from the library that is shared within your team or organization. Or you could add data tables from multiple sources or add a data connection to, for example, a SQL Server environment. For this exercise, we're going to add data from a local file. So if I go to Open File, then I can select my Excel file. And I get this Excel import settings window where I can preview my data. And here I can see all my different worksheets within my Excel file. So if I select my first worksheet, which is the orders worksheets, then I can see all my different columns. The name row includes all the column names. The type rho will give me my data types for each column. Included will mark if I want to include this column within my import settings. And here I can select whether this rho is a name, rho is a typo or a data row. Or if I want to ignore this row. So for example, if I ignore this first row, then it will not import the first row. I want to select all my columns. So all my columns are selected. And when I look at my columns, I can change, for example, the sales to a currency because this is a currency amount. And I can do the same for my profits, unit price, shipping cost, and import this data. So now I have just imported the data from my first worksheet within my Excel file. And you can already see the different columns on the left side. The columns are grouped by datatype. So what I want to do next, adding the other tables within my Excel worksheet. To do so, I go again to add tables. And I add my tables within my Excel sample orders file. And I select the second worksheet, which is a returns worksheet. As you can see here, my first row contains some descriptions. So I do not want to include these descriptions within my dataset. So what I can do is rename this to order ID and rename the second column 2 status. And this will be my name row. And I can now ignore the first data row, which doesn't include actual data. So I do not include this row. I click OK. I can preview is data in here. Here I can see all the transformations. And I can add a new transformation, for example, by going to add. And I can rename, for example, a certain column to uppercase. To do this, I just simply select the status column. I select my function upper, which will return the arguments string converted to uppercase. And I add this column. And I insert this expression to undo a certain transformation. I can simply remove this transformation. If I now click on, Okay, my new data table will be added. And you can see my two columns, status and order ID on the left side. If I click on the table that I can see all my tables. As you can see, there is the Orders table and the returns table. And they can now start adding the other tables within my Excel worksheet. So I'll do the same thing again. And I add a file and I select the sales orders Excel sheet. Now I import the third sheet, which is the product sheet. And I do the same for my other sheets. And within the region manager sheet, I also rename the column names and ignore the first row. 5. Importing Data from a Data Connection: Okay, so what we're going to do next is import data using a data connection. A data connection is a connection to a certain database or a web service where we can import data using that connection. So as you can see, there are multiple options for adding data connections. What we're going to do next is add a open data connection and then import data using this open data connection. So what is open data? Open data is actually a protocol for communicating with RESTful APIs. So what we're actually going to do is send a request or a query to this web service using HTTP. And what we will get back a result of the query, which will be in a JSON like format. So if you're interested to learn more about open data protocol, you can just go to the Open Data.org website and here you can find more information about Open Data Protocol also with some sample services here. So for this example, we're going to use strip in service, which is one of the main examples, which can be used by anyone. So if I click on this web service, you can see the Daggett a JSON back, which contains some data. So actually my response contains some tables where you can see the table for people. You can see a table for airlines and airports. So if I now want to look to the data inside of these tables, I can just append the URL and enter, for example, people. What I will get is the full dataset for this table. But what we're going to do next is load this table from this web service into Spotfire using a data connection. We now go back to Spotfire and we can either add a data connection in here or we can go to Tools manage data connections. And here we can add a new data source or new data connection. So we add a new data connection, open data, and entered the service URL. So this is the URL of our web service, which is a trip in service sample. And we don't have an authentication methods. So we can simply connect duty to this web service without authentication. And as a response, we get the different tables. So we have the tables for the people in here. So I select this table and I add this to the view in my connection. And here I can select the columns that I want to add to this view. So if I want to select all the columns, I select all of them and I click on, Okay. And here I can see the connection details. I can add a description to disconnection. This connection is used to fetch people data from the tree pin Web Service sample. And I saved this data connection. And I name it to three bin service people. I can add some keywords like treatment, service, samples, exercise, whatever. And I can save this into the library under my organization. And I save this data connection within my organizations folder. And if I now go to this folder, then I can see my newly created data connection in here together with the description. So if I now want to add my tables from this data connection, simply go to Add Data Tables. And I add data connection in library because I store this data connection within my library. And I select my data connection. And this will fetch the people table from the web service. I import is data. And you can see that the data is imported and the columns have been added to Spotfire. So I can create visualizations using the columns I have in here. And you can start creating different visualizations. If we want to change the settings of our data connection, we can go again to tools, manage data connections. And we go again to the data connection within the organization folder. And if we then go to our data connection, we can edit this data connection. And what you see here. For example, in performance settings, you can switch between caching and always refreshing the data from the external source. So now the data will be cached for one minutes, after which the web service will be called again and we will get new fresh data again. We can also change this to, for example, 10 minutes, which means that after ten minutes, we will fetch again the data from the web service. If you want to reload the data, we can also go to file, reload data. And then we will also reload the data again. 6. Modeling Relationships in the Data Panel View: Okay, so we have now loaded all our tables and columns in Spotfire. And if we want to change the properties of these columns again, we can simply go to Edit Column Properties. And here you can see all the columns datatypes. And you can also see the origin, which is my sales order Excel sheet. If I want to rename a certain column, then I can rename it here. I can also insert a new column. I can insert a calculated column, which is a new column that contains certain calculation logic. For example, I could insert a new calculated column, which is the sum of my shipping cost and unit price. And I could call this product cost. So I call this Column product cost. And I use an expression which is the sum of my unit price. Insert this column unit price. And like shipping costs. Here I can select the available properties for his new column. And here I have some functions that I can use to calculate this column. If I go to preview and I can preview first 100 rows for this new calculated column. And you can see this new calculated column in here. As you can see, the product cost is the sum of my unit price and my shipping cost. And is a currency because my unit price and shipping costs are both also a currency. If I want to change the formatting of this currency, and I can go to formatting and change the formatting. For example, to a euro or a Dollar formatting. Of course, all the tables that we just imported are not linked to each other yet, so we have to create relationships, are created joints between those tables. So if I now go to Insert columns, get started joining the columns from the other sheets with my order sheet. So in this case I want to add columns to my data table orders. And I want to add columns from my other table, which is the returns table. And if I now go to next, then I can try to match my current data or my current table with the new table, which is the return stable. If I click on match our possible, you can see that Spotfire automatically recognizes the order ID as a possible match and also proposes to match these two columns. So if I now go to next, and I can add my new column status based on the matching order IDs. And here I can select the join methods. By default, this is a left outer join, which means that we will keep the rows from the current dataset, from the current table, which is the order stable. And then join the new table based on matching order ID. So I select my columns, so I select my status column. And my status column is now added to my sales orders table. So if I scroll down here, I can see my new status column within my categories. And I do the same for my other tables. So I go again to insert column and I add my columns from my products sheet. I go to next. I match all possible columns. And you can see that Spotfire automatically recognizes the product name as a key. We did both tables. So if I now go to next and select all my columns that I want to add. And again select the left outer join methods and you click finish. And I do the same for my tables. So I go to Insert columns and add my columns for my customers table. And then do the same for my region manager stable. As you can see now, all the columns are added within my sales order sheet. So you can see my manager column, you can see my product column, you can see my customer columns. So if I now want to see all the operations or all the joints that have been made between tables. Then I can simply click on this expanse data panel icon next to my table. And if I then go to the source view, then you can see all the different joints that have been made with the table and other tables. So each note in here will represent a new joint. As you can see on the left side, my data source, which is my sales order sheet. And you can see that I have added columns from another table, which is the return stable. And if you click on information, you will get more details on this table. And here you can see all the different records that are available in this table. If you then click on this Edit Settings, then you can see the settings for adding these columns. So you can see here my join method. So you can see that this is a left outer join. And you can see all the joint columns in here. So in light blue, you will see all the original data from my older stable. You can see the matching column, which is the order ID in dark blue. The matching data is my key column. On the right side you can see the data that has been added from the status column. And if you want to change the matching columns. So if you want to change the matching based on the order ID to another match, that you can simply click on, Add match and change this manually. We want to change which columns we want to fetch or which columns we want to join from the new table, then we can simply select or deselect the column that we want to add. And if you want to change the join method. And if I, for example, changes to right outer join, that will fetch the columns of my order stable based on my existing roles within my status table or my returns table. If I select the inner join, it will only show me the matching records that have both an order ID in the orders table and the returns table that matches. 7. Building a Dashboard: Okay, So in this section we're going to look at how we can build dashboards and visualizations in Spotfire. So each time you build a new dashboard and Spotfire, you can add certain sheets to the dashboard. And all these sheets within your dashboard contain multiple visualizations on a certain topic. So when you're building sheets, always think about which topic you're presenting. You can have a sheet for logistics. You can have a sheet for products and grow customers so that you separate those topics from each other. In separate sheets. The visualization is a single object that represents the data in your sheet. So when you build, for example, a sheet, customers, you can add a pie chart, which presents the data on different customer segments, for example, can also add filters, bookmarks, and tax, which we're going to cover in the next section. So for now we're just going to learn how we can add multiple sheets on a certain dashboard and also how we can add visualizations. There are different types of visualizations in Spotfire. You can have tables and cross tables to represent the data in its original form. You can also add graphical tables, which can contain graphical elements such as arrows or bars. You can add a waterfall chart where you can decompose a certain measure, two different sub measures. For example, you can add a waterfall chart for the price, where you can decompose this price into the different elements that determine this price. So for example, you can decompose the measure price into two elements, which is the VAT amount and the amount without VAT. Scatter plots are used to show the relationship between two variables or two measures. And then a scatterplot, you use dots to represent the relationship between two different measures. You can also use map charts to represent data values on a map. So this can be a map of the whole world or it can be the map of a specific. You can also add treemaps. Treemaps are used when you want to represent quantities or measures that have a certain hierarchy. And in a tree map, You will use blocks to represent each category, each subcategory of this hierarchy. And the size or color of the stream map can be used to determine your measure or the quantity that you want to visualize. Or you could also use heatmaps which use a similar matrix structure. So it's really important to choose the right visualization type. When you just want to represent one single value, it's best to use a KPI chart when you want to show the composition of data of a certain measure within a certain dimension. So for example, when you want to represent the sales for each product category, you can use a pie chart. And the size or color of each slice within your pie chart represents your measure or the quantity. When you want to represent a measure over time, you can use a line chart. Good example is the sales amount over time, where we have a time dimension on your horizontal axis and the measure or an amount on your vertical axis. When you want to compare two-dimensions that have a certain hierarchy, you can use a TreeMap instead of a pie chart. So for example, when you want to represent the sales amount by each product category and product subcategory. The two-dimensions, product category and product subcategory have a hierarchy and therefore its best use, a Treemap. In this case, when you want to decompose measures into sub measures, you can use a waterfall chart. And when you want to show the relationship between two different measures, you can use a scatter plot chart. So in the previous section, we have loaded data from our sales orders Excel sheet into Spotfire. And we're now going to use this data to build the following sheets. We're going to create five cheats. Sheet is a KPI dashboard which will contain some of our most important KPIs, such as the total number of orders, the sales revenue, and the profit. On the second sheet, we're going to go more into detail on different customer segments. And we're going to plot the seals by each customer segment, each region, and each province. On the term sheet. We're going to look at the product categories. And we're going to visualize the sales by each product category and each product subcategory. And also going to show a table with the top selling products. On the four cheat. We're going to look at the different shipments for each ship mode and the average shipping costs for each ship mode. We also want to see the total number of orders shipped and how long it takes to ship those orders. On the final sheet, we're going to have a total overview of all the orders and returns. So here we just want one table with all the orders and returns. And of course, for each of those visualizations, we're going to look at how we can best represent our data and use the appropriate visualization type. 8. Preparing our Sales Dashboard - Exercise: So in the previous exercise, we've loaded data from an Excel file into TIBCO Spotfire. What we're now going to do is try to visualize that data into a dashboard in TIBCO Spotfire. And we're going to group all those visualizations into separate sheets so that each sheet contains information on a certain topic. For example, we can create a sheet with the KPI dashboard, which gives a global overview of all the KPIs. And then we're going to go more into detail all our customers, products, shipments, and also give an overview of all the orders and returns. So let's have a look at the final result of our dashboard. Once we publish this dashboard into TIBCO Cloud. And let's have a look at the different pages that we're going to create once we're going to start building our dashboard. So after we've loaded our data into TIBCO Spotfire, we're going to build a dashboard which contains five different pages. And we're going to publish this dashboard to dip gcloud. As you can see, I have my dashboard here, which has a page called KPI dashboard, which gives an overview of all the KPIs. I have a page, customer segments, sales, which gives an overview of all the customer segments and all the sales by customer segment, a customer region. I have the product category sales, which contains all the details on the product categories. And here I can see all my product categories, sales by product category and product subcategory. I have my shipments sheet where I have all my shipment details. Here I can see the average time it takes to ship a certain product and the average cost to ship that product. And then the last table, I have an overview of all my orders and returns. If I now go back to my desktop application, then I can start adding these pages and adding my visualizations to it. So if I go back to my menu and I go to Add Data, then I can add the dataset previously loaded into the physical library. And I opened this dataset. You can see that all my metrics and all my attributes are added on the left side of my screen. And I can see the name of my dataset in here. And on top of my screen I can see the different pages of my dashboard. So I want to start by adding a first page, which is the KPI overview. This page will give me an overview of all the KPIs, such as my total profits, total sales, and number of orders. Then I want to create a second page, which I call customer segment sales. I want to add a third page, which I call product category sales, which will contain all the details of my product categories and product subcategories. And I want to add another page, which will be the page of my shipments. And on this page I want to break down my shipment costs and my shipment times for each ship mode. And I create another page which I call overview, orders and returns. If I want to change the visual team of TIBCO, then I just click on this icon here. And I can switch between light and dark. So for example, I can switch to dark, which gives me a dark background. You can also see that TIBCO automatically recommends adding certain visualizations. So if I click on this icon here, I can get automatic recommendations by tiptoe to add certain visualizations based on the measures and attributes I select. On the left side. 9. Building a Detailed List of Orders and Returns - Exercise: So on the first page, I want to give an overview of all my orders and returns. I do this by adding a new table. So I click on the Table icon. And as you can see, TIBCO automatically creates a new table. Of course I want to customize this table because I want to select the rows and columns that I want to include in this table. So I right-click and I go to properties. And here I can change the properties of my table. If I want to change my columns, click on columns, and they can choose which columns I want to select the, my table. So at the right side you see the current list of columns that are included. If I want to remove some of these columns, I just simply select the column that I want to remove. For example, row ID, and I click on Remove. As you can see, row ID is now removed from my table. If I want to change the order of my columns, I simply click on move up or move down. For example, I can move my customer name and product name, both, both up. So I select both columns and I move them up. I want to move the ship date also up. And I also want to move the order date next to the ship date. If I now close my properties and you can see that my columns are reordered. I can also reorder my columns by simply dragging and dropping those columns in between another column. I can also go to my properties. If I click on the Properties I can here. And as you can see, I can also change other properties. For example, in the general menu, I can change the title of my chart so I can go to Edit. And if I now add a new property for my title, I just simply click on New. I give this property a name. For example, title, orders, and returns. When you give a property a title, you can never use whitespaces. So I remove all the whitespaces in here. I can add a description. This property gives me the title of my order, overview and returns a table. And I can give this a constant value. Overview. Orders and returns. As you can see, TIBCO really gives you a lot of flexibility in creating dynamic properties and really customizing your visualizations. So in case I want to select my new property which have created, I just Simply double-click on this property. And you can see that this property is added to the title expression. I just need to remove this part. Each property is uses the expression which has a dollar sign and then uses the brackets. So I now simply click on Okay. And this Properties edit to my title. I now close Properties menu. I can see that this title is added to my orders and returns table. And what I want to do next is highlight those orders. What I have a negative profit, so I have a loss. And the orders where I have a positive profits, I want to highlight in green, where I have a negative one, I want to put them red. So I can go to Properties again. And if I go to colors, then I can add a new color scheme. So I can add a color scheme for profit, which is the measure that I want to include in my scheme. And here I want to add a certain point, which is 0. And everything below this value will have a red color, and everything above this value will have a creed. So I add my green color here for the positive values. And I add my red color here for negative values. And my 0 will be white. Because my range is very large. I want to narrow down this range by simply clicking on this icon here and selecting percentile here, I can select my percentiles. For example, if I want to include the 75 percent percentile in here and my 25 percent percentile in here. Then you can see that my color comes out very nicely. So as you can see, TIBCO really offers you a lot of flexibility in creating custom visualizations and adding custom values in here. And I want to add a second color scheme for my order priority, because I want to highlight the orders at every higher priority. So I select order priority. And here I select my color mode, unique values. And here I have all my values. And I can choose the color for each of those values. So I can select, for example, a color for my critical values, which I want to color red. Of course. My high ones will be orange, for example. My low ones I want to put in blue. My medium ones, I want to put in yellow. Not specified, can be purple. And empty can be verbal as well. You can also sort your values according to a certain measure. So I can sort by, for example, sales descending. Or I can sort by ship date or order date. And then I can sort by customer name. So I can add multiple layers of sorting here. I can also fonts where I can change my data selection in here. I can also change the appearance of my table by increasing the row height or the number of frozen columns, for example. And I can also show or hide certain items. What I want to do next after I added my orders table is add a filter panel where I can dynamically filter all my orders. So I simply go to filters. And here I right-click and I go to Organize filters to add or remove certain filters. And I remove row ID, Order ID. I keep the order dates. I also want to keep the order priority, but I remove order quantity, sales discount, ship mode, profit, unit price, shipping costs, and all the others except for the ship date. Now I want to move the ship date up next to my order date so that I have a filter for my order date, filter for my ship date, and my order priority. I click on, Okay. As you can see, I have a slide filter and a checkbox filter here. To customize these filters, I can also go to Filter scheme properties. And here you can see the field of type, which I can change. For example, if I want to change the order date filter, I can simply go to the filter. And I can change this datatype or this filter type, sorry, from range filter, list box filter. Where I can just select the date or I can use a text filter to type a certain text field and then it will filter on this certain text. But because this is a data type, I want to include a range filter. I can also reset my filters by simply clicking on Reset of filters. This will uncheck all my active filters. So for example, if I now only filter on the critical orders, and I want to undo this filter, then I can reset all filters. 10. Building a Chart and Boxplot with Shipments - Exercise: So on the second sheet we're going to give information about the order shipments. So here we're going to start with adding a stacked column chart. So I start by going to recommended visualizations and I select my order date. And they also select my own ID. And as you can see, TIBCO automatically gives me some recommendations. I just add one of those recommendations. And the visualization has been added to my page. So if I now go to properties, then I can start editing this visualization. So I give it a title, number of order shipments. And if I go to formatting, I can choose the formatting of my axis. So I can choose to format my vertical axis to a number format with a thousand separator. So I down separator. If I now go to Category Axis, then you can see that I have my order date on my Category Axis. On my value axis, I have my unique count order ID. So this gives me the total number of orders. If I now see the total number of orders for each ship mode, I simply go to colors. And here I can select a column ship mode. And as you can see, my orders are now stacked for each ship mode. Of course, this gives me the total number of orders by order date. But I want to have my shipments. So if I go to Category Axis, then I can add a second column, which is the ship date. I can then remove my other column Order Date by simply right-clicking and clicking Remove. And I have my columns ordered by ship date. If I now want to group those ship dates according to the year, month, and day, I can simply go to the ship date and select year, quarter, month, day of month. And this gives me the possibility to group my dates according to the month, quarter, year, or day. If I now want to switch between the day, month, quarter, or year, I simply slide the bar on the bottom of my graph to the left or to the right. If I want to change this visualization and make it a side-by-side bar visualization. I simply click on side-by-side. And as you can see, the columns are now not stacked anymore, but are presented side-by-side. Okay, so what I want to do next is create a boxplot chart, which gives me the average number of days to ship a certain order for each ship mode. So I click on boxplot that I can go to x axis. And here I can select my ship mode. On my y-axis, I want to have the number of days that it takes to ship the order. So I want to calculate a new column, which is the ship date minus the order date. To do this, I have to close this Properties menu and I go to Insert calculated column. And here I can create a new column, which I call this to ship. And then my expression area, I create my expression, which is the ship date minus the order date. So I just double-click on the available column that I want to add, or I can click on insert column. Here I have all the properties of my column. And here I have different types of functions. So you can see that there are different date and time functions that are logical functions and so on. If I now click Okay, and this new column is created, I can also preview is called a. Here you can see my new calculated column, days to ship, my ship date and my order date. So I click Okay. I go back to my boxplot chart and go to Properties y axis. And here I select my new column, days to ship. And as you can see now I have a message saying that the expression is not valid. So if I go back to my calculated column, if I go to Edit Column Properties and I can see all my columns. And if I then select my days to ship calculated column, then I can see that this has a date type timespan. Of course I need a numeric value. So I go to Edit. And if I look at the functions in here, nice like date and time functions, date, div, then you can see that this formula allows me to calculate the difference between two dates and converts this into a numeric value. So if I want to use this formula, then I simply double-click on the function. Then my first argument is day, because I want to have the number of days. Then I enter my first column, which is the order date, and my second column, which is the ship date. And as you can see, the result is a real Or in numeric value. So if I go to preview and you can see that I can count the number of days in-between my order date and my ship date. Fine. I'll click Okay. Then you can see that my boxplot is updated. As you can see, I now only have three statistics, the count, medium, and outliers. I want to update this and I want to have the average, the standard deviation, the 95 percent interval, and the maximum ship date. So if I go back to properties, go to statistics table, then I can choose which statistics I want to add to my visualization. So if I select the average, the standard deviation, the maximum, and then I select the lower and upper bound of my 95 percent confidence interval. And I add those two measures as well. And I remove the old measures. So I remove the count, medium and outlier count. And my visualization is updated. As you can see, I don't see my average very well on my median because of the outliers that I have here, my scaling is very large. So if I want to fix this, I can go to Y axis, and here I can show a zoom slider. This allows me to zoom in on certain areas of my boxplot. So if I now select the zoom slider here and I slightly zoom down a little bit. Then you can see that my boxplot becomes more visible. And I'll go back to my properties. And what I want to do next is to visualize some reference points. So I go to reference points. And here I select my standard deviation. My median is already selected, and I select my upper bound. I can change the marker. So for my median, I can use a line marker like this. Or I can choose a star marker. For my standard deviation, I can choose a line marker. And for my upper bounds, I can choose a double line marker. And I close this. And as you can see, my visualization is updated. And I can see that my median is a little bit higher for my regular air orders then for my delivery truck or express air orders. Then here you can see the standard deviation, which is a little bit lower here. And hire for my regular air orders. I can also rename this visualization if I go to properties and call this one days. To ship or orders, they see ship. So next I want to create a new box plot for my shipping cost. So I insert a new boxplot. And again, I go to Properties. I call this boxplot order orders. Shipping costs. I go to y-axis. And then here I select my column. If I go to my x-axis, I select my shape mode. I go to reference points. And then here I select my median, my standard deviation, my lower and upper bound again, and also my maximum. I do the same here. So for my maximum, I can use this marker for my median. I can use a star marker. For my standard deviation. I can use this dotted line again. And for my lower and upper bound, I choose a double line. I go to my statistics table, and here I can choose to remove again these selected measures. And then I do the same again. So I add my average, my standard deviation, my lower and upper bounds of my 95 percent confidence interval. And I add those measures to my statistics table. And I also add the maximum. To move a certain measure up or down. I simply click on move up or move down. And I can also add my zoom slider by going to the y-axis and clicking on Show zoom slider. And as you can see, my new box plot chart is created to move or rearrange certain visualizations. I can simply drag and drop the visualization to where I want. So if I now go to Stat than they are on top of each other. If I go to side-by-side, they are standing next to each other. I can also split them evenly by which they are spread evenly on my sheet. So if I want to have my number of shipments below my other two visualizations, I can simply drag and drop this at the bottom. And if I want to drag and drop my box plot charts next to each other, I simply drag and drop them next to each other. To resize a certain visualization, I just simply use this bar to resize them. So now we have finished building our shipments sheet and we can move on to the next sheet, which is the product category sales sheet. 11. Building a Stacked Chart for Sales by Product Category - Exercise: So for our next sheet, we want to start by adding a new table. And this table will contain all the details on the product categories. So if I go to properties and I go to columns that I first remove all the selected columns, and I select only the columns that I want to add. So I select the product category, product subcategory, product base margin, product name. And also seals. I add these columns to my selected columns and I can move certain columns up or downside, move the product base margin here, and I move the product name on top. Then I move the product category next to it. And product subcategory. That finally I have the sales and product based margin. If I now go to colors, then I can add a new color scheme. So if I want to add a new color scheme for sales, then I simply go to sales. So I choose to use a green card and I just simply select the green color here. And the larger seals amounts will have a green color. And the lower sales amount, we'll have a white color. And now add a second color scheme for product base margin. And here I also use a green color. Then I can also go to Appearance. And I can show the cell borders. And if I go to sorting, I can sort my data according to certain columns. So if I want to sort them first by sales descending, then I go to Sales, sort by sales descending. And then my largest sales would be on top. Then I sort by product-based margin, and I sort it descending. So then it will first sort on the sales amount, these ending. And then my records will be sorted on the product base margin descending. And then next I want to add a bar chart which shows my sales by each product category in each product subcategory. So if I go to bar chart and I go to properties, then I go to my value axis. And here I want to see my sales amount. So I select Sales. And then I want to compare my different categories, which are my product category. So here I select product category. And for each product category, so each column will be a product category. I want to have the different product sub-categories. So in my colors, I select Product subcategory. And the final result is a bar chart where each column is a product category and each column contains multiple product subcategories. If I now want to format the y-axis, then I go to formatting, and I go to some seals. And I want to format this as a currency. Currency. And I select decimals to use 1000 separator. Use short number format. And as you can see, my charges update it. Okay, So next we're going to add a graphical table. A graphical table is a table that can contain a visual elements such as sparklines or icon's. So if I go to this graphical table icon here, and I can insert a graphical table. If I now go to properties, then I can rename this graphical table to product category sales. And if I go to x's, then I can select both my product category and product subcategory. For each column I have a sparkline. But if I want to change this, then I can go to settings. If I want to add a new column visualization, I can go to add and add a new visualization, for example, an icon. And here I can create a certain rule to display certain, I can force certain values. I remove this second column, and I close the Properties panel. I don't want to see these legends on the right side, I can simply click on the legend icon here. And legends disappears. And I can rearrange my visa visualizations so I can move this left. And then I move this a little bit to the right. And that's it. My product category seal sheet is finished and I can move to my next sheet, which is a customer segments seals sheet. 12. Building a Treemap with Sales by Customer Segment - Exercise: Okay, So next we're going to build our customer segments sales sheet. And I want to start by adding a TreeMap. So if I click on Treemap and I go to properties, then I can select my size, which is the sum of my sales amount. And my hierarchy will be customer segments. So I select customer segments. And if I want to add a second hierarchy, then I can select my second hierarchy. For example, I can choose region or province as a second hierarchy. And if I go to colors, then you can see that the darker colors represent a larger sales amount and the white color represents a low sales amount. I can also change the colors. For example, I can use a cream color or I can use a red color as well. And I can rename this Treemap to sales. By customer segments and region. We can also use a map to represent the sales for each region and Province. So if you go to map chart, then you can insert a map. And on this map chart we're going to use dots to represent the sales for each province and region. So if you go to marker by and you can select the marker for each province or region. And each marker will be a dot. And as you can see, the dots represent the sales amount. So if you have a larger dot, this will mean that the size of the total sum sales will be higher in this region or province. I can use color by to give each province dot a different color. And as you can see, all my provinces have a different color now. And in the shape by I can select if I want to have different shapes for each region. If I now go to properties, then I can change the layout of my map chart. So here you can see the layers. There is a map layer, which is the background, which contains my map. And then I have the marker layer which contains all the markers for a different regions. If I go to settings, then again adjust the settings for my marker layer. So here I can, for example, change the size of my dots. And I can increase the size of each of my dot markers. And here in positioning, I can see which geocoding table is used to geocode or fetch the longitude and latitude coordinates for my provinces. And here I used the Canada provinces and territories table because this contains all my provinces within Canada and all the geo-coordinates for these provinces. If you want to change this geocoding hierarchy, you can just go to geocoding hierarchies. As like the hierarchies you want to use for your geo-coding. So did go actually automatically joins my provinces with the provinces in Canada, provinces and territories table. And then fetches the latitude and longitude coordinates in this table, which are then used to present the dots on my map chart. Okay, so next we're going to add a KPI charts. So I start by adding a new KPI chart here. A KPI chart can give you an overview of some important KPIs, such as the seals for each product category or each customer segment. So in this case, we want to add a KPI chart for the total sales for each customer segment. So if I go to properties and I go to KPIs, then I can see that there is one KPI already, and I want to remove this one and add a new KPI. And in the KPI settings window in here, I can customize this KPI. So I want to have my total sales amounts of my y-axis will be sum of sales. My timer x axis of my KPI will be ordered date, and my Tau will be by customer segments. I can also format my number values. Because I have a sales amount, I want to have a currency, and I want to have a short number format. And I use a 1000 separator. And I want to have two decimals. Then close this window. And I move my KPI chart to the right. And if I want to change the size of my tiles, then I can simply go to properties. And I can change the appearance and change my tile width and make this smaller. So I can change this to a smaller width so that I can see all my KPI is next to each other. 13. Building a KPI and Trendline Chart - Exercise: So next we're going to build our KPI dashboard. In our KPI dashboard, we just want to have a brief overview of all the information. So we want to have a chart with the total number of sales orders. Want to have a chart with the total sales amount and also the profit. And also we want to have a KPI overview of some of the KPIs, such as the total sales amount, total profits, and total number of orders. So I start by adding a new line chart for the total number of orders. So if I go to properties and I call this chart total number of sales orders. My x-axis will be my order date. And my columns will be the count of the number of orders. So I counts or ID. As you can see, the aggregation, It's now on unique counts. So this will count all the unique order IDs, which will give me the total number of orders. I do the same for my sales amount. So I create a new line chart. And I go to properties. And I call this blue line chart. Total sales revenue. My x axis will be the same because I want to see the total sales amount or a total revenue over time. So this will be my order date. And my y-axis will be the sum of sales. If I go to formatting, then I can form it. My sales amount to a currency. And I use a short number format. And I also create a line chart for my profit. So I insert a new line chart. I go to Properties. I call this one total profit. And I go to my x-axis, which is again the order date. And my y-axis will be profits. And they go again to the number formatting. And I format my profits as a currency. And then I can stack my different visualizations. Finally, I also want to add a KPI chart so I insert a new. Kpi chart, which will contain my total sales revenue, my total profit, and total number of sales orders. So if I go to properties and I go to KPIs, they remove this KPI and add three new KPIs. One which has my some of my sales. I remove the tile by because I just want to show the total sales amount. And I want to adjust the number formatting. So I would do formatting and cages to a currency. I do the same for my second KPI, which is the total number of sales orders. So I use a unique counts of the order ID and remove this dial buy property. And the same for my profits. I select profits. They removed this tile by property. And I change the number formatting to a currency. I now want to hide the line charts which are present within my KPIs. Then I can simply go to Properties. I go again to the KPIs. And here I go to settings. And I go to appearance. In here I can hide the sparkline. And I do the same for my two other APIs. So I go to Appearance and hide the sparkline. What you could also do is rename this label here. To do that, I have to go to the KPI, go to Settings again. And then I go to my sum of sales or my y-axis. And I want to change the display name of this value. So I want to change this, for example, to revenue. And as you can see, the expression also changes. And my some of my sales amounts are displayed as revenue. Do the same for my two other KPIs. So I go again to my expression on my y-axis, and I call this one number of orders. And they do the same for my profit. And I rearrange my visualizations. And I can put my KPIs on top. And I changed the format of my profit KPI, and change this to two decimals. And as you can see, my KPI dashboard is finished. 14. Visualizing a Dashboard: So after we have created our dashboard, we can share the dashboard and publish or dashboard to Spotfire clouds. There are different ways of presenting your dashboard. You can mark certain cells within your visualizations. And by marking, you will highlight certain data points, your visualizations. You can also filter certain data visualizations and only include the data that match your filter condition. With details on demand, you can view the values of the items that you have marked within your visualization. So this gives you an idea, the data points and the values of the records that are behind the visualization. Within Spotfire, you can also use tags. Tags are used to structure or classify certain data records. For example, when you mark certain data points and you want to keep these datapoints a certain classifier. You can use a tag collection and they tag to save those data records. Under a certain tag. The x also gives you the option to save certain marked records to classify a structure your data records, to reuse those data records again later. Bookmarks, on the other hand, give you really a snapshot of entire sheet at a given state. So it doesn't DAC the data structure behind it, but only saves a sheet at a certain moment in time. You can also add certain comments to visualizations or sheets using conversation. When you're collaborating with different people, it might be useful if you can add a comment and other teammate can add another comment on your comments. And this can improve collaboration with different people on a certain dashboard. Finally, we're also going to look at how we can publish our dashboard on Spotfire Cloud and upload the dashboard on the library on Spotfire Cloud. And we're also going to look at how we can export either our visualizations on our dashboard are also export the data from our analysis onto Spotfire clouds. We can also export our dashboard as an HTML webpage where the user can open the dashboard in his or her browser and view and filter the dashboard within the web browser. We can also do a static export of our dashboard to a PDF or a PowerPoint to save the dashboard locally near PDF or PowerPoint file on your desktop. So within the exercises, we're just going to explore the possibilities of viewing or data, of marking the data, filtering the data, and also adding tags and bookmarks. We're also going to create a custom filter for each page so that you can easily filter out certain fields. And we're also going to publish our analysis on to Spotfire clouds. 15. Custom Filters and Dynamic Filtering - Exercise: So in the previous exercises, we've seen how we can load data into Spotfire and also create dashboards in Spotfire, what we're now going to do is have a look at how we can present those dashboard and start analyzing the data within our dashboard. So Spotfire, you can either mark certain data or you can filter on certain data where you mark certain data, only the data that you want to select will be highlighted. For example, if I mark the delivery truck orders in my visualization, then I can see that all my other visualizations have only marked delivery truck orders that I have selected within my data range. In here. This is called marking. To reset all the markings in your sheet, you can simply go to Edit. And then you can go to reset all markings. And all the visualizations will be completely highlighted. Again. Within the view step, you can show all active filters. So if I click on filters that I can see all the filters on the right side of my sheets that are currently active. If I want to select or deselect a certain filter, I can simply select or deselect one of the filters types in here. Close the filter panel again, you can simply click on the Close I can in here. So what we're going to do next is add filters on our pages. So if we start by going to the orders returns sheet, we can go to add it's organized filters. And here we can select or deselect the filters that we want to add. So we select only ship date, order date, ship mode, and order priority BY select all the other filters because we do not want to include those filters within our sheet. If I then go to my Shipments page and I go to Organize filters again. So I de-select all the filters first. And then I select the ship date, order, date, order priority as well. I also want to have the shape modes. And that's also add the shipping cost. And we can also add the priority, which is in here. And if I then go to view filters, I can see my newly created filters on the right side. And we do the same for the product category sales sheet. So I go to Edit organized filters. And I de-select all the filters. And I only select the order date, the product category, and the product subcategory. I do the same for my customer segments, sales. So here I go to Organize filters again. And I only want to have the Order Date, the customer segment, region, and Province. And on the KPI dashboard, we don't want to have any filters. So here we just de-select all the filters. 16. Adding Tags and Bookmarks to your Dashboard - Exercise: So when you're creating visualizations in Spotfire, you might want to see the actual data within your visualization. This can be done through the details on demand. If you go to View and select details on demand, you can actually see the data of a certain visualization. For example, if I click on this graph that I can see the data within this visualization. So let's take an example. For example, if we go to the customer segments sales, and we want to retrieve the list of customers for the region, Ontario within the Home Office sales category. Then we can go to details on demand. And we select the Ontario home office region. And here we will see the list of customers within the region of Ontario. And in the customer segment, home office. If we now want to see the products that these customers have bought, we can go to product category sales, and view the details on demand. And here we will see the list of products that these customers have bought. So only the customers and customer segment that has been marked within my customer segments seal sheet in here will be shown indeed details on-demand panel. On the right side. You can also see that 5,494 rows have been marked out of a total of 75 1887 rows. We can also create a specific tag for the selection of March rows. So if you go to tags, then we can select the table. For example, we can select the customers table and add a new deck collection. And we call this home office sales, Ontario. And we can add a description. This gives the selection of customers within the Home Office customer segment for region Ontario. And we add a new tag to this collection. And we call this tag customers tech. You can now see that we don't have any row stack yet. But if we go to the customer segments seal sheet and we open the text file, we can add the current selection of March rose to the stack. To do this, we click on the customer stack and we add the tag to the selection of March rows. And as you can see now, the 54 rows for Home Office Ontario are now added to it. It's Home Office Seals Ontario customers tag. If we then reset or markings, we can still go to the stack and see the customer stack in here. And if we then double-click on the stack, we are able to filter again on Home Office Ontario without clicking on this box. This allows you to save certain markings and reuse them later. In case yet you don't just want to save your markings, but want to save your entire sheet. At the current set of analysis, you can just add a bookmark. So if I close the tax panel now and I add a new bookmark in here that I can save the current worksheet. I can save this under Home Office, Ontario. And this will save the entire worksheet. So if I now undo all the markings, and if I then go to my bookmarks and I can see the previous sheet that has been saved in here. And I can apply or view this worksheet to see the actual previous state of my worksheet. 17. Publishing your Dashboards on TIBCO Cloud: So after we've created our analysis, we also want to share this analysis with, for example, colleagues. And we can do that by going to File Export. And here you can see you have different export options. If we want to export just an image. For example, if we just want to export this map chart, we can click on expert visualization to image. This will save the image of my map chart. If you want to save the data within our dashboard, we can go to File, export data to file or data to library. This will export just the data or the records that we have loaded into Spotfire. We can also export to PDF or PowerPoint. If we want to save our entire analysis file, we have to save this file as a file locally or as a library item within typical Cloud. For example, if I want to save this analysis found within the library, I click on library item. And here I can see the folder of my team organization. And I can save this analysis fall within the library, under the organizations folder. Within the data loading settings, I can edit the settings for loading data from multiple data sources. And for example, only load data when data is possible. Use store data so don't reload my data, are always reload my data and always use new data. So I save this analysis file into typical cloud. Finish. And I will get this confirmation that the analysis file has been published. I also get a link to the library where I can see my analysis file. If we then click on this link, we will be redirected to the library where you can see the recently published Spotfire analysis file. And from the library I can also open this file. If we now go back to Spotfire. We can also access the analysis file to our web browser. And what we'll get is an embedded analysis file within your browser. So if you just click on this link, you can see that the analysis file has been embedded into this webpage. And you can see the different pages that we have created within Spotfire desktop. In here, we can also filter or mark certain items. And we can also share this link with different users. You can also see that you can add certain bookmarks here at filters or UC details on demand to see the data within your visualizations. If you want to start a certain conversation, we can add a certain remark in here. So if I want to add a comment, I can say, for example, Welcome to our dashboard. Are welcome to our KPI dashboard. This dashboard gives an overview of the most important KPIs. My post this comment. And you can see a comment here on top of this webpage. And last but not least, you can also send an e-mail to different users to notify that your analysis has been published and send the link to those users which take an access to view the analysis file, review your dashboard within their browser. So if I click on Send Email, you can send an email with a link to the analysis file on typical Cloud. And also together with a link of the web client location of your dashboard. And all the users who receive this link or received this email can access or view your analysis file that has been published on TIBCO Cloud. So thank you all for watching this course. In case you have any questions, please let me know. You can also leave a review and a rating on the course landing page and let me know if you enjoyed this course. Thank you very much.