EDITC - Education & Information Technology Centre

Training Courses : BUSINESS USER : EXCEL SPECIALIST

Training Courses

Analyzing Data Using PowerPivot and Data Analysis Expression in Excel

Type:	IT InstructorLed Courses
Category:	EXCEL SPECIALIST, POWERPIVOT AND POWER BI

The analysis of large data volume demands the use of modern tools in order that the analysis is done in a very effective way. People from the Statistics, IT, Risk Management and Control Departments as well as Financial Controllers and Analysts need to gain new skills in order to be able to respond to the new demands for controlling, monitoring and assessment of risks in Cyprus. PowerPivot is a new ADD-IN in Microsoft Excel . PowerPivot allows the user to connect to a database and use its related tables to analyze the data. The user may also create new fields in the tables in order to calculate new data based on existing data in the tables. It uses a new programming language (DAX) which is quite easy to use especially for experienced users of Excel Formulae and Functions. The PowerPivot Add in is a revolution in data analysis since (compared with “traditional” Pivot Tables) as it allows the use of many related tables for data analysis and it also provides fast processing due to the use of In-Memory-storage which is much faster.

Duration:	21 hours
Location:	EDITC & MMC Conference Center, 16 Imvrou Street, 1055 Nicosia
Language:	Greek
Attendance:	4-16

Topics

Unit 1: Introducing Data Models
Unit 2: Using Data Models For BI
Unit 3: Manipulate Data in a Data Model
Unit 4: Programming with DAX
Unit 5: Loading Data
Unit 6: Understanding Evaluation Contexts
Unit 7: Working with PowerView

Who Should Attend
The course is suitable for candidates who deal with data analysis, programmers, people from Information Technology department, Financial Controllers and Accountants.

Objectives

Create Data Models
Explain relationships in data models
Create measures and calculated columns using DAX
Create PowerPivot tables
Create DAX expressions for data analysis
Use measures and calculated columns in PowerPivot tables
Link to various data sources
Create Dashboards and PowerView Reports

Prerequisites
Participants should have a very good knowledge of Excel and especially of Pivot Tables and Formulae and Functions. Prior to participating in this course, participants are encouraged to take up an Excel Expert course.

Methodology
Lecture, discussion, demonstration and practice.

Find Training Courses

Name

Type