This repository includes a list of varying demo databases I collected for learning purposes.
The AdventureWorks demo datase of Microsoft. Mostly used for Power BI. The demo dataset consists of six tables.
- SALES_ORDER
- SALES_TERRETORY_DATA
- SALES_DATA
- RESELLER_DATA
- PRODUCT_DATA
- CUSTOMER_DATA
The BI-Assessment database consists of six tables:
- PRODUCTS
- ORDERS
- CUSTOMERS
- RETAILER
- RETAILER_PRODUCT
- RESELLER_LEVEL
- CUSTOMERS_BASKET
The DemoShop database consists of eight tables of a fictional shop.
- CUSTOMERS
- EMPLOYEES
- OFFICES
- ORDERDETAILS
- ORDERS
- PAYMENTS
- PRODUCTLINES
- PRODUCTS
The date table contains all necessary information about dates, such as weekday, week number, quarter as well as start- and end day of the week. The table can be used to build up date-dimensions.
The table contains all dates from 01.01.2000 (2000-01-01) until 31.12.2030 (2030-12-31).