Course Outline

Introduction to PowerQuery


1. What is PowerQuery
2. PowerQuery use cases

Data retrieval and operations on data sets:

  1. Data import from:
  • a. MS Excel
  • b. web
  • c. MS SQL
  • d. text files
  • e. importing multiple files
  1. Query operations:
  • a. Combining queries
  • b. Scalano inquiries
  • c. Types of joins between queries
  • d. Scalanot blurred
  • e. Data loading settings
  • f. Duplication and query references

Data operations

  1. combining data from multiple sheets (consolidation),
  2. deleting rows/columns,
  3. data grouping,
  4. data merging,
  5. data filtering,
  6. organizing data,
  7. changing data type,
  8. working with numerical data,
  9. working with date and time data,
  10. working with text data.

Parameterization and query automation

  1. Parameter management
  2. Query parameterization
  3. Import automation

PowerPivot

  1. Creating a data model based on data prepared in PowerQuery
  2. Presentation of an example of using PowerPivot in a real case

Requirements

lack

 14 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (6)

Provisional Courses

Related Categories