Data Analyst Skills for beginners - (SQL,R,Python,Power BI )

Focused View

Bluelime Learning Solutions

8:50:19

131 View

1 - Setting Up R Environment

1 - Introduction.mp4

00:20

2 - What is R.html

3 - Installing R on Windows.mp4

02:01

4 - Download-and-install-R-on-Mac.pdf

4 - Installing R on Macs.html

5 - What is R Studio.html

6 - Installing R Studio on Windows.mp4

01:50

7 - Download-and-install-R-Studio.pdf

7 - Installing R Studio on Macs.html

8 - Exploring R Studio Default Interface.mp4

09:32

9 - Creating a new project in R Studio.mp4

05:34

10 - What are Packages.html

11 - How to install Packages.mp4

04:19

12 - Data sets vs Data frames.html

13 - Loading Packages.mp4

06:38

14 - Importing data into R Studio.mp4

05:44

15 - How to read data in a csv file with R.mp4

06:28

16 - Installing Janitor Package.mp4

03:30

17 - Cleaning columns.mp4

11:18

18 - Selecting a subset of data.mp4

04:53

19 - Performing multiple operations using Pipe operator.mp4

09:36

20 - Creating new columns from existing columns.mp4

10:00

21 - Create a new R Project.mp4

05:02

22 - Load data into new project.mp4

06:08

23 - What is Data Wrangling.html

24 - Data Wrangling steps.html

25 - Importance of data wrangling.html

26 - Perform Data Wrangling on Data.mp4

12:25

27 - Create a scatter plot.mp4

06:37

28 - Create a bar graph.mp4

08:39

29 - Adding Labels to plots.mp4

07:52

2 - SQL Server Environment Setup

30 - What is SQL Server.mp4

02:57

31 - What is SQL.mp4

04:32

32 - What is TSQL.mp4

10:27

33 - Download SQL Server.mp4

04:31

34 - Install SQL Server.mp4

09:43

35 - SQL Server Editions.mp4

04:45

36 - Install SSMS.mp4

05:48

37 - Connect SSMS to SQL Server.mp4

02:16

38 - Download Sample Database.mp4

06:28

39 - Database Concepts.mp4

04:31

40 - Database Normalisation.mp4

14:13

41 - Create database.mp4

00:32

3 - Data Exploration with SQL

42 - Data Preparation.mp4

08:36

43 - Importing Datasets into database.mp4

07:31

44 - How many continents do we have data for.mp4

04:52

45 - What is possibility of dying from COVID.mp4

06:38

46 - What percentage of population is infected with COVID.mp4

05:00

47 - What countries has highest COVID infection per population.mp4

05:40

48 - What countries has the highest deaths from COVID.mp4

04:58

49 - What continent has highest deaths from COVID.mp4

02:50

50 - What are the global COVID cases and death.mp4

03:23

51 - What number of people have been vaccinated against COVID.mp4

10:13

52 - Analysing data with SQL CTE.mp4

05:43

53 - Using temporary tables for data.mp4

06:17

54 - Using Views for data.mp4

03:45

4 - Python Environment Setup

55 - What is Python.mp4

05:16

56 - What is Jupyter Notebook.mp4

01:20

57 - Installing Jupyter Notebook Server.mp4

06:45

58 - Running Jupyter Notebook Server.mp4

08:44

59 - Common Jupyter Notebook Commands.mp4

07:28

60 - Jupyter Notebook Components.mp4

04:26

61 - Jupyter Notebook Dashboard.mp4

04:20

62 - Jupyter Notebook Interface.mp4

05:44

63 - Creating a new Jupyter Notebook.mp4

06:45

5 - Data Analysis and visualization with Python

64 - Kaggle Datasets.mp4

03:06

65 - Tabular data.mp4

08:00

66 - Exploring Pandas DataFrame.mp4

02:20

67 - Analysing and manipulating pandas dataframe.mp4

12:57

68 - What is data cleaning.mp4

03:28

69 - Basic data cleaning.mp4

22:42

70 - Data Visualization.mp4

02:35

71 - Visualizing qualitative data.mp4

12:00

72 - Visualizing quantitative data.mp4

13:49

6 - Data Analysis Visualization with Power BI

73 - Microsoft 365.mp4

03:43

74 - Getting started with Microsoft 365.mp4

04:04

75 - What is Power BI.mp4

05:47

76 - What is Power BI Desktop.mp4

03:40

77 - Installing Power BI Desktop.mp4

02:55

78 - Exploring Power BI Desktop.mp4

05:02

79 - Power BI Overview Part 1.mp4

04:24

80 - Power BI Overview Part 2.mp4

04:05

81 - Power BI Overview Part 3.mp4

04:49

82 - Components of Power BI.mp4

02:57

83 - Building blocks of Power BI.mp4

09:31

84 - Power BI Service.mp4

04:28

85 - Connecting to web data.mp4

05:07

86 - Clean and transform data Part 1.mp4

07:12

87 - Clean and transform data Part 2.mp4

09:45

88 - Combining data sources.mp4

07:59

89 - Data visualization with Power BI Part 1.mp4

06:09

90 - Data visualization with Power BI Part 2.mp4

05:23

91 - Publishing reports to Power BI Service.mp4

04:47

92 - Connect Power BI to SQL Server.mp4

03:14

93 - Import SQL Data into Power BI.mp4

01:55

94 - Analyze data create visualization.mp4

01:30

95 - How to Publish your report to Power BI Service.mp4

15:33

Description

Gain skills you need to succeed as a data analyst.

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

Who is this for?

Beginner Data Analyst

Beginner Data Scientist

More details

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.
Who this course is for:
Beginner Data Analyst
Beginner Data Scientist

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.