Markovdata > Tracks > Data Visualization Expert Track

Data Visualization Expert Track

Abstract • Build essential statistical knowledge and how to apply it on different business questions. • Will be able to analyse your data quickly and visualize your results using SPSS and Python. • You will learn how to use Python to analyse and visualize your data using different libraries. • You’ll explore the four crucial […]

Instructor

Markov Data

13 students enrolled

Abstract

• Build essential statistical knowledge and how to apply it on different business questions.
• Will be able to analyse your data quickly and visualize your results using SPSS and Python.
• You will learn how to use Python to analyse and visualize your data using different libraries.
• You’ll explore the four crucial steps for any data analysis project. Reading, describing, cleaning, and visualizing data.
• You will work with the most common and popular tools that data analysts use every day.
• You will be able to confidently extract knowledge and answers from data.
• Using Power BI to solve business problems and improve operations.
• Use Power BI to master the development of dashboards from published reports, discover greater insight from your data with Quick Insights, and learn practical recipes for the various tasks that you can perform — from gathering data to analyzing it.
• Use Tableau to build visualizations, organize data, and design charts and dashboards to empower more meaningful business decisions.
• You’ll be exposed in Tableau to the concepts of data visualization; different combo charts and stories; working with filters, parameters, and sets; and building interactive dashboards

Instructor

Eng. Ahmed Yehia, Markov
Eng.Eman Raslan, Markov
Eng.Hany Mohamed, Markov
Eng.Aya Mamdouh, Markov

Duration

5 Months

Sessions

Mondays & Wednesdays, 6:00 to 10:00PM

Location

Live Streaming (on-line)

Prerequisites

None

Statistics Essentials using SPSS and Python (30hrs)

Module 1: introduction to basics of Statistics.

Introduction

Types of Variables

Sampling Techniques

Sample size

Module 2: Descriptive & Inferential Statistics using SPSS-software

Introduce SPSS

Data coding, and data entry

Importing data to SPSS from excel

Data manipulation in SPSS

Data checking and editing in SPSS Introduction to descriptive statistics using SPSS

Measures of central tendency for different types of data

Measures of Variability for different types of data

One-way Tabulation distinct types of variables

Two-way and 3-way tabulations for distinct types of variables

Correlation and Covariance

Probability

Probability Distributions and Central Limit Theorem

Inferential Statistics

Module 3: Data Visualization (using Python)

Introduction to Data Visualization Tools

Basic and Specialized Visualization

Matplotlib and Seaborn

Different Data Charts

Advanced Visualization Tools

Heat Maps Plotting

Word Cloud

Folium Maps

Intensity Maps

Geospatial Maps in Python

Choropleth Maps

Module 4: Data Prediction Models

Linear Regression

Logistic Regression

Use Case-1

Explore US Bikeshare Data Use python to understand US bikeshare data. Calculate statistics and build an interactive environment where a user can choose the data and filter for a dataset to show.

Use Case-2

House Sales in King County, USA Analyze and predict housing prices using attributes or features such as square footage, number of bedrooms, number of floors and so on

Use Case-3

Audience Interest in Data Science Topics Use python to generate visualization plots to summarize the results of a survey that was conducted to gauge an audience interest in different data science topics

Use Case-4

San Francisco Incidents Distribution Use python Folium maps to generate a Choropleth map of the crime rate in San Francisco, based on data for one year, and show distribution of different crimes’ type and cities

2- Data Analysis & Visualization Using Power BI (35hrs)

Module 1: Introducing Power BI

Introduction to Power BI

The Power BI Desktop User Interface

Building Our First Visualization in Power BI

Filtering and Interactions

Using Data from Multiple Tables

Saving and Uploading Your Work

Creating and Sharing a Dashboard

Module 2: Introduction to the Query Editor

Connecting to Multiple Files

Pivoting and Un-pivoting the Dataset

Assigning Data Types

Merging and Appending Datasets

Grouping and Aggregating Data

Filtering in the Query Editor

Formatting Columns

Custom and Conditional Columns

The M Formula Language

Editing Queries and Loading to Power BI

Connecting to Folders

Module 3: Modeling Data

What are the Relationships?

Fact Tables vs. Dimension Tables

Star/Snowflake Schema

Viewing Relationships

Creating Relationships

Cardinality

Cross Filter Direction

Active vs. Inactive Relationships

Module 4: Introduction to DAX

Calculated Columns

Measures

Calculated Tables

Aggregation Functions

Logical Functions

CALCULATE Function

SWITCH Function

COUNT and DISTINCTCOUNT

Module 5: Advanced DAX

Date Functions

Time Intelligence Analysis

