Power BI: Data Analytics and Data Preparation

Vente anticipée ! Débloquez plus de 10 000 cours de Google, Microsoft et autres pour 160 €/an. Économisez maintenant.

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Power BI: Data Analytics and Data Preparation

Ce cours fait partie de Spécialisation Exam Prep PL-300: Microsoft Power BI Data Analyst Associate

Instructeur : Whizlabs Instructor

Inclus avec Coursera Plus

3 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

9 heures à compléter

Planning flexible

Apprenez à votre propre rythme

3 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Intermédiaire

Expérience recommandée

9 heures à compléter

Planning flexible

Apprenez à votre propre rythme

Compétences que vous acquerrez

Catégorie : Data Modeling
Catégorie : Data Cleansing
Catégorie : Power BI
Catégorie : Data Visualization Software
Catégorie : Data Quality
Catégorie : Data Manipulation
Catégorie : Data Analysis
Catégorie : Data Import/Export
Catégorie : Business Intelligence
Catégorie : Data Transformation
Catégorie : Data Integration
Catégorie : Data-Driven Decision-Making
Catégorie : Analytics

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

juin 2025

Évaluations

8 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation Exam Prep PL-300: Microsoft Power BI Data Analyst Associate

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 3 modules dans ce cours

This course is designed to provide a comprehensive foundation in Microsoft Data Analytics, equipping learners with essential skills in Power BI for data-driven decision-making. Participants will begin by exploring data sources, understanding how to connect, manage, and optimize various datasets for analysis.

The course progresses to data cleaning techniques, ensuring accuracy and consistency in raw data before visualization. Learners will gain expertise in data types and data combining, enhancing efficiency in integrating multiple datasets. Additionally, the course covers data transformation principles, allowing participants to refine and manipulate data for advanced modeling and reporting. This course is structured into multiple modules, each featuring lessons and video lectures that provide theoretical insights and hands-on practice. Participants will engage with approximately 3:00–4:00 hours of instructional content, ensuring both conceptual understanding and practical application. To reinforce learning, graded and ungraded assignments are included within each module to test the ability of learners in real-world scenarios. Module 1: Microsoft Data Analytics: Exploring Power BI Data Sources Module 2: Data Cleaning Techniques in Power BI Module 3: Data Types and Transformation Techniques in Power BI At the end of the course, learners will learn - Understand key concepts of the PL-300 certification and the role of a data analyst. - Learn to acquire, clean, and transform data using Power BI tools. - Develop proficiency in Power BI’s interface, modeling, and visualization. - Learn to manage columns and reduce rows for efficient data cleaning in Power BI. - Apply sorting, splitting, and replacing values to enhance dataset organization. - Utilize filters, including text, numerical, and date-based, for refined data analysis. - Develop practical skills for transforming raw data into structured insights in Power BI. - Understand different Power BI data types and their applications in data processing. - Learn to merge, append, and integrate datasets using various query techniques. - Apply transformation techniques like grouping, transposing, pivoting, and unpivoting for structured analytics. - Develop practical skills in error handling, renaming, and optimizing data workflows in Power BI This course is for Data Analysts, Data Engineers, Power BI Analyst, and Power BI Experts

This module provides a comprehensive understanding of Power BI and data analytics, focusing on key concepts, tools, and exam preparation strategies for PL-300 certification. It emphasizes the principles of data-driven decision-making, data modeling, and visualization techniques, fostering a strong foundation for practical implementation. Participants will gain valuable insights into Power BI’s capabilities, installation, and user interface, enabling them to connect and transform data from various sources like Excel, CSV, and Web using Power Query Editor. The module also covers roles in the data world, responsibilities of a data analyst, and best practices for preparing for the certification exam. By the end of this module, learners will be equipped with the technical knowledge and skills required to navigate Power BI, analyze datasets effectively, and apply industry-standard practices for real-world data analytics solutions.

Inclus

15 vidéos2 lectures3 devoirs1 sujet de discussion

15 vidéosTotal 85 minutes

Introduction to PL-300 Certification6 minutesPrévisualiser le module
Exam Overview4 minutes
Introduction to Data Analytics9 minutes
Introduction to Power BI7 minutes
Get Started Building with Power BI8 minutes
Roles in Data World (The Data Team)5 minutes
Data Analyst (Roles and Responsibilities)5 minutes
Power BI - Download and Installation3 minutes
Uncovering Power BI User Interface5 minutes
Get Data from Excel in Power Bi4 minutes
Get Data from CSV in Power Bi2 minutes
Get Data from Web into Power BI2 minutes
What is Power Query Editor?4 minutes
Power Query Editor - Demo7 minutes
Module 1 Exam Tips6 minutes

2 lecturesTotal 50 minutes

Welcome to the Course20 minutes
Microsoft Data Analytics: Exploring Power BI Data Sources - Overview30 minutes

3 devoirsTotal 75 minutes

Microsoft Data Analytics: Exploring Power BI Data Sources - Graded Assignment30 minutes
Get started with Microsoft Data Analytics - Practice Assignment20 minutes
Power BI: Data Sources - Practice Assignment25 minutes

1 sujet de discussionTotal 10 minutes

Meet & Greet10 minutes

This module provides a comprehensive understanding of data cleaning techniques in Power BI, ensuring datasets are properly structured for analysis and visualization. Participants will explore managing columns, reducing rows, and applying sorting and filtering operations to refine data integrity. The module covers advanced transformation techniques, such as splitting columns, replacing values, and applying text, numerical, and date-based filters for enhanced accuracy. By the end of this module, learners will gain hands-on expertise in organizing, filtering, and preparing data efficiently within Power BI to drive better analytical insights.

Inclus

11 vidéos1 lecture2 devoirs

11 vidéosTotal 58 minutes

Cleaning Data in Power BI (Manage Columns) Part 14 minutesPrévisualiser le module
Cleaning Data in Power BI (Manage Columns) Part 23 minutes
Cleaning Data in Power BI (Reduce Rows) Part 15 minutes
Cleaning Data in Power BI (Reduce Rows) Part 26 minutes
Cleaning Data in Power BI(Sorting)3 minutes
Cleaning Data in Power BI (Split Column)6 minutes
Cleaning Data in Power BI (Replace values)3 minutes
Cleaning Data in Power BI (Filters)3 minutes
Cleaning Data in Power BI (Text Filters)8 minutes
Cleaning Data in Power BI (Numerical Filters)6 minutes
Cleaning Data in Power BI (Date Filters)7 minutes

1 lectureTotal 30 minutes

Prepare a machine learning solution - Overview30 minutes

2 devoirsTotal 60 minutes

Data Cleaning Techniques in Power BI - Graded Assignment30 minutes
Power BI: Data Cleaning - Practice Assignment30 minutes

This module provides a comprehensive understanding of Power BI data types, data integration techniques, and advanced data transformation strategies. Participants will learn to classify numerical, date, text, boolean, and binary data types, ensuring structured and optimized data processing within Power BI. Additionally, learners will explore data combination techniques, including merge queries, inner joins, and append queries, allowing for seamless integration across multiple datasets. The module further delves into data transformation principles, covering grouping, transposing, pivoting, unpivoting, and various row operations, helping users refine data models for accurate insights. By the end of this module, participants will have hands-on expertise in transforming raw data into structured formats, enabling effective analytics, reporting, and visualization within Power BI.

Inclus

16 vidéos1 lecture3 devoirs

16 vidéosTotal 90 minutes

Data Type in Power BI (Any Type & Numerical Type)6 minutesPrévisualiser le module
Data Type in Power BI (Date Type)4 minutes
Data Type in Power BI (Text Type, Boolean Type & Binary Type)5 minutes
Combining Data in Power BI (Merge Queries)3 minutes
Combining Data in Power BI (Merge Types)6 minutes
Combining Data in Power BI (Inner Join)5 minutes
Combining Data in Power BI (Append Queries)6 minutes
Combining Data in Power BI (Append Queries)- Demo6 minutes
Transform Data in Power BI (Introduction)3 minutes
Transform Data in Power BI (Group By)8 minutes
Transform Data in Power BI (Transpose)5 minutes
Transform Data in Power BI (Reverse Rows + Count Rows)3 minutes
Transform Data in Power BI (Rename Rows + Replace Errors)6 minutes
Transform Data in PowerBI (Pivot Column)6 minutes
Transform Data in Power BI (Unpivot Column)6 minutes
Difference between Transpose, Pivot and Unpivot4 minutes

1 lectureTotal 30 minutes

Data Types and Transformation Techniques in Power BI - Overview30 minutes

3 devoirsTotal 90 minutes

Data Types and Transformation Techniques in Power BI - Graded Assignment30 minutes
Configure collaboration and communication - Practice Assignment30 minutes
Power BI: Data Transformation - Practice Assignment30 minutes

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.

Instructeur

Whizlabs Instructor

Whizlabs

98 Cours68 677 apprenants

Offert par

Whizlabs

En savoir plus sur Data Analysis

Whizlabs
Power BI: Data Modeling and Data Analysis
Cours
Whizlabs
Power BI: Data Visualization and Analysis
Cours
Whizlabs
Power BI: Data Secure, Governance, and Workspace Management
Cours

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

Ouvrez de nouvelles portes avec Coursera Plus

Accès illimité à 10,000+ cours de niveau international, projets pratiques et programmes de certification prêts à l'emploi - tous inclus dans votre abonnement.

Faites progresser votre carrière avec un diplôme en ligne

Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne

Découvrir les diplômes

Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires

Améliorez les compétences de vos employés pour exceller dans l’économie numérique

Foire Aux Questions

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.