Microsoft Power BI Training

MS Power BI software logo

Microsoft Power BI is a business intelligence platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool t. A free version of Power BI is intended for small to midsize business owners; a professional version called Power BI Plus is available for a monthly subscription fee.

The following courses are offered. All courses can be customized and delivered at your location.

NEXT SCHEDULED MS POWER BI CLASSES


DATA VISUALIZATION CERTIFICATE OF COMPETENCY (3 Classes)

  • Data Visualization Principles and Concepts
  • Introduction to MS Power BI or Introduction to Tableau 
  • Advanced MS PowerBI or Advanced Tableau

To achieve a Certificate of Competency, all classes must be taken through the Center for Business Analytics.  In the event that professional experience meets the prerequisite for a class, another approved class may be substituted (limited to 1 class per Certificate of Competency)



Introduction to MS Power BI

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.

                                     Introduction to MS Power BI Course Outline
Day One   Day Two  

·       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

 

By the end of day one, students will be able to load data into PowerBI and create a fully interactive report based on simple calculations.

·       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

By the end of day two, students will be able to model large datasets within PowerBI, generate dynamic dashboards, and deploy those dashboards for use in their businesses.

 

4 online sessions

Online Course Fees: $495  ($595 starting Jan 1 2021)

These trainings can also be customized and delivered at your location.


Advanced MS Power BI

This course takes a deep dive into advanced level Power BI skills, covering lesser known but more advanced skills from the Power BI set of features. This course is a continuation of the "Introduction to Power BI" class or the following knowledge is recommended prior to taking this course: how to connect to data, how to build basic data models, basic PowerBI visualizations, and basic DAX knowledge. Desired Outcomes: • Create more sophisticated calculations and metrics using advanced DAX functionality • Improve the end user experience with various interactive reporting tools • Efficiently publish and deploy PowerBI reports across an organization

                                     Advanced MS Power BI Course Outline
Day One Day Two
 

Advanced Data Modeling with DAX

·       Running totals and moving averages

·       Filtered calculations and subtotals<

·       Calculated tables

·       DAX variables

·       Advanced time intelligence functions

Data Transformations in the Query Editor

·       Removing duplicates

·       Identifying errors

·       Merging queries

·       Conditional logic

·       Normalization

Spatial Analysis

·       ArcGIS maps

Integrating R with Power BI

Features for Interactive Reporting

·       Parameters and What-if Analysis

·       Action Buttons

·       Bookmarks

·       Drill-through

·       Power BI analyze distribution

·       Bookmarks

·       Report Themes

·       Power BI templates

Deployment and Security

·       Power BI free vs premium

·       Creating apps and workspaces

·       Reports vs dashboards

·       Data Gateways and Scheduled Refresh

·       Row-level Security

·       Dataflows (preview feature)

 

4 online sessions

Online Course Fee: $595

This training can also be customized and delivered at your location.


Data Visualization Principles and Concepts

Transform Data into Meaningful Insights

Data by itself is meaningless. Data visualization encompasses a set of techniques and principles that can be used to transform data at its most basic form into charts and tables that can be analyzed and presented to generate insights and spur action. This online or two-day in-person workshop will teach participants how to use data visualization to both analyze complex data sets to generate insights and to present analytical output as meaningful information. The course will cover data visualization best practices, design principles for creating effective data visualization, and leading software demonstrations (e.g. advanced Excel features, Tableau, R) to show participants how to effectively display and analyze complex data sets.  We will introduce interactive data visualization tools that can be used to explore data and to create exceptional opportunities for generating competitive advantage  This course is suitable for all levels of participants interested in learning more effective data visualization techniques.  .Access will be provided to any required data visualization software.

No prior experience required

4 online sessions

Online Course Fees: $495  ($595 starting Jan 1 2021)

These trainings can also be customized and delivered at your location.


POWER BI INSTRUCTOR : Gabe Welp

Gabe Welp photo MS Power BI Instructor

Gabe Welp, Senior Technical Analyst, Amend Consulting: 

Gabe specializes in Business Intelligence projects, and has implemented and developed enterprise-wide reporting solutions for a diverse group of companies spanning multiple industries. The majority of Gabe's Business Intelligence projects have relied heavily on Power BI. Gabe received his BA in Economics from Brown University. Gabe worked at The Kroger Co. in their finance group before joining AMEND in 2018.


DATA VISUALIZATION INSTRUCTOR: Jeffrey Shaffer

Image of Instructor Jeffrey Shaffer

Tableau Zen Master Jeffrey Shaffer is an expert in applying data visualization to create insights and competitive advantage. Mr. Shaffer is Adjunct Assistant Professor at the University of Cincinnati in the Carl H. Lindner College of Business where he teaches Data Visualization in the graduate course series for Data Analytics. He is a regular speaker at conferences, symposiums, universities and corporate training programs on the topic of data visualization, he writes for the data visualization blog at Data + Science and he was a finalist in the 2011 Tableau Interactive Visualization Competition. Mr. Shaffer also teaches data visualization at the KPMG Advisory University. Mr. Shaffer is Vice President of Information Technology and Analytics at Unifund. He joined Unifund in 1996 and has been instrumental in the creation and development of the complex systems, analytics and business intelligence platform at Unifund.Replace with your text


Testimonials

  • The essentials were covered.  The content was appropriate without being too slow.
  • Well versed and knew his stuff
  • Covered a lot of material in a short period of time.  Well done
  • Gabe is very knowledgeable and did a very good job presenting the material
  • Great class, relevant and very helping in enhancing my skills

For more information on these training courses or custom training, please contact
Headshot of Larry Porter

Larry Porter

Training , Marketing and Sponsorship Manager

513-556-4742