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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 23914
    حجم: 4265 مگابایت
    مدت زمان: 484 دقیقه
    تاریخ انتشار: ۱۲ آذر ۱۴۰۲
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید