Self-paced

Microsoft 70-466: Implementing Data Models & Reports

In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

With internship

$674

$1099

or

Without internship

$79

$299

this course includes

12 Training Hours

47 On-demand Videos

Closed Captions

17 Topics

42 Prep Questions

Certificate of Completion

What you’ll
learn

01

Introduction To Business Intelligence And Data Modeling

02

Implementing Reports The SQL Server Reporting Services

03

Supporting Self Service Reporting

04

Managing Report Execution And Delivery

05

Creating Multidimensional Databases

06

Working With Cubes And Dimensions

07

Working With Measures And Measure Groups

08

Introduction To MDX

09

Customizing Cube Functionality

10

Implementing A Tabular Data Model

11

Introduction To DAX

12

Implementing An Analysis Services Tabular Data Model

13

SQL Analysis Services

14

Creating Data Visualizations With Power View

15

Supporting Self Service Reporting

16

Performing Predictive Analysis With Data Mining

17

Predictive Analytics

Transform Your Career with Advanced BI Skills

Engaging with this course propels your career forward by equipping you with in-demand BI skills. As businesses increasingly rely on data-driven strategies, your ability to implement multidimensional and tabular data models becomes a significant asset. Mastering Microsoft SQL Server Reporting Services empowers you to generate insightful reports, elevating your professional value. Additionally, learning to create dashboards with Microsoft SharePoint Server PerformancePoint Services enhances your capacity to present complex data in an accessible and impactful manner. These skills not only make you an invaluable asset to any data-focused team but also broaden your career opportunities in the rapidly evolving field of BI.

 

course CURRICULUM

Introduction To Business Intelligence And Data Modeling

Introduction To Business Intelligence and Data Modeling Part1
Introduction To Business Intelligence and Data Modeling Part2
The Microsoft Business Intelligence Platform Part 1
The Microsoft Business Intelligence Platform Part 2
The Microsoft Business Intelligence Platform Part 3
The Microsoft Business Intelligence Platform Part 4

Implementing Reports The SQL Server Reporting Services

Implementing Reports the SQL Server Reporting Services Part 1
Implementing Reports the SQL Server Reporting Services Part 2
Implementing Reports the SQL Server Reporting Services Part 3
Implementing Reports the SQL Server Reporting Services Part 4
Implementing Reports the SQL Server Reporting Services Part 5
Implementing Reports the SQL Server Reporting Services Part 6
Implementing Reports the SQL Server Reporting Services Part 7
Implementing Reports the SQL Server Reporting Services Part 8

Supporting Self Service Reporting

Supporting Self Service Reporting Part 1
Supporting Self Service Reporting Part 2

Managing Report Execution And Delivery

Managing Report Execution And Delivery
Managing Report Execution
Subscriptions And Data Alerts

Creating Multidimensional Databases

Creating Multidimensional Databases
Creating Data Sources And Data Source Views
Creating And Browsing a Cube

Working With Cubes And Dimensions

Working with Cubes And Dimensions
Sorting And Grouping Attributes

Working With Measures And Measure Groups

Working With Measures and Measure Groups

Introduction To MDX

Introduction To MDX
Adding Calculations To A Cube

Customizing Cube Functionality

Customizing Cube Functionality Part 1
Customizing Cube Functionality Part 2
Customizing Cube Functionality Part 3

Implementing A Tabular Data Model

Implementing An Analysis Services Tabular Data Model Part 1
Implementing An Analysis Services Tabular Data Model Part 2
Deploying A Tabular Data Model

SQL Analysis Services

SQL Analysis Services Part 1
SQL Analysis Services Part 2

Creating Data Visualizations With Power View

Creating Data Visualizations With Power View

Supporting Self Service Reporting

Supporting Self Service Reporting

Performing Predictive Analysis With Data Mining

Performing Predictive Analysis With Data Mining
Using The Data Mining Wizard

Predictive Analytics

Predictive Analytics Part 1
Predictive Analytics Part 2

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
ti.webp
unicard_ltd_logo.jpeg
onecall.png
ibm.png
Fourth_new-logo-e1678350336847.png

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.

Raymond A. CYBERSECURITY ANALYST BLUE CROSS

"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 will I learn in this course?

You’ll dive into creating managed enterprise BI solutions. The course covers implementing multidimensional and tabular data models, delivering reports with Microsoft SQL Server Reporting Services, creating dashboards with Microsoft SharePoint Server PerformancePoint Services, and discovering business insights by using data mining​.

How long is the course?

The course is approximately 10 hours in length. This is flexible though, as the course is self-paced, so you can learn at your own speed.

How do I access this course and what happens after my free trial

The course can be accessed with an All Access Monthly Subscription, which comes with 7 free days. If you wish to continue after your trial period, your subscription will kick in. Don’t worry though, you can cancel anytime if it’s not for you​

What’s the end goal of this course?

This course prepares you for the Microsoft 70-466: Implementing Data Models & Reports with SQL Server exam. It’s a great way to demonstrate your skills and become a Microsoft Certified Professional.

What topics are covered in the course?

The course covers a range of topics, including building an analysis services multidimensional database, managing, maintaining, and troubleshooting a SQL Server Analysis Services (SSAS) database, building a tabular data model, and building a report with SQL Server Reporting Services (SSRS)​.

How can I reach out if I have any questions or need support?

The ITU Online team is available to help! You can contact them via phone at +1 855.488.5327 or email at customerservice@ituonline.com from Monday to Friday, 9:00am – 5:00pm ET​.