VOTRE
FORMATION
Excel training workshop – Power Query and Power Pivot for controller and analyst (Level 1)
$ 495
AF3659
Webinaire
2 jours de 4 heures
Anglais
Aussi disponible en entreprise
RÉSUMÉ :
RÉSUMÉ :
The addition of Power suites will revolutionize the way you work with Excel. Until now, "Business Intelligence" (BI) was almost exclusively reserved for IT developers. This training explores the Power Query and Power Pivot add-ons for Excel and takes place over two consecutive days, four hours each.
Voir plus
Power Query
- Import data
- Automate the import of data from external sources
- Excel, Access, SQL
- Text
- Web
- ODBC link
- Automate the import of data from external sources
- Data manipulation
- Adjust data in the query editor
- Transform data with Power Quercy
- Sort and filter data
- Combine different sources
- Consolidate files from a folder
- Formulas
- Use Power Query formulas (M Language)
- Modify a query
- Insert custom columns
- Import data
- The different sources (SQL, Access, Excel, ...)
- Update data
- Create the data model
- What is the data model
- Create relationships
- Create hierarchies
- DAX functions
- Time intelligence
- DATESYTD
- DATESMTD
- DATESQTD
- PARALLELPERIOD
- Aggregation
- SUM
- SUMX
- Math
- DIVIDE
- Filter
- CALCULATE
- Adding KPIs
- Time intelligence
CALENDRIER :
| 25/08/2025 | Webinaire | Stéphanie Perreault |
