DATA ANALYTICS TRAINING COURSES UK
Data Mining using Excel and Microsoft SQL Server Analysis Services
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- 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 ... Data Mining Concepts
- See Training Course Details...
The User Interface
Accuracy and Validation
Creating Reports Using Reporting Services
Concepts and Terminology
Data Source
Exploring Data
Data Preparation
Named Calculation
Microsoft Decision Trees Algorithm
Microsoft Association Algorithm
Multiple Nested Tables Microsoft Data Mining Algorithms
Microsoft Sequence Clustering Algorithm
Microsoft Logistic Regression Algorithm
Topics include:
Visio Data Mining Add-In
Microsoft Neural Network Algorithm
Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
Types of Data Mining Algorithms
Testing and Validation of Mining Models
Microsoft Power Graphics
- 2 day course
- Location: Uk
- Telephone on 01952 305730
- 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 ... Understanding DAX
- See Training Course Details...
Creating PivotTables
Utilize themes.
Use Bing maps.
Add time to a presentation.
Using Cards
Power View
Merge datasets.
Adding Slicers to Reports
Importing Data with a Query
Navigate the Power Query interface.
Calculated Columns and Calculated Fields
Perspectives Power Query
Importing Data
Manage modifications.
Examine map data.
Understanding Aggregations
Creating a Cascading Relationship
Oracle Business Intelligence - Create Reports and Interactive Dashboards
- 3 day course
- Location: Uk
- Telephone on 01952 305730
- 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 ... Warehouse Models and Schemas
- See Training Course Details...
Chart View
Basic Navigation Using A Dashboard
Sections and Pages
Previewing the Answers
Accessing The Presentation Catalog
Controlling the Report Definition
Filters View
Report Attributes
Viewing the Request Results
Warehouse Databases
Sorting Data
Defining the Pivot View
Column Formulas Using Primary Views
A Pivoting Scenario
Databases and Data Models
Understanding The Dashboard Interface
Pdf and Print Control
Preparing Objects for Dashboard Deployment
Understanding the Dashboard Structure
Managing Dashboard Objects Creating a Report
Email us about this courses
Other Uk Enable Technology Training Courses
Data Warehouse - Uk SQL Training Courses
Project 2016 L1 - Uk Microsoft Project Training Courses
Power BI - Uk Microsoft Power BI Training Courses
SSRS 2014 Uk Training Courses
SSAS 2017 Uk Training Courses
PL/SQL Uk Training Courses
VBA - Uk Excel Training Courses
Crystal 2011 - Uk Crystal Reports Training Courses
SQL Uk Training Courses