Training Courses

These training courses are available to be delivered onsite, in a classroom setting, or remotely via live, interactive conference sessions.  Courses include lab exercise materials and setup guides, presentation materials and hand-outs, demonstrations and reference materials.  Most course formats can be adapted to a minimum or maximum number of days, and to match the experience and skill level of participants.  Training may be blended with consulting or mentoring, and may be adapted to match development project objectives.  Labs and demos are based on sample data sets and files.  Cost include an hourly instructor rate, material costs per student and travel expenses if delivered onsite.

Mastering Power BI Solutions

Adaptable course length and skill level:
1-4 days; beginning, intermediate and advanced levels

The length of the non-adapted course is 3 days and is taught at an intermediate skill level.  Students should have some entry-level experience with database concepts, reports and using Excel.  The course addresses the needs of self-service BI practitioners, IT professionals, administrator and data analysts.  Optional materials are available to focus on the Business Data Analyst and IT Professional roles; and Beginner, Intermediate and Advanced skill levels and experience.  Course covers the current version of Power BI and Power BI Desktop (material is update every 2-3 months).

Course modules:

00-Course Introduction
00-Lab setup
01-Business Analytics
02-Getting and Cleansing Data
02-Lab: Get & Transform Data
03-Modeling Essentials
03-Lab: Modeling Essentials
04-Quick Analytics
05-Calculation Basics
06-Visualizing and Analyzing Information
06-Lab: Visualizing & Analyzing
07-Publishing Sharing Distributing and Mobile
08-Architecting Business Solutions
09-Advanced Data Transformation
09-Lab: Advanced Transformations
10-Advanced Data Modeling
11-Advanced Calculations DAX
11-Lab: Financial Models & Calculations
12-Advanced Visualization
13-Advanced Analytics
14-Administration & Security
15-Bring Your Own Data Business Case Deep Dive
16-Review & Next Steps

 

Mastering Reporting Services 2016 Solutions

Adaptable course length and skill level:
2-4 days; beginning, intermediate and advanced levels

The length of the non-adapted course is 3 days and is taught at a beginning to intermediate skill level.  Students should have some entry-level experience with database concepts.  The course covers the features of the SQL Server 2016 and 2017 Reporting Services (these product versions are ~80% similar to SQL Server 2008R2, 2012 & 2014) and, optionally, Power BI Report Server.

Course modules:

01-Microsoft Reporting Tools and BI Solutions
02-Self-service Reporting with SSRS
03-Getting Started with Report Solutions and What’s New in SSRS 2016-2017
04-Basic Report Design
04-Lab: Report Design Essentials
05-Grouping and Totals
05-Lab: Authoring Report Datasets
06-Adanced and Analytic Reporting
06-Lab: Grouping and Totals
07-Graphical Report Design
07-Lab: Graphical Report Design
08-Advanced Queries and Parameters
08-Lab: Advanced Queries and Parameters
09-Reporting with Analysis Services
09-Lab: Reporting with Analysis Services
10-Expressions and Actions
10-Lab: Expressions and Report Templates
11-Solution Patterns
11-Lab: Report Solutions Patterns and Recipes
12-Mobile Report Solutions
12-Lab: Implementing a Mobile Report with Design First Development
13-Mobile Report Design Patterns
13-Lab: Mobile Report Design Patterns
14-Advanced Mobile Report Solutions
14-Lab: Advanced Mobile Report Solutions
15-Reporting Services Custom Programming
16-Administrating Reporting Services

Additional Training Topics

Dimensional Modeling with SQL Server

SQL Server Analysis Services solution design and development
(Tabular and Multidimensional)

Business Intelligence and Analytics Solutions and Design Approaches