Showing posts with label Query tool. Show all posts
Showing posts with label Query tool. Show all posts

Sunday, 17 January 2016

KS New Release - Data Query Tool

The KS admin dashboard has a new element this month... a new query builder and reporting tool. The release is part one of three, for this tool.

When you log in to your dashboard as a KS admin, you will now see a new landing page, called 'HOME'.

The top half of the page displays 4 sections, which summarize some useful at-a-glance data, as follows:

Number of Invites sent in last 30 days
Number of Tests in last 30 days (Not Started, In Progress and Complete)
Top 8 Skills Gaps (based on results from last 6 months' results)
Results (last 5 completed tests)



At the bottom of the page, you will find the new query tool. This includes a range of 'pre-defined' queries, as follows:

50% or less test scores
70% or greater test scores
All invites from last 30 days
All results from last 30 days
Incomplete invites from last 30 days
All employee scores
All interviewee scores
All expired invites



You can edit pre-defined copies by first taking a copy, then editing the copy and saving with a different name.

Create new queries by clicking on the 'Create New Query' button.
Edit queries by clicking on the 'Edit Query' button.
Copy existing (or pre-defined) queries by clicking on the 'Copy Query' button.
Delete queries by clicking on the 'Delete Query' button.



Run queries across all linked accounts, or selected child accounts, by checking the relevant boxes in the 'Run Against Accounts' area:



When you create a new query, you will see this box appear:



There are 4 main sections which can be presented in your report: 
Users - this captures data about the user profile and account where the user record is stored
Background - this captures data about user demographics info
Invites - this captures data about invite (and related test) status
Results - this captures data about results (and related test) status

Click 'Display these columns' to expand the top section. Use the check boxes to build up the columns of your data query. The columns selected here will also be presented in your csv export. Click on the '+' icon, if you want to add this element to your filter options in the 'match ALL conditions' section below.  

In the query conditions section below, use the filter on the left of the screen to toggle between the following search topics: Users, Background, Invites, Results.



Queries can be a combination of 'ALL of these conditions' only, or 'ANY of these conditions' only, or both.



Use the dropdowns to build up the logic of your queries. There are lots of different options available, so you can filter your user, invites and results data in lots of new ways.

Export queries to csv for further analysis, by clicking on the 'Download' button.





This release is part one of three. Here's what we're working on next.

Part Two

Allow KS admins to perform a series of bulk actions, with the results of a query.  

For example:

Delete users
Move users from one account to another
Invite users to a test
Delete results
Move results from one account to another
Delete invites
Change invite expiry date
Re-send invites

We'll also add individual training tags to the search options, allowing you to create workshop groups for users who have common skills gaps.


Part Three

Graphics & charts: we plan to display a range of visual summary fields on the dashboard landing page.

For example:

No. of invites sent in last x days
No. of completed tests in last x days
No. of incomplete tests in last x days
Users who have 'incomplete tests' 
Most popular test topics by number taken
Average score and time for top 5 test topics
Average score for Employees vs Interviewees
Global benchmark comparison for top 5 test topics
Last x results: user names, test names, scores & times
Top 20 skills gaps (i.e. training tags)
Top 20 hardest test questions (i.e. lowest scoring average)


We will also include the ability to send auto-email reports to KS admins, which contain custom values and timescales.

As always, we welcome your feedback and ideas, so if you have any additional feature requests, in the context of searching, filtering, grouping and reporting data, we'd love to hear them!

R

Wednesday, 16 September 2015

KS Devs Update

So, the children are back to school and summer in the UK is fast becoming a memory. The autumn rains are upon us, which means it must be KS Devs update time!

We've had a busy year in 2015, keeping the KS library titles up to date with the latest releases. We've also been working steadily through the customer wishlist, improving existing tools and adding some new ones into the mix.

Here are the highlights..

New Query Tool

We've been working on new and improved ways to filter and search KS results, users and invites data.  This will be a 3-phase dev, as follows:

Phase 1

Create new query tool. We have built a new tool for searching, filtering and capturing KS data.



Query outputs can be captured in a table and exported to csv.



We are capturing a list of popular 'pre-defined' queries, which can be copied and edited.

For example:

Most popular test topics by number taken 
Average score and time for top 5 test topics
Global benchmark comparison for top 5 test topics
Users who have 'incomplete tests' 
Last 20 results: user names, test names, scores & times
Top 20 skills gaps (i.e. training tags)
Top 20 hardest test questions (i.e. lowest scoring average)

And so on.


Phase 2

Allow KS admins to perform a series of bulk actions, with the results of a query.  

For example:

Delete users
Move users from one account to another
Invite users to a test
Delete results
Move results from one account to another
Delete invites
Change invite expiry date
Re-send invites

And so on.


Phase 3

Graphics & charts: we aim to display summary fields on  a new dashboard landing page.

For example:

No. of invites sent in last 30 days
No. of completed tests in last 30 days
No. of incomplete tests in last 30 days
Most popular test topics by number taken
Average score and time for top 5 test topics
Average score for Employees vs Interviewees
Global benchmark comparison for top 5 test topics
Last 20 results: user names, test names, scores & times
Top 20 skills gaps (i.e. training tags)
Top 20 hardest test questions (i.e. lowest scoring average)

Plus offer an auto email report to KS admins, which can contain custom values and timescales.


Survey Tool

We have built a survey tool, which sits inside the KS admin dashboard and allows you to create a hybrid assessment/survey. For those times when you want to include questions in the mix, which don't have a 'right or wrong' answer. The UI is mobile responsive and captures survey results and charts in the same KS admin dashboard, for further analysis.


Other Items and a look ahead to 2016

Add Ecommerce page to KS site 

Helpdesk part 1: Add new 'Support' section in admin dashboard. Simple form to complete for tech support which is captured in KS CRM system. Future updates may follow, if more functionality and issues log is required.

Design refresh on main dashboard login page/password reset page: make page mobile responsive. 

Go live with new KS test report design.

Design refresh on main test taking UI: make mobile responsive;  add 'confidence meter' and associated admin dashboard links.

API calls: we have an ongoing dev with a third party vendor, to add more integration to training material hosted in their LMS.

Admin UI design refresh.

System mails: Revisit logic for KS system mails (invites, results, reminders) and how admins/others are copied on system mails. 

Allow more than one user group/dynamic group to be selected at a time when sending invites.  

Allow selection of default landing account for admins of multiple accounts.

Allow bulk copy & paste of emails on invite page.

Allow bulk upload/import of KS questions.

Key skills search tool.


As always, we'll keep you  posted as these devs progress to go live status.

R