Enable Technology

MIDLANDS TRAINING COURSES 

TRAINING COURSES MIDLANDS




ASP.NET Core MVC

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This course covers the fundamentals of the Model-View-Controller design pattern and its implementation in ASP.NET Core MVC. This technology is compared with classical ASP.NET Web Forms. Visual Studio 2017 with ASP.NET Core 2.0 is used as a productive platform for creating MVC Web applications. After presenting the fundamentals of the technology with several examples, the main components of Model, Controller and View are covered in detail. The discussion of the Model incorporates Microsoft technologies for persisting data, including XML Serialization and ADO.NET with SQL Server 2016. The routing mechanism of ASP.NET MVC is covered. The course includes an introduction to ASP.NET Web API.

    The student should have a prior knowledge of C# and the .NET Framework. Basic knowledge of HTML and some prior exposure to .NET Core would also be helpful.

  • Some of the training topics covered include ...
  • NuGet Package Manager
    Using XML Serialization
    Representational State Transfer
    Using Dynamic Objects
    Review of ASP.NET Web Forms
    ASP.NET Web API Clients ASP.NET Core and Azure
    Rendering Views
    Unit Testing Getting Started with ASP.NET Core MVC
    The View in ASP.NET MVC
    ASP.NET Core MVC Testbed
    Using ADO.NET The Controller
    Attribute Routing ASP.NET Core Web API
    Advantages and Disadvantages of Web Forms
    Registering Routes
    ASP.NET Core MVC
    Action Attributes
    Properties of Routes
    Retrieving Data from a Request
    Form Submission
    Html Helpers
    Using ViewBag

  • See Training Course Details...


ASP.NET using C#

  • 3 day course
  • Location: Midlands
  • Course Outline
  • This course provides practical, hands-on expertise on developing Web Applications using ASP.NET 4 and C#. Numerous programming examples and exercises are examined. A working knowledge of HTML is however assumed.

  • Some of the training topics covered include ...
  • Creating an XML Site Map File 
    Using the Simple Validators 
    LINQ Syntax 
    Introducing Cascading Style Sheets 
    Debugging Exceptions and Handling Errors 
    Client-side Code Debugging in ASP.NET 
    Overview of ADO.NET 
    CSS 
    Summarizing Results with the ValidationSummary Control 
    Working with Controls 
    Using the Site Navigation API 
    LINQ to XML 
    Introduction to Rich Controls 
    Using Visual Studio 2008's Tools for Working with Styles 
    Managing State 
    List Controls 
    Separating Validation into Validation Groups 
    Executing Commands 

  • See Training Course Details...


ASP.NET using VB.NET

  • 3 day course
  • Location: Midlands
  • Course Outline
  • This course provides a practical, hands-on overview of how to develop Web Applications using ASP.NET 4 and VB.NET. The course assumes a working knowledge of HTML and is suitable for anyone who wishes to use ASP.NET to develop dynamic web content.

  • Some of the training topics covered include ...
  • Working with Data 
    Using Cookies to Preserve State 
    Using Rich Server Controls 
    Using the Simple Validators 
    Data Binding 
    Allow Users to Select from a DropDownList in the Grid 
    Using the Site Navigation API 
    Summarizing Results with the ValidationSummary Control 
    Programming Configuration Files 
    Add a Hyperlink to the Grid 
    Connecting to Data 
    Client-Side and Advanced Debugging 
    Creating a Consistent Web Site 
    ASP.NET Web Applications 
    The AdRotator Control 
    Introducing Cascading Style Sheets 
    Master Pages 
    Displaying Data with the GridView Control 

  • See Training Course Details...


