Data Analysis for Beginners

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

Learn the exact technical skills in Excel, Power BI and SQL that you need to land your first job as a Data Analyst

1. Introduction

1. Welcome Introduction

2. Excel - Data Entry

1. Introduction

2.1 Excel for web.html

2. Downloading Excel

3. Active Cell

4. Excel Introduction

5. Entering Data

6. Auto-Fit

7. Auto-Complete

8. Entering Numbers

9. Inserting & Deleting ColumnsRows

10. Auto Sequencing

11. Navigating Edges

12. Selecting Cells

13. Number Formatting

14. Numbers & Fractions

15. Currency & Accounting

16. Percentage

17. Date Format

18. Time Format

19. Data Entry.html

3. Excel - Formatting

1. Bold, Italics & Underline

2. Borders

3. Fill & Font

4. Alignment

5. Formatting.html

4. Excel - Editing

1. Editing a cell

2. Autofill

3. Copy & Paste

4. Sorting

5. Filter

6. Find and Replace

7. Editing Quiz.html

5. Excel - Calculations

1.1 Test sample.xlsx

1. Download File

2. Signs

3. Functions

4. Auto-Sequence with calculations

5. SUM

6. SUMIF

7. SUMIFS

8. COUNT

9. COUNTIF

10. COUNTIFS

11. MIN, MAX, AVERAGE

12. IFELSE

13. VLOOKUP

14. TRIM

15. LEFTRIGHT

16. FIND

17. LENMID

18. REPLACE

19. Calculations.html

6. Excel - Visualisations

1. Tables

2. Slicers

3. Pivot Tables

4. Pivot Charts

5. Conditional Formatting

6. Save As

7. Visualisations.html

7. Excel - Power Query

1. Fetching Data

2. Power Query Editor

3. Adding Columns

4. Conditional Column

5. Close & Load

6. Key Takeaways

7. Excel Power Query.html

8. Power BI - Load Data

1. Power BI introduction

2.1 Download Power BI Desktop.html

2.2 Power BI for web.html

2. Download Power BI

3.1 list of countries and dependencies.csv

3. Get Data

9. Power BI - Data Transformation

1. Power Query

2.1 countries.csv

2. New Query

3. Merge Query

4. Load Data to Model

5. Data Transformation.html

10. Power BI - Report Editor

1. Report View

2. Report Editor Intro

11. Power BI - Visualisations

1. Text Box

2. Bringing Data into visualisations

3. Styling Visuals

4. Conditional Formatting

5. General Formatting

6. Filters

7. Slicers

8. Pie Chart

9. Donut Chart

10. More Visuals

11. Column Chart

12. Map VisualSyncing Slicers

13. Slicer Interactions

14. DuplicatingHiding Pages

15. Create new hidden pages

16. Visualisations Quiz.html

12. Power BI - Navigating Reports

1. Buttons

2. Bookmarks

3. Navigating Reports.html

13. Power BI - DAX fields

1. Add a column

2. DAX todays date

3. Measures

4. Save & Publish

5. DAX Fields - Quiz.html

6. Key Takeaways

14. SQL - Getting Started

1. SQL Introduction

2.1 SQLite Download link.html

2. Download SQLite

15. SQL - Databases

1. Create a database

2.1 films.csv

2.2 movie ratings.csv

2. Importing tables

16. SQL - Writing Queries

1. Introduction to SQL

2. Sams Favourite Word

3. Comments

4. Select Statement

5. SELECT DISTINCT

6. WHERE Clause

7. ORDER BY

8. AND

9. OR Operator

10. NOT Operator

11. UPDATE

12. DELETE

13. TOPLIMIT

14. MAX & MIN

15. COUNT

16. SUM

17. LIKE

18. IN Operator

19. BETWEEN

20. ALIASES

21. GROUP BY

22. JOIN

23. SQL.html

24. SQL.html

25. SQL.html

26. SQL.html

27. SQL.html

28. Key Takeaways

17. Project and Outro

1. Employees Analysis project.html

2. Congratulations!

45,900 تومان

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

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

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

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