Skip to Main Content

Learn & Network
- Events Calendar
  Check out upcoming NERCOMP events & workshops.
- Annual Conference
  Our community of faculty, researchers, learners, and institutions come together to advance innovation and leadership in higher education.
- Submit A Session Idea
  Do you have an interesting idea or hot topic in the academic information technology field you can share with the NERCOMP community?
- On-Demand Content
  View a large library of previously recorded webinars and access presentations & handouts from past in-person workshops.
- New Horizons
  NERCOMP members save 30% off the list price for all New Horizons classes. This is a great opportunity to take advantage of numerous training and certifications at deeply discounted prices.
- Moodle
  NERCOMP members save 15% on the Moodle Educator Certification (MEC) program. It is a comprehensive teaching and learning curriculum designed to help you develop transferable knowledge and skills to be effective educators in today’s growing digital workplace.
- Canvas
  NERCOMP members save hundreds of dollars on the Canvas Certified Educator (CCE) program. Learn about best practices through this flexible, asynchronous facilitated 36-week program geared toward individuals in teaching roles, instructional design, and professional development/training positions at their institutions with basic familiarity with Canvas.
Membership
- Join Now
  Complete the application for Institutional Membership to start using NERCOMP member benefits now!
- Member Benefits
  Learn why so many institutions have taken advantage of NERCOMP membership for over 60 years.
- Fees & Information
  Discover more about membership requirements and fees.
- Member List
  See all the current participating member schools.
- IR Resources
  Use this Resource page to access information about your important role as an Institutional Representative.
Community
- Job Board
  Find new higher education positions and post jobs for free as a benefit of your NERCOMP membership!
- Leadership Ecosystem
  Learn more about what is happening with NERCOMP's Leadership community including past and upcoming webinars
- NERCOMP Mentorship Program
  The Mentorship Program offers members a platform to engage in ongoing learning and professional growth and highlighting our commitment to providing quality professional development opportunities and fostering a vibrant community of IT professionals.
- NERCOMP Awards
  The NERCOMP Awards Program recognizes the professional accomplishments of individual NERCOMP members.
Partners
- Licensing Agreements
  NERCOMP schools leverage their buying power for deep discounts and valuable warranties and protections.
- Become a Solutions Partner
  Interested in being considered for a three-year partnership agreement with NERCOMP?
- Corporate Partners
  Learn more about NERCOMP partnerships that bring professional development and other valuable expertise to our organization.
About Us
- Who We Are
  We are a professional society for University and Collegiate Information Technology professionals.
- Our Mission
  NERCOMP advances innovation and leadership in educational institutions across the Northeastern United States.
- Strategic Plan
  NERCOMP continually refines its strategic goals to remain relevant to higher education.
- News & Blog
  Featuring information and technology, strategic partnerships, innovation advances and leadership in educational institutions across the Northeast.
- Our History
  NERCOMP has been a pioneer in information technology and professional development for colleges and universities since the 1950’s.
- Our Board & Staff
  NERCOMP is governed by a Board of Trustees elected from NERCOMP member institutions.
- Bylaws
  NERCOMP’s bylaws outline the terms and conditions that govern the NERCOMP Inc. Corporation and its Board of Trustees.
- Committees
  Interested in volunteering your time and energy to help cultivate communities of practice?

Meetings Stub Page [mx-stub]

Course Outline

1 - DATA ANALYSIS IN EXCEL

Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis
Lab : Building a Classic Excel Dashboard

2 - THE EXCEL DATA MODEL

Create Calculated Columns
Format Data Model Data
Create Measures
Analyze the Data
Lab : Explore an Excel Data Model

3 - IMPORTING DATA FROM FILES

Importing Data into Excel
Shaping and Transforming Data
Loading Data
Lab : Importing Data from a CSV File

4 - IMPORTING DATA FROM DATABASES

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data
Lab : Import Data from Multiple Sour

5 - IMPORTING DATA FROM EXCEL REPORTS

Importing Data from Excel Reports
Transforming Excel report Data
Lab : Importing Data from a Report

6 - CREATING AND FORMATTING MEASURES

DAX
Measures
Advanced DAX Functions
Lab : Creating Measures using Advanced DAX Functions

7 - VISUALIZING DATA IN EXCEL

Pivot Charts
Cube Functions
Charts for Cube Functions
Lab : Data Visualization in Excel

8 - USING EXCEL WITH POWER BI

Power BI
Uploading Excel Data to Power BI
Power BI Mobile App
Lab : Creating a Power BI Dashboard with Excel

You are using an unsupported version of Internet Explorer. To ensure security, performance, and full functionality, please upgrade to an up-to-date browser.