Discover Classes. Earn Rewards.

Power BI for the Cloud - Level 3 - Advanced Languages is unfortunately unavailable

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

Qlik Sense Advanced

ONLC Training Centers @ Online Classroom

This class is an excellent course for all aspiring Qlik Sense® developers. It will take you through the basics, right through to the use of more advanced functions. Starting with a quick refresher on obtaining data from data files and databases, this class moves on to the more refined features of Qlik Sense®, including visualization, scripting, and set analysis. The tips and tricks provided will help you to overcome challenging situations while...

(7) Advanced 18 and older
$895

2 sessions

Gift it!

Tableau Desktop Level 1: Introduction for Experienced IT Professionals

ONLC Training Centers @ Online Classroom

Tableau has for some time been one of the most popular Business Intelligence and data visualization tools available. Why? Because, quite simply, it’s a tool that’s responsive to the needs of modern business. But it’s most effective when you know how to get what you want from it – it might make your business intelligent, but it isn’t going to make you intelligent. We’ll make sure you’re well prepared to take full advantage of Tableau's...

(7) Beginner 18 and older
$1,095

2 sessions

Gift it!

Administering a SQL Database Infrastructure

ONLC Training Centers @ Online Classroom

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. Prerequisites: In addition to their professional experience, students who attend this training should already have the following technical knowledge:...

(7) Advanced 18 and older
$2,975

5 sessions

Gift it!

Tableau Desktop Level 1: Introduction for Novice Users

ONLC Training Centers - Virtually Online

Unlock the power of data visualization with this introductory course designed for beginners. Gain hands-on experience with Tableau Desktop and learn essential skills to create impactful visualizations. Elevate your data analysis capabilities and transform numbers into actionable insights.

(7) Beginner 18 and older
$1,495

3 sessions

Gift it!

Alteryx Concepts - Level 1

ONLC Training Centers @ Online Classroom

This two-day instructor-led course is designed to give students a hands-on introduction to Alteryx Designer, an all-in-one self-service Business Intelligence solution for acquiring, transforming, visualizing and interacting with data. The course doesn’t assume any previous experience with Alteryx or any other Business Intelligence technology. By the end of the course, students will have had the opportunity to work with Alteryx designer and will...

(7) Beginner 18 and older
$1,195

2 sessions

Gift it!
See all Business Intelligence classes Online

Power BI for the Cloud - Level 3 - Advanced Languages

  • Advanced
  • 18 and older
  • $1,190
  • Interactive Online Classroom
  • 16 hours over 2 sessions
Power BI for the Cloud - Level 3 - Advanced Languages
Sold Out

Start Dates (0)

  • $1,190
  • 16 hours over 2 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this business intelligence training:

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. This course will also introduce students to the M-Language and how it can be used to make querying more effective. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers, and understand the importance of the M Language and its uses.

Pre-requisite(s): Power BI for the Cloud - Level 2 - Data Model Designer

Outline:

Lesson 1 : Power BI Functions – M Language
  • M Language vs DAX Functions 
  • Basic M Language Syntax 
  • Working with Columns 
  • IF Expression in M Language 
  • Query Cleanup
Lesson 2 : Basic DAX Functionality
  • Review of Calculated Columns 
  • Review of Measures 
  • Rules of Evaluation 
  • Evaluation Context 
  • Formatting DAX Code
Lesson 3 : Controlling Content & Values
  • Controlling Values - DAX 
  • M Custom Functions 
  • Error Handling
Lesson 4 : Context Control Functions
  • Iterative Functions 
  • FILTER Function 
  • ALL Function 
  • CALCULATE Function 
  • Additional Uses Of The ALL Function
Lesson 5 : Contexts In Relationships
  • Working With Many Tables 
  • Row Context & Relationships 
  • Elevated Calculated Columns 
  • Filter Context & Relationships 
  • Cross Filtering Issues
Lesson 6 : Advanced Concepts
  • Controlling Totals 
  • Parameter Tables 
  • Banding
Lesson 7 : Time Intelligence Calculations
  • Working With Date Tables 
  • Calculating Operating Periods 
  • Working With Missing Periods 
  • To-Date Functions 
  • Advanced Date Functions 
  • Prior Year Functions

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Reviews of Classes at TLG Learning (1)

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

TLG Learning

For over 20 years, TLG Learning has been trusted by premier companies and government agencies.

We provide complete learning solutions on Microsoft, F5 Networks, ITIL, Cisco, Citrix, CompTIA, VM Ware, Adobe, Project Management, Business Skills, and more.

During the past 3 years, 99% of over 10,000 TLG...

Read more about TLG Learning

CourseHorse Approved

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

TLG Learning

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