Dapper.Linq
-
Updated
Jan 13, 2024 - C#
Dapper.Linq
This project is a Data Warehouse built using SQL, incorporating ETL processes, Data Modeling, and Analytics. It follows the Medallion Architecture (Bronze, Silver, and Gold layers) to ensure efficient data ingestion, transformation, and reporting. The goal is to create a scalable and optimized data pipeline for insightful analytics.
Aprendizado documentado em SQL Server para Data Analytics | 200+ exercícios LeetCode/HackerRank + Curso) | Window Functions, CTEs, Query Optimization.
SQL analytics suite on a star-schema warehouse: exploratory analysis, magnitude and ranking breakdowns, time trends, cumulative growth, YoY performance, part-to-whole, and customer/product segmentation.
This repository contains text files that cover various concepts and functionalities in MySQL. Each file provides detailed explanations and examples, making it a valuable resource for learning and reference.
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.
Analisis SQL (PostgreSQL) atas 5,8 juta penerbangan domestik AS 2015: maskapai paling andal, penyebab delay, dan bandara/bulan yang perlu dihindari
This 2011 census SQL project employed COUNT, SUM, AVG, GROUP BY, HAVING, ORDER BY, LIMIT, RANK(), and LIKE for aggregations, analyses, and filtering. It offers a concise overview of India's demographic trends, showcasing SQL's versatility for data exploration.
HR Management System — MySQL project with schema, sample data, and 17 solved business queries (joins, subqueries, window functions, CTEs)
Building DWH , Include ETL , Processing, Data Modeling and Analytics
SQL Views, Temp Tables, Windows Functions
Explores an E-Commerce dataset and generate various analytics and insights from customers' past purchase behavior.
Pure-SQL analysis of 3,925 global data science job listings using PostgreSQL window functions and CTEs to uncover salary patterns by country, experience level, and role
SQL analytics project using MySQL for e-commerce data
Air Cargo Analysis- Effective way of Writing Query to Find the Insites from the Data
A hands-on PostgreSQL learning journey covering SQL fundamentals, advanced queries, joins, CTEs, window functions, indexing, query optimization, and real-world database projects.
MySQL supply chain KPI warehouse: star schema over 40,000 simulated order lines, reusable SQL views for OTIF, fill rate, backlog and inventory turns, CTE and window function analysis, and an automated weekly Excel report in Python.
Applying SQL knowledge from the book "Learning SQL" from Alan Beaulieu
Compute the top N viewed Wikipedia pages for a given date
To associate your repository with the windows-function topic, visit your repo's landing page and select "manage topics."