logo-slvexpert

YOUR

TRAINING

Excel training workshop – Power Query and Power Pivot for controller and analyst (Level 1)
$ 300
AF3659
et|icon_check_alt|
Webinar training - Online
et|icon_check_alt|
7 hours (8h30 to 16h30)
et|icon_check_alt|
English
et|icon_check_alt|
Webinar

Summary :

The addition of the Power Suites will revolutionize the way you work with Excel. To date, “Business Intelligent” (BI) has been almost exclusively reserved for IT developers. This course explores the Power Query and Power Pivot add-ins of Excel.
SEE MORE
Power Query
  • Import data
    • Automate the import of data from external sources
      • Excel, Access, SQL
      • Text
      • Web
      • ODBC link
  • Data manipulation
    • Fit data in the query editor
    • Transform data with Power Quercy
    • Sort and filter data
    • Combine different sources
    • Consolidate files inside a directory
  • Formulas
    • Use Power Query formulas (Language M)
    • Modify a query
    • Insert custom columns
 

.

 

.

PowerPivot
  • Import data
    • The different sources (SQL, Access, SharePoint, ...)
    • Update data
  • Create the data model
    • What is the data model
    • Create relationships
    • Create hierarchies
  • DAX functions
    • Time intelligence
      • DATESYTD
      • SAMEPERIODLASTYEAR
    • Statistics
      • SUM
      • SUMX
      • AVERAGE
      • AVERAGEX
    • Logic
      • IF / AND / OR
      • SWITCH

YOUR TRAINERS:

CALENDAR :

01/05/2024Webinar training - OnlineStéphanie Perreault
04/07/2024Webinar training - OnlineStéphanie Perreault
26/08/2024Webinar training - OnlineStéphanie Perreault