TRAINING COURSES WOLVERHAMPTON
About Enable Technology Wolverhampton Training Courses
We offer intensive two and three days courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the onsite. Another option is we can organise a local socially distanced training site in Wolverhampton. We offer the option of working with you to develop a bespoke programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Homeserve PLC, Canadian High Commission, TalkTalk Direct Limited, Wolverhampton City Council, Boots UK Limited, Birmingham Heartlands Hospital, West Bromwich Building Society and Vodafone Group Services.
Excel 365 Advanced
- 1 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data. - Some of the training topics covered include ... Use Lookup Functions
- See Training Course Details...
Working with Multiple Worksheets and Workbooks
Use the Goal Seek Feature
Protect Worksheets and Workbooks Automating Workbook Functionality
Consolidate Data Sharing and Protecting Workbooks
Search for Invalid Data and Formulas with Errors
Determine Potential Outcomes Using Scenarios
Use 3-D References
Apply Data Validation
Watch and Evaluate Formulas Forecasting Data
Use Links and External References
Work with Macros Using Lookup Functions and Formula Auditing
Collaborate on a Workbook
Forecast Data Trends
Determine Potential Outcomes Using Data Tables
Trace Cells
Excel 365 Basic
- 1 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
In this course, you will learn fundamental Excel skills. You will:
Familiarize yourself with Excel's layout, its various parts, its commands, and its terminology.
Outline Excel's abilities to quickly, efficiently, and accurately calculate data.
Update worksheets without throwing away all of the valuable work you've already done.
Format a worksheet and organize your data.
Print workbooks.
Manage the overall structure of your workbooks. - Some of the training topics covered include ... Adjust Cells, Columns, and Rows
- See Training Course Details...
Apply Colors, Borders, and Styles
Manage Worksheets
Manage Workbook and Worksheet Views
Navigate the Excel User Interface
Apply Basic Conditional Formatting Printing Workbooks
Apply Text Formats
Set Up the Page Layout
Reuse Formulas and Functions Modifying a Worksheet
Configure Headers and Footers Managing Workbooks
Align Cell Contents
Navigate in Excel for the Web
Create and Save a Basic Workbook
Use Excel Commands
Enter Cell Data Performing Calculations
Use Proofing and Research Tools Formatting a Worksheet
Insert Functions
Manage Workbook Properties
Apply Number Formats
Search for and Replace Data
Getting Started with Excel
Excel 365 Intermediate
- 1 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts. - Some of the training topics covered include ... Apply Intermediate Conditional Formatting
- See Training Course Details...
Sort Data
Use Specialized Functions
Work with Logical Functions
Filter Data by Using Timelines and Slicers
Use Advanced Chart Features Using PivotTables and PivotCharts
Filter Data
Create and Modify Tables
Analyze PivotTable Data
Create a PivotTable
Present Data with PivotCharts
Work with Date and Time Functions
Query Data with Database Functions
Create Charts
Apply Advanced Conditional Formatting Visualizing Data with Charts
Modify and Format Charts
Working with Functions Work with Ranges
Work with Text Functions Working with Lists
Outline and Subtotal Data Analyzing Data
Excel Power Pivot
- 1 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
A one day course introducing candidates to Power View and Power Pivot Excel tools.
- Some of the training topics covered include ... Editing Query Steps
- See Training Course Details...
Enabling Power View
Merging Queries
Adding More Power Views
Using Related Power Pivot Fields
Working With Data Model Fields
Understanding Relational Data
Power Map
Adding Power View to the Ribbon
Creating a Power View Sheet
Adding Slicers Get & Transform
Working With the Data Model
Understanding the Query Editor
Working With Layers
Working With Height and Category
Navigating a Data Map
Transforming Data
Working With Merged Queries
Tiling Data in Power View
Excel Programming Using VBA
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
A two day Excel VBA programming course which introduces advanced Excel users to the process of writing and editing Macros. No prior programming experience is assumed.
- Some of the training topics covered include ... Creating a PivotTable Using Worksheet Data
- See Training Course Details...
Working with Variable Scope
Working with Forms and Controls
Assigning a Macro to the Quick Access Toolbar
Declaring and Using Object Variables
Using the If...End If Decision Structures
Working with the Text Box Control
Launching a Form in Code
Working with UserForm Properties, Events, and Methods
Setting Control Properties in the Properties Window
Working with the Label Control
Understanding Controls
Saving a Macro-Enabled Workbook
Working with Boolean Expressions
Understanding Objects
Understanding Errors
Writing an Error-Handling Routine
Understanding VBA's Error Trapping Options
JavaScript
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This introductory two day JavaScript training course aimed at Web Designers will enable participants to interpret, adapt and write their own JavaScript code.
No prior programming knowledge is assumed.- - Some of the training topics covered include ... JavaScript Operators
- See Training Course Details...
Methods
Validating Select Menus
Built-in Functions vs Methods
if - else if - else Conditions
Validating Checkboxes
Function Syntax
JavaScript Objects, Methods and Properties
Passing Values to Functions
isNaN(object)
Storing User-Entered Data
Working with Images
for Loop Syntax
Returning Values from Functions
Built-In JavaScript Objects
Variables, Arrays and Operators
JavaScript Form Validation
JavaScript Basics
JavaScript Variables
JQuery
- 3 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This intensive three day jQuery training course provides a comprehensive overview of the jQuery JavaScript library. Ideally candidates should have a working knowledge of HTML and CSS.
- Some of the training topics covered include ... Avoiding Conflicts with Other Libraries
- See Training Course Details...
Using RequireJS with jQuery
Conclusion
Inside the Event Handling Function
Don't Treat jQuery as a Black Box
Event Helpers
Custom Events-
Finding and Evaluating Plugins
CSS, Styling, and Dimensions
Managing Dependencies
Attributes
Increasing Performance with Event Delegation
Events-
Operations on Numbers and Strings
Data Methods
Dimensions
Creating New Elements
Convenience Methods
Basic Operators
JQuery Mobile
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course in which participants develop single sites for all popular smartphone, tablet, and desktop platforms. You'll learn how to use jQuery Mobile to handle touch events, build mobile-optimized forms and widgets, incorporate HTML5 features, leverage phone capabilities such as making calls and texting, and more. Along the way, we'll cover jQuery Mobile's extensive theme framework and plugin architecture.
Prior knowledge of HTML, CSS and JavaScript is required.
- Some of the training topics covered include ... Collapsible Blocks Events
- See Training Course Details...
Ajax-driven Page Navigation
Lists and Buttons
Dialogs
plugin Architecture
Sending SMS Texts
Overriding Themes with Custom CSS Plugins
Using Others' Plugins
Data-role
Overview
ThemeRoller
Dialogs Widgets and UI
Sending Emails
Hosting vs. CDN
Themes and Swatches
Microsoft Access
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
DIY Forms
Macro Techniques
Modifying Table Structures
Using a Navigation Form
Calculations in Queries
Importing and Exporting Records
Formatting Tables
Multi Table Queries
Navigation Pane Protection
Creating a Relational Database
Adding Transactional Records
Getting to Know Access
Action Queries
Designing a Lookup Database
Relational Database Design
Sorting and Filtering
Creating and Using Forms
Parameter Queries
Creating and Using Macros
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Locking Records for Updating
- See Training Course Details...
Working with Boolean Expressions
Using Expressions, Variables, and Intrinsic Functions
Using the If...End If Decision Structures
Guidelines for use of Branching Structures
Understanding Error Handling
Stepping through Code
Using Intrinsic Functions
Understanding the Order of Events
Working with the Application Object
Using Intrinsic Constants
Understanding Procedures
Using the Immediate Window to Call Procedures
Creating a Standard Module
Specifying a Recordset Cursor Location - Optional
Understanding the Form Object
Understanding Modules
Using the For...Next Structure
Using the CacheSize Property - Optional
Microsoft Excel Power Query
- 1 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.
Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.
- Some of the training topics covered include ... Combining Worksheets
- See Training Course Details...
Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
Grouping Options
Appending Operations
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Power Query Interface
Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Loading into Excel
Understand and utilize merges. LOADING YOUR DATA
Loading Data
Understanding the Issues
Using Ranges in Excel
Introduction to Power BI Desktop
Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
Working with Folders and Files
Importing Data
Understanding and Handling Special Situations
Understand working with relational data.
Using PivotTables CONNECTING TO DATABASES
Understand Power Query formulas.
Performing Merges
Microsoft Excel PowerPivot Data Analytic Expressions DAX Language
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.
Prior experience with Excel and Microsoft SQL query writing is useful.
- Some of the training topics covered include ... Utilizing Operators
- See Training Course Details...
Aggregation Functions
Using Multiple Calendars Utilising Advanced DAX Functionality
Mathematical Functions
Introduction to DAX
Logical Functions
Filter Functions
The CALCULATE Function
Text Functions
Understanding Values
Many-to-Many Relationships
Exploring Data Types
Relational Functions Understanding Evaluation Contexts
Handling Errors Using DAX Functions
Explaining Syntax
Multiple Table Evaluation Context Working with Dates
Introduction to DAX
Statistical Functions
Conversion Functions
Single Table Evaluation Context
Microsoft Power BI
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop.
- Some of the training topics covered include ... Create relationships between data tables.
- See Training Course Details...
Connecting to Power BI data
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
Power BI embedded
Understand the DAX syntax and use DAX functions to enhance your dataset.
Combine data together from tables in your dataset. Modeling data
Direct connectivity from Power BI desktop
Shape data using formatting and transformations.
Importing different data sources into Power BI
Power BI desktop queries
Create calculated columns, calculated tables and measures. Interactive Data Visualisations
The Power BI Interface
Using Excel as a data source for Power BI
Custom visuals Power BI mobile app
Overview of the Power BI Data Model. Using Power BI
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Using the Power BI mobile app
Viewing reports from Excel files Shaping and Combining Data
Direct connectivity from the Power BI service
Managing a Power BI solution
Creating Power BI reports
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.
- Some of the training topics covered include ... Deploy Model Solutions Using XMLA
- See Training Course Details...
Create Calculated Members
Cube or model permissions Process permissions
Configure Measure Group Properties
Deployment Requirements and Considerations for Analysis Services Deployment
Overview of SSAS Multidimensional Modelling
Define Time Intelligence
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Primary Keys in a Data Source View
Define Attribute Relationships
Test an Action
Dimension permissions
Move an Analysis Services Database
Use Aggregate Functions
Set Impersonation Options for a Data Source Connection
Define a Referenced Relationship and Referenced Relationship Properties
Defined Linked Measure Groups Partitions
Delete a Data Source View Dimensions
Change a Partition Source
Add a Standard Action
Backup and Restore of Analysis Services Databases
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) . The course is aimed at Data Analysts and SQL professionals. No prior knowledge of SSAS is assumed.
- Some of the training topics covered include ... Process Database, Table, or Partition
- See Training Course Details...
Hide or freeze columns
Manage Roles by using SSMS
Data types supported
Bi-directional cross filters Calculations
Analyze a tabular model in Excel Deploy tabular model solutions
Set the Data Type of a Column
Create and Manage Hierarchies Partitions
Create and Manage Roles
Create a New Tabular Model Project
Restore from Power Pivot
Database Process Partitions in the Workspace Database Perspectives
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import data by using a native query
Define partitions in DirectQuery models
Data sources supported in tabular 1200 models
Filter Data in a Table Relationships
Data sources supported in SSAS tabular 2017
Create and Manage Partitions in the Workspace
Data sources supported in tabular 1400 models
DAX formula compatibility in DirectQuery mode Tables and Columns
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This two day intensive course introduces SQL Server Integration Services. No prior knowledge of Integration Services is assumed.
- Some of the training topics covered include ... Using Expressions in Packages Containers
- See Training Course Details...
Utilizing Container Loops Performing Joins
Understanding Deployment Strategies
Understanding Packages
Utilizing the Import/Export Wizard
Working with Advanced Logging and Reporting
SQL Server Integration Services Architecture
Examining the SSIS Engine
Using Package Hierarchies: Parent Child
Moving Data with Data Flow
Choosing the Script Task or Script Component
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Creating Dynamic Packages
Working in the Explore Window
Overview of Containers
Utilizing Data Preparation Tasks
Utilizing Connection Managers SQL Server Integration Services Tasks
Looping and Sequence Tasks
Working with XML
Performing Joins with the Merge Transformation
Data Loading with the Analysis Services Tasks
Microsoft SQL Server Report Builder SSRS
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.
- Some of the training topics covered include ... Utilizing Lists
- See Training Course Details...
Visualizing Your Company Report Templates
SQL Server Report Builder Wizards
Understanding Report Parts
Formatting Reports
Understanding Variances Between SQL Versions
Examining Management
Understanding Visualizations
Examining Maps
Planning Your Reports
Filtering, Grouping, and Sorting
Mastering Data Region(s)
Utilizing Dynamic Headers and Footers
Working with Expressions
Introduction to SQL Server Report Builder
Utilizing Chart Wizard
Using the List Object to Combine Other Items
SQL Server Report Builder Advanced Reporting
Examining Parameters
Microsoft SQL Server Reporting Services SSRS
- 3 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.
- Some of the training topics covered include ... Report parameters
- See Training Course Details...
Introduction to reporting services
Create a report using report builder or report designer.
Reporting services tools Reporting Services Data Sources
Add a drillthrough to a custom URL
Topics include Introduction to Reporting Services
Using Datasets Creating Paginated Reports
Implementing report filters and parameters Visualizsng Data with Report Services
Use report services configuration manager to reconfigure SSRS servers.
Work with expressions and embedded code.
Extend reporting services functionality with external assemblies.
Formatting data
Report caching, snapshots, and comments
Secure access to reports by using authentication, permissions, and SSL encryption.
Data filters
Mobile report publisher
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Configuring data access with report builder
Databars, sparklines, indicators, gauges, and maps
Overview of mobile reports
Creating a report with the report wizard
Oracle PL/SQL
- 3 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.
- Some of the training topics covered include ... Subtypes
- See Training Course Details...
Using Nested TABLEs
REF CURSOR Variables
External LOBs
Nesting Blocks
Stored Functions and SQL
Stored Procedures and Functions
Beyond Declarative Integrity
Declaring and Opening Cursors
Associative Array Collections
SQLCODE and SQLERRM
Parameter Modes
Using VARRAYs
WHILE and FOR Loops
Exception Handlers
Stored Subprograms
Dependencies and Validation
Creating Packages
LOB Locators
Oracle SQL
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.
- Some of the training topics covered include ... Joining Tables
- See Training Course Details...
Oracle Pseudocolumns
The Aggregate Functions
Data Definition and Control Statements
Choosing Rows with the WHERE Clause
Updatable Views
Sample Database
Numeric Functions
Relational Database and SQL Overview
Other Database Objects
Scalar Functions
The UPDATE Statement
Logical and Physical Storage Structures
Tailoring Your SQL*Plus Environment
Introduction to SQL
The SELECT Statement
The SQL Buffer
SQL
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.
- Some of the training topics covered include ... Using the WHERE clause to check for greater or less than
- See Training Course Details...
Renaming Tables
Relational Database Management System
Simple SELECT Statements
Subqueries
Checking Multiple Conditions
Comments
Primary Keys
Table Aliases
Common Date Functions Subqueries, Joins and Unions
Sorting By Column Position
Selecting Distinct Records
Common String Functions
Checking for Equality
Tables
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.
The course requires a working knowledge of SQL.
- Some of the training topics covered include ... Configure MDS
- See Training Course Details...
Debug Package Execution Components
Introduction to Data Warehouses
Examine MSI Packages
Deploy SSIS Packages
Add Script Tasks and Script Components to an SSIS Package
Add Data Flow Components to a Data Flow Task
Overview of Data Warehouse Components
Deploy a Control Flow
Profile OLTP Data
Configure the Package Execution Strategy
Track Changed Data Managing Data Flow
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Perform Transformation Tasks
Create Package Templates Implementing Data Flow
Troubleshoot Package Failures Deploying Packages
Overview of Data Warehouses
Install Integration Services Working with Integration Services
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Create Dimensions
Transact SQL
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.
The course id practical, hands on and does not assume prior SQL or programming experience.
- Some of the training topics covered include ... Manage Views
- See Training Course Details...
Merge Data Working with SQL Server Built-in Functions
Work with Set Operators
Assign Aliases Using Queries
Work with T-SQL Statements
Sort the Queried Data
Modifying Data
Work with Data Access Technologies Implementing Stored Procedures
Work with String and Numeric Data Types
Group and Aggregate Data Programming in T-SQL
Create Queries to Test Nullability
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Variables and Batches
Overview of T-SQL
Work with System Databases
Work with Grouping Sets Managing Error Handling and Transactions
Configure Indexes
Getting Started with SQL Server 2012
Work with Date and Time Data Types
Work with Predicates
Configure User-Defined Functions (UDF)
Email us about this courses