A library with pre-configured DbContexts for SQLite, PostgreSQL, and SQLServer, supporting Northwind, AdventureWorks, and Chinook databases for seamless integration and rapid development.
-
Updated
Mar 18, 2024 - C#
A library with pre-configured DbContexts for SQLite, PostgreSQL, and SQLServer, supporting Northwind, AdventureWorks, and Chinook databases for seamless integration and rapid development.
How to model and partition data for Cosmos DB starting with the Adventure Works database.
"DataQuest: Efficient SQL Queries for Large Databases" aimed at refining SQL queries to efficiently handle large datasets. It offers insights and strategies for optimizing query performance, utilizing indexes effectively, and improving overall data retrieval processes in relational database environments.
The sources (incl data) needed to generate the Adventure Works DW 2020 DAX training model as a PBIX file.
This project aims to implement a robust ETL process using SQL Server Integration Services (SSIS) to extract data from the AdventureWorks database, transform it, and load it into a Data Warehouse named "Datawarehouse."
A docker image using Microsoft's latest Microsoft SQL Server docker image, with the sample AdventureWorks database installed.
Turn AdventureWorksLT sample database into a REST and GraphQL service with Data API builder
Throughout this project, I utilized Power BI to dissect Order, Revenue, Profit, and returns data from Adventure Works, an imaginative bike shop. It became a valuable learning journey, offering step-by-step guidance on techniques by Maven Analytics.
This is a repository created for the Analytics Engineering certification by Indicium Academy and Lighthouse Program.
Interactive Sales Reports Dashboard with AdventureWorks database
Importing AdventureWorks (SQL Server Sample Database) to Neo4j
This is my first power bi dashboard Adventure worksdata.
SQL & Power BI. Diagrams, select/view, Power Query, DAX, etc.
Repository for Adventure Works Sample Database Analysis
Basic to Complex SQL Server queries with Adventure Works database including window functions, triggers, string manipulation, user-defined functions, CTE, recursive CTE, DML and DDL
Add a description, image, and links to the adventureworks topic page so that developers can more easily learn about it.
To associate your repository with the adventureworks topic, visit your repo's landing page and select "manage topics."