Discover Classes. Earn 10% Rewards.

Designing Data Models in Excel for Power BI Reports is unfortunately unavailable

Thankfully we have 1 other Tech Class for you to choose from. Check our top choice below or see all classes for more options.

Lightroom Classic in a Day

Capital Photography Center See all classes by this school @ 1201 K St NW, Washington, DC

Get faster and more confident in Lightroom Classic using its most powerful organizing and editing tools. Build a complete digital workflow covering importing, organizing, and precise color, tone, detail, and retouching adjustments. Practice masking, black-and-white conversions, noise reduction, sharpening, and clean exports.

(25) All levels 16 and older
$159
Attend
+1590 pts
Gift it!
See all Tech classes Washington, D.C.

Designing Data Models in Excel for Power BI Reports

Learn how to transform and present sophisticated data for business intelligence using Power BI and Excel in this comprehensive course. Discover how to import, cleanse, merge, and analyze data to create powerful data models and interactive reports that empower informed decision-making. Enhance your data skills and communication abilities with this practical and flexible training.

  • Beginner
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 13650 Dulles Technology Dr, Herndon, VA
  • 22 hours & 30 minutes over 3 sessions

Start Dates (0) $2,650/person

  • Course 1362

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

This course focuses on designing BI Data Models to display in either an interactive Power BI report or an interactive Excel dashboard. This is both a fundamental Power BI course and an advanced Excel course that will take you through a data journey from importing, cleansing, and merging large amounts of data to analyzing the data to presenting strategic data in a PivotTable and a Power BI dashboard. This practical course provides flexibility and empowers you to choose how you want to present your business insights to help management make informed decisions.

Data Models in Excel for Power BI Course Benefits

  • Transform and present sophisticated data to provide Business Intelligence (BI)
  • Actualize a data model from multiple sources with Power Pivot
  • Shape and prepare your data with Power Query
  • Mine and expose hidden information with Data Analysis eXpressions
  • Communicate business and data insights with Power BI reports and dashboards
  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

Prerequisites

  • Experience with Excel at the level of:
    • Excel Data Analysis Course • course 195
  • This course is applicable to all versions of Excel, from Excel 2010 to Excel 2021

Course Outline:

  • Module 1: Identifying the Role of Power Pivot in Business Intelligence (BI)
  • Module 2: Building the Data Model with Power Pivot
  • Module 3: Shaping Data with Power Query
  • Module 4: Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language
  • Module 5: Designing Interactive Power BI dashboards

Refund Policy

If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to 3 weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

  • If a customer transfers to another course prior to 3 weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.
  • If a customer needs to cancel an enrollment 3 weeks prior to the start of the class or within seven days of registration, we will refund 95% of any prepaid course tuition for that enrollment.
  • If a customer does need to transfer or cancel a course within 3 weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances.

Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 26500 points. Earn 10% back in reward points!

Learning Tree International

Learning Tree International is a leading provider of IT and management training to businesses and government organizations worldwide. They offer a wide range of courses, personalized services, and implementation workshops to enhance the knowledge and skills of over 2.4 million IT professionals.

View school profile
Learning Tree International
Vetted by CourseHorse

A verified Washington, D.C. educator.

Loading...