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!
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:
- Course Navigation & Structure
- Introduction to Power Query & Applications
- Accessing the Power Query Editor
- Importing Data from the Same Workbook
- Data Loading Options
- Refreshing Connections & Changing Data Sources
- Power Query Editor Interface
- The M Language & Advanced Editor
- Data Types in Power Query
- Query Management
- Removing Columns & Rows
- Handling Errors & Value Replacement
- Filtering & Sorting Data
- Splitting & Merging Columns
- Working with Dates, Text & Numbers
- Importing from Excel Workbooks
- Importing Text Files
- Importing XML & PDF Files
- Importing Folders of Files
- Importing from the Web
- Importing from OneDrive
- Importing from Images
- Importing from SQL Databases
- Joining Queries
- Merging Queries – Join Types
- Transpose, Reverse Rows, Count Rows
- Pivot Columns & Unpivot Columns
- Grouping Data
- Index & Example Columns
- Conditional Columns
- Custom Columns & IF Statements
- Using Parameters
- Parameters from a Worksheet
- Building Queries in the M Language
- Converting Queries to Functions
- Writing Custom Functions in M
- Filtering Data from Last Week/Yesterday
- Creating a Dynamic Calendar Table
- 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
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.