Visual Builder Overview
The Visual Builder within IntelliBoard Pro empowers you, the user, to craft bespoke reports from the ground up, all without requiring any expertise in SQL programming. It enables you to design personalized reports, seamlessly incorporate columns and data points, apply filters, and format your data to construct a tailored narrative that aligns with your specific needs and objectives. The feature is primarily utilized by a small group of IntelliBoard administrators.
To access Visual Builder to Create a Dataset:
In your IntelliBoard dashboard, click the “Create New” button and select “Create Dataset.” Complete the Visual Builder Form. Direct link to “Visual Builder” here. Visual Builder Form Steps Step 1 Settings: Add Name and Description. You can utilize the description box to give
more information to the user (Instructions, messages about how to utilize the
data, etc). Step 2 Visualization: Choose the visualization you’d like for your dataset: Table, Cross-Tab Table, Multi-Level Table, Bar Chart, Pie Chart, Line Chart, Scatter Chart, Bubble Chart, or Heat Map. Step 3 LMS: Choose the LMS connection you wish to use to build the report. Click the “Go To Report” to start building your own data story.
Visual Builder components:
Preview: See the what the new report will look like before finalizing SQL Code: Preview the SQL code for the newly created report Settings: Settings menu to change the name, description, or add tags for easy searching. Update Preview Authomatically: Toggle that allows you to turn on/off automatic data update to preview any changes on Layout. When it is on, data is updated right away as you add, modify, and remove columns and filters on Layout. When it is Off, the preview remains unchanged. Cancel or Save: “Cancel” to exit out of builder and delete what you’ve created or “Save” to add the new report to your “My Datasets.” Layout: Layout menu that lists the columns you can add to the report or “Add Field” to add datapoints and columns Filters: Filter menu to create drop down filters or hidden filters to narrow the data in the report Format: Format menu to change the look of the report-colors, fonts, and conditional formatting Calc: Calculation Menu to create stored formulas and columns to reuse in other reports Layout Area: Displays columns, filters, and formatting as you build. Arrow: Toggles between the tabs: Layout, Filter, Format, Calc Dataset Type: Change the visualization of the dataset: Table, Cross-Tab Table, Multi-Level Table, Bar Chart, Pie Chart, Line Chart, Scatter, Bubble Chart, or Heat Map. Add Column: Add Columns of data to your table from: Unified Tables, InContact, PLA, and InForm. You can check the box next to a data field and add them one at a time to your report or slide the “Bulk Mode” toggle at the top to add several data fields at once. Default Column Sort: Once you have added columns to the table, you can choose which column will be used as the default column to sort by when the report is initially opened. Visual Builder Layout Menu Table Type Options Choose the Table Type(s) to select data to build Columns in your dataset. You can select multiple options, a single option, or all options. The menu will populate with categories that expand to show available datapoints (columns). Visual Builder Filter Menu Similarly to the Layout Menu, the Filter Menu displays categories with available datapoints that can be filtered. Filter Operation Options: Visual Builder Format Menu Column Format Menu: Select the icon to the far right of the column name to open the Column Format Menu.
Editing an Existing Dataset:
Open the report you wish to edit in “My Datasets.” Click the “Edit” button in the top right of the dataset. Visual Builder menu will open on the right. Click “Save” to save any changes or “Cancel” to revert back to most recent saved version of the report.
Additional Visual Builder Articles:
Build a Multilevel Table Chart
Creating Component Filters for Dashboards
Creating Downloadable Certificates for Moodle
Exporting and Importing Dataset Definition
Adding Formulas to a Dataset to Create a Custom Datapoint or Column
Create Conditional Formatting to Highlight Important Data
Frequently Asked Questions:
Participation data is calculated and stored by IntelliBoard from the moment a connection is established.
IntelliBoard does not report on historical participation data.
Average (Including Nulls as 0) Calculates the average value of all columns, treating NULL values as 0. Simply, it counts the average meaning of all columns which have value, hiding NULL values. Average (Mean) Calculates the mean average of all rows, obtained by dividing the sum of the row values by their count. Count Counts the number of all rows in the table, ignoring NULL values. Count Null Counts all rows in the dataset, including those containing NULL values. Group Concantenate Combines non-NULL values from a group into a single string result. Inter-Quartile Range It is a measure of the middle 50% spread of values. Preferred over many other measures of spread when reporting school performance or SAT scores. Maximum Identifies the highest value within the dataset. Median Indicates the midpoint of the dataset. Minimum Determines the lowest non-NULL value in the dataset.. Minimum (Including Null as 0) Identifies the lowest value in the dataset, considering NULL as 0. Modifier First Returns first non-NULL modified data in the table. Modifier Last Returns last non-NULL modified data in the table. Range The difference between the largest and smallest values. Can be used for the dispersion of the class's test scores. Standard Deviation It is a single number that summarizes the variation or dispersion in a dataset. Simply, it shows how spread out the numbers are. Sum Calculates the total sum of any sequence of numbers.
Date filters can be applied to any datapoint with a date format in the database to filter a report based on a date or date range. To create a date filter: Open an existing report in “My Datasets” or create a new report in the Visual Builder tool. Click the “Edit” button in the top right corner of the report. In the visual builder menu, select the “Filter” tab. Select “Create” under the “Filters” menu to create a filter for the entire report, not the “Create” button under the Column Filters menu. Select the category you wish to use as a datapoint filter. For example, you may choose “Enrollment Category” and select “Enrollment Start Date.” The datapoint must be in a date data format. Displayed are three types of date filter options: Hidden, Date, and Within Date Range. Select which filter type to use and apply the filter. Click “Save” in your report to save the changes. Hidden Filter Type Options Date Filter Type Options Within Date Range Filter Type Options
Yes if you are using a Moodle Based LMS. IntelliBoard dynamically scans Moodle Based LMS for custom user profile fields and stores the found fields in a separate table. It is listed as User Custom Profile Fields in the Visual Builder. These can be used as datapoints and columns in reports or as filters.