Perform common query tasks in Power BI Desktop
Perform common query tasks in Power BI Desktop, available at $19.99, has an average rating of 3.17, with 19 lectures, based on 3 reviews, and has 348 subscribers.
You will learn about Connect to data Power Query Editor and Queries Shape and combine data Group rows Pivot columns Create custom columns Query formulas Creating and Managing Query Groups Creating Conditional Columns Appending Queries Merging Queries This course is ideal for individuals who are Beginner Power BI Data Analyst or Beginner Data Analyst or Beginner Data Scientist It is particularly useful for Beginner Power BI Data Analyst or Beginner Data Analyst or Beginner Data Scientist.
Enroll now: Perform common query tasks in Power BI Desktop
Summary
Title: Perform common query tasks in Power BI Desktop
Price: $19.99
Average Rating: 3.17
Number of Lectures: 19
Number of Published Lectures: 19
Number of Curriculum Items: 19
Number of Published Curriculum Objects: 19
Original Price: $29.99
Quality Status: approved
Status: Live
What You Will Learn
- Connect to data
- Power Query Editor and Queries
- Shape and combine data
- Group rows
- Pivot columns
- Create custom columns
- Query formulas
- Creating and Managing Query Groups
- Creating Conditional Columns
- Appending Queries
- Merging Queries
Who Should Attend
- Beginner Power BI Data Analyst
- Beginner Data Analyst
- Beginner Data Scientist
Target Audiences
- Beginner Power BI Data Analyst
- Beginner Data Analyst
- Beginner Data Scientist
Power BI is a data analytics tool developed by Microsoft used to visualize data and find useful insights. In this article, you will see how to work with the Query Editor in Power BI desktop. Power BI comes in various versions, i.e., Power BI Desktop, Power BI Service, Power BI Mobile, and Power BI Developer. Power BI desktop is the free version, and the query editor is available in all three versions.
Power BI Desktop has several components to transform, model, and visualize data and also generate reports from data. The Query Editor in Power BI is used to transform or edit data files before they are actually loaded into the Power BI.
The Query Editor plays the role of an intermediate data container where you can modify data by selecting rows and columns, splitting rows and columns, pivoting and unpivoting columns, etc. The changes made by the Query Editor in Power BI are not reflected in the actual dataset. Once you have pre-processed the data and have transformed it into the required format, you can load the data into the Power BI environment.
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Course Curriculum
Chapter 1: Power BI Setup
Lecture 1: Introduction
Lecture 2: What is Power BI
Lecture 3: What is Power BI Desktop
Lecture 4: Install Power BI Desktop
Lecture 5: Explore Power BI Desktop
Chapter 2: Perform common query tasks in Power BI Desktop
Lecture 1: Overview of querying in Power BI Desktop
Lecture 2: Connect to data
Lecture 3: Power Query Editor and Queries
Lecture 4: Creating and Managing Query Groups
Lecture 5: Renaming Queries
Lecture 6: Splitting Columns in a query
Lecture 7: Changing Data Types
Lecture 8: Removing and Reordering Columns
Lecture 9: Duplicating and Adding Columns
Lecture 10: Creating Conditional Columns
Lecture 11: Connecting to Files in a Folder
Lecture 12: Appending Queries
Lecture 13: Merging Queries
Lecture 14: Query Dependency View
Instructors
-
Bluelime Learning Solutions
Making Learning Simple
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 3 votes
- 4 stars: 0 votes
- 5 stars: 0 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024