Power Bi Developer (Power Bi,Dax,Power Query,Datamodelling)

Power BI Hands-on learning experience- Data Analytics, Data Visualization,DAX,Power Query,Datamodelling,Databases

What you'll learn

Install Power BI Desktop

Connect to multiple data sources

Clean, transform and load data

Analyse data

Visualize data

Create measures

Create paginated reports

Build dashboards

Requirements

No experience required

Required software installation is covered in the course.

Description

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.Power BI consists of several elements that all work together, starting with these three basics:A Windows desktop application called Power BI Desktop.An online software as a service (SaaS) service called the Power BI service.Power BI Mobile apps for Windows, iOS, and Android devices.These three elements—Power BI Desktop, the service, and the mobile apps—are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.  Beyond those three, Power BI also features two other elements:Power BI Report Builder, for creating paginated reports to share in the Power BI service. Read more about paginated reports later in this article.Power BI Report Server, an on-premises report server where you can publish your Power BI reports, after creating them in Power BI DesktopHow you use Power BI can be based on which feature or service of Power BI is the best tool for your situation. For example, you can use Power BI Desktop to create reports for your own team about customer engagement statistics and you can view inventory and manufacturing progress in a real-time dashboard in the Power BI service. You can create a paginated report of mailable invoices, based on a Power BI dataset. Each part of Power BI is available to you, which is why it's so flexible and compelling.One common workflow in Power BI begins by connecting to data sources in Power BI Desktop and building a report. You then publish that report from Power BI Desktop to the Power BI service, and share it so business users in the Power BI service and on mobile devices can view and interact with the report.

Overview

Section 1: Power BI Setup

Lecture 1 Introduction

Lecture 2 What is Power BI

Lecture 3 What is Power BI Desktop

Lecture 4 Install Power BI Desktop

Lecture 5 Exploring Power BI Desktop Interface

Lecture 6 Microsoft 365 Setup

Lecture 7 Getting started with Microsoft 365

Lecture 8 Creating a new user account in Microsoft 365

Section 2: Connecting to Data Sources

Lecture 9 Introduction

Lecture 10 Connecting to online data sources

Lecture 11 Connecting to NOSQL Database

Lecture 12 Getting data into Power BI Desktop

Lecture 13 Create and save a new Power BI Desktop file

Lecture 14 Set Power BI Desktop options

Lecture 15 Get data from SQL Server

Lecture 16 Preview SQL Server queries

Lecture 17 Getting data from files

Lecture 18 Get data from a CSV file

Lecture 19 Get additional data from a CSV file

Lecture 20 Connect to data in a database

Lecture 21 Connect to data in Power Platform

Lecture 22 Connect to Azure SQL Database

Lecture 23 Data Source Settings

Lecture 24 Storage Modes

Lecture 25 Change the source file

Lecture 26 Selecting a storage mode

Section 3: Power BI Overview

Lecture 27 Introduction

Lecture 28 Power BI Overview : Part 1

Lecture 29 Power BI Overview : Part 2

Lecture 30 Power BI Overview : Part 3

Lecture 31 Parts of Power BI

Lecture 32 Power BI Building blocks

Lecture 33 Exploring Power BI Service

Section 4: Connect & Transform Online Data

Lecture 34 Connect to Web Data

Lecture 35 Clean & transform data : Part 1

Lecture 36 Clean & transform data : Part 2

Lecture 37 Combine data sources

Lecture 38 Creating Data Visuals : Part 1

Lecture 39 Creating Data Visuals : Part 2

Lecture 40 Publish report to Power BI Service

Section 5: Power BI | Databases Interaction

Lecture 41 Download SQL Server

Lecture 42 SQL Server Installation

Lecture 43 Installing SQL Server Management Studio

Lecture 44 Connect to SQL Server with SSMS

Lecture 45 Install Database

Lecture 46 Restore AdventureWorksDW2020 Database

Lecture 47 Connecting to SQL Server Database with Power BI Desktop

Lecture 48 Install PostgreSQL

Lecture 49 Connecting to PostgreSQL Database Server : Part 1

Lecture 50 Connecting to PostgreSQL Database Server : Part 2

Lecture 51 Download and load sample database

Lecture 52 Connect to PostgreSQL Databases

Lecture 53 Connect to PostgreSQL with Power BI Desktop - Part 1

Lecture 54 Connect to PostgreSQL with Power BI Desktop - Part 2

Lecture 55 Importing and Transforming Data from an Access Database File

Section 6: Clean, transform, and load SQL Server data in Power BI

Lecture 56 Shaping initial data

Lecture 57 Configure the Salesperson query

Lecture 58 Configure the SalespersonRegion query

Lecture 59 Configure the Product query

Lecture 60 Configure the Reseller query

Lecture 61 Configure the Region query

Lecture 62 Configure the Sales query

Lecture 63 Configure the Targets query

Lecture 64 Configure the ColorFormats query

Lecture 65 Update the Product query

Lecture 66 Update the ColorFormats query

Section 7: Data Modelling

Lecture 67 What is Data Modelling

Lecture 68 Create Model Relationships

Lecture 69 Configure the Product table

Lecture 70 Configure the Region table

Lecture 71 Configure the Reseller table

Lecture 72 Configure the Sales table

Lecture 73 Bulk update properties

Lecture 74 Review the model interface

Lecture 75 Create quick measures

Lecture 76 Create a many-to-many relationship

Lecture 77 Relate the Targets Table

Lecture 78 Enforce row-level security

Section 8: Introduction to DAX In Power BI Desktop

Lecture 79 What is DAX

Lecture 80 Create the Salesperson Calculated table

Lecture 81 Create the Date calculated table

Lecture 82 Create calculated columns

Lecture 83 Complete the Date table

Lecture 84 Mark the Date table

Lecture 85 Create simple Measures

Lecture 86 Create additional measures

Lecture 87 Time Intelligence

Lecture 88 Create a matrix visual

Lecture 89 Manipulate filter context

Lecture 90 Create a YTD measure

Lecture 91 Create a YoY growth measure

Lecture 92 Publish Power BI Desktop File

Section 9: Building Reports in Power BI

Lecture 93 Create a new file

Lecture 94 Create a live connection

Lecture 95 Design page 1

Lecture 96 Design page 2

Lecture 97 Design page 3

Lecture 98 Publish report

Lecture 99 Explore the report

Lecture 100 Configure Sync Slicers

Lecture 101 Configure drill through page

Lecture 102 Add Conditional Formatting

Lecture 103 Add Bookmarks to Report

Lecture 104 Add Buttons to Report

Lecture 105 Publish Updated Report

Lecture 106 Explore Updated Report

Section 10: Building Dashboards | Perform Data Analysis

Lecture 107 What are Dashboards

Lecture 108 Create a dashboard

Lecture 109 Configure an alert

Lecture 110 Refresh the dataset

Lecture 111 Create the report

Lecture 112 Connect to the Sales Analysis Dataset

Lecture 113 Create an animated scatter chart

Lecture 114 Create a forecast

Lecture 115 Work with a decomposition tree

Lecture 116 Work with key influencers

Section 11: Building Paginated Reports

Lecture 117 What are Paginated Reports

Lecture 118 Installing Power BI Report Builder

Lecture 119 Create a blank report

Lecture 120 Configure the report header

Lecture 121 Create a data source and dataset

Lecture 122 Configure the report parameter

Lecture 123 Add textboxes to report header region

Lecture 124 Add a table to the report

Lecture 125 Format the table data region

Lecture 126 Finalize the report design

Beginners to Power BI