Data Analyst Skills For Beginners - (Sql,R,Python,Power Bi )

What you'll learn
Connect to various data sources
Clean and transform data
Perform exploratory data analysis
Manipulate data using data frames
Create visualizations from data
Analyse data with SQL
Analyse data with Python
Analyse data with Power BI
Analyse data with R
Requirements
No prior coding experience required.
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. A data analyst collects, organises and studies data to provide business insight.Data analyst applies various tools and techniques for data analysis and data visualisation (including the use of business information tools) to identify, collect and migrate data to and from a range of systems manage, clean, abstract and aggregate data alongside a range of analytical studies on that data manipulate and link different data sets summarise and present data and conclusions in the most appropriate format for users.R is a programming language. R is often used for statistical computing and graphical presentation to analyse and visualize data. R provides a wide variety of statistical (linear and nonlinear modelling, classical statistical tests, time-series analysis, classification, clustering, .) and graphical techniques, and is highly extensible. SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It's been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data.Python is a popular programming language. Python can be used on a server to create web applications and also for data analysis and visualization. Analysing data with Python is an essential skill for Data Scientists and Data Analysts .Power BI is a cloud-based business analytics service from Microsoft that enables anyone to visualize and analyse data, with better speed and efficiency. It is a powerful as well as a flexible tool for connecting with and analysing a wide variety of data. Power BI also has a desktop version that can be used for data analysis and visualization.Gain skills you need to succeed as a data analyst! No prior coding experience required.
Overview
Section 1: Setting Up R Environment
Lecture 1 Introduction
Lecture 2 What is R
Lecture 3 Installing R on Windows
Lecture 4 Installing R on Macs
Lecture 5 What is R Studio
Lecture 6 Installing R Studio on Windows
Lecture 7 Installing R Studio on Macs
Lecture 8 Exploring R Studio Default Interface
Lecture 9 Creating a new project in R Studio
Lecture 10 What are Packages
Lecture 11 How to install Packages
Lecture 12 Data sets vs Data frames
Lecture 13 Loading Packages
Lecture 14 Importing data into R Studio
Lecture 15 How to read data in a csv file with R
Lecture 16 Installing Janitor Package
Lecture 17 Cleaning columns
Lecture 18 Selecting a subset of data
Lecture 19 Performing multiple operations using Pipe operator
Lecture 20 Creating new columns from existing columns
Lecture 21 Create a new R Project
Lecture 22 Load data into new project
Lecture 23 What is Data Wrangling
Lecture 24 Data Wrangling steps
Lecture 25 Importance of data wrangling
Lecture 26 Perform Data Wrangling on Data
Lecture 27 Create a scatter plot
Lecture 28 Create a bar graph
Lecture 29 Adding Labels to plots
Section 2: SQL Server Environment Setup
Lecture 30 What is SQL Server
Lecture 31 What is SQL
Lecture 32 What is T-SQL
Lecture 33 Download SQL Server
Lecture 34 Install SQL Server
Lecture 35 SQL Server Editions
Lecture 36 Install SSMS
Lecture 37 Connect SSMS to SQL Server
Lecture 38 Download Sample Database
Lecture 39 Database Concepts
Lecture 40 Database Normalisation
Lecture 41 Create database
Section 3: Data Exploration with SQL
Lecture 42 Data Preparation
Lecture 43 Importing Datasets into database
Lecture 44 How many continents do we have data for
Lecture 45 What is possibility of dying from COVID
Lecture 46 What percentage of population is infected with COVID
Lecture 47 What countries has highest COVID infection per population
Lecture 48 What countries has the highest deaths from COVID
Lecture 49 What continent has highest deaths from COVID
Lecture 50 What are the global COVID cases and death
Lecture 51 What number of people have been vaccinated against COVID
Lecture 52 Analysing data with SQL CTE
Lecture 53 Using temporary tables for data
Lecture 54 Using Views for data
Section 4: Python Environment Setup
Lecture 55 What is Python
Lecture 56 What is Jupyter Notebook
Lecture 57 Installing Jupyter Notebook Server
Lecture 58 Running Jupyter Notebook Server
Lecture 59 Common Jupyter Notebook Commands
Lecture 60 Jupyter Notebook Components
Lecture 61 Jupyter Notebook Dashboard
Lecture 62 Jupyter Notebook Interface
Lecture 63 Creating a new Jupyter Notebook
Section 5: Data Analysis and visualization with Python
Lecture 64 Kaggle Datasets
Lecture 65 Tabular data
Lecture 66 Exploring Pandas DataFrame
Lecture 67 Analysing and manipulating pandas dataframe
Lecture 68 What is data cleaning
Lecture 69 Basic data cleaning
Lecture 70 Data Visualization
Lecture 71 Visualizing qualitative data
Lecture 72 Visualizing quantitative data
Section 6: Data Analysis & Visualization with Power BI
Lecture 73 Microsoft 365
Lecture 74 Getting started with Microsoft 365
Lecture 75 What is Power BI
Lecture 76 What is Power BI Desktop
Lecture 77 Installing Power BI Desktop
Lecture 78 Exploring Power BI Desktop
Lecture 79 Power BI Overview - Part 1
Lecture 80 Power BI Overview - Part 2
Lecture 81 Power BI Overview - Part 3
Lecture 82 Components of Power BI
Lecture 83 Building blocks of Power BI
Lecture 84 Power BI Service
Lecture 85 Connecting to web data
Lecture 86 Clean and transform data - Part 1
Lecture 87 Clean and transform data - Part 2
Lecture 88 Combining data sources
Lecture 89 Data visualization with Power BI - Part 1
Lecture 90 Data visualization with Power BI - Part 2
Lecture 91 Publishing reports to Power BI Service
Lecture 92 Connect Power BI to SQL Server
Lecture 93 Import SQL Data into Power BI
Lecture 94 Analyze data & create visualization
Lecture 95 How to Publish your report to Power BI Service
Beginner Data Analyst,Beginner Data Scientist

Homepage