Course Outline

Entry

  • new possibilities Excelaw Business Intelligence
  • what is Power Query
  • what is PowerPivot
  • what is Power View
  • what is Power Map?
  • what is Power Inquire
  • what is solver
  • installing add-ons

Power Query Add-in

  • import and transformation of file sources
  • import and transformation of Internet sources

Introduction to PowerPivot and working with data

  • overview of slicer controls
  • data filtering
  • cell formatting
  • changing data type
  • datasheet customization

Downloading data from various sources into PowerPivot

  • downloading data from databases
  • downloading data from MS Excel
  • downloading data from TXT files
  • downloading Copy-Paste data
  • creating linked tables

Create pivot tables using PowerPivot

  • creating a pivot table
  • reorganizing the pivot table
  • adding calculated measures to a pivot table
  • changing the type of pivot table functions

Create pivot charts using PowerPivot

  • creating a pivot chart
  • reorganizing a pivot chart

Refreshing data in a PowerPivot worksheet

Creating and managing relationships in PowerPivot

Introduction to DAX expressions (Data Analysis Expressions)

  • DAX overview
  • types of functions
  • operators
  • calculated columns and measures
  • Error handling

Power View Sheets

tabels:

  • sorting
  • filtration
  • charts
  • maps

Solver Add-in

  • problems that can be solved with an add-on
  • tool configuration overview
  • optimization examples

Inquire add-on

  • discussion of the concept of the add-on
  • sheet design review

Requirements

Knowledge of the Windows system and the material in the basics of using the program Microsoft Excel.

  14 Hours

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:00 and 16:00.

Price per participant

Testimonials (1)

Related Courses

Related Categories