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

Khóa học rất chi tiết về quy trình làm BI, giúp mình cụ thể hóa những công việc thực tế của một người làm phân tích dữ liệu. Giờ đây mình đã biết cách áp dụng Power Query để tối ưu phân tích dữ liệu và chọn đúng biểu đồ để báo cáo hiệu quả hơn

Hình minh hoạ
Nguyen Quang Nhan

Data Controller @Vibrant LLC

Tôi đã ứng dụng vào phân tích các báo cáo liên quan đến tài chính, tôi cảm thấy hào hứng và choáng ngợp vì nội dung được cung cấp trong khóa học

Hình minh hoạ
Hoàng Thanh Xuân

Kế toán @ Công Ty CP Công Nghệ Tex Việt Nam

The Course Helped Me Gain a Deeper Understanding of the Importance of Using Data to Make Decisions, Through How to Build Automated Reporting Dashboards

Hình minh hoạ
Dao Van Anh

Assistant to CSO – Blockchain

Not Limited To Theoretical Knowledge, There Is Also A Lot Of Relevant Practical Information Here

Hình minh hoạ
Duong Hoang Phuc

Production Planner

The course provides very good and effective analytical thinking, thanks to which the approach to the fields is more systematic. The lecturers all have in-depth skills and extensive experience, good pedagogical ability, full of positive energy, very professional and practical.

Hình minh hoạ
Bui Viet Cuong

Project Management - AKH Investment JSC

Tôi đã học được nhiều kỹ năng và phương pháp phân tích dữ liệu, từ đó thay đổi được mindset về ngành nghề data analyst. Hệ thống được quy trình làm việc cũng như phân tích dữ liệu một cách rõ ràng và chuyên nghiệp

Hình minh hoạ
Mai Thi Nhu Thao

Data Analyst @ Home Credit

Tôi Đã Nắm Vững Cách Xử Lý Dữ Liệu Một Cách Hiệu Quả Hơn, Giúp Tôi Tiết Kiệm Thời Gian Và Nâng Cao Hiệu Suất Làm Việc

Hình minh hoạ
Nguyen Duy Hoai Anh

IT Application @La Vie Company

Sau Một Năm, Tôi Đã Có Cơ Hội Thể Hiện Khả Năng Sử Dụng Dashboard Thành Thạo Trước Sếp, Điều Đó Thực Sự Tuyệt Vời Và Tôi Rất Trân Trọng Điều Đó

Hình minh hoạ
Nguyen Thi Ngoc Yen

Financial Planning & Analysis @Công ty CPDT & PTDL Phú Quốc

The course is quite valuable for the cost. I learned how to think, process data to analyze, thereby discovering actionable insights and optimizing work. In addition, after the course, I combined with knowledge about the product and the company to rebuild the company's Data Model for better optimization.

Hình minh hoạ
Nguyen Trung Hieu

Head of R&D @GC Group

Khóa Học Giúp Mình Có Tư Duy Bài Bản Hơn Về Phân Tích Dữ Liệu, Hiểu Được Quy Trình Phân Tích Để Tránh Mắc Sai Sót Trong Quá Trình Làm Việc

Hình minh hoạ
Nguyen Thi Minh

Export Coordinator - Exporting Industry @Cty Open Country Dairy Limited

Thông Tin Học Được Vô Cùng Hữu Ích Để Áp Dụng Vào Việc Tạo Báo Cáo, Giúp Tối Ưu Hoá Thời Gian Làm Việc

Hình minh hoạ
Phí Thị Hiền

Vận hành – Dịch vụ Khách hàng @ One Mount

Khóa Học Business Intelligence Đã Thực Sự Mang Lại Cho Tôi Những Trải Nghiệm Và Kiến Thức Đáng Giá. Tôi Đã Học Được Khả Năng Tự Động Ghép Nối Dữ Liệu, Giúp Tối Ưu Hóa Việc Làm Việc Với Dữ Liệu

Hình minh hoạ
Huỳnh Dương Ngọc Uyển

Manager @Công ty KOVA

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