Welcome to ONLC Training Centers

Excel Analytics & Power Classes

Microsoft Excel has features that bring advanced business analytics, business intelligence and publishing capabilities to average users. These features became available with version 2013 through the “Power” add-ins of Power Pivot, Power Query, Power View and Power Map.

With the BI (business intelligence) and business analytics tool in Excel, data science is no longer solely in the hands of the technical elite. Business analytics and business intelligence is now democratized for every Excel users with features including:

  • Get Data. Power Query lets you connect to public data or corporate data sources. Then it makes “data munging” and “data wrangling” easy by merging data from multiple sources and re-shaping and transforming data with repeatable steps.

  • Analyze. Power Pivot creates sophisticated data models with relationships, custom calculated fields, hierarchies, and KPIs that can analyze 100s of millions of rows of data with lightning-fast performance. After getting your data, use Power Pivot for Excel to put it all together in sophisticated data models.

  • Visualize. Power View lets you quickly create interactive reports, analytical views and dashboards.With Power Map for Excel you can perform geospatial explorations of your data by taking advantage of any data with location to plot across 3-D maps. Interact and story tell with this captivating map tool to see your data in new perspectives and unlock deeper insights.

  • Publish. Power BI publishes your reports making them available for your team. Colleagues can then access and interact with your reports in a browser, making it easier to consume data and unlock insights.


Instructor-led Training (ILT)

Click for FAQs about remote instructor-led training

ILT classes are live, hands-on classes led and supported by an online instructor. You'll do hands-on exercises throughout the class to ensure learning and can engage directly with the instructor at any point. Attend class from any of ONLC's hundreds of training centers click or from your own location click. Training is fully interactive no matter what class location you choose.

ONLC Value Adds

Work hands-on with the software for best learning

You get more with ONLC. Train with confidence knowing ONLC has a money-back satisfaction guarantee link plus the option to see the same class a 2nd time with our optional free refresher course link. These ONLC value-adds are available when students attend our public, instructor-led training (ILT) classes.

Group Training from ONLC

Save time and money bringing teams up to speed on Camtasia with our group training solutions. Instruction can be virtual or in-person with public or private sessions. We can even customize content to meet specific learning objectives, schedules and budgets. To learn more and for a price quote see Group Training .

Excel Analytics Classes & Schedule

Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
Excel Analytics
Excel PowerPivot and Interactive Visualizations 3 $1495
Power BI Tools: DAX Introduction 2 $995
Power BI Tools: Get and Transform Data (with M Programming) 1 $495

Looking for other Excel titles?
ONLC offers multiple levels of Excel training as well as Specialty titles. See more Excel classes.

 

Looking for more Data Analytics / Business Intelligence classes?
ONLC offers Business Intelligence / Data Analytics courses from a variety of vendors. See all Business Intelligence classes.

 


News & Offers

Call an ONLC Education Advisor for certification and course selection assistance

Education Advisors for Personal Guidance
Our Education Advisors can answer questions you may have about our classes and training options. Our Advisors can help you find training is right for your goals. ONLC's Education Advisors are available weekdays at our toll free number or via CHAT (icon on this page).

 

Train at any ONLC center

Hundreds of ONLC Centers Coast to Coast
We schedule every online instructor-led (ILT) class for each of our ONLC Training Centers locations. Our training rooms are outfitted with the equipment needed for training and provide an interruption-free space so you can concentrate fully on learning. Find an ONLC center near you click link.

 

Train at Home

Live Classes from Home
You can attend our live, instructor-led classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software. Follow our easy setup video click link. After viewing, if you're still not sure about the setup contact an ONLC Advisor toll free for assistance.

 

Group training available from ONLC

Group Training Option
ONLC offers complete learning solutions so training coordinators can quickly and successfully upskill their teams while maintaining their budget. Training can be via our public class schedule or private sessions delivered virtually or in-person on-site. We can also customize content to meet the client's specific needs and technologies. To discuss our group training options and to receive a price quote complete our quick Group Training Request form click link or call 1.800.288.8221 (weekdays).

 

spacer

For More Information

To register for class by phone or for more information contact our Education Advisors weekdays via the chat feature or by calling:

1.800.288.8221

 

Locations

ONLC Locations

District of Columbia

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com