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

Focused View

Jobshie Academy

16:43:02

167 View

1. Introduction

1. Hello.mp4

01:43

2. Introduction.mp4

05:06

3.1 Data Analysis Resourses.rar

3. Resources.html

4. Welcome.mp4

00:53

2. Python Programming language

1. Installation - Python.mp4

03:57

2. Installation - VS Code.mp4

01:39

3. Tour.mp4

02:52

4. Setup and Hello World.mp4

08:02

5. Drawing a Shape.mp4

02:33

6. DataTypes.mp4

04:24

7. Variables.mp4

07:28

8. Strings.mp4

20:34

9. Numbers.mp4

12:57

10. Taking an Input.mp4

03:31

11. Lists.mp4

09:27

12. List_functions.mp4

09:27

13. Tuples.mp4

03:52

14. Dictionaries.mp4

04:12

15. Functions.mp4

08:48

16. Return Statement.mp4

05:18

17. Operators.mp4

02:23

18. If Statement.mp4

12:51

19. If Statements & Comparisons.mp4

03:44

20. While Loop.mp4

04:23

21. For Loops.mp4

08:05

22. Exponent Function.mp4

03:41

23. 2D Lists & Nested Loops.mp4

04:01

24. Comments.mp4

01:38

25. Try & Except.mp4

03:45

26. Reading Files.mp4

03:54

27. Writing Files.mp4

03:04

3. Oop

1. Introduction.mp4

03:00

2. What is oop.mp4

10:37

3. Encapsulation.mp4

07:34

4. Abstraction.mp4

06:05

5. Inheritance.mp4

05:27

6. Polymorphism.mp4

06:11

4. Microsoft Excel

1. MicroSoft Excel.mp4

01:19

2. Customization.mp4

08:26

3. Shortcuts.mp4

02:18

4. Mathematics Operations.mp4

09:40

5. Data Validation.mp4

03:59

6. Filters.mp4

04:46

7. Shorting.mp4

01:54

8. Grouping.mp4

04:49

9. Functions.mp4

04:33

10. Minimum and Maximum Values.mp4

01:24

11. Average.mp4

02:09

12. Count.mp4

00:59

13. Is Numeric Function.mp4

01:24

14. RAND Function.mp4

02:41

15. Round Function.mp4

00:53

16. Median.mp4

00:51

17. Power.mp4

00:38

18. Left Right and Mid Function.mp4

02:35

19. Find Function.mp4

03:30

20. Date Function.mp4

02:23

21. IF Condition.mp4

02:24

22. IF ERROR Condition.mp4

02:10

23. Nested IF Condition.mp4

02:38

24. AND.mp4

02:16

25. OR.mp4

01:32

26. VLOOKUP.mp4

03:02

27. Pivot Table.mp4

05:02

28. Pie Chart.mp4

01:38

29. Column Chart.mp4

00:36

30. Line Chart.mp4

00:51

31. Other Charts.mp4

00:39

5. Reminder

1. Reminder.mp4

00:25

6. Advanced Excel

1. Index and Match Function.mp4

04:50

2. SUM IF Formula.mp4

01:26

3. Sum Offset Formula.mp4

07:09

4. IF AND CONDITION.mp4

03:01

5. CONCATINATE.mp4

02:30

6. PMT FORMULA.mp4

02:54

7. TRIM FUNCTION.mp4

02:07

8. CHOOSE FUNCTION.mp4

01:59

9. XNPV Function.mp4

04:02

10. XIRR Function.mp4

01:48

11. COUNTA().mp4

02:25

12. FV Function.mp4

03:12

13. RANDBETWEEN.mp4

01:55

14. SMALL FUNCTION.mp4

01:48

15. QUARITILE FUNCTION.mp4

01:59

16. MACROS.mp4

04:33

7. Pandas

1. Data Description.mp4

04:12

2. Importing the data.mp4

15:29

3. Series.mp4

03:42

4. Creating a DataFrame.mp4

07:43

5. Homework.mp4

00:31

6. Data Cleaning.mp4

03:02

7. Mean Median Mode.mp4

02:11

8. Empty cells.mp4

08:33

9. Wrong Data.mp4

12:51

10. Wrong Datatype.mp4

06:10

11. Duplicates.mp4

05:30

12. Correlation Introduction.mp4

01:53

13. Correlation.mp4

02:01

8. Numpy

1. NumPy and its Applications.mp4

03:42

2. Initializing an Array.mp4

02:38

3. NumPy Datatypes.mp4

06:19

4. AccessingChanging Specific Elements.mp4

11:06

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

09:55

6. Basic Mathematics.mp4

04:49

7. Other Mathematical Functions.html

8. Linear Algebra and Statistics.mp4

07:56

9. Reorganizing Arrays.mp4

05:00

10. Load data using NumPy.mp4

02:27

11. Advanced Indexing and Boolean Masking.mp4

03:38

9. Looker For Data Visualization

1. Looker Introduction.mp4

01:46

2. Key Features.mp4

08:22

3. Sign Up.mp4

01:48

4. Import Data.mp4

10:09

5. Interface.mp4

09:45

6. Templates.mp4

03:39

7. Data Description.mp4

05:52

8. Text.mp4

07:38

9. Image.mp4

03:07

10. Line and Arrows.mp4

03:44

11. Shapes.mp4

01:53

12. Table.mp4

21:42

13. Scorecard.mp4

08:20

14. Timeseries.mp4

20:28

15. Bar Chart.mp4

10:00

16. Pie Chart.mp4

08:46

17. Google Map Charts.mp4

10:55

18. Google Map Chart Heatmap.mp4

04:03

19. Line Chart.mp4

14:11

20. Line Chart 2.mp4

06:00

21. Area Charts.mp4

09:49

22. Scatter Plots.mp4

07:04

23. Pivot Table.mp4

11:55

24. Bullet Charts.mp4

03:41

25. Tree Maps.mp4

03:51

26. Gauge Plot.mp4

04:31

27. Controls.mp4

09:41

28. Themes and Layouts.mp4

05:07

29. Filter.mp4

01:14

30. Blending Data.mp4

05:24

31. New Field and Formulas.mp4

04:13

32. Share.mp4

03:55

10. Seaborn - Data Visualization

1. Importing the data.mp4

06:29

2. DISPLOT.mp4

07:08

3. Uses of distribution plot.mp4

02:25

4. KDE introduction.mp4

07:45

5. KDE Plot Part 1.mp4

07:03

6. KDE Plot Part 2.mp4

15:04

7. Scatter Plot.mp4

11:40

8. Rug Plot.mp4

03:45

9. Joint Plot.mp4

07:55

10. Pair Plot.mp4

05:55

11. Bar Plot.mp4

12:04

12. Count Plot.mp4

02:00

13. Box Plot.mp4

06:33

14. Violin Plot.mp4

04:50

15. Strip Plot.mp4

04:16

16. Swarm Plot.mp4

03:37

17. Heat Map.mp4

09:25

18. Pair Grid.mp4

08:45

19. Sub Plots.mp4

05:16

11. PostgreSQL

1. Installation.mp4

03:07

2. Select Statement.mp4

01:09

3. Creating a table.mp4

06:54

4. Insert data into a table.mp4

07:36

5. Alter data in a table.mp4

03:21

6. Drop a column.mp4

01:23

7. Drop a row.mp4

01:55

8. Order by command.mp4

03:55

9. Limit, Alias, Distinct.mp4

05:00

10. WHERE, AND, OR, IN, BETWEEN.mp4

09:17

11. Aggregate and Group by command.mp4

05:29

12. Advanced PostgreSQL

1. Create database and drop table.mp4

04:10

2. Create table and Foreign Key.mp4

11:48

3. Insert data.mp4

05:38

4. Update using SET.mp4

02:31

5. Delete Records.mp4

01:25

6. Display Specific Columns.mp4

02:02

7. Display Specific Rows.mp4

01:28

8. ORDER BY - LIMIT.mp4

01:56

9. WHERE - NOT.mp4

00:58

10. BETWEEN.mp4

03:11

11. Equal to, Not Equal to.mp4

01:17

12. Nested Queries.mp4

05:33

13. LIKE Condition.mp4

03:55

14. DISTINCT.mp4

01:16

15. Connect Two Tables.mp4

05:48

16. JOINS.mp4

04:41

17. EXCEPT.mp4

04:19

18. Special Query.mp4

05:44

13. Instagram clone Database

1. Create Database and Users Table.mp4

05:36

2. Phots Table.mp4

02:14

3. Comment Table.mp4

01:57

4. Like Table.mp4

01:43

5. Follows Table.mp4

01:25

6. Tags Table.mp4

00:58

7. Photos Tags Table.mp4

01:36

8. Insert Data.mp4

05:58

9. Query 1.mp4

02:19

10. Query 2.mp4

05:54

11. Query 3.mp4

02:42

12. Query 4.mp4

01:30

13. Query 5.mp4

02:59

14. Query 6.mp4

03:02

15. Query 7.mp4

05:08

16. Query 8.mp4

01:16

17. Query 9.mp4

04:16

14. Certificate

1. Certificate.mp4

00:49

Description

What You'll Learn?

Learn Microsoft Excel for Data Analysis
Learn Python Programming language for Data Analysis and Data Science
Learn SQL/PostgreSQL for database design and handing big data
Learn Pandas and Numpy for data manipulation and Mathematical calculations.
Learn Data Visualization in Python - Beginner to Advanced
Learn Oops Concepts - Encapsulation + Abstraction + Inheritance + Polymorphism
Learn Looker - For Data Visualization
Learn Google Data Studio for Data Visualization

Who is this for?

Entry level Job seekers for data analysis.

Who wants to learn Python, Microsoft Excel, PostgreSQL, Numpy, Pandas, Data Visualization in Python, Oops, Google Data Studio, Looker

Data analysts who wants to enhance there skills

More details

Description
Hello and welcome to this full and comprehensive course on data analysis.

This is your path to a career in data analytics. In this program, youâ€™ll learn in-demand skills that will have you job-ready in less than a month. No degree or experience is required.

After completing this course, you will be ready for the following job titles:
Junior Data Analyst, Associate Data Analyst, Junior Data Scientist, Finance Analyst, Operations Analyst, Data Technician, Business Performance Analyst, Marketing Analyst, Healthcare Analyst

You will get Get professional training to kick start your career. There are 380,000 U.S. job openings in data analytics with a $74,000 median entry-level salary. Around 2 lakh job openings are on LinkedIn itself.

This is not a single course but a bundle of Over 9 courses that are carefully designed to transform you from a beginner to an expert. , You will gain in-demand skills that prepare you for an entry-level job.

What is data analysis?

Data analytics is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making.

Skills you will learn:
Microsoft Excel: Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming etc.

Postgresql: PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Python programming language: Python is a popular general-purpose programming language. It is used in machine learning, web development, desktop applications, and many other fields.

Pandas and Numpy library: Pandas is a python library. It is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language( We will learn more about libraries inside our course)

NumPy is also a python library, With the help of NumPy library, we can create and manipulate multi-dimensional arrays and matrices, and we can use a large collection of high-level mathematical functions to operate on these arrays.

Seaborn library for Data visualization: Seaborn is also a python library built on top of matplotlib and closely integrated with pandas data structures in Python. Visualization is the central part of Seaborn, which helps in the exploration and understanding of data. With the help of data Visualization, we can quickly convey our analysis to others. Itâ€™s like storytelling.

Google Data Studio ( Looker ): Google Data Studio is an incredibly easy-to-use drag-and-drop tool that allows a multitude of different visualizations to be created in minutes. The addition of filtering tools produces stunning reports that will take your data analysis to the next level.
Google Data Studio is available free to people with a Google or Gmail account.

OOPS: Object Oriented programming is one of the most asked technical interview topics. So, if you want to ace your interviews, you need a thorough understanding of OOPs (Object Oriented Programming).
Object-oriented programming is one of the most sought-after skills in the programming world, and as a web developer, if you master it, youâ€™ll stand out from the rest.
So, if you'd like to delve deep into the exciting world of OOPs, especially with Javascript as your language of choice, this course is perfect for you.

Jobshie Academy Reviews
300+ learner reviews | 4+ average rating
We help learners across the globe develop new skills and achieve their personal and professional goals. Browse learner reviews below to discover how people enjoy the online learning experience at Jobshie Academy.

"I have gained useful skills while learning this course. I can consider myself a data analysis specialist. Thank you"
by Joseph Israel

"I was a nice experience about this course as it introduces with many topics which are related to data analysis ."
by Sreeraj Mopkar

"very good explaination , bohot achhe se sab samajh aata hai ...100% Understanding all concept very much....excellent explanation"
by Moosa Khan

"The course is very instructive and didactic, I liked it, it is all the information I need for my activities"
by Jaime Ronald Palma Aguilar

"yeah it was such a great course, the teacher took time out to disect all angles of Excel, he touched all the essential parts, needed for our daily use of excel. Thanks a lot"
by Unyime Joshua

"The instructor is very knowledgeable and teach in a very engaging way. I totally recommend this course.????"
by Aditya

Once you complete this course, you will be proficient in all these tools. In this course, you not only learn about how to use these tools but also why and when to use these tools. You will think like a pro data analyst after completing this course.

Learn By Practice
You will have hands-on practice through carefully designed quizzes, exercises, projects, and coding challenges to make sure you actually learning the concepts.
The projects you complete in this course can be included in your resume, and these real-world projects will help you in getting your dream job.

No Prerequisites
Because everything is covered in this course from scratch, you donâ€™t need to have any prior knowledge of anything. You just need a computer and internet connection. So, there are no prerequisites for this course.

Incredible Doubt Support
If you face any problem or if you have any doubt, you personally message me, or you can post your doubt on the Question answer form. I will personally answer your doubt within a few hours.

So, what are you waiting for? Enroll now, and I will see you in the class.

Who this course is for:
Entry level Job seekers for data analysis.
Who wants to learn Python, Microsoft Excel, PostgreSQL, Numpy, Pandas, Data Visualization in Python, Oops, Google Data Studio, Looker
Data analysts who wants to enhance there skills

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Jobshie Academy

Instructor's Courses

I have working experience of Data Analysis of more than three years. I create videos on SQL, Big query, Data Science, Data Analysis, Python, Machine Learning, Deep Learning. There are more than 70000 Enrollments in my courses. My most popular course is: Data Analysis for Entry Level Job - Zero to Hero Skill Path

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.