Crystal Reports 2008

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A  two day training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2008. No prior Crystal Reports experience is assumed.

  • Some of the training topics covered include ...
  • Using Multiple Sections in Reports
    Importing a Pick List
    Using the Sort Control 
    The Main Components of the Design 
    Suppressing Rows, Columns or Totals
    Power Formatting with Multiple Sections
    Applying a Formatting Style to the 
    Browsing Field Data 
    Selecting Specific Records from the Database 
    Modifying Groups 
    Previewing the Report 
    Chart 
    Formatting on Report Alerts
    Filter Types of the Select Expert 
    Calculating Percentages 
    Separating Statements in Complex 
    Exporting to a Report Definition Format
    Sorting Records within a Group 
    Customizing Group Sort Order
    Linking a Subreport

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting,grouping, linking, formula creation and parameters using the Crystal Reports 2011 release.

  • Some of the training topics covered include ...
  • Placing Fields on the Report 
    Creating a Group 
    Bottom N Report
    Creating Summary Reports and Charts 
    Using Parameters in Conditional 
    Exporting to Windows Applications 
    Basing Report Formulas or Conditional 
    Window 
    Parameter Fields Overview
    Using Alias Names for Column and Row Headings
    Applying the Drill Down Feature 
    Creating a Dynamic Value List for Parameter Values
    Understanding the Formula Evaluation 
    Selecting Specific Records from the Database 
    Expert 
    Combining Multiple Tables 
    The Main Components of the Design 
    Using Subreports to Link "Unlinkable" Data 

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using the Crystal Reports 2013. No prior knowledge of Crystal Reports is required.

  • Some of the training topics covered include ...
  • Crating a Cross-Tab with Multiple Rows or Columns
    Managing Resources with Explorers
    Using Multiple Parameter Fields in Reports
    Exporting to a Report Definition Format Using the Report Wizards
    Working with the Page Commands
    Using a Parameter to Select Records
    Grouping Hierarchically Working with Cross-Tab Reports
    Using the Chart Options
    Conditional Running Totals Prompting with Parameters
    Importing a Pick List
    Variable Scope
    Starting the Crystal Reports Program
    Using a Parameter to set N in a Top N or Bottom N report
    The Formula Editor Toolbar
    Create a Report Using the Standard Report Creation Wizard
    Understanding the Formula Evaluation Subreports
    Selecting and Sizing Objects
    Record Selection Formula Templates Grouping and Sorting Data
    Inserting Lines and Boxes
    Formatting Objects
    Declaring a Variable

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2016. No prior knowledge of Crystal Reports is required.

  • Some of the training topics covered include ...
  • Adding Multiple Tables to a Report Creating and Using Formulas
    HTML Preview
    The Template Dialog Box Power Formatting
    Modifying Groups
    Drawing a Line
    Group Sorting with a Parameter
    Choosing a Data Source
    Creating a Group
    Grouping on a Formula Field
    Using Group Selection to Filter the Records in the Report
    Selecting and Sizing Objects
    Variable Scope
    The Fields Dialog Box
    The Data Dialog Box
    Charting Cross Tabs
    The Group Sorting Dialog Box
    The Main Components of the Design  Window
    Applying the Drill-Down Group Level
    Cascading Parameter Fields Using Advanced Formula Features
    Passing Data from the main Report into a Subreport
    Refreshing the Data

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day comprehensive Crystal Reports XI trainingcourse will prepare participants to build and distribute complex reports whichinclude sorting, grouping, linking, formula creation and parameters.

    Crystal Reports training courses are also available in Crystal Reports versions8.0, 8.5, 9.0 and 10. 

  • Some of the training topics covered include ...
  • The Group Sorting Dialog Box
    Understanding How Crystal Reports Processes the Data
    Understanding Tables, Records, and Fields
    Manipulating Dates with Formulas
    Exploring the Toolbars
    Creating Your Own Templates
    Using Bookmarks to Navigate Through Formulas Conditional Formatting
    Using the Group Tree to Navigate the Report
    Organizing the Data for the Report
    Declaring a Variable
    Previewing the Report
    The Main Components of the Design Window
    Template Considerations
    Basing Report Formulas or Conditional Formatting on Report Alerts
    Understanding Running Totals
    Creating String Formulas
    Helpful Hints for Formatting the Report
    Understanding Crystal Formula Syntax without Being a Programmer
    Using Alias Names for Column and Row Headings
    Linking a Subreport
    Creating an Unlinked Subreport

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Midlands
  • Course Outline
  • This CSS3 course will expose students to new features in CSS3. Participants will learn how to use selectors and pseudo elements, font, color, and layout techniques; transforms, transitions, and animations. The course will explore how CSS media queries can be used to change how websites are presented on mobile devices.

  • Some of the training topics covered include ...
  • Transitions and Transforms
    Introducing CSS3
    What Are Vendor Prefixes
    Browser Support
    background-origin, and background-size Borders and Box Effects
    The @font-face Rule
    Preprocessors
    Attribute Selectors
    Embedding Media
    Flexible Box Model Vendor Prefixes
    The History of CSS
    Text Shadow
    Negation Pseudo-Class
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Rounded Corners
    The CSS3 Speech Module
    What is CSS3?
    Box Shadow Transitions, Transforms, and Animations
    Video Formats

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Midlands
  • Course Outline
  • This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals and  Project Managers interested in exploring the Microsoft toolsets for data mining, machine learning and predictive analytics. Participants will fully explore the potential of Excel PowerPivot and Excel Data Mining Add-ins used in  conjunction with Microsoft  SQL Server Analysis Services (SSAS).

  • Some of the training topics covered include ...
  • The Mining Model Prediction Tab
    The User Interface
    Concepts and Terminology
    Multiple Nested Tables Microsoft Data Mining Algorithms
    Microsoft Logistic Regression Algorithm
    Model Usage
    Data Preparation
    Topics include:
    Cross Validation
    CRISP-DM
    Microsoft Association Algorithm
    Data Mining and Results
    Named Calculation
    Named Queries
    Exploring Data
    Cross Validation
    Compare Mining Structures
    Connection
    Excel PowerPivot Data Mining Add-ins
    Offline Mode and Immediate Mode

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day intensive course will demonstrate how to use HTML5, CSS, JavaScript, and other tools to create websites which adapt their layout to the client device, whether it be a smartphone, tablet computer or desktop computer. The course assumes prior knowledge of HTML, CSS and some familiarity with SQL.

  • Some of the training topics covered include ...
  • Flexible Grids
    Using max-device-width
    The Flexible Grid: A More Responsive Layout Strategy
    HTML5: Mobile Specific
    Hosting Your Own Videos
    The Case for Flexible
    Framework: Foundation
    Gestures
    Controlling the Video through JavaScript
    Using the Accelerometer
    The Viewport
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    Linearizing the Layout
    Browser and Device Support
    Converting Video Formats
    A First Look at Foundation
    jQuery Mobile

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Modifying an Inserted Picture Data Linking
    Using a Subtotalled Worksheet
    Editing Worksheet Comments
    Creating Nested Subtotals
    Consolidating With Identical Layouts
    Using the DMIN Function
    Using Relative Names for Subtotals Data Consolidation
    Finding the Percentage of Total
    Creating a Two-Variable Data Table Scenarios
    Moving PivotCharts to Chart Sheets Advanced Filters
    Understanding How Controls Work
    Creating Scenarios
    Circling Invalid Data
    Working With a Protected Worksheet
    Merging Scenarios PivotTables
    Formatting PivotTable Values
    Importing Comma Delimited Text
    Setting Advanced Options Protecting Data
    Using One-Variable Data Tables
    Creating a Scenario Summary Report
    Adding a Spin Button Control

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one day course introducing Excel.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

  • Some of the training topics covered include ...
  • The Print Options Creating Charts
    Understanding Moving in Excel
    Using the Blank Workbook Template
    Saving a New Workbook on Your Computer
    Deleting a Chart Getting Help
    Formatting as Fractions
    Specifying the Number of Copies
    Opening an Existing Workbook
    The Excel Workbook Screen
    Changing Fonts
    Changing the Chart Style
    Horizontal Cell Alignment
    Finding a Maximum Value
    Previewing Before You Print
    Performing a Numerical Sort
    Understanding Number Formatting
    Editing Formulas
    Changing Background Colours
    Using the Format Painter Cell Alignment
    Copying From One Cell to Another
    What if Formulas

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Using IF With Numbers
    Fit to a Specific Number of Pages Applying Borders
    The PMT Function Complex Formulas
    Quick Formatting
    Adding More Complexity
    Setting the Print Area
    Drawing a Border Grid
    More Top and Bottom Formatting
    Applying Names to Existing Formulas
    Working With Colour Scales
    Creating Sparklines
    Applying Top and Bottom Borders
    Centring on a Page
    Printing Headings
    Converting a Table to a Range
    Using Counting Functions
    Padding Numbers Using Custom
    Filling a Series
    Moving a Worksheet
    Using Names to Select Ranges

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Midlands
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.

  • Some of the training topics covered include ...
  • Understanding Power Map
    Working With the Data Model
    Adding More Power Views
    Creating a New Query From the Web
    Updating a Power View Report
    Understanding the Query Editor
    Creating a Power Map Tour
    Filtering Data
    Displaying the Query Editor
    Merging Queries
    Understanding Power View
    Transforming Data
    Working With Location Fields
    Working With Power View Fields
    Working With Data Model Fields
    Adding Power View to the Ribbon
    Changing a Power Pivot View
    Tiling Data in Power View
    Filtering in Power View
    Formatting Data Model Fields

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Setting Breakpoints
    Getting Started
    Handling Errors
    Understanding Errors
    Determining the Value of Expressions
    Creating a Function Procedure
    Using the For...To...Next Structure
    Using the Select Case...End Select Structure
    Writing an Error-Handling Routine
    Using the With Statement
    Using the Toolbox
    Working with the Command Button Control
    Working with the PivotFields Collection
    Recording a Macro
    Controlling Program Execution
    Using the Object Browser
    Closing the Visual Basic Editor
    Using Debugging Tools
    Using Message Boxes
    Understanding PivotTables

  • See Training Course Details...


