Microsoft 70-466: Implementing Data Models & Reports - ITU Online
JULY SITEWIDE DEALS | UP TO 50% Off
Get Lifetime Training At 60% Off

Future proof your IT career with our LIFETIME IT training option.  Start today with over 2,500 hours of focused IT training.  Plus, you’ll receive all new and updated content for life at no additional cost.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

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.

Included In This Course

Included In This Course

Total Hours
12  Training Hours
Microsoft 70-466: Implementing Data Models & Reports
47 On-demand Videos
Closed Caption

Closed Captions

Course Topics
17  Topics
Prep Questions
42 Prep Questions
Microsoft 70-466: Implementing Data Models & Reports

Certificate of Completion

Course Description

Note: Although the associated examination for this course has been retired, it is a good resource for training.

This course prepares students for the Microsoft 70-466: Implementing Data Models & Reports with SQL Server exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.

The exam measures your ability to accomplish the technical tasks listed below.

  • Build an analysis services multidimensional database (35-40%)
  • Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database (15-20%)
  • Build a tabular data model (15-20%)
  • Build a report with SQL Server Reporting Services (SSRS) (25-30%)

Frequently Asked Questions About Microsoft 70-466: Implementing Data Models & Reports

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

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 Course Content

Module 1: 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

Module 2: 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

Module 3: Supporting Self Service Reporting

  •    Supporting Self Service Reporting Part 1

  •    Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution And Delivery

  •    Managing Report Execution And Delivery

  •    Managing Report Execution

  •    Subscriptions And Data Alerts

Module 5: Creating Multidimensional Databases

  •    Creating Multidimensional Databases

  •    Creating Data Sources And Data Source Views

  •    Creating And Browsing a Cube

Module 6: Working With Cubes And Dimensions

  •    Working with Cubes And Dimensions

  •    Sorting And Grouping Attributes

Module 7: Working With Measures And Measure Groups

  •    Working With Measures and Measure Groups

Module 8: Introduction To MDX

  •    Introduction To MDX

  •    Adding Calculations To A Cube

Module 9: Customizing Cube Functionality

  •    Customizing Cube Functionality Part 1

  •    Customizing Cube Functionality Part 2

  •    Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

  •    Implementing A Tabular Data Model Part 1

  •    Implementing A Tabular Data Model Part 2

Module 11: Introduction To DAX

  •    Introduction to DAX

  •    Demonstration Making A Tabular Model Part 1

  •    Demonstration Making A Tabular Model Part 2

  •    Using DAX

Module 12: Implementing An Analysis Services 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

Module 13: SQL Analysis Services

  •    SQL Analysis Services Part 1

  •    SQL Analysis Services Part 2

Module 14: Creating Data Visualizations With Power View

  •    Creating Data Visualizations With Power View

Module 15: Supporting Self Service Reporting

  •    Supporting Self Service Reporting

Module 16: Performing Predictive Analysis With Data Mining

  •    Performing Predictive Analysis With Data Mining

  •    Using The Data Mining Wizard

Module 17: Predictive Analytics

  •    Predictive Analytics Part 1

  •    Predictive Analytics Part 2

Add a review
Microsoft 70-466: Implementing Data Models & Reports Microsoft 70-466: Implementing Data Models & Reports
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required
4.8
Based on 57 reviews
5 star
79
79%
4 star
21
21%
3 star
0%
2 star
0%
1 star
0%
1-5 of 57 reviews
  1. I’ve enjoyed the training so far. Wish it was more focused on Linux like other training, but still good.

  2. So far all is good

  3. I have signed up for a lot of your courses so it will take me time to get through them all but I am so pleased with what I have already started with. THANK YOU!

  4. Great Assistance. Thank you

Microsoft 70-466: Implementing Data Models & Reports
 

$49.00

OR

Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-466: Implementing Data Models & Reports

Microsoft 70-466: Implementing Data Models & Reports with SQL Server
Microsoft 70-466: Implementing Data Models & Reports
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Learn Python programming with ITU Online. Get hands-on experience with real-world projects and become proficient in Python. Enroll now!

Python, which has been around for nearly three decades, is one of the most widely used programming languages in existence. This Python programming course is particularly helpful to data scientists and machine learning professionals, Python stands out due to its ease-of-use – it’s no wonder that universities now make it their go-to language when teaching coding.

$49.00

Become a Microsoft Certified Database Designer! Learn Microsoft 70-465: Designing Database Solutions for SQL Server with ITU’s comprehensive online course.

In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. You will learn how to create plans and designs for database structure, storage, objects, and servers.

$49.00

Boost your career with our comprehensive Microsoft 70-487 online course on developing Azure and web services.

In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services.