Training
Enable Technology offer onsite bespoke training delivered at your premises. We can provide a detailed understanding of how the Microsoft BI Stack can be used to create data warehouse and reporting solutions.
We have particular expertise in combining Excel, VBA and SQL to create surprisingly powerful reporting solutions without the need for custom reporting software.
We will provide the equipment, teaching materials and all training is delivered by Microsoft Certified Experts (MCSE).
Enable Technology can offer on site delivery in the following two day Business Intelligence courses
- SQL
- Power BI
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- Crystal Reports
- Excel VBA
- Power Pivot
Please feel free to contact us if you would like to discuss either our standard on site courses or additional Business Intelligence training requirements.
SQL Course Content
Relational Databases
Tables
Rows
Columns
Relationships
Data types
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Simple SELECT Statements
Comments
Whitespace and Semi-colons
Case Sensitivity
Selecting All Columns in All Rows
Selecting Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Aggregate Functions
Grouping and Aggregating Data
Selecting Distinct Records
Common Math Functions
Common String Functions
Common Date Functions
Subqueries, Joins and Unions
Subqueries
Joins
Table Aliases
Multi-table Joins
Outer Joins
Conditional Processing with CASE
CASE syntax
Using CASE
Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE
Creating and Modifying Tables
Data Types
Creating Tables
NULL Values
Primary Keys
Foreign Keys
Creating Tables
Adding and Dropping Columns
Renaming Tables
Dropping Tables
Views
Creating Views
Dropping Views
Benefits of Views
Stored Procedures
Creating Stored Procedures
Dropping Stored Procedures
Benefits of Stored Procedures
SSRS Course Content
Introduction to SQL Server Reporting Services
Reporting Services Modes
Installing and Configuring Reporting Services
Reporting Services Architecture
Native Mode Architecture
Service Architecture
Report Building Tools
Report Builder vs. Report Designer
Build a Simple Report
Report Definition Language (RDL)
Creating a Customer Contact List
Creating Ad Hoc Reports With Report Builder
Introduction to Report Builder
Report Builder Installation and Execution Options
A Tour of the Report Builder Interface
Building a Report with Report Builder
Preview Performance
Using Report Parts
Shared Data Sets
Shared Data Sources
Shared Dataset Design View
Creating Ad Hoc Reports with Report Builder
Create a Data Source Connection
Create A Shared DataSet for Northwind
Create a Report Based on a Shared Data Set
Creating Reports With SQL Server Data Tools
Introducing SQL Server Data Tools
Installing SQL Server Data Tools
Report Project Types
Working with Report Server Projects
Report Project Files and Folders
Report Designer and Data Windows
Configuring Report Projects
Setting Report Project Properties
Report Project Configurations
Creating a New Report in the Report Designer
The Report Designer
Creating Reports with SQL Server Data Tools
Create and Configure a Report Server Project
Create Shared Data Sources and Data Sets
Create a Tabular Report
Using the Tablix Report Type
Exploring the Tablix Report Type
The Tablix Component
Tablix Cell Content and Scope
Building a Tablix Report
Creating a Shared Data Source and Data Sets
Building a Tabular Report
Building a Matrix Report
Building a List Report
Configuring Tablix Properties and Groups
The Tablix Properties Dialogue Box
No Data Rows
Groups before Row Headers
Synchronized Data Alignment
Using the Tablix Report Type
Create a Shared Data Source and Two Data Sets
Create a Matrix Report
Create a Form-Like Report from a list
Calculations Using Expressions And Functions
Writing and Using Report Expressions
Using the Expression Editor
Using Built-in Report Operators and Functions
Expression Operators
Built-in Functions
Null Handling
The Global Collections
Field Collection
Globals Collection
User Collection
Report Items Collection
Variable Collection
Globals Collection
Creating Custom Functions
Creating a Custom Age Function
Sharing Custom Code with Multiple Reports
Calculations Using Expressions and Functions
Overview
Rein in the Length of a Text Field
Create a Custom Function
Managing Page Layout and Adding Interactivity
Designing the Page Layout
Considering Report Layout Options
Page Structure Properties
Page Headers and Footers
Report Formatting Options
Formatting Text Boxes from the Toolbars
Formatting Text Boxes in the Properties Window
Formatting Text Boxes in the Text Box Properties Dialogue Box
Formatting Tablix Rows and Columns
Making Reports Interactive
Interactive Sorting
Drilldown Reports
Managing Page Layout and Adding Interactivity
Overview
Creating a Columnar Report
Create a Report with Interactive Sorting
Dynamic Reports with Parameters
Creating Report Parameters
Parameters and Stored Procedures
Using Parameters with Ad Hoc SQL
Using Unbound Parameters
Understanding Report And Data Set Parameters
Report Parameters
Data Set Parameters
Reordering Report Parameters
Using Drop-Down List Parameters
Providing a Drop-Down List for a Report Parameter
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Cascading Parameters
Multivalued Parameters
Dynamic Reports with Parameters
Create a Parameterised Report
Create a Drop-Down List Parameter
Work with Multivalued Parameters
Enhancing Reports with Data Visualisations
Using Charts in a Report
Formatting a Chart
Visualising Performance with Data Bars, Sparklines and Indicators
Data Bars
Sparkline
Indicators
Working with Maps and Spatial Data
Enhancing Reports with Data Visualisation
Create a Pie Chart with Point Labels
Create a Map Report
SSIS Course Content
SQL Server Integration Services Architecture
Version Changes of SSIS From 2008-2012
The SQL Server Integration Service
Understanding Packages
Managing with Control Flow
Moving Data with Data Flow
Understanding Variables
Understanding Parameters
SQL Server Integration Services Tools
Utilizing the Import/Export Wizard
Working in the Explore Window
Creating SQL Server Integration Services Packages
Utilizing Connection Managers
SQL Server Integration Services Tasks
Coding the Script Task
Looping and Sequence Tasks
Utilizing Data Preparation Tasks
Data Loading with the Analysis Services Tasks
Using the Workflow Tasks
Managing SQL with the SQL Tasks
Administration of SQL Using the SQL Management Objects Tasks
Data Flow
Optimizing Sources for Extraction
Using Destinations and Understanding choices
Examining the Transformation and Other Tasks
Variables, Parameters and Expressions
Creating Dynamic Packages
Utilizing SQL Server Integration Services Data Typing
Define and Use Variables and Parameters
Using Expressions in Packages
Containers
Overview of Containers
Utilizing Sequences in a Container
Utilizing Container Loops
Performing Joins
Performing Joins with the Lookup Transformation
Performing Joins with the Merge Transformation
Utilizing Cache Modes in Joins
Tuning SQL Server Integration Services Packages
Examining the SSIS Engine
Using the Best Practices
Debugging SQL Server Integration Services Packages
Designing to Troubleshoot: Using Precedence Constraints
Working with Advanced Logging and Reporting
Handling Errors
Common SQL Server Integration Services Design Patterns
Choosing the Script Task or Script Component
Working with XML
Using Package Hierarchies: Parent Child
Understanding Deployment Strategies
Crystal Reports Course Content
Creating a Simple Report
Starting the Crystal Reports Program
Starting a New Report
Choosing a Data Source
The Main Components of the Design Window
Exploring the Toolbars
Managing Resources with Explorers
Placing Fields on the Report
Selecting and Sizing Objects
Browsing Field Data
Moving and Aligning Objects
Using Guides and Guidelines to Move and Align Objects
Creating Text Objects
Saving the Report
Autosaving the Report
Previewing the Report
Refreshing the Data
Using the Status Bar
Getting Help
Formatting Features
Quick Formatting with the Template Expert
Formatting Objects
Format Painter
Inserting Lines and Boxes
Drawing a Line
Drawing a Box
Inserting Graphics
Working with the Page Commands
Working with Text Objects
Adding Fields into a Text Object
Formatting Part or All of an Object
Inserting Special Fields
Selecting Specific Records from the Database
Filter Types of the Select Expert
Database Filtering with the Select Expert
Selecting Records with Multiple Criteria
Viewing and Editing the Select Formula
Case Sensitive vs. Case Insensitive
Record Selection Formula Templates
Grouping and Sorting Data
When and Why to Group Records
Creating a Group
Group and Sort Direction
Customize Group Name Field
Modifying Groups
Creating Multiple Groups in a Report
Using the Preview Panel
Using the Group Tree to Navigate the Report
Reordering Groups
Sorting Records within a Group
Using the Sort Control
Summarizing Groups
Grouping Data in Date/Time Intervals
Calculating Percentages
Ordering Groups Based on Their Subtotals Using the Group Sort Expert
Combining Multiple Tables
Understanding Tables, Records, and Fields
Learning about Linking
Adding Multiple Tables to a Report
Creating and Using Formulas
Understanding Crystal Formula Syntax
Using the Formula Workshop
Using the Formula Editor
The Formula Editor Toolbar
Performing Simple Number Calculations
Manipulating Dates with Formulas
Creating Boolean (True/False) Formulas
Creating String Formulas
Using Bookmarks to Navigate Through Formulas
Conditional Formatting
Formatting Sections
Formatting Sections Conditionally
Conditionally Formatting Fields
Creating Summary Reports and Charts
Creating a Summary Report
Applying the Drill-Down Feature
Applying the Drill-Down Group Level
Producing Charts
Editing Charts
Formatting Charts
Using the Chart Options
Modifying Individual Objects in the Chart
Using the Chart Options
Modifying Individual Objects in the Chart
Applying Chart Templates
Exporting Your Reports
Understanding Export Formats and Destinations
Using the PDF Format for Crystal Reports
HTML Preview
Exporting to Windows Applications
Exporting to a Report Definition Format
Using the Report Wizards
Create a Report Using the Standard Report Creation Wizard
The Data Dialog Box
The Fields Dialog Box
The Grouping Dialog Box
The Summaries Dialog Box
The Group Sorting Dialog Box
The Chart Dialog Box
The Record Selection Dialog Box
The Template Dialog Box
Power Formatting
Using Multiple Sections in Reports
Using the Section Expert to Work with Sections
Using the Running Totals Feature
Understanding Running Totals
Creating Running Totals for a List of Numbers
Conditional Running Totals
Prompting with Parameters
Parameter Fields Overview
Parameter Field Considerations
Creating a Parameter Field
Using a Parameter to Select Records
Using a Parameter Field
Using the Parameter Panel
Creating a Dynamic Value List
Importing a Pick List
Adding Parameter Values to Text Objects
Allowing Multiple Values in Parameters
Using Multiple Parameter Fields in Reports
Specifying and Limiting a Range for a Parameter
Using Parameters in Conditional Formatting
Using an Edit Mask to Limit String Parameters
Sorting with a Parameter
Group Sorting with a Parameter
Using a Parameter to set N in a Top N or Bottom N report
Displaying Parameter Fields
Cascading Parameter Fields
Using Advanced Formula Features
Understanding How Crystal Reports Processes the Data
Using Evaluation Time Functions
Working with Variables
Declaring a Variable
Variable Scope
Separating Statements in Complex Formulas
Working with Arrays
Understanding the Formula Evaluation
Subreports
Understanding Subreports
Unlinked versus Linked Subreports
Creating an Unlinked Subreport
Linking a Subreport
Formatting the Subreport
Passing Data from the main Report into a Subreport
Creating on-demand Subreports
Creating Hyperlinks
Creating Powerful Groups
Creating Custom Groups
Customizing Group Sort Order
Using Group Selection to Filter the Records in the Report
Grouping on a Formula Field
Grouping Hierarchically
Working with Cross-Tab Reports
Understanding How Cross-Tabs Affect Your Data
Creating a Cross-Tab Report
Crating a Cross-Tab with Multiple Rows or Columns
Applying a Formatting Style to the Cross-Tab
Customizing the Cross-Tab Format
Changing the Summary Operation
Charting Cross Tabs
Customizing Cross-Tab Group Names
Report Alerts
Creating Report Alerts
Basing Report Formulas or Conditional Formatting on Report Alerts
Creative Usage for Report Alerts
VBA Course Content
Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor
Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables
Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures
Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code
Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar
Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions
Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
Power BI Course Content
Introducing Power BI
The Power BI Interface
Overview of the Power BI Data Model.
Using Power BI
Connecting to Power BI data
Create a Power BI dashboard
Using Excel as a data source for Power BI
Using databases as a data source for Power BI
Importing data into Power BI
Importing different data sources into Power BI
Viewing reports from Excel files
Shaping and Combining Data
Power BI desktop queries
Shape data using formatting and transformations.
Combine data together from tables in your dataset.
Modeling data
Create relationships between data tables.
Understand the DAX syntax and use DAX functions to enhance your dataset.
Create calculated columns, calculated tables and measures.
Interactive Data Visualisations
Creating Power BI reports
Managing a Power BI solution
Use Power Bi desktop to create interactive data visualisations.
Direct Connectivity
Direct connectivity from Power BI desktop
Direct connectivity from the Power BI service
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode.
The Developer API
The developer API
Custom visuals
Power BI mobile app
Using the Power BI mobile app
Power BI embedded
Power Pivot Course Content
Power View
Understanding Power View
Enabling Power View
Adding Power View to the Ribbon
Creating a Power View Sheet
Working With a Power View Object
Working With Power View Fields
Rearranging and Sorting Fields
Working With Measure Fields
Formatting Power View Data
Tiling Data in Power View
Filtering in Power View
Switching Visualisations
Adding More Power Views
Adding Titles and Images
Updating a Power View Report
Power Pivot
Understanding Power Pivot
Understanding Relational Data
Enabling Power Pivot
Connecting to a Data Source
Working With the Data Model
Working With Data Model Fields
Changing a Power Pivot View
Creating a Data Model PivotTable
Using Related Power Pivot Fields
Creating a Calculated Field
Creating a Concatenated Field
Formatting Data Model Fields
Using Calculated Fields
Creating a Timeline
Adding Slicers
Get & Transform
Understanding Get & Transform
Understanding the Navigator Pane
Creating a New Query From a File
Creating a New Query From the Web
Understanding the Query Editor
Displaying the Query Editor
Managing Data Columns
Reducing Data Rows
Adding a Data Column
Transforming Data
Editing Query Steps
Merging Queries
Working With Merged Queries
Saving and Sharing Queries
The Advanced Editor
Power Map
Understanding Power Map
Creating a Power Map Tour
Working With Location Fields
Working With Mapping Confidence
Working With Height and Category
Fields
Filtering Data
Navigating a Data Map
Changing the Look
Working With Layers
Working With Scenes
Working With Scene Options
Working With Time Settings
Viewing and Editing a Tour
Exporting a Tour as a Video