Course HighlightsCOURSE
Analyzing and Visualizing Data with Power BI

Analyzing and Visualizing Data with Power BI

Learn Power BI, a powerful cloud-based service that helps data scientists visualize and share insights from their data.

Analyzing and Visualizing Data with Power BI Highlights

Course Enrollment

Starts on

15 April 2019

Enrollment closes on
30 September 2019

  Course duration

Duration

  • Total 12 to 24 hours
  Course Fee

Fee

US$89 - US$149

Course Enrollment

Starts on

15 April 2019

Enrollment closes on
30 September 2019

Course duration

Duration

  • Total 12 to 24 hours
Course Fee

Fee

US$89 - US$149

Enrollment is Closed

About this course

This course is part of the Microsoft Professional Program Certificate in Data Science, Microsoft Professional Program Certificate in Big Data and the Microsoft Professional Program for Data Analysis.

Power BI is quickly gaining popularity among professionals in data science as a cloud-based service that helps them easily visualize and share insights from their organizations' data.

In this data science course, you will learn from the Power BI product team at Microsoft with a series of short, lecture-based videos, complete with demos, quizzes, and hands-on labs. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Plus, learn to create dashboards and share with business users—on the web and on mobile devices.

What you'll learn

  • Connect, import, shape, and transform data for business intelligence (BI)
  • Visualize data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop and Excel
  • Use natural language queries
  • Create real-time dashboards

Prerequisites

Some experience in working with data from Excel, databases, or text files.

Course Syllabus

Week 1
  • Understanding key concepts in business intelligence, data analysis, and data visualization
  • Importing your data and automatically creating dashboards from services such as Marketo, Salesforce, and Google Analytics
  • Connecting to and importing your data, then shaping and transforming that data
  • Enriching your data with business calculations
Week 2
  • Visualizing your data and authoring reports
  • Scheduling automated refresh of your reports
  • Creating dashboards based on reports and natural language queries
  • Sharing dashboards across your organization
  • Consuming dashboards in mobile apps
Week 3
  • Leveraging your Excel reports within Power BI
  • Creating custom visualizations that you can use in dashboards and reports
  • Collaborating within groups to author reports and dashboards
  • Sharing dashboards effectively based on your organization’s needs
Week 4
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services
  • Introduction to Power BI Development API
  • Leveraging custom visuals in Power BI

Meet the instructors

Will Thompson

Will Thompson

Program Manager, Power BI
Microsoft

Will is a self-confessed data geek, working his way through sysadmin and DBA roles before joining Microsoft. He spent 5 years helping customers in the UK implement and get value out of Microsoft's BI solution. When an opportunity arose to move into the engineering world he jumped at it, and now helps translate customer and market requirements into new features as a Program Manager in the Power BI team.

Jonathan Sanito

Jonathan Sanito

Senior Content Developer
Microsoft

Jonathan works as a content developer and project manager for Microsoft focusing in Data and Analytics online training. He has worked with trainings for developer and IT pro audiences, from Microsoft Dynamics NAV to Windows Active Directory. Before coming to Microsoft, Jonathan worked as a consultant for a Microsoft partner, implementing Microsoft Dynamics NAV solutions.

Kim Manis

Kim Manis

Program Manager
Microsoft

Kim is a program manager on the Power BI Desktop team, working to make data analysis fun and easy. Before that, Kim has worked on all sorts of products ranging from productivity software, social networks and online retail. In her spare time she loves exploring the Pacific Northwest, cooking and finding the perfect animated gif.

Miguel Llopis

Miguel Llopis

Senior Program Manager
Microsoft

Miguel Llopis is a Senior Program Manager specialized on Data Connectivity for Power BI.

Course Outline

Enrollment is Closed
Welcome!
Schedule and Grading
Installing Power BI Desktop
Signing up for Power BI Service
DataSet / Examples Terms of Usage and Disclaimer
Survey
Survey Acknowledgement
Meet the Presenters
Introduction
Overview of Power BI
Connecting to Software as Services
Power BI Community
Summary
Introduction to Power BI Desktop
Changing Locale
Connecting to a Database
Basic Transformations
Managing Query Groups
Splitting Columns
Changing Data Types
Working with Dates
Removing and Reordering Columns
Conditional Columns
Connecting to Files in a Folder
Merge Queries
Query Dependency View
Transforming Less Structured Data
Enter Data
Query Parameters
Summary
Knowledge Checks
Lab Overview
Exercise 1: Import Data from Access Database
Exercise 2: Import Data from a Folder Containing CSV Files
Exercise 3: Import a Less Structured Data from an Excel File
Introduction
Managing Data Relationships
Creating Calculated Columns
Optimizing Models for Reporting
Creating Calculated Measures
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence
Manually Typing in a Data Table
Include / Exclude
Grouping / Binning
Summary
Knowledge Checks
Lab Overview
Exercise 1: Manage Table Relationships
Exercise 2: Last Year Comparison
Exercise 3: Year to Date
Exercise 4: Market Share
Exercise 5: Optimize the Data Model
Introduction
Pie and Treemap
Hierarchical Axis and Concatenating
Filter (Including TopN)
Bar Chart with Line (Combo Chart)
Analytics Pane
Clustering (and Machine Learning)
Slicer
Focus Mode and See Data
Date Slicer
Map Visualizations
ESRI Map
Table and Matrix
Table Styles
Scatter Chart
Waterfall
Gauge, Card, and KPI
Coloring Charts
Shapes, Textboxes, and Images
Gridlines and Snap to Grid
Knowledge Checks
Page Layout and Formatting
Visual Relationship
Duplicate Page
Categories with No Data
Default Summarization and Categorization
Positioning, Aligning, and Sorting Visuals
Custom Hierarchies
R - Visual Integration
Summary
Knowledge Checks
Lab Overview
Exercise 1: Cross-Tabular Report
Exercise 2: Part-to-Whole Report
Exercise 3: Relationship Report
Exercise 4: Trend Report
Exercise 5: Rank Report
Introduction
Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Configuring a Dashboard
Adding Textbox, Image Widgets
Featured and Favorite Dashboard
Filtering Dashboard
Dashboard Settings
Natural Language Queries
Featured Questions
Sharing a Dashboard
In-Focus Mode
Pinning a Live Page
Custom URL and Title
TV Mode and Collapse Navigation
Printing Dashboard and Exporting Data
Export to CSV and Excel
Power BI Notifications
Alerts in the Power BI Service
Personal Gateway
Publishing to Web
Admin Portal
Knowledge Checks
Viewing in Windows App
Viewing in Android App
Viewing in Ipad
Viewing in iPhone
Summary
Lab Overview
Exercise 1: Upload PBI Report and Pin Visualizations
Exercise 2: Share Dashboard and Update Report
Exercise 3: Schedule Data Refresh
Introduction
Importing Excel Data using Simple Table
Excel Workbook with Excel Data Model
Connecting to Excel Workbook on OneDrive for Business
Pinning Excel Tables or Visuals
Analyzing Data in Excel
Summary
Knowledge Checks
Lab Overview
Exercise 1: Upload Excel File with an Excel Table
Exercise 2: Upload an Excel File with a Data Model
Introduction
Direct Connectivity to SQL Azure
Direct Connectivity to SQL Database
Direct Connectivity to SSAS
Using SSAS Connector
SSAS Multi Dimensional Preview
SAP HANA
Summary
Knowledge Checks
Lab Overview
Exercise 1: Direct Connectivity From Power BI Desktop
Exercise 2: Direct Connectivity From Power BI Service
Introduction
Interactive API Console
Registering a Client App and Embedding a Tile
Integrating a Tile to Your App
Using PubNub to Push Data to a Tile
Creating Custom Visuals
Using Custom Visuals
Power BI Embedded
Summary
Knowledge Checks
Lab Overview
Exercise: Use Custom Visuals
Introduction
Report Gallery and Search
Mobile Dashboard Layout
Sharing and Annotating in Power BI Mobile
Taking Your Mobile Content Offline
Platform Specific Features
Search and Recent
Limiting Access to Mobile + MAM
Course Wrap-up
Survey
Survey Acknowledgement
Course Certificate

Earn your certificate

Once you have completed this course, you will earn your certificate.

Analyzing and Visualizing Data with Power BI