top of page
Hình minh hoạ

DATABASE SIMULATES REAL DATA WAREHOUSE

The document includes 8 databases that simulate the actual structure of Data Warehouse and are complex enough to do the most professional Business Intelligence Project.

 

Each Database will have a Diagram showing the tables and fields in the tables to help you visualize more specifically what the database includes and how the tables are linked together.

 

The database provides 2 Raw Data formats: 1 CSV or Excel file pushed directly into the tool and 1 bak file to ensure data integrity and allow recovery in case of need.

 

If you are interested, please register to receive free documents!

Sign up to receive a data warehouse simulation database

Are you a student or a working person?
Do you need advice about the course?
Would you like to receive knowledge sharing emails from MDA?
What is your current job?
What field/industry does the company you work for operate in?
Are you an MDA student yet?

Database simulates real Datawarehouse to make the most professional Business Intelligence Project

The document includes 8 databases that simulate the actual structure of the Data Warehouse and are complex enough to do the most professional Business Intelligence Project . Dataset sources such as Kaggle, Dataset Research, etc. do not have a complete and complex structure to do a professional business intelligence data analysis project. Each database will have a diagram showing the tables and fields in the table to help you visualize more specifically what the database includes and how the tables are linked together. MDA will describe each database in general below!

1. Database Contoso

The Contoso database is a sample database created by Microsoft to help learn and develop applications in the Microsoft SQL Server environment. It is used as a sample data set to showcase Microsoft Business Intelligence products and DW/BI capabilities across the entire Microsoft Office product line. The data set includes information about company departments such as C-levels, Sales/Marketing, IT, Finance, and supports mapping integration, providing both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) data, along with reference data and dimensions. The Contoso database includes tables such as Customer, Order, OrderDetail, and Product, each containing different information about the company's customers, orders, order details, and products. These tables have relationships with each other, allowing for complex and powerful data queries. For example, a customer can have many different orders, and each order can have many different order details. These data can be used for data analysis, visualization, and training of predictive and classification models. In education, Contoso is often used as an example to teach concepts in many fields such as databases, application development, and systems management.

2. Database AdventureWorks 

The AdventureWorks database is a sample database developed by Microsoft to help users better understand Microsoft technologies and learn how to use them to develop applications. This database is designed for SQL Server, but can also be used with other database management systems such as Oracle, MySQL, PostgreSQL. AdventureWorks is set on a fictional company called AdventureWorks Cycles, a large-scale bicycle manufacturing and trading company. This database contains tables, views, and procedures related to customer management, product management, order management, and other transactions, used to illustrate objects in online task processing (OLTP). The AdventureWorks database provides complex functions such as data processing with transactions and combining data from multiple tables in the database. In addition, AdventureWorks has notable features such as using data constraints to protect data integrity, using indexes to optimize data access performance, and using triggers to automatically perform actions when data is added, modified, or deleted. These features make AdventureWorks a very useful sample database for developers and database administrators. AdventureWorks datasets can be used for data analysis, visualization, and training of predictive and classification models. AdventureWorks is also used in many courses, certifications, and training in database administration, database design, and application development.

3. Database WideWorldImposter

The WideWorldImporters database is an important resource for developers and database administrators to learn and practice new features of SQL Server and Azure SQL Database. It is also a wholesale database that contains a wealth of information about the import and export of goods. With new features and technologies of SQL Server, this database allows for multiple joins, in-memory processing of data, and full-text search. The data tables in the WideWorldImporters database provide detailed information about different aspects of a wholesale company's business. The main objects include customers, orders, products, warehouses, suppliers, and employees. In addition, this database also contains other important objects such as accounts, addresses, invoices, and shipping charges. Analyzing data in the WideWorldImporters database can help developers and database administrators gain a better understanding of a wholesaler’s business and find opportunities to optimize performance and business growth. The WideWorldImporters database is developed in the T-SQL language and can be used on a variety of operating system platforms, including Windows and Linux. This allows developers and database administrators to use the database on a variety of systems to develop and deploy applications. Additionally, the database can also be used in the cloud via Azure SQL Database and Azure SQL Managed Instance to provide easier scalability and data management.