Working with Variables

Relational Functions

FILTER Function

Multiple Row Contexts

Running Totals

Rolling Averages

Module 6: Interactive Data Visualizations

Power BI Reports: Page Layout and Formatting

Chart Types

Creating and Formatting Charts

Charts

Legends and Tooltips

Slicers

Filters

Drill-through Filters

Interactions

Hierarchies

Quick Measures

Lists and Bins

Other Charts

“What-If” Parameters

Managing & Viewing Roles

3- Data Analysis & Visualization Using Tableau (40hrs)

Module 1: Introduction to Tableau Desktop

Module Overview

• Concept: Exploring the Desktop Workflow

• Demo 1: Making Your First Data Connection

• Activity 1: Connect to Global Library Excel Data

• Demo 2: Analyzing Data in the Workspace

• Activity 2: Analyze Your Data in Two Views

• Demo 3: Sharing Your Analysis in a Dashboard

• Activity 3: Share Library Data in a Dashboard

Module 2: Connecting to Data

Module Overview

• Concept: How Tableau Desktop Connects to Data

• Demo: Connecting to a File-Based Data Source

• Activity: Connect to an Excel File

Module 3: Customizing a Data Source

Module Overview

• Demo: Editing and Saving a Data Source

• Demo: Updating the View with New Data

• Activity: Change and Save a Data Source

Module 4: Filtering Your Data

Module Overview

• Demo: Creating Filters on Your Data

• Demo: Changing Filter Options

• Demo: Using Date Filters

• Linear Algebra Review

1. Review on Matrices

2. Operations on Matrices

3. Eigen Values and Eigen Vectors.

4. Dimensionality Reduction (Principal Component Analysis - PCA)

• Activity: Create and Customize Filters

Module 5: Sorting Your Data

Module Overview

• Concept: Sorting Your Data to Find Answers

• Demo: Using Computed and Manual Sorts

• Activity: Sort by Fields in a View

• Activity: Sort by Fields Not in a View

Module 6: Creating Groups in Your Data

Module Overview

• Demo: Organizing Your Data with Groups

• Activity: Create a Group

• Activity: Create Visual Groups

Module 7: Creating Hierarchies in Your Data

Module Overview

• Demo: Organizing Your Data with Hierarchies

• Activity: Create a Hierarchy

Module 8: Working with Data Fields: Discrete and Continuous Time

Module Overview

• Concept: Working with Dates

• Concept: Discrete and Continuous Fields

• Demo: Changing Date Fields into Discrete or Continuous Fields

• Demo: Using Discrete and Continuous Date Fields

• Activity: Show Data Across Discrete and Continuous Months

Module 9: Working with Data Fields: Custom Dates

Module Overview

• Demo: Creating Custom Dates

• Activity: Apply Custom Dates

Module 10: Working with Multiple Measures: Dual Axis and Combo Charts

Module Overview

• Demo: Building Dual Axis and Combo Charts

• Activity: Build a Combo Chart

Module 11: Working with Multiple Measures: Combined Axis Charts

Module Overview

• Demo: Building a Combined Axis Chart

• Activity: Build a Combined Axis Chart

Module 12: Showing Relationships between Numerical Values

Module Overview

• Demo: Building Scatter Plots

• Activity: Build a Scatter Plot

Module 13: Mapping Data Geographically

Module Overview

• Concept: Mapping Your Data

• Demo: Creating a Symbol Map

• Activity: Build a Symbol Map

Module 14: Using Crosstabs: Totals and Aggregation

Module Overview

• Demo: Creating and Editing Crosstabs

• Demo: Working with Totals and Aggregation

• Activity: Show Sales Totals in a Crosstab

• Activity: Create a Weighted Average

Module 15: Using Crosstabs: Highlight Tables

Module Overview

• Demo: Creating Highlight Tables

• Activity: Build a Highlight Table

Module 16: Using Crosstabs: Heat Maps

Module Overview

• Demo: Creating Heat Maps

• Activity: Build a Heat Map

Module 17: Using Calculations: Customize Your Data

Module Overview

• Concept: Using Calculated Fields

• Demo: Exploring the Calculation Editor

Module 18: Using Calculations: Working with Strings

Dates

and Type Conversion Functions

Module Overview

• Demo: Working with String Calculations

• Activity: Manipulate Strings and Convert the Data Type

• Demo: Using Date-Specific Calculations

• Activity: Create a Date Calculation

Module 19: Using Calculations: Working with Aggregations

Module Overview

• Concept: How Calculations Work with Aggregation

• Demo: Building Calculations with Aggregations

• Activity: Create a Calculation with Aggregation

