Excel Analytics & Power Classes

• Classes
• News & Offers

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.