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 - Discover data analysis

Overview of data analysis
Roles in data
Tasks of a data analyst
Check your knowledge

2 - Get started building with Power BI

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

3 - 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
Check your knowledge

4 - 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
Check your knowledge

5 - Design a data model in Power BI

Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
Check your knowledge

6 - Add measures to Power BI Desktop models

Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge

7 - Add calculated tables and columns to Power BI Desktop models

Create calculated columns
Learn about row context
Choose a technique to add a column
Check your knowledge

8 - Use DAX time intelligence functions in Power BI Desktop models

Use DAX time intelligence functions
Additional time intelligence calculations
Check your knowledge

9 - Optimize a model for performance in Power BI

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
Check your knowledge

10 - Design Power BI reports

Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
Check your knowledge

11 - Configure Power BI report filters

Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
Check your knowledge

12 - 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
Check your knowledge

13 - 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
Check your knowledge

14 - Create and manage workspaces in Power BI

Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Check your knowledge

15 - Manage datasets in Power BI

Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity
Boost performance with query caching (Premium)
Check your knowledge

16 - 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
Configure a real-time dashboard
Configure data classification
Set mobile view
Check your knowledge

17 - Implement row-level security

Configure row-level security with the static method
Configure row-level security with the dynamic method
Check your knowledge

Become a Member

Complete the application for Institution Membership to start using NERCOMP member benefits now!

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