Data Modeling and Dashboards Using Excel

Gain advanced skills to make effective data visualizations for reports and presentations using Microsoft Excel.

The ability to efficiently model data in spreadsheets and create dashboards to dynamically visualize that data is a highly sought-after skill in the workplace. In this program, you will enhance your skills by learning to use Excel's powerful data modeling and business intelligence tools; Power Query, Power Pivot, Power View and Power BI to make effective data visualizations for reports and presentations.

Working professionals
UB students
Non-UB students
Prior working knowledge of the data analysis and modeling tools found in our Introduction to Data Modeling using Excel course

Online
Self-paced

Non-credit-bearing (you will not earn university credit)
In addition to the micro-credential, you will receive a certificate of completion

Successfully complete Data Modeling and Dashboards using Excel Power Tools
Content is broken into five learning units. You must complete each unit assignment with a score of 80% or better
You may proceed at your own pace, but you must complete all five units within the required 10-week timeframe