Skillsoft
Skillsoft

MCSE: Business Intelligence

Course description

Duration

duration

2 yrs

Study mode

studyMode

Online

Start date

date

Enrol anytime.Have a question about this course? Contact the course provider.

  • Gain the skills to build & deploy SQL Server business intelligence (BI) solutions with this Microsoft Certified Solutions Expert (MCSE): Business Intelligence training
  • Develop your career as a BI & Reporting Engineer
  • Study online at your own pace

This Skillsoft course will train you in everything you need to know to pass the exams for the MCSE: Business Intelligence certification. You'll need to sit the exams separately.

Course details

Entry requirements

MCSA SQL Server 2012

Recognition
Location
Online
Start dates
Enrol anytime.Have a question about this course? Contact the course provider.
Duration
Self paced. 94 hours (e.g. 8 hours a week = finish in 12 weeks). Complete within 2 years.
Study mode
Online
Education institution
Skillsoft
Price
$1995
Payment options
Credit cardsSSL Security
You can pay for this course upfront securely online via credit card.

Ready to start?

Skillsoft

MCSE: Business Intelligence

  1. Enrol in a few steps and pay via credit card
  2. Receive access to the course by email
  3. Support is available as you study
Enrol now
Price: $1,995AUD (GST Exempt)

Career insights

Explore roles related to this qualification

Course content

42 units

  • Creating database objects
  • Querying basics and modifying data
  • Manipulate data using operators and functions
  • Creating functions and triggers
  • Creating programming objects and optimizing queries
  • Managing XML data
  • Installation and upgrade
  • Instance configuration and database creation
  • Managing databases and automating tasks
  • Security management
  • Managing database data
  • Managing indexes, full-text search and partitions
  • Backing up and restoring databases
  • Database monitoring and performance tuning
  • Configuring high availability
  • Design and deployment
  • Create basic packages
  • ETL solutions
  • Enhancing packages
  • Custom components
  • Installing SSIS
  • Troubleshooting
  • DQS and MDS solutions
  • Design and install analysis services and tools
  • Designing multidimensional models and data sources
  • Implement and configure cubes
  • Design and implement dimensions
  • Implement partitions and custom logic
  • MDX Queries, process models and deploy databases
  • Manage, maintain and troubleshoot SSAS
  • Create and manage tabular data models
  • Design reports and create data sources and datasets
  • Report formatting and interactivity
  • Manage reporting services
  • Process report and create subscriptions and schedules
  • BI infrastructure design
  • Extract, transform and load
  • Data models
  • Reporting services
  • SharePoint integration
  • MDX Queries and performance
  • Availability and recovery

SEEK Learning's MCSE certification training will fully prepare you for the MCSE exams 70-461, 70-462, 70-463, 70-466 and 70-467.

Please note that the MCSE exams are held by an external provider.

Entry requirements

Successful completion of MCSA:SQL Server 2012 (exams 70-461, 70-462, 70-463)

What you’ll learn

You'll learn how to:

  • Design, create, and configure SQL Server 2012 database objects
  • Add additional features and components to an installation of SQL Server 2012
  • Use a data warehouse to create reports and aggregate data
  • Install SSAS and SQL Server Data Tools – Business Intelligence
  • Design and build a BI solution and what elements are involved

Recognition

Certification is awarded by Microsoft and is globally recognised. 

Support and delivery

Skillsoft & SEEK Learning partnership

SEEK Learning provides training from Skillsoft, the premier global provider of IT e-learning courseware.

Skillsoft does not generally offer courses directly to individuals, but our partnership enables us to exclusively offer MCSE training directly to you.

Skillsoft courses are developed according to the certification specifications of leading vendors.

Payment options

There is 1 way you can pay for this course:

Upfront payment
Credit cardsSSL Security

You can pay for this course upfront securely online via credit card.

Ready to start?

Skillsoft

MCSE: Business Intelligence

  1. Enrol in a few steps and pay via credit card
  2. Receive access to the course by email
  3. Support is available as you study
Enrol now
Price: $1,995AUD (GST Exempt)

Undecided about this course?

Browse courses by area of interest