As a options engineer, I’ve labored for 2 widespread 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 resolve completely different use instances, even creating useful synergies between platforms. This has enabled them to resolve 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 software must be robust in a number of key product areas, comparable to:
- Information visualization
- Information supply integration
- Warehousing
- Information transformation
- Information governance
- Machine studying and NLP
However most instruments aren’t robust in all six, or corporations lack the sources to allow every part successfully. That’s why bringing instruments collectively could make every yet one more highly effective. As an 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 simple 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 commonly integral to augmenting areas the place current options like Energy BI and Tableau could not focus as a lot. For some organizations, combining these instruments and maximizing each’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. Keep in mind that Tableau’s power is information exploration, not information entry. It’s typically the case that folks can’t entry the information they want in Tableau to make fast choices. That’s as a result of information is commonly centralized earlier than Tableau customers can entry it.
Meaning a marketer, for instance, should consolidate information from Google Adverts, TikTok, YouTube, and Fb Adverts 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 want to arrange information entry in Tableau—can take months. It will possibly 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 staff with specialised instruments—slightly than a bigger headcount with a heavy funding in folks with specialised abilities. In Domo, that very same advertising staff 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 modifications on the seller facet. Then, Domo will deal with all updates as wanted.
Nervous if IT requires all information to be centralized in an current information lake? Domo is rarely a knowledge gatekeeper—any information introduced into Domo could be written again to any database or cloud system! In the event you’re prepared to mix Domo and Tableau, we’re sharing a few how-to guides.
Easy methods to join a Domo information set to a Tableau Workbook
To attach a Domo information set to a Tableau Workbook, you have got two choices.
Tableau Internet Information Connector
This connector permits customers to entry information from a Domo information set and visualize it in a Tableau workbook. The Tableau Internet 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 lot of potential information connections on 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 depends upon the scale of the information and the information velocity 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 convey 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 current 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
In the event you’re a Microsoft firm, it’s possible you’ll have already got entry to Energy BI. Domo’s engineers imagine that’s not all you might want to construct robust information experiences—however you should utilize Energy BI’s integrations to make your Domo information expertise even stronger and smoother.
Listed below are 3 ways you may convey the 2 platforms collectively, getting the connectivity of Microsoft and the information entry and integration energy of Domo:
- An ODBC Driver connects Energy BI on to Domo. This enables 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 mixture creates a “better of each worlds” expertise—significantly for extra conventional information analysts preferring a star schema mannequin over Domo’s flat mannequin.
- SQL/database writebacks (particularly SQL Server) or Domo’s Cloud Amplifier is an alternative choice. Energy BI is commonly layered on prime of a SQL database to make it extra scalable. However, after all, this then restricts the utilization to information analysts and builders. Most connections have to be absolutely coded by information engineers and designers to get the information within the warehouse. This creates a bottleneck, which implies tasks 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 way of Domo’s connectors and ETL, the information turns into far more accessible and environment friendly.
- Energy BI Writeback Connector is in beta mode however works equally to the ODBC driver. You need to use 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 stories.
See for your self how combining your instruments builds a stronger resolution
Two options working collectively can typically be the reply to enabling data-driven choices for the enterprise in a well timed and environment friendly method. Domo can match into current enterprise tech stacks to enhance, slightly than rip and exchange, and assist you to higher combine, rework, or visualize your information.
And now, you may attempt Domo free of charge.
