TARGIT Data Discovery

Originally published January 31, 2020. Updated May 15, 2024

TARGIT’S Data Discovery tool is all about smashing the boundaries of your traditional data warehouse. Business doesn’t stop at the walls of your company, and the ability to analyze other data sources than just your own is the only way to make truly data-driven decisions.

The impressive power of Data Discovery has helped all our customers to make an impact on their business, so we want to arm you with the knowledge you need to take full advantage of one of our favorite features of TARGIT Decision Suite.

Dig deeper. Expand your insight further.


How to read data from a local Excel file


Data Discovery converts Excel files into Data Discovery models so they can be integrated seamlessly and analyzed against other data.


How to combine external data with data warehouse data


I'll show how quickly you can build a new analysis to feed the Data Discovery model and demonstrate how to add files to the server. I also show how to use the more advanced Data Modeler to add data sources and cubes. The Data Modeler editor lets you add additional data sources to an existing cube as well as the TARGIT analyses that was just created.


How to transform Data Discovery data with formats


I use the Data Modeler to add a format, which like a layer on top of any data source. Formats display the data precisely the way you want to see it, organized in the way that makes the most sense for you, such as by date. Formats are updated any time the original data sources are updated, so they are always in sync. In formats, users can remove fields, add new fields, pivot, and perform calculations.


How to prepare data with Power Query in Microsoft Excel


You can also use Power Query to reshape Excel data directly in TARGIT® Data Discovery before combining it with different sources.


How to build hierarchies


TARGIT’s Hierarchy Editor lets you build hierarchies to fit any need. It’s easy to select from the drop-down list which data you would like included, give the hierarchy a name, and upload it automatically to TARGIT. I'll show you how to use the Hierarchy Editor and what it looks like when your analysis is automatically updated with a new hierarchy.


How to integrate data from 1,000+ apps into Data Discovery with Zapier


Watch how user-friendly it is to open up Zapier and integrate data directly into a TARGIT spreadsheet. I'll use Zapier to pull in data from a Trello task flow as an example of how quick it is to integrate data, open it up as a spreadsheet, and analyze away.

Our TARGIT Data Discovery webinar should serve as an inspiration for using some of the many features of Data Discovery to integrate, analyze, and understand more data in context than ever before. 

See TARGIT Data Discovery in action

Originally published November 20, 2018. Updated May 15, 2024