Power BI: Business Intelligence with Excel

Course Description

Business Intelligence is a hot topic today: In an information driven society, analyzing and reporting upon the data that lives within an enterprise is crucial. Microsoft offers a lot of products that can help you setup your Business Intelligence infrastructure. In this course, we focus on Microsoft Power BI: Self-service BI, where we use the Power Query and Power Pivot functionality in Excel to collect, clean and enrich their business data. Then we create reports on top of this, using the native PivotTable functionality in Excel, as well as the Power View and Power Map reporting functionality which can be added to Excel 2013 and which is available out of the box in Excel 2016. We will also focus on how SharePoint and the cloud-based Power BI can be used as a delivery platform for both kinds of reports, making it possible to share these reports within a wider audience. The course contains many exercises, such that students will have a lot of hands-on experience with these tools.
Who Should Attend?
This course is intended for people who frequently use Excel to analyze their data and want to become familiar with the newest technologies to manipulate and query data in Excel. Also people who want to share their Excel reports in a more centralized manner via SharePoint or Power BI online will benefit from this course.

Course Content

 The need for Business Intelligence
 Self Service BI versus Enterprise BI
Loading data with Power Query
 Load public data in Excel
 Load online and offline data in Excel
 Filter, transform and clean data
Power Pivot
 Overview of Power Pivot in Excel 2010 and Excel 2013
 Installing Power Pivot
Power Pivot Data Sources
 Using SQL Server data
 Loading data from cubes
 Load data from text files
 Using data from Excel sheets
 Loading data via data feeds

Enriching data with DAX
 Creating computed columns
 Constant values and data types
 DAX operators
 Commonly used DAX functions
 Referencing other tables in DAX
 Row versus filter context
 Working with Time Intelligence
Building PivotTables on Power Pivot
 Building pivot tables on top of Power Pivot
 Using PivotCharts
 Working with Slicers
 Building custom sets
 Combine Power Pivot data with Sparklines
 Using CUBE functions in Excel
 Deploying PivotTables to Excel Services
Deploy Power Pivot to SharePoint
 Power Pivot in SharePoint: Prerequisites
 Publishing Power Pivot databases
 Deploying reports to Excel Services
 Using Excel Web Parts
 Accessing SharePoint Power Pivot databases in other reporting tools
Introduction Power View
 From personal BI to corporate BI
 Power View reports in Excel and SharePoint
Authoring Power View reports
 Create tables and Matrices
 From table to chart
 Interactive sorting, filtering and highlighting
 Working with buble charts
 Slicers, cards and multiples
 Adding maps to Power View

 Working with multi-view reports
 Improving Power Pivot models for Power View reporting
Deploying Power View reports
 Saving Power View reports in document libraries
 Power Pivot Gallery functionality
 Printing the report
 Export to PowerPoint functionality
Power Map
 Mapping geographical data
 Exploring visualization options
 Working with multiple scenes
Power BI Desktop
 Using Power BI Desktop
 Variables in DAX
 Bidirectional relationships
 New visualizations
Power BI in the cloud
 Getting started with PowerBI.com
 Creating Datasets
 Working with reports and dashboards
 Setting up the PowerBI Personal Gateway

Course duration: 3 days for 5 hours