Designing BI Infrastructure

SQL Server 2014    |    Expert
  • 11 videos | 1h 7m 19s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
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.

WHAT YOU WILL LEARN

  • Describe the elements of a bi infrastructure and explain data sources
    Describe a data warehouse and etl for a bi infrastructure
    Describe analytical data models and the reporting and analysis element in a bi infrastructure
    Describe the role windows server, sql server, sharepoint, and office applications play in a bi infrastructure
    Describe the considerations and guidelines for updating an existing bi solution
    Describe the key features in a bi project
  • Describe the applications, development, and test infrastructure as well as the personnel to build the bi project
    Plan system sizing and workload for a bi infrastructure
    Describe the different types of server topologies for a bi solution
    Plan for scaling out a bi solution
    Plan for high availability for a bi solution

IN THIS COURSE

  • 8m 38s
    After completing this video, you will be able to describe the elements of a BI infrastructure and explain data sources. FREE ACCESS
  • 7m 32s
    Upon completion of this video, you will be able to describe a data warehouse and ETL process for a BI infrastructure. FREE ACCESS
  • Locked
    3.  Analytical Data Models and Reporting
    9m 15s
    Upon completion of this video, you will be able to describe analytical data models, the reporting element, and the analysis element in a BI infrastructure. FREE ACCESS
  • Locked
    4.  Microsoft Product Roles in the BI Infrastructure
    6m 57s
    After completing this video, you will be able to describe the role Windows Server, SQL Server, SharePoint, and Office applications play in a business intelligence infrastructure. FREE ACCESS
  • Locked
    5.  BI Infrastructure Upgrade Considerations
    6m 6s
    After completing this video, you will be able to describe the considerations and guidelines for updating an existing business intelligence solution. FREE ACCESS
  • Locked
    6.  Overview of Building a BI Project
    5m 22s
    After completing this video, you will be able to describe the key features in a business intelligence project. FREE ACCESS
  • Locked
    7.  The Infrastructure and Personnel to Build a BI Project
    3m 37s
    After completing this video, you will be able to describe the applications, development, and test infrastructure as well as the personnel needed to build the BI project. FREE ACCESS
  • Locked
    8.  Planning for the Size and Workload of an Infrastructure
    6m 2s
    Find out how to plan system sizing and workload for a BI infrastructure. FREE ACCESS
  • Locked
    9.  SQL Server BI Topologies
    3m 38s
    After completing this video, you will be able to describe the different types of server topologies for a business intelligence solution. FREE ACCESS
  • Locked
    10.  Designing Scaling for a BI Solution
    5m 31s
    In this video, you will learn how to scale out a BI solution. FREE ACCESS
  • Locked
    11.  Designing for High Availability
    4m 41s
    During this video, you will learn how to plan for high availability for a BI solution. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Book Self-Service Analytics with Power BI: Learn How to Build an End-To-End Analytics Solution in Power BI

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Implementing BI Infrastructure
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Agile Best Practices for Tech Leaders: Agile Frameworks
Rating 4.5 of 61 users Rating 4.5 of 61 users (61)
Course Developing an AI/ML Data Strategy: The Data Analytics Maturity Model
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)