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
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
A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.
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 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)
Advanced SQL + MySQL for Analytics and Business Intelligence
This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence
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
Design and Implementation of a data warehouse on the "Northwind" database.
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…
Optimizing Inventory Management
A Data Analytics Project on FitBit Fitness Tracker Data.
SQL for Exploratory Data Analysis