Skip to main content

Microsoft 70-467 – Designing Business Intelligence Solutions with SQL Server

Advanced19 Hours 56 Minutes48 Course Videos43 Test Questions

$99.00

Plan and design SQL Server business intelligence solutions with this Microsoft 70-467 course. Cover data warehouses, ETL, SSIS and reporting in 19 hours 56 minutes of video.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server teaches you to plan a full business intelligence (BI) setup, from data loading to reports. It follows the Microsoft 70-467 exam, which was part of the MCSE: Business Intelligence track, and suits BI architects, developers and data analysts. You get 19 hours 56 minutes of self-paced training across 48 video lessons.

What you will learn

  • Plan and design a BI infrastructure on SQL Server
  • Explain data warehouses, ETL and semantic models
  • Use Power Pivot as part of a BI solution
  • Work with database objects, stored procedures and triggers
  • Back up and restore SQL Server databases
  • Build Integration Services packages in SQL Server Data Tools
  • Transform data and load fact tables with SSIS
  • Build reports with Report Builder, including multi-table and interactive reports
  • Create drill-through reports and data visuals
  • Use newer SQL Server 2014 features such as cloud backups and partitioning

Course outline: Microsoft 70-467

  1. Intro to business intelligence: BI basics, Power Pivot, ETL, data warehouses and semantic models.
  2. Database essentials: database objects, stored procedures, triggers, SQL Server management, backup and restore.
  3. Business intelligence development: SQL Server Data Tools, Integration Services packages and loading remote data.
  4. Business intelligence results: building reports, Report Builder, web services, multi-table and interactive reports.
  5. Advanced reporting and development: drill-through reports, data visuals, stored procedures and memory-optimised tables.
  6. SQL Server Integration Services (SSIS): integration projects, data transformation, fact tables and an intro to big data.
  7. SQL Server 2014 new features: backup and index changes, cloud backups and partitioning.
  8. Course review and exam prep: a recap, a SharePoint overview and exam preparation.

Who this course is for

  • BI architects who design reporting and data platforms
  • BI developers who build ETL and reports
  • Data analysts who want to understand the full BI stack
  • IT professionals working on BI projects
  • Database administrators moving into BI work
  • Report developers who want to plan the systems behind their reports

Before you start

This course is aimed at people who already work with SQL Server. You should be at ease with databases, basic queries and reports. Taking the Microsoft 70-466 course on data models and reports first will help. Experience with SQL Server Integration Services or Reporting Services is useful but not required, as the course covers both. Plan time to practise in SQL Server Data Tools as you go.

About the 70-467 exam

The 70-467 exam, Designing Business Intelligence Solutions with Microsoft SQL Server, was issued by Microsoft as part of the MCSE: Business Intelligence track. It tested your ability to plan BI infrastructure, reporting, data models and ETL. Microsoft has retired the 70-series exams, so you can no longer sit this exam. The design skills still apply to SQL Server BI work today.

Jobs this course supports

  • BI Architect
  • Business Intelligence Developer
  • Data Analyst
  • BI Consultant

Skill level

Advanced
Duration

19 Hours 56 Minutes
Videos

48 Course Videos
Questions

43 Test Questions
Certification

Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
Exam code

70-467
Certification body

Microsoft
Prerequisites

Working knowledge of SQL Server databases and reporting. The 70-466 course is a good first step.
Best for

BI architects, BI developers, data analysts, database professionals
Topics covered

BI infrastructure and data warehouses, ETL and SSIS, Power Pivot and semantic models, SQL Server Data Tools, Report Builder and reporting, Drill-through reports and data visuals, SQL Server 2014 features
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

8 modules and 48 lessons. Here is the full outline.

Module 1: Intro To Business Intelligence8 lessons
  1. Introduction
  2. The Business Intelligence Solution
  3. Overview Of Business Intelligence
  4. BI And Power Pivot Demo
  5. ETL Intro
  6. Designing Data Warehouses
  7. Design For Speed
  8. BI Semantic Model
Module 2: Database Essentials8 lessons
  1. Basic Database Objects Demo
  2. Stored Procedures And Triggers Demo
  3. Database Clusters Demo
  4. SQL Server Management
  5. Table Triggers
  6. DB Config Options
  7. DB Backup
  8. DB Files And Restore
Module 3: Business Intelligence Development3 lessons
  1. Using SQL Server Data Tools Demo
  2. Building An IS Integration Services Package Demo
  3. Loading Data From Remote Sources Demo
Module 4: Business Intelligence Results7 lessons
  1. Report Building Intro Setup Demo
  2. Using Report Builder Demo
  3. Processing Data From Web Service Demo
  4. Reporting From Multiple Tables Demo
  5. Report Function And Matrix Demo
  6. Interactive Reports Demo
  7. Sorting Report Data Demo
Module 5: Advanced Reporting And Development4 lessons
  1. Drill Through Reports
  2. Data Visualization
  3. Creating Store Procedure From Scratch
  4. Memory Optimize Table
Module 6: SQL Server Integration Services (SSIS)7 lessons
  1. Building Our First Integration Project
  2. Data Transformation
  3. Introduction To Big Data
  4. Transformation Using Store Procedure
  5. Transformation Using SSIS
  6. Building Fact Table Using Store Procedure
  7. Building Fact Table Using SSIS
Module 7: SQL Server 2014 New Features5 lessons
  1. Backup Enhancements
  2. Index Enhancements
  3. Online DB Enhancements
  4. BackUp To The Cloud
  5. Partition Data
Module 8: Course Review And Exam Prep6 lessons
  1. BI Review
  2. SharePoint Overview
  3. SharePoint Demo
  4. Exam Prep
  5. Before You Take The Exam
  6. Conclusion

Your learning path

Where Microsoft 70-467 - Designing Business Intelligence Solutions with SQL Server fits. Build your skills one step at a time.

Take firstMicrosoft 70-463: Implementing a Data Warehouse with SQL ServerTake firstMicrosoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
You are hereMicrosoft 70-467 - Designing Business Intelligence Solutions with SQL Server
Next stepMicrosoft 70-466: Implementing Data Models & Reports with SQL Server

Frequently asked questions

Can I still take the Microsoft 70-467 exam?

No. Microsoft retired the 70-series exams linked to MCSA and MCSE. The course still teaches useful SQL Server BI design skills.

What is ETL?

ETL stands for extract, transform and load. It is how data is pulled from sources, cleaned and loaded into a data warehouse. The course covers it with SQL Server Integration Services.

Does this course cover SSIS?

Yes. A full module covers SQL Server Integration Services, including projects, data transformation and loading fact tables.

Should I take 70-466 before 70-467?

Yes, if you can. 70-466 teaches you to build data models and reports. 70-467 builds on that with full BI solution design.

Does the course cover newer SQL Server versions?

Yes. One module looks at SQL Server 2014 features such as cloud backups, index changes and partitioning.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course