Data Analysis and Visualization with Microsoft Power BI 2020

Name: Data Analysis and Visualization with Microsoft Power BI 2020
Rating: 4.1 (40 reviews)

Analyze , Transform & Visualize Data with Microsoft Power BI Desktop with hands-on projects lab work

Created bySKILL CURB

Last updated 11/2020

English

What you'll learn

At the end of this course students will be able to analyze data from different data sources and create their own datasets
Importing data from CSV, Excel and other sources in Power BI
Data Analytics
Different Data Visualization techniques
Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Course content

7 sections • 46 lectures • 2h 45m total length

What is Power BI?4:47
Why Power BI?4:36
Power BI Family6:08
Power BI Service3:31
Power BI Desktop3:16
Quiz 1

Data Ingestion and Importing4:36
Import data from CSV1:06
LAB: Importing data from CSV2:29
Learn to import csv data into Power BI Desktop by using get data, connect to a csv file, view delimiter and source settings, load the data, and explore loaded tables.
Import data from Excel1:15
LAB: Import data from Excel1:53
Learn to import data from an Excel file into Power BI Desktop by using getData, selecting Excel, navigating sheets, and loading a chosen table.
Import data from Web0:47
LAB: Import data from from Web4:08
Learn how to import data from the web into Power BI Desktop by connecting to a web page, choosing HTML tables with the preview, and loading a table for visualizations.
Import Real-time Streaming data4:19
LAB: Import Real-time Streaming data4:15
Quiz 2

Power BI Visuals2:09
Explore Power BI visuals, including preinstalled visuals, and learn when to use horizontal bar charts, bar charts, column charts, and line charts to compare categories and track changes over time.
Stacked Bar and Column Chart2:43
Explore stacked bar and stacked column charts in Power BI to break totals into subcategories with a second dimension and a measure, showing parts of the whole and time-based changes.
LAB: Bar and Column Chart2:49
Learn to create bar and column charts in Power BI by importing Excel data, loading the financial sheet, and exploring stacked visuals that adapt as attributes are added.
Line Chart1:51
LAB: Line Chart2:08
Pie Chart1:44
LAB: Pie Chart3:48
Map Chart2:15
LAB: Map Chart2:18
Card and Multi-Row Cards0:47
Learn to use cards and multitool cards in Power BI to visualize key metrics. Apply single-number cards for totals like sales or market share and group data with multi-card layouts.
LAB: Card and Multi-row Cards3:35
KPIs1:54
Discover key performance indicators (KPIs) as measurable values that quantify progress toward strategic objectives. Learn how KPIs at multiple levels guide decision making and assess performance across departments.
LAB: KPIs2:48
Word Cloud1:22
LAB: Word Cloud2:05
Quiz 4

Requirements

PC with Microsoft Windows
Basic understanding of Data Analysis and Data Visualization (but not mandatory)
Microsoft Power BI Desktop installed on your system

Description

This course teaches you how to do Data Analysis and Visualization in Microsoft Power BI Desktop.

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices? Then the Power BI tools are the tools to choose for you!

This is what you will learn:

Get to know the different tools of the Power BI universe and learn how to use them
Understand Power BI Desktop and its components
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model, and understand the difference between those two steps
How to work in the different views of the Data Model
How to create calculated columns and measures
How to create a report with different interactive visualization types

This course if for:

People who never worked with Power BI and who want to understand how to use these tools
People who want to learn to analyze and to visualize the data in Microsoft Power BI
People with no or less knowledge of Data Analysis and Visualization
Students of Business operations
Owners of any business who want to see the day-to-day position of their business
Everyone who wants to be an expert in Data Analytics and Microsoft Power BI

We would be happy to welcome you to this course!

Who this course is for:

Anyone having the need to learn Data Analysis and Data Visualization using Microsoft Power BI

Data Analysis and Visualization with Microsoft Power BI 2020

What you'll learn

Explore related topics

Course content

INTRODUCTION TO MICROSOFT POWER BI5 lectures • 22min

DATA INGESTION AND IMPORTING9 lectures • 25min

DATA CLEANING6 lectures • 25min

POWER BI VISUALS15 lectures • 34min

DATA MODELLING5 lectures • 20min

DAX in Power BI5 lectures • 24min

Capstone Project1 lecture • 15min

Requirements

Description

Who this course is for: