Learn Power Bi With Sahil

Data Visualization with Power BI

What you'll learn

Install Power BI Desktop

Import data in Power BI

Create Relationships between tables

Introduction to Power Query Editor

Introduction to bar charts, line charts and other features of power BI

Update bookmarks

Write DAX queries

Measures Vs Columns

Export report to PDF or publish power bi report

Important tips to remember while working on BI

How to create a Drill through in Power BI

Different sorts of navigation options in Power BI

Create Slicers

What is Tree map chart in Power BI

Usage of legends in Power BI

Advanced DAX functions to use

Live Dashboard at end of the course

Requirements

No programming experience required

Basic understanding of MS Excel

Power BI desktop installed in system

Description

Welcome to the course "Learn Power BI from scratch".There are a lot of things to explore in Power BI, However, This course covers all the major important topics which you will use in real time scenarios or while doing business/ data analysisIntroduction to various Power BI FeaturesInstall Power BI DesktopCreate a drill through to get in-depth insights of the dataLearn how to transform data using the Power Query Editor to connect Power BI to various source typesLearn how to use various types of visualisations available.How to work in the different views of the Power BI DashboardHow to create calculated columns and measures and difference between themHow to build relationships between different tablesHow to write Basic as well as Advanced DAX functionsHow to publish your report or export to PDFHow to use measures to show figures using card visualHow to change canvas background of the dashboardWhere to use legends in visualsCreate slicers and filters in Power BIThings to keep in mind while working on Power BIChange data types in Power query editorLearn to make a dashboard from data import to publish on Power BI Service

Overview

Section 1: Important Topics

Lecture 1 Installing Power BI Desktop

Lecture 2 Importing data in power bi from various sources

Lecture 3 Types of relationships in Power BI

Lecture 4 Transform data using Power Query Editor

Lecture 5 Different sorts of charts and Filter pane

Lecture 6 Introduction to Measures vs Columns

Lecture 7 Writing DAX functions in Power BI

Lecture 8 Advanced DAX functions to use

Lecture 9 How to use card visual to show KPI and figures

Lecture 10 How to use various charts in Power BI

Lecture 11 What is treemap in Power BI

Lecture 12 Create Slicers

Lecture 13 How to create a Drill through in Power BI

Lecture 14 How to make use of bookmarks using filters, selection and action option

Lecture 15 Things to keep in mind while working on Power BI

Lecture 16 How to Export report to PDF

Beginners who want to enter into data analyst/Business analyst,Experienced who want to transition to Business Intelligence roles,Someone who want to restart their careers