Skip to content
Lagos CityComputer College
Microsoft CertificationsCertification PrepBeginner to IntermediateAdmission open

Microsoft Power BI Data Analyst (PL-300)

Prepare, model, visualise and share data with Power BI, and prepare for the PL-300 exam.

Programme duration, fees, schedules and entry requirements are being confirmed by the college. Please contact admissions for the latest information.

Programme overview

Power BI is one of the most in-demand skills for analysts in Nigeria and worldwide. This course takes you from raw spreadsheets to polished, interactive dashboards that decision-makers trust.

You will clean data with Power Query, build data models, write DAX measures, design clear reports, and publish and secure them in the Power BI service. Case studies cover sales, finance, HR and marketing data.

Who it is for

  • Accountants, finance and HR professionals
  • Marketing and sales analysts
  • Anyone who works with Excel reports and wants to do more

Recommended background

  • Confident Excel user
  • Basic understanding of business data

Curriculum

5 modules · 20 topics

Indicative curriculum. Final modules and schedule are confirmed at enrolment.

  1. 01Prepare the DataGet data clean and ready.
    • Connecting to Excel, databases and online sources
    • Profiling and cleaning data in Power Query
    • Transforming, merging and appending queries
  2. 02Model the DataDesign models that perform.
    • Star schema design and relationships
    • DAX calculated columns and measures
    • Time intelligence
    • Optimising model performance
  3. 03Visualise & AnalyseTell clear stories with data.
    • Choosing the right visuals
    • Report design, themes and accessibility
    • Drill-through, bookmarks and tooltips
    • AI visuals and identifying trends and outliers
  4. 04Deploy & MaintainShare securely and keep reports current.
    • Workspaces, apps and sharing
    • Row-level security
    • Scheduled refresh and gateways
    • Sensitivity labels and governance
  5. 05Exam Readiness & Practice TestsPrepare to sit PL-300 with confidence.
    • How the PL-300 exam is structured and scored
    • Question types: case studies, drag-and-drop and multiple choice
    • Timed practice tests with review of every answer
    • Personal study plan based on your weak areas
    • Booking the exam online or at a test centre

What you will be able to do

  • Clean and transform data with Power Query
  • Build efficient data models and write DAX measures
  • Design interactive, accessible reports and dashboards
  • Publish and secure reports in the Power BI service
  • Be ready to sit the PL-300 exam

Tools & technologies

  • Power BI Desktop
  • Power BI service
  • Power Query
  • DAX
  • Microsoft Excel

Career paths

  • Power BI developer
  • Data analyst
  • Business intelligence analyst
  • Financial or marketing analyst

Certification

Prepares you for Microsoft Certified: Power BI Data Analyst Associate (exam PL-300).

This is an exam-preparation course delivered by Lagos City Computer College. Certification exams are booked and taken separately through Microsoft, and exam fees are not included unless stated. Exam codes and skills measured follow Microsoft's published study guide at the time of delivery; Microsoft may update or retire exams, so confirm the current outline on Microsoft Learn before booking. Microsoft, Azure, Power BI and Power Platform are trademarks of the Microsoft group of companies; Lagos City Computer College is not affiliated with or endorsed by Microsoft unless stated.

Entry requirements

  • Specific entry requirements will be published once confirmed by the school.
  • Programme suitability depends on the individual course. Contact the admissions team for guidance.
Read the full admissions guide

Related programmes

  • Microsoft CertificationsBeginner
    Certification Prep Admission open

    Microsoft Azure Fundamentals (AZ-900)

    Learn core cloud concepts and Azure services, and prepare for the AZ-900 Azure Fundamentals exam.

    Learn more
  • Microsoft CertificationsBeginner
    Certification Prep Admission open

    Microsoft Azure AI Fundamentals (AI-900)

    Understand AI and machine learning concepts and Azure AI services, and prepare for the AI-900 exam.

    Learn more
  • Microsoft CertificationsBeginner
    Certification Prep Admission open

    Microsoft Azure Data Fundamentals (DP-900)

    Learn core data concepts, relational and non-relational data, and analytics on Azure, and prepare for DP-900.

    Learn more