Speaker

Boriana Petrova

Boriana Petrova

ITraining CEO, Excel MVP

Sofia, Bulgaria

Actions

Microsoft Certified Trainer with over 20 years experience as an IT instructor and Consultant. She has many qualifications and professional certifications, including: Excel MVP, MCT, MCITP, MCTS, MOS Master.

Area of Expertise

  • Information & Communications Technology

Topics

  • Microsoft Excel
  • Microsoft Excel VBA
  • Microsoft Power BI
  • Microsoft Project
  • Microsoft SQL Server

Some problems with smart decision

This session explain a couple of problems in one real project and there decisions.

Disconnected tables in Power BI

This session will show how to create slicers with different measures.

It's Easy ... just refresh

The session present real project to collect and analyze data.

Analyze data across different periods with DAX.

This session is how to create data model and use time intelligence functions.

Power BI in Office 365

It this session will explain how to collaborate with Office 365 and Power BI

The power of parameters

This session show how to create and use dynamic parameters in Power Query

Dynamic array functions in Excel

FILTER - filters a dataset
RANDARRAY - creates an array of random numbers 0 - 1
SEQUENCE - generates a sequence of numbers
SINGLE - get value through implicit intersection
SORT - sorts table
SORTBY - sorts by two or more columns
UNIQUE - generates a unique lists or distinct list

Boriana Petrova

ITraining CEO, Excel MVP

Sofia, Bulgaria

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top