Carl H. Lindner College of BusinessCarl H. Lindner College of BusinessUniversity of Cincinnati

Carl H. Lindner College of Business
Business Analytics Training Header
MS Power BI

Creating Visibility into your Business with Microsoft PowerBI

March 1 & 2

Microsoft PowerBI is a business intelligence software rapidly gaining in popularity. Due to its comprehensive suite of data visualization and integration tools as well as its affordable pricing models, Gartner has ranked Microsoft PowerBI on par with Tableau in 2017.

The course is designed to be an introduction to Microsoft PowerBI and its use as a data analytics and reporting tool. There will be an even mix of lecturing and working sessions where the students will be developing their own dashboards with some sample data. The material will focus on the core building blocks of PowerBI including:

Day 1 (Beginner) – By the end of Day 1, students will be able to load data into PowerBI and create a fully interactive report based on simple calculations

  • Overview of PowerBI Service
  • Loading data into PowerBI
  • Creating simple visuals
  • Using PowerBI quick measures
  • Data viz design tips
  • Creating interactive reports with filters, cards, KPI’s and targets

Day 2 (Intermediate / Advanced) – By the end of Day 2, students will be able to model large datasets within PowerBI, generate dynamic dashboards, and deploy those dashboards for use in their business.

  • Data Modeling – table relationships, calculated fields, DAX measures
  • What-if scenarios
  • Forecasting tools
  • Using R within PowerBI
  • Sharing and Deploying Dashboards
  • Data Security
  • Final PowerBI Project

The course will be led by the Business Intelligence team of AMEND Consulting, a management consulting firm based in Cincinnati, OH.  

Course Fee: $750 includes breakfasts, lunches, refreshments and free parking for both days.

Course Location:
U-Square. Room 359
225 Calhoun Street
Cincinnati. OH 45219   (google map link)



Future Training                                                  

Python for Data Science Feb 22 & 23
Text Mining with R Mar 8 & 9, 2018
Data Management for Analysts TBD
Tableau Training May 14 & 15