Introduction to Power BI

Introduction to Power BI

OptimalBI September 29, 2025

This article includes tips and tricks for Power BI. What is Power BI? Power BI is a cloud-based data analysis and visualisation tool created by Microsoft, which can easily connect with various data sources. It is simple, user friendly…

Power BI Visuals

Power BI Visuals

OptimalBI September 29, 2025

Data is a new currency. According to Statista, the total amount of data consumed globally in 2021 was 79 zettabytes, an annual number projected to grow to over 180 zettabytes by the end of 2025. FYI, there are…

Connect to MySQL database from Power BI using SSH Tunnel

Connect to MySQL database from Power BI using SSH Tunnel

OptimalBI September 29, 2025

In a previous OptimalBI project, we had to access a MySQL database on a remote server from Microsoft Power BI to provide some insights on the key tables. However, the database was configured to not allow direct access from…

You've come to the right place!

Squareweave is now part of Ackama.

New logo

We are now part of the Ackama Group, delivering pragmatic technology and design across the Asia-Pacific.

You've come to the right place!

Common Code is now part of Ackama.

New logo

We are now part of the Ackama Group, delivering pragmatic technology and design across the Asia-Pacific.

You've come to the right place!

Optimal BI is now part of Ackama.

Optimal BI logo

We are now part of the Ackama Group, delivering pragmatic technology and design across the Asia-Pacific.