Blog Archives

20778MOD: Analyzing Data with Power BI (On-Demand)

Information workers need access to more and more data in forms that expose new insights. This new form of data analysis is based on a variety of data sources both inside and outside the organization.  Microsoft’s Power BI desktop and the Power BI Service are becoming powerful tools for creating Business Intelligence solutions.  This course … Continue reading 20778MOD: Analyzing Data with Power BI (On-Demand)

20779MOD: Analyzing Data with Excel (On-Demand)

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

20778: Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, the Power BI Service, and the Power BI Mobile App.

20779: Analyzing Data with Excel

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Power Query Power Pivot Tables, Pivot Charts, the Excel Data Model, and Power BI.

PBIBC16: Power BI for Excel 2016 – Report Builders, Power BI Tools, Data Model Designers and DAX Functions

First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data … Continue reading PBIBC16: Power BI for Excel 2016 – Report Builders, Power BI Tools, Data Model Designers and DAX Functions

PBICRB16: Data Analysis using Power BI Desktop – Level 1 – Report Builder

This course lays the foundation for Power BI for the Cloud Report Builders. Power BI Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created by Power BI Data Model Designers. This course covers the use of both the Power BI Desktop application … Continue reading PBICRB16: Data Analysis using Power BI Desktop – Level 1 – Report Builder

PPBC2013: PowerBI for Excel 2013 – Report Builders, PowerBI Tools, Data Model Designers, and DAX Functions

First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data … Continue reading PPBC2013: PowerBI for Excel 2013 – Report Builders, PowerBI Tools, Data Model Designers, and DAX Functions