Power BI Fundamentals

Beginning 2 days

4.7/5

In this course you will learn

  • Data sourcing and transformation with Power Query Editor
  • Data modeling fundamentals
  • How to build visuals
  • About the Power BI Service

Included in this course

  • Hands-on exercises
  • Course manual

Suggested attendees

Business analysts. No previous experience required.

Choose Format

$199.00
$229.00
$249.00

Course Outline

  • Data sourcing and transformation with Power Query Editor
    • Introduction to Power BI Desktop with an end-to-end overview tour
    • Explore and explain Power BI data-sourcing basics
    • Expose the Query Editor environment and discuss its use in transforming data
    • Transform data using Power BI to meet common business needs
  • How to build visuals
    • Configure the PBI environment with themes
    • Build visuals
    • Enhance visuals with grouping and sorting
    • Filter visuals
    • Work with DAX
    • Create new columns and measures
    • Review drill behavior on visuals
    • Use tooltips
    • Add conditional formatting
    • Understand how to use bookmarks
    • Build data groups and bins
  • Data modeling fundamentals
    • Review data terminology
    • Understand relationships and create joins
    • Review cardinality
    • Filter data
  • About the Power BI Service
    • Introduction to the Power BI service environment
    • Explore and explain workspaces
    • Explore and explain datasets
    • Work with reports and dashboards

  • Payments by purchase order and invoice incur a $50 service fee.
  • Paying party will receive a payment confirmation email upon receipt of payment.
  • Each registered student will receive an email with the course details.
  • Students will receive electronic copies of the course materials and may print one hard copy for their personal use. The course materials are copyrighted and any other reproduction or distribution of these materials is strictly prohibited.

This class requires a local copy of Power BI Desktop. Download it for free

Instructor-led online

We recommend using two monitors to simultaneously view the training presentation and hands-on class work.

You’ll receive a Zoom link to join the class. We recommend using a headset instead of the computer’s microphone and speakers. You may also listen to the audio by phone.

Instructor-led online

  • 100% refund for cancellations made more than 10 days before the first class
  • 50% refund for cancellations made 5-9 days before the first class
  • No refund for cancellations made less than 5 days before the first class

Self-paced

  • Subscriptions start when payment is received
  • Full refund if cancelling within 24 hours of registration
  • $15 fee for cancellations after 24 hours of registration
  • No refund for cancellations after 15 days of registration
  • Shared subscriptions will be immediately deactivated and no refund issued

You may also be interested in

Power BI Creating Reports & Visualizations Beginning/Advanced

Learn more about this course