How to import data for data analysis, visualisation and reporting

Step by step guide

If anything is still unclear, you can follow this step by step guide.

Technical support

If you have any difficulty with the data import, transformation, analysis, or anything else, we will gladly support you.

Please contact: Johann Fritz for technical support on WhatsApp at +27 82 940 1858, or by email: Johann at AmpX.co 

Sample Data

Three-phase: To download sample data for testing click here.

Frequently Asked Questions

One common problem is the following. If you browse to the dot CSV file and open it in Excel, and only the first column is displayed and not the other columns, then it could be a problem with the list separator settings on your system. So in other words, you just see one column an not the other columns. That means Excel did not know how to seperate the data and is just showing you the first column. This setting can be changed under the advanced setting of your system regional settings.

To resolve this, refer to this article: https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/

Or watch this video.

We are mostly able to resolve the problem through WhatsApp. Otherwise we can schedule a video call we prefer using MS Teams, but also have most of the other applications installed like Skype or Zoom.