Discover Classes. Earn 10% Rewards.

Power BI for Excel 2016 - Level 1 - Report Builders is unfortunately unavailable

Thankfully we have 17 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

Attend
+8950 pts
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

Attend
+10950 pts
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

Attend
+29750 pts
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

Attend
+11950 pts
Gift it!

Alteryx Concepts - Level 2

ONLC Training Centers @ Online Classroom

Enhance your Alteryx Designer skills and dive deeper into data extraction, transformation, and loading with Alteryx's In-DB tools. Join this instructor-led course and discover the powerful features that will take your data analysis to the next level. Ideal for BI professionals and technically proficient business users.

(7) Intermediate 18 and older
$595
Attend
+5950 pts
Gift it!
See all Business Intelligence classes Online

Power BI for Excel 2016 - Level 1 - Report Builders

  • Intermediate
  • 18 and older
  • $495
  • Earn 4,950 reward points
  • Interactive Online Classroom
  • 8 hours
Power BI for Excel 2016 - Level 1 - Report Builders
Sold Out

Start Dates (0)

  • $495
  • 8 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this business intelligence training:

This is the first course in TLG Learning’s exclusive Power BI for Excel 2016 training series. This course lays the foundation for all Power BI for Excel Designers. It is the first of several courses an Advanced Power BI Designer would require. Power BI Report Writers will learn everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. Topics covered include an overview of the PowerPivot add-in, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations.

Audience: This class was created for users needing to create intuitive and dynamic data visualizations, users needing to extend the capabilities of PivotTables, and business intelligence professionals with experience using Excel for analysis.

Pre-requisite(s): Excel levels 1 & 2, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.

Outline:

Lesson 1 : Introducing PowerPivot
  • What Is Power BI for Excel? 
  • What is PowerPivot? 
  • Power BI for Excel Key Features
  • Self Service BI Model
  • PowerPivot Components
Lesson 2 : Defining a Report
  • What is a PowerPivot Report? 
  • Defining a Report 
  • Data-Driven Storytelling
Lesson 3 : Understanding PowerPivot Data
  • Understanding Data Terminology 
  • Understanding Tables 
  • Relationships 
  • Diagnosing Data Models 
  • Data Model Schemas
Lesson 4 : Create Reports using PowerPivot Data
  • Making Changes to PowerPivot Data 
  • Creating PowerPivot PivotTables 
  • Creating PowerPivot PivotCharts 
  • Creating Slicers 
  • Graphing Data
Lesson 5 : Understanding PowerPivot Functions
  • Calculated Columns 
  • What is DAX? 
  • Understanding DAX Functions 
  • Common DAX Functions 
  • Dates and Date 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 4950 points. Earn 10% back in reward points!

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