Enable Technology

DATA ANALYTICS MIDLANDS TRAINING COURSES 

DATA ANALYTICS TRAINING COURSES MIDLANDS




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 ...
  • Visio Data Mining Add-In  
    CRISP-DM
    Introduction to SQL Server Data Tools
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Multiple Nested Tables Microsoft Data Mining Algorithms
    Excel PowerPivot Data Mining Add-ins
    Data Source
    Testing and Validation of Mining Models
    Microsoft Sequence Clustering Algorithm
    The Mining Model Prediction Tab
    Microsoft Logistic Regression Algorithm
    The User Interface
    Cross Validation
    Microsoft Association Algorithm
    Offline Mode and Immediate Mode
    Microsoft Linear Regression Algorithm
    Saving Results to the Database
    Data Mining and Results
    Saving Queries

  • 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 ...
  • Adding Slicers to Reports
    Utilise data sources.
    Understand querying with natural language
    Hierarchies
    Applying Filters
    Use Bing maps.
    Importing Data
    PowerPivot
    Merge datasets.
    Introduction to Power BI
    Creating a Cascading Relationship
    Theming Reports
    Navigate the Power BI interface.
    Examine map data.
    Introduction to the PowerPivot Interface
    Hiding Columns, Change Data Type, Sorting, and Filtering
    Working with Tables

  • 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 ...
  • Creating a Dashboard
    Defining the Pivot View
    Launch BI Presentation Services
    Warehouse Models and Schemas
    Understanding The Dashboard Interface
    Managing the Views Using Secondary Views
    View Selector View
    About Views
    Navigating the Answers Interface
    Set Operations
    No Results View Using Pivot Table Views
    A Pivoting Scenario
    Physical Data Models Data Warehousing and BI
    View XML and SQL Calls Administering The Presentation Catalog
    Column Formatting
    Transactional Databases
    Controlling the Report Definition
    Chart View
    Oracle BI Architecture
    Miscellaneous Tasks Building a Dashboard
    Narrative View

  • See Training Course Details...




Contact Us By Email         Telephone on 01952 305730




Other Midlands Enable Technology Training Courses

Publisher 2010 - Midlands Office Training Courses
Mobile - Midlands Web Development Training Courses
Word 2013 Basic Midlands Training Courses
Oracle SQL - Midlands SQL Training Courses
SSAS 2017 - Midlands SQL Server Analysis Services Training Courses
Access VBA Midlands Training Courses
Flash Midlands Training Courses
PL/SQL Midlands Training Courses
Microsoft Access 2010 Midlands Training Courses


All Enable Technology Data Analytics Training Locations


Telford Data Analytics Training Courses
Solihull Data Analytics Training Courses
West Bromwich Data Analytics Training Courses
Stourbridge Data Analytics Training Courses
Shropshire Data Analytics Training Courses
Derby Data Analytics Training Courses
Black Country Data Analytics Training Courses
Newcastle under Lyme Data Analytics Training Courses
Bridgnorth Data Analytics Training Courses
Lichfield Data Analytics Training Courses
Northhampton Data Analytics Training Courses
Milton Keynes Data Analytics Training Courses
Chester Data Analytics Training Courses
Bromsgrove Data Analytics Training Courses
Rugby Data Analytics Training Courses
West Midlands Data Analytics Training Courses
East Midlands Data Analytics Training Courses
Tamworth Data Analytics Training Courses
Stoke On Trent Data Analytics Training Courses
Wolverhampton Data Analytics Training Courses
Kidderminster Data Analytics Training Courses
Hereford Data Analytics Training Courses
Stafford Data Analytics Training Courses
Walsall Data Analytics Training Courses
Leicester Data Analytics Training Courses
Oxford Data Analytics Training Courses
Dudley Data Analytics Training Courses
Coventry Data Analytics Training Courses
Leek Data Analytics Training Courses
Burton on Trent Data Analytics Training Courses
Nottingham Data Analytics Training Courses
Redditch Data Analytics Training Courses
Nuneaton Data Analytics Training Courses
Crewe Data Analytics Training Courses
Sandwell Data Analytics Training Courses
Birmingham Data Analytics Training Courses
Shrewsbury Data Analytics Training Courses
Cannock Data Analytics Training Courses
Staffordshire Data Analytics Training Courses
Liverpool Data Analytics Training Courses
Manchester Data Analytics Training Courses
Cheltenham Data Analytics Training Courses
Leicestershire Data Analytics Training Courses
Worcester Data Analytics Training Courses

Telford, Solihull, West Bromwich, Stourbridge, Shropshire, Derby, Black Country, Newcastle Under Lyme, Bridgnorth, Lichfield, Northhampton, Milton Keynes, Chester, Bromsgrove, Rugby, West Midlands, East Midlands, Tamworth, Stoke On Trent, Wolverhampton, Kidderminster, Hereford, Stafford, Walsall, Leicester, Oxford, Dudley, Coventry, Leek, Burton On Trent, Nottingham, Redditch, Nuneaton, Crewe, Sandwell, Birmingham, Shrewsbury, Cannock, Staffordshire, Liverpool, Manchester, Cheltenham, Leicestershire, Worcester