Microsoft 70-467 – Designing Business Intelligence

In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.


With internship




Without internship



this course includes

19 Training Hours

47 On-demand Videos

Closed Captions

8 Topics

43 Prep Questions

Certificate of Completion

What you’ll


Intro To Business Intelligence


Database Essentials


Business Intelligence Development


Business Intelligence Results


Advanced Reporting And Development


SQL Server Integration Services (SSIS)


SQL Server 2014 New Features


Course Review And Exam Prep

Course Description

The Microsoft 70-467 course, focusing on Designing Business Intelligence Solutions with SQL Server 2012, offers a comprehensive learning experience for BI architects and aspiring professionals. This course meticulously covers the essentials of BI infrastructure planning, reporting solution design, and the development of BI data models. You’ll gain hands-on expertise in leveraging SQL Server 2012 BI tools, ensuring you are well-equipped to create robust BI solutions.


Intro To Business Intelligence

The Business Intelligence Solution
Overview Of Business Intelligence
BI And Power Pivot Demo
ETL Intro
Designing Data Warehouses
Design For Speed
BI Semantic Model

Database Essentials

Basic Database Objects Demo
Stored Procedures And Triggers Demo
Database Clusters Demo
SQL Server Management
Table Triggers
DB Config Options
DB Backup
DB Files And Restore

Business Intelligence Development

Using SQL Server Data Tools Demo
Building An IS Integration Services Package Demo
Loading Data From Remote Sources Demo

Business Intelligence Results

Report Building Intro Setup Demo
Using Report Builder Demo
Processing Data From Web Service Demo
Reporting From Multiple Tables Demo
Report Function And Matrix Demo
Interactive Reports Demo
Sorting Report Data Demo

Advanced Reporting And Development

Drill Through Reports
Data Visualization
Creating Store Procedure From Scratch
Memory Optimize Table

SQL Server Integration Services (SSIS)

Building Our First Integration Project
Data Transformation
Introduction To Big Data
Transformation Using Store Procedure
Transformation Using SSIS
Building Fact Table Using Store Procedure
Building Fact Table Using SSIS

SQL Server 2014 New Features

Backup Enhancements
Index Enhancements
Online DB Enhancements
BackUp To The Cloud
Partition Data

Course Review And Exam Prep

BI Review
SharePoint Overview
SharePoint Demo
Exam Prep
Before You Take The Exam

Why become a Cybersecurity Engineer?

Growing Demand for Cybersecurity Professionals

The field of cybersecurity is experiencing rapid growth, driven by the escalating number and complexity of cyber threats. Both public and private sectors are investing heavily in cybersecurity measures to protect sensitive information and secure critical infrastructure. This increased investment has created a substantial demand for cybersecurity professionals, and the job market is teeming with opportunities. By becoming a cybersecurity engineer, you position yourself at the forefront of a booming industry with a multitude of career prospects.

Lucrative Salaries and Career Advancement

Cybersecurity professionals are highly sought after, and as a result, they enjoy attractive salaries and excellent benefits. The specialized skills and expertise required in this field command a premium in the job market. Furthermore, as you gain experience and demonstrate your capabilities, the potential for career advancement becomes significant. Cybersecurity engineers can progress to leadership positions, such as Chief Information Security Officer (CISO), and take on strategic roles in shaping an organization's security posture.

Global Relevance and Job Security

Cybersecurity is a global concern affecting organizations of all sizes and industries worldwide. The need for cybersecurity professionals extends beyond borders, making it a globally relevant field. By becoming a cybersecurity engineer, you equip yourself with skills that are in demand not only locally but also internationally. Job security in the field of cybersecurity is robust, as the increasing threat landscape ensures a constant need for skilled professionals to protect against attacks and mitigate risks.

Continuous Learning and Growth

The field of UX/UI design is dynamic and ever-evolving. To stay competitive, designers need to keep learning and adapting to new technologies and design trends. This continuous learning keeps the work interesting and provides opportunities for personal and professional growth.

Opportunities for growth

As software testers gain experience and develop their skills, they can take on more challenging roles and responsibilities. This can lead to promotions and career advancement opportunities. Most Manual testers progress to QA automation, Software development, DevOps, or Cloud Engineering.

Our Talents Work Here

Our talentstories

We connect learners with peers and experts from around the world, facilitating networking and collaboration opportunities.

IBT Training's DevOps course provided a comprehensive and insightful learning experience with valuable hands-on exercises. While the internship placement was beneficial, additional guidance could enhance the overall transition. Overall, IBT Training lays a solid foundation for entering the DevOps field.

Olaniyan Olatunde Kubernetes Admin, Microsoft

Enrolling in this course proved career-defining, offering invaluable knowledge and a guaranteed internship. It set me on a path to success, delivering everything promised—free certification, ongoing learning, and the ability to pass my sec+ on the first try.

Solomon Awuku Cybersecurity Analyst, Tek Computers

Upon completing the class, I felt confident and prepared to embark on a career in cybersecurity. The skills and knowledge I acquired have already proven invaluable, as I find myself better equipped to tackle real-world challenges and contribute to the protection of digital assets.


"IBT Learning is an outstanding tech school, with experienced teachers. Graduates gain hands-on experience with management tools such as Git, Maven, Nexus, SonarQube, Ansible, Docker for microservices, Kubernetes for container orchestration, and Terraform for Infras as Code"

Landric N DevOps Engineer, Transportation Insight

Your Questions, Answered

What’s the deal with this Microsoft 70-467 course?

So, this course is all about helping you understand how to plan and design a business intelligence (BI) infrastructure using Microsoft SQL Server 2012. It’s going to cover a lot of ground – things like designing a reporting solution, creating BI data models, and designing an ETL solution. Just remember, even though the exam associated with this course has been retired, it’s still a really solid resource for training.

What’s the structure of the course?

The course packs a punch in 19 training hours. It’s made up of 47 videos covering 8 different topics. Plus, you get to test your knowledge with 43 practice questions​.

I’m busy during the day, can I access the course anytime I want?

Absolutely! With the All Access Monthly Subscription, you can dive into this course and over 2,500 hours of on-demand content whenever you like. You also get a 7-day free trial to see if it suits you. And don’t worry, there’s no obligation – you can cancel anytime.

What if I’m a total beginner in IT? Is this course right for me?

This course is part of a bigger library that includes training for different levels and fields, like CompTIA, Cybersecurity, Project Management, Cisco, Microsoft, Adobe, Microsoft SQL, Azure, Amazon Web Services, and Cloud Services. So, whether you’re starting out or looking to deepen your knowledge, there’s a range of courses to choose from.

Are the instructors experienced in their field?

You bet! All instructors have a minimum of 10 years of experience in their respective fields and are recognized as experts. So you’ll be learning from the best in the biz.

I’m always on the go. Can I access the course on my mobile device?

Absolutely! The platform is designed to offer flexible learning options. You can learn anywhere at any time on your desktop, tablet, or mobile. All you need is an internet connection and you’re good to go.