4. Database Chinook

The Chinook database was developed to help students and teachers learn and practice database management skills. With tables such as artists, albums, media tracks, invoices, and customers, Chinook provides a practical and easy-to-understand approach to database management in the music retail industry. The Chinook database was created by Jeff Richter and released under the MIT license, allowing users to freely use and modify the database according to their needs. The Chinook database is available for many different database management systems, including SQL Server, Oracle, MySQL, and more. The Chinook database is also considered an alternative to the Northwind database, which is also a popular sample database used for learning and training in database management. However, Chinook provides more information about the music retail industry and can be used to develop real-world applications in the industry.

5. Sakila

Sakila is a database widely used in database management education and training. This database is developed by MySQL and includes tables for managing movie lists, employees, customers and DVD copies of movies. Sakila has many tables such as actor, film, category, customer and rental. It is designed to help learners and developers practice database management skills, from database design, creating queries to optimizing performance. Sakila also provides several reporting systems and script files to help users practice and better understand this database. Since Sakila is a free sample database, it is available for many different database management systems, including MySQL, SQL Server and PostgreSQL. This makes it easy and quick for learners and developers to access the database to practice and develop their skills in the field of database management.

6. Database Northwind

Northwind Database is a famous Microsoft database that contains data on the commercial activities of a virtual company called Northwind, which specializes in importing and exporting food products. The tables in this database will be a classic example for the sales problem and are widely used in learning and training database administration. The Northwind database provides tables to manage product lists, orders, suppliers, customers and employees. It is designed to help learners practice database management skills, such as database design, query creation and performance optimization. The Northwind database includes tables such as Products, Orders, Suppliers, Customers and Employees. It can be used to practice skills such as SQL programming, data processing and database design. In addition, Northwind also provides a number of reporting systems to help users better understand the database and practice data analysis skills. The Northwind database has been used by Microsoft for many years to showcase new features of SQL Server and other database technologies. Northwind is no longer officially supported by Microsoft, but it is still widely used in education and training.

7. World Database

World Database MySQL is a sample database that comes with the MySQL relational database management system. It is designed to be a practical example database for learning and practicing SQL (Structured Query Language) queries. The World Database MySQL database includes 3 tables city, country, countrylanguage containing information about countries, their cities and other related information such as population, region, continent, etc. These tables can be used to practice SQL queries, for example, searching for countries with a population above a certain threshold, or searching for cities within a certain country. In addition, World Database MySQL is also widely used in MySQL courses and documents to help learners master the skills of working with relational databases.

8. Qlikview

QlikView is a dataset used in the QlikView application, a software for visualizing and analyzing data. This dataset is organized in the form of tables and linked together through common fields (key fields) to form a relational data structure. QlikView dataset includes sample datasets such as Sales, Inventory, Human Resources, which are provided in the software for users to easily practice and learn. In addition, users can also create and use their own datasets in QlikView to visualize and analyze data. All datasets in QlikView are designed to allow users to perform complex data queries, create reports, charts and visual data models to help users better understand data and make more accurate business decisions.

Why study Business Data Analytics at MDA?

Ready to level up your analysis with MDA?

Join the Business Intelligence course now to improve your capacity and career opportunities in the digital age where data reigns supreme.

Student & Business Feedback

Lọc theo Thẻ

Display

82

result

This Course Helped Me Expand My Vision And Gain A Better Understanding Of How To Use Data To Make Smart Decisions In Business

Hình minh hoạ
Trinh Thi Khanh Chi

Business Analyst @Bao Viet Company

Các Kiến Thức Và Kỹ Năng Học Được Đã Giúp Tôi Hiểu Rõ Hơn Về Cách Thức Phân Tích Dữ Liệu Để Đưa Ra Dự Đoán Và Đưa Ra Quyết Định Thông Minh.

Hình minh hoạ
Nguyễn Xuân Thắng

Data Analyst @Kingfoodmart

Mặc Dù Ban Đầu Tưởng Rằng Mình Là Người Trẻ Nhất Trong Khóa Học, Nhưng Sau Khi Tham Gia, Tôi Nhận Ra Rằng Độ Tuổi Không Phải Là Rào Cản Để Học Hỏi Và Phát Triển

