From the course: Introduction to Microsoft Fabric by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Organize data in a data warehouse

Organize data in a data warehouse - Microsoft Fabric Tutorial

From the course: Introduction to Microsoft Fabric by Microsoft Press

Start my 1-month free trial Buy for my team

Organize data in a data warehouse

“

- In the previous sub-lesson, we talked about the schema-first and data-first paradigms in data management. For many years, the only way to do analytics or business intelligence is by using relational database technology, schema-first solution. Data warehouse is commonly understood as a relational database designed to store data for reporting and analysis. You may also see the term enterprise data warehouse. Here the objective is to gather all data in the enterprise into one large database as the single source of truth for all analytics activities throughout the organization. Being a relational database, the data warehouse is based on SQL or Structured Query Language or SQL in short. If you're not familiar with SQL, this is the language used to query or retrieve sets of data from relational databases. With SQL, you can write queries that retrieve data from multiple tables in the database. When you do this, you need to specify in which way these tables are joined together in the result…

Contents