From Stage to Data: An End-to-End Power BI dashboard for a Matatu Fleet.

STEP 1 DATA CLEANING.
The raw data set is messy and needs cleaning like;

• handling missing values.
• duplicates.
• invalid dates.
• nulls.

STEP 2 HOSTING THE DATA ON AIVEN
After the data is cleaned, we move the data to aiven for postgreSQL.

• Create a PostgreSQL instance on aiven.
• Download the CA Certificate.

STEP 3 CONNECTING AIVEN TO POWER BI

• Install the Certificate
• Connect the data to Power BI.
• Authenticate by entering the credentials provide by Aiven.

STEP 4 DATA MODELLING AND DASHBOARDS
Once connected, build different dashboards using models provided like the charts.

CONCLUSION
Once done you would have created an end to end project for the fleet where one can get information on it.

link : https://github.com/Issahnjoroge/SAFARI-C0NNECT