Processing...

Home > Implementing Data Models And Reports With Microsoft Sql Server (course #20466)

Microsoft Courses

Learnfast is a Microsoft Learning Partner. With the Learning Solutions Competency, we specialize in delivering high-end technical learning solutions to our customers. Earning this Competency identifies members of Microsoft premier commercial training and delivery channel, making it easier to expand the scope of services and market potential.

Contact Request


South Africa's largest short course provider

Implementing Data Models and Reports with Microsoft SQL Server (Course #20466)  

Overview

The focus of this 5-day instructor-led course is on creating managed enterprise BI solutions. It describes 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.

Prerequisites

This course requires that you meet the following pre-requisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping a

Course Outcomes

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution.
  • Create a multidimensional database with Analysis Services.
  • Implement dimensions in a cube.
  • Implement measures and measure groups in a cube.
  • Use MDX Syntax.
  • Customize a cube.
  • Implement a Tabular Data Model in SQL Server Analysis Services.
  • Use DAX to enhance a tabular model.
  • Create reports with Reporting Services.
  • Enhance reports with charts and parameters.
  • Manage report execution and delivery.
  • Implement a dashboard in SharePoint Server with PerformancePoint Services.
  • Use Data Mining for Predictive Analysis.

Price

R10250.00 per person Incl VAT

PLEASE NOTE: Learnfast serves a full lunch during break as well as coffee, tea and biscuits as part at no extra cost. We also cater for special meals.

Duration

5 Days (08:30 - 16:00)

Our myWay Learning Methods

Our innovative "myWay” learning methodology is built around the students individual learning requirement, allowing each student to learn in a style that is most suitable for their skills set, knowledge and schedule.

Instructor-Led Classes

Reach your full potential through our “myWay Instructor-Led” classes combined with interactive lessons, supporting video content, practical assignments and in field experience. We deliver instructor led classes full time, part-time, weekends and onsite.

Read More

Mentored Learning

The "myWay Mentored Learning” was created in response for more flexible learning schedules and focused content. It allows each student to progress in a manner that is most suitable for their skills set, knowledge and schedule that a fixed, lecture based approach does not allow for. You will be mentored on a one to one basis by a subject matter expert with continues practical exposure and focus on problem areas, allowing you to progress at your own pace and deciding what content requires more or less time.

Read More

Distance Learning

Do a course at your own pace via our “myWay Distance Learning”. We have re-defined studying via online by combining self-study with supported interactive online video lectures, extra resources, questionnaires and much more, all supported via out Online Student Portal. You will get a course coach and lecturer assigned to you so that you never feel alone and have support whenever you need. Your coach will look after you and your study health, encouraging you to progress constantly.

Read More

Testimonials

Important Notes

  • Students are to be at the training venue by 08h00 in preparation for a 08h30 start time.
  • Learnfast retains the right to change this calendar without any notification.
  • Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order for the full amount of the training.
  • For full day courses Learnfast will supply you with the relevant training material. A desktop computer to use for the training (where applicable), tea/coffee and a full lunch for full day InClass training hosted at Learnfast only. Catering is not included for OnSite training and laptop is available for hire at an additional cost if required.
  • Cancellation or rescheduling requests must be in writing and reach us via fax or email at least 5 (five) working days prior to the course commencement date. Full course fees may be retained for no shows or requests within 5 working days prior to commencement.
  • Although we go to great lengths to ensure that all training proceeds as scheduled, Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes.
  • Learnfast suggests clients wait until a week prior to course commencement that a course has been confirmed to go ahead as scheduled before booking flight and accommodation. Learnfast is NOT responsible for cost associated with cancellation of classes such as flight and accommodation for clients.

Module 1: Introduction to Business Intelligence and Data Modeling
As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution.
Lessons

  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Planning an Enterprise BI Project

Module 2: Creating Multidimensional Databases
This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube.
Lessons

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

Module 3: Working with Cubes and Dimensions
This module describes how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model.
Lessons

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Hierarchies 

Module 4: Working with Measures and Measure Groups
This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.
Lessons

  • Working with Measures
  • Working with Measure Groups 

Module 5: Introduction to MDX
This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.
Lessons

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube 

Module 6: Enhancing a Cube
This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.
Lessons

  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations 

Module 7: Implementing an Analysis Services Tabular Data Model
This module describes Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.
Lessons

  • Introduction to Analysis Services Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in the Enterprise 

Module 8: Introduction to DAX
This module explains the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models.
Lessons

  • DAX Fundamentals
  • Enhancing a Tabular Data Model with DAX

Module 9: Implementing Reports with SQL Server Reporting Services
This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.
Lessons

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publishing and Viewing a Report

Module 10: Enhancing Reports with SQL Server Reporting Services
This module describes how to enhance a SQL Server reporting Services report with charts and other visualizations, and how to use parameters to filter data in a report.
Lessons

  • Showing Data Graphically
  • Filtering Reports by Using Parameters 

Module 11: Managing Report Execution and Delivery
This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.
Lessons

  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services 

Module 12: Delivering BI with SharePoint PerformancePoint Services
This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.
Lessons

  • Introduction to SharePoint Server as a BI Platform
  • Introduction to PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards 

Module 13: Performing Predictive Analysis with Data Mining
This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports.
Lessons

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating a Data Mining Model
  • Consuming Data Mining Data
Campus
Book Now
Type
End Date
Start Date

Cape Town, Pinelands
myWay Mentored Learning
27 Jul 2018
23 Jul 2018

Cape Town, Pinelands
myWay Mentored Learning
24 Aug 2018
20 Aug 2018

Cape Town, Pinelands
myWay Mentored Learning
21 Sep 2018
17 Sep 2018

Cape Town, Pinelands
myWay Mentored Learning
26 Oct 2018
22 Oct 2018

Cape Town, Pinelands
myWay Mentored Learning
23 Nov 2018
19 Nov 2018

Cape Town, Pinelands
myWay Mentored Learning
07 Dec 2018
03 Dec 2018

Campus
Book Now
Type
End Date
Start Date

Centurion, Pretoria
myWay Mentored Learning
03 Aug 2018
30 Jul 2018

Centurion, Pretoria
myWay Mentored Learning
31 Aug 2018
27 Aug 2018

Centurion, Pretoria
myWay Mentored Learning
05 Oct 2018
01 Oct 2018

Centurion, Pretoria
myWay Mentored Learning
02 Nov 2018
29 Oct 2018

Centurion, Pretoria
myWay Mentored Learning
30 Nov 2018
26 Nov 2018

Campus
Book Now
Type
End Date
Start Date

Midrand, Johannesburg
myWay Mentored Learning
17 Aug 2018
13 Aug 2018

Midrand, Johannesburg
myWay Mentored Learning
14 Sep 2018
10 Sep 2018

Midrand, Johannesburg
myWay Mentored Learning
19 Oct 2018
15 Oct 2018

Midrand, Johannesburg
myWay Mentored Learning
16 Nov 2018
12 Nov 2018

Midrand, Johannesburg
myWay Mentored Learning
14 Dec 2018
10 Dec 2018


 In-Class    Onsite    Distance Learning