Site Powered by nite.org

IT Business Intelligence
Build skills equivalent to the MCSE: Business Intelligence program
  • Credit Hours: 5 Days

  • Format: Virtual Classroom - Instructor-led, Online

  • Professional Certificate: MCSE: Business Intelligence

  • Recommended for: Database Administrators, Systems Engineers, System Analysts and Technical Consultants

The IT Technical Consultant course prepares students for employment in the Informational Technology industry. This course is an accelerated learning environment that builds skills and techniques to design, build, and deploy solutions that deliver more data to more people. Through theory-based lectures and virtual labs, students will obtain the knowledge and understanding of building reporting and analysis solutions with SQL Server 2012 and design, install, and maintain a business intelligence infrastructure with SQL Server 1012. Upon completion of this program, students will possess the skills and knowledge necessary to obtain employment and will be employable by various companies within the industry, as well as the opportunity for career advancement.  

This program prepares students for employment as a Database Administrator. According to the Bureau of Labor Statistics, employment change between 2010 and 2020 will grow 25% greater than the annual average.

What You'll Learn

  • Build reporting and analysis solutions with SQL Server 2012 by using MDX, DAX, Analysis Services, cubes and dimensions, PowerPivot, PowerView
  • Design, install, and maintain a business intelligence (BI) infrastructure with SQL Server 2012 including data warehouse, extract, transform and load (ETL), Analysis Services, Reporting Services and SharePoint Server

Who Needs to Attend

IT Professionals with at least three years of hands-on experience implementing and administering database systems

Prerequisites

  • MCSA: SQL Server 2012 certification or equivalent knowledge
  • Three years of hands-on experience working in a SQL Server 2008 or SQL Server 2012 environment
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Course Outline

1. Business Intelligence and Data Modeling

  • BI
  • The Microsoft BI Platform

2. Implementing Reports with Reporting Services

  • Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports using Parameters
  • Publishing and Viewing a Report

3. Supporting Self-Service Reporting

  • Report Builder
  • Creating Reusable Report Items

4. Managing a Report Execution and Delivery

  • Managing Security
  • Managing Report Execution
  • Subscriptions and Data Alert
  • Troubleshooting Reporting Services

5. Creating Multidimensional Databases

  • Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Cube Security

6. Working with Cubes and Dimensions

  • Configuring Dimensions
  • Attribute Hierarchies
  • Sorting and Grouping Attributes

7. Working with Measures and Measure Groups

  • Measures
  • Measure Groups

8. Multidimensional Expressions (MDX)

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

9. Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions, Perspectives, and Translations

10. Implementing a Tabular Data Model by Using Microsoft PowerPivot

  • Tabular Data Models and PowerPivot Technologies
  • Creating a Tabular Data Model by using PowerPivot for Excel
  • Sharing a PowerPivot Workbook and using PowerPivot Gallery

11. Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

12. Implementing an Analysis Services Tabular Data Model

  • Analysis Services Tabular Data Model Projects
  • Implementing an Analysis Services Tabular Data Model Using SQL Server Data Tools

13. Creating Data Visualizations with Power View

  • Power View
  • Visualizing Data with Power View

14. Performing Predictive Analysis with Data Mining

  • Data Mining
  • Create and Validate a Data Mining Model
  • Using the Data Mining Add-In for Excel
  • Using a Data Mining Model in a Report

1. Planning a BI Solution

  • Elements of a BI Solution
  • Microsoft BI Platform
  • Planning a BI Project

2. Planning a SQL Server BI Infrastructure

  • Considerations for a BI Infrastructure
  • Planning Data Warehouse Hardware

3. Designing a Data Warehouse

  • Data Warehouse Design
  • Designing Dimension Tables and Fact Tables
  • Designing a Data Warehouse Physical Implementation

4. Designing an ETL Solution

  • ETL Overview
  • Planning Data Extraction, Data Transformation, and Data Loading

5. Designing Analytical Data Models

  • Analytical Data Models
  • Designing an Analytical Data Model
  • Designing Dimensions
  • Enhancing Data Models

6. Planning a BI Delivery Solution

  • Considerations for Delivering BI
  • Common Reporting Scenarios
  • Choosing a Reporting Tool

7. Designing a Reporting Services Solution

  • Planning a Reporting Services Solution
  • Designing Reports
  • Planning Reporting Consistency

8. Designing a Microsoft Excel-Based Reporting Solution

  • Using Excel for Data Reporting and Analysis
  • PowerPivot and Power View for Excel

9. Planning a SharePoint Server BI Solution

  • SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning PowerPivot Configuration
  • Planning for PerformancePoint Services

10. Monitoring and Optimizing a BI Solution

  • BI Monitoring Overview
  • Monitoring and Optimizing the Data Warehouse, Analysis Services, and Reporting Services

11. Operating a BI Solution

  • BI Operations Overview
  • ETL Operations
  • Data Warehouse, Analysis Services, and Reporting Services Operations

Labs

Lab 1: Report and Analyze Data

Lab 2: Create a Report with Report Designer

Lab 3: Enhance and Publish a Report

Lab 4: Implement Self-Service Reporting

Lab 5: Configure Report Execution and Delivery

Lab 6: Create a Multidimensional Database

Lab 7: Define Dimensions

Lab 8: Configure Measures and Measure Groups

Lab 9: Use MDX

Lab 10: Customize a Cube

Lab 11: Use PowerPivot for Excel

Lab 12: Create Calculated Columns and Measures by using DAX

Lab 13: Work with an Analysis Services Tabular Data Model

Lab 14: Create Interactive Reports with Power View

Lab 15: Use Data Mining to Support a Marketing Campaign

Lab 1: Planning a BI Solution

Lab 2: Planning a BI Infrastructure

Lab 3: Designing a Data Warehouse Logical Schema

Lab 4: Design a Data Warehouse Physical Implementation

Lab 5: Designing an ETL Solution

Lab 6: Comparing Analytical Data Models

Lab 7: Designing Dimensions and Hierarchies

Lab 8: Enhancing Analytical Data Models

Lab 9: Planning a BI Delivery Solution

Lab 10: Designing a Reporting Services Solution

Lab 11: Designing an Excel Reporting Solution

Lab 12: Implementing a SharePoint Server BI Solution

Lab 13: Implementing PerformancePoint Services

Lab 14: Monitoring and Optimizing a BI Solution

Lab 15: Operating a BI Solution

Purchase this Course

$3695.00

Become versed as an IT Technical Consultant in 5 Days