Data Analyst’s Toolbox: Excel, SQL, Power BI

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

Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights

1. Course Overview

1. Welcome to the Course

2. ----- PART 1. Exploring Data in MS Excel -----

1. MS Excel for Data Analysis

2.1 Working data clean.xlsx

2. Introduction to Data Analyst Role

3. Cleaning and Preparing Tools

1. Sort and Filter

2. Text to Columns

3. Remove Duplicates

4.1 Data Validation.xlsx

4. Data Validation

5. Find, Replace, Go to

6. Data Entry Form

4. Advanced Forumals and Functions

1. Logical Functions IF, AND, OR

2. Math Functions SUM, COUNT, SUBTOTAL

3. Text Functions LEFT, RIGHT, CONCATENATE, LEN, LOWER, UPPER, PROPER

4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE

5. Conditional Functions SUMIF, COUNTIF, SUMIFS, COUNTIFS

6. Statistical Functions AVERAGE, AVERAGEIF, AVERAGEIFS

7.1 Financial Analysis.xlsx

7. Financial Functions PMT, PV, FV, RATE, NPER, NPV, IRR

5. Pivot Tables and Lookup Functions

1. Introduction to Pivot Table

2. Calculated Fields in Pivot Table

3. Grouping Data with Pivot Table

4. GetPivotData

5. VLOOKUP with Exact Match

6. INDEX and MATCH functions

7. VLOOKUP with Approximate Match

8. Format as Table

9. Data Model

10. Slicer in Pivot Table

11. Conditional Formatting

6. Part 1 Completed

1. Quiz 1.html

7. ----- PART 2. Statistical Analysis with Excel -----

1. Calculation of Statistical Metrics

2.1 Statistical Analysis.xlsx

2. Scatter Plots

8. Data Analysis ToolPak

1. Activation of Data Analysis ToolPak

2. Descriptive Statistics

3. Histogram

4. Correlation

9. Linear Regression Analysis

1. Linear Regression

2. Explanation of the Output of Regression

3. Muliple Linear Regression

10. AB Testing

1.1 A-B Testing.xlsx

1. Introduction to AB Testing

2. Visualization of AB Testing

3. Statistical Significance

11. Part 2 Completed

1. Quiz 2.html

12. ----- PART 3. Managing Data with MySQL -----

1. What are SQL and MySQL

2. Installing MySQL Workbench

13. Basic SQL Queries

1.1 data.txt

1. Create Table and Insert Data

2. SELECT (DISTINCT) Statement

3. WHERE clause

4. AND, OR, NOT, IN, and BETWEEN Operators

5. LIKE Operator

6. INSERT INTO and DELETE FROM Statements

7. UPDATE SET Statement

8. ORDER BY Statement

14. Intermediate Statements and Functions

1. Aggregate Functions

2. SQL Subqueries

3. GROUP BY Statement

4. HAVING Statement

5. SQL JOINS

6. CASE Statement

15. Advanced Tips and Tricks in MySQL

1. SQL Query - Best Practices

2. Comments in SQL

3. Export and Import Data

4. Stored Procedures

5. Practical Exercises with Solutions (Part 1)

6. Practical Exercises with Solutions (Part 2)

16. Part 3 Completed

1. Quiz 3.html

17. ----- PART 4. Visualization with Power BI -----

1. Power BI vs MS Excel

2. Installing Power BI Desctop

18. Data Connection and Preparation

1.1 Full Data Excel.xlsx

1. Connect to XLSX File

2.1 Orders Data.csv

2. Connect to CSV File

3. Connect to SQL Database

4. Basic Transformations

5. Working with Dates

6. Splitting Columns

7. Conditional Columns

8. Calculated Columns

9. Calculation of Statistics

10. Apply Transformations

11. Managing Data Relationships

19. Charts and Visualization Techniques

1. Stacked Bar Chart

2. 100% Stacked Column Chart

3. Pie and Donut Charts

4. Column Chart with Line

5. Treemap Charts

6. Map and Filled Map Charts

7. Waterfall Chart

8. Gauge Chart

9. Card and KPI

10. Table and Matrix

11. Slicer for Interactive Dashboards

12. Shapes, Textboxes, and Images

13. Visual Relationship

20. Extra Functionalities in Power BI

1. Duplicate Page

2. See and Export Data

3. Enter New Data Manually

4. Update Project Data

5. Wrapping Up of Power BI

6. Power Add-ins in Excel

21. Part 4 Completed

1. Quiz 4.html

22. ----- Congratulations -----

1. Conclusion

2. Next Steps

45,900 تومان

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

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

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

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