Former Tableau Engineer Reveals How Domo Enhances Different BI Instruments

As a options engineer, I’ve labored for 2 fashionable enterprise intelligence (BI) suppliers: Tableau and Domo. I even have expertise utilizing different BI instruments all through my profession. Through the years, I’ve seen many organizations select to make use of two BI options (leveraging the strengths of each) to unravel totally different use circumstances, even creating worthwhile synergies between platforms. This has enabled them to unravel information issues a lot sooner whereas decreasing total prices in customized growth work, hiring, and extra. 

To assist folks make well timed data-driven choices, your BI device must be sturdy in a number of key product areas, akin to: 

• Information visualization 
• Information supply integration
• Warehousing
• Information transformation
• Information governance
• Machine studying and NLP

However most instruments aren’t sturdy in all six, or corporations lack the sources to allow every element successfully. That’s why bringing instruments collectively could make every yet another highly effective. For example, I’ve discovered that Tableau shines in sturdy information exploration. Energy BI has useful Excel integrations for the Excel energy customers and information connectivity to the Microsoft stack. 

Domo shines in making information integration and transformation straightforward for everybody. They give attention to safe, well-managed self-service—everybody will get the information they want, and nobody sees delicate information they shouldn’t. Domo is usually integral to augmenting areas the place present options like Energy BI and Tableau could not focus as a lot. For some organizations, combining these instruments and maximizing every one’s strengths can take advantage of sense for his or her enterprise.  

How Domo can work with Tableau 

A typical use case I’ve seen firsthand for Domo and Tableau getting used collectively is in locations the place Tableau has a big footprint. Do not forget that Tableau’s energy is information exploration, not information entry. It’s usually the case that individuals can’t entry the information they want in Tableau to make fast choices. That’s as a result of information is usually centralized earlier than Tableau customers can entry it.  

Which means a marketer, for instance, should consolidate information from Google Advertisements, TikTok, YouTube, and Fb Advertisements into Tableau workbooks—both on their very own or by getting in line for IT’s assist. These efforts are well timed, pricey, and irritating.

Constructing customized pipelines, organising net information connectors, or contemplating iPaas options—belongings you would wish to arrange information entry in Tableau—can take months. It will probably additionally take time to get BI sources to attach and construct out the required Tableau visualizations. 

Domo cuts the time in half, or extra—and makes it doable to have a leaner group with specialised instruments—fairly than a bigger headcount with a heavy funding in folks with specialised abilities. In Domo, that very same advertising and marketing group will get entry to over a thousand pre-built connectors which allow API connections to cloud-based techniques.

Domo helps and maintains these connections in order that customers can self-serve and join to those information sources and never fear about API adjustments on the seller facet. Then, Domo will deal with all updates as wanted. 

Apprehensive if IT requires all information to be centralized in an present information lake? Domo isn’t a knowledge gatekeeper—any information introduced into Domo will be written again to any database or cloud system! When you’re prepared to mix Domo and Tableau, we’re sharing a few how-to guides.  

The way to join a Domo information set to a Tableau Workbook 

To attach a Domo information set to a Tableau Workbook, you will have two choices.   

Tableau Net Information Connector 

This connector permits customers to entry information from a Domo information set and visualize it in a Tableau workbook. The Tableau Net information connector framework makes an API name to a Domo information set, which may then create a Tableau extract to energy your Tableau Workbook. This opens a whole bunch of potential information connections in your staff utilizing Tableau. (Please contact your Domo consultant for entry.) 

Domo Information Driver

Domo ODBC Information Driver is an Open Database Connectivity (ODBC) driver that can be utilized to fetch information from a Domo information set. It may be used to add bigger Domo information units (over 10 million rows) to Tableau workbooks. Domo ODBC Information Driver fetches information from Domo over HTTPS. The question execution time relies on the dimensions of the information and the information pace of your community. Discover extra documentation right here about set up. (Once more, please contact your Domo consultant for entry). 

How to connect with a Tableau extract from Domo 

If you wish to carry information saved in your Tableau server or cloud into Domo, right here’s what Domo engineers would suggest:  

Tableau Connector:  

Domo has a Tableau connector that takes an present Tableau extract and creates a Domo information set that then is flowed into your Domo dashboards. You may then use this information to construct an app with our low code app platform or construct an easy-to-use dashboard interface. See documentation right here.  

How Domo can work with Energy BI 

When you’re a Microsoft firm, you could have already got entry to Energy BI. Domo’s engineers imagine that’s not all it is advisable to construct sturdy information experiences—however you should utilize Energy BI’s integrations to make your Domo information expertise even stronger and smoother.  

Listed here are 3 ways you may carry the 2 platforms collectively, getting the connectivity of Microsoft and the information entry and integration energy of Domo: 

1. An ODBC Driver connects Energy BI on to Domo. This permits customers to leverage all of Domo’s connectors and ETL layer for information transformation. In the meantime, your staff can nonetheless use Energy BI’s information modeling framework in Energy BI Desktop. This mix creates a “better of each worlds” expertise—significantly for extra conventional information analysts preferring a star schema mannequin over Domo’s flat mannequin.  

2. SQL/database writebacks (particularly SQL Server) or Domo’s Cloud Amplifier is an alternative choice. Energy BI is usually layered on prime of a SQL database to make it extra scalable. However, in fact, this then restricts the utilization to information analysts and builders. Most connections should be absolutely coded by information engineers and designers to get the information within the warehouse. This creates a bottleneck, which suggests initiatives are delayed, deprioritized, or don’t even make it on the roadmap. That is the place the Domo integration cloud is available in: It will get information into the warehouse in order that it may be utilized by Energy BI. By Domo’s connectors and ETL, the information turns into rather more accessible and environment friendly. 

3. Energy BI Writeback Connector is in beta mode however works equally to the ODBC driver. You should utilize Domo’s connecting and modeling layer to prep information and ship it to Energy BI. The connector then pushes the Domo information set into the Energy BI Service (On-line) as a Energy BI Dataset, which may then be utilized in each Desktop and Service to create new reviews. 

See for your self how combining your instruments builds a stronger resolution 

Two options working collectively can usually be the reply to enabling data-driven choices for the enterprise in a well timed and environment friendly method. Domo can match into present enterprise tech stacks to enhance, fairly than rip and substitute, and assist you higher combine, remodel, or visualize your information.  

And now, you may attempt Domo without spending a dime.