...
||Completed||Priority||Locked||CreatedDate||CompletedDate||Assignee||Name||
|T|M|F|1311171217050|1311171231606|dmurphy|Job Search|
|F|M|F|1311171225228| |dmurphy|kkkk|
...
Table of Contents | ||
---|---|---|
|
Multimedia name Create_User.swf
Note: An admin can also create a user by selecting “User” under the “Create” menu.
Multimedia name UsersAndGroups.swf
Multimedia name BatchUserImport.swf
Field | Required? | Length | Default | Description |
---|---|---|---|---|
Username/Email | Yes | 5-60 |
| User's username, which must be an email address. |
First Name | Yes | 1-60 |
| User's first name. |
Last Name | Yes | 1-60 |
| User's last name. |
Password | Yes | 5-60 |
| User's password. |
Role | Yes | admin or user | user | User's privileges within the application. |
Dataverse Overview
Not only can your Dataverse consume disaggregate data, but it can also bring your data to life! By clicking into a Dataview the user is able to view the time in which the data was updated and the number of records that reside in it.
Accessing Dataviews (Dataverse Page)
There are two ways a user can access their Dataviews from the home screen:
From the “Dataverse” page, users can easily see all created and shared dataviews that they have access to. The user may organize their Dataviews using the menu bar at the top of their screen to filter and organize their Dataverse.
Dataviews: Allows users to view all dataviews and datasets that they have created or that have been shared to them.
Datasets: Allows users to only view datasets that they have created. All other dataviews that have been shared to them will be filtered out.
Other Options: Users have the ability to filter their Dataverse further by clicking the Favorites, Shared to me, and Shared by me options.
*A user may have multiple Dataviews in their accounts with 1 main dataset. The dataset can be sliced and diced into smaller sets for data that only corresponds to your specific filters. A user can then save these new sets as a different Dataview. Most users consider a Dataview to be static data at one point in time, but iSEEKsc allows the user to view multiple slices of data which are more or less live and current.
Change Dataview Name: To change the Dataview name click the small black arrow next to the current name and select “Edit Dataview Name”. The user may then change the name of their Dataview and click the green checkmark when done.
*iSEEKsc provides an “auto alert” when there are unsaved changes that were made.
Find iView: The Find iView button allows the user to find a field within a large Dataview which would make it difficult to find otherwise. The user can either choose from the list or use the search feature. Once the iView is click, iSEEKsc highlights the corresponding box and brings the user right to it.
The sprocket menu at the top of the Dataview has many useful features within it like:
When a user has a large Dataview with many different iViews it might be difficult to make certain selections. This is why iSEEKsc allows the user to organize and compartmentalize their iViews into different tabs. To create a Tab:
The number of tabs that can be created are unlimited.
After consuming lots of data and linking multiple datasets together one of the best features of iSEEK is the empowerment it gives to users to interact with large amounts of data easily, comfortably, and quickly in essence making their data come alive.
There are 3 types of filters:
Filters are represented by a box of data which are called iViews. Each filter provides a default of 25 results for listed values. Simply click on one of the results in your filter and watch how your data dynamically filters the number of records in your Dataview. You can now see a filter selection pop up at the top of your Dataview. To remove a selected filter, you can either use the “Reset” button at the top of your Dataview, or simply select the “X” next to your filter selection.
Missing Values: Marked by a “Ø” icon this functionality of a filter will allow a user to view only the records that have a missing value for the specific iView. You will see the icon change once it has been selected. This new icon will allow you to view only the records that do not have a missing value. To remove either of these filters you must remove the filter selection from the top of the Dataview.
More: Marked by a “+” icon this functionality of the filter will allow a user to view all possible selections within the listed value iView. A user may chose to include or exclude specific results in their selections and save their changes. The filter selection will appear at the top of your Dataview.
Quick Graph: Marked by a simple graph icon which provides an immediate graphical representation of your data in an iView.
The relative date field has been updated so that in addition to last 30, 60, 90 days I can enter any last days (365 for trailing 12 months, 10 days, 14 days, etc.)
Another powerful way for users to interact with their data is by using the Search technology embedded in iSEEK Supercruncher. The search empowers a user to search for a specific data element within a single dimension or multiple dimensions. By using the search technology this allows the user to query their entire database to move closer closer to what they are looking for. They can then us the filters to refine their search further.
Find
The find feature empowers the user to search not one within a specific dataset, but to find data elements within their entire account. This is not like the search feature where a user can query their data, but it helps them find where their data resides within a dataset, tables/charts, templates or Dataviews.
For a user to customize their filters they can click the sprocket at the top of their Dataview and select “Edit Search Fields”. From here a user can:
There are three types of data sharing:
Edit Permissions:
Share Current View:
After a user has been able to see deeper into their data they have the ability to create tables and charts to show a graphical representation of that data. There are two ways to start creating a table or chart:
When creating tables and charts iSEEK Supercruncher uses a drag and drop interface to make it quick and easy for users to create them. There are a few general guidelines to follow:
The X axis is generally for Search fields or iViews. There will be a list of fields to select from on the left hand side of your screen. Once you have found the iView you are looking for simple click and drag it to the x-axis. The Y axis is for numeric fields or metrics. Metrics are pre-calculated using the data within a given iView. When a user clicks on an iView in the creation window they will see a list of Basic Metrics appear such as Count, Distinct Count, Share of Count, Share of Total, Standard Deviation, Average, Total, Maximum and Minimum.
Record Limit; There is a default number of records that can be loaded for each type of table or chart. Limit your records when there is too much to view, or you are trying to refine your records to the top 10 or bottom 10 etc.
Filter/Group-by: This piece of functionality helps set up the “cycle” filter. Ex. You would like to see the average scores for each test taken this year, but there are multiple schools in your district taking the same named exams. You can you the Group-by filter to see the average score by assessment by school. By clicking the side arrows you can filter through the individual schools in your district to view the data associtated to it.
Y limits: Set you y maximum and y minimum limits to stretch or shrink the range of data you see. This can help put you chart into perspective.
Benchmark: This allows a user to input a static value that puts a line across the table or chart, indicating if the value has been reached or not.
A combination chart empowers the user to graph two data elements on the same graph. It is effectively used for comparison purposes. For example, a combination graph is recommended to graphically display:
The first data element plotted in a combination chart appears as a bar chart; the second (and subsequent) appear as line graphs. All standard features apply to a combination chart including the ability to apply a series, a filter, customize the Y-axis and include a benchmark.
This chart is similar to a combination chart (above); however, it differs to the extent that you can apply two different Y-axis scales. It is recommended when you are graphing multiple data elements that have a significant different scales. For example:
Higher Education: Total amount of content aligned to objectives across the curriculum vs. Average Student Test Score for each objective
All standard features are available with the Dual Y-Axis Combination Chart. As a user, you can apply a customized Y-axis (to the right and left), enter a benchmark, add a series (to one of both of the data elements in the graph), and filter by any field.
A Scatter plot is used to plot data points on a horizontal and a vertical axis in the attempt to show how much one variable is affected by another. Each row in the data table is represented by a marker whose position depends on its values in the columns set on the X- and Y-axes. Multiple scales can be used on the Y-axis to when you want to compare several markers with significantly different value ranges.
Gauges make for great gadgets on the dashboard. Users can publish key data metrics as a thermometer, linear/angular gauges as well as many other interesting, eye-catching gauges. Creating a gauge is easy and users have all standard options available such as filtering and applying a benchmark. Below are few examples of gauges:
A nibble is an enhanced feature that empowers users to publish specific, discrete pieces of critical data extraneously to the application by embedding the nibble in an email, on the desktop, in a dashboard, within a website or other location. It is as is “one-feature, one-button” tool. Users that have purchased this advanced feature can data mine through thousands or millions or records and, tap the nibble to find the discrete slice of data most important to you. Key points:.
Examples:
This Content Browser is an enhanced feature that allows you to view, interact with, touch, edit and identify with all of your data sets comprehensively and contemporaneously on a single screen.
The data loading process has been enhanced to automatically crawl a pre-existing SFTP site for newly posted data and load it directly into iSEEK Supercruncher.
Intelligent Agents have been enhanced to not only to send a data export via email, but an IA can exported the data automatically and post it to a pre-established SFTP site.
Access the Setup menu at the top of your screen and click datasets.
Select the dataset you would like to custom reorder the column values
Click the sprocket for the columns settings
Scroll to the column you would like to reorder the values for and click the “list” icon
A window will appear with all the values for the field you selected. Reorder the values in sequential, numerical, or alphabetical order and click save.
Note: the “x” will hide the value and move it to the bottom of the list in default order. Click reset order to make these fields reappear.
Access the Setup menu at the top of your screen and click datasets.
Select the dataset you would like to create a column look-up table for
Click the sprocket for the columns settings
Scroll to your desired column and click the icon that looks like two crossing arrows.
The user can now convert individual values in the column or input an entire list of values.
Note: Once values are converted (numeric or text) the field will be reformatted as text. The table can be edited if the values should change.
Access the Setup menu at the top of your screen and click datasets.
Select the dataset you would like generate a custom column value for.
Click the sprocket for the columns settings
Scroll to the bottom of the screen where you see “Generated Columns” section and select “Add New Generated Columns”.
There will be three types of columns to generate:
Predicted: This column can be generated once you have create a training model to predict values based on historical data.
Web Service: This generated column allows you to retrieve realtime data from a webservice behind and even hind a username and password. You will be provided a form to specify how you would like the data to be retrieved.
Custom Expression: This generated column allows you to apply algorithms or formulas to your existing data fields and place them into your dataview to be filtered.
Create a results view and save
Access your results view in the related tables and charts section and click the “V” and select Enable API
An icon will appear at the top left of your results view and at the bottom right of the thumbnail.
By clicking on the icon a window will appear with a url connection to the api. Copy this link and use it to connect to a number of different applications and machines.
Open a new excel document and click “Import data from text” from here you can click add. You will copy and paste the link from iSEEKsc into the filed.
Setup your preferences for the data and where you would like it to populate.
Note: Save the data as comma delimited and default save it in the first worksheet.
Click refresh in the top toolbar and watch your data automatically populate in the specified fields.
Note: The user can also set an automatic refresh rate to keep the data update in the document.
Access the Setup menu at the top of your screen and click datasets.
Select the dataset you would like to change the column values to actionable likes.
Click the sprocket next to Columns and Settings
Find the column you would like to add an actionable like to and click the icon with the circle and arrow.
A window will appear for you to add a web location and a place to add a column placeholder to input the values of that field.
Save all changes. Your dataview should now be populated with actionable links.