ratafar22 Goto Github PK

30days-sql-challenge

This repository contains 30 days SQL challenge queries and answers

analysis-of-superstore-giant-sales

I performed analysis on Superstore Giant data to assess how well the business is doing and to advise on areas that need to be improved. I used Excel and Power BI for the Analysis

analysis-of-unicorn-companies

I used Google Sheets to analyze the Unicorn dataset of private companies with a valuation of over $1 billion as of March 2022.

call-centre-performance-analysis

This analysis measures the performance of a call centre and assessed the satisfactions and sentiments of customers.

car-insurance-claim-analysis

This repository contains the analysis of car insurance claims data, including the amount claimed, car models and usage, and customers' demographics.

creating-database-with-sql

I created employee database using SQL

customer-segmentation-rfm-analysis

Segmenting customers using RFM model

dax-codes

dbt

excel-formulas-and-functions

This file contains my completed projects using advanced Formulas and Functions

fifa-21-data-cleaning-using-r

This file contains the full documentaion of the cleaning of the FIFA 2021 dataset uisng R programming Language

financial-analysis-of-new-york-stock-exchange-data

This repository contains the Financial Analysis of the S&P 500 companies. I used Excel to carry out this project

hotel-revenue-analysis

importing-data-into-mysql

This repository contains comprehensive guide on how to import CSV files into MySQL workbench.

kpmg-data-analytics-virtual-internship

Customer Segmentation: Analysis of old existing customers’ data to advise on which new top 1000 customers to target. The tool used is Excel

marketing-campaign-analysis

mini-project

Mavenmovies database design

movie-analysis

powerquery-codes

querying-data-with-sql

I demonstrated my ability to query databases of many tables and answered required business questions

ratafar22

rukayat.github.io

sql-analysis-of-parch-and-posey

This notebook contains analysis of Parch and Posey paper company data using MySQL and PostgreSQL

sql-database-normalization-using-python

Database normalization

the-chinook-digital-music-store-database

I queried the Chinook Music Database to help the company understand the media in their store, their customers and employees, and their invoice information. I used SQLite and Power BI for this project

tuberculosis-disease-analysis

I analysed the spread of tuberculosis disease among the WHO countries from 2000 to 2020. I used Python and Power BI

whatsapp-chat-analysis