Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.
Zomato Data Exploration and Analysis with SQL (SQL SERVER)
This is an Analysis to optimise inventory managemnt for FitCapacity company by analyzing sales and inventory data using SQL and PowerBI
SQL for Data Analysis using PostgresSQL - analyzing Parch&Posey fictional company
Aprender scripts de consulta e manipulação de dados no Azure SQL
SQL data analysis project from basic statistics like median, min, max, avg,etc to percentile, correlation or linear regression
Data Analyst Portfolio Project 1 - SQL and PowerBI - Cleaning and analysing the AdventureWorks dataset with SQL, then visualizing it with PowerBI
In this repository you will find SQL queries of multi-difficulty levels that can applied on to large datasets for various business requirements.
This repository contains SQL problems from HackerRank, DataLemur and other challenges. Contains solutions to improve skills in database querying, optimization, and data manipulation.
This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.
This repository contains intermediate to complex sql queries which explains sql concepts. This repository can be helpful when writing queries with complex concepts and can be considered for reference. (Most queries have DDL and DML command within for practise)
An exploratory analysis on covid19 cases and deaths. Other interesting factors which are available in the dataset like, Stringency Index, Human Development Index, Percentage of smokers in population etc., are also explored in this analysis
Advanced SQL + MySQL for Analytics and Business Intelligence
Design and Implementation of a data warehouse on the "Northwind" database.
This is a project that shows my ability to query data from Adventure Works database Using SQL, thereafter using PowerBI to import , analyze and visualise.
This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence
SQL for Exploratory Data Analysis
Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…