Skip to content
Play overlay
Preview this course

Microsoft Power BI Data Analyst: PL-300 Exam Preparation

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate

Uplatz

Summary

Price
Save 25%
£12 inc VAT (was £16)
Offer ends 28 February 2025
Study method
Online, On Demand What's this?
Duration
59.3 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
  • Uplatz Certificate of Completion - Free
3 students purchased this course

Add to basket or enquire

Overview

Uplatz provides this end-to-end course on Microsoft Power BI Data Analyst: PL-300 Exam Preparation. It is a self-paced course with video lectures. You will be awarded Course Completion Certificate at the end of the course.

What is Microsoft Power BI?

Microsoft Power BI is a powerful business analytics service from Microsoft. It helps you visualize data and share insights in an easy-to-understand way. Think of it as a toolbox for turning raw data into meaningful stories.

How does it work?

  1. Connect: Power BI connects to many data sources, like Excel files, databases, online services, and cloud platforms. It even handles real-time data.
  2. Transform: Clean, shape, and transform your data using Power BI's built-in tools to get it ready for analysis.
  3. Model: Define relationships between different datasets, creating a data model that reflects connections in your information.
  4. Visualize: Power BI offers many visualizations, from charts and graphs to interactive maps. You can create dashboards that bring your data to life.
  5. Share: Share reports and dashboards with others in your organization or publicly. You can embed them in websites or share them as interactive files.

Core Features of Power BI

  • Data Connectivity: Connect to many data sources, both on your computer and in the cloud.
  • Data Transformation: Clean and prepare your data with an intuitive interface.
  • Data Modeling: Create relationships between datasets and build data models.
  • Visualizations: A wide array of charts, graphs, maps, and visuals to represent your data.
  • Dashboards: Create interactive dashboards that provide a clear overview of key metrics.
  • Reports: Design detailed reports for analysis and printing.
  • Natural Language Querying (Q&A): Ask questions about your data in plain English.
  • Mobile Access: View reports and dashboards on any device.
  • Collaboration: Share and collaborate on reports with colleagues.
  • Security: Features to protect your data and control access.

Why is Power BI so popular?

  • Ease of Use: You can quickly learn to use Power BI's interface.
  • Powerful Features: It offers comprehensive tools for data analysis.
  • Flexibility: Connects to various data sources and supports different types of analysis.
  • Cost-Effectiveness: Offers a free desktop version and affordable cloud-based plans.
  • Strong Community: A large community provides support and resources.

Whether you're a business analyst, data scientist, or someone who wants to make better sense of their data, Power BI provides the tools to turn information into insights.

Key Outcomes of the Power BI course

  • Proficiency in Power BI for data preparation, modeling, visualization, and maintenance.
  • Practical knowledge of Power Apps, Power Automate, and Power Pages for business solutions.
  • Understanding Microsoft Fabric for data governance and integration.
  • Readiness for real-world projects and certification exams in Power BI and Power Platform.

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Curriculum

1
section
62
lectures
59h 21m
total

    • 1: Introduction to Data Analytics and Microsoft Power BI Preview 1:10:01
    • 2: Types of Data Analysis (PL-300 Focused) 1:07:44
    • 3: Microsoft Power BI - Detailed Documentation 1:02:49
    • 4: Microsoft Power Automate 56:43
    • 5: Microsoft Power Apps and Microsoft Dataverse 1:06:08
    • 6: Microsoft Fabric 1:00:47
    • 7: Prepare the Data - Getting Started 1:16:24
    • 8: Prepare the Data - Data Transformation 52:56
    • 9: Prepare the Data - Advanced Data Transformation 1:02:19
    • 10: Prepare the Data - Data Quality and Profiling (PL-300 Expert Guide) 1:02:31
    • 11: Prepare the Data - Combining Data from Multiple Sources (PL-300 Expert Guide) 57:06
    • 12: Model the Data - Introduction to Data Modeling (PL-300 Expert Guide) 59:40
    • 13: Model the Data - Data Modeling Best Practices (PL-300 Expert Guide) 1:01:19
    • 14: Model the Data - Calculated Columns and Measures (PL-300 Expert Guide) Preview 1:09:19
    • 15: Model the Data - Advanced DAX Calculations (PL-300 Expert Guide) 1:01:52
    • 16: Model the Data - Managing Data Security (PL-300 Expert Guide) 1:06:14
    • 17: Visualize and Analyze the Data - Introduction to Visuals (PL-300 Expert Guide) 55:54
    • 18: Visualize and Analyze the Data - Advanced Visualizations (PL-300 Expert Guide) 46:05
    • 19: Visualize and Analyze the Data - Visual Design Best Practices 1:04:57
    • 20: Other Visualizations - Gauge Charts, KPI Cards, Maps 1:14:07
    • 21: Advanced DAX - Text Operators 55:48
    • 22: Advanced DAX - Calculate, Filter, and All Functions 1:05:52
    • 23: Advanced DAX - Context Transition, Earlier, Variables 1:08:32
    • 24: Advanced DAX - Ranking, Cumulative Totals, Aggregations 1:09:02
    • 25: Advanced DAX - Calculated Tables, Model Optimization, and Security 1:10:25
    • 26: Part 1 - Combo Charts and Area Charts in Power BI 38:28
    • 27: Part 2 - Combo Charts and Area Charts in Power BI 34:00
    • 28: Scatter Plots and Bubble Charts 1:21:12
    • 29: Ribbon Charts and Waterfall Charts 1:15:59
    • 30: AI Visuals and AI Insights in Power BI 53:00
    • 31: Latest Power BI Updates and New Visuals 59:56
    • 32: Performance Tuning for Visuals in Power BI 53:09
    • 33: Tooltips, Bookmarks, and Drill Through 1:03:04
    • 34: Power BI Themes and Layout Design 1:03:28
    • 35: Real World Case Studies 52:49
    • 36: Power BI Interview Questions and Tips 56:30
    • 37: Introduction to Power BI Service Preview 1:02:07
    • 38: Managing Power BI Workspaces 53:08
    • 39: Power BI App Creation 49:40
    • 40: Power BI Premium Features 54:34
    • 41: Case Studies in Power BI Service 58:30
    • 42: Power BI Security Essentials 1:04:57
    • 43: Rare Power BI Premium Features 58:03
    • 44: Power BI Gateways - Introduction and Setup 59:47
    • 45: Advanced Power BI Premium and Data Automation 59:27
    • 46: Advanced Embedding and Custom Integrations 56:32
    • 47: SQL Skills for Power BI Developers 41:24
    • 48: Advanced SQL and Databricks Integration 46:55
    • 49: Data Transformation in Azure Databricks 55:45
    • 50: Data Analysis and Presentation using Excel Preview 48:44
    • 51: Cross-Functional Collaboration and Data Presentation 33:49
    • 52: Part 1 - Stakeholder and Client Management 43:57
    • 53: Part 2 - Stakeholder and Client Management 11:43
    • 54: Requirements Gathering and Analysis 1:01:21
    • 55: Networking on LinkedIn and Personal Branding 1:08:05
    • 56: Freelancing and Remote Job Opportunities 1:13:25
    • 57: Teaching Power BI and Building an Online Presence 52:22
    • 58: Job Search Strategies and Interview Preparation 50:49
    • 59: Microsoft Fabric for Data Integration 44:50
    • 60: Advanced Features in Microsoft Fabric 28:18
    • 61: Power Platform Essentials 47:48
    • 62: Advanced Power Platform and Career Growth 58:14

Course media

Description

Microsoft Power BI Data Analyst: PL-300 Exam Preparation - Course Syllabus

Phase 1: Introduction to Data Analytics & Power Platform

Lecture 1 - Lecture 6

  • Lecture 1: Introduction to Data Analytics

    • Overview of Data Analytics: History, importance, and applications
    • Roles in Data: Data Analyst, Data Engineer, Data Scientist, and Business Intelligence Developer
    • Latest Data Trends in 2024: Emerging technologies and their business impacts

  • Lecture 2: Types of Data Analysis

    • Descriptive, Diagnostic, Predictive, and Prescriptive Analytics: Definitions and use cases
    • Data Sources: Structured, semi-structured, and unstructured data
    • Introduction to Big Data: Understanding its impact on analytics

  • Lecture 3: Introduction to Power BI

    • What is Power BI: Overview and its role in modern data analytics
    • Power BI Architecture: Desktop, Service, Mobile, and Premium
    • Latest Features and Updates in Power BI (2024)

  • Lecture 4: Introduction to Power Automate

    • Overview of Power Automate: Basics of workflow automation
    • Integrating Power Automate with Microsoft 365 Tools
    • Practical Use Cases of Power Automate in Business

  • Lecture 5: Introduction to Power Apps and Dataverse

    • Power Apps: Creating low-code applications for businesses
    • Dataverse: Understanding its role in supporting the Power Platform
    • Connecting Power Apps to Dataverse and Building Scalable Apps

  • Lecture 6: Introduction to Microsoft Fabric & Course Scope

    • What is Microsoft Fabric: Data governance and integration platform
    • Integration of Microsoft Fabric with Power BI and Power Platform
    • Scope of the Course: How the topics fit into broader data analytics and business solutions

Phase 2: Power BI - Data Preparation, Modeling, Visualization & Maintenance

Lecture 7 - Lecture 36

Module 1: Data Preparation

Lecture 7 - Lecture 11

  • Connecting and cleaning raw data, handling missing values, advanced transformations using Power Query, and managing multiple data sources.

Module 2: Data Modeling

Lecture 12 - Lecture 16

  • Star schema, relationships, advanced DAX calculations, managing data security with Row-Level Security (RLS).

Module 3: Data Visualization and Analysis

Lecture 17 - Lecture 27

  • Building interactive visuals, implementing advanced analytics, creating KPIs and dashboards, optimizing performance, and exploring mobile reporting.

Module 4: Deployment and Maintenance

Lecture 28 - Lecture 36

  • Deploying reports, administering Power BI, managing governance and security, exploring Power BI Premium, API integrations, and real-world use cases.

Phase 3: Power Platform Applications and Microsoft Fabric

Lecture 37 - Lecture 60

Module 1: Power Apps

Lecture 37 - Lecture 38

  • Building and deploying apps, integrating with SharePoint and other data sources.

Module 2: Power Automate

Lecture 39 - Lecture 40

  • Automating workflows, building advanced approvals, troubleshooting flows.

Module 3: Power Pages

Lecture 41 - Lecture 42

  • Creating user-friendly websites, managing security, and embedding Power Apps.

Module 4: Microsoft Fabric

Lecture 43 - Lecture 44

  • Understanding data pipelines, governance, and integrating with Power BI.

Module 5: Advanced Power Platform Use Cases

Lecture 45 - Lecture 56

  • Multi-stage workflows, AI Builder, extending capabilities with custom connectors and Azure integrations.

Module 6: Real-World Projects and Exam Preparation

Lecture 57 - Lecture 60

  • Solving case studies, practice exams, interview preparation, and exploring career opportunities.

Who is this course for?

Everyone

Requirements

Passion and determination to achieve your goals!

Career path

  • Power BI Developer
  • Data Analyst
  • Business Intelligence Analyst
  • Business Intelligence Developer
  • Power Platform Consultant
  • Reporting Analyst
  • Dashboard Developer
  • Data Visualization Specialist
  • Analytics Consultant
  • Data Engineer
  • Power BI Administrator
  • BI Solutions Architect
  • Data Modeler
  • Business Analyst
  • Power BI Consultant
  • Data Consultant
  • Data Governance Analyst
  • Product Owner
  • Product Manager

Questions and answers

No questions or answers found containing ''.

Constantin asked:

hi, when does this course start?

Answer:

Hi, there are couple of courses already running and there is one that's going to start on 20th Oct. But, we can start a class as per your timing flexibility as all our classes are 1-1 live training so can decide a mutual timing. I would suggest go ahead and pay for the course, and we'll work out all logistics as per your convenience. Regards Indu Khemchandani Uplatz

This was helpful. Thank you for your feedback.
Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft courses, Analytics courses, Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.