Learn how to turn mass quantities of data into meaningful information.
This Excel self-service BI certification that allows you to focus your skills in the area of Pivot Tables and PowerPivot functionality.
Transform your skills, data, and business and create your own BI solutions using software you already know: Microsoft Excel with the add-in functionality of PowerPivot.
Announcement: Microsoft has just released a NEW product - Power BI Desktop; therefore, this certificate will be modified, Spring 2016. The courses listed below reflect Excel for Business Analytics and will continue to be supported by Microsoft.
RoadMap to the Beginning Power BI Certificate
Learn how to transform your skills, data, and business and create your own business intelligence solutions using software you already know: Microsoft Excel. In this class, you will focus on real world scenarios, problem-solving, and data modeling. Learn how to turn mass quantities of data into meaningful information and on-the-job results.
Course Outline (DPT 7171)
Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! In this course, you will learn how Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, and finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot.
Course Outline (DPT 7172)
Power View and Map
Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Learn to harness the power of these two Microsoft’s self-service business intelligence tools to deliver compelling and interactive insight with remarkable ease.
Course Outline (DPT 7173)
Power BI Model
This is the last course of the Beginning Power BI Certificate. You will summarize the three Microsoft Power BI tools into one data model; maximizing the understanding and implementation of deploying a BI solution.
Course Outline (DPT 7174)