Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx

Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx, available at $49.99, has an average rating of 4.05, with 101 lectures, based on 21 reviews, and has 1103 subscribers.

You will learn about Connect to data sources Clean, transform and load data Create data visualizations Create and publish reports to the Power BI Service Transform less structured data Perform data modelling Perform time intelligence on models Create and merge queries Create bulk SQL queries with excel This course is ideal for individuals who are Beginner Data Analyst or Beginner Data Scientist or Beginner Power BI Analyst It is particularly useful for Beginner Data Analyst or Beginner Data Scientist or Beginner Power BI Analyst.

Enroll now: Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx

Summary

Title: Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx

Price: $49.99

Average Rating: 4.05

Number of Lectures: 101

Number of Published Lectures: 101

Number of Curriculum Items: 101

Number of Published Curriculum Objects: 101

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Connect to data sources
Clean, transform and load data
Create data visualizations
Create and publish reports to the Power BI Service
Transform less structured data
Perform data modelling
Perform time intelligence on models
Create and merge queries
Create bulk SQL queries with excel

Who Should Attend

Beginner Data Analyst
Beginner Data Scientist
Beginner Power BI Analyst

Target Audiences

Beginner Data Analyst
Beginner Data Scientist
Beginner Power BI Analyst

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

Course Curriculum

Chapter 1: Power BI Setup

Lecture 1: Introduction

Lecture 2: Office 365 Setup

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

Chapter 2: Power BI Overview

Lecture 1: Power BI Overview: Part 1

Lecture 2: Power BI Overview: Part 2

Lecture 3: Power BI Overview: Part 3

Lecture 4: Components of Power BI

Lecture 5: Building blocks of Power BI

Lecture 6: Exploring Power BI Desktop Interface

Lecture 7: Power BI Service

Lecture 8: Power BI APPS

Chapter 3: Connecting to Web Data

Lecture 1: Connecting to Web Data

Lecture 2: Clean and transform data : part 1

Lecture 3: Clean and transform data : part 2

Lecture 4: Combining data sources

Lecture 5: Creating visuals : Part 1

Lecture 6: Creating visuals : Part 2

Lecture 7: Publishing report to Power BI Service

Chapter 4: Transforming Data

Lecture 1: Connecting to data source

Lecture 2: Power query editor

Lecture 3: Creating and managing query groups

Lecture 4: Renaming queries

Lecture 5: Splitting columns

Lecture 6: Changing data types

Lecture 7: Removing columns

Lecture 8: Duplicating and adding columns

Lecture 9: Creating conditional columns

Lecture 10: Connecting to files in a folder

Lecture 11: Appending queries

Lecture 12: Merge queries

Lecture 13: Query dependency view

Lecture 14: Transforming less structured data

Lecture 15: Creating tables

Lecture 16: Query Parameters

Chapter 5: Data Modelling

Lecture 1: What is data modelling

Lecture 2: Creating and managing relationship

Lecture 3: Creating calculated columns

Lecture 4: Optimize models for reporting

Lecture 5: Time intelligence

Lecture 6: Apply filters to visuals

Chapter 6: SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server Editions

Lecture 3: SQL Server Installation Requirements

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Install SSMS

Lecture 7: Connect SSMS to SQL Server

Lecture 8: Create a database

Chapter 7: Data Exploration with SQL

Lecture 1: Data Preparation

Lecture 2: Importing Datasets into Database

Lecture 3: How many continents do we have data for

Lecture 4: Possibility of dying from COVID

Lecture 5: Percentage of population infected with COVID

Lecture 6: Countries with highest COVID infection

Lecture 7: Countries with highest COVID deaths

Lecture 8: Continents with highest COVID deaths

Lecture 9: Global COVID cases and deaths

Lecture 10: Number of people vaccinated

Lecture 11: Exploring data with SQL CTE

Lecture 12: Exploring data with SQL Tempory tables

Lecture 13: Exploring data with SQL Views

Chapter 8: Azure Setup

Lecture 1: What is Azure

Lecture 2: Creating Azure Account

Lecture 3: Accessing Azure Services

Lecture 4: Creating a database in Azure Portal

Chapter 9: Data Manipulation with Azure

Lecture 1: Query data on Azure portal

Lecture 2: Connect SSMS to Azure

Lecture 3: Inserting data into Azure SQL Database

Lecture 4: Updating data in Azure SQL Database

Lecture 5: Deleting data in Azure SQL Database

Chapter 10: Oracle Database and TOAD Setup

Lecture 1: Install Oracle Server

Lecture 2: SQL PLus

Lecture 3: Unlock Sample database schema

Lecture 4: Install Oracle SQL developer

Lecture 5: Connect SQL Developer to Oracle

Lecture 6: Install TOAD

Lecture 7: Connect TOAD to Oracle

Chapter 11: Build Bulk SQL Queries with Excel for Oracle Databases

Lecture 1: What is SQL

Lecture 2: Sample Data

Lecture 3: Create table

Lecture 4: Prep Data

Lecture 5: Build bulk insert SQL Queries: Part 1

Lecture 6: Build bulk insert SQL Queries: Part 2

Lecture 7: Build bulk update SQL Queries: Part 1

Lecture 8: Build bulk update SQL Queries: Part 2

Lecture 9: Build bulk delete SQL Queries: Part 1

Instructors

Digital Learning Academy
Digital learning 24 /7

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 2 votes
4 stars: 8 votes
5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu