Discover Classes. Earn Rewards.

Analyzing Data with Microsoft Power BI is unfortunately unavailable

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

Excel Introduction

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Gain the essential skills needed to create and format spreadsheets in Excel. Learn to enter data, use formulas, and format worksheets with ease in this comprehensive introductory course. Perfect for anyone looking to enhance their ability to create and manipulate basic spreadsheets.

(7) Beginner 18 and older

Power BI Introduction for Excel Users

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Learn how to easily transform and shape data from Excel into Power BI, create reports, and publish them on the Power BI cloud service in this comprehensive course designed for non-IT professionals. Gain essential Power BI skills and become proficient in analyzing data with Power BI Desktop and the Power BI service.

(7) Intermediate 18 and older
$795

2 sessions

Gift it!

Excel Database Features & PivotTables

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Master the essential Excel database features and learn how to create powerful PivotTables with this highly sought-after course. Don't miss your chance to gain valuable data management skills - register now to secure your spot!

(7) Intermediate 18 and older

Excel Workbooks, Formulas and Functions

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Master the essential skills of managing large worksheets, creating models, and working with financial, date, and logical functions in Excel with this popular course at ONLC Training Centers. Don't miss out on the opportunity to enhance your Excel skills - register now and secure your spot!

(7) Intermediate 18 and older

Microsoft Excel Level 1 - Introduction

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Learn how to create, modify, format, and print Excel worksheets and workbooks in this hands-on beginner class at Training Connection. Discover basic formulas and functions, manipulate data, and add charts to your spreadsheets. Ideal for those new to Excel who need to produce reports, budgets, and lists.

(158) Beginner 14 and older
See all Data Analyst classes Los Angeles

Analyzing Data with Microsoft Power BI

  • Beginner
  • 18 and older
  • $2,380
  • Virtual Class, Online, CA
  • 32 hours over 4 sessions

Start Dates (0)

  • $2,380
  • Virtual Learning @ Virtual Class, Online, CA 00000
  • 32 hours over 4 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this data analyst training:

This course will discuss 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 also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Who Should Attend

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 on both in the cloud and on-premises.

Course Objectives

After completing this course, students will be able to:

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI
  • Prerequisites

    In addition to their professional experience, students who take this training should have technical knowledge equivalent to the information found in the Azure Fundamentals course.

    Course Outline

    1 - GET STARTED WITH MICROSOFT DATA ANALYTICS

  • Data Analytics and Microsoft
  • Getting Started with Power BI
  • Tour and use the Power BI service
  • Power BI in the Enterprise
  • Knowledge Check
  • 2 - PREPARE DATA IN POWER BI

  • Get data from various data sources
  • Optimize performance
  • Resolve data errors
  • Knowledge Check
  • 3 - CLEAN, TRANSFORM, AND LOAD DATA IN POWER BI

  • Data shaping
  • Enhance the data structure
  • Data Profiling
  • Knowledge Check
  • 4 - DESIGN A DATA MODEL IN POWER BI

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies
  • Knowledge Check
  • 5 - CREATE MEASURES USING DAX IN POWER BI

  • Introduction to DAX
  • DAX context
  • Advanced DAX
  • Knowledge Check
  • 6 - OPTIMIZE MODEL PERFORMANCE

  • Using Variables
  • Fine-tune the data model
  • Optimize DirectQuery Models
  • Create and manage Aggregations
  • Knowledge Check
  • 7 - CREATE REPORTS

  • Design a report
  • Enhance the report
  • Knowledge Check
  • 8 - CREATE DASHBOARDS

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard
  • Knowledge Check
  • 9 - CREATE PAGINATED REPORTS IN POWER BI

  • Paginated report overview
  • Create Paginated reports
  • Knowledge Check
  • 10 - PERFORM ADVANCED ANALYTICS

  • Advanced Analytics
  • Data Insights through AI visuals
  • Knowledge Check
  • 11 - CREATE AND MANAGE WORKSPACES

  • Creating Workspaces
  • Sharing and Managing Assets
  • Knowledge Check
  • 12 - MANAGE DATASETS IN POWER BI

  • Parameters
  • Datasets
  • Knowledge Check
  • 13 - ROW-LEVEL SECURITY

  • Security in Power BI
  • Knowledge Check
  • Refund Policy

    For open enrollment classes, ten (10) business days' written notice is required to reschedule a class with no additional fees.

    In case of a no-show or a cancellation with less than ten (10) business days before class date: 100% of the class price will be due according to the date of original invoice or date of Term Net 30.

    Reviews of Classes at New Horizons Learning Group LA (1)

    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 23800 points. Points give you money off your next class!

    Questions & Answers (0)

    Get quick answers from CourseHorse and past students.

    New Horizons Learning Group LA

    New Horizons Learning Group has been serving businesses and individuals in the Arizona, California and Nevada communities for over 35 years. With ten convenient locations we offer a wide range of technical, application and business skills courses. As the world of computer technology continues to evolve...

    Read more about New Horizons Learning Group LA

    CourseHorse Approved

    This school has been carefully vetted by CourseHorse and is a verified Los Angeles educator.

    New Horizons Learning Group LA

    New Horizons Learning Group LA

    All classes at this location

    Before your course begins we will reach out to you and ensure your system is properly configured.

    Give This Course as a Gift Card

    • Thousands of classes
    • No expiration
    • Unique and memorable gifts for any occasion
    • Personalized
    • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
    • Instant delivery
    • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

    Buy a Gift Card

    Book this Class as a 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.

    CourseHorse Gift Cards

    • Creative & unique gift for any occasion
    • Thousands of classes & experiences
    • No expiration date
    • Instant e-delivery (or choose a date)
    • Add a personalized message
    • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
    Buy a Gift Card
    gift card with the CourseHorse logo gift card with the CourseHorse logo
    Loading...