Get in Touch
 Duration 14 hours

Course Outline

Overview of Power Query

  • Exploring the Power Query interface
  • Comprehending queries and applied steps
  • Navigating integrations within Power BI and Excel

Linking to Data Sources

  • Importing data from Excel, CSV, and text files
  • Handling folders and organized datasets
  • Connecting to web-based and database sources

Essentials of Data Cleaning

  • Eliminating errors and duplicate entries
  • Applying filters, sorting, and reshaping data
  • Addressing missing values

Data Transformation and Shaping

  • Dividing and combining columns
  • Performing pivots and unpivots
  • Grouping data and calculating aggregates

Integrating Queries

  • Differences between appending and merging queries
  • Join methodologies and data structural implications
  • Designing datasets from multiple sources

Introduction to the M Language

  • Grasping M language formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation logic

Automation and Data Refreshing

  • Building reusable transformation processes
  • Setting up refresh timetables
  • Overseeing dependencies and query efficiency

Advanced Methods

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

Recap and Future Directions

Requirements

  • A foundational grasp of spreadsheet-based data operations
  • Prior experience with elementary data analysis activities
  • Awareness of standard file formats like CSV and Excel

Target Audience

  • Data specialists tasked with cleansing and structuring datasets
  • Business analysts handling routine data processes
  • Individuals engaged in data reporting and workflow automation

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories