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 | 16h 41m 50s
  • 4 Books | 31h 56m
  • 2 Courses | 1h 36m 53s
  • 3 Books | 21h 40m
Likes 129 Likes 129
 
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 7m 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 | 59m 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 | 51m 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 28m 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.
11 videos | 1h 11m available Badge
Preparing for BI Data Models
SQL Server Analysis Services uses data models for the storage and analysis of data. Explore the Business Intelligence Semantic Model (BISM) framework, and how to choose and design the appropriate model.
5 videos | 32m has Assessment available Badge
Designing BI Data Models
Data models use performance indicators and aggregation to add extra value to the data being presented. Discover how to design and create multidimensional and tabular data models to achieve this goal.
13 videos | 1h 22m has Assessment available Badge
BI Data Model Partitions
Partitions can improve performance when retrieving data for analysis and reporting. Learn how to design and create partitions for cubes and tables in your BI data warehouse.
6 videos | 36m has Assessment available Badge
BI Reporting & Analysis
SQL Server Reporting Services (SSRS) can deliver meaningful data to the business users. Explore the SSRS architecture and tools available for creating and delivering reports.
10 videos | 48m has Assessment available Badge
BI Reporting Strategies
SSRS helps you deliver meaningful data to the business users. Learn how to design and create an effective SSRS reporting solution, including managing the underlying data sources and datasets.
15 videos | 1h 22m has Assessment available Badge
Integration, Features, & Installation
You can improve your BI reports using SharePoint and SSRS together. Learn how to integrate SharePoint with Reporting Services, and use PowerPivot and Power View to create more meaningful reports.
11 videos | 1h 7m has Assessment available Badge
Planning & Configuration
Used together, SharePoint and SSRS can provide a powerful report delivery system. Discover how to plan, create, and manage an effective report processing and delivery system for your BI solution.
12 videos | 1h 6m has Assessment available Badge
MDX Queries
Multidimensional expression, MDX, is a query language used to retrieve data and perform data definition and data manipulation operations for Analysis Services. Learn how to create MDX calculations to obtain the desired result set.
11 videos | 1h 9m available Badge
MDX Performance
You must monitor performance and security to ensure a BI solution is operating efficiently. Discover how to achieve this for the SQL Server instances being used, including SSAS, the data warehouse, and SSRS.
9 videos | 55m available Badge
Availability & Configuration
For an effective BI solution, users must be able to access the data they require, when they require it. Learn how to design and implement strategies to secure your data and provide high availability in a BI infrastructure.
13 videos | 1h 20m has Assessment available Badge
Recovery & Backup
BI administrators need to ensure that stored data is valid and available to the users. Discover how to design and implement strategies for data backup, recovery, and logging in a BI solution.
9 videos | 42m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Data Warehousing & Business Intelligence Implementation
Data warehousing and business intelligence have become fundamental to maintaining business competitiveness. Examine what is involved in creating a SQL Server data warehouse, and how to create and deploy an SSIS package.
15 videos | 59m available Badge
Data Warehousing & Business Intelligence Deployment
To gain a business edge, it is vital to extract business intelligence from data warehouses. Examine how to achieve this goal using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
10 videos | 37m available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Knight's Microsoft Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and SharePoint
If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book provides you with the just the right amount of information to perform basic business analysis and reporting.
book Duration 4h 24m book Authors By Adam Jorgensen, Brian Knight, Devin Knight, Mike Davis, Patrick LeBlanc

Book

Business Intelligence with SQL Server Reporting Services
Helping you deliver business intelligence with panache, this straightforward guide will show you how to harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards.
book Duration 5h 51m book Authors By Adam Aspin

Book

Pro SQL Server 2012 BI Solutions
Providing practical examples of cost-effective business intelligence projects, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments.
book Duration 11h 25m book Authors By Caryn Mason, Randal Root

Book

Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition
Filled with expert tips and best practices, this hands-on guide shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide.
book Duration 10h 16m book Authors By Brian Larson
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Business Intelligence with SQL Server Reporting Services
Helping you deliver business intelligence with panache, this straightforward guide will show you how to harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards.
book Duration 5h 51m book Authors By Adam Aspin

Book

Pro SQL Server 2012 BI Solutions
Providing practical examples of cost-effective business intelligence projects, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments.
book Duration 11h 25m book Authors By Caryn Mason, Randal Root

Book

Knight's Microsoft Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and SharePoint
If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book provides you with the just the right amount of information to perform basic business analysis and reporting.
book Duration 4h 24m book Authors By Adam Jorgensen, Brian Knight, Devin Knight, Mike Davis, Patrick LeBlanc