Udemy

Platform

English

Language

Data & Analytics

Category

BI Data Engineer | Analyst: Power BI, SQL, Data Excel ,DAX

Data Analysis & Visualization with Power BI ,Excel ,SQL

4.43 (76 reviews)

BI Data Engineer | Analyst: Power BI, SQL, Data Excel ,DAX

Students

11.5 hours

Content

Jul 2021

Last Update
Regular Price


What you will learn

Connecting to SQL Server and PostgreSQL Databases with Power BI

Connecting to Web Data with Power BI

Connecting to Microsoft Access Database File

Analysing data from various connected data sources

Clean and transform data

Creating visualizations and dashboards

Publishing reports to Power BI Service

Creating data relationships

Creating and Optimizing Data Models

Performing Data Analysis & Visualization with Excel

Performing Data Analysis with SQL & MySQL


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 beginners course you will learn how to  get started with this powerful toolset.  We will  cover topics like  connecting to and transforming 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 Databases

  • Connecting to Microsoft Access Database File

  • Creating reports with data visualizations

  • Modifying existing reports

  • Creating and managing data dashboards

  • Creating Power BI datasets, dashboards, reports, and workbooks

  • Connecting to web based data source

  • Connecting to Excel dataset

  • Using Query Editor

  • Joining tables and creating tables

  • Formulating via DAX logic

  • Using quick measures and dynamic measures

  • Using conditional statements

  • Performing various transformation on connected dataset

We will also be performing some data analysis using Excel and SQL.


Content

Introduction

Course Introduction

What is a Data Engineer

What is a Data Analyst

What is SQL

What is Power BI

What is Power BI Desktop

What is DAX

Power BI Setup and Overview

Setting Up Office365

Installing Power BI Desktop

Power BI Desktop tour

Power BI Overview: Part 1

Power BI Overview: Part 2

Power BI Overview: Part 3

Components of Power BI

Building blocks of Power BI

Exploring Power BI Desktop Interface

Exploring Power BI Service

Power BI Apps

Connecting Power BI To Web Data

Connect to web data

Clean and transform data : Part 1

Clean and transform data : Part 2

Combining Data Sources

Creating Visualization : Part 1

Creating Visualization : Part 2

Publishing Reports to Power BI Service

Connecting Power BI To Databases

What is SQL Server

SQL Server Download

SQL Server Installation

Install SSMS

Connect to SQL Server with SSMS

Download Sample Database

SQL Server Minimum Hardware & Software Installation Requirements

Connect Power BI To SQL Server Database

What is PostgreSQL

Minimum Installation Requirements for PostgreSQL

Install PostgreSQL on Windows

Install PostgreSQL on Macs

Install PgAdmin4 on Macs

Install PostgreSQL on Linux

Install PgAdmin4 on Linux

Connect to PostgreSQL

Install Sample Database

Connect Power BI To PostgreSQL database: Part 1

Connect Power BI To PostgreSQL database: Part 2

Connect Power BI To Access Database File

Data Analysis & Transformation with Power BI

Changing locale

Connect to access database file

Power query editor and queries

Creating and managing query groups

Renaming Queries

Splitting Columns

Changing Data Types

Removing and reordering columns

Duplicating and adding columns

Creating conditional columns

Connecting to files in folder

Appending queries

Merge queries

Query dependency view

Transform less structured data: Part 1

Transform less structured data: Part 2

Creating tables

Query Parameters

Data Modelling and Analysis with Power BI

What is Data Modelling

Creating and managing data relationships

Creating Calculated columns

Optimizing Models for reporting

Time Intelligence

Applying Filters on Visuals

Excel Setup ( Optional )

Office 365 setup ( Optional)

Activating office 365 ( Optional)

Logging into office 365 (Optional)

What is Power Pivot

Office versions of power pivot

How to enable power pivot in excel

What is Power Query

Data Analysis & Visualization with Excel

Connecting to a data source

Preparing query

Cleansing data

Enhancing query

Creating a data model

Build Relationships with data

Create lookups with DAX

Analyse Data with Pivot Tables

Analyse data with Pivot Charts

Refresh Source Data

Update Queries

Create new reports

MySQL Database Server Setup

What is MySQL

MySQL Download Link

MySQL Windows Installation

MySQL Mac Installation

What is MySQL Workbench

MySQL Workbench Installation for Mac

Basic Database Concepts

Data Analysis with SQL & MySQL

SQL Statement and query

Analyse data with SQL INNER JOIN

Analyse data with SQL LEFT JOIN

Analyse data with SQL RIGHT JOIN

Analyse data with SQL SELF JOIN

Analyse data with SQL SUB QUERIES

Analyse data with nested subqueries

Analyse data with SQL Derived Tables

Analyse data with Between Operator

Analyse data with SQL IN Operator

Analyse data with SQL LIKE Operator

Analyse data with SQL UNION Operator

What are aggregate functions

Analyse data with SQL AVG Aggregate Function

Analyse data with SQL COUNT Aggregate Function

Analyse data with SQL SUM Aggregate Function

Analyse data with SQL MIN Aggregate Function

Analyse data with SQL MAX Aggregate Function

Database Modelling with MySQL

What is Data Modelling

Creating a Model : Part 1

Creating a Model : Part 2

Basic Data Modelling


Reviews

M
Merter4 August 2021

I would definitely recommend it for beginners. The tutor's explanation is very good. The reason I gave it four stars is because some videos have black screens at the end. And, the fact that he repeatedly uploaded data at the beginning of each lesson and did not continue from where he left off in the previous video reduced my focus and motivation. It was full of information but I got a little bored towards the end.


Coupons

DateDiscountStatus
7/30/2021100% OFFExpired

4209330

Udemy ID

7/28/2021

Course created date

7/30/2021

Course Indexed date
Bot
Course Submitted by