Flash ActionScript 3.0

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day Flash ActionScript 3.0 course will explore best practices when developing rich Flash applications, review important concepts such as syntax, object oriented programming, animating with ActionScript, and keyboard and mouse event handlers.

  • Some of the training topics covered include ...
  • Programmatically Formatting Text 
    Declaring Methods 
    Using the Sound Class 
    Loading Content Dynamically Into a MovieClip 
    Adding Symbols to the Stage at Run-Time 
    Determine your Current Age 
    Formatting the Player Score TextField 
    ActionScript Event Types 
    Manipulating Symbols with ActionScript 
    Dispatching A Custom Crash Event 
    Using the Keyboard and Enter Frame Events 
    Exploring the ActionScript Class Library 
    Creating a Visual Class 
    Animating with ActionScript 
    Adding Asteroids to the Screen 
    ActionScript Events 
    Loops and Conditional Logic 
    Using the MouseEvent 
    Using the EX Operators 
    Use Cos and Sin to maneuver the Space Ship and Create Random Asteroids 

  • See Training Course Details...


Google Script Programming

  • 3 day course
  • Location: Midlands
  • Course Outline
  • A three aday course introducing the fundamentals  Google Acript Programming.  Participants will learn the how to create and manipulate Googe documents, folders, calendars and spreadsheets.  The course will also demonstrate how to link google documents a a underlying database.

  • Some of the training topics covered include ...
  • Sending An Email Using MailApp
    Populating A Table
    Using Google Services Spreadsheets and Sheets
    Checking Input and Throwing Errors
    Adding Users Building Simple Graphical Interfaces
    Range Objects Are Complex
    Creating A Table
    A Data Entry Form
    GmailApp
    The Range offset() Method
    Custom User-Defined
    Introducing JavaScript Functions
    Using List Boxes Google Drive, Folders, Files and Permissions
    The Spreadsheet Object
    Native And Host Objects
    Creating A Web App
    Text Functions
    Introduction
    File And Folder Permissions
    Layout and Panels
    Google Apps Scripting

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day course introducing HTML (Hyper Text Markup Language). Delegates will learn to create and edit simple web pages containing text, lists, images, hyperlunks, forms and tables.

    No prior HTML or web development knowledge is assumed. 

  • Some of the training topics covered include ...
  • Anchors
    Email Links
    Nesting Ordered Lists
    Getting Started
    DOCTYPE Declarations
    Creating Tables
    HTML Links
    Phrase Elements
    Media Types and Units of Measurement
    CSS Rules
    Submit and Reset Buttons
    Descendant Selectors
    Ems (em)
    Text Links
    Definition Lists HTML Tables
    Image Links HTML Lists
    Inches (in), Centimeters (cm), and Millimeters (mm)
    Merging Cells HTML Forms
    Anchors with the name Attribute
    Comments

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Participants on this two day courses will learn about HTML5 structural, semantic, and form tags, how to use Canvas to create drawings natively in the browser, how to work with HTML5 audio and video, the methods for storing variables client-side, and how you build applications that work offline. The course is aimed at delegates with an existing knowledge of HTML 4 or xhtml.

  • Some of the training topics covered include ...
  • Text Properties
    Practice
    Browser Support
    Other Storage Methods
    drawImage() - Sprites
    Page Simplification
    Multiple Sub-Paths
    Sections and Articles
    New Form Elements
    autocomplete
    The audio Element
    Circles and Arcs
    Indexed Database API
    Additional Changes
    Offline Application API
    Cache Manifest File

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Midlands
  • 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 Form Validation
    Preloading
    String(object)
    Focus, Blur, and Change Events
    The this Object
    Methods
    Built-in Functions
    JavaScript Objects, Methods and Properties
    Associative Arrays
    The getElementById() Method
    Conditionals
    Validating Checkboxes
    Function Syntax
    Storing User-Entered Data
    Basics of Form Validation
    Accessing Form Data
    Passing Values to Functions
    JavaScript Operators
    Number(object)

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Basic Operators
    Self-executing Anonymous Functions
    Use Stylesheets for Changing CSS on Many Elements
    Don't Act on Absent Elements
    Key Concepts
    Inside the Event Handling Function
    Logical Operators
    Comparison Operators
    Connecting Events to Run Only Once
    Utility Methods
    Moving, Copying, and Removing Elements
    Selecting Elements
    Attributes
    Ajax and Firebug
    Optimize Selectors
    Checking Types
    Removing Elements
    Getting and Setting Information about Elements
    Best Performance Practices-
    $.fn.toggle
    Writing Plugins

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Using Others' Plugins
    Creating Your Own Plugin
    What Is jQuery Mobile?
    Levels of Support
    Dialogs
    Overview
    Video The Theme Framework
    Accessibility Support
    Buttons and Linking Pages
    ThemeRoller
    Overriding Themes with Custom CSS Plugins
    Sliders
    Themes and Swatches
    Hosting vs. CDN
    Orientation (Portrait/Landscape)
    Data-role

  • See Training Course Details...


Microsoft Access 2007

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Modifying query results and queries
    Adding calculated values
    Database normalization
    PivotTables
    Setting field properties
    Summarizing and grouping values Advanced form design
    Exporting objects
    Finding and editing records
    Protecting databases
    SQL and Access
    Charts in forms
    Performing operations in queries Using forms
    Database concepts
    Database concepts
    Calculated fields
    Modifying query results and queries
    Attaching macros to the events of database objects Advanced macros
    Finding and editing records
    Working with Windows SharePoint Services Database management
    PivotTables

  • See Training Course Details...


Microsoft Access 2010

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Creating parameter queries
    Adding combo boxes
    Calculated values
    Modifying PivotTables
    Exploring tables
    Organizing records Data entry rules
    Hyperlink fields Database management
    Using calculated fields
    PivotTables
    Modifying query results and queries
    Creating macros for data transfer
    Exporting objects
    Summarizing and grouping values Advanced form design
    Adding calculated values
    Modifying lookup fields
    Using action queries Macros
    Creating and using queries
    Getting help Databases and tables
    Importing, exporting, and linking
    Complex queries
    Getting started

  • See Training Course Details...


Microsoft Access 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Working with input masks
    Summarizing and grouping values Advanced form design
    Calculated values and subreports
    Setting validation rules Basic queries
    Creating macros that require user input
    Creating parameter queries
    Planning and designing databases
    Setting field properties
    Creating and using queries
    Getting started
    Attaching SQL queries to controls Advanced queries
    SQL and Access
    Creating, running, and modifying macros
    Charts in reports Querying with SQL
    Linking Access objects
    Changing the design of a table
    Creating reports
    Joining tables in queries
    Label printing Charts
    Adding calculated values
    Organizing records Data Entry rules

  • See Training Course Details...


Microsoft Access 2016

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Designing a Lookup Database
    Getting to Know Access 2016
    Relational Database Design
    Importing and Exporting Records
    Setting Table Relationships
    Working With Records
    Database Security
    Adding Transactional Records
    Creating and Using Macros
    Creating and Using Reports
    Understanding VBA
    Aggregation Queries
    Querying Techniques
    Adding Records to a Table
    Formatting Tables
    Database Wellness
    Creating Queries
    Macro Techniques
    Parameter Queries
    Macros on Forms
    Creating a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Midlands
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Introduction to Programming in Access
    Using the Do...Loop Structure
    Understanding Objects
    Working with Events
    Using the With Statement
    Working with the Application Object
    Using the Object Browser
    Using the For Each...Next Structure
    Navigating the Access Object Hierarchy
    Understanding Collections
    Understanding Constants
    Using Break Mode during Run Mode
    Understanding the Form Object
    Debugging Code
    Using Message Boxes
    Guidelines for use of Branching Structures
    Creating a Function Procedure
    Understanding the Development Environment
    Using Expressions, Variables, and Intrinsic Functions

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Midlands
  • 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 ...
  • Understand the M interface.
    Using Ranges in Excel
    Course topics include- INTRODUCTION TO POWER QUERY
    Using PivotTables CONNECTING TO DATABASES
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Understand and utilize merges. LOADING YOUR DATA
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand working with relational data.
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Transforming Data
    Appending Operations
    Performing Merges
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Understanding the Issues
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Loading into Power Pivot
    Grouping Options
    Working with Folders and Files
    Understanding and Handling Special Situations
    Importing Data
    Understand Power Query formulas.

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Using Multiple Calendars Utilising Advanced DAX Functionality
    Mathematical Functions
    Multiple Table Evaluation Context Working with Dates
    Utilizing Operators
    Introduction to DAX
    Date Functions
    Aggregation Functions
    Filter Functions
    Exploring Data Types
    Single Table Evaluation Context
    The CALCULATE Function
    Working with Calendars
    Logical Functions
    PowerPivot Data Model
    Introduction to DAX
    Information Functions
    Conversion Functions
    Many-to-Many Relationships
    Statistical Functions
    Text Functions
    Explaining Syntax

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Midlands
  • 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 ...
  • Managing a Power BI solution
    Power BI embedded
    Connecting to Power BI data
    Shape data using formatting and transformations.
    Create relationships between data tables.
    Direct connectivity from Power BI desktop
    Importing data into Power BI
    Topics covered include- Introducing Power BI
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Create a Power BI dashboard
    Power BI desktop queries
    The Power BI Interface
    Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
    Direct connectivity from the Power BI service
    Using Excel as a data source for Power BI
    Viewing reports from Excel files Shaping and Combining Data
    Using databases as a data source for Power BI
    Creating Power BI reports
    Use Power BI direct connectivity to access data in Azure SQL data warehouse
    Importing different data sources into Power BI
    Custom visuals Power BI mobile app

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Midlands
  • Course Outline
  • The course is targeted towards business analysts, business intelligence developers and reporting professionals. Participant will learn how to combine the functionality of Power View, PowerPivot, Power Query and Power BI into graphs, charts, KPIs, reports and other data visualisations.

  • Some of the training topics covered include ...
  • Working with Tables
    Exploring the Power View Interface
    Creating Charts
    Hierarchies
    Examining Tiles
    Merge datasets.
    Visualizing Power View Reports
    Importing Large Datasets
    Introduction to the PowerPivot Interface
    Navigate the Power Query interface.
    Navigate the Power Map interface.
    Utilizing DAX Functions
    Importing Data with a Query
    Importing Data
    Adding Slicers to Reports
    Theming Reports

  • See Training Course Details...


Microsoft Project 2007

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Project management concepts
    Working with advanced task options Managing resources
    Creating a custom table Managing multiple projects
    Copying data
    Creating base calendars
    Getting started
    Creating a Work Breakdown Structure Scheduling tasks
    Working with project files
    Sharing resources across projects Project communications
    Communicating among a project team
    Creating custom views
    Creating macros
    Sorting tasks and resources Finalizing the task plan
    Creating a task list
    Consolidating and sharing projects
    Managing a project
    Resolving resource conflicts
    Rescheduling tasks Formatting and reporting
    Working with resources and calendars
    Exporting data
    Working with resource costs Working with views and tables

  • See Training Course Details...


Microsoft Project 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Gantt chart formatting
    The Project window
    The Help window Tasks
    Custom views
    Project management concepts
    Working with tables Filters, groups, and sorting
    Resources and calendars
    Creating a task list
    Customizing Project
    Working with views
    Managing a project
    Task options Resource management
    Standard reports Visual reports  
    Task relationships
    Collaboration
    Exporting to Office applications
     Macros
    Handling resource conflicts Using templates and importing data
    Team Planner view Working with reports
    Consolidating and sharing projects

  • See Training Course Details...


Microsoft Project 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Using templates and importing data
    Analyzing the plan
    Project costs
    Creating projects from other programs Managing a project
    Project management concepts
    Working with templates
    Task links
    Delays and conflicts
    Working with views
    Standard reports
    Task scheduling
    Collaboration
    Getting started
    Working with tables Filters, groups, and sorting
    Hyperlinks
    Team Planner view Working with reports
    Sorting tasks and resources Finalizing the task plan
    Resources and calendars
    Project files Tasks
    The base calendar
    Custom views

  • See Training Course Details...


Microsoft Project 2016 Integrated Course

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A short intensive course covering Microsoft Project Levels 1, 2 and 3. This course teaches you everything you need to know to get up and running with using Microsoft Project competently.

  • Some of the training topics covered include ...
  • Understanding the Backstage
    Editing a Macro
    Resource Assignment Calculations
    Working With the QAT
    Entering Lead Time
    Creating a New Table
    Formatting Chart Objects
    Customising the View Menus
    Exporting to PDF Custom Fields
    Creating a New Project File
    Adding More Material Assignments
    Consumption
    Entering Cost Resources
    Running a Report
    Changing Calendar Options
    Cloning an Existing Report
    Information
    Linking a New Project File to the Pool
    Custom Fields
    Using a Hyperlink Field Controlling Project Data
    Resource Assignment Summary Assigning Resources

  • See Training Course Details...


Microsoft Project 2016 Level 1

  • 1 day course
  • Location: Midlands
  • Course Outline
  • The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

    At the completion of this course you should be able to:

    Start Microsoft Project and identify how it works
    Explain some of the key concepts associated with project management
    Create a new project file in Project
    Enter tasks into a project file
    Create relationships between tasks in a project
    Add resources, including labour, materials and equipment to a project
    Understand and use resource assignment calculations
    Assign resources to tasks using a number of different methods
    Print various aspects of a project
    Obtain help for Project whenever you need it

  • Some of the training topics covered include ...
  • Setting Up Project Information
    Working With Split Screens
    Resource Assignment Calculations
    Entering Tasks
    Work Times for Multiple
    Project Operations
    Working With Summary Tasks
    Assigning Calendars to Resources
    Printing Tasks for Resources
    The Project 2016 Screen
    Working With Fixed Unit Tasks
    Adding More of the Same Resource
    Creating Dependencies in a Sheet
    Showing and Collapsing the Ribbon
    Creating a Simple Assignment
    Working in a Sheet View
    Assigning Specific Work Times
    Adjusting Resource Availability
    Previewing Before You Print
    The Case Study Resources Printing
    Entering Lead Time

  • See Training Course Details...


Microsoft Project 2016 Level 2

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Microsoft Project 2016 - Level 2 is designed for existing users of Microsoft Project who wish to extend their skills and knowledge beyond the creation of simple projects.

    At the completion of this course you should be able to:

    Use various techniques for levelling over allocation of resources
    Assign material resources in a project
    Assign and track costs within a project
    Apply constraints and deadlines to tasks in a project
    Track the progress of a project
    Work more productively with project views
    Work with tables in Project
    Work with some of the features that allow you to control your data
    Format projects to make them more appealing and relevant
    Print data from Gantt Charts in a variety of ways and presentations

  • Some of the training topics covered include ...
  • Customising the View Menus
    Assigning Fixed Costs
    Working With the Standard Views
    Understanding Gantt Chart Bars
    Exploring Tables
    More Highlight Filters
    Tracking Down Over Allocations
    Changing the Layout
    Checking Work For Materials Costs
    Adding Simple Custom Fields
    Assigning Daily Costs
    Formatting Selected Bars
    Understanding the Data Tools
    Formatting for Non-Working Time
    Keeping New Views Local
    Grouping Tasks
    Creating a Custom View
    Working With Progress Lines
    Creating a Custom Combination View
    Highlighting a Range of Tasks
    Exporting to PDF

  • See Training Course Details...


Microsoft Project 2016 Level 3

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Microsoft Project 2016 - Level 3 aims to take the learner to more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA.

    At the completion of this course you should be able to:

    Create and work with several types of custom fields
    Create and work with WBS Codes
    Create a custom view with a custom filter, group and table
    Run and modify standard graphical reports as well as create your own custom reports
    Create and work with visual reports
    Work with and create project templates
    Work with and link multiple projects in Project
    Create shared resources for use amongst multiple projects
    Downsize large project files into more manageable entities
    Export project data to other applications
    Collaborate on projects with others using Skype for Business and SharePoint
    Create VBA macros to automate operations in a project file

  • Some of the training topics covered include ...
  • Filtering Report Data
    Custom Fields
    Creating a Formula in a Custom Field
    Saving a Project as a Template
    Copying to Microsoft Excel
    Creating the Resource File
    Altering Tasks With Custom WBS
    Understanding Project VBA
    Cloning an Existing Report
    Viewing a Combined Project
    Testing a Formula
    Working With Shared Resources
    Understanding Excel Visual Reports
    Accessing the Developer Tab
    Assigning Resources From the Pool
    Understanding the Global Template
    Linking Subprojects to Resources
    Using the Personal Template Folder
    Understanding WBS Codes
    Template Project Templates
    Creating WBS Codes

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.

  • Some of the training topics covered include ...
  • Processing mining models 
    Basic syntax 
    KPIs 
    Most-used Functions & Common tasks 
    Demonstration of SQL Reporting Services with cube as data source 
    Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 
    Clustering - high availability 
    Using the Add Business Intelligence Wizards - write-back, semi-additive measures, time intelligence, account intelligence 
    Understanding the development environment 
    Adding scripts 
    XMLA scripting (SQL Mgmt Studio) 
    Security - roles and permissions 
    Refining Dimensions and Measures in BIDS 
    Using SSAS in BIDS
    Cube Storage and Aggregation 
    Disaster Recovery - backup / restore 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

  • Some of the training topics covered include ...
  • Using variables in data flow 
    Deployment options 
    Configuration discipline 
    Introduction to Control Flow
    The Execute Process Task 
    Data Transformations 
    The Conditional Split Transformation 
    The deployment utility 
    Introduction to SSIS scripting 
    Data Sources 
    SSIS for DBAs: Using SQL Server Management Studio
    Control Flow: The OnError event handler 
    The SSIS object model 
    SSIS debugging overview 
    Script in Data flow: The Script Component 
    The Aggregate Transformation 
    The FTP Task 
    Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations 
    Configuration Overview 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • In this two day course participants learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.

  • Some of the training topics covered include ...
  • Customize Cube and Dimension Processing
    MDX Expressions
    See how to Create Translations for Cubes and Dimensions
    Customize Aggregation Designs
    Understand SSAS Database Backup and Restore
    Deploy and View a Sample Cube
    Deploy and Synchronize Databases
    What Is Microsoft Business Intelligence?
    Understand the Development Environment
    Understand Measure (fact) and Cube Modeling
    Implement Proactive Caching
    Advanced SSAS
    Understand the Calculation Subtab
    Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
    SSAS Administration
    Review Microsoft Office SharePoint Server 2007
    Understand Performance Tuning and Optimization
    Understand Mining Structure Processing
    View a Cube by using SQL Reporting Services

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

  • Some of the training topics covered include ...
  • Executing Packages 
    Package Deployment
    Package Management
    Scripting in Control Flows with the Script Task 
    Installing a Package 
    Advanced Control Flow
    Redeploying Updated Packages 
    Working with Windows Management Instrumentation
    When Things Go Wrong 
    Variables and Configurations
    Extending Integration Services Capabilities through Code 
    Working with Workflow Tasks 
    Using Variables in Control Flow 
    Checkpoints 
    Understanding Integration Services 
    The Data Flow Task 
    Advanced Data Flow
    Data Flow Best Practices 
    Using Variables and Configurations between Packages 

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

  • Some of the training topics covered include ...
  • Common Analysis Services Solutions
    Browsing Perspectives and Translations
    Managing Measures
    Understanding the Tabular Model
    Measures and Measure Groups
    Version Changes of SSAS from 2008-2014
    Utilizing Attributes
    Examining Deployment Options
    Processing Strategies
    The Tabular Solution
    Utilizing Translations
    Understanding the Multidimensional Model
    The Multidimensional Solution
    Introduction to Microsoft SQL Server Analysis Services
    Maintaining and Optimizing
    Calculated Members.
    Deploying

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.

  • Some of the training topics covered include ...
  • Data Loading with the Analysis Services Tasks
    Designing to Troubleshoot: Using Precedence Constraints
    Moving Data with Data Flow
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Optimizing Sources for Extraction
    Using the Workflow Tasks
    Understanding Packages
    Performing Joins with the Lookup Transformation
    Utilizing Data Preparation Tasks
    Using Package Hierarchies: Parent Child
    Overview of Containers
    Understanding Variables
    Managing SQL with the SQL Tasks
    Coding the Script Task
    Utilizing SQL Server Integration Services Data Typing
    Working in the Explore Window
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Utilizing Sequences in a Container
    Handling Errors Common SQL Server Integration Services Design Patterns
    Working with XML
    Creating SQL Server Integration Services Packages

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Midlands
  • 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 2016 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 ...
  • Exploring Subscriptions
    Utilizing Chart Wizard
    SQL Server 2016 Report Builder Advanced Reporting
    Working with Expressions
    Formatting Reports
    Introduction to SQL Server 2016 Report Builder
    Understanding HTML5 and Textboxes
    Understanding Visualizations
    Working with Datasets
    Mastering Data Region(s)
    Exploring Matrix
    Understanding Report Parts
    Utilizing Data Sources
    SQL Server 2016 Report Builder Wizards
    Understanding Variances Between SQL Versions
    Visualizing Your Company Report Templates
    Exploring Table or Matrix Wizard
    SQL Server 2016 Report Builder Graphics

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day course demonstrating how to use SQL Server Data Mining tools. The course introduces delegates to the DMX language and Microsoft graphic validation tools. The intention is to give participants the skills necessary to data mine their own organisations data sets.

  • Some of the training topics covered include ...
  • Apply a Filter to a Mining Model
    Microsoft Time Series
    Microsoft Sequence Clustering
    Create a Cross-Validation Report
    Change the Properties of a Mining Model
    Browse a Model Using the Microsoft Tree Viewer
    Create a Content Query on a Mining Model
    Apply Filters to Model Testing Data
    Add a Mining Model to an Existing Mining Structure
    View and Save the Results of a Prediction Query
    Microsoft Association
    Create an Alias for a Model Column
    Topics include- SSAS Data Mining
    Deploy a Data Mining Solution to Previous Versions of SQL Server
    Data Mining Concepts
    Create a Lift Chart, Profit Chart or Classification Matrix
    Classified Columns
    Management of Data Mining Solutions and Objects
    Browse a Model Using the Microsoft Generic Content Tree Viewer Stored Procedures
    SystemGetCrossValidationResults
    Processing Data Mining Objects

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Midlands
  • 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 Analysis Services Projects
    Add or Remove Tables or Views in a Data Source View
    Processing Databases, Dimensions and Partitions
    Define Time Intelligence
    Authorizing access to objects and operations
    Create an Analysis Services Project
    Create Named Sets
    Configure Analysis Services Project Properties
    Ragged Hierarchies
    Read Definition permissions
    Define Semiadditive Behavior
    Create a Data Source
    Deploy Model Solutions Using the Deployment Wizard
    Create Measures and Measure Groups
    Define a Regular Relationship and Regular Relationship Properties
    Change a Partition Source
    Delete a Data Source View Dimensions
    Define Named Queries in a Data Source View
    Error Configuration Roles and Permissions
    Work with Diagrams in Data Source View Designer
    Replace a Table or a Named Query in a Data Source View

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

  • Some of the training topics covered include ...
  • Add columns to a table
    Create a Relationship Between Two Tables
    Connect to a tabular model database
    Import from Analysis Services
    Import Data
    Understanding DAX in Tabular Models Measures
    Data sources supported in tabular 1400 models
    Delete Relationships
    Create and Manage Tabular Model Partitions
    Create a New Tabular Model Project
    Specify Mark as Date Table for use with Time Intelligence
    Create a Calculated Table
    Delete a Column
    Version comparison
    Topics include- Overview of SSAS Tabular models
    Data types supported
    Process Database, Table, or Partition
    Process Tabular Model Partitions

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Introduction to reporting services
    Sorting and grouping
    Data filters
    Topics include Introduction to Reporting Services
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Create a report using report builder or report designer.
    Implementing report filters and parameters Visualizsng Data with Report Services
    Add a drillthrough to a custom URL
    Configuring data access with report builder
    Use report services configuration manager to reconfigure SSRS servers.
    Report caching, snapshots, and comments
    Report parameters
    Drilldown and drill through Sharing Reporting Services Reports
    Reporting services tools Reporting Services Data Sources
    Report subscription and delivery Administering Reporting Services
    Reporting services components
    Formatting data
    Configuring data access with report designer
    Drillthrough in mobile reports
    Using Datasets Creating Paginated Reports
    Report sub-reports

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Midlands
  • Course Outline
  • Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated dashboards and reports.

  • Some of the training topics covered include ...
  • About Views
    BI and Presentation Catalog Security
    View Selector View
    Navigating the Answers Interface
    Using Prompts to Filter Data
    Oracle BI Architecture
    OLAP, BI, DSS Introduction to Oracle BI Answers and Dashboards
    Logical Data Models
    Column Selector View
    Chart View
    Warehouse Models and Schemas
    Ticker View
    Previewing the Answers
    Filters View
    Adding Columns to a Request
    Saving and Reusing Filter Settings
    Viewing Supplementary Content
    About Database Technologies
    Managing Saved Content
    Managing The View of the Dashboard Page

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Midlands
  • 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 ...
  • User-Defined Exceptions 
    Types of Triggers 
    Calling a Stored Procedure 
    Declaring Variables 
    Privileges for Stored Programs 
    Procedures and Functions 
    Date Intervals 
    The DBMS_OUTPUT Package 
    Named Parameter Notation 
    Using Packages 
    Nesting Blocks 
    Creating Packages 
    The PL/SQL Execution Environment 
    Package Variables 
    WHILE and FOR Loops 
    The Implicit (SQL) Cursor
    Row-Level Triggers 
    Declaring and Opening Cursors 
    Anchored Types 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Midlands
  • 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 ...
  • SQL*Plus LOB Support 
    Data Inconsistencies 
    Grouping Rows 
    Date Functions 
    Outer Joins 
    Defining Tables 
    Self Joins 
    Interactive SQL*Plus Scripts 
    SQL*Plus Substitution Variables 
    The INSERT Statement 
    Deleting a Table Definition 
    Oracle Versioning and History 
    The UPDATE Statement 
    Nulls and DISTINCT 
    The EXISTS Operator 
    Tailoring Your SQL*Plus Environment 
    SQL Queries 
    SQL Queries - Joins 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course introducing PHP and equipping candidates with the skills necessary to build PHP driven dynamic web sites. Participants should have a sound knowledge of HTML.

  • Some of the training topics covered include ...
  • Arrays 
    Writing to a File 
    Opening a File 
    PHP Basics
    Sessions 
    Magic Quotes
    Constants 
    The php.ini File 
    require_once 
    Concatenation 
    A Database-less Login Form 
    magic_quotes_gpc 
    Sending Email with PHP 
    Flow Control 
    PHP and HTML Forms 
    Creating a Resume Management Page
    Looping through Associative Arrays 
    Defining and Calling Functions 

  • See Training Course Details...


PowerPoint 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Running presentations
    Using comments
    Getting started
    Application settings
    Equations Distributing presentations
    Clip art Using tables and charts
    Proofing presentations
    WordArt Pictures
    Working with hyperlinks
    Using slides from other presentations Formatting slides
    Modifying objects
    Speaker notes
    Formatting paragraphs Using drawing objects
    Building slides from Word outlines
    Custom slide shows
    Saving presentations
    Adding shapes
    Media clips
    Customizing tables
    Custom themes Using graphics and multimedia
    Using text in objects Working with graphics

  • See Training Course Details...


PowerPoint 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Modifying graphics
    Editing efficiently Working with shapes
    Customizing tables
    Customizing PowerPoint
    Slide masters and transitions
    Formatting shapes
    Photo albums Customizing slide elements
    Proofing presentations
    Action buttons and equations
    Applying content to shapes Graphics
    The PowerPoint interface Creating presentations
    SmartArt Preparing and printing presentations
    Slide masters
    Equations Integrating Microsoft Office files
    Distributing presentations
    Pictures Tables and charts
    Preparing a presentation
    Application settings
    Working with SmartArt graphics

  • See Training Course Details...


PowerPoint 2016 Advanced

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Microsoft PowerPoint 2016 - Advanced Level is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

  • Some of the training topics covered include ...
  • Animating Text
    Rotating and Flipping Images
    Editing Audio Clips
    Recording a Slide Show
    Saving to a Storage Device
    Rehearsing Timings
    Understanding Presenter View
    Merging and Splitting Cells
    Optimising and Compressing Media
    Understanding Picture
    Applying Colour Corrections
    Deleting a Customised Theme
    Presenting a Slide Show Online
    Understanding the Chart Format
    Using Presenter View
    Saving a Presentation as a PDF
    Inserting Action Buttons
    Applying Artistic Effects

  • See Training Course Details...


PowerPoint 2016 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • The skills and knowledge acquired in Microsoft PowerPoint 2016  Basic Level are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations.

     

  • Some of the training topics covered include ...
  • Accessing the Help Window
    Drawing Shapes
    Printing the Outline
    Changing the Slide Layout
    Inserting and Formatting Text
    Using Slide Sorter View
    Adding Sections
    Customising the Status Bar
    Applying a SmartArt Style
    Exiting Safely From PowerPoint
    Working With Text
    Connecting Shapes
    Applying Theme Variants
    The Save As Place
    The PowerPoint Screen
    Launching Dialog Boxes
    Aligning Objects Using Smart Guides
    Editing Text
    Inserting a Title Slide

  • See Training Course Details...


Publisher 2010

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Custom colors
    Catalog merge
    Graphics in typography
    Finalizing and publishing a site
    Publication basics
    Interactive forms
    Publisher Help
    Print preparation
    Long publications
    The Publisher interface
    Getting started
    Typography
    Basic publications
    Modifying form properties
    Data sources for the recipient list
    Adding elements to a Web site
    Object positioning
    Web site publishing

  • See Training Course Details...


Publisher 2013

  • 1 day course
  • Location: Midlands
  • Course Outline
  • The skills and knowledge acquired in Microsoft Publisher 2013 are sufficient to be able to create publications such as flyers, newsletters and labels.

  • Some of the training topics covered include ...
  • Drawing Lines
    Text Box Margins
    Accessing The Help Window
    Sending A Publication As An Email
    Zooming And Panning
    Exiting Safely From Publisher Your First Publication
    Creating A Product List
    Adjusting Rows And Columns
    Inserting Pages
    Creating Labels
    Inserting Borders And Accents
    Using The Scratch Area
    Using The Ribbon
    Deleting Shapes Working With Pictures
    Using Undo And Redo
    Text Effects Text Techniques
    Inserting Headers
    Inserting Picture Fields
    Selecting A Merge Area Layout
    Printing A Publication
    Naming Pages

  • See Training Course Details...


Publisher 2016

  • 1 day course
  • Location: Midlands
  • Course Outline
  • The skills and knowledge acquired in Microsoft Publisher 2016 are sufficient to be able to create publications such as flyers, newsletters and labels.

  • Some of the training topics covered include ...
  • Showing Merge Results
    Creating Grid Guides
    Creating Labels
    Page Orientation
    Understanding Page Sizes
    Master Pages
    Moving Pages
    Saving for Another Computer
    Creating Folded Cards
    Saving for Photo Printing
    Catalogue Merge
    Text Columns
    Creating a Data Source
    Inserting Picture Fields
    Selecting a Merge Area Layout
    Previewing and Modifying a
    Publications
    Catalogue Merge
    Drawing Lines

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Midlands
  • Course Outline
  • SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating  data,  joins,  subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.

  • Some of the training topics covered include ...
  • Whitespace and Semi-colons
    Sorting By Column Position
    Simple SELECT Statements
    Stored Procedures
    Dropping Views
    Creating Tables
    NULL Values 
    Common Math Functions    
    Benefits of Stored Procedures
    Selecting Specific Columns
    Table Aliases  
    Primary Keys
    Case Sensitivity
    Creating Tables
    Concatenation
    Data Types
    Using CASE  Inserting, Updating and Deleting Records

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

  • Some of the training topics covered include ...
  • Creating a Data Source and Dataset
    Design the Query Dialog
    Deploying Reports with Development Studio
    Adding Groups and Users
    Filters
    Adding Fields to the Table Data Region
    Web Folder Properties
    Designing the Layout
    Create a Data Source
    Data Output
    Understanding System-level Roles
    Create a Dataset
    Understanding Reporting Services 2005 Caching
    Reporting Services 2005 Query vs. Report Parameters
    Reporting Services 2005 Toolbars
    Understand the Report Model Architecture
    Reporting Services 2005 Security Model Concepts
    The Main Components of the Design Environment
    Grouping Data

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Midlands
  • Course Outline
  • A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.

  • Some of the training topics covered include ...
  • Explore how to create expressions in your reports using 
    Investigate how to call a custom assembly from a report 
    Creating Tabular and List Reports
    Explore creating groups 
    Learn how to solve common parameter issues 
    Learn about report variables and when you might need to use them 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Discover interactive sorting 
    Creating Matrix Reports and Charts
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Snapshots and Subscriptions
    Investigate the scheduling of report snapshots 
    Learn about datasets and data regions 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Learn how to work with rich text to produce mail merge style reports 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Midlands
  • 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 ...
  • Create Expressions with Variables
    Examine Data Warehousing Concepts
    Overview of Data Warehouse Components
    Securing Packages and Databases
    Work with Windows Azure
    Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Execute SSIS Packages on the Server
    Secure Packages
    Examine MSI Packages
    Work with MDS Databases
    Debug Package Execution Components
    Configure the Package Execution Strategy
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Overview of Data Warehouses
    Create Fact Tables
    Add Script Tasks and Script Components to an SSIS Package
    Debugging and Troubleshooting Packages
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Introduction to Data Warehouses

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

  • Some of the training topics covered include ...
  • Create a Drop-Down List Parameter
    The Report Designer Creating Reports with SQL Server Data Tools
    Using Parameters with Ad Hoc SQL
    Create a Pie Chart with Point Labels
    Drilldown Reports Managing Page Layout and Adding Interactivity
    The Tablix Component
    Globals Collection
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Report Builder vs. Report Designer
    Building a Report with Report Builder
    Create Shared Data Sources and Data Sets
    Introduction to SQL Server Reporting Services
    Exploring the Tablix Report Type
    Multivalued Parameters Dynamic Reports with Parameters
    Formatting Tablix Rows and Columns Making Reports Interactive
    Overview
    Introducing SQL Server Data Tools
    Installing and Configuring Reporting Services Reporting Services Architecture
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    A Tour of the Report Builder Interface
    Expression Operators

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Midlands
  • Course Outline
  • In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database.  You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server 2012 error handling features.

    The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.

    The course uses a SQL Server 2012 database but is suitable for users of earlier SQL Server versions. For those interested in external accreditation the course materials are mapped against the Microsoft SQL Server 2012 Database Querying (70-461) exam syllabus.

  • Some of the training topics covered include ...
  • Implement Error Handling
    Modifying Data
    Update Data
    Group and Aggregate Data Programming in T-SQL
    Analyze Data from Query Plans
    Manage Triggers
    Work with Set Operators
    Work with Dynamic SQL Working with Subqueries and Table Expressions
    Create Queries Using Built-in Functions
    Work with String and Numeric Data Types
    Write CASE Expressions Working with SQL Data Types
    Manage Query Plans
    Filter the Queried Results
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Manage Transactions Querying SQL Server System Metadata
    Work with SSPs and SMOs
    Perform Advanced Filtering Querying Data from Multiple Tables
    Work with System Databases
    Getting Started with SQL Server 2012
    Work with SSMS Working with T-SQL
    Configure User-Defined Functions (UDF)

  • See Training Course Details...


Visio 2007

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Advanced Layout and connection techniques
    Block, tree, and onion diagrams
    Network diagrams
    Flowcharts
    Project management diagrams
    Integration with Microsoft Outlook
    Web site maps
    Working with organization charts
    Navigating in Visio
    Dimensioning
    Integration with Microsoft Word
    Documenting software systems
    Drawing tools
    Shape behavior and events
    Reporting Creating technical layouts

  • See Training Course Details...


Visio 2010

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Database model diagrams
    Working with links Network and brainstorming diagrams
    Network diagrams
    Organization charts
    File and print properties
    Creating a basic diagram
    Web site maps Integrating Visio with other programs
    Documenting software systems
    Custom stencils Business diagrams and Web site mapping
    Shape behaviors
    Shape properties
    Integration with Microsoft Word
    Working with Web-enabling features Software and database diagrams
    Rack diagrams
    Formatting text
    Special drawing operations
    Basic shapes and lines
    Project management diagrams
    Custom themes
    Editing objects Basic diagrams
    Working with text

  • See Training Course Details...


Visio 2013

  • 2 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Formatting text
    The Visio 2013 interface
    Displaying shape dimensions
    Layout and connection techniques
    Formatting shapes and lines
    Working with pages
    Special drawing operations
    File and print properties
    Block, tree, and onion diagrams
    Custom themes and templates
    Basic shapes and lines
    Sharing diagrams using a browser
    Reporting
    Database model diagrams
    Custom templates
    Software and database diagrams
    Network diagrams

  • See Training Course Details...


Word 2010 Advanced

  • 1 day course
  • Location: Midlands
  • Course Outline
  • This course aims to provide the skill and knowledge to create more intricate and complex documents by using Microsoft Word at a more advanced level.

  • Some of the training topics covered include ...
  • Creating A Template
    Sorting Table Data
    Modifying Theme Colours
    Understanding Electronic Forms In Word
    Understanding Importing
    Splitting Table Cells
    Recipient Lists
    Understanding Lists
    Applying Bullets
    Modifying A Template
    Importing And Embedding Excel Data
    Assigning A Macro To The Toolbar
    Modifying A Bullet
    Renumbering A List
    Applying Hanging Indents
    Indexing
    Downloading An Online Template

  • See Training Course Details...


Word 2010 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • This course focuses on basic document production using Microsoft Word 2010 and is designed to give the learner a sound understanding of how documents are created, formatted, and printed.

  • Some of the training topics covered include ...
  • Inserting A Date
    Template
    Minimising The Ribbon
    Quick Printing
    Understanding Tables
    Footers
    Saving A New Document
    Accessing The Help Window
    Selecting Text Using The
    Browsing For Help
    Document Proofing
    Changing Paper Sizing
    Launching Dialog Boxes
    Setting Custom Margins
    WordArt
    Understanding How Help Works
    Drawing Shapes

  • See Training Course Details...


Word 2013 Advanced

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • Creating and formatting sections
    Web pages Working in Word efficiently
    Document properties
    Document design Document References
    Formatting text graphically
    Form letters
    Working with shapes
    Advanced document formatting
    Mail Merge
    Indexes, bibliographies, and footnotes Document sharing
    Macros  
    Creating forms
    Finalizing documents Document interactivity
    Creating diagrams
    Customizing the ribbon
    Tracking changes
    Tables of contents and captions
    Inserting objects and charts
    Data sources for the recipient list
    Mailing labels and envelopes Illustrations

  • See Training Course Details...


Word 2013 Basic

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Some of the training topics covered include ...
  • The Word window
    The Undo and Redo commands
    Adding graphics and clip art
    Paragraph formatting
    Working with graphics Styles and outlines
    Creating tables
    Working with table content
    Document navigation Editing text
    Working with styles
    Table data Page layout
    Headers and footers
    Working with outlines Proofing, printing, and exporting
    Changing the table structure
    Getting started
    Find and replace Formatting text
    Character formatting
    Cut, copy, and paste
    Examining formatting
    Graphics
    Spelling and grammar

  • See Training Course Details...


Word 2016 Level 1

  • 1 day course
  • Location: Midlands
  • Course Outline
  • This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Word 2016 to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well-designed documents. The course begins by showing the learner how to navigate around Microsoft Word 2016. It then quickly gets the learner to create a new document before moving onto features such as text manipulation and enhancement, creating and using tabs and tables, embellishing documents with clip art and pictures, creating multiple documents through merging and printing documents

  • Some of the training topics covered include ...
  • Inserting a Picture
    Adding Data to a Table
    Increasing and Decreasing Font Size
    Product Code: INF1650
    Borders and Shading Dialog Box
    Using Google to Get Help
    Performing a Mail Merge
    Autofitting Columns
    Replacing Words
    Opening an Existing Document
    Creating a Recipient List
    Creating the Starting Document
    Printing Your Documents
    Product Information
    Changing Fonts
    Checking Spelling and Grammar
    Typing Text
    The Save As Place

  • See Training Course Details...


Word 2016 Level 2

  • 1 day course
  • Location: Midlands
  • Course Outline
  • This course aims to enhance existing skills by covering more specific documentation creation aspects such as working with multiple documents, formatting tables, tabs, lists, merging, section breaks, templates and more.

  • Some of the training topics covered include ...
  • Inserting an Even Page Section Break
    Drawing Shapes
    Selecting the Document Type
    Creating a Template
    Using a Custom Template
    Selecting Another Data Source
    Applying a Theme to a Template
    Aligning Shapes
    Revealing Formatting
    Saving a Recipient List
    Formatting a Text Box
    Inserting First Page Headers and
    Typing Text Into a Text Box
    Importing and Exporting Styles
    Footers
    Colouring Pictures
    Applying Effects to Text Boxes
    Creating a Character Style
    Understanding the Modify Style
    Attaching a Template to a Document

  • See Training Course Details...


Word 2016 Level 3

  • 1 day course
  • Location: Midlands
  • Course Outline
  • Microsoft Word 2016 - Level 3 is designed for Microsoft Word users who are keen to extend their understanding and knowledge of the software beyond basic document creation so that they can create and work with features such as SmartArt, indexes, master documents, interactive fields and much more.

  • Some of the training topics covered include ...
  • Understanding SmartArt
    Applying a Modify Document
    Assigning a Macro to the Toolbar
    Inserting Prompt Text
    Understanding Electronic Forms in
    Marking Index Entries
    Accepting and Rejecting Changes
    Locating Footnotes and Endnotes
    Changing the Number Format
    Saving Building Blocks
    Editing a Macro
    Endnotes
    Inserting a Building Block
    Understanding Footnotes and
    Assigning a Keyboard Shortcut to a
    Customising the Spelling Checker
    Navigating With Bookmarks
    Dictionary
    Applying a Number Format
    The Field Dialog Box

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730