Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power Query

  • Overview of the Power Query interface
  • Concepts of queries and applied steps
  • Interaction with Power BI and Excel integrations

Data Source Connections

  • Ingesting Excel, CSV, and text-based files
  • Handling folders and structured data collections
  • Linking to web-based and database systems

Core Data Cleaning Techniques

  • Eliminating errors and duplicate entries
  • Filtering, sorting, and reshaping data sets
  • Addressing null or missing values

Transformation and Data Modeling

  • Splitting and combining column data
  • Pivoting and unpivoting operations
  • Data grouping and aggregation strategies

Query Combination Strategies

  • Distinguishing between appending and merging queries
  • Join mechanisms and structural data considerations
  • Constructing datasets from multiple sources

Introduction to M Language

  • Interpreting M language syntax and formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation logic

Automation and Refresh Processes

  • Building reproducible transformation workflows
  • Setting up automated refresh intervals
  • Handling dependencies and optimizing query performance

Advanced Methodologies

  • Implementing query parameters
  • Utilizing M language functions
  • Best practices for building scalable transformation pipelines

Conclusion and Future Directions

Requirements

  • Fundamental knowledge of data management in spreadsheet applications
  • Practical experience with elementary data analysis operations
  • Basic familiarity with standard file formats, including CSV and Excel

Target Audience

  • Data specialists responsible for dataset cleaning and preparation
  • Business analysts managing repetitive data processes
  • Individuals engaged in data reporting and workflow automation

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories