Designing a Data Warehouse
Learn how to design a Microsoft SQL Server Data Warehouse
Note: 0/5 (0 notes) 837 students
Instructor(s): Bluelime Learning Solutions
Last update: 2022-04-29
What you’ll learn
- Setup Microsoft SQL Server
- Configure database settings for data warehousing
- Enable SQL Server Agent
- Logical design of data warehouse
- Physical design of data warehouse
- Design Dimension Tables
- Basic knowledge of database concepts advised.
A data warehouse is a central repository of information that can be analysed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence. Business analysts, data engineers, data scientists, and decision makers access the data through business intelligence (BI) tools, SQL clients, and other analytics applications.
Data and analytics have become indispensable to businesses to stay competitive. Business users rely on reports, dashboards, and analytics tools to extract insights from their data, monitor business performance, and support decision making. Data warehouses power these reports, dashboards, and analytics tools by storing data efficiently to minimize the input and output (I/O) of data and deliver query results quickly to hundreds and thousands of users concurrently.
A data warehouse is specially designed for data analytics, which involves reading large amounts of data to understand relationships and trends across the data. A database is used to capture and store data, such as recording details of a transaction.
This course explains the design of dimension tables, physical and logical design of a data warehouse .
Physical design is the creation of the database with SQL statements. During the physical design process, you convert the data gathered during the logical design phase into a description of the physical database structure. Physical design decisions are mainly driven by query performance and database maintenance aspects.
The process of logical design involves arranging data into a series of logical relationships called entities and attributes. An entity represents a chunk of information. In relational databases, an entity often maps to a table. An attribute is a component of an entity that helps define the uniqueness of the entity.
A dimension table is a table in a star schema of a data warehouse. A dimension table stores attributes, or dimensions, that describe the objects in a fact table. In data warehousing, a dimension is a collection of reference information about a measurable event.
Who this course is for
- Beginners to data warehouse
- Beginner Data Analyst
- Beginner Data Scientist
- Microsoft SQL Server Setup
- What is SQL Server
- SQL Server Editions
- SQL Server Installation Requirements
- Download SQL Server
- Install SQL Server
- Install SSMS
- Connect SSMS to SQL Server
- Install sample data warehouse database
- Data Warehouse Configuration
- What is a data warehouse
- Database vs data warehouse
- Data Warehouse Vs Enterprise Data Warehouse
- Hardware requirements for data warehouse
- Configure database settings for a data warehouse
- FTDW Sizing Tool
- Designing a Data Warehouse
- Logical design of a data warehouse
- Physical design of a data warehouse: Part 1
- Physical design of a data warehouse: Part 2
- Designing Dimension Tables
|Don’t miss any coupons by joining our Telegram group|