Tasks and Projects about Databases, BI and Data Analytics.

This repository consists of all the projects done by me under the field of Data analysis.

Consulting project for a logistics LLC

Learn a little about Google Data Studio

This utilizes a static IP address in GCP to pull data from the Clash of Clans API, store it and serve it via data studio. There is also a API client with a sleep of functions you can use to pull, store, and view CoC facts and dimensions.

Study case data analysis & visualization projects using SQL, BigQuery and Data Studio.

This repository contains the SQL code used to generate the 'Harlem Link Snapshot: Academic Data Dashboard' (see README for screenshots)

Solutions to the Google Cloud challenge labs for the "Insights from Data with BigQuery" quest and "Build and Optimize Data Warehouses with BigQuery" quest.

A Power BI/Google Studio Dashboard to analyze previous OTC CatchUps

This repository contains SQL code that I've used to build a dashboard to be used for board oversight and governance. View the complete user guide at: https://tinyurl.com/msm-accountability

A daily auto-updating interactive dashboard project to visualize the impact of community's mobility to daily new COVID-19 cases by leveraging the data from MOH Malaysia, Google, Apple, Waze and TonTon. https://public.tableau.com/views/COVID-19MobilityDashboard/MobilityTrends (Tableau) https://datastudio.google.com/reporting/54616e0e-19c9-4097-bc…

A Power BI/Google Studio Dashboard to analyze previous OTC CatchUps