Power BI - Preparing, cleaning and transforming your Data Tutorial

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
1382 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Duplicate a column

In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve to help you locate and access documents, collaborate with colleagues, and stay updated on the latest information.
This tutorial will provide you with the necessary skills to efficiently search for and find the documents you need within the Microsoft 365 environment.
This knowledge will enhance your productivity and ensure that you don't miss out on important updates and modifications made by your colleagues.

492 views

Excel - Sort your data

In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve to help you locate and access documents, collaborate with colleagues, and stay updated on the latest information.
This tutorial will provide you with the necessary skills to efficiently search for and organize your data in the Microsoft 365 environment, enhancing your productivity and workflow.

465 views

Excel - Create a PivotTable and analyze your data

In this video, you will learn how to create a PivotTable and analyze your data using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.
The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.
You can preview each recommendation to see how your data will look.
The video also shows how to format the numbers in the PivotTable as currency.
This tutorial will help you gain a better understanding of your data and make informed decisions.

1:35
1350 views

Excel - Delete columns

In this video, you will learn how to delete columns in Power Query using Microsoft 365. The video demonstrates the process of removing duplicate columns and unnecessary information.
By following the steps shown, you can easily remove unwanted columns and optimize your data.
This tutorial is a valuable resource for anyone using Power Query in Microsoft 365.

620 views

Excel - Introduction to Power Query

In this video, you will learn about the introduction to Power Query.
The video covers the Power Query tools and Power Pivot, which are complementary but often confused.
It presents a case where Power Query is used to reprocess and manipulate a file, removing duplicates, changing formats, and handling missing values.
The idea of Power Query is to automate these tasks, allowing you to retrieve data from various sources and apply automations to clean and format it.
This tool saves time and optimizes the process of reprocessing data.
This tutorial provides a brief introduction to Power Query and its benefits for solving data manipulation problems.

988 views

RELATED COURSES This tutorial is part of the following courses

Microsoft Power BI Video Training – Discovery

Dashboard, indicators (KPIs), activity tracking are part of your daily vocabulary? The Power BI business intelligence tool is your perfect companion for quickly delivering relevant visual data.

1854 vues

Analyze in depth your data with the Power BI desktop app

In this course, we will show you how to create relations with dashboards, how to create your own measures to process complex calculations, all with the help of DAX language (Data Analysis Expressions) and how to analyse them and any other data as well.

896 vues

ALL COURSES