Data360 Analyze: Beginners Guide

This article is aimed at Analyze's new users. New users often feel a little overwhelmed with all that Analyze has to offer, and are unsure how to leverage the functions to produce results. We understand it can be difficult getting to know a new product, so we've compiled Clue Cards for you that we hope will help you with the basics. 

 EXPECTED LEARNING OUTCOMES:

Every great data flow starts off with a connection to a data source. This article and video will show you how to connect to common file formats, perform simple transformations and output the data to an Excel file. From the video and Clue Cards...

- you'll learn some Analyze product terminology

- you'll become acquainted with some of the nodes you'll need to complete common tasks

- you'll learn more about datatypes and functions, specifically what functions can be performed on what datatypes

- you'll learn the basics, fast. 

If you don't see what you need here, try this link for further learning: Frequently used nodes and functions

Software version: 3.6.1

THE ATTACHMENTS:

In the attachments sections of this article, you'll find an Excel file containing some useful information, and some sample data to help you get started. 

1. The Clue Cards:

Sheet 1: Analyze Terminology - here you'll find an overview of terms that are commonly used among Analyze users, and a definition of them as they apply to Analyze.

Sheet 2: Analyze Tools- here you'll see how Analyze is functionally categorized after the data has been brought in. Typically, the functions are to organize, modify & calculate. You'll also find common Helpful Links here. 

Sheet 3: Common Task - this page outlines some of our more commonly performed tasks, and the  nodes that can help you complete that task. Some of the more common tasks include organizing data, performing calculation and modifying data. This page tells you what category each node falls under in the Node Palette, and provides a link to where you can access the node help directly for more information. 

Sheet 4: Datatypes & Functions - when using functions, the data type is very important. Not all functions can be performed on all data types. This page gives an overview of what functions can be performed on each data type. 

Sheet 5: FAQ's - a list of the most commonly asked questions in Data360 Analyze.

2. The Sample Data:

This contains both .csv and .xlsx files that can be used to acquire data using the CSV Input Delimited node and the Excel File nodes respectively. 

We'd love to hear your thoughts on this article and it's contents, or if you have a use case that you'd like to see demonstrated in a video / article, please let us know by posting in the comments below, or email me directly at ccostello@infogix.com