collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
-
Updated
Jul 2, 2024 - TSQL
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)
SQL for Data Analysis using PostgresSQL - analyzing Parch&Posey fictional company
Aprender scripts de consulta e manipulação de dados no Azure SQL
This is an Analysis to optimise inventory managemnt for FitCapacity company by analyzing sales and inventory data using SQL and PowerBI
SQL data analysis project from basic statistics like median, min, max, avg,etc to percentile, correlation or linear regression
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 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
Data Analyst Portfolio Project 1 - SQL and PowerBI - Cleaning and analysing the AdventureWorks dataset with SQL, then visualizing it with PowerBI
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
SQL for Exploratory Data Analysis
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.
A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.
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…
Traffic Source Analysis, Website Performance Analysis, Channel Portfolio Analysis, Business Pattern Analysis, Product Analysis and User Analysis
Google Data Analytics Capstone Project over Divvy Trips Cyclistic Bike Share Data using Excel, R, and TSQL.
Optimizing Inventory Management