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

Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

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

4-in-1 bundle: Practical learning of the essential tools used in Data Science with hands on examples and projects


1. Introduction
  • 1. Introduction

  • 2. SQL
  • 1.1 Script for Classic Models.txt
  • 1. Download MySQL Workbench and Classic Models Database - Windows
  • 2.1 Script for Classic Models.txt
  • 2. Download MySQL Workbench and Classic Models Database - MacOS
  • 3.1 MySQL-Sample-Database-Diagram-PDF-A4.pdf
  • 3. What is SQL And a Relational Database
  • 4.1 Select, From, Where.pdf
  • 4. Select, From And Where Statement
  • 5.1 Select Statement Exercise.pdf
  • 5. Select Statement Q And A
  • 6.1 Upper And Lower.pdf
  • 6. Upper And Lower
  • 7.1 In And Not In.pdf
  • 7. In And Not In
  • 8.1 Distinct, Like, Order By.pdf
  • 8. Distinct, Like And Order By
  • 9.1 Inner Join.pdf
  • 9. Inner Join
  • 10.1 Left And Right Join.pdf
  • 10. Left And Right Join
  • 11.1 Join Exercises.pdf
  • 11. Joins Q And A
  • 12.1 Union And Union All.pdf
  • 12. Union And Union All
  • 13.1 Sum, Round, Group by, Having.pdf
  • 13. Sum, Round, Group by And Having
  • 14.1 Count, Max, Min, Avg.pdf
  • 14. Count, Max, Min, Avg
  • 15.1 Aggregate Functions Exercise.pdf
  • 15. Aggregate Functions Q And A
  • 16.1 Subquery.pdf
  • 16. Subquery
  • 17.1 CTE.pdf
  • 17. Common Table Expression (CTE)
  • 18.1 Case Statement.pdf
  • 18. Case statement
  • 19.1 Flag using Case statement.pdf
  • 19. Create a Flag using Case Statement
  • 20.1 Row Number.pdf
  • 20. Row Number
  • 21.1 Lead And Lag.pdf
  • 21. Lead And Lag
  • 22.1 Row Number Exercise.pdf
  • 22. Row Number Q And A
  • 23.1 Date Functions.pdf
  • 23. Date Functions
  • 24.1 String Functions.pdf
  • 24. String Functions

  • 3. Excel with Netflix Dataset
  • 1.1 netflix titles.csv
  • 1. Download Excel and Netflix Dataset
  • 2.1 Excel shortcuts_cheat_sheet.pdf
  • 2. Common Excel Shortcuts
  • 3. Split Text to Columns - Part 1
  • 4. Split Text to Columns - Part 2
  • 5. Trim And Separate Data
  • 6. Sort And Filter Data
  • 7. Common Calculations - Sum, Avg, Max, Min
  • 8. If Function
  • 9. Sumifs And Countifs
  • 10. Unique, Left, Right
  • 11. Vlookup
  • 12. Pivot Tables
  • 13. Excel - Exercises and Answers
  • 14. Separate Sheets and Find And Replace Blanks
  • 15. Import Netflix Data to MySQL Workbench
  • 16.1 Create Cast Table.docx
  • 16.2 Create Countries Table.docx
  • 16.3 Create Directors Table.docx
  • 16.4 Create Listed In Table.docx
  • 16. Set Up Relational Tables for Power BI

  • 4. Power BI Dashboard - Netflix
  • 1. Download Power BI and Connect to Data
  • 2. Power BI Overview
  • 3. Create Area Chart
  • 4. Create Shows by Rating And Top 10 Categories Charts
  • 5.1 logo.zip
  • 5. Create Countries Available Map and import Netflix logo
  • 6. Create Single Title View Page - Part 1
  • 7. Create Single Title View Page - Part 2

  • 5. Classic Models Data Analysis Exercises
  • 1. Sales Overview by Product
  • 2. Sales Overview by Country
  • 3. Products Purchased Together
  • 4. Customers Sales Value by Credit Limit
  • 5. Sales Value Change from Previous Order
  • 6. Office Sales by Customer Country
  • 7. Customers Affected by Late Shipping

  • 6. Power BI Dashboard - Classic Models
  • 1. Create View in My SQL Workbench for Power BI
  • 2. Connect Power BI to Data Source And Prepare Canvas
  • 3. Create Overview Cards
  • 4. Create Overview Line Charts
  • 5. Set up Measures for Sales And Net Profit Buttons
  • 6. Add Actions to Buttons and Create Bar Chart
  • 7. Create Scatter, Column And Donut Charts
  • 8. Add Conditional titles to Charts
  • 9. Create Decomposition Tree
  • 10. Create Sales Overview Table with MoM % and YTD Calculations
  • 11. Add Filters and Page Navigation Buttons

  • 7. Electric Vehicle Dashboard with Tableau
  • 1.1 Electric Vehicle_Population_Data.xlsx
  • 1. Download Tableau Public and Electric Vehicle Dataset
  • 2. Tableau Overview
  • 3. Create Bar Chart - Vehicle Year
  • 4. Create Map
  • 5. Top 10 Counties Column Chart
  • 6. Make And Model Column Chart and Parameter
  • 7. Create Donut Chart
  • 8. Put Dashboard Together
  • 9. Format and Publish Dashboard
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 16239
    حجم: 6391 مگابایت
    مدت زمان: 478 دقیقه
    تاریخ انتشار: ۲۵ تیر ۱۴۰۲
    طراحی سایت و خدمات سئو

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