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.
- EDUCAUSE Partnership Opportunities
  EDUCAUSE has offered NERCOMP members access to some valuable discounted services through their partnerships with Prosci and Infosec.
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!
- 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
- Solutions Partner 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 Associates
  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 - Discover data analysis

Overview of data analysis
Roles in data
Tasks of a data analyst

2 - Get started building with Power BI

Use Power BI
Building blocks of Power BI
Tour and use the Power BI service

3 - Introduction to end-to-end analytics using Microsoft Fabric

Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Module assessment

4 - Get started with Copilot in Power BI

Use Copilot in Power BI to prepare and model data
Create reports with Copilot in Power BI
Get your data ready for AI usage in Power BI
Module assessment

5 - Get data in Power BI

Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors

6 - Clean, transform, and load data in Power BI

Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code

7 - Choose a Power BI model framework

Describe Power BI model fundamentals
Determine when to develop an import model
Determine when to develop a DirectQuery model
Determine when to develop a composite model
Choose a model framework
Module assessment

8 - Configure a semantic model

Configure relationships
Configure tables
Configure columns
Configure hierarchies
Configure measures
Configure parameters

9 - Write DAX formulas for semantic models

Understand DAX calculation types
Write DAX formulas
DAX data types
Work with DAX functions
Use DAX operators
Use DAX variables

10 - Create DAX calculations in semantic models

Create calculated tables
Create calculated columns
Understand implicit measures
Create explicit measures
Use iterator functions

11 - Use DAX time intelligence functions in semantic models

Use DAX time intelligence functions
Additional time intelligence calculations

12 - Create visual calculations in Power BI Desktop

Understand visual calculations
Create visual calculations
Use parameters in visual calculations
Module assessment

13 - Optimize a model for performance in Power BI

Describe semantic model optimization techniques
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations

14 - Scope report design requirements

Identify the audience
Determine report types
Define user interface requirements
Define user experience requirements
Explore designs in a Power BI report

15 - Design Power BI reports

Design the analytical report layout
Design visually appealing reports
Use report objects
Select report visuals
Apply filters and slicers to reports
Understand filtering techniques and considerations
Case study - Configure report filters based on feedback

16 - Enhance Power BI report designs for the user experience

Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use

17 - Perform analytics in Power BI

Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals

18 - Manage workspaces in Power BI service

Understand Power BI service
Understand workspaces
Publish to Power BI service

19 - Manage semantic models in Power BI

Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Boost performance with query caching (Fabric or Premium capacity)
Use lineage and impact analysis

20 - Choose a content distribution method

Understand sharing models
Create a Power BI app
Apply data governance principles
Track report or dashboard usage

21 - Create dashboards in Power BI

Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Set mobile view

22 - Secure data access in Power BI

Configure row-level security with the static method
Configure row-level security with the dynamic method
Use single sign-on (SSO) for DirectQuery sources
Restrict access to Power BI model objects

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