Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.