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

Data Analyst-Python/ETL/SSIS/SSRS/SSAS/Microsoft SQL/PowerBI

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

Learn Data Analyst Skills : Connect | Clean | Transform | Model | Interpret | Analyse |and Visualise data


1. Chapter 1
  • 1. What is SSIS.html
  • 2. What is T-SQL.html
  • 3. What is SQL.html
  • 4. What is SQL Server.html
  • 5. Introduction.html
  • 6. What is a Data Analyst.html

  • 2. Python & Jupyter Notebook Setup
  • 1. Introduction
  • 2. What is a Data Analyst.html
  • 3. What is Python
  • 4. What is Jupyter Notebook
  • 5. Installing Jupyter Notebook Server
  • 6. Running Jupyter Notebook Server
  • 7. Common Jupyter Notebook Commands
  • 8. Jupyter Notebook Components
  • 9. Jupyter Notebook Dashboard
  • 10. Jupyter Notebook User Interface
  • 11. Creating a new Notebook

  • 3. Data Analysis & Visualization with Python
  • 1. Kaggle Datasets
  • 2.1 us_baby_names.zip
  • 2. Tabular Data
  • 3. Exploring Pandas Data Frame
  • 4. Manipulating a Pandas Data Frame
  • 5. What is Data Cleaning
  • 6.1 crime_boston.zip
  • 6. Performing Data Cleaning
  • 7.1 listings.zip
  • 7. What is data visualization
  • 8. Visualizing qualitative data
  • 9. Visualizing quantitative data

  • 4. SQL Server Setup
  • 1. What is SQL Server
  • 2. SQL Server Installation Requirements
  • 3. SQL Server Editions
  • 4. Download SQL Server
  • 5. Install SQL Server
  • 6. Install SQL Server Management Studio (SSMS )
  • 7. Connect SSMS to SQL Server
  • 8. Please Note.html
  • 9. Restore sample data warehouse database
  • 10. Restore sample database

  • 5. Visual Studio Setup
  • 1. What is Visual Studio
  • 2. Visual studio installation requirements
  • 3. Install Visual studio
  • 4. Visual studio workloads
  • 5. Install SQL Server Data Tools (SSDT)
  • 6. Install SSDT Templates

  • 6. Data Analysis with ETL & SSIS
  • 1. What is ETL
  • 2. What is SSIS
  • 3. ETL Illustration
  • 4. Create a new SSIS Project
  • 5. SSIS Designer
  • 6. Add and configure a Flat File Connection Manager
  • 7. Remapping Column Data Types
  • 8. Add and configure OLE DB connection manager
  • 9. Add a Data Flow task to the package
  • 10. Add and configure the flat file source
  • 11. Add and configure the lookup transformations
  • 12. Add and configure Lookup for DateKey Transformation
  • 13. Add and configure OLEDB Destination
  • 14. Run and test Package

  • 7. Create Analytic Reports with SSRS
  • 1. What is SSRS
  • 2. Create a report server project
  • 3. Create a report definition file
  • 4. Configure a data source for the report
  • 5. Define a dataset for the report
  • 6. Add a table to the report
  • 7. Format report
  • 8. Group data in report
  • 9. Adding totals to the report
  • 10. Previewing report
  • 11. Exporting report

  • 8. Data Analysis with SQL Server Analysis Server (SSAS)
  • 1. What is SSAS
  • 2. Installing SSAS
  • 3. Connecting SSAS
  • 4. Create a tabular model
  • 5. Explore tabular model authoring
  • 6. Creating connection to data source
  • 7. Transform and import data
  • 8. Mark as a data table
  • 9. Create table relationships
  • 10. Create calculated columns- part 1
  • 11. Create calculated columns- part 2
  • 12. Creating measures - Part 1
  • 13. Creating measures - Part 2
  • 14. Creating measures - Part 3
  • 15. Creating KPIs

  • 9. Data Analysis with Microsoft SQL(T-SQL)
  • 1. What is SQL
  • 2. What is Microsoft SQL (T-SQL )
  • 3. Analysing data with Analytic Functions
  • 4. Basic Analytic Function Syntax
  • 5. Analysing data with LEAD Function
  • 6. Restore sample data warehouse database.html
  • 7. Analysing data with LAG Function
  • 8. Analysing data with LAST_VALUE Function
  • 9. Analysing data with FIRST_VALUE Function
  • 10. Analysing data with PERCENT_RANK Function
  • 11. Analysing data with CAST Function
  • 12. Analysing data with ROUND Function.html
  • 13. Analysing data with CONVERT Function
  • 14. Analysing data with SUBSTRING Function
  • 15. Analysing data with CASE Expression

  • 10. Power BI Setup
  • 1. What is Microsoft 365.html
  • 2. Microsoft 365 Setup
  • 3. Getting started with Microsoft 365
  • 4. What is Power BI
  • 5. What is Power BI Desktop
  • 6. Installing Power BI Desktop
  • 7. Exploring Power BI Desktop

  • 11. Data Analysis & Visualization with Power BI
  • 1. Power BI Overview - Part 1
  • 2. Power BI Overview - Part 2
  • 3. Power BI Overview - Part 3
  • 4. Components of Power BI
  • 5. Building blocks of Power BI
  • 6. Power BI Service
  • 7. Connect to web data
  • 8. Clean & transform data - Part 1
  • 9. Clean & transform data - Part 2
  • 10. Combine data sources
  • 11. Data visualization - part 1
  • 12. Data visualization - part 2
  • 13. Publishing reports to Power BI Service
  • 14. Analyse and visualize SQL Server data
  • 15. Connect to Microsoft Access Database
  • 16. Creating and Managing Relationships in Power BI Desktop
  • 17. Power Query Editor and Queries
  • 18. Creating and managing query groups
  • 19. Renaming queries
  • 20. Splitting columns
  • 21. Changing data types
  • 22. Remove and re-order columns
  • 23. Duplicate and add columns
  • 24. Create conditional columns
  • 25. Connect to files in a folder
  • 26. Append queries
  • 27. Merge queries
  • 28. Query dependency view
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 5852
    حجم: 3792 مگابایت
    مدت زمان: 660 دقیقه
    تاریخ انتشار: 3 اسفند 1401
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید