Microsoft Course 10778 Implementing Data Models and Reports – SQL Server 2012 – in Cleveland, Ohio

Located in Beachwood off I-271, DeVore serves the Northeast Ohio Area, including Akron – Canton, Warren – Youngstown and Erie, Pa.

This course is the flagship Official Microsoft Business Intelligence class, covering all the Microsoft BI tools, with increasing emphasis on “self-service” BI. This class coveres SSRS (SQL Server Reporting Services), SSAS ( SQL Server Analysis Services), multi-dimensional cubes, self-service reporting, dimensions and measures, using MDX, tabular data models, PowerPivot, using DAX, crea

ting data visualizations with PowerView, predictive analysis with data mining, and creating interactive reports.

If your organization has data in Microsoft SQL Server, this is the fundamental training for tools and techniques for gaining business value from that data without the purchase of any additional products – it is all there, ready for you to use.

This training is appropriate for both the individuals who actually write reports hands-on, and the IT leaders who manage reporting areas and benefit from a clear picture of which tools are best under specific circumstances. ( and also need to know whether they should be pushing the organization forward on PowerPivot)

In addition, if your organization uses or is contemplating SharePoint, this training will cover how these tools integrate with SharePoint for corporate sponsored “self-service” BI.

There is a compelling business case for organizations using SQL Server now to use and understand the capabilities of the no additional cost Microsoft tools you already have, even to better understand whether you should consider other third-party products.

View DeVore’s LIVE – Instructor Led Class Schedule

What can you gain with Tableau? It is hard to measure if you do not have a solid grounding in the Microsoft tools you have now or are free add-ins.


Microsoft Learning thanks the following individuals who participated in the development of this training:

Graeme Malcolm – Lead Content Developer

Graeme Malcolm is a Microsoft SQL Server subject matter Content Master—a division of CM Group Ltd. As a Microsoft training courses on SQL Server since version 4.2; as an author, articles, and training courses on SQL Server; and as a consultant, business solutions based on SQL Server for customers all over

Geoff Allix – Content Developer

Geoff Allix is a Microsoft SQL Server subject matter expert Master—a division of CM Group Ltd. Geoff is a Microsoft Certified extensive experience in designing and implementing database technologies, and has provided consultancy services to organizations data warehousing and OLAP solutions.

Martin Ellis – Content Developer

Martin Ellis is a Microsoft SQL Server subject matter expert Master—a division of CM Group Ltd. Martin is a Microsoft an MCSE. He has been working with SQL Server since version Certified Trainer, and has developed a wide range of technical technology enterprises.

Chris Testa-O’Neill – Technical Reviewer

Chris Testa-O’Neill is a Senior Consultant at Coeo (www.coeo.Managed Support and Consulting in the UK and Europe. He Most Valuable Professional for SQL Server, and lead author Server 2008. Chris has spoken at a range of SQL Server events States. He is also one of the organizers of SQLBits, SQLServerFAQ You can contact Chris at , @ctesta_oneill

Course Content

This course will focus on the following topic areas:

  • Module 1, “Introduction to Business Intelligence and Data Modeling”
  • Module 2, “Implementing Reports with SQL Server Reporting Services”
  • Module 3, “Supporting Self Service Reporting”
  • Module 4, “Managing Report Execution and Delivery”
  • Module 5, “Creating Multidimensional Databases”
  • Module 6, “Working with Cubes and Dimensions”
  • Module 7, “Working with Measures and Measure Groups”
  • Module 8, “Introduction to MDX”
  • Module 9, “Customizing Cube Functionality”
  • Module 10, “Implementing a Tabular Data Model with Microsoft Module 11, “Introduction to DAX”
  • Module 12, “Implementing an Analysis Services Tabular Data Model”
  • Module 13, “Creating Data Visualizations with Power View”
  • Module 14, “Performing Predictive Analysis with Data Mining”

This course maps to the skills and knowledge measured by Microsoft Exam 70-466, Implementing Data Models and Reports with Microsoft SQL Server, and in conjunction with on-the-job experience, can help prepare you for the exam.

As a convenience to our customers, DeVore offers Information Technology Certification Testing. Microsoft tests are currently scheduled through both Pearson VUE and Prometric.

DeVore also offers the purchase of testing vouchers with a Purchase Order, credit card, company check or electronic payment as a convenience to our customers. Call the DeVore office with any questions.

To schedule this exam, visit Pearson VUE –

To read in detail what the exam covers, visit the Microsoft Learning site: