Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
POWERQUERRY IN EXCEL
Category
INFORMATION TECHNOLOGY
Subcategory
Data
Code
DAT001
Training Objectives
Understand Power Query's databases for data import and transformation. Connect Excel and Power BI to various external data sources. Clean and transform data to prepare for analysis with Excel and Power BI Automate the process of updating imported data in Excel and Power BI
Training Program
Introduction to Power Query: What is Power Query and its advantages.
Connecting to data sources: Excel files, CSV, databases, Web sources.
Data import: Use the query editor to load data into Excel.
Data transformation: Filter, sort, rotate, split columns, change data types.
Data combination: merge (JOIN) and add (APPEND) queries.
Data cleaning: Manage errors, replace values, delete duplicates.
Creating custom columns: custom formulas in Power Query.
Advanced settings: use of parameters, advanced M functions.
Update data: automate the update of imported data.
Excerpts on Excel and Power BI
