Unix and Linux Fundamentals

Duration: 3 Days

Objectives

The objective of this course is to provide a comprehensive introduction to the UNIX operating system. At the end of the course delegates will have the fundamental skills required to login to a Unix system, manage files and directories, use Unix commands and manage processes, use an editor, access the electronic mail facility and create simple shell scripts.

Pre-requisites

Delegates should be computer literate and familiar with the basic usage of an operating system, although no prior knowledge of UNIX is required.

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.)

Related Courses


"One of the most enjoyable and informative courses I have ever attended."

Invacore Ltd

"The best two days training I have ever had. Would definitely recommend and use again."

Surrey Heath Borough Council

"Probably the best course I have been on. Very thorough and entertaining."

Cancer Research UK



 

 

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