Database Business Intelligence: Intermediate SQL Server 2014

https://www.skillsoft.com/channel/database-business-intelligence-babfb2b0-e199-11e6-93f3-0242c0a80605?expertiselevel=29989&technologyandversion=29990 https://www.skillsoft.com/channel/database-business-intelligence-babfb2b0-e199-11e6-93f3-0242c0a80605?expertiselevel=29991&technologyandversion=29990
  • 16 Courses | 17h 41m 34s
  • 4 Books | 31h 56m
  • 2 Courses | 1h 42m 53s
  • 3 Books | 21h 40m
Likes 77 Likes 77
 
Business Intelligence means collecting and analyzing massive amounts of data for decision-making. Discover the various facets of BI technologies.

GETTING STARTED

Designing BI Infrastructure

  • Playable
    1. 
    The BI Infrastructure Data Sources
    8m 38s
    NOW PLAYING
  • Playable
    2. 
    Data Warehouse and ETL Solution for a BI Infrastructure
    7m 32s
    UP NEXT

GETTING STARTED

Data Warehousing & Business Intelligence Implementation

  • Playable
    1. 
    Data Warehousing Overview
    5m
    NOW PLAYING
  • Playable
    2. 
    Business Intelligence Overview
    4m 18s
    UP NEXT

COURSES INCLUDED

Designing BI Infrastructure
A business intelligence (BI) solution provides a storage solution for data gathered for analysis and reporting. Discover infrastructure elements involved in a BI solution, and how to plan a BI project.
11 videos | 1h 12m
has Assessment available Badge
Implementing BI Infrastructure
How the database is designed will greatly impact the analysis and reporting of the data it contains. Examine data warehouse design, including dimension and fact table design, for a BI solution.
10 videos | 1h 3m
has Assessment available Badge
Planning BI Infrastructure
To get the most out of your data, it is important that the data warehouse is properly designed. Learn about planning the physical design of the data warehouse, including file storage, table partitioning, and indexes.
7 videos | 53m
available Badge
Extract, Transform, & Load
SQL Server 2014 provides an Extract, Transform, and Load (ETL) process to populate the data warehouse from the source systems. Examine ETL package design for gathering and transforming the source data.
12 videos | 1h 33m
has Assessment available Badge
BI Project Deployment
The SQL Server 2014 ETL process provides a convenient way to populate your data warehouse database. Discover how to deploy ETL projects and packages, and manage ETL solutions.