305-651-6500

Jobs    Everything

Select a Metro Area

Business Intelligence Full Immersion Boot Camp – 5 Days

by | Apr 29, 2013

Calendar
When:
May 13, 2013 – May 18, 2013 all-day America/New York Timezone
2013-05-13T04:00:00+00:00
2013-05-18T04:00:00+00:00
Where:
Homnick Systems
902 Clint Moore Road
Boca Raton, FL 33487
USA
Boca

Register via email

Download the flyer

Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Additionally we teach how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-463 and 70-466.

What you will be able to do after the class

 

  • · Describe data warehouse concepts and architecture considerations.
  • · Select an appropriate hardware platform for a data warehouse.
  • · Design and implement a data warehouse.
  • · Implement Data Flow in an SSIS Package.
  • · Implement Control Flow in an SSIS Package.
  • · Debug and Troubleshoot SSIS packages.
  • · Implement an SSIS solution that supports incremental data warehouse loads and changing data.
  • · Integrate cloud data into a data warehouse ecosystem infrastructure.
  • · Implement data cleansing by using Microsoft Data Quality Services.
  • · Implement Master Data Services to enforce data integrity.
  • · Extend SSIS with custom scripts and components.
  • · Deploy and Configure SSIS packages.
  • · Describe how information workers can consume data from the data warehouse.
  • · Describe the components, architecture, and nature of a BI solution.
  • · Create reports with Reporting Services.
  • · Create reusable report items that simplify self-service reporting.
  • · Manage report execution and delivery.
  • · Create a multidimensional database with Analysis Services.
  • · Implement dimensions in a cube.
  • · Implement measures and measure groups in a cube.
  • · Use MDX Syntax.
  • · Customize a cube.
  • · Implement a Tabular Data Model in PowerPivot.
  • · Use DAX to query a tabular model.
  • · Implement a Tabular Database.
  • · Use PowerView to create interactive data visualizations.

· Use Data Mining for Predictive Analysis