MCSE: Business Intelligence

Course description



94 hrs

Study mode



Next start date



  • 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.

Campus options

1 campus available

CampusStudy modeDurationNext start date

Online (self paced)

94 hrs


Course details

Entry requirements

MCSA SQL Server 2012

Next start date
94 hrs
Study mode
Education institution
Payment options
Credit cardsSSL Security
You can pay for this course upfront securely online via credit card.

Course content

  • 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


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?


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
Price: $1,995AUD (GST Exempt)

Undecided about this course?

Find out more about this course


MCSE: Business Intelligence

Enrol now ($1,995)

Price is AUD GST Exempt.