This project demonstrates the processes of data modelling and warehouse creation in Snowflake. It demonstrate the steps taken to design a data model and setting up of a data warehouse using the snowflake web UI to support analytics and reporting requirements.Click on the button for detailed report
Read More
This project involves Extracting, Transforming, and Loading (ETL) data from the OpenWeather API into a PostgreSQL database on behalf of Stanness Bikez. The extracted weather data will be used for various analytical purposes within the company's operations.
Read More
Data pipelines play a vital role for organizations seeking to leverage their data for business intelligence, analytics, and machine learning. This project demonstrates the seamless extraction, transformation and analysis of data for thorough data-driven decision making and analysis
Read More
Data build tool(dbt) is a powerful open-source tool designed for transforming data within the context of business Intelligence and analytics. dbt simplifies data transformation processes unlike traditional ETL processes. The project demonstrates the transformation of data in bigquery for analytical purposes.
Read More
Uber is a ride sharing business enterprise found in almost all big cities across the globe. This Analysis seeks to understand the ride sharing business and it's economic benefits. Analysis was conducted using pandas library in python. Click on the button for detailed report
Read More
This Visualized analysis seeks to build insight into healthcare delivery in Ghana. Data collection of Health Facilities of all levels and tier were collected and compiled the Government of Ghana in 2017. Click on the button to view detailed dashboard.
Read More
Sales analysis entails analyzing key sales metrics to evaluate strategies, identify improvements and optimize performance. This project showcases a complete solution for analyzing sales data and extracting actionable insights through the Python programming language.
Read More