Power BI - Preparing, cleaning and transforming your Data Video
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people, searching your emails, and more.
This will help you save time and easily find all your information in the Microsoft 365 suite.
- 4:42
- 3389 views
-
Power BI - Recovering your Data from different sources
- 3:26
- Viewed 3579 times
-
Power BI - Introduction to the Query Editor
- 2:33
- Viewed 3273 times
-
Power BI - Creating your Datasets
- 2:26
- Viewed 3236 times
-
Power BI - Customising your Report
- 3:12
- Viewed 2685 times
-
Power BI - Customising your Visuals
- 2:58
- Viewed 3168 times
-
Power BI - Creating a Report
- 2:54
- Viewed 8823 times
-
Power BI - Introduction to Power BI Building Blocks
- 3:07
- Viewed 3547 times
-
Power BI - Introduction to Power BI Desktop
- 2:52
- Viewed 3576 times
-
Creating a Report
- 2:54
- Viewed 8823 times
-
Introduction to Power Bi
- 1:29
- Viewed 5590 times
-
General Introduction
- 2:54
- Viewed 4581 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 3832 times
-
Recovering your Data from different sources
- 3:26
- Viewed 3579 times
-
Introduction to Power BI Desktop
- 2:52
- Viewed 3576 times
-
Introduction to Power BI Building Blocks
- 3:07
- Viewed 3547 times
-
Create slicers
- 3:55
- Viewed 3484 times
-
Create quick measures
- 3:02
- Viewed 3451 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3313 times
-
Introduction to Power BI Mobile
- 2:15
- Viewed 3308 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3273 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3273 times
-
Creating your Datasets
- 2:26
- Viewed 3236 times
-
Customising your Visuals
- 2:58
- Viewed 3168 times
-
Conditional formatting
- 3:35
- Viewed 3132 times
-
Use the drill down filter
- 4:41
- Viewed 3116 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 3099 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 3092 times
-
Calculate function
- 4:22
- Viewed 3027 times
-
Turn on the drill down feature
- 2:23
- Viewed 2806 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 2771 times
-
Manage interactions
- 1:56
- Viewed 2737 times
-
Customising your Report
- 3:12
- Viewed 2685 times
-
Manage relations between data sources
- 2:37
- Viewed 2670 times
-
Add an alert to a visual
- 2:24
- Viewed 2654 times
-
What are measures?
- 2:58
- Viewed 2536 times
-
Creating a Report
- 2:54
- Viewed 8823 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3902 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3599 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3580 times
-
Recovering your Data from different sources
- 3:26
- Viewed 3579 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3568 times
-
Analyze your network and communication habits
- 2:17
- Viewed 3352 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3313 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3273 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3273 times
-
Creating your Datasets
- 2:26
- Viewed 3236 times
-
Customising your Visuals
- 2:58
- Viewed 3168 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 3099 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 3092 times
-
Improved version history
- 0:51
- Viewed 2828 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 2771 times
-
Customising your Report
- 3:12
- Viewed 2685 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2388 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2336 times
-
Check and share your form results
- 2:42
- Viewed 2169 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2128 times
-
Manage video settings
- 1:27
- Viewed 1892 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 1866 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 1344 times
-
Analyze Team Dynamics
- 1:19
- Viewed 707 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 308 times
-
Organize into Folders
- 01:57
- Viewed 135 times
-
Sort and filter emails
- 02:51
- Viewed 129 times
-
Process an incoming message
- 01:53
- Viewed 116 times
-
Manage Views
- 02:36
- Viewed 109 times
-
Clean Up Your Inbox
- 01:18
- Viewed 82 times
-
Easily Sort Your Mails
- 01:38
- Viewed 63 times
-
Use Categories
- 02:51
- Viewed 56 times
-
Action Function
- 04:18
- Viewed 21 times
-
Search Function
- 03:42
- Viewed 32 times
-
Date and Time Function
- 02:53
- Viewed 22 times
-
Logical Function
- 03:14
- Viewed 41 times
-
Text Function
- 03:25
- Viewed 29 times
-
Basic Function
- 02:35
- Viewed 20 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 32 times
-
Introduction to Power Fx
- 01:09
- Viewed 24 times
-
The New Calendar
- 03:14
- Viewed 47 times
-
Sections
- 02:34
- Viewed 23 times
-
Customizing Views
- 03:25
- Viewed 21 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 46 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 32 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 31 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 45 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 155 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 121 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 55 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 135 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 61 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 66 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 175 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 49 times
-
Share Power Automate Flows
- 02:20
- Viewed 51 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 56 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 56 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 58 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 78 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 52 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 128 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 157 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 107 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 101 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 77 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 54 times
-
Discover the “Build Space”
- 02:26
- Viewed 45 times
-
The Power Automate Mobile App
- 01:39
- Viewed 45 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 60 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 58 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 50 times
-
Access Power Automate for the Web
- 01:25
- Viewed 64 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 64 times
-
Add a third-party application
- 02:40
- Viewed 88 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 78 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 77 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 71 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 55 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 96 times
-
Share a document securely with Outlook
- 02:21
- Viewed 64 times
-
Block a sender
- 01:54
- Viewed 89 times
-
Identify a fraudulent email
- 02:06
- Viewed 63 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 57 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 77 times
-
Protect an email by encrypting
- 01:10
- Viewed 58 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 53 times
-
Recover deleted items
- 01:09
- Viewed 148 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 80 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 53 times
-
Use a Shared Mailbox
- 01:18
- Viewed 86 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 62 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 83 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 55 times
-
Calendar Delegation Setup
- 01:21
- Viewed 81 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 145 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 123 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 88 times
-
Create a Meeting Poll
- 02:48
- Viewed 81 times
-
Display Three Time Zones
- 01:52
- Viewed 55 times
-
View Other Calendars
- 00:50
- Viewed 78 times
-
Open a Shared Calendar
- 01:29
- Viewed 82 times
-
Share Your Calendar
- 01:54
- Viewed 82 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 67 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 62 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 62 times
-
Translate Emails in Outlook
- 01:32
- Viewed 72 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 59 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 81 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 58 times
-
Improve Email Accessibility
- 02:02
- Viewed 68 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 73 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 73 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 51 times
-
Delay Email Delivery
- 01:10
- Viewed 73 times
-
Use Conversation View
- 01:47
- Viewed 59 times
-
Clean Up Your Inbox
- 01:18
- Viewed 82 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 308 times
-
Use Categories
- 02:51
- Viewed 56 times
-
Easily Sort Your Mails
- 01:38
- Viewed 63 times
-
Automate Routine Actions
- 02:19
- Viewed 65 times
-
Create an Email Template
- 01:40
- Viewed 85 times
-
Create a task from a message
- 02:00
- Viewed 113 times
-
Share a task list
- 03:10
- Viewed 121 times
-
Create a task or reminder
- 01:50
- Viewed 124 times
-
Task Module Overview
- 01:56
- Viewed 148 times
-
Manage Teams online meeting options
- 01:56
- Viewed 122 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 208 times
-
Create a reminder for yourself
- 01:59
- Viewed 126 times
-
Respond to a meeting
- 01:00
- Viewed 128 times
-
Create an appointment or meeting
- 01:44
- Viewed 133 times
-
Create different types of events
- 01:46
- Viewed 136 times
-
Edit and customize views
- 01:55
- Viewed 141 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 140 times
-
Search options
- 01:23
- Viewed 115 times
-
Sort and filter emails
- 02:51
- Viewed 129 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 192 times
-
The Bcc Field in Detail
- 01:53
- Viewed 124 times
-
Save and Print a Message
- 01:48
- Viewed 139 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 170 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 129 times
-
Process an incoming message
- 01:53
- Viewed 116 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 145 times
-
Organize into Folders
- 01:57
- Viewed 135 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 123 times
-
Create and add a signature to messages
- 01:26
- Viewed 135 times
-
Manage new message notifications
- 01:40
- Viewed 116 times
-
Change the default font of your emails
- 01:05
- Viewed 120 times
-
Manage Views
- 02:36
- Viewed 109 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 164 times
-
Explore the Interface
- 03:22
- Viewed 122 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 129 times
-
Manage Storage Space
- 02:08
- Viewed 236 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 228 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 253 times
-
Make a File Request
- 01:24
- Viewed 254 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 234 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 244 times
-
Modify Sharing Rules
- 00:53
- Viewed 241 times
-
Check Granted Shares
- 00:48
- Viewed 229 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 248 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 215 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 241 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 250 times
-
Search for Documents
- 01:31
- Viewed 226 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 305 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 243 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 238 times
-
Edit, Delete a Share
- 02:16
- Viewed 295 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 238 times
-
Power and Manage OneDrive
- 01:36
- Viewed 229 times
-
What is OneDrive ?
- 01:14
- Viewed 435 times
Objectifs :
This video aims to demonstrate how to utilize various features in Query Editor to prepare a dataset for reporting in Power BI. It covers data importation, formatting, and manipulation techniques necessary for effective data analysis.
Chapitres :
-
Introduction to Query Editor
In this section, we will explore the functionalities of Query Editor in Power BI. The focus will be on preparing a dataset that consists of 704 rows, which will be used to generate a report. Often, imported data is not formatted correctly or is not ready for analysis. -
Importing and Preparing Data
To begin, we will import the dataset. A common issue is that the Country column may only have the first line of each section filled. To ensure Power BI can analyze sales by country, we will use the 'Fill Down' feature found in the Transform tab. -
Handling Null Values
After filling down, there may still be rows with null values in the header of each section. To remove these, right-click on a null value and select 'Does Not Equal' to delete it. Power BI will automatically detect the data type, such as number or whole number. -
Filtering Data
Since we are only interested in European sales, we will delete the rows that list US sales, which range from row 561 to row 700, totaling 140 lines. This can be done using either the 'Keep Rows' command or the 'Remove Rows' command. -
Selecting Relevant Columns
For our analysis, we will focus on the Month Number, Month Name, and Date columns. These can be selected by holding down the Ctrl key and clicking on the desired columns under the Home tab. -
Splitting Columns
To split a column into several columns, we can use the 'Split Column' command and choose 'By Delimiter.' Power BI will automatically detect the delimiter, or you can select one from the list. Alternatively, you can create new columns from existing ones using the 'Column From Examples' feature. -
Replacing Values
To change the manufacturing value of a product, select the cell with the value to be changed, then use the 'Replace Values' command under the Home tab. Enter the new value and confirm by clicking OK. -
Adding Calculated Columns
If a column for actual sales is missing, we can add it by naming the column and entering a formula that calculates actual sales by subtracting the discount value from the sales total. If errors occur in the formula, they can be corrected before confirming. -
Creating Conditional Columns
To indicate a gain, we will create a final column using the 'Conditional Column' command, which functions similarly to the IF function in Excel. We will set the condition to check if the Profit column is greater than 0, outputting 'Yes' for gains and 'No' otherwise. -
Finalizing the Dataset
Once all edits are made, we will apply the changes by clicking on 'Close & Apply' under the Home tab. It is important to note that most features in Query Editor can also be accessed by right-clicking with the mouse.
FAQ :
What is Query Editor in Power BI?
Query Editor is a tool in Power BI that allows users to transform and prepare their data for analysis. It provides various features to clean, reshape, and modify datasets before they are used in reports.
How do I import data into Power BI?
To import data into Power BI, you can use the 'Get Data' option on the Home tab. Select the data source you want to import from, and follow the prompts to load your dataset into Power BI.
What should I do if my imported data is not properly formatted?
If your imported data is not properly formatted, you can use the features in Query Editor to clean and transform the data. This includes filling down values, changing data types, and removing unnecessary rows.
How can I delete specific rows in Query Editor?
You can delete specific rows in Query Editor by using the 'Remove Rows' command. You can choose to remove rows based on their position or specific criteria.
What is the purpose of the Conditional Column feature?
The Conditional Column feature allows you to create a new column based on specific conditions. It functions similarly to the IF function in Excel, enabling you to categorize data based on defined criteria.
How do I calculate actual sales in Power BI?
To calculate actual sales in Power BI, you can create a new column that subtracts the discount value from the total sales. This can be done using a formula in the new column.
Quelques cas d'usages :
Sales Data Analysis
Using Query Editor to clean and prepare sales data for analysis in Power BI. This includes removing irrelevant rows, filling down missing values, and calculating actual sales to gain insights into sales performance.
Monthly Reporting
Preparing a monthly sales report by transforming the dataset to include only relevant columns such as Month Number, Month Name, and Actual Sales. This allows for efficient reporting and analysis of sales trends over time.
Data Quality Improvement
Utilizing Query Editor to enhance data quality by identifying and removing null values, correcting data types, and ensuring that the dataset is ready for accurate analysis and reporting.
Profitability Analysis
Creating a profitability analysis report by adding a Conditional Column to indicate whether sales resulted in a gain or loss. This helps businesses make informed decisions based on profit margins.
Data Transformation for Marketing Insights
Transforming marketing data to analyze the effectiveness of campaigns by filtering out irrelevant data, calculating actual sales, and preparing the dataset for visualization in Power BI dashboards.
Glossaire :
Query Editor
A tool in Power BI used for data transformation and preparation before analysis.
Dataset
A collection of data that is used for analysis and reporting.
Transform tab
A section in Query Editor where users can apply various data transformation operations.
Fill Down
A command used to fill empty cells in a column with the value from the cell above.
Data Type
The classification of data in a column, such as number, text, or date.
Remove Rows
A command used to delete specific rows from a dataset based on certain criteria.
Split Column
A feature that allows a single column to be divided into multiple columns based on a delimiter.
Conditional Column
A feature that creates a new column based on conditions, similar to the IF function in Excel.
Actual Sales
The total sales amount after deducting any discounts.
Discount Value
The amount subtracted from the total sales price.