Module 20: Using Quick Table Calculations to Analyze Data

Module Overview

• Concept: Applying Quick Table Calculations

• Demo: Using Running Total and Percent of

Total

• Demo: Leveraging Rank Calculations

• Activity: Apply a Year over Year Table

Calculation

• Activity: Apply a Rank Table Calculation

Module 21: Showing Breakdowns of the Whole

Module Overview

• Demo: Making Effective Pie Charts

• Activity: Build a Pie Chart

• Demo: Showing Hierarchy with Tree Maps

• Activity: Build a Tree Map

Module 22: Using Calculations: Customize Your Data

Module Overview

• Concept: Using Calculated Fields

• Demo: Exploring the Calculation Editor

Module 23: Highlighting Data with Reference Lines

Module Overview

• Demo: Using Reference Lines and Bands

• Activity: Add Two Types of Reference Lines

Module 24: Create a Dashboard: Combining Your Views

Module Overview

• Concept: Introduction to Dashboards

• Demo: Building a Dashboard

• Demo: Adding Interactivity to Dashboards

• Activity: Build an Interactive Dashboard

Module 25: Create a Dashboard: Add Actions for Interactivity

Module Overview

• Concept: Using More Actions in Dashboards

• Demo: Adding Highlight Actions to a Dashboard

• Demo: Adding Filter Actions

• Demo: Adding URL Actions to a Dashboard

• Activity: Add Actions to a Dashboard

Module 26: Sharing Your Work

Module Overview

• Concept: The Tableau File Types

• Demo: Sharing Your Work with Others

Module 27: Working with a Data Extract

Module Overview

• Concept: Deciding When to Use an Extract

• Demo: Extracting Data

• Activity: Create a Data Extract

Module 28: Joining Tables

Module Overview

• Concept: Using Table Joins

• Demo: How to Join Tables

• Activity: Join Tables and Build a View

Module 29: Joining Tables Using Calculations

Module Overview

• Demo: Writing Join Calculations

• Activity: Use a Calculation to Join Data

Module 30: Blending Multiple Data Sources

Module Overview

• Concept: Using Data from Multiple Sources

• Demo: Blending Data in a View

• Activity: Blend Data from Two Sources

Module 31: Blending Data without a Common Field

Module Overview

• Demo: Blending with Custom Relationships and Calculations

• Activity: Blend Data Using Custom Relationships

Module 32: Using Unions to Combine Data

Module Overview

• Concept: Appending Row Data with Unions

• Demo: Creating a Union Manually

• Activity: Union Data and Merge Fields

Module 33: Filtering Across Data Sources

Module Overview

• Demo: Filtering Across Data Sources

• Activity: Apply a Filter to Multiple Data Sources

Module 34: Using Sets to Highlight Data

Module Overview

• Demo: Creating Sets

• Activity: Use Combined Sets

Module 35: Using Context Filters to Limit Scope

Module Overview

• Demo: Adding a Context Filter

• Activity: Add a Filter to Context

Module 36: Using Split and Custom Split

Module Overview

• Demo: Splitting Data Fields

• Activity: Show Profitability as a Percent of Total

Module 37: Controlling Table Calculations

Module Overview

• Concept: Specifying Scope and Direction

• Demo: Controlling Scope and Direction

• Activity: Show Profitability as a Percent of Total

Module 38: Using Level of Detail Expressions

Module Overview

• Concept: Exploring Level of Detail Expressions

• Demo: Writing Calculations Fixed to a Dimension

• Activity: Calculate the Average Product Profit by Category

Module 39: Filtering and LOD Expressions

Module Overview

• Concept: Using LOD Expressions with Filters

• Demo: Controlling a Filter's Impact on Percent of Total

• Activity: Filter Percent of Sales

Module 40: Using Parameters to Control Data in the View

Module Overview

• Concept: Using Parameters to Give Control

• Demo: Adding Parameters to a View

• Activity: Use a Parameter in a Filter

Module 41: Parameters: Swap Measures

Module Overview

• Demo: Using Parameters to Swap Measures

• Activity: Create a Parameter for Switching Measures

• Activity: Use a Nested Parameter for Dynamic Selection

Module 42: Advanced Mapping: Modifying Locations

Module Overview

• Demo: Editing Location Data

• Activity: Add Location Data

Module 43: Advanced Mapping: Customizing Tableau’s Geocoding

Module Overview

• Demo: Customizing Geocodes for Addresses

• Activity: Build a Map with Custom Geocoding

Module 44: Advanced Mapping: Using a Background Image

Module Overview

• Concept: Plotting Data on a Custom Background

• Demo: Adding an Image and Plotting Data

