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

Data Analyst Skills for beginners – (SQL,R,Python,Power BI )

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

Gain skills you need to succeed as a data analyst.


1 - Setting Up R Environment
  • 1 - Introduction
  • 2 - What is R.html
  • 3 - Installing R on Windows
  • 4 - Download-and-install-R-on-Mac.pdf
  • 4 - Installing R on Macs.html
  • 5 - What is R Studio.html
  • 6 - Installing R Studio on Windows
  • 7 - Download-and-install-R-Studio.pdf
  • 7 - Installing R Studio on Macs.html
  • 8 - Exploring R Studio Default Interface
  • 9 - Creating a new project in R Studio
  • 10 - What are Packages.html
  • 11 - How to install Packages
  • 12 - Data sets vs Data frames.html
  • 13 - Loading Packages
  • 14 - Importing data into R Studio
  • 15 - How to read data in a csv file with R
  • 16 - Installing Janitor Package
  • 17 - Cleaning columns
  • 18 - Selecting a subset of data
  • 19 - Performing multiple operations using Pipe operator
  • 20 - Creating new columns from existing columns
  • 21 - Create a new R Project
  • 22 - Load data into new project
  • 23 - What is Data Wrangling.html
  • 24 - Data Wrangling steps.html
  • 25 - Importance of data wrangling.html
  • 26 - Perform Data Wrangling on Data
  • 27 - Create a scatter plot
  • 28 - Create a bar graph
  • 29 - Adding Labels to plots

  • 2 - SQL Server Environment Setup
  • 30 - What is SQL Server
  • 31 - What is SQL
  • 32 - What is TSQL
  • 33 - Download SQL Server
  • 34 - Install SQL Server
  • 35 - SQL Server Editions
  • 36 - Install SSMS
  • 37 - Connect SSMS to SQL Server
  • 38 - Download Sample Database
  • 39 - Database Concepts
  • 40 - Database Normalisation
  • 41 - Create database

  • 3 - Data Exploration with SQL
  • 42 - Data Preparation
  • 43 - Importing Datasets into database
  • 44 - How many continents do we have data for
  • 45 - What is possibility of dying from COVID
  • 46 - What percentage of population is infected with COVID
  • 47 - What countries has highest COVID infection per population
  • 48 - What countries has the highest deaths from COVID
  • 49 - What continent has highest deaths from COVID
  • 50 - What are the global COVID cases and death
  • 51 - What number of people have been vaccinated against COVID
  • 52 - Analysing data with SQL CTE
  • 53 - Using temporary tables for data
  • 54 - Using Views for data

  • 4 - Python Environment Setup
  • 55 - What is Python
  • 56 - What is Jupyter Notebook
  • 57 - Installing Jupyter Notebook Server
  • 58 - Running Jupyter Notebook Server
  • 59 - Common Jupyter Notebook Commands
  • 60 - Jupyter Notebook Components
  • 61 - Jupyter Notebook Dashboard
  • 62 - Jupyter Notebook Interface
  • 63 - Creating a new Jupyter Notebook

  • 5 - Data Analysis and visualization with Python
  • 64 - Kaggle Datasets
  • 65 - Tabular data
  • 66 - Exploring Pandas DataFrame
  • 67 - Analysing and manipulating pandas dataframe
  • 68 - What is data cleaning
  • 69 - Basic data cleaning
  • 70 - Data Visualization
  • 71 - Visualizing qualitative data
  • 72 - Visualizing quantitative data

  • 6 - Data Analysis Visualization with Power BI
  • 73 - Microsoft 365
  • 74 - Getting started with Microsoft 365
  • 75 - What is Power BI
  • 76 - What is Power BI Desktop
  • 77 - Installing Power BI Desktop
  • 78 - Exploring Power BI Desktop
  • 79 - Power BI Overview Part 1
  • 80 - Power BI Overview Part 2
  • 81 - Power BI Overview Part 3
  • 82 - Components of Power BI
  • 83 - Building blocks of Power BI
  • 84 - Power BI Service
  • 85 - Connecting to web data
  • 86 - Clean and transform data Part 1
  • 87 - Clean and transform data Part 2
  • 88 - Combining data sources
  • 89 - Data visualization with Power BI Part 1
  • 90 - Data visualization with Power BI Part 2
  • 91 - Publishing reports to Power BI Service
  • 92 - Connect Power BI to SQL Server
  • 93 - Import SQL Data into Power BI
  • 94 - Analyze data create visualization
  • 95 - How to Publish your report to Power BI Service
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 8837
    حجم: 2939 مگابایت
    مدت زمان: 531 دقیقه
    تاریخ انتشار: ۱۰ فروردین ۱۴۰۲
    طراحی سایت و خدمات سئو

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