Microsoft

Enjoy the best in Microsoft Power BI Data Analyst PL-300 Training

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Microsoft Power BI Data Analyst PL-300

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

Audience

1 - Discover data analysis

Overview of data analysis
Roles in data
Tasks of a data analyst
Check your knowledge

2 - Get started building with Power BI

Use Power BI
Building blocks of Power BI
Tour and use the Power BI service

3 - Get data in Power BI

Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Check your knowledge

4 - Clean, transform, and load data in Power BI

Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Check your knowledge

5 - Design a data model in Power BI

Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
Check your knowledge

6 - Add measures to Power BI Desktop models

Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge

7 - Add calculated tables and columns to Power BI Desktop models

Create calculated columns
Learn about row context
Choose a technique to add a column
Check your knowledge

8 - Use DAX time intelligence functions in Power BI Desktop models

Use DAX time intelligence functions
Additional time intelligence calculations
Check your knowledge

9 - Optimize a model for performance in Power BI

Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Check your knowledge

10 - Design Power BI reports

Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
Check your knowledge

11 - Configure Power BI report filters

Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study – Configure report filters based on feedback
Check your knowledge

12 - Enhance Power BI report designs for the user experience

Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
Check your knowledge

13 - Perform analytics in Power BI

Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
Check your knowledge

14 - Create and manage workspaces in Power BI

Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Check your knowledge
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Check your knowledge
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Check your knowledge

15 - Manage datasets in Power BI

Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity
Boost performance with query caching (Premium)
Check your knowledge

16 - Create dashboards in Power BI

Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Set mobile view
Check your knowledge

17 - Implement row-level security

Configure row-level security with the static method
Configure row-level security with the dynamic method
Check your knowledge

Prerequisites

Understanding core data concepts.

Knowledge of working with relational data in the cloud.

Knowledge of working with non-relational data in the cloud.

Knowledge of data analysis and visualization concepts.

DP-900 Microsoft Azure Data Fundamentals is recommended.

Toggle Filters

Want to run this course in-house?

Inquire about running this course in-house

None of these dates work for you?

Suggest another date & time

Get Certified in Microsoft Power BI Data Analyst-(PL-300)

Our award winning superior training solutions are designed to help you set effective business goals and attain measurable business outcomes. With return clients and multiple testimonials, we have established ourselves as a premier training solution provider for corporate teams across the globe, providing nothing less than the best corporate training in the marketplace.

Client Testimonials

Be wary of companies that pay external vendors to farm and post reviews, many of them are not authentic. Ours come straight from Google, you can’t alter reviews on Google Maps in any way. Don’t take our word for who we are – hear from our clients:

Jeremiah Hood

12/13/2021

Our organization hosted a CompTIA Security+ Boot Camp in December, conducted by ATA. We had a 100% pass rate for the certification exam. The instructor, Mr. Chaney was one of the best that I have seen in the business! The ATA Services Director, Ms. Pernaselci, and the ATA operations and support team were top notch, being adaptable to last minute changing needs. I highly recommend ATA for your organization's IT Workforce certification needs!

Becca Lynn

6/06/2021

J. Chaney came to JBPHH, HI to instruct us for the SEC+ cert. We attended class Monday thru Friday, and tested. J taught us more than what was on the certification test, and he was available to answer all of our questions. I couldn't have passed the cert without his expertise.

AlAmin Smith (Swizzkillz)

2/07/2022

So, I have used ATA for several bootcamps and they have all been great. All the instructors I have had have been excellent. The staff is helpful and responsive. I have asked if a class could record sessions for me and they have reached out to the professor to get that done. I can't wait for their new AWS offerings.

Sangwoo Lee

8/19/2021

Great prep for PMP exam.Dr. Salk is a great instructor. He is very engaging and presents material thoroughly.

Oscar A.

7/07/2021

Great Institution, they enrolled me very quick for a class. Thank you for supporting the military

john C.

7/07/2022

Great training and very knowledgeable instructors

Chad B.

7/07/2020

I can't say enough good things about Applied Technology Academy. I require CompTia Security+ for my current job and this is the place that I went through to get it. Kim Locke was my initial contact that scheduled my class and J Chaney was my instructor and both are complete professionals. The quality of the class was unbelievable and totally prepared me for my S+ exam. I was very nervous about taking the exam but about half way through it I realized that J had nearly over prepared the class for success which is definitely the position that you want to be in. Overall, this is a top notch operation and I highly recommend them.

Sangwoo L.

7/07/2022

Great prep for PMP exam. Dr. Salk is a great instructor. He is very engaging and presents material thoroughly.

Ginnette B.

7/07/2020

Great Institution, great instructors! Would highly recommend for anyone wanting to advance their IT knowledge and marketability.

Francisco G.

2/15/2022

The instructor and class were very direct, simple and to the point. Very interactive as well. I’m grateful to have been apart of this class & pass it.

Donna Johnson

12/09/2020

I would highly recommend this class for the level of detail and effective strategies provided in preparation in the PMP certification. The professor was outstanding; tackling specific approaches to each domain of project management.

Hey t.

2/07/2023

I had 0 computer knowledge or background going into the Security + class. J made it understandable and easily digestible. The classes were thorough and the study material was exactly what was needed to help prepare for the test. Cannot recommend this enough for people trying to get into the security field.

Brandon F.

7/07/2021

Eric is an amazing instructor. The class was very well informed and as someone who has been in this field for close to 14 years, I thoroughly enjoyed adding to my arsenal of tools. I especially like the option to view the class on recordings because for those of us deployed it’s extremely difficult for us to watch them live while on mission. Labs are ok, just wish there was more explanation to them from the lab material itself. The advantage of taking this course in a live classroom setting I’m sure. All in all I look forward to my CHFI class coming up Aug 17th. Thank you for all you guys do for us.

Ashish K.

7/07/2022

I really had good training experience from ATA and our instructor J Chaney. It was very through and knowledgable.

Jake Dean

12/18/2021

Awesome training, great supporting tools and aids. Kept me and my ADHD engaged while learning this great subject! This is my fourth class with Applied Technology Academy and I will continue to use them for my certification needs!

SEE ALL TESTIMONIALS

We offer more than just Microsoft Power BI Data Analyst (PL-300) Training

Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

STRATEGIC PLANNING AND PROJECT MANAGEMENT

From Lean Six Sigma to PMI Project Management Professional, Agile and SCRUM , we offer the best-in-class strategic planning and project management training available. We are here to train your team!

IT AND CYBERSECURITY

As the leading Offensive Security US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best cybersecurity and vendor driven IT training and certification courses to keep your team ahead of the technology skills curve.

LEADERSHIP AND MANAGEMENT

Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others, and build a culture that values communication, authenticity, and community.

Looking for Microsoft Power BI Data Analyst (PL-300) Training and Certifications?

And no, we will not relentlessly hound you with sales calls, we promise! Please reach out to us with any questions you might have. We welcome the opportunity to talk through your individual training needs, or that of your team. We are a no pressure, service oriented company. Reach out – you’ll be glad you did!