Tableau is a leading data visualization tool and one supported by Openbridge. Tableau focuses on interactive visualizations and has native connectors to some of the data sources you need to analyze the data from. It’s even better if all of your data is stored in one place, and you don’t have to work hard on joining the data from multiple sources in Tableau as it is not built for data cleaning and wrangling.
Amazon Redshift is a leading cloud data warehouse solution. Combined Tableau and Redshift make a powerful pairing for analytic workloads.
How to connect Tableau to Amazon Redshift
In this article, we will guide you through the process of connecting Tableau to your Redshift data warehouse and building your first visualization.
Step 1: Select connect option
Open Tableau and select “Amazon Redshift” from the Connect options in the left-hand toolbar:
Step 2: Enter credentials
Enter the server address, database, username, and password provided by Openbridge into the Amazon Redshift Connection pop-up.
Once you enter and click “OK”, assuming your credentials are correct, you will be connected. Time to create your first visual!
Step 3: Select a schema
Since we are using Openbridge data our first step is to select the ‘openbridge’ schema. This will list a collection of tables in Redshift under that schema. You simply drag the desired table(s) to the right. In this case, we are using DoubleClick data:
Select the ‘openbridge’ schema
Step 4: Create a new worksheet
Click on a new worksheet. You will see the tables fields listed as either Dimensions or Metrics
Create a worksheet
Step 5: Configure rows
- Drag ‘Date’ field from Dimensions section onto the row shelf
Add “Date” dimension to row
2. Click the drop-down on the right of the Date field, select ‘More’ and then ‘Custom’
3. Choose ‘Month/Day/Year’ format
Choose the desired format
4. Drag the ‘Clicks’ field from Metrics onto the Text mark
Add “Clicks” to columns
Step 6: Create a chart
Select the Line Chart from the ‘Show Me’ dropdown
Voila! Your first visual in Tableau with the data from Redshift is ready!
Enjoy the view!
Want to see how to use Tableau and Redshift with social data? Check out how we did we paired Tableau and Redshift with Instagram data: Instagram How To: Powerful Data Analytics Tips
If you have multiple data sources you need to analyze data from, data pipeline solutions like Openbridge can help you. You can stream all the data from social media, CRM, point-of-sale, marketing, advertising platforms, and more to the data warehouses like Amazon Redshift and have it ready for analysis in Tableau.