image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
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.
Some responsibilities of a data analyst includes:
Developing records management processes and policies
identify areas to increase efficiency and automation of processes
set up and maintain automated data processes
identify, evaluate and implement external services and tools to support data validation and cleansing
produce and track key performance indicators
develop and support reporting processes
monitor and audit data quality
liaise with internal and external clients to fully understand data content
gather, understand and document detailed business requirements using appropriate tools and techniques
design and carry out surveys and analyse survey data
manipulate, analyse and interpret complex data sets relating to the employer's business
prepare reports for internal and external audiences using business analytics reporting tools
create data dashboards, graphs and visualisations
provide sector and competitor benchmarking
mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool
In this course we will perform some task of a Data Analyst  using Python ,Excel, SQL, and  Power BI.  We will connect to a variety of data sources, perform  data transformation ,cleaning and  exploration . We will create dashboards to visual data  .
Who this course is for:
Beginner Data Analyst
Beginner Data Scientist

What you'll learn

Perform data analysis & visualization with Python

Perform data analysis & visualization with Excel

Perform data exploration and analysis with SQL

Perform data analysis & visualization with Power BI

Write SQL Queries to explore and analyse data

Connect to multiple data sources with Power BI

Clean & transform data

Create Dashboards with Power BI

Write SQL temporary table queries to extract and query data

Write SQL CTE queries to extract and query data

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Python and Jupyter Notebook Setup
12
1.1-Introduction
1.2-What is Data Analysis
1.3-What is Python
1.4-What is Jupyter Notebook
1.5-Installing Jupyter Notebook Server
1.6-Running Jupyter Notebook Server
1.7-Jupyter Notebook Commands
1.8-Jupyter Notebook Components
1.9-Jupyter Notebook Dashboards
1.10-Creating a new notebook
1.11-Jupyter Notebook user interface
1.12-Python and Jupyter Notebook Setup
2-Data Analysis & Visualization with Python & Jupyter Notebook
10
2.1-Kaggle Datasets
2.2-Tabular data
2.3-Exploring Pandas Data frame
2.4-Manipulating Pandas Data frame
2.5-What is data cleaning
2.6-Performing data cleaning
2.7-What is data visualization
2.8-Qualitative data visualization
2.9-Quantitative data visualization
2.10-Data Analysis & Visualization with Python & Jupyter Notebook
3-Data Analysis & Visualization with Excel
18
3.1-What is Power Pivot
3.2-Versions of Power Pivot
3.3-Enabling Power Pivot in Excel
3.4-What is Power query
3.5-Please Read
3.6-Connecting to data source
3.7-Preparing your query
3.8-Cleansing data
3.9-Enhancing your query
3.10-Creating a data model
3.11-Build data relationships
3.12-Create lookups as new fields with DAX
3.13-Analyse data using Pivot tables
3.14-Analyse data with Pivot charts
3.15-Refreshing source data
3.16-Updating queries
3.17-Creating new reports
3.18-Data Analysis & Visualization with Excel
4-Microsoft SQL Server Setup
8
4.1-What is SQL Server
4.2-SQL Server Editions
4.3-Download SQL Server
4.4-Install SQL Server
4.5-Install SSMS
4.6-Connect SSMS to SQL Server
4.7-Create a database
4.8-Microsoft SQL Server Setup
5-Data Exploration & Analysis with SQL
14
5.1-Data Preparation
5.2-Importing datasets into database
5.3-How many continents do we have data for
5.4-Possibility of dying from COVID
5.5-Percent of population infected with COVID
5.6-Countries with highest infection
5.7-Countries with highest COVID deaths
5.8-Continents with highest COVID deaths
5.9-Global Covid deaths
5.10-Number vaccinated against COVID
5.11-Exploring data with temporary tables
5.12-Exploring data with views
5.13-What is the purpose of Common Table Expressions (CTEs) in SQL?
5.14-Exploring data with CTE
6-Power BI Setup
8
6.1-What is Power BI
6.2-what is Power BI Desktop
6.3-Install Power BI Desktop
6.4-Explore Power BI Interface
6.5-Microsoft 365 setup
6.6-Exploring Microsoft 365
6.7-Add users to Microsoft 365
6.8-Power BI Setup
7-Power BI Overview
6
7.1-Power BI Overview : Part 1
7.2-Power BI Overview : Part 2
7.3-Power BI Overview : Part 3
7.4-Components of Power BI
7.5-Building blocks of Power BI
7.6-Power BI Apps
8-Data Analysis & Visualization with Power BI
8
8.1-Connect to data source
8.2-Clean & transform data : part 1
8.3-Clean & transform data : part 2
8.4-Combine data source
8.5-Create visualization : Part 1
8.6-Create visualization : Part 2
8.7-Publish report to Power BI Service
8.8-Data Analysis & Visualization with Power BI
9-Analyse & consume database data with Power BI
7
9.1-Connect to SQL Server with Power BI
9.2-What is PostgreSQL
9.3-Install PostgreSQL
9.4-Connect to PostgreSQL
9.5-Install sample database
9.6-Connect to PostgreSQL with Power BI : Part 1
9.7-Connect to PostgreSQL with Power BI : Part 2
10-Transforming Data with Power BI
19
10.1-Importing Microsoft access database file
10.2-Changing locale settings
10.3-Connect to data source
10.4-Power query editor and queries
10.5-Creating & managing query groups
10.6-Renaming queries
10.7-Splitting columns
10.8-Changing data types
10.9-Removing & reordering columns
10.10-Duplicating & adding columns
10.11-Creating conditional columns
10.12-Connecting to files in folder
10.13-Appending queries
10.14-Merge queries
10.15-Query dependency view
10.16-Transform less structured data
10.17-Create tables
10.18-Query Parameters
10.19-Transforming Data with Power BI
11-Capstone Project
2
11.1-Project Steps
11.2-Example Solution Guide to project