Udemy

Platform

English

Language

Data & Analytics

Category

Data Analysis and Visualization with Microsoft Power BI 2020

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

4.20 (13 reviews)

Students

3 hours

Content

Nov 2020

Last Update
Regular Price


What you will 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


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!


Screenshots

Data Analysis and Visualization with Microsoft Power BI 2020
Data Analysis and Visualization with Microsoft Power BI 2020
Data Analysis and Visualization with Microsoft Power BI 2020
Data Analysis and Visualization with Microsoft Power BI 2020

Content

INTRODUCTION TO MICROSOFT POWER BI

What is Power BI?

Why Power BI?

Power BI Family

Power BI Service

Power BI Desktop

Quiz 1

DATA INGESTION AND IMPORTING

Data Ingestion and Importing

Import data from CSV

LAB: Importing data from CSV

Import data from Excel

LAB: Import data from Excel

Import data from Web

LAB: Import data from from Web

Import Real-time Streaming data

LAB: Import Real-time Streaming data

Quiz 2

DATA CLEANING

Power Query

LAB: Power Query

Append Queries

LAB: Append Queries

Merge Queries

LAB: Merge Queries

Quiz 3

POWER BI VISUALS

Power BI Visuals

Stacked Bar and Column Chart

LAB: Bar and Column Chart

Line Chart

LAB: Line Chart

Pie Chart

LAB: Pie Chart

Map Chart

LAB: Map Chart

Card and Multi-Row Cards

LAB: Card and Multi-row Cards

KPIs

LAB: KPIs

Word Cloud

LAB: Word Cloud

Quiz 4

DATA MODELLING

Modelling Relationships

LAB: Modelling and Relationships

Normalization Denormalization

OLTP vs. OLAP

Snowflake vs. Star scheme

Quiz 5

DAX in Power BI

What is DAX?

LAB: Creating Measures

LAB: Basic Functions

LAB: Time Analysis Function

LAB: Calendar Date Table

Capstone Project

Capstone Project


3524430

Udemy ID

9/24/2020

Course created date

10/11/2020

Course Indexed date
Bot
Course Submitted by