Data Analysis & Visualisation With Power Bi (Basic)

Beginners Guide to Microsoft Power BI. Create Professional , Interactive Reports & DashBoards with Power BI in Minutes

What you'll learn

How to Extract and Transform Data for Visualisation

Create Interactive Reports and Visuals with Power BI

How to create Data Models & establish relationships

Basic understanding of DAX

Requirements

No prior knowledge of Power BI is required

Basic knowledge of working with data in Excel, is recomended.

Description

Power BI (a tool from Microsoft) is the world leader in Data Analytics & Business Intelligence.In this course, you will learn Basics of  Data Extractions, Transformation & Dashboarding with Power BI.Course ContainsIntroduction- How to down load Power BI, Basic Settings & Options, Understanding UI.Connect & Extract Data- How to Extract & Load Data Data Transformation-How to Transform date & make it ready for presentation using Date, Text, Numeric tools, appending multiple files.Creating Data Models-  Creating Power BI Table Relationships, Connecting Multiple Data Tables.DAX- Adding Calculated Columns & Fields with basic understanding DAX.Visualisation- Designing Interactive Power BI Dashboards.During this Course, we will complete one project from start to end i.e. from Importing Data till Data Visualiastion.It is highly recommended that, while learning you should pause the video and then tray on your own the concepts learned.This will give you hands on practical experience of using Power BI. By the end of this course, you will get clear understanding of Basic concepts & tools used in Power BI, which you can apply  to your own Power BI projects going ahead.This course is essential for those who want to create complex MIS reports and DashBoards  base on various different data sources, make professional and interactive visual with out affecting integrity of source data.

Overview

Section 1: Introduction

Lecture 1 Introduction- How To Down Load, Basic Settings

Section 2: Extract & Transform Data

Lecture 2 Extract & Connect Data

Lecture 3 Transform Data-1

Lecture 4 Transform Data-2

Section 3: Data Modeling

Lecture 5 Relationships

Section 4: Dax & Reports

Lecture 6 Reports & DAX -1

Lecture 7 Reports & DAX -2

Lecture 8 Reports & DAX -3

Beginners in Data Analytics & Visualization,MIS , Accounting & Finance Executives who want to upskill for:- Creating Automated, Interactive Dashboards & Reports.