Power Query Course

دورة تحليل البيانات Power Query

USD 106
USD 53

time

Duration
01:59:32 hours

time

Access Time
Lifetime

time

Language
Arabic

time

Resources
(1)

time

Skill Level
( General - Specialized )

USD 106
USD 53

About the instructor

Mohamed El-Saeed
Data analyst instructor

Data analysis Instructor

Quality control and electrical maintenance

SKILLS

  • Advanced Excel.
  • Power Query
  • Microsoft Programs.
  • Microsoft Power BI, DAX.
  • Web scrapping
  • Machine Learning algorithms

You Will Learn

Module 1: Introduction

  • Understanding the role of Power Query in data transformation.
  • Exploring the user interface and basic functionalities.
  • Importing data from various sources into Power Query.
  • Performing basic data cleaning.

Module 2: Merge Queries

  • Understanding the concept of merging queries.
  • Performing inner, left outer, right outer, and full outer joins.
  • Handling common challenges in merging queries.
  • Utilizing merge options for precise data matching.

Module 3: Append Queries

  • Introduction to appending queries.
  • Combining multiple datasets vertically.

Module 4: Unpivot Columns

  • Understanding the need for unpivoting data.
  • Unpivoting columns to convert wide datasets into tall datasets.
  • Handling complex data structures during the unpivot process.
  • Applying transformations to unpivoted data for further analysis.

Targeted Students

  1. Data Analysts: Data analysts can use Power Query to easily load, analyze, clean, and transform data from multiple sources.
  2. Managers and Decision Makers: Leaders and managers can use Power Query to analyze data and quickly gain insights for decision-making.
  3. Marketers: Marketers can utilize Power Query to analyze marketing and sales data, financial reports, and more to understand campaign performance, identify opportunities, and make marketing decisions.
  4. Developers and Data Programmers: Developers can integrate Power Query into their coding processes to load, clean, and transform data before analyzing or storing it in their applications.
  5. Students and Researchers: Students and researchers can leverage Power Query for data analysis, report preparation, and research projects efficiently.
Training Program Name As In Certificate

Power Query Course

Created at: 2024-04-18 11:53:04
Updated at: 2024-12-08 16:44:42
A team of instructors who are the best in their fields
The continuous development of our educational materials
Lifetime access for the courses that you purchase
Evaluate yourself through a test that you can take after each level in
Easy communication between you and the instructors directly through your account
We have presence in more than 22 countries in the Middle East and North Africa
Our content is provided in the Arabic language with an easy-to-use platform
A team of customer services who are working 24/7
Lowest cost and highest quality of supervised educational materials
More than one accreditation from local and international education institutions
53 USD