Welcome to ONLC Training Centers
Welcome to ONLC Training Centers
Attend Excel for Business Analytics Training Classes at ONLC

Excel Analytics & Power Classes


Microsoft Excel has new features that bring advanced business analytics, business intelligence and publishing capabilities to average users. These features were available in Excel 2013 through the “Power” add-ins Power Pivot, Power Query, Power View and Power Map. In Excel 2016, these features are built-in.

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.

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


Attend hands-on, instructor-led training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from the convenience of your home/office PC via our Remote Classroom Instruction (RCI) technology.

EXCEL ANALYTICS CLASSES


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
Power Query in Excel Level 1 2 $995
Power Pivot in Excel Level 1 2 $995
Power View and Power Map in Excel Level 1 2 $995
Power BI and Power BI Desktop
Power BI Desktop Level 1 2 $995
Power BI Level 1 2 $995    
10989: Analyzing Data with Power BI 2 $1195
Data Mining and Business Analysis
55040: Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot 3 $1795    

 

Looking for other Excel classes?
ONLC offers Introduction through Programming with VBA classes in Excel. See more Excel classes at ONLC.

 

Looking for other Business Intelligence classes?
ONLC offers many Business Intelligence courses from a variety of vendors. See Business Intelligence classes at ONLC.

 


NEWS & OFFERS

 

Call our Education Advisors for certification and course selection assistanceEducation Advisors to Help You
Our advisors can answer questions you may have about classes and vendor certification programs to help you select the training that is right for you. For assistance, contact our Education Advisors toll free in the USA at 1.800.288.8221 (8am-5pm Eastern).

 

ONLC Training Centers has locations coast to coast
Training Locations Coast to Coast
ONLC Training Centers offers hands-on, remote instructor-led training classes at our more than 300 locations in North America. And for those not near one of our sites, you can attend these same live classes from your home/office computer via our Remote Classroom Instruction (RCI™). See list of ONLC locations.

 

For More Information
To register for class by phone or for more information...

1.800.288.8221

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