Kainat Liaqat

DATA ANALYST

I am a Data Analyst skilled in SQL, Excel, Power BI, Tableau, and R, transforming data into insights and solutions across industries—see my projects for real-world impact.

SALES ANALYSIS AND VISUALIZATION

This project presents an analysis and visualization of pizza sales data from a fictional pizza restaurant chain. The project utilizes SQL for data extraction and transformation, and Power BI for data visualization.

Skills: MS SQL, Power BI, Data cleaning, Analyzing, and Visualization

AMAZON TOP SELLING BOOKS EDA

Explored the data of the top 50 bestselling books on Amazon from 2009 to 2019 using R-studio, and R Markdown, performed the data analysis, visualization and reporting. skillsdemonstrated: MSSQL, Power BI, Data cleaning, Analyzing, and Visualization

Skills: EDA(exploratory data analysis), R-studio, R-markdown

CYCLISTIC BIKE SHARE CAPSTONE PROJECT

Used SQL and Tableau to analyze and visualize the historical trip data of Cyclistic, a bike-share company in Chicago. Aiming to provide data-driven recommendations for marketing strategies that can convert more casual riders into loyal customers.

Skills: SQL, Tableau, time series analysis, Data manipulation, visualization, Report

DATA PROFESSIONAL SURVEY REPORT

Explored the trends and patterns of the data profession and provide insights for aspiring and current data analysts using Power BI.

Skills: Power BI(cleaning and analyzing using Dax queries, communicating Insights)

CLEANING DATA WITH SQL

Used SQL to perform various data cleaning tasks on a dataset of Nashville housing sales.

Skills: SQL , Data cleaning

Power BI comparative analysis using scratch

Used Power BI to conduct a comparative analysis of the sales and budgeted data of the Company from 2014-2020

Skills: Power BI, DAX queries, cleaning & Analyzing, Visualization