Dive Deeper into TARGIT Data Discovery

noviembre 20, 2018

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 a special place in my heart, and I want to make sure every TARGIT user is armed with the knowledge they need to take full advantage of one of my favorite features. You can watch my Data Discovery webinar, now available on demand. Watch it today.

While the basics of Data Discovery are relatively intuitive for regular TARGIT users, I'll cover more advanced features that help users dig deeper and expand their insight further. Follow along as I demonstrate:

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.

This 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 it all in action in the on-demand webinar.
Jesper da Silva Endelt - Headshot

Jesper da Silva Endelt

Senior Solution Architect
I've been working at TARGIT for more than a decade now, and I am currently working as a Senior Solution Architect.
Continue Reading...

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.