cyrus-maina Goto Github PK

2020-fortune_2000_companies

This repo wholesomely analyses fortune 2000 companies year 2020.It deducts aspects like profit ratios, correlations between variables, profitable/non-profitable companies and performs a regression analysis. It also groups insights into countries and continents.

castiglione_hotel_db_querying

We have this hotel business' database and business problems which we solve by querying the database. We then provide recommendations and insights.

complex_sakila_db_querying

We will employ various SQL techniques like UNION, CTE AND AGGREGATION FUNCTIONS to query the DB

cyrus-maina

Database/datasets analysis utilizing SQL and Python and offering recommendations and insights that enhance your organization's decision-making process.

exam_scores_study_hours_analysis

An analysis on the correlation between exam scores and number of hours invested in studying and attempt at predicting student's scores from study hours

fire_brigade_database

The database is of a fire brigade firm. It includes data such as members and equipment. We query it to gain beautiful insights that will help arrive data-driven decisions.

global_food_price_inflation

grocery_store_sales_analysis

This analysis exhausts a grocery store's sales from 2020 to 2023 and provides business insights from the statistical methods applied.

kings_car_delaership_linear_regression

kiosk_e-commerce_sales_analysis

lego_themes_database

This analysis aims to help you understand Lego's growth via themes released and number of products released from 1949 to date.

motorbike_dealer_database_querying

The motorbike dealer tasked us with business problems along with the business database which we are to query and provide recommendations based on the problems.

netflix_userbase

This analysis provides insights deducted from a fictitious Netflix userbase dataset.

pharmacy_db_querying

A pharmacy has tasked us with business problems solvable by querying their Database. We drew insights and provided recommendations to the business problems.

pizza_hut_sales

Our aim is to extract insights on how Pizza Hut can stay financially healthy, from their revenues and sales data.

profitable_movies_analysis

This analysis assumes we have an investor for a customer who seeks our guidance on deciding in which genre should he venture to considering its profitability and low capital.

r-d_expenditure_in_europe

sakila_database_querying

The sakila DB is a fictional database for a rental DVD Store, used for educational purposes. We will query it to derive some basic insights

scotch_whisky_analysis

This analysis provides insights on a scotch whisky dataset. Insights are such as correlation between ageing periods and their prices, mean and median prices of whisky categories e.g., Blended Malt Scotch Whisky. With such insights a new distiller or one seeking to expand will easily make decisions.

sql_online_shopping_database

We have an online shop database which is already clean. We will query it to gain insights that will enrich data-driven decision making.

supplychain_database_analysis

This analysis deduces day to day insights of Herman Traders' supply chain operations, insights meant to streamline the operations to improve efficiency, increase profits and cut costs.

tele_bank_customer_dataset

We analyze the customer dataset with the sole intention of extracting as many useful insights that may help the bank's shareholders make decisions that will keep them financially healthy.

wikipedia-fundraising-statistics

world_gdp_2022_statistics