Power Bi Desktop – Beginner

Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.78 GB | Duration: 2h 33m

Getting Familiar With Power BI Desktop

What you’ll learn
Understanding Self-Service Business Intelligence
Connecting to Data
Preparing Data for Analysis
Visualizing Data
Building Dashboards in Power BI Service

Requirements
Basic Computer Skills
Excel Level 2
Web browser skills

Description
Modern business reporting demands the ability to visualize data within an organization’s business context. Power BI Desktop is Microsoft’s premier tool for visualizing data and for creating highly interactive dashboards.This course starts with the basics. Business Intelligence concepts are examined and explained. The process of grooming data for analysis is covered with demonstrations at each step.Connecting to data sources is the first step and this course covers several data sources as examples. Data may live in humble Excel workbooks, SQL databases, or the Power BI Service.Once data sources have been created, data must often be prepared before visualizations can be created. Data must be cleansed, transformed, and shaped before analysis can begin. Power BI Desktop has tools to assist with all these tasks. Each feature is examined and demonstrated.Many visualizations are created in this course. Each type is explained so that students understand why one visualization should be used instead of others. The lesser used chart types are given extra attention because their value is usually not understood without examples.Created in this course: Tables and Matrices, Text Based visuals, Column Charts, Line Charts, Interactive Legends, Waterfall Charts, Funnel Chars, Scatter Plot Charts complete with motion, Area and Stacked Area Charts are all created. Gauges and KPIs are also created.Finally, the Power BI Service is examined and used to create truly interactive dashboards that may be shared with other users within their organizations.

Overview
Section 1: Introduction

Lecture 1 Introduction

Section 2: Understanding Self-Service BI

Lecture 2 Understanding Self-Service BI

Lecture 3 Who Performs Business Intelligence

Section 3: Connecting to Data

Lecture 4 Understanding Data Sources

Lecture 5 Understanding Data Connections

Lecture 6 Connecting to Data

Lecture 7 Saving Data

Section 4: Preparing Data for Analysis

Lecture 8 What is Data Prep

Lecture 9 Preparing Data for Analysis

Lecture 10 Cleaning and Transforming Data

Lecture 11 Shaping Data

Lecture 12 Using the Query Editor to Transform Data

Lecture 13 Data Categories

Lecture 14 Basic Calculations

Section 5: Visualizing Data

Lecture 15 Visualizing Data

Lecture 16 Overview of the Environment

Lecture 17 Overview of Basic Features

Lecture 18 Creating a Table and a Matrix

Lecture 19 Creating Text Based Visuals

Lecture 20 Creating Column and Line Charts

Lecture 21 Creating a Waterfall Chart

Lecture 22 Creating a Scatter Plot

Lecture 23 Creating a Funnel Chart

Lecture 24 Creating an Area Chart

Lecture 25 Creating a Stacked Area Chart

Lecture 26 Creating a Gauge

Lecture 27 Creating KPI

Section 6: Building Dashboards

Lecture 28 Understanding the Power BI Service

Lecture 29 Power BI in Excel

Lecture 30 Dashboard in Power BI Service

Section 7: Conclusion

Lecture 31 Recap

Section 8: Power BI Desktop – Beginner Assessment

Anyone looking to expand upon existing business software knowledge.

HomePage