Foodie-Fi- SQL

Tools used: SQL

The primary focus of this project is to leverage SQL, a powerful database management language, to analyze subscription data and extract meaningful insights. By utilizing SQL queries and operations, the project aims to gain valuable insights into subscription trends, popular content, customer behavior, and the effectiveness of marketing campaigns.

Through SQL, the project will aggregate, filter, and segment data to gain a comprehensive understanding of Foodie-Fi's subscriber base. Key metrics, including subscriber growth, churn rates, engagement levels, and subscription revenue, will be analyzed. Additionally, the project will explore consumption patterns, such as popular shows, genres, and user preferences.

World Happiness Based

Tools used: Python

The objective of this project is to compute the global happiness score. World happiness revolves around prosperity and the advancement of economies. The primary hindrance to worldwide economic growth and stability lies in the presence of corrupt leaders on an international level. The decision to participate in the Corruption Perception Index (CPI) stemmed from a mere inquisitiveness to uncover the underlying causes and discoveries. Ultimately, data analytics centers around the aggregation of factual information, which contributes to a deeper understanding of the subject matter.

SAheart: South African Hearth Disease

Tools used: R

The aim of this project is to analyze a retrospective sample of males in a heart-disease high-risk region of the Western Cape, South Africa. The dataset contains information on various factors that contribute to heart disease risk. By utilizing R, we will explore, visualize, and analyze the data to gain insights into the key risk factors prevalent in this population.

Airbnb Rental Analysis

Tools used: Tableau, Alteryx and Excel

In this project, we will utilize Alteryx and Tableau to perform an in-depth analysis of Airbnb rental data. Airbnb has become a popular platform for short-term rentals, and by analyzing the data, we can gain insights into pricing trends, property characteristics, and customer preferences. We will focus on data cleaning to ensure data quality before conducting exploratory analysis and visualization.

Shifting News Consumption: Exploring Trends and Preferences

Tools used: Knime and Excel

This project aims to analyze the recent shifts in news consumption and understand the preferences of individuals regarding different news sources. A research group conducted a survey on a sample of 3,000 participants, where they were asked to indicate up to three options for their usual news reading habits. The available options included Social Media ,Online Newspapers, Printed Newspapers, and "Radio or Television.