MS-MCSE-SQLDATA-BI FastTrack to MCSE Data Management and Analytics through SQL Business Intelligence Boot Camp (MS-MCSE-SQLDATA-BI)

The course discusses design, installation, and operations of a BI platform, including Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and Microsoft SharePoint Server.
  • Virtual Classroom

    Learning Style
  • Intermediate

    Difficulty
  • 6 Days

    Course Duration
  • 10 Days

    SATV Value
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
New
$4,095.00
$4,095.00
/ Seat
The course discusses design, installation, and operations of a BI platform, including Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and Microsoft SharePoint Server.

About this course:

This six-day instructor-led course teaches students how to design and implement a BI infrastructure for enterprise data models and reports. The course discusses design, installation, and operations of a BI platform, including Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and Microsoft SharePoint Server. This course will also cover how to empower information workers through self-service analytics and reporting. Students will learn how to use Microsoft SQL Server Reporting Services, and Microsoft Excel to deliver a self-service BI solution, and how to use Microsoft Windows Azure HDInsight to incorporate Big Data analysis into a BI scenario.

This boot camp prepares you for the following exams:

Course Objective:

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution.
  • 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 SQL Server Analysis Services.
  • Use DAX to enhance a tabular model.
  • Create reports with Reporting Services.
  • Enhance reports with charts and parameters.
  • Manage report execution and delivery.
  • Implement a dashboard in SharePoint Server with PerformancePoint Services.
  • Use Data Mining for Predictive Analysis.

Audience:

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

  • Implementing analytical data models, such as OLAP cubes.
  • Implementing reports, and managing report delivery.
  • Creating business performance dashboards.
  • Supporting data mining and predictive analysis.

Prerequisite:

This course requires that you meet the following prerequisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Suggested prerequisite course:

More Information
Brand Microsoft
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 6 Days
Language English
SATV Value 10 Days
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's