Last updated 6/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.21 GB | Duration: 5h 39m

Perform Business analysis| Connect to various Data Sources|Transform Data |Publish Data

What you'll learn
How to sign up to Power BI Service
How to install Power BI Desktop
Building blocks of Power BI
Overview of Power BI Service
Connecting to web based data source
Clean and transform web based data
Combine web based data sources
Create visuals from web based data source
Publish reports and visuals to Power BI Service
Connect to SQL Server Database with Power BI Desktop
Connect to PostgreSQL Database with PostgreSQL
Connect to Microsoft Access Database File with Power BI Desktop
Perform various transformation on connected data sources
Connecting to files in a Folder with Power BI Desktop
Transform less structured data
Perform data modelling with Power BI Desktop
Optimize models for reporting
Perform intelligence on models
Applying filters to visuals
Requirements
Access to computer and internet
Description
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website.

Connect to hundreds of data sources and bring your data to life with live dashboards and reports.Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.In this bners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transfog web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.You will learn how to import data, create visualizations, and arrange those visualizations into reports. You will learn how to how to pin visualizations to dashboards for sharing. You will also learn how to use DAX language( Data Analysis Expressions) to perform calculations on data models.Topics include:Connecting to SQL Server and PostgreSQL DatabasesConnecting to Microsoft Access Database FileCreating reports with data visualizationsModifying existing reportsCreating and managing data dashboardsCreating Power BI datasets, dashboards, reports, and workbooksConnecting to web based data sourceConnecting to Excel datasetUsing Query EditorJoining tables and creating tablesFormulating via DAX logicUsing quick measures and dynamic measuresUsing conditional statementsPerfog various transformation on connected dataset

Overview

Section 1: Introduction and Lab Environment Setup

Lecture 1 Introduction

Lecture 2 Signing up for Office 365

Lecture 3 What is Power BI

Lecture 4 What is Power BI Desktop

Lecture 5 Installing Power BI Desktop

Lecture 6 Power BI desktop Tour

Section 2: Overview of Power BI

Lecture 7 Power BI Overview - Part 1

Lecture 8 Power BI Overview - Part 2

Lecture 9 Power BI Overview - Part 3

Lecture 10 Components of Power BI

Lecture 11 Building blocks of Power BI

Lecture 12 Exploring Power BI Desktop interface

Lecture 13 Exploring Power BI Service

Lecture 14 What are Power BI Apps

Section 3: Connecting to Web dаta: Tranform | Visualize |Publish

Lecture 15 Connecting to Web based Data

Lecture 16 Clean and transform data - Part 1

Lecture 17 Clean and transform data - Part 2

Lecture 18 Combining Data Sources

Lecture 19 Creating Visuals in Power BI - Part 1

Lecture 20 Creating Visuals in Power BI - Part 2

Lecture 21 Publishing Report to Power BI Service

Section 4: Connecting to Databases Data Sources

Lecture 22 What is SQL Server

Lecture 23 SQL Server 2017 Express Installation

Lecture 24 Sample Database

Lecture 25 Attach sample database

Lecture 26 Connecting to SQL Server Database with Power BI Desktop

Lecture 27 What is PostgreSQL

Lecture 28 Install PostgreSQL

Lecture 29 Connecting to PostgreSQL Database Server

Lecture 30 and load sample database

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

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

Lecture 33 Importing and Transfog Data from an Access Database File

Section 5: Transfog Data using Power BI Desktop

Lecture 34 Chag Locale

Lecture 35 Connecting to Microsoft Access Database File

Lecture 36 Power Query Editor and Queries

Lecture 37 Creating and Managing Query Groups

Lecture 38 Renaming Queries

Lecture 39 Splitting Columns

Lecture 40 Chag Data Types

Lecture 41 Removing and Reordering Columns

Lecture 42 Duplicating and Adding Columns

Lecture 43 Creating Conditional Columns

Lecture 44 Connecting to Files in a Folder

Lecture 45 Appending Queries

Lecture 46 Merge Queries

Lecture 47 Query Dependency View

Lecture 48 Transfog Less Structured Data - Part 1

Lecture 49 Creating Tables

Lecture 50 Query Parameters

Section 6: Power BI Desktop Modelling

Lecture 51 What is Data Modelling

Lecture 52 Creating and Managing Data Relationships

Lecture 53 Creating Calculated Columns

Lecture 54 Optimizing Models for Reporting

Lecture 55 Intelligence

Lecture 56 Applying Filters on Visuals

Lecture 57 Thank You

Bners to Power BI,Business Analyst,Data Analyst

HomePage:

Https://anonymz.com/https://www.udemy.com/course/power-bi-for-bners/