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

سرفصل های دوره

Gain skills you need to succeed as a data analyst.

1 - Setting Up R Environment

1 - Introduction

2 - What is R.html

3 - Installing R on Windows

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

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

7 - Installing R Studio on Macs.html

8 - Exploring R Studio Default Interface

9 - Creating a new project in R Studio

10 - What are Packages.html

11 - How to install Packages

12 - Data sets vs Data frames.html

13 - Loading Packages

14 - Importing data into R Studio

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

16 - Installing Janitor Package

17 - Cleaning columns

18 - Selecting a subset of data

19 - Performing multiple operations using Pipe operator

20 - Creating new columns from existing columns

21 - Create a new R Project

22 - Load data into new project

23 - What is Data Wrangling.html

24 - Data Wrangling steps.html

25 - Importance of data wrangling.html

26 - Perform Data Wrangling on Data

27 - Create a scatter plot

28 - Create a bar graph

29 - Adding Labels to plots

2 - SQL Server Environment Setup

30 - What is SQL Server

31 - What is SQL

32 - What is TSQL

33 - Download SQL Server

34 - Install SQL Server

35 - SQL Server Editions

36 - Install SSMS

37 - Connect SSMS to SQL Server

38 - Download Sample Database

39 - Database Concepts

40 - Database Normalisation

41 - Create database

3 - Data Exploration with SQL

42 - Data Preparation

43 - Importing Datasets into database

44 - How many continents do we have data for

45 - What is possibility of dying from COVID

46 - What percentage of population is infected with COVID

47 - What countries has highest COVID infection per population

48 - What countries has the highest deaths from COVID

49 - What continent has highest deaths from COVID

50 - What are the global COVID cases and death

51 - What number of people have been vaccinated against COVID

52 - Analysing data with SQL CTE

53 - Using temporary tables for data

54 - Using Views for data

4 - Python Environment Setup

55 - What is Python

56 - What is Jupyter Notebook

57 - Installing Jupyter Notebook Server

58 - Running Jupyter Notebook Server

59 - Common Jupyter Notebook Commands

60 - Jupyter Notebook Components

61 - Jupyter Notebook Dashboard

62 - Jupyter Notebook Interface

63 - Creating a new Jupyter Notebook

5 - Data Analysis and visualization with Python

64 - Kaggle Datasets

65 - Tabular data

66 - Exploring Pandas DataFrame

67 - Analysing and manipulating pandas dataframe

68 - What is data cleaning

69 - Basic data cleaning

70 - Data Visualization

71 - Visualizing qualitative data

72 - Visualizing quantitative data

6 - Data Analysis Visualization with Power BI

73 - Microsoft 365

74 - Getting started with Microsoft 365

75 - What is Power BI

76 - What is Power BI Desktop

77 - Installing Power BI Desktop

78 - Exploring Power BI Desktop

79 - Power BI Overview Part 1

80 - Power BI Overview Part 2

81 - Power BI Overview Part 3

82 - Components of Power BI

83 - Building blocks of Power BI

84 - Power BI Service

85 - Connecting to web data

86 - Clean and transform data Part 1

87 - Clean and transform data Part 2

88 - Combining data sources

89 - Data visualization with Power BI Part 1

90 - Data visualization with Power BI Part 2

91 - Publishing reports to Power BI Service

92 - Connect Power BI to SQL Server

93 - Import SQL Data into Power BI

94 - Analyze data create visualization

95 - How to Publish your report to Power BI Service

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training