Database Business Intelligence: intermediate SQL Server 2014
Expertise:
Technology:
- 16 Courses | 16h 41m 50s
- 4 Books | 31h 56m
- 2 Courses | 1h 36m 53s
- 3 Books | 21h 40m
Business Intelligence means collecting and analyzing massive amounts of data for decision-making. Discover the various facets of BI technologies.
GETTING STARTED
Data Warehousing & Business Intelligence Implementation
-
5m
-
4m 18s
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
Assessment
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
Assessment
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
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
Assessment
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
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
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
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
Assessment
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
Assessment
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
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
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 SharePointIf 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.
4h 24m
By Adam Jorgensen, Brian Knight, Devin Knight, Mike Davis, Patrick LeBlanc
Book
Business Intelligence with SQL Server Reporting ServicesHelping 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.
5h 51m
By Adam Aspin
Book
Pro SQL Server 2012 BI SolutionsProviding 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.
11h 25m
By Caryn Mason, Randal Root
Book
Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth EditionFilled 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.
10h 16m
By Brian Larson
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Business Intelligence with SQL Server Reporting ServicesHelping 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.
5h 51m
By Adam Aspin
Book
Pro SQL Server 2012 BI SolutionsProviding 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.
11h 25m
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 SharePointIf 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.
4h 24m
By Adam Jorgensen, Brian Knight, Devin Knight, Mike Davis, Patrick LeBlanc