• Activity: Plot Data on an Image

Module 45: Viewing Distributions

Module Overview

• Demo: Building Histograms

• Activity: Use a Histogram to View Distributions

• Demo: Building Box and Whisker Plots

• Activity: Use a Box Plot to View Distributions

Module 46: Comparing Measures Against a Goal

Module Overview

• Demo: Building Bar-in-Bar Charts

• Activity: Create a Bar-in-Bar Chart

• Demo: Building Bullet Graphs

• Activity: Create a Bullet Graph

Module 47: Showing Statistics and Forecasting: Use the Analytics Pane and Trend Lines

Module Overview

• Demo: Adding Trend Lines in the View

• Activity: Create Trend Lines with Small Multiples

• Demo: Generating a Forecast in the View

• Activity: Add a Forecast to a View

Module 48: Advanced Dashboards: Using Design Techniques and Filter Actions

Module Overview

• Concept: Planning for a Successful Dashboard

• Demo: Using Design Best Practices

• Activity: Improve a Dashboard's Design

• Demo: Using Advanced Filter Actions

• Activity: Create Advanced Filter Actions

Module 49: Telling Stories with Data

Module Overview

• Concept: Introduction to Tableau Stories

• Demo: Creating a Data Story

• Demo: Formatting a Story

• Activity: What's the Story?

Be the first to add a review.

Please, login to leave a review

Data Visualization Expert Track

Abstract

Instructor

Duration

Sessions

Location

Prerequisites

Statistics Essentials using SPSS and Python (30hrs)

Module 1: introduction to basics of Statistics.

Module 2: Descriptive & Inferential Statistics using SPSS-software

Module 3: Data Visualization (using Python)

Module 4: Data Prediction Models

Use Case-1

Use Case-2

Use Case-3

Use Case-4

2- Data Analysis & Visualization Using Power BI (35hrs)

Module 1: Introducing Power BI

Module 2: Introduction to the Query Editor

Module 3: Modeling Data

Module 4: Introduction to DAX

Module 5: Advanced DAX

Module 6: Interactive Data Visualizations

3- Data Analysis & Visualization Using Tableau (40hrs)

Module 1: Introduction to Tableau Desktop

Module 2: Connecting to Data

Module 3: Customizing a Data Source

Module 4: Filtering Your Data

Module 5: Sorting Your Data

Module 6: Creating Groups in Your Data

Module 7: Creating Hierarchies in Your Data

Module 8: Working with Data Fields: Discrete and Continuous Time

Module 9: Working with Data Fields: Custom Dates

Module 10: Working with Multiple Measures: Dual Axis and Combo Charts

Module 11: Working with Multiple Measures: Combined Axis Charts

Module 12: Showing Relationships between Numerical Values

Module 13: Mapping Data Geographically

Module 14: Using Crosstabs: Totals and Aggregation

Module 15: Using Crosstabs: Highlight Tables

Module 16: Using Crosstabs: Heat Maps

Module 17: Using Calculations: Customize Your Data

Module 18: Using Calculations: Working with Strings

Dates

and Type Conversion Functions

Module 19: Using Calculations: Working with Aggregations

Module 20: Using Quick Table Calculations to Analyze Data

Module 21: Showing Breakdowns of the Whole

Module 22: Using Calculations: Customize Your Data

Module 23: Highlighting Data with Reference Lines

Module 24: Create a Dashboard: Combining Your Views

Module 25: Create a Dashboard: Add Actions for Interactivity

Module 26: Sharing Your Work

Module 27: Working with a Data Extract

Module 28: Joining Tables

Module 29: Joining Tables Using Calculations

Module 30: Blending Multiple Data Sources

Module 31: Blending Data without a Common Field

Module 32: Using Unions to Combine Data

Module 33: Filtering Across Data Sources

Module 34: Using Sets to Highlight Data

Module 35: Using Context Filters to Limit Scope

Module 36: Using Split and Custom Split

Module 37: Controlling Table Calculations

Module 38: Using Level of Detail Expressions

Module 39: Filtering and LOD Expressions

Module 40: Using Parameters to Control Data in the View

Module 41: Parameters: Swap Measures

Module 42: Advanced Mapping: Modifying Locations

Module 43: Advanced Mapping: Customizing Tableau’s Geocoding

Module 44: Advanced Mapping: Using a Background Image

Module 45: Viewing Distributions

Module 46: Comparing Measures Against a Goal

Module 47: Showing Statistics and Forecasting: Use the Analytics Pane and Trend Lines

Module 48: Advanced Dashboards: Using Design Techniques and Filter Actions

Module 49: Telling Stories with Data

Be the first to add a review.

Includes