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

Carl H. Lindner College of Business
Business Analytics Training Header

Creating Visibility into your Business with Microsoft PowerBI

Feb 22 & 23, 2018

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: $695 (register before Dec 31, 2017) or $750 (starting Jan 1 2018) 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                                                  

Analytics In Excel Dec 14 & 15, 2017
Tableau Training Jan 25 & 26, 2018
Intermediate R Feb 8 & 9, 2018
Text Mining with R Mar 8 & 9, 2018