20779 Analyzing Data with Excel

New Class  20779 Analyzing Data with Excel

You may attend in person or Online LIVE (you will be connected to the class happening live in NYC).

Where:

New Horizons Computer Learning Center
236 w 30th
6th Floor 
New York, NY 10001 
Click here for directions
or
Virtual via Online LIVE - you will be connected to the class happening live in NYC.

When: Wednesday, October 2, - Friday, October 4, 2019
9:00am - 5:00pm each day.

Workshop Organizer: New Horizons and NERCOMP

Registration Fee:
NERCOMP Member: $1,250 (30% off list price)
Non-Member: $1,785
Registration fee includes 3 days training and courseware.

​Class size is limited to 16 people.


Course Overview
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
 
Who Should Attend
This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Course Objectives

After completing this course, students will be able to: Explore and extend a classic Excel dashboard. Explore and extend an Excel data model. Pre-format and import an.CSV file. Import data from a SQL Server database Import data from a report. Create measures using advanced DAX functions. Create data visualizations in Excel. Create a Power BI dashboard with Excel.

 




Registration Cancellation Policy:
By clicking on the "Register Now" button, you are indicating a commitment to attend and will be held responsible for the registration fee. Your fee can be refunded if you notify us of a cancellation at least 12 business days prior to the event via email to nercomp@nercomp.org.

Event Disclaimer:
NERCOMP reserves the right to use any photographs or other mechanical recordings taken at NERCOMP events in promotional materials. No mechanical recordings of any kind may be used at NERCOMP events without the prior written consent of NERCOMP organizers and presenters. The views and opinions expressed at NERCOMP events do not necessarily reflect those of NERCOMP, nor does NERCOMP make any representation regarding the information presented at NERCOMP events.