ERD Creation, SQL database implementation, Encryption, Computed columns, SQL functions, PowerBI reports
-
Updated
Mar 7, 2020 - TSQL
ERD Creation, SQL database implementation, Encryption, Computed columns, SQL functions, PowerBI reports
SQL based data profiling & data quality checks, which will help you to perform data profiling & data quality checks on SQL database at table & database level.
Host Behaviour Analysis for Property Rental Company
Processing covid data in SQL to show it in Dashboard.
Ad-hock analysis of requests for HardWare company in MS SQL
Welcome! This repository houses an analysis of international debt data supplied by The World Bank. The dataset includes details about the indebtedness (in USD) of developing countries, classified under various indicators. The aim of this analysis is to delve into and address fundamental inquiries concerning international debt.
To contribute to business by utilizing data analysis techniques and creating an executive Dashboard using Tableau.
SQL: Cleaning,Wrangling and Exploring the Data; Excel: Created an Interactive Dynamic Dashboard using Pivot Tables and Pivot Diagrams
Exploratory Data Analysis using SQL in SQL Server Management Studio 19. Incorporated queries for KPIs Calculation (mathematical operations), sorting, data type conversions, joins and aggregations, Common Table Expressions (CTEs), Temporary Tables, Window Functions, Table Manipulation (Feature Engineering) etc.
collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
🚀 Excited to share my latest project, a Bank Loan Analysis Dashboard developed in Power BI. This dashboard provides a consolidated view of key metrics, offering deep insights into loan applications, funding, and repayments.
A Full Data Analysis project where a sales data is ask,prepare,process,analyze,share and act through data analysis process
My final project for my Data Analytics trainings course
The Sales Analysis Project extracts and models data from the AdventureWorks database to visualize key metrics like Total Sales, Budget, and Net Profit. It includes bar charts for top products and customers, pie charts for category breakdowns, and tables for monthly spending and sales trends.
Modern Data Warehouse with SQL Server, including ETL process, data modeling and analytics.
Welcome to my repository featuring solutions to the SQL 50 challenge from LeetCode. Whether you're practicing for technical interviews or just looking to sharpen your SQL skills, this collection covers a wide range of topics from basic to complex queries.
An in-depth Exploratory Data Analysis (EDA) project that leverages Python libraries like Pandas, Matplotlib, and Seaborn to uncover trends, patterns, and insights from datasets, preparing the data for further analysis or modeling.
Building a modern data warehouse with SQL Server, including data modeling, analytics and ETL processes.
An exploratory marketing analysis using SQL Server, Excel, and Tableau to uncover key customer traits, top-performing products, and campaign success. Two dashboards reveal marketing and customer insights, highlighting campaign performance, underperforming channels, and behavioral patterns driving web purchases. Data sourced from Maven Analytics.
Add a description, image, and links to the dataanalysis topic page so that developers can more easily learn about it.
To associate your repository with the dataanalysis topic, visit your repo's landing page and select "manage topics."