Discover Classes. Earn 10% Rewards.

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

Thankfully we have 115 other IT Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel Level I: Fundamentals

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Build a confident foundation in Microsoft Excel through this practical workshop at Noble Desktop. You'll work with calculations, functions, charts, formatting, and print layouts to manage data and produce well-structured spreadsheets.

(452) Beginner 18 and older

Excel Level II: Intermediate

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Push your Excel skills past the basics with this intermediate course covering VLOOKUP, PivotTables, and more. At Noble Desktop, you'll build the working ability to manipulate and analyze data effectively for real reporting and analysis tasks.

(452) Intermediate 18 and older

Excel for Business Fundamentals

NYIM Training See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Maximize your everyday productivity with this focused course on Excel's most essential tools and functions. Through hands-on exercises, you'll gain a confident working command of the formulas, features, and workflows that business professionals rely on most, helping you work smarter and more efficiently from day one.

(750) Beginner 18 and older

Excel Bootcamp

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Gain comprehensive Excel expertise in this intensive three-day course that moves from foundational calculations through to advanced automation with macros. Whether you're building on basic knowledge or aiming for expert-level proficiency, this well-paced program covers the full range of tools and techniques that make Excel an indispensable asset in any professional setting.

(452) Beginner 18 and older
$599

3 sessions

Gift it!

Excel Specialist Certification Program

Noble Desktop See all classes by this school @ 185 Madison Ave, New York, NY & Virtually Online

Become an expert in Microsoft Excel and strengthen your resume through this comprehensive certification program. Get lifetime access to video courses, private training, and free proctored exams. Grow your skills and stand out in the competitive job market.

(452) All levels 18 and older
$959

3 sessions

Gift it!
See all IT classes NYC

Designing Data Models in Excel for Power BI Reports

  • Intermediate
  • 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!

  • 1601 Broadway, New York, NY
  • 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.

Similar Classes

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 NYC educator.

Loading...