Microsoft Power BI Data Analysis Professional Training

Price
$1,895.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.

Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

What Is Included

  • Expert-Led Training – Learn from certified instructors with real-world Power BI experience
  • Hands-On Labs – Practice skills in live environments
  • 90-Day Access to Class Recordings – Revisit sessions on demand
  • Flexible Rescheduling – Adjust your plans if needed (conditions apply)
  • Guaranteed-to-Run Courses – We don’t cancel confirmed classes

Course Objectives

  • Analyze data and create reports with Power BI.
  • Connect to data.
  • Perform data cleaning, profiling, and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis by adding and customizing visual elements.
  • Model data with calculations.
  • Customize and filter visualizations.
  • Use advanced analysis techniques.
  • Share reports and create dashboards in the Power BI Service.
  • Manage and collaborate in the Power BI Service.
  • Enhance reports and dashboards.

Who Should Attend?

This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft® Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is the Microsoft Power BI Data Analysis Professional course?

This course teaches you how to harness Microsoft Power BI to turn raw data into powerful insights. You'll learn to connect to multiple data sources, model and transform data, and build compelling reports and dashboards.

Does the Microsoft Power BI Data Analysis Professional course prepare me for the certification exam?

Yes, this course thoroughly prepares you for the PL-300: Microsoft Power BI Data Analyst exam by covering all key exam objectives—including data preparation, modeling, visualization, and analysis. You’ll gain hands-on experience with real-world scenarios and tools, equipping you with the confidence and expertise to pass the exam and earn the Microsoft Certified: Data Analyst Associate certification.

How will this course help me build executive-ready dashboards?

You’ll learn how to connect to diverse data sources, shape the data, and use Power BI’s interactive visualizations to create clear, high-impact dashboards. These skills will enable you to present KPIs, trends, and business outcomes in a way that executives can quickly understand and act on.

Can this course help me automate monthly reporting workflows?

Yes—this course covers how to model and transform data so you can create dynamic reports that update automatically with new data. Instead of manually building reports each month, you’ll be able to refresh a Power BI dashboard and instantly deliver accurate, up-to-date insights.

Is Microsoft Power BI Data Analysis Professional worth it?

Absolutely. Power BI is one of the fastest-growing and most in-demand business intelligence tools in the market. Mastering Power BI not only sharpens your data analysis and visualization skills but also significantly enhances your career prospects. Professionals skilled in Power BI often command higher salaries—on average, data analysts with Power BI expertise earn 10–20% more than those without. This course equips you with practical abilities that make you indispensable for data-driven decision-making, helping you stand out and advance in your organization.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel.

Optionally, having experience with other data analytics tools, such as Google Analytics™ or Customer Relationship Management (CRM) systems such as Salesforce®, as well as a knowledge of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course.

Agenda

Lesson 1: Analyzing Data and Reporting with Power BI

  • Data Analysis and Visualization for Business Intelligence
  • Interact with Reports in Power BI

Connecting to Data

  • Create Data Source Connections
  • Configure and Manage Relationships
  • Save Files in Power BI
  • Secure and Troubleshoot Connections

Lesson 3: Cleaning, Transforming, and Loading Data

  • Load, Clean, and Shape Data with the Query Editor
  • Profile Data with the Query Editor
  • Shape Data with the Query Editor
  • Transform Data with the Query Editor

Lesson 4: Visualizing Data with Power BI

  • Create Visualizations with Power BI
  • Select Visualization Types with Power BI

Lesson 5: Enhancing Visuals for Data Analysis

  • Customize Visuals and Pages
  • Incorporate Tooltips in Visualizations

Lesson 6: Modeling Data with Calculations

  • Create Calculated Columns with DAX
  • Create Calculated Measures and Conditional Columns

Lesson 7: Customizing and Filtering Reports

  • Create Data Hierarchies
  • Filter Reports
  • Discover Time-Intelligence Insights
  • Configure Slicers for Interactive Filtering

Lesson 8: Performing Advanced Analysis

  • Create Calculated Tables, Variables, and Parameters
  • Perform Statistical Analysis
  • Analyze Data with Advanced Power BI Features

Lesson 9: Sharing Reports and Creating Dashboards in the Power BI Service

  • Publish and Explore Reports in the Power BI Service
  • Create Dashboards
  • Add Q&A to Dashboards

Lesson 10: Managing and Collaborating in the Power BI Service

  • Manage Workspaces and Share Content
  • Collaborate with the Power BI Service

Lesson 11: Enhancing Reports and Dashboards

  • Optimize Usability and Performance
  • Create Mobile Reports for Power BI
 

Upcoming Class Dates and Times

Oct 13, 14, 15
8:00 AM - 4:00 PM
ENROLL $1,895.00 USD
Dec 15, 16, 17
8:00 AM - 4:00 PM
ENROLL $1,895.00 USD
CourseID: 3604602E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons