Here you can find short lessons on how to create your own SQL queries to manage your data warehouse on zistemo. Learn more about the SQL Data Warehouse.

We’re using the MySQL Workbench in the lessons.

Customers and Invoices

Learn how to create a custom query to get the customer ID, name, invoice number and invoice amount. Also we sort customers by name and group data by currency.

Push data immediately, filter by date and export to Excel

Learn how to immediately push data into the SQL Warehouse, filter data by date and export everything to Excel. Make sure you watched the video above first, since it uses the query from that lesson.

Build a report with approved timesheets on Google Data Studio

Learn how to build a query to get approved timesheets only, including project name, customer name, task and staff. After that we build a report on Google Data Studio. If you try it by yourself, please make sure that you using approve timesheet feature.