Scribd
Upload
285 views3 pages

Power BI Boot Camp CES LUMS

This 24-hour Power BI boot camp over 2 weekends is designed for individuals seeking data/business analyst positions or wanting to enhance their skills in managing and presenting data using Power BI. The course will teach students how to source, transform, model and visualize data in Power BI to deliver actionable insights. Students will learn how to identify business requirements, clean and transform data, build data models, and create easy-to-understand visualizations and reports. Upon completing the course, students should be able to understand business needs, model data using Power Query and DAX, visualize and analyze data in dashboards and paginated reports, and publish online reports for collaboration. Assessments include labs, quizzes, and a final

Uploaded by

mahnoor javaid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
285 views3 pages

Power BI Boot Camp CES LUMS

This 24-hour Power BI boot camp over 2 weekends is designed for individuals seeking data/business analyst positions or wanting to enhance their skills in managing and presenting data using Power BI. The course will teach students how to source, transform, model and visualize data in Power BI to deliver actionable insights. Students will learn how to identify business requirements, clean and transform data, build data models, and create easy-to-understand visualizations and reports. Upon completing the course, students should be able to understand business needs, model data using Power Query and DAX, visualize and analyze data in dashboards and paginated reports, and publish online reports for collaboration. Assessments include labs, quizzes, and a final

Uploaded by

mahnoor javaid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Course Title Power BI Boot Camp

Course Length Total 24 Hours (Sat & Sun – 6 Hours a day) – 2 consecutive weekends

Target Audience  Individuals seeking Data/Business Analysts positions or existing employees to enhance skills in
managing and presenting data using the Power BI application.
 Individuals seeking to pass Microsoft Exam PL-300: Microsoft Power BI Data Analyst

Prerequisites (if any) Basic knowledge of working with data in spreadsheets and/or relational databases

Language of Instruction English / Urdu

Course Description

This Power BI Analyst course is specifically designed for individuals who play a crucial role in leveraging available data to deliver actionable
insights. Upon completion of this course, you will be able to collaborate with key stakeholders across departments within an organisation to
identify business requirements, cleans and transforms the data, and design, and build data models using Power BI, enabling report consumers
to make informed decisions through easy-to-comprehend data visualisations and self-service analytics.

This course can also help you pass the Microsoft Exam PL-300: Microsoft Power BI Data Analyst.

Course Learning Outcomes

By the end of this course, the students should be able to:

LO1: Understand business requirements. Identify challenges and roadblocks. Create a strategy and roadmap for final deliverables
promptly.

LO2: Source, transform and load data in Power BI.


LO3: Apply Power Query knowledge to model data.

LO4: Use DAX functions to create more complex measures.

LO5: Use the best visualisation to present and analyse data.

LO6: Upload, share and secure Power BI online reports with different teams in an organisation.

Assessments/Graded Components

 Class participation by asking questions and sharing ideas.


 Share real-world challenges from existing or previous job experience.
 Work as a team to deliver the final project of the CRM Sales Dashboard.

Course Summary

Lecture Module Name Essential Concepts/Topics Covered Assessments


/Day

1 Introduction to  Data Analyst job role and responsibilities Lab/Quiz


Data Analyst  Agile Project management lifecycle from requirements gathering to final deliverables.
job role and  Power BI components: Personal BI Desktop, Power BI Service and Power BI Mobile
responsibilities.  Power BI Desktop application walkthrough
Basic to  Data Discovery: Source data from popular data sources
Advance  Power BI online service use-cases
knowledge of
 Power BI online Workspaces, Datasets, Dataflows and Datamarts walkthrough
Power BI
 MS Teams integration with Power BI and collaboration
application

2 Model data  Power Query use cases. Lab/Quiz


using the Power  Model data using Power Query
Query and  Source and Transform data using Power Query
DAX  Combine, append and merge queries in Power Query
 Creating a custom calendar table for time-series analysis
 Basic to Advance DAX function use-cases
 Use DAX functions to create more complex measures

3 Visualise and  Dashboard Lab/Quiz


analyse the data  Paginated Reports
 Power Visuals and Custom Visuals
 Perform analytics in Power BI
 Work with AI visuals in Power BI

4 Power BI  Power BI online service Workspaces and Security Lab/Quiz


Online Service  Publish reports to online Power BI Workspace
 Power BI Apps
 Deployment pipelines
 Data refresh using gateways or cloud data sources.
 Dataflows vs Datamarts
 Power BI Service Administration
 Publish Power BI reports to Websites

Supplementary Reading Material

1. Microsoft Exam PL-300: Microsoft Power BI Data Analyst: https://learn.microsoft.com/en-us/certifications/exams/pl-300


2. https://pragmaticworks.com/
3. https://radacad.com/blog

You might also like