Analyzing and Presenting Data with Power BI

Duration: 3 Days (Face-to-Face or Remote-Live), or 21 hours of coursework with personal facilitation over a four week span (On-Demand)

US Price: $1695 (Face-to-Face or Remote-Live), or $1495 (On-Demand)

Delivery Options: Attend face-to-face in the classroom, remote-live or via on-demand training

Registration: Click here to view upcoming schedules and register for face-to-face sessions, click here to register for live remote attendance sessions, or click here to register for on-demand training with a start date that is convenient for you.

View the course schedule

Description

This course provides an in-depth introduction to Microsoft's Power BI suite of products. Students will learn to use the Power BI Desktop and Power BI online service to import, analyze, and visualize business data, and to share business intelligence. The course starts with an exploration of the evolution of relational databases, data warehouse and business intelligence. Later topics include importing and combining data from diverse data sources, shaping and transforming data, and modeling data. Students will develop useful and insightful data visualizations, and create and share reports and dashboards in the Power BI service. Students will learn about collaborating in the Power BI service, and will also gain an introduction to Data Analysis Expressions (DAX).

Extensive hands on labs provide students with experience using the topics presented throughout the course to produce appropriate visualizations of data.

Students wanting in-depth coverage of DAX and Power Query M in addition to Power BI training should instead attend the Analyzing Data with Power BI, DAX, and Power Query M course rather than this course.

Prerequisites

Before attending this course, students must have:

High degree of computer literacy
Experience with office applications
Familiarity with spreadsheet functionality
An understating of fundamental business analysis issues such as revenue, profitability, financial accounting, and reporting
Basic familiarity with relational databases and data warehousing is helpful but not required

Course Overview

Introduction to Business Analysis The Evolution of Data Analysis Databases Normal Forms Data Modeling Data Processing Beyond the Database Data Warehouses Fact and Dimension Tables Data Warehouse Schema Star Schema Snowflake Schema Big Data Self-Service Business Intelligence Enterprise Intelligence Self-Service BI The BI Team The Data Steward The Tasks Accessing Data Loading Data Shaping Data Reporting Visualizing Data Collaborating The Tools The Power BI Suite Related Tools	Getting Data with Power BI Desktop The Power BI Workflow Terminology Opening the Power BI Desktop The Navigation and Filter Panes The Visualizations Pane The Fields Pane Power BI Desktop Settings Data Sources On-Premises Data Files Databases Online Databases Software as a Service (SaaS) Providers Internet Data Data Access Issues Data Reliability Issues Getting Data Import vs. Direct Query Advantages of Direct Query Limitations of Direct Query Data Limits Cleaning Data Selecting Data Fundamentals of Getting Data Importing from Excel Preparing Excel Data Importing from Excel Importing from a Database Selecting Data with SQL Importing from a Web Page Revising Data
Transforming and Shaping Data Getting the Right Data Shaping Data How and Where to Transform Data Formatting Currency Columns and Measures Filters The Power Query Editor How Power BI Accesses and Stores Data Query Editor Layout The Transform Tab The Add Column Tab The View Tab Manipulating Columns Applied Steps The Advanced Query Editor	Visualizing Data Visual Data Processing Why We Visualize Choosing the Right Visualization Report Design Creating Visualizations Basic Layout Selecting Data Starting with Data Starting with Visualization Type Sorting Adding Data, Changing Visualizations The Slicer Fields, Format and Analytics in the Visualizations Pane Formatting Visualizations General Formatting Formatting Groups Title Report Themes Data Colors Data Labels Data Labels Display Units Axes Text Boxes, Images, Shapes Visualization Mechanisms The Slicer Q&A Custom Visuals
Types of Visualizations Basic Visualizations Tables Matrixes Bar/Column Charts Clustered Stacked 100% Ribbon Charts Waterfall Charts Line/Scatter/Area Charts Line Chart Scatter Chart Area Charts Line-and-Column Charts Pies and Donuts Pie Charts Donut charts Map Charts Specialized Charts Funnel Chart Gauge Chart Card Chart Multi-Row Card KPI Key Influencers Tree Maps	Modeling Data Data Models The Utility of Data Models Data Types Cardinality Cross Filter Direction Relationships Understanding Relationships Relationships and Keys Hierarchies The Utility of Hierarchies Creating Hierarchies The Model View Changing Relationships Using the Model View
The Power BI Service Overview Functions by Application Limitations Connecting to the Power BI Service Publishing a Report to the Power BI Service Direct Connectivity from the Power BI Service Refreshing Data Gateways The Power BI Service Interface Layout My Workspace Report Edit Mode Dashboards Dashboard Foundations Dashboards vs. Reports Building Dashboards Editing a Dashboard Filtering a Tile Working the Power BI Service Reports Exporting Reports and Data Workbooks Datasets Apps Sharing Reports and Dashboards Q&A Featured Questions Power BI Service Settings Administration Power BI Administration Admin Portal Power BI Mobile The App To Set Up Your Smartphone Layout Power BI Mobile Features and Limitations	Power BI and Programming Languages Survey of Power BI Languages Why? The Power BI REST API R M Python DAX Data Analysis Expressions DAX Syntax Logical Operators DAX Examples