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

Become a Data Analyst: Excel, SQL & Tableau – 3-in-1 Bundle

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

Boost Your Career with Data Analytics: Learn Excel, SQL & Tableau for Advanced Business Insights & Competitive Advantage


1 - Introduction
  • 1 - Introduction

  • 2 - Excel Basics
  • 2 - Getting started with Excel
  • 3 - Course Resources.html
  • 4 - This is a milestone
  • 5 - Worksheet basics
  • 6 - Entering values and Formulas
  • 7 - Data Formats
  • 8 - Data Handling Basics Cut Copy Paste
  • 9 - Saving and Printing in Excel

  • 3 - Essential Excel functions
  • 10 - Basic Formula Operations
  • 11 - Mathematical Functions Part 1
  • 12 - Mathematical Functions Part 2
  • 13 - Difference between RANK RANKAVG and RANKEQ.html
  • 14 - Textual Functions Part 1
  • 15 - Textual Functions Part 2
  • 16 - Logical Functions
  • 17 - DateTime Functions
  • 18 - Lookup Functions V Lookup Hlookup IndexMatch

  • 4 - Data Tools
  • 19 - Data Tools Part 1
  • 20 - Data Tools Part 2

  • 5 - Formatting data and tables
  • 21 - Formatting data and tables

  • 6 - Pivot Tables
  • 22 - Pivot Tables

  • 7 - Excel Charts
  • 23 - Excel Charts Categories of messages that can be conveyed
  • 24 - Elements of charts
  • 25 - The Easy way of creating charts
  • 26 - Bar and column charts
  • 27 - Formatting charts Part 1
  • 28 - Formatting charts Part 2
  • 29 - Line Charts
  • 30 - Area Charts
  • 31 - Pie and Doughnut Charts
  • 32 - Why we should avoid Pie charts
  • 33 - Scatter plot or XY chart
  • 34 - Frequency Distribution and Histograms
  • 35 - Waterfall Charts
  • 36 - Hierarchy Charts Sunburst and Treemap
  • 37 - Combination charts
  • 38 - Sparklines

  • 8 - Pivot Charts
  • 39 - Pivot Charts

  • 9 - Special purpose charts
  • 40 - Stock charts
  • 41 - Radar charts
  • 42 - Surface charts
  • 43 - Heatmaps

  • 10 - Named Ranges
  • 44 - Named Ranges
  • 45 - Indirect Functions

  • 11 - Excel Shortcuts
  • 46 - Shortcuts

  • 12 - Macros
  • 47 - Macros

  • 13 - Advanced Excel
  • 48 - Advanced Excel Analytics in Excel

  • 14 - Creative Infographics
  • 49 - Infographic Example 1
  • 50 - Infographic Example 2

  • 15 - SQL
  • 51 - Introduction

  • 16 - Installation and getting started
  • 52 - Installing PostgreSQL and pgAdmin in your PC
  • 53 - If pgAdmin is not opening.html

  • 17 - Case Study Demo
  • 54 - Case Study Part 1 Business problems
  • 55 - Case Study Part 2 How SQL is Used

  • 18 - Fundamental SQL statements
  • 56 - CREATE
  • 57 - INSERT
  • 58 - Import data from File
  • 59 - SELECT statement
  • 60 - SELECT DISTINCT
  • 61 - WHERE
  • 62 - Logical Operators
  • 63 - UPDATE
  • 64 - DELETE
  • 65 - ALTER part 1
  • 66 - ALTER part 2

  • 19 - Restore and Backup
  • 67 - Restore and Backup
  • 68 - Debugging restoration issues
  • 69 - Creating DB using CSV files
  • 70 - Debugging summary and Code for CSV files.html

  • 20 - Selection commands Filtering
  • 71 - IN
  • 72 - BETWEEN
  • 73 - LIKE

  • 21 - Selection commands Ordering
  • 74 - Side Lecture Commenting in SQL
  • 75 - ORDER BY
  • 76 - LIMIT

  • 22 - Alias
  • 77 - AS

  • 23 - Aggregate Commands
  • 78 - COUNT
  • 79 - SUM
  • 80 - AVERAGE
  • 81 - MIN MAX

  • 24 - Group By Commands
  • 82 - GROUP BY
  • 83 - HAVING

  • 25 - Conditional Statement
  • 84 - CASE WHEN

  • 26 - JOINS
  • 85 - Introductions to Joins
  • 86 - Concepts of Joining and Combining Data
  • 87 - Preparing the data
  • 88 - Inner Join
  • 89 - Left Join
  • 90 - Right Join
  • 91 - Full Outer Join
  • 92 - Cross Join
  • 93 - Intersect and Intersect ALL
  • 94 - Except
  • 95 - Union

  • 27 - Subqueries
  • 96 - Part1 Subquery in WHERE clause
  • 97 - Part2 Subquery in FROM clause
  • 98 - Part3 Subquery in SELECT clause

  • 28 - Views and Indexes
  • 99 - VIEWS
  • 100 - INDEX

  • 29 - String Functions
  • 101 - LENGTH
  • 102 - UPPER LOWER
  • 103 - REPLACE
  • 104 - TRIM LTRIM RTRIM
  • 105 - CONCATENATION
  • 106 - SUBSTRING
  • 107 - LIST AGGREGATION

  • 30 - Mathematical Functions
  • 108 - CEIL FLOOR
  • 109 - RANDOM
  • 110 - SETSEED
  • 111 - ROUND
  • 112 - POWER

  • 31 - DateTime Functions
  • 113 - CURRENT DATE TIME
  • 114 - AGE
  • 115 - EXTRACT

  • 32 - PATTERN STRING MATCHING
  • 116 - PATTERN MATCHING BASICS
  • 117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1
  • 118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2

  • 33 - Windows Functions
  • 119 - Introduction to Window functions
  • 120 - Introduction to Row number
  • 121 - Implementing Row number in SQL
  • 122 - RANK and DENSERANK
  • 123 - NTILE function
  • 124 - AVERAGE function
  • 125 - COUNT
  • 126 - SUM TOTAL
  • 127 - RUNNING TOTAL
  • 128 - LAG and LEAD

  • 34 - COALESCE function
  • 129 - COALESCE function

  • 35 - Data Type conversion functions
  • 130 - Converting Numbers Date to String
  • 131 - Converting String to Numbers Date

  • 36 - User Access Control functions
  • 132 - User Access Control 1 Grant and Revoke
  • 133 - User Access Control 2 Drop Alter users

  • 37 - Nail that Interview
  • 134 - Tablespace
  • 135 - PRIMARY KEY FOREIGN KEY
  • 136 - ACID compliance
  • 137 - Truncate

  • 38 - Performance tuning tips
  • 138 - TIP 1 EXPLAIN
  • 139 - TIP 2
  • 140 - TIP 3
  • 141 - TIP 4 VACCUM
  • 142 - TIP 5
  • 143 - TIP 6 STRING FUNCTIONS
  • 144 - TIP 7 JOINS
  • 145 - TIP 8 SCHEMAS

  • 39 - Database Basics
  • 146 - What is SQL
  • 147 - Tables and DBMS
  • 148 - Types of SQL commands
  • 149 - PostgreSQL

  • 40 - TABLEAU
  • 150 - Introduction
  • 151 - Why Tableau
  • 152 - Tableau Products

  • 41 - Installation and getting started
  • 153 - Installing Tableau desktop and Public
  • 154 - About the data
  • 155 - Connecting to data
  • 156 - Live vs Extract

  • 42 - Combining data to create Data model
  • 157 - Combining data from multiple tables
  • 158 - Relationships in Tableau
  • 159 - Joins in Tableau
  • 160 - Types of Joins in Tableau
  • 161 - Union in Tableau
  • 162 - Physical Logical layer and Data models
  • 163 - The visualization screen Sheet

  • 43 - Data categorization in Tableau
  • 164 - Types of Data Dimensions and Measures
  • 165 - Types of Data Discreet and Continuous
  • 166 - Changing Data type in Tableau

  • 44 - Most used charts
  • 167 - Bar charts
  • 168 - Line charts
  • 169 - Scatterplots

  • 45 - Customizing charts using Marks shelf
  • 170 - Marks cards
  • 171 - Dropping Dimensions and Measures on marks card
  • 172 - Dropping Dimensions on Line chart
  • 173 - Adding marks in scatterplot

  • 46 - Other important charts
  • 174 - Text tables heat map and highlight tables
  • 175 - Pie charts
  • 176 - Area charts
  • 177 - Creating custom hierarchy
  • 178 - Tree map
  • 179 - Dual combination charts
  • 180 - Creating Bins
  • 181 - Histogram

  • 47 - Grouping and Filtering data
  • 182 - Grouping Data
  • 183 - Filtering data
  • 184 - Dimension filters
  • 185 - Measure filters
  • 186 - DateTime filters
  • 187 - Filter options
  • 188 - Types of filters and order of operation
  • 189 - Customizing visual filters
  • 190 - Sorting options

  • 48 - Map chart in Tableau
  • 191 - How to make a map chart
  • 192 - Considerations before making a Map chart
  • 193 - Marks card for customizing maps
  • 194 - Customizing maps using map menu
  • 195 - Layers in a Map
  • 196 - Visual toolbar on a map
  • 197 - Custom background images
  • 198 - Territories in maps
  • 199 - Data blending for missing geocoding

  • 49 - Calculations and Analytics
  • 200 - Calculated fields in Tableau
  • 201 - Functions in Tableau
  • 202 - Table calculations theory
  • 203 - Table calculations in Tableau
  • 204 - Understanding LOD expressions
  • 205 - LOD expressions examples
  • 206 - Analytics pane

  • 50 - Sets and Parameters
  • 207 - Understanding sets in Tableau
  • 208 - Creating Sets in Tableau
  • 209 - Parameters

  • 51 - Dashboard and Story
  • 210 - Dashboard part 1
  • 211 - Dashboard part 2
  • 212 - Story

  • 52 - Appendix
  • 213 - Connecting to SQL data source
  • 214 - Connecting to cloud storage services

  • 53 - Congratulations and about your certificate
  • 215 - The final milestone
  • 216 - Bonus lecture.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 10577
    حجم: 10625 مگابایت
    مدت زمان: 1551 دقیقه
    تاریخ انتشار: ۸ اردیبهشت ۱۴۰۲
    طراحی سایت و خدمات سئو

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