Accelerated A+ Hardware and OS Objectives

Duration: 5 Days

Objectives

In this course, you will install, upgrade, repair, configure, optimise, troubleshoot and perform preventative maintenance on basic personal computer hardware and operating systems. The course will help prepare students to achieve a CompTIA A+ Certification.

Pre-requisites

Delegates should have end-user skills with Windows®-based personal computers, including the ability to browse and search for information on the Internet, start up and shut down, log on to a computer and network, run programs and move, copy, delete, and rename files in Windows Explorer. Students should also have basic knowledge of computing concepts, including the difference between hardware and software, the functions of software components such as the operating system, applications, file systems and the function of a computer network.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Introduction to Business Intelligence

  • OLTP databases
  • OLAP databases
  • Data Warehouses
  • SSIS ETL, SSRS and SSAS

Introduction to PowerPivot and Analysis Services Tabular Mode

  • What Is PowerPivot?
  • PowerPivot Deployment Options
  • Self-Service Business Intelligence (SSBI)
  • Differences between SSAS Tabular Mode and Multidimensional
  • Power Pivot Data Models
  • Pivot Tables and Charts

A First Look at Tabular BISM

  • Using Visual Studio and working with Projects
  • The Tabular Designer
  • Importing Data
  • Relationships
  • Calculations
  • Browsing Models
  • Modelling and Deploying
  • Administering Tabular Models with SSMS

Enhancing Your Tabular BISM

  • Refining the Tabular Model
  • Hierarchies
  • Measures
  • KPIs
  • Perspectives
  • Partitions
  • Processing a Tabular Database
  • Creating and Applying Security Roles

Introduction To DAX

  • DAX Fundamentals
  • DAX Operators
  • DAX Functions
  • DAX as a Query Language

Advanced Topics in DAX

  • Parent-Child Hierarchies
  • Cross Filtering with Many-to-Many Relationships
  • Multiple Relationships Between Tables
  • Time Based Analysis
  • Non-Aggregatable Columns

Analysing Tabular BISMS in Excel

  • Pivot Tables
  • Sheet Data Reports
  • Pivot Charts
  • Local Cubes
  • Excel Services

Reporting on Tabular Models with SSRS

  • PowerPivot
  • PowerPivot Add-In for Excel
  • PowerPivot data model

Course Dates

London CentralLondon GreenwichBristol

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)


"Excellent in all areas. The trainer was fantastic."

University of Glamorgan

"Concepts were explained clearly - very much so. What a great instructor! "

Jason Mather

"Amazing! Looking forward to the follow-up course!"

MOD



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team