Hình minh hoạ
Đỗ Thị Hoa

Trưởng phòng Quản trị bán hàng @Công ty TNHH Livespo Pharma

Những Kỹ Thuật Và Phương Pháp Tại Khóa Học Giúp Tôi Hiểu Cách Xử Lý Và Làm Sạch Dữ Liệu Một Cách Hiệu Quả, Cùng Với Cách Tạo Ra Dashboard Đẹp Mắt Và Dễ Dàng Truyền Tải Thông Tin

Hình minh hoạ
Đỗ Bá Hải

Chuyên viên Quan Hệ Khách hàng @Ngân hàng Eximbank

Khóa Học Này Đã Mang Đến Cho Tôi Một Tư Duy Mới Về Phân Tích Dữ Liệu Và Cách Sử Dụng Các Công Cụ Trong Lĩnh Vực Business Intelligence

Hình minh hoạ
Phan Văn Nam

Financial Analyst @NCB

Khóa Học Này Đã Giúp Tôi Biết Cách Phân Tích Dữ Liệu Một Cách Chính Xác Và Hướng Dẫn Tôi Cách Trình Bày Kết Quả Một Cách Chuyên Nghiệp Hơn

Hình minh hoạ
Lê Thị Cẩm Tiên

Business Development Executive @King Elong

The Course Gave Me A More Logical Analytical Mindset And An Understanding Of How To Use Tools And Tools Effectively

Hình minh hoạ
Tran Thi Van Anh

BI @Viettel IDC Telecommunication Company

Khóa Học Dạy Về Power BI, Cách Ứng Dụng Cho Việc Tự Xây Dựng Và Quản Lý Dữ Liệu Nhanh Chóng Và Khoa Học Hơn Mà Trước Đó Mình Chưa Biết Tới

Hình minh hoạ
Đỗ Thị Nguyệt

Manager Health Care @Công ty TNHH 3M Việt Nam

Khóa Học Business Intelligence Không Chỉ Giúp Tôi Tích Luỹ Kiến Thức Một Cách Bài Bản Mà Còn Là Tài Sản Quý Báu Cho Sự Phát Triển Tương Lai

Hình minh hoạ
Nguyễn Viết Tuấn

Finance Staff @H.I.S Company

This Course Helped Me Learn How to Create Power BI Reports, Which Saved Me Significantly in My Daily Work

Hình minh hoạ
Vu Thu Trang

Product Planning @Panasonic Corporation

Các Case Study Được Đưa Ra Rất Thực Tế, Có Tính Ứng Dụng Cao, Có Nhiều Kiến Thức Bổ Ích Và Cần Thiết Để Có Thể Hiểu Sâu Hơn Về Mảng Dữ Liệu

Hình minh hoạ
Liêu Tuấn Tài

Business Development Executive @Công ty Fourth Valley Concierge

The lecturers at MDA are very enthusiastic in sharing their knowledge. This sharing has helped me to understand the concepts better and apply them in practice.

Hình minh hoạ
Hoang Anh Dao

Sales Staff @FitFood Company

Mastering Data Analytics

Mastering Data Analytics specializes in providing business data analysis training services to leading businesses in Vietnam and internationally.

 

The Business Data Analysis course has opened 55+ courses, with nearly 100 students/course

Hình minh hoạ

Training & Services

Mastering Data Analytics is a leading provider of public training courses, corporate training on Data Analytics and consulting services for businesses.

businesspeople-meeting-plan-analysis-1-2048x1058.jpg
BUSINESS
INTELLIGENCE​
  1. Business Intelligence Fundamentals

  2. Business Statistics

  3. DESCRIPTIVE ANALYTICS

  4. DIAGNOSTICS ANALYTICS

  5. Data Visualization & Storytelling

  6. Business Intelligence Capstone Project

corporate-training-2048x1058.jpg
CORPORATE
CONSULTING​
  1. Proof of Concept

  2. Technology Consulting

  3. Roadmap Consulting

  4. Project Delivery

  5. Corporate Training

bottom of page