Data Analyst Free Course Videos from DigiSkill.pk with Ahmad Siddiqui

Project Resources & Files

• 1 - Project Resources & Files Example
• 2 - Project Resources & Files Example

Week 01

• 1 - Introduction: Data Analytics and Business Intelligence
• 2 - Introduction: Components of Data Analytics
• 3 - Introduction: What is Data
• 4 - Introduction: What is Data Source
• 5 - Data Analytical Tools: Google Analytics - Google Office - Google Docs
• 6 - Data Analytical Tools: Google Analytics - Google Word Cloud (Part 1)
• 7 - Data Analytical Tools: Google Analytics - Google Word Cloud (Part 2)
• 8 - Data Analytical Tools: Google Analytics - Google Office and Google Sheets

Week 02

• 9 - Data Analytical Tools: Google Analytics - Google Sheets - Mathematical Analysis
• 10 - Data Analytical Tools: Google Analytics - Google Sheets - Usage and Example of Mathematical Analysis
• 11 - Data Analytical Tools: Google Analytics - Google Sheets - Statistical Analysis
• 12 - Data Analytical Tools: Google Analytics - Google Sheets - Usage and Example of Statistical Analysis
• 13 - Data Analytical Tools: Google Analytics - Google Sheets - Developing and Exporting Statistical Analysis
• 14 - Data Analytical Tools: Google Analytics - Data Mining using Google Sheets
• 15 - Data Analytical Tools: Google Analytics - Data Pivoting using Google Sheets
• 16 - Data Analytical Tools: Google Analytics - Spreadsheet Extensions

Week 03

• 17 - Data Analytical Tools: Google Analytics - Data Pivoting (Part 1)
• 18 - Data Analytical Tools: Google Analytics - Data Pivoting (Part 2)
• 19 - Data Analytical Tools: Google Analytics - Advanced Functions in Google Sheets
• 20 - Data Analytical Tools: Google Analytics - Forms and Presentation Outcomes
• 21 - Data Analytical Tools: Microsoft Data Analytics - Microsoft Tools
• 22 - Data Analytical Tools: Microsoft Data Analytics - Microsoft Excel
• 23 - Data Analytical Tools: Microsoft Data Analytics - Database Management using MS Excel
• 24 - Data Analytical Tools: Microsoft Data Analytics - Descriptive Analysis using MS Excel (Part 1)

Week 04

• 25 - Data Analytical Tools: Microsoft Data Analytics - Descriptive Analysis using MS Excel (Part 2)
• 26 - Data Analytical Tools: Microsoft Data Analytics - Interpreting Visualizations using MS Excel
• 27 - Data Analytical Tools: Microsoft Data Analytics - Filtering using MS Excel
• 28 - Data Analytical Tools: Microsoft Data Analytics - Developing Series using MS Excel
• 29 - Data Analytical Tools: Microsoft Data Analytics - Number Based Visualization in MS Excel
• 30 - Data Analytical Tools: Microsoft Data Analytics - Pivot Table in MS Excel (Part 1)
• 31 - Data Analytical Tools: Microsoft Data Analytics - Pivot Table in MS Excel (Part 2)
• 32 - Data Analytical Tools: Microsoft Data Analytics - Pivot Table in MS Excel (Part 3)

Week 05

• 33 - Data Analytical Tools: Microsoft Data Analytics - Macros in MS Excel
• 34 - Data Analytical Tools: Microsoft Data Analytics - Pattern Development using MS Excel (Part 1)
• 35 - Data Analytical Tools: Microsoft Data Analytics - Pattern Development using MS Excel (Part 2)
• 36 - Data Analytical Tools: Microsoft Data Analytics - Pattern Based Visualization using MS Excel
• 37 - Data Analytical Tools: Microsoft Data Analytics - Forecasting and Prediction in MS Excel
• 38 - Data Analytical Tools: Microsoft Data Analytics - Lookup Functions in MS Excel
• 39 - Data Analytical Tools: Microsoft Data Analytics - WhatIf Analysis using MS Excel
• 40 - Data Analytical Tools: Microsoft Data Analytics - Series and Sequences using MS Excel

Week 06

• 41 - Data Analytical Tools: Microsoft Data Analytics - Complete Data Analytics Project in MS Excel
• 42 - Data Analytical Tools: Microsoft Data Analytics - Data Forecasting in MS Excel
• 43 - Data Analytical Tools: Microsoft Data Analytics - MS Excel Add-ins
• 44 - Power BI Data Analytics: Microsoft Power BI
• 45 - Power BI Data Analytics: Graphs & Charts in Power BI Desktop
• 46 - Power BI Data Analytics: Power BI Desktop Models
• 47 - Power BI Data Analytics: Relational Power using Power BI Desktop
• 48 - Power BI Data Analytics: First Power BI Desktop Dashboard

Week 07

• 49 - Power BI Data Analytics: Another Dashboard, using Power BI Desktop
• 50 - Power BI Data Analytics: Discovering and Loading Power BI Desktop
• 51 - Power BI Data Analytics: Dealing with Different Datasets in Power BI Desktop
• 52 - Power BI Data Analytics: Power BI Desktop Query Examples
• 53 - Power BI Data Analytics: Power BI Data Queries
• 54 - Power BI Data Analytics: Data Transformations using Power BI Desktop (Part 1)
• 55 - Power BI Data Analytics: Data Transformations using Power BI Desktop (Part 2)
• 56 - Power BI Data Analytics: Data Transformations using Power BI Desktop (Part 3)

Week 08

• 57 - Power BI Data Analytics: Conditional Data Transformations using Power BI Desktop
• 58 - Power BI Data Analytics: Data Mashup using Power BI Desktop
• 59 - Power BI Data Analytics: Creating Data using Power BI Desktop
• 60 - Power BI Data Analytics: Conditional Formatting in Power BI Desktop
• 61 - Power BI Data Analytics: Developing Cards using Power BI Desktop
• 62 - Power BI Data Analytics: Power BI using Geographical Maps
• 63 - Power BI Data Analytics: Exporting Dashboards from Power BI Desktop
• 64 - R Data Analytics: R Programming Language - An Introduction

Week 09

• 65 - R Data Analytics: What is using R
• 66 - R Data Analytics: R Database Handling
• 67 - R Data Analytics: R Programming Language - Control Structure
• 68 - R Data Analytics: R Programming Language - Functions
• 69 - R Data Analytics: R Visualization
• 70 - R Data Analytics: Visualizing Aggregate using R
• 71 - R Data Analytics: Multiple Plots using R
• 72 - R Data Analytics: Exploratory Data Analytics

Week 10

• 73 - R Data Analytics: Odd man using R
• 74 - R Data Analytics: Developing Patterns using R (Part 1)
• 75 - R Data Analytics: Developing Patterns using R (Part 2)
• 76 - R Data Analytics: Developing Segments using R (Part 1)
• 77 - R Data Analytics: Developing Segments using R (Part 2)
• 78 - R Data Analytics: Developing Segments using R (Part 3)
• 79 - R Data Analytics: R Interface using Power BI
• 80 - R Data Analytics: R GUI Interfaces

Week 11

• 81 - R Data Analytics: R Interface with MS Excel
• 82 - Data Analytics using Tableau: Tableau Based Data Analytics
• 83 - Data Analytics using Tableau: Graphs & Charts in Tableau
• 84 - Data Analytics using Tableau: Five Ways using Tableau
• 85 - Data Analytics using Tableau: Date Hierarchies
• 86 - Data Analytics using Tableau: Level of using Tableau
• 87 - Data Analytics using Tableau: Filters using Tableau
• 88 - Data Analytics using Tableau: Calculated Fields using Tableau

Week 12

• 89 - Data Analytics using Tableau: Table Calculations in Tableau
• 90 - Data Analytics using Tableau: Sets using Tableau
• 91 - Data Analytics using Tableau: Expressions using Tableau
• 92 - Data Analytics using Tableau: Dashboards using Tableau
• 93 - Data Analytics using Tableau: Highlight/Heatmap Table using Tableau
• 94 - Data Analytics using Tableau: A Dual-Axis using Tableau
• 95 - Data Analytics using Tableau: Advanced Graphs using Tableau
• 96 - World of Data Analytics: Advanced Analytical Tools