Implementing Data Models and Reports with Microsoft SQL Server Training

Course Description

This five-day Implementing Data Models and Reports with Microsoft SQL Server training teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining.

Course Outcomes

At the end of the course, learners will be able to:

  • Use the Alteryx Designer interface to design data workflows.
  • Connect to a plethora of data sources and write into numerous output sources.
  • Clean and update your data and create useable datasets
  • Use your effort to create repeatable workflows
  • Filter, join, aggregate, blend and prep data.
  • Apply expression logic to data without writing SQL
  • Preparation for Alteryx Designer Core Exam

Course Summary

Next Public Course Dates

UK & Europe:

  • 2 - 6 October 2023
  • 16 - 20 October 2023
  • 4 - 8 December 2023

US & Canada:

  • 25 - 29 September 2023
  • 23 - 27 October 2023
  • 13 - 17 November 2023
  • None
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
  • This course is intended for database professionals who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions

Course Modules

  • Introduction to Business Intelligence and Data Modeling
  • Implementing Reports with SQL Server Reporting Services
  • Supporting Self Service Reporting
  • Managing Report Execution and Delivery
  • Creating Multidimensional Databases
  • Working with Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model with Microsoft PowerPivot
  • Introduction to DAX
  • Implementing an Analysis Services Tabular Data Model
  • Creating Data Visualizations with Power View
  • Performing Predictive Analysis with Data Mining

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

    To discuss your project requirements, send us a message

    For a free assessment, quick quote or training information, send us a message

    To book this course, please fill in your details and submit the form.

    To discuss your training requirements or book a class, drop us a line