Analyzing data using PowerPivot and Data Analysis Expression in Excel

- Οργάνωση/ Διοίκηση/ Ηγεσία - Πληροφορική - Χρήστες

17 Μαρτίου 2023 08:15 31 Μαρτίου 2023 13:30
Ελληνικά
21 ώρες ( 3 μέρες )
Analyzing data using PowerPivot and Data Analysis Expression in Excel

ΠΕΡΙΓΡΑΦΗ

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 2010 & 2013. 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) 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.

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

  • 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

ΣΕ ΠΟΙΟΥΣ ΑΠΕΥΘΥΝΕΤΑΙ

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

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

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

The course is 100% practical. The topics are delivered with short presentations by the instructor followed by a  step-by-step demonstration by the instructor and repetition by the students, examples and discussions on how a feature may be used with real life examples and practice through written exercises.

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


Αναλυτικό Κόστος Σεμιναρίου

Για Δικαιούχους ΑνΑΔ

  • € 700.00
  • € 357.00
  • € 0.00
  • € 343.00

Για μη-Δικαιούχους ΑνΑΔ

  • € 700.00
  • € 0.00
  • € 0.00
  • € 700.00
ΠΡΟΓΡΑΜΜΑ ΣΕΜΙΝΑΡΙΟΥ

Παρασκευή - 17 Μαρτίου 2023

Ώρα

08:15 - 13:30

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Δευτέρα - 20 Μαρτίου 2023

Ώρα

08:15 - 16:00

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Παρασκευή - 24 Μαρτίου 2023

Ώρα

08:15 - 13:30

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Παρασκευή - 31 Μαρτίου 2023

Ώρα

08:15 - 13:30

ΕΚΠΑΙΔΕΥΤΗΣ:

Μαρία Κναή

Τοποθεσία:

OnLine Virtual Classroom

Εκδήλωση Ενδιαφέροντος : Analyzing data using PowerPivot and Data Analysis Expression in Excel

Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
Beyond Excel Expert (Comparing, Manipulating Lists and Analysing Data ...

Ένα νέο σεμινάριο από τους ειδικούς στο Microsoft Excel! To σεμινάριο αυτό απευθύνεται σε χρήστες που έχουν ήδη παρακολουθήσει το σεμινάριο Excel Expert και επι...

10/02/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Microsoft Excel Expert Level for Technical, Scientific & Supervisory S...

Mastering Excel can be life changing in the workplace regardless of your current position. Working with tables and lists, making decisions based on data analysi...

02/03/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Χειρισμός Ηλεκτρονικών Υπολογιστών (Windows, Internet, Email, Word & ...

Με την ραγδαία εξέλιξη της τεχνολογίας στην πληροφορικής,  όλοι οι εργαζόμενοι πρέπει να έχουν τουλάχιστον τις βασικές ψηφιακές  γνώσεις και δεξιότητες που απαι...

08/03/2023 08:15

60 ώρες (10 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Editc (Λευκωσία)

Microsoft Excel Basic Level For Technical, Scientific and Supervisory ...

Microsoft Excel is an essential application in today’s work environment. Microsoft Excel is a tool for the creation of spreadsheets and graphs, for performing c...

09/03/2023 08:15

12 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Microsoft Power Automate for End Users and Microsoft PowerApps(Course ...

Microsoft Power Automate for End Users delivers an instructor-led product showcase for Microsoft Flow from start to finish in an engaging and practical way. Flo...

15/03/2023 08:15

28 ώρες (4 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Analyzing data using PowerPivot and Data Analysis Expression in Excel...

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, Ri...

17/03/2023 08:15

21 ώρες (3 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online

Microsoft Excel Expert Level for Technical, Scientific & Supervisory S...

Mastering Excel can be life changing in the workplace regardless of your current position. Working with tables and lists, making decisions based on data analysi...

04/05/2023 08:15

14 ώρες (2 μέρες)

Ελληνικά

Επιχορηγημένο-ΑνΑΔ

Live Online