Interactive

Microsoft SQL Server Data Warehousing and Business Intelligence Overview

Skillsoft

Updated Oct 17, 2019

Course Overview

As capabilities and capacities of modern computers continue to proliferate, data warehousing, and business intelligence more broadly, have become fundamental to maintaining business competitiveness. This course describes the concepts and methodologies involved in creating data warehouses and using them to extract business intelligence.

Target Audience

IT and business professionals with an interest in harvesting business intelligence from SQL Server databases

Learning Objectives

describe data warehousing
recognize the key concepts of business intelligence
recognize the function of normalization in OLTP databases and denormalization in OLAP databases
describe dimension and fact tables in OLAP databases
recognize the star and snowflake schemas in data warehouse databases, and the role of KPIs in business intelligence
create a fact table in a data warehouse database in SQL Server
create a dimension table in a data warehouse database in SQL Server
create a columnstore index in a data warehouse database in SQL Server
create a table and index partition in a data warehouse database in SQL Server
implement data compression in a data warehouse database in SQL Server
create a simple SSIS package in SQL Server using SQL Server Data Tools
create a control flow in SQL Server using SQL Server Data Tools
create a data flow in SQL Server using SQL Server Data Tools
create a transform in SQL Server using SQL Server Data Tools
deploy an SSIS package in SQL Server
create a SQL Server Analysis Service project using SQL Server Data Tools
create a data source in SQL Server Analysis Services using SQL Server Data Tools
create a cube in SQL Server Analysis Services using SQL Server Data Tools
deploy SQL Server Analysis Services
query SQL Server Analysis Services using Excel
connect to a data source to create a report in SQL Server Report Builder
create a basic SQL Server Report
create a SQL Server report with calculations
create a SQL Server report with end user interactive elements
deploy a SQL Server report
create and query a data warehouse in SQL Server

Related learning

SSAS 2014, Part 01 of 10: Basics and ToolsInteractive ⋅ 106 mins

SQL for Business Intelligence (MySQL)Course ⋅ 600 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Skillsoft

Skillsoft is the global leader in corporate learning, providing the most engaging learner experience and high-quality content. Skillsoft are trusted by the world's leading organizations, including 65 percent of the Fortune 500. Skillsoft's mission is to build beautiful technology and engaging content that drives business impact for today's modern enterprise. Skillsoft provides a comprehensive selection of cloud-based corporate learning content, including courses, videos, books and other resources. Skillsoft's 500,000+ multi-modal courses, videos, authoritative content chapters and micro-learning modules are accessed more than 130 million times every month, in 160 countries and 29 languages. Via the Go1 Content Hub, you can access Skillsoft courses on topics including Business and Management Skills, Leadership Development, Digital Transformation, IT Skills and Certification Training, Productivity and Collaboration Tools and Compliance.