Integrating Business Intelligence Tools with Databricks
The best way to analyze big data may often involve the use of a combination of platforms. This course delves into the integration of Databricks with BI tools such as Power BI, Tableau, and Qlik Replicate to perform business intelligence tasks.
What you'll learn
While Databricks is a powerful platform which supports a variety of business intelligence functions on its own, there will be use cases where it is necessary to link this service with external BI tools. In this course, Integrating Business Intelligence Tools with Databricks, you'll learn the integrations available for Power BI, Tableau, and Qlik Replicate. First, you'll explore the need for tool integrations with Databricks, including the use of the Partner Connect feature to make such integrations seamless. Then, you'll discover the hands-on portion of the course which looks into the precise steps involved in connecting Power BI and Tableau to a Databricks workspace. Finally, you'll learn how data in a SQL database such as SQL Server can be replicated in Databricks using the Qlik Replicate utility. Once you complete this course, you will recognize precisely when BI tool integrations should be used, and how these can be implemented using the resources available in Databricks.
Table of contents
- Course Prerequisites and Outline 2m
- The Need for Tool Integrations 4m
- Business Intelligence Tools and Databricks 4m
- Power BI and Databricks 3m
- Demo: Creating a Table in Databricks 4m
- Demo: Setting up Clusters and an Access Token 5m
- Demo: Connecting to Databricks from Power BI 6m
- Demo: Connecting Power BI to Databricks with Partner Connect 4m
- An Overview of Qlik Replicate 2m
- Demo: Provisioning an Azure Storage Account 3m
- Demo: Creating an Azure SQL Database 3m
- Demo: Populating the Azure SQL Database 5m
- Demo: Connecting to the Data Source from Qlik Replicate 7m
- Demo: Generating a Personal Access Token 4m
- Demo: Configuring the Target Endpoint for Qlik Replicate 7m
- Demo: Kicking off the Qlik Replicate Task 5m
- Course Summary and Related Content 1m
