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 ... Compare Mining Structures
- See Training Course Details...
Topics include:
Data Mining Tab
Data Source
Saving Results to the Database
Microsoft Logistic Regression Algorithm
Microsoft Neural Network Algorithm
Introduction to SQL Server Data Tools
Model Usage
Saving Queries
Microsoft Time Series Algorithm
Named Calculation
Named Queries
CRISP-DM
Visio Data Mining Add-In
Cross Validation
Offline Mode and Immediate Mode
Data Preparation
Data Modelling
Accuracy and Validation
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 ... View Selector View
- See Training Course Details...
Totals within Pivot Tables Advanced Formatting
Pdf and Print Control
Ticker View
Column Formulas Using Primary Views
Downloading the Answers Report Formatting
Gauge View
View XML and SQL Calls Administering The Presentation Catalog
Launch BI Presentation Services
About Database Technologies
Reusing Filters
Navigating the Answers Interface
Managing Presentation Catalog Objects Deploying Requests to Dashboards
Databases and Data Models
Warehouse Models and Schemas
Preparing Objects for Dashboard Deployment
Miscellaneous Tasks Building a Dashboard
Warehouse Databases
Filters View
Controlling the Report Definition
Using Dashboard Prompts
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 ... Utilise data sources.
- See Training Course Details...
Load data.
Creating Relationships
Navigate the Power BI interface.
Drill Through
Visualizing Power View Reports
Filter data.
Exploring the Power View Interface
Add time to a presentation.
Use Bing maps.
Calculated Columns and Calculated Fields
Understand querying with natural language
Hierarchies
Importing Data with a Query
Navigate the Power Map interface.
Merge datasets.
Understanding DAX
Email us about this courses
Other Uk Enable Technology Training Courses
Microsoft Project Level 3 Uk Training Courses
Power BI - Uk Microsoft Power BI Training Courses
Oracle SQL Uk Training Courses
PL/SQL - Uk SQL Training Courses
Report Builder Uk Training Courses
SSRS 2008 Uk Training Courses
CSS Uk Training Courses
Project 2016 L1 Uk Training Courses
HTML Uk Training Courses