Microsoft Office Excel - moduł Business Intelligence

Knowledge of Windows and knowledge of the basics of the program Microsoft Excel.

The course is intended for people who would like to become familiar with and learn how to use the new functionality of MS Excel 2013, intended for Business Inteligence.

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