Excel BI Tools: DAX Formulas for Dynamic Tables is unfortunately unavailable

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

Excel BI Tools: DAX Formulas for Dynamic Tables

at ONLC Training Centers - Financial District

(5)
Course Details
Price:
$995
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Financial District, Manhattan
40 Wall St 28th Fl
Btwn Nassau & William Streets
New York, New York 10005
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this microsoft training:

This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement.

This course covers essential information needed for DAX-related reporting requirements. Specifically, it leverages the DAX language, teaching how to build models that extend the capabilities Power BI, Excel, or SQL Server Analysis Services. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time intelligence calculations.

Software Used During the Class

This class is for users of either Power BI, Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar DAX-related interface, the course will be taught using the Excel software. Users of Power BI and SQL Server should have no problems with the slight differences between products.

Audience

This course is aimed at Excel power-users, Power BI users who have a need to create dynamic reports that are based on the Excel / Power BI Data Model. Our Essential Data Preparation Skills for Data Mining course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server. For details on this companion course, go to
Essential Data Preparation Skills for Data Mining Using Power Query and M 

Prerequisites

While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either our "Analyzing Data with Power BI" or "Excel BI Tools" class or have similar experience.

Course Outline

DAX Functionality Review

Review Of Calculated Column
PivotTable Function
Review Of Measure
Rules Of DAX Measure
Evaluation Context
Formatting DAX Code

Controlling Content & Values

Controlling Values
Switch Function
Error Handling

Context Control Functions


Filter Function
All Function
Iterative Functions
Earlier Function
Calculate Function
Additional Uses Of The All Function

Contexts In Relationships


Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Values Function

Advanced Concepts

Circular Dependencies
Controlling Totals
Advanced Hierarchy Concepts

Time Intelligence Calculations

Working With Date Tables
Calculating Operating Periods
Working With Missing Periods
DAX Date Functions
Advanced Date Functions
Prior Year Functions
Moving Averages

Appendix : DAX Dashboard Techniques

Parameter Tables
Banding
Ranking
Advanced Slicer Techniques

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

28th Floor with WorkBetter

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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 9950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

165 Top Choices

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate Microsoft Excel 2016 Class Overview The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal...

Monday Oct 14th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Beginner Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel Training Course Overview - Level 1 The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel...

Wednesday Oct 16th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Intermediate Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Intermediate Excel for Business Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database...

Tuesday Oct 15th, 10am - 5pm

Microsoft PowerPoint

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This training will cover the basic to advance functions of Microsoft PowerPoint. You will learn how to create a presentation that is visually appealing to an audience, by adding graphical objects, color themes, charts, pictures, customize texts, and a variety of slide effects. This is a great course for anyone looking to learn PowerPoint for the...

Monday Oct 21st, 10am - 6pm

Intermediate SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep,...

Wednesday Oct 23rd, 9am - 5pm

Beginner SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Beginner SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class. Our SQL courses are taught in our state-of-the-art...

Wednesday Oct 16th, 5:50pm - 9:20pm

  (2 sessions)
$325

2 sessions

Excel Programming with VBA

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase...

Tuesday Oct 29th, 9am - 5pm

  (2 sessions)
$595

2 sessions

Excel for Business Fundamentals

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial...

Friday Oct 18th, 10am - 5pm

Excel for Mac Level 1

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Mac covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate...

Wednesday Oct 16th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Microsoft Excel Expert (Level 3)

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Tuesday Oct 15th, 10am - 6pm

Advanced Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Advanced Excel for Business Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions,...

Wednesday Oct 16th, 10am - 5pm

Microsoft Word 2010 for Beginners

at The New York Public Library - Bronx 1701 Martin Luther King, Jr. Blvd., Bronx, New York 10453

Learn the basic features of Microsoft Word 2010, a word processing program you can use to create documents.  Topics include: entering and editing text, saving files, and various formatting options.

Thursday Oct 17th, 11am - 12:30pm

Free

PowerPoint for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

PowerPoint Classes NYC PowerPoint for Business Hands-on Training The PowerPoint class concentrates on the most common topics we see NYC businesses using on a daily basis. When you are finished with this class you will be able to create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, deliver a presentation...

Tuesday Oct 29th, 10am - 5pm

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Course. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our Small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.  This is a great course for...

Wednesday Oct 23rd, 10am - 6pm

Beginner Microsoft PowerPoint 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft PowerPoint Beginner Training Course Overview It's hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream...

Tuesday Oct 29th, 10am - 5pm

Advanced SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Advanced SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and...

Thursday Oct 24th, 9am - 5pm

MS PowerPoint 2010 for Beginners

at The New York Public Library - Fordham Heights 310 E Kingsbridge Rd, Bronx, New York 10458

Learn how to create a slideshow presentation using Microsoft PowerPoint 2010.  Topics include creating and editing slides, inserting images and clipart, and running your slideshow.

Friday Oct 18th, 2pm - 4pm

Free

Intermediate Excel: Formulas & Functions

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and...

Monday Oct 28th, 6:30pm - 9:30pm

Powerpoint for Mac

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The PowerPoint class concentrates on the most common topics we see NYC businesses using on a daily basis. When you are finished with this class you will be able to create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, deliver a presentation without difficulty, feel comfortable with importing slides from...

Tuesday Oct 29th, 10am - 5pm

Excel VBA Macros Level I

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel VBA Macros Level I Class Overview Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is...

Tuesday Oct 29th, 9am - 5pm