Data Analyst - ETL/SSIS/SQL/PowerBI

Learn to extract ,transform, and analyse data.

3.70 (373 reviews)
Udemy
platform
English
language
Other
category
Data Analyst - ETL/SSIS/SQL/PowerBI
20,021
students
10 hours
content
May 2023
last update
$64.99
regular price

What you will learn

Data Analysis with ETL

Data Analysis with SSIS

Data Analysis with SQL

Data Analysis with Power BI

Extract data from multiple sources

Clean and transform data

Analysing data using SQL Analytic functions

Description

Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.

The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.

A common problem that organizations face is how to gathering data from multiple sources, in multiple formats, and move it to one or more data stores. The destination may not be the same type of data store as the source, and often the format is different, or the data needs to be shaped or cleaned before loading it into its final destination.

Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.


SSIS can be used for:

  •  Data Integration

  •  Data Transformation

  •  Providing solutions to complex Business problems

  •  Updating data warehouses

  •  Cleaning data

  •  Mining data

  •  Managing SQL Server objects and data

  •  Extracting data from a variety of sources

  •  Loading data into one or several destinations


SQL is a standard language for accessing and manipulating databases.

SQL stands for Structured Query Language

What Can SQL do?

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can set permissions on tables, procedures, and views


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  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.



Content

ETL Environment Setup

Introduction
What is ETL
What is Visual Studio
Visual studio installation requirements
Download and Install Visual Studio
Visual Studio Workload
What is SQL Server
SQL Server Installation Requirements
SQL Server Editions
Download Microsoft SQL Server
Install SQL Server
Install SSMS
Connect to SQL Server with SSMS
SQL Server Configuration Manager
Download and install sample database
Download adventureworksDW Database
Download and Install SSDT
Installing SSDT Templates

Data Analysis with ETL with SSIS

ETL Process
What is SSIS
Create a new SSIS Project in SQL Server 2019
Create a new SSIS Project in SQL Server 2015
Add a flat file connection manager
Remap Column Data Types
Add and Configure OLE DB Connection Manager
Add a data flow task
Add and Configure Flat file source
Add and Configure Lookup Transformation
Add and Configure Lookup For DateKey Transformation
Add and configure OLE DB Destination
Test and Run Package

Power BI

What is Power BI
What is Power BI Desktop
Office 365 Setup
Install Power BI Desktop
Exploring Power BI Desktop
Power BI Overview: Part 1
Power BI Overview: Part 2
Power BI Overview: Part 3
Components of Power BI
Exploring Power BI Desktop Interface
Exploring Power BI Service
Power BI Apps

Connecting to web data with Power BI

Connecting to web data with Power BI
Clean and transform data: part 1
Clean and transform data: part 2
Combining Data Sources
Data Visualization: Part 1
Data Visualization: Part 2
Publishing to Power BI Service

Connecting and transforming database data with Power BI

Transforming Database Data
Changing Locale
Connecting to access database data
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 folders
Appending Queries
Merge Queries
Query Dependency Views
Transforming Less Structured Data: Part 1
Transforming Less Structured Data: Part 2
Creating Tables
Query Parameters

Data Analysis with SQL - Table Joins

What is SQL
What is T-SQL
Basic Database Concepts
SQL Server Data Types
Introduction to Table Joins
Extracting data with INNER Join
Extracting data with LEFT OUTER Join
Extracting data with RIGHT OUTER Join

Data Analysis with SQL Aggregate Functions

Introduction to aggregate functions
Returning data with COUNT function
Returning data with SUM function
Returning data with AVG function
Returning data with MIN function
Returning data with MAX function
Using multiple aggregate functions

Data Analysis - Sorting Data with SQL

Introduction to sorting data
The ORDER BY Clause
Sorting data in ascending order
Sorting data in descending order
Sorting data from multiple columns

Data Analysis - Filtering Data with SQL

Introduction
Filtering data with comparison operators
Filtering data with logical operators
Filtering data with NULL values
Filtering data with string comparison

Data Analysis with Analytic Queries

What are Analytic Functions
The Syntax
Using LEAD Function
LAG Function
LAST_VALUE Function
FIRST_VALUE Function
PERCENT_RANK Function
CUME_DIST Function

Reviews

Gopinath
April 3, 2023
Actually, The course is very is good but please improve the clarity of voice because it hears the base voice , some words is not understanding clearly
Barbara
December 29, 2022
Simply awful. Very confusing. The person recording this course seems to not have planned at all. A lot of back and forth because the instructor itself confuses the steps he has to take, and hence we get confused. He doesn't explain why we have to do any of the steps of ETL. Bad waste of time.I got to this course specifically because of the ETL/SSIS part, and it was very poorly explained. Not engaging. Don't recommend this course to anyone.
Harikrishna
November 24, 2022
there were no answers to the questions asked. this is 2022 and, there are lot of changes in 2019 installation without proper tool installation - this course is not suitable to any one.
Yash
September 1, 2022
It was very good, I got to learn all the basics of Power Bi, SQL, and so many things about Data Analytics
Kim
March 27, 2022
This is very good basis information for data analysis with SQL. Power BI is very basic for beginner! This course is good for starting in data analysis, how to install SQL server and Power BI desktop. The teacher is very good at his knowledge and try to update the newest version of software, however the database is used the version 2014. That does not affect the SQL queries. Thank you for the course!
Brennan
February 17, 2022
Course skips over reasoning of why certain options are being selected, or why you may want to select other values. Instead, the instructions are simply "click on this" with no rationale as to why. A number of videos should be re-shot to remove errors the instructor encounters - there's a lot of going back and forth to fix things that were done in previous lessons. As an introduction to SSIS, this is fine, but I would have preferred a deeper dive into some of the concepts.
Ajay
September 22, 2021
Trainer did not provide any live examples to work on SQL. Would not recommend this course. NOt sure why udemy is promoting this
Mohammed
May 15, 2021
So far, so good. However, he does spend too much time on unnecessary stuffs like system requirements, various versions of SQL servers etc so far. He speaks bit slow and I understand he does that for someone whose grip of English is poor but it can also annoy people whose grip of English is high and want to speed things up.
James
April 9, 2021
There is useful content but a lot of padding too, it feels as though a lot of this could be done more quickly
Juan
March 12, 2021
Excelente material y buenas prácticas. El material y la forma como se presenta los laboratorios son precisos. Gracias

Coupons

DateDiscountStatus
3/9/2021100% OFF
expired
3/28/202178% OFF
expired
8/16/202278% OFF
expired
4/26/202382% OFF
expired

Charts

Price

Data Analyst - ETL/SSIS/SQL/PowerBI - Price chart

Rating

Data Analyst - ETL/SSIS/SQL/PowerBI - Ratings chart

Enrollment distribution

Data Analyst - ETL/SSIS/SQL/PowerBI - Distribution chart

Related Topics

3895330
udemy ID
3/6/2021
course created date
3/9/2021
course indexed date
Bot
course submited by