Get in Touch
 Duration 14 hours

Course Outline

Getting Started with Power Query

  • Overview of the Power Query interface
  • Conceptual understanding of queries and applied steps
  • Exploring integrations with Power BI and Excel

Establishing Data Connections

  • Importing data from Excel, CSV, and text files
  • Managing folder structures and organized datasets
  • Linking to online services and database sources

Essential Data Cleaning Techniques

  • Eliminating errors and duplicate entries
  • Applying filters, sorting, and reshaping data structures
  • Handling missing or null values effectively

Data Transformation and Structuring

  • Splitting and merging columns for optimal analysis
  • Utilizing pivot and unpivot operations
  • Grouping and aggregating data points

Query Integration

  • Differentiating between appending and merging queries
  • Selecting appropriate join types and considering data structures
  • Constructing models from multiple data sources

Introductory M Language Concepts

  • Deciphering M formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation scripts

Automation and Refresh Management

  • Designing reusable transformation processes
  • Setting up automated refresh schedules
  • Overseeing dependencies and optimizing query performance

Advanced Methodologies

  • Implementing parameters within queries
  • Applying functions in M language
  • Adhering to best practices for scalable transformation pipelines

Recap and Future Directions

Requirements

  • A foundational grasp of spreadsheet-based data operations
  • Hands-on experience with fundamental data analysis tasks
  • Knowledge of standard file formats including CSV and Excel

Target Audience

  • Data specialists requiring efficient methods for cleaning and preparing datasets
  • Business analysts managing recurring data processing workflows
  • Individuals involved in data reporting and operational automation

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories