Data Analysis for Entry Level Job – ( 9 courses in 1 )

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

1. Introduction

1. Hello

2. Introduction

3.1 Data Analysis Resourses.rar

3. Resources.html

4. Welcome

2. Python Programming language

1. Installation - Python

2. Installation - VS Code

3. Tour

4. Setup and Hello World

5. Drawing a Shape

6. DataTypes

7. Variables

8. Strings

9. Numbers

10. Taking an Input

11. Lists

12. List_functions

13. Tuples

14. Dictionaries

15. Functions

16. Return Statement

17. Operators

18. If Statement

19. If Statements & Comparisons

20. While Loop

21. For Loops

22. Exponent Function

23. 2D Lists & Nested Loops

24. Comments

25. Try & Except

26. Reading Files

27. Writing Files

3. Oop

1. Introduction

2. What is oop

3. Encapsulation

4. Abstraction

5. Inheritance

6. Polymorphism

4. Microsoft Excel

1. MicroSoft Excel

2. Customization

3. Shortcuts

4. Mathematics Operations

5. Data Validation

6. Filters

7. Shorting

8. Grouping

9. Functions

10. Minimum and Maximum Values

11. Average

12. Count

13. Is Numeric Function

14. RAND Function

15. Round Function

16. Median

17. Power

18. Left Right and Mid Function

19. Find Function

20. Date Function

21. IF Condition

22. IF ERROR Condition

23. Nested IF Condition

24. AND

25. OR

26. VLOOKUP

27. Pivot Table

28. Pie Chart

29. Column Chart

30. Line Chart

31. Other Charts

5. Reminder

1. Reminder

6. Advanced Excel

1. Index and Match Function

2. SUM IF Formula

3. Sum Offset Formula

4. IF AND CONDITION

5. CONCATINATE

6. PMT FORMULA

7. TRIM FUNCTION

8. CHOOSE FUNCTION

9. XNPV Function

10. XIRR Function

11. COUNTA()

12. FV Function

13. RANDBETWEEN

14. SMALL FUNCTION

15. QUARITILE FUNCTION

16. MACROS

7. Pandas

1. Data Description

2. Importing the data

3. Series

4. Creating a DataFrame

5. Homework

6. Data Cleaning

7. Mean Median Mode

8. Empty cells

9. Wrong Data

10. Wrong Datatype

11. Duplicates

12. Correlation Introduction

13. Correlation

8. Numpy

1. NumPy and its Applications

2. Initializing an Array

3. NumPy Datatypes

4. AccessingChanging Specific Elements

5. Initializing Different Arrays (1s, 0s, full, random, etc)

6. Basic Mathematics

7. Other Mathematical Functions.html

8. Linear Algebra and Statistics

9. Reorganizing Arrays

10. Load data using NumPy

11. Advanced Indexing and Boolean Masking

9. Looker For Data Visualization

1. Looker Introduction

2. Key Features

3. Sign Up

4. Import Data

5. Interface

6. Templates

7. Data Description

8. Text

9. Image

10. Line and Arrows

11. Shapes

12. Table

13. Scorecard

14. Timeseries

15. Bar Chart

16. Pie Chart

17. Google Map Charts

18. Google Map Chart Heatmap

19. Line Chart

20. Line Chart 2

21. Area Charts

22. Scatter Plots

23. Pivot Table

24. Bullet Charts

25. Tree Maps

26. Gauge Plot

27. Controls

28. Themes and Layouts

29. Filter

30. Blending Data

31. New Field and Formulas

32. Share

10. Seaborn - Data Visualization

1. Importing the data

2. DISPLOT

3. Uses of distribution plot

4. KDE introduction

5. KDE Plot Part 1

6. KDE Plot Part 2

7. Scatter Plot

8. Rug Plot

9. Joint Plot

10. Pair Plot

11. Bar Plot

12. Count Plot

13. Box Plot

14. Violin Plot

15. Strip Plot

16. Swarm Plot

17. Heat Map

18. Pair Grid

19. Sub Plots

11. PostgreSQL

1. Installation

2. Select Statement

3. Creating a table

4. Insert data into a table

5. Alter data in a table

6. Drop a column

7. Drop a row

8. Order by command

9. Limit, Alias, Distinct

10. WHERE, AND, OR, IN, BETWEEN

11. Aggregate and Group by command

12. Advanced PostgreSQL

1. Create database and drop table

2. Create table and Foreign Key

3. Insert data

4. Update using SET

5. Delete Records

6. Display Specific Columns

7. Display Specific Rows

8. ORDER BY - LIMIT

9. WHERE - NOT

10. BETWEEN

11. Equal to, Not Equal to

12. Nested Queries

13. LIKE Condition

14. DISTINCT

15. Connect Two Tables

16. JOINS

17. EXCEPT

18. Special Query

13. Instagram clone Database

1. Create Database and Users Table

2. Phots Table

3. Comment Table

4. Like Table

5. Follows Table

6. Tags Table

7. Photos Tags Table

8. Insert Data

9. Query 1

10. Query 2

11. Query 3

12. Query 4

13. Query 5

14. Query 6

15. Query 7

16. Query 8

17. Query 9

14. Certificate

1. Certificate

53,700 تومان

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

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

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

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