문의를 보내주셔서 감사합니다! 팀원이 곧 연락드리겠습니다.
예약을 보내주셔서 감사합니다! 저희 팀 멤버 중 한 분이 곧 연락드리겠습니다.
코스 개요
Introduction to Power Query
- Power Query interface overview
- Understanding queries and applied steps
- Navigating the Power BI and Excel integrations
Connecting to Data Sources
- Importing Excel, CSV, and text files
- Working with folders and structured datasets
- Connecting to online and database sources
Data Cleaning Fundamentals
- Removing errors and duplicates
- Filtering, sorting, and shaping data
- Working with missing values
Transformations and Data Shaping
- Splitting and merging columns
- Pivoting and unpivoting
- Grouping and aggregating data
Combining Queries
- Append vs. merge queries
- Join types and data structure considerations
- Modeling multi-source datasets
Introduction to M Language
- Understanding M formulas
- Editing queries using the Advanced Editor
- Writing custom transformations
Automation and Refresh
- Creating reusable transformation workflows
- Configuring refresh schedules
- Managing dependencies and query performance
Advanced Techniques
- Parameterizing queries
- Using functions in M
- Best practices for scalable transformation pipelines
Summary and Next Steps
요건
- An understanding of spreadsheet-based data work
- Experience with basic data analysis tasks
- Familiarity with common file formats such as CSV and Excel
Audience
- Data professionals who need to clean and prepare datasets
- Business analysts responsible for recurring data workflows
- Anyone involved in data reporting and process automation
10 시간
회원 평가 (5)
강사가 질문을 다루는 방식. 수업을 전달하는 방법이 학생들에게 매우 유익했습니다. 정말 좋은 강사이십니다.
ROSE BALOYI - National Transmission Company South Africa
코스 - Power BI: Basics to Advanced
기계 번역됨
내용은 힘들었지만, 제가 쏟은 노력 덕분에 Power BI를 더 잘 기억하고 이해할 수 있었습니다.
Melvin - TLI Group
코스 - Power BI DAX Fundamentals
기계 번역됨
우리 문제에 대해 토론하기
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
코스 - Power BI for Developers
기계 번역됨
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
코스 - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
