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 recent 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.