> ## Documentation Index > Fetch the complete documentation index at: https://openops-f559c8bf.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Data Visualization > How to create and use charts and dashboards in OpenOps Analytics You can visualize data that you collect with [OpenOps tables](https://openops-f559c8bf.mintlify.site/reporting-analytics/tables.md) and display the visualizations in the **Analytics** view in OpenOps. In addition to OpenOps tables, OpenOps Analytics can connect to and visualize your existing data sources, such as CSV files, Google Sheets, Postgres databases, and more. ## Analytics admin portal To configure data visualizations, you need to visit the Analytics admin portal outside of the main OpenOps application. The portal is available at the IP address of your OpenOps instance, via port 3002: [http://your-ip:3002](http://your-ip:3002) ![Analytics portal login form](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-signin.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=4291129895a85541b98af08a860cbb9a) To sign in to the Analytics portal, use `admin` as the username and the password defined with the `OPS_ANALYTICS_ADMIN_PASSWORD` variable in the `.env` file in your OpenOps installation folder. (If you haven’t changed the password, the default is `please-change-this-password-1`.) Once you log in, you can see two built-in dashboards: **FinOps** and **Homepage**. Modifying the **FinOps** dashboard will affect the **Analytics** tab in OpenOps. ![Built-in dashboards in the analytics portal](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-builtin-dashboards.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=dd365bc031c791bceea0fab2540faed2) Behind every OpenOps table, there is a Postgres database view that can be used to build charts and queries. When a new table is created in [OpenOps tables](https://openops-f559c8bf.mintlify.site/reporting-analytics/tables.md), the system automatically creates a new database view with the naming convention *table name \_ table id \_ userfriendly*. You can use this view to create dashboards in OpenOps, as well as connect it to other BI systems. ![OpenOps tables](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-tables.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=f9a38f076de0d2c34a99a52ca322854f) ## Building new charts To configure a new chart to display in the **Analytics** view in OpenOps, do the following: 1. Create a new dataset for the OpenOps table that you want to source data from. To do this, navigate to **Datasets** and click **+ Dataset**. This will allow you to create a dataset on top of one of your OpenOps tables: ![Datasets](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-datasets.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=5351e2f6d5d91c848a8981277c2448f7) ![New dataset](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-new-dataset.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=686e7bd86282b6c08c3248b0173fd06b) 2. After the dataset has been created, create a new chart by navigating to **Charts** and clicking **+ Chart**: ![Charts](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-charts.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=6055daf289ea128412c4ffe821f3c008) 3. Configure your chart. Refer to [this Superset documentation page](https://superset.apache.org/docs/using-superset/creating-your-first-dashboard#creating-charts-in-explore-view) if you need help. ![New chart](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-new-chart.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=945438f6938b1061c3e5bb22f11e9da0) 4. When saving the chart, add it to the **FinOps** dashboard: ![Saving a chart](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-save-chart.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=e702419a02adb258d5c74e230b74d2bd) As a result, the chart will display in the **Analytics** view back in OpenOps: ![Chart in OpenOps Analytics](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-chart-in-openops.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=283bc3630b331648832fa80030f1af29) For more information on how to create charts, see [Superset documentation](https://superset.apache.org/docs/intro/). ## Connecting to external data sources Here's what you can do to connect OpenOps Analytics to external data sources such as CSV files: 1. In the Analytics admin portal, go to **Settings > Database Connections**. ![Database connections settings](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-external-menu.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=4a465306ac27b51df3283508def09cb7) 2. Click on **+ Database** to connect to an external data source, such as your own Postgres instance or Google Sheets. 3. Once you have created a database connection, if you’d like to upload CSVs to it, click the **Edit** icon for the database connection: ![Editing a database connection](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-edit-db-connection.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=14ff8154a4a5c44df094b8ec98da9614) 4. In the popup that displays, go to **Advanced > Security**, scroll down, and enable **Allow file uploads**. ![Edit database popup](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-edit-database.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=8bf2c6272f0d8e5f06d87f7131f9b780) ![Allowing file uploads](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-database-allow-file-uploads.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=f97bc92d24570d1cbd14dc58ffc9317d) 5. Click **Finish**. As a result, you should now be able to upload CSV files into your database: ![Uploading CSV into a database](https://mintcdn.com/openops-f559c8bf/jHP4JOF17NoTQvTt/images/analytics-upload-csv-to-db.png?fit=max\&auto=format\&n=jHP4JOF17NoTQvTt\&q=85\&s=d37b52d8aa5ac48d6e04406c1eba083e) You can now build charts based on the data from your external data source, similar to how you do it with OpenOps tables. When you add charts to the **FinOps** dashboard, they become available in the **Analytics** view in OpenOps. Feel free to contact [support@openops.com](mailto:support@openops.com) if you have any questions or need help with your installation. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.