At first we were torn apart between Tableau and Power BI, a couple well-known BI Tools in the market. After several discussions with the Data Team, it was agreed that we would use Tableau for building the dashboard as we did not rely heavily on Microsoft Stack for our IT Infrastructure (which is preferable for PowerBI).

My department (marketing department) was the first department that built the dashboard, as I felt the urgency to have accurate, complete, and quickly available data as a basis for building marketing initiatives.

I gave the business requirements (the data, charts, information needed to be provided in the dashboard) to the data team so they can try to build the data marts and the dashboards. We had several iterations to refine the dashboards until it was ready to be used by the marketing department.

Another BI tool that I used were Metabase and Google Data Studio. Metabase tool used the same data marts that were being used in Tableau so it won’t have redundancy. If Tableau dashboards were built by the data team based on my requirements, Metabase dashboards were built by myself using SQL (Google Bigquery). This way I can have more flexibility for creating new dashboards or modifying existing dashboards when i deemed necessary.

For Google Data Studio, I used it to integrate paid ads performance from Google Ads and Meta Ads with the internal marketing cost. I used Supermetrics to connect the data from Google Ads and Meta Ads dashboard so I can get the whole marketing cost at one dashboard.