From the course: Implementing a Data Warehouse SQL Server 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Business intelligence applications - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Business intelligence applications
- [Instructor] Once you have all of your internal and external data organized, cleansed, and reconfigured into fact and dimension tables in the data warehouse, it's time to actually do something with that data. This brings us back to the concept of business intelligence. The purpose of business intelligence is to gain insight by analyzing raw data that can lead to a competitive advantage in the marketplace. The results of a business intelligence analysis are used to support operational decision making by reviewing past trends in the market, as well as predicting future outcomes. This allows decision makers within the enterprise, to be able to better position the company to take full advantage of shifts in customer behavior, efficiencies in manufacturing, or right-sizing the workforce. Having a well-structured and complete data warehouse isn't ever an end-goal in itself, though. All of that data is worthless if it's not…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.