Harnessing the Power of Data with Power BI
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 16 hours
- Course by Microsoft
-
Offered by
About
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI. After completing this course, you’ll be able to: • Describe how data is produced and gathered in businesses and organizations. • Outline the role of data in creating data-driven decisions and successful business outcomes. • Classify key stages in the data analysis process. • Recognize the skills needed by a Power BI analyst and the tools they use. • List the tasks performed by a Power BI Data Analyst. • Recognize the components of Power BI. This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.Modules
Welcome to the course
-
1
Videos
-
6
Readings
-
1
Discussion
1
Discussions
- What do you hope to learn?
1
Videos
- Course introduction
6
Readings
- Course syllabus
- How to be successful in this course
- How to open an image in a new tab
- New name for Power BI datasets
- How to locate your downloaded files
- Additional resources: Welcome to the course
The role of the Data Analyst
-
3
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Self-review: Identifying stakeholders
- Knowledge check: The role of the Data Analyst
3
Videos
- What is the role of a Data Analyst?
- Roles working with data
- Essential data analyst skills
5
Readings
- Using data to solve a business problem
- Tasks of a data analyst
- Exercise: Identifying stakeholders
- Exemplar: Identifying stakeholders
- Additional resources: The role of the Data Analyst
Stages in data analysis
-
3
Videos
-
7
Readings
-
3
Assignment
3
Assignment
- Self-review: Stakeholder experience
- Self-review: Evaluating an analysis process
- Knowledge check: Stages in data analysis
3
Videos
- Gathering the right data
- Processing and analyzing the data
- How data insights drive business
7
Readings
- Sharing data insights
- Stakeholder experience
- Exercise: Stakeholder experience
- Exemplar: Stakeholder experience
- Exercise: Evaluating an analysis process
- Exemplar: Evaluating an analysis process
- Additional resources: Stages in data analysis
Introduction to Power BI
-
3
Videos
-
6
Readings
-
2
Discussion
-
3
Assignment
3
Assignment
- Self-review: Generate a visualization
- Knowledge check: Introduction to Power BI
- Module quiz: Data analysis in business
2
Discussions
- What key elements or visualizations stood out to you?
- Which areas of data analysis interest you most?
3
Videos
- Introduction to Power BI
- Analyzing data with Power BI
- Module summary: Data analysis in business
6
Readings
- Power BI Desktop, service and Mobile
- Setting up your Power BI environment
- Activity: How to view a report
- Exercise: Generate a visualization
- Exemplar: Generate a visualization
- Additional resources: Introduction to Power BI
Data Collection
-
2
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- Self-Review: Dataset
- Knowledge check: Data collection
2
Videos
- Identifying and evaluating required data
- Workflow in Power BI
3
Readings
- Exercise: Dataset
- Exemplar: Dataset
- Additional resources: Data collection
Introduction to the ETL process
-
3
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- Self-Review: Data storage and management
- Knowledge check: Introduction to the ETL process
3
Videos
- The ETL (Extract, Transform, Load) process
- Ingesting and gathering data
- Storing and managing data
3
Readings
- Exercise: Data storage and management
- Exemplar: Data storage and management
- Additional resources: Introduction to the ETL process
Introduction to transforming data
-
3
Videos
-
5
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-Review: Evaluating data for transformation
- Knowledge check: Introduction to transforming data
- Module quiz: The right tools for the job
1
Discussions
- What other business scenarios would require data transformation?
3
Videos
- Transforming and cleaning data
- What is Power Query?
- Module summary: The right tools for the job
5
Readings
- Cleaning at source in Excel
- Data transformed in Power BI
- Exercise: Evaluating data for transformation
- Exemplar: Evaluating data for transformation
- Additional resources: Introduction to transforming data
Final project and assessment: Harnessing the power of data in Power BI
-
1
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- Self-review: Product launch analysis
- Course Quiz: Harnessing the Power of Data in Power BI
1
Videos
- Course Recap: Harnessing the Power of Data
3
Readings
- About the final project and assessment: Harnessing the Power of Data in Power BI
- Exercise: Product launch analysis
- Exemplar: Product launch analysis
Wrap-up: Harnessing the Power of Data in Power BI
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Congratulations
1
Readings
- Next steps
Auto Summary
Unlock the potential of data with "Harnessing the Power of Data with Power BI." This foundational course, part of the Microsoft Power BI Analyst Professional Certificate on Coursera, focuses on data analysis using Power BI. Learn the role of a data analyst, key stages of data analysis, and essential Power BI skills. Ideal for beginners and those preparing for the Microsoft PL-300 exam. Duration: 960 minutes. Subscription: Starter. Perfect for aspiring data analysts.
Microsoft