Export Piwik Data to data analytic/visualisation tool

General questions
1

Hi guys

I’m newish to the Piwik, appreciate if you can help answer some of my questions.

I’m trying to use the Piwik data in a data analytic tool (Tableau for example), but I’m doing this via pushing the Piwik data into the Redshift, then use Tableau to connect the redshift database.

But I have found the Piwik data table is not in a structured way, at least from what I can see. Below are a set of tables I have in Piwik.

{noformat}
±------------------------------+
| Tables_in_piwik |
±------------------------------+
| piwik_access |
| piwik_archive_blob_2014_01 |
| piwik_archive_blob_2014_06 |
| piwik_archive_blob_2014_07 |
| piwik_archive_blob_2014_08 |
| piwik_archive_blob_2014_09 |
| piwik_archive_blob_2014_10 |
| piwik_archive_blob_2014_11 |
| piwik_archive_blob_2014_12 |
| piwik_archive_blob_2015_01 |
| piwik_archive_blob_2015_02 |
| piwik_archive_blob_2015_03 |
| piwik_archive_blob_2015_04 |
| piwik_archive_blob_2015_05 |
| piwik_archive_blob_2015_06 |
| piwik_archive_blob_2015_07 |
| piwik_archive_blob_2015_08 |
| piwik_archive_blob_2015_09 |
| piwik_archive_blob_2015_10 |
| piwik_archive_blob_2015_11 |
| piwik_archive_blob_2015_12 |
| piwik_archive_blob_2016_01 |
| piwik_archive_blob_2016_02 |
| piwik_archive_blob_2016_03 |
| piwik_archive_numeric_2014_01 |
| piwik_archive_numeric_2014_06 |
| piwik_archive_numeric_2014_07 |
| piwik_archive_numeric_2014_08 |
| piwik_archive_numeric_2014_09 |
| piwik_archive_numeric_2014_10 |
| piwik_archive_numeric_2014_11 |
| piwik_archive_numeric_2014_12 |
| piwik_archive_numeric_2015_01 |
| piwik_archive_numeric_2015_02 |
| piwik_archive_numeric_2015_03 |
| piwik_archive_numeric_2015_04 |
| piwik_archive_numeric_2015_05 |
| piwik_archive_numeric_2015_06 |
| piwik_archive_numeric_2015_07 |
| piwik_archive_numeric_2015_08 |
| piwik_archive_numeric_2015_09 |
| piwik_archive_numeric_2015_10 |
| piwik_archive_numeric_2015_11 |
| piwik_archive_numeric_2015_12 |
| piwik_archive_numeric_2016_01 |
| piwik_archive_numeric_2016_02 |
| piwik_archive_numeric_2016_03 |
| piwik_goal |
| piwik_log_action |
| piwik_log_conversion |
| piwik_log_conversion_item |
| piwik_log_link_visit_action |
| piwik_log_profiling |
| piwik_log_visit |
| piwik_logger_message |
| piwik_option |
| piwik_report |
| piwik_segment |
| piwik_sequence |
| piwik_session |
| piwik_site |
| piwik_site_setting |
| piwik_site_url |
| piwik_user |
| piwik_user_dashboard |
| piwik_user_language |
±------------------------------+
{noformat}

And my challenge is really about to make sense about the data table and turn them into an understandable structure in the data analytic tool.

Do you guys have any idea where I should start to look at? or how do you normally deal with this issue? Any tips?

many thanks

2

I’d go with importing the raw data (if it’s possible). Regarding archive tables, see below:

https://developer.piwik.org/guides/archive-data

3

Hi, I’m new to piwik. I can’t answer your question but I have a doubt that you might be able to help. I want to store the reports generated by piwik into amazon s3 or microsoft blob storage so that I can analyse data later using any tool . You mentioned that you are moving them into redshift. Can you tell how to do that? and Is there any way to export to s3 or bolb storage?