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


"Very helpful, knowledgeable and responsive trainer."

Westminster University

"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills

"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260