Sample Data Warehouse Database The GSDB sample database contains sales data for a fictional company that sells outdoor equipment. Let’s use the data from the TPCH Once you've loaded some sample data into your SQL Data Warehouse, you can quickly run a few queries. In this comprehensive guide, we explore the fundamentals and real-world data warehouse examples, explain key benefits, and differences between Download backup files Use these links to download the appropriate sample database for your scenario. For help with using MySQL, please visit the Use PolyBase to load public data from Azure blob storage into the Contoso Retail Data Warehouse schema. Data modelling is an essential part of data engineering. A good intro to popular ones that includes discussion of samples available for other databases is Sample Databases for PostgreSQL and More (2006). How to create a new warehouse with sample data In this section, we walk you through creating a new Warehouse with sample data. OLTP data works for most typical online Releases allow you to conveniently download sample databases or applications without the need to build them from source code. This database has spawned other derivatives, which I'll explain in the next tutorial in this series: AdventureWorksLT — a smaller sample OLTP database microsoft / sql-server-samples Public Notifications You must be signed in to change notification settings Fork 9. Open a new query window and run the T-SQL code from there. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing Sample Databases Relevant source files Purpose and Scope This section documents the sample databases included in the SQL Data Warehouse samples repository, specifically the Wide The sample database for features introduced in SQL Server 2016 and Azure SQL Database. The sakila-data. The database and schemas do not use any data storage so they do not incur storage The Centers for Medicare and Medicaid Services (CMS) Chronic Conditions Data Warehouse (CCW) database provides researchers with Medicare beneficiary enrollment and medical services, including The sample includes the databases that can be explored, as well as sample applications and sample scripts that can be used to explore the use of Get started Sample data Usage Use the sample database The sample database, SNOWFLAKE_SAMPLE_DATA, is identical to the databases that you create in your account, except This dataset includes C-level, sales/marketing, IT, and common finance scenarios for the retail industry and support map integration. Description: These samples are referenced within the Microsoft Fabric official documentation and Learn In this guide, you can choose to load sample data from Amazon Redshift Serverless or from an Amazon S3 bucket. The project involved designing a dimensional data model with Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge - microsoft/sql-server-samples Right-click on the Databases node, and select Import Data-Tier Application. You can use the Intune Data Warehouse API to build reports that provide insight into your enterprise mobile environment. In this story, I would like to talk about data warehouse design and how we organise the process. bak) files that you can use to install the AdventureWorks (OLTP) and AdventureWorksDW (data The sample database for features introduced in SQL Server 2016 and Azure SQL Database. The implementation includes creating a SQLite database, Discover the top 8 data warehouses in 2025, including Snowflake, Google BigQuery, and Databricks, to power your modern data stack. It From Visual Studio, open the SQL Server Object Explorer and connect to your SQL Data Warehouse database. The downloads contain sample data as CSV files, but could also include model / metadata information. You will learn how to organize and -- Use PolyBase to load public data from Azure Blob Storage into the Contoso Retail Data Warehouse schema. WideWorldImportersDW homepage (GitHub) A data lake stores current and historical data from one or more systems in its raw form, which allows business analysts and data scientists to easily analyze the The AdventureWorks databases are sample databases originally published by Microsoft to show how to design a SQL Server database using SQL Server 2008. sql file Learn how to download and install the SQL Server 2016 Sample Databases WideWorldImporters and WideWorldImportersDW. The repository contains Sample Models and Scripts With SQL Developer Data Modeler, you don't need to be connected to a database to create a design. This overview will help you decide which sample databases you should This document summarizes an automaker sales data warehouse project completed by a student team. A data lake stores current and historical data from one or more systems in its raw form, which allows business analysts and data scientists to easily analyze the SQL Data warehouse architecture Step 1: Database & Schema Setup The journey starts with creating a new database and defining schemas for each This tutorial provides you with a SQL Server Sample Database called BikeStores, which allows you to start practicing with SQL Server quickly and effectively. One trivial sample that WideWorldImportersDW Data warehouse equivalent of WideWorldImporters. In this tutorial you will: Configure PolyBase for loading from a public blob storage container. The sample data is used throughout the Amazon A warehouse is a super-powered filing cabinet where you can store, organize, and easily find all important business data. 1k Star 11k dbt Data Warehouse — Star Schema Design & Transformation Production-grade data warehouse built with dbt-core, demonstrating dimensional modeling, staging → intermediate → marts architecture, A data warehouse is critical for a business because it provides a centralized and consolidated view of the organization's data. A data Explore how a modern data warehouse can revolutionize your business today and learn about its functions, architecture, & real-life examples. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing We are excited to announce the support of Microsoft Fabric Data Warehouse in the SQL Database Projects extension available inside of Azure Data Studio and Visual Studio Code! SQL Releases allow you to conveniently download sample databases or applications without the need to build them from source code. In line with We would like to show you a description here but the site won’t allow us. Learn about Welcome to the Data Warehouse and Analytics Project repository! 🚀 This project demonstrates a comprehensive data warehousing and analytics solution, from Releases allow you to conveniently download sample databases or applications without the need to build them from source code. Benefit from N-iX's expert advice, insightful case studies, and This tutorial will show you how you can document your existing data warehouse and share this documentation within your organization. The repository contains Where do you store a petabyte of data for business intelligence? In a data warehouse. See the Documentation Samples Location: docs-samples folder. Let’s use the data from the TPCH A data warehouse aggregates data from various sources into a central data store optimized for querying and analysis. Sample databases for SQL Server from Microsoft and other sources are important for testing and development. sql file contains all the CREATE statements required to create the structure of the Sakila database including tables, views, stored procedures, and triggers. If you desire a sample database with a larger data size, use the source scripts to create a new sample database, and tweak the parameters in step 6 to Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge - microsoft/sql-server-samples The database contains a schema for each data set, with the sample data stored in the tables in each schema. For database professionals seeking robust SQL practice environments, this comprehensive comparison helps identify the most suitable downloadable Building a modern Data Warehouse from scratch This project demonstrates a comprehensive data warehousing and analytics solution, from This section documents the sample databases included in the SQL Data Warehouse samples repository, specifically the Wide World Importers data warehouse implementation. Welcome to our database design community! Discover how to build MS Access databases, SQL Server design, and explore data models from many different industries. You can start creating a new design from scratch open an exisiting The sakila-schema. To run a query, connect to your newly created Adventure Works database in Azure SQL DW It is imperative that it is done correctly, considering different factors like development and production, security, and business use cases. From Visual Studio, open the SQL Server Object Explorer and connect to your SQL Data Warehouse Browse Dataedo sample database documentations. In this article, we discuss how The samples databases downloads include the AdventureWorks sample online transaction processing (OLTP) database, the AdventureWorksDW sample data warehouse, and the The functional genomics data collection (ArrayExpress), stores data from high-throughput functional genomics experiments, and provides data for reuse to the research community. To run this sample, you need the following prerequisites. By understanding these data warehouse examples and concepts, you’re well-equipped to embark on your data warehousing journey, transforming View information about the WideWorldImporters and AdventureWorks sample databases, Azure samples and templates, and code samples for Microsoft SQL products. AdventureWorks is the We would like to show you a description here but the site won’t allow us. The sample database schemas provide a common platform for examples in each release of Oracle Database. This repo has the following Data Warehouse Examples: Learn about key data warehouse components, benefits, challenges, and future trends in data warehousing. The repository serves as a practical resource for developers and data engineers implementing, monitoring, and managing SQL Data Warehouse solutions. This repo has the following From Visual Studio, open the SQL Server Object Explorer and connect to your SQL Data Warehouse database. For legal information, see the Legal Notices. In the Import Settings, select Import from local disk and select the Open this link and look at the data warehouse section where the backup file of all versions of the sample database AdventureWorks DW is 15 Data Warehouse Project Ideas for Practice with Source Code Learn how data is processed into data warehouses by gaining hands-on experience on And AdventureWorks fun doesn't stop there. Once connected to the SNOWFLAKE_SAMPLE_DATA database, you’ll see schemas that start with TPC-H and TPC-DS. One trivial sample that This repository contains an example of data warehousing using a star schema model. Microsoft SQL Server 2025 Accelerate your AI application's time to market by harnessing the power of your data and the built-in AI Browse Dataedo sample database documentations. In addition, this dataset offers large volumes of Download free SQL databases for practice — AdventureWorks, Northwind, Chinook & more. This document describes Sakila sample database installation, structure, usage, and history. Run this sample From Visual Studio, open the SQL Server Object Explorer and connect to your SQL Data Warehouse database. It helps you make smarter Discover key components, architecture types, and best practices to design scalable, efficient data warehouses for optimal data management and Unlock business value with our comprehensive guide to building a data warehouse. Welcome to the Data Warehouse and Analytics Project repository! 🚀 This project demonstrates a comprehensive data warehousing and analytics solution, from Real-Time Data Warehouse Examples (Real World Applications) Discover how businesses are leveraging real-time data warehouses and case Use sample content to explorer SAP Datasphere. It allows for the The database shows how to design a SQL Server database using SQL Server 2008 and AdventureWorksDW is the data warehouse sample. The AdventureWorks databases are sample databases that were originally published by Microsoft to show how to design a SQL Server database using SQL Server The repository serves as a practical resource for developers and data engineers implementing, monitoring, and managing SQL Data Warehouse solutions. Setup instructions for SQL Server, MySQL, and This article explains the process of installing the AdventureWorks2016 and AdventureWorksDW2016 sample database on a stand-alone instance of SQL Check out this post about a tutorial from Microsoft that allows us to very easily load a large sample data set into Azure SQL Data Warehouse for free. The GO Sales and Marketing sample cube contains sales and marketing metadata for the GSDB A simple Data Warehouse project to analyze student academic performance using SQL and an ETL pipeline. This repo has the following releases: Wide World Importers sample Real-Time Data Warehouse Examples (Real World Applications) Discover how businesses are leveraging real-time data warehouses and case Check out this post about a tutorial from Microsoft that allows us to very easily load a large sample data set into Azure SQL Data Warehouse for free. Open a new query window and run the T-SQL code The AdventureWorks databases are sample databases that were originally published by Microsoft to show how to design a SQL Server database using SQL Server These downloads are scripts and full database backups (. The following schemas are included: HR: Human . Explore what a data warehouse is with real world examples.