Udemybeginnerpl

POWER QUERY-Import i transformacja danych w Excelu i PowerBI

Excel & Power BI data import & transformation. Learn to clean, shape, and prepare data for powerful analysis. Boost your data skills!

Related:ETL Process
4.8(53)
353students
8h 55m
Certificate
Dariusz Skórniewski
Dariusz SkórniewskiOd górnika do programisty

Course Content

POWER QUERY-Import i transformacja danych w Excelu i PowerBI is a beginner-level Udemy course taught by Dariusz Skórniewski. It runs 8h 55m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 53 reviews, with 353 students enrolled. It is a paid course, last updated January 2025.

Data Preparation & Analysis with Power Query: A Comprehensive Course

Are you struggling with messy data hindering your ability to make informed decisions? Data-driven decision making is crucial, but unreliable data leads to flawed conclusions. This course provides a complete guide to data cleaning, transformation, and integration using Power Query, a powerful tool for professionals and analysts.

What you'll learn:

  • Data Source Connectivity: Learn to import data from a wide variety of sources, including:
    • Databases
    • Text files
    • Excel spreadsheets
    • Websites (WWW)
    • XML and PDF files
    • Folders of files
    • OneDrive
    • Images
    • SQL Databases
  • Power Query Fundamentals: Master the basics of Power Query, Microsoft's powerful data transformation engine. Understand its role as the successor to MS Query.
  • Visual Data Transformation: Utilize the intuitive visual editor to clean, transform, and combine data with simple clicks.
  • Power Query in Excel & Power BI: This course covers Power Query in both Microsoft Excel and Power BI Desktop, enabling you to build robust data models for reporting and analysis.
  • Advanced M Language: Dive into the M language, the formula language behind Power Query, and learn to write custom functions for complex data manipulations.
  • Data Manipulation Techniques: Gain proficiency in essential data manipulation techniques:
    • Filtering & Sorting: Quickly isolate relevant data.
    • Column & Row Management: Remove, rename, and reorder columns and rows.
    • Data Type Conversion: Ensure data accuracy and consistency.
    • Text, Date & Number Operations: Perform calculations and transformations on various data types.
    • Splitting & Merging Columns: Combine and separate data effectively.
  • Data Integration: Learn to join and merge queries using various join types (inner, outer, left, right) to combine data from multiple sources.
  • Data Shaping & Analysis:
    • Transpose & Reverse Data: Change data orientation for optimal analysis.
    • Grouping & Aggregation: Summarize data for insightful reports.
    • Index & Example Columns: Create calculated columns for advanced analysis.
    • Conditional Columns: Implement logic to create columns based on specific conditions.
    • Custom Columns & IF Statements: Build flexible data transformations.
  • Parameterization & Automation:
    • Using Parameters: Create dynamic queries with user-defined parameters.
    • Creating Functions: Automate repetitive tasks with custom functions.
    • Dynamic Calendar Tables: Generate dynamic date tables for time-series analysis.
    • Refresh Automation: Automate data refresh using events and macros.

Course Outline:

  1. Course Navigation & Structure
  2. Introduction to Power Query & Applications
  3. Accessing the Power Query Editor
  4. Importing Data from the Same Workbook
  5. Data Loading Options
  6. Refreshing Connections & Changing Data Sources
  7. Power Query Editor Interface
  8. The M Language & Advanced Editor
  9. Data Types in Power Query
  10. Query Management
  11. Removing Columns & Rows
  12. Handling Errors & Value Replacement
  13. Filtering & Sorting Data
  14. Splitting & Merging Columns
  15. Working with Dates, Text & Numbers
  16. Importing from Excel Workbooks
  17. Importing Text Files
  18. Importing XML & PDF Files
  19. Importing Folders of Files
  20. Importing from the Web
  21. Importing from OneDrive
  22. Importing from Images
  23. Importing from SQL Databases
  24. Joining Queries
  25. Merging Queries – Join Types
  26. Transpose, Reverse Rows, Count Rows
  27. Pivot Columns & Unpivot Columns
  28. Grouping Data
  29. Index & Example Columns
  30. Conditional Columns
  31. Custom Columns & IF Statements
  32. Using Parameters
  33. Parameters from a Worksheet
  34. Building Queries in the M Language
  35. Converting Queries to Functions
  36. Writing Custom Functions in M
  37. Filtering Data from Last Week/Yesterday
  38. Creating a Dynamic Calendar Table
  39. Refreshing Connections with Events & Macros

This course is designed for anyone who needs to clean, transform, and analyze data effectively. Whether you're a data analyst

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

4.8(95)
5h 50m
intermediate
4.8(8,474)
6h 17m
all
4.7(57)
6h 42m
all
4.7(2,961)
10h 33m
all