You get request for reports all the time but what is slowing you down is getting the data you need. Don’t re-key in the data when your colleagues already have them. Get them to share it with you or simply capture it from documents.
Play Video
0-1: Required format
The type of Excel and CSV file formats that will work with Qwikidata.
Play Video
0-2: File validation
How Qwikidata will validate the file before processing the file.
Step 1: Creating a template
Before you can start to upload, manage, share and analyze your data, the first step is to create a template for that file. note: click ‘Full screen’ to expand video size.
Play Video
1-1: Upload sample file & select data
How to upload a sample file and select the field/column you want.
Play Video
1-2: Defining Field type 1
Important step on how to define the field/column as alphanumeric & numeric. All fields are defaulted to alphanumeric.
Play Video
1-3: Defining Field type 2 & save template settings
Important step on how to define the field/column as date. Once all fields are set, you can save the template settings. More date format examples below.
Play Video
1-4: Activate template & upload sample data
Once all fields are set correctly, you can activate the template & optionally upload data from sample file.
Play Video
1-5: Activate template & separately upload data
If you decide not to upload the data from the sample file, you can separately upload data from another file with the same filename.
Step 2: Upload files for processing
After creating the template, now you can start to upload data from your files for charting, analysis and sharing with others. note: click ‘Full screen’ to expand video size.
Play Video
2-1: Upload data from file
This video will show you how to upload data from a file.
Play Video
2-2: Adding more data to existing table
You have a table with existing data and you want to add more data to it.
Play Video
2-3: Replacing existing data in table
Sometimes, you just need to replace an existing data in the table with edited data. This short video will show you how.
Step 3: My Data
‘My Data’ section is where all the tables containing the data that you have uploaded. note: click ‘Full screen’ to expand video size.
Play Video
3-1: My Data -overview
This video is an overview of the main My Data section. It’ll show you how quickly you can find the data you need.
Play Video
3-2: Quick search for data in table
You want to quickly find the data you need. The ‘Search’ function allow you to do real-time search & filtering with multiple keywords.
Play Video
3-3: Advance Filtering - numbers
There are times when you need to narrow down data with multiple conditions with various fields like ‘greater or less than’ or ‘between’ certain values. The Advance Filtering does that easily.
Play Video
3-4: Advance Filtering - dates
Many situations require a need to focus on specific time period. Advance Filtering by dates can be done easily with ‘point & clicks’.
Play Video
3-5: Search + Advance Filtering
When you need data based on multiple conditions, combining ‘Search’ and ‘Advance Filtering’ is the best way to get results.
Play Video
3-6: Bar chart + Group bar chart
Creating a bar chart is essentially a 3-clicks process. Just add one extra click to tweak it to a Group bar chart.
Play Video
3-7: Bar chart + Search + Ad. Filter
Create a Bar chart & tweak it with a combination of Search & Advance Filtering for amazing flexibility. You’ve got to see this!
Play Video
3-8: Stacked bar, Pie & Line chart
Use Stacked bar chart when you need to see the break-down of components or view it as Pie and line charts.
Play Video
3-9: Share data with pre-set formats & conditions
Sharing or receiving data is super-easy. You can immediately analyze & chart it or combine with your own data.
Step 4: Analytics
‘Analytics’ section is where all the magic happens. You can blend data, add columns with formula and conditions, and create inter-linked charts tto perform scenario analysis.
Play Video
4-1: Analytics - overview
This short video will walk you through the basic functionality of Analytics homepage section.
Play Video
4-2: From data to charts in > 2 minutes
Analytics is design to take you quickly from your data to interactive charts fast & easy.
Play Video
4-3: Add new date & simple count column
This video will show you how to change the date to other date formats & create a simple count
Play Video
4-4: Add conditional count column
You can use conditional count for filtering or calculations based on specific conditions,
Play Video
4-5: Calculations for between columns
It it common to perform calculatons between 2 columns or more. All you need is to point, click & select.
Play Video
4-6: Calculations for between rows
In some cases, calculations between rows are needed i.e. Daily share price differences. This video will show you how simple it is for row calculations.