Home » Shop » Microsoft Office » Excel » Big Data – Data Analysis with PowerPivot for Excel
Course ID: #158-1

Big Data – Data Analysis with PowerPivot for Excel

Duration: 1 day Dates: 2 November 2026 1 February 2027 10 May 2027 2 August 2027

With PowerPivot, Business Intelligence reports that previously had to be commissioned can now be created independently. This course shows you how.

Introduction to PowerPivot

  • What is PowerPivot
  • Computer requirements for installing PowerPivot
  • Benefits of PowerPivot
  • First steps
  • First reports

Fundamentals of PowerPivot

  • Relationships
  • Hiding or deleting columns
  • Adding calculated columns
  • Measures basics
  • Adding measures

Introduction to DAX Data Analysis Expressions

  • Introduction to DAX (Data Analysis Expressions)
  • Grouping dates
  • Refreshing data
  • Slicers
  • Adding further tables/worksheets

Optimising PivotTables

  • Differences between „calculated column“ and „measures“
  • When it is better to use calculated columns and when to use „measures“
  • KPIs
  • Charts
  • Error handling
Learning Solution

Blended Learning, Firmenseminar, Individualcoaching, Klassenraumtraining, Online Live Webinar
Language

Deutsch, Englisch, Französisch, Italienisch
Dates

2026/11/02, 2027/02/01, 2027/05/10, 2027/08/02, flexibel, auf Anfrage
Location

Brüttisellen, Lausanne, flexibel, auf Anfrage

By the end of the course, participants will be able to consolidate large volumes of data and/or data from different sources into meaningful dashboards and charts.

Experienced Excel users who want to compile various business data for reports, analyses and decision-making documents.

  • Experience using the Windows user interface
  • Solid knowledge of Microsoft Excel (e.g. having attended the course „Microsoft Excel 365 / 2019 Introduction and Microsoft Excel 365 / 2019 Advanced“)

Related products

  • Course ID: #OTL2A
    Top Rated

    Outlook Advanced

    After completing this course, participants will have advanced knowledge of Outlook and be confident in using its email functions, additional organisational tools and the use of Outlook in a team.

    Duration: 1 day
    Price:
    Price range: CHF500 through CHF1'700 excl. VAT
    Outlook Advanced
  • Course ID: #149
    Top Rated

    PowerPoint Advanced

    In this course, participants can deepen their knowledge of working with PowerPoint. They become familiar with advanced functions and, through exercises, achieve greater efficiency in their daily work with PowerPoint.

    Duration: 1 day
    Price:
    Price range: CHF500 through CHF1'700 excl. VAT
    PowerPoint Advanced
  • Course ID: #158
    Best Selling

    Excel Advanced

    You become familiar with advanced functions, e.g. names and conditional formatting, database functions and advanced filters, complex analyses using pivot tables and arrays. You learn how to analyse and visualise your data quickly and professionally.

    Duration: 2 days
    Price:
    Price range: CHF990 through CHF3'400 excl. VAT
    Excel Advanced
  • Course ID: #153
    Best Selling

    Excel Introduction

    Participants will be able to create spreadsheets with Microsoft Excel for calculations and as a basis for planning. In addition, they will gain knowledge of working with charts in order to present calculations effectively.

    Duration: 2 days
    Price:
    Price range: CHF990 through CHF3'400 excl. VAT
    Excel Introduction

Price range: CHF600 through CHF1'900 excl. VAT

Clear

SIGN UP

Newsletter

Receive news about new courses, offers and promotions by email.

← Back

Thank you for your response. ✨

Email Subscription
Microsoft Office
Show all
Microsoft Tech
Show all
Business & Soft Skills
Process and Quality Management
Project Management
Adobe
CompTIA
Security
Linux
Oracle
Amazon
Google
Leadership and Professional Development
E-Learning and LMS
Languages
Show all
Artificial Intelligence
Show all
Cisco
Show all
VMware and Virtualisation
Show all
Data and Programming
Show all
Online Collaboration
Show all