Über den Kurs
The guide uses a repeatable, hands‑on format: each module explains a concept, presents click‑by‑click steps, includes practice tasks with sample CSV and Excel files and ends with a short checklist. By the end, you’ll know how to import data from workbooks, text/CSV files and folders, clean and standardize fields, reshape tables with pivot/unpivot and group‑by, build append and merge queries, write simple M functions, and deliver a refreshable dataset ready for reporting.
Who is this course for?
• Excel and Power BI users who want to streamline data preparation
• Business analysts, finance professionals and data enthusiasts looking to reduce manual data cleaning steps
• Beginners with basic familiarity of Excel/Power BI who want to build repeatable data flows
• Anyone interested in learning ETL concepts without coding
What to expect
This 4–5 hour bootcamp takes you from zero to hero with hands‑on practice, sample datasets and clear explanations. You will learn to:
• Understand the ETL flow: Connect, Transform and Load data
• Navigate the Power Query interface and applied steps
• Import data from Excel, CSV and folders and choose the right load options
• Clean messy datasets (handle blanks, standardize data types, remove duplicates)
• Reshape data with pivot/unpivot, Group By, conditional and custom columns
• Combine tables with append and merge operations, understanding join types
• Build a reusable calendar table and perform basic M code tweaks
• Complete a mini project that combines monthly sales data, enriches it with product attributes, and delivers a refreshable report in Excel or Power BI.
Included: Practice dataset, full slide deck, and reusable .pbix/Excel template file.
Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.
Ihr Ausbilder
Mirzet Velagić
