How to install piwik on Ubuntu 16.04

Hi I am using a Linux server and what do i need to do to use piwik. Can I see the detailed analysis of the visit to Web Tasarım Ankara website? I do not speak English do not look at the translation I used.

Installing Piwik - Analytics Platform - Piwik and

hello matthieu,
I have tried the second link you posted, but there is something wrong with me.

Before this, I have created a database named “piwik_db” manually, it seems there are some initial table settings for piwik?
How can I do this? I mean, I have no idea about the DDL of the tables.