Grazie per aver inviato la tua richiesta! Uno dei nostri team membri ti contatterà a breve.
Grazie per aver inviato il tuo prenotazione! Uno dei nostri team membri ti contatterà a breve.
Struttura del corso
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
Requisiti
- 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 Ore
Recensioni (5)
Il modo in cui il presentatore ha affrontato le domande. Il metodo di erogazione del corso è stato molto utile per gli studenti. Un insegnante davvero molto bravo.
ROSE BALOYI - National Transmission Company South Africa
Corso - Power BI: Basics to Advanced
Traduzione automatica
Il contenuto era difficile, ma lo sforzo extra che ho dovuto fare mi ha aiutato a ricordare e comprendere meglio Power BI.
Melvin - TLI Group
Corso - Power BI DAX Fundamentals
Traduzione automatica
le spiegazioni chiare e concise
Georgiana - Everience
Corso - Power BI Basic
Traduzione automatica
Discutere dei nostri problemi
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Corso - Power BI for Developers
Traduzione automatica
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
