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 and may be adapted to match development project objectives.  Labs and demos are based on sample data sets and files.  Additional

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.  Covers the features of the SQL Server 2016 and 2017 Reporting Services (these product versions are ~80% similar to SQL Server 2008R2, 2012 & 2014).

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
05-Grouping and Totals
05-Lab
06-Adanced and Analytic Reporting
06-Lab
07-Graphical Report Design
07-Lab
08-Advanced Queries and Parameters
08-Lab
09-Reporting with Analysis Services
09-Lab
10-Expressions and Actions
10-Lab
11-Solution Patterns
12-Mobile Report Solutions
13-Mobile Report Design Patterns
13-Lab
14-Reporting Services Custom Programming
15-Administrating Reporting Services
15-Lab