Connect with us

Masters of Computer Science

DATA ANALYTICS & VISUALIZATION | Microsyllabus | MCS

Published

on

Introducing Data Visualization:

  • What is data visualization?
  • Understanding Data Visualization
  • Importance of Data Visualization
  • Impact of data visualization
  • Principles of good data representation
  • Recognizing the Traits of Good Data Viz; Embracing the Design Process;
  • Ensuring Excellence in Your Data Visualizations

Exploring Common Types of Data Visualization:

  • Data visualization Vs. Infographics
  • Picking the right content type
  • Appreciating interactive data visualization
  • Observing visualizations in different fields; using dashboards
  • Discovering infographics

Analysing Data Using Excel:

Tables

  • What is a table?
  • Creating tables
  • Changing the table range
  • Inserting table columns
  • Inserting table rows
  • Deleting rows or columns
  • Creating a table total row
  • Sorting and filtering tables
  • Sorting data in a table

Dates

  • Dates and time in Excel
  • Inserting and formatting dates
  • Entering date functions
  • Using dates in formulas

Charts

  • Creating a chart
  • Manipulating a chart
  • Moving and resizing a chart
  • Adding a chat title
  • Adding a chart axis title
  • Changing the type of chart
  • Formatting a chart

Conditional Formulas and Formatting

  • The IF Function
  • Using the function library
  • Manually entering a function
  • Conditional formatting
  • Applying conditional formatting

Lookup Functions

  • Using VLOOKUP to find data
  • How to find an exact match with VLOOKUP
  • Finding the closest match with VLOOKUP
  • How to use the MATCH function and Index function

Pivot tables and pivot charts

  • What is a pivot table?
  • Preparing data to create a pivot table
  • Creating a pivot table
  • Quick analysis
  • Adding fields to the pivot table
  • Creating a pivot table frame (Classic pivot table layout)
  • Rearranging pivot table data
  • Hiding and showing field data
  • The pivot table tools ribbon

Macros

  • What is a macro?
  • Creating a macro
  • The developer ribbon
  • Recording a macro
  • Playing a macro

Macros

  • What is a macro?
  • Creating a macro
  • The developer ribbon
  • Recording a macro
  • Playing a macro

Introduction to Data Visualization Using R:

  • Installing R and Rstudio
  • A tour of Rstudio
  • Vectors in R
  • Data frames
  • Working with ggplot
  • Installing ggplot2
  • Plotting a poing with ggplot
  • Controlling axis properties
  • More with color and shape
  • Graphing lines with ggplot
  • More with lines
  • Sampling from populations
  • Normal populations
  • Plotting a vertical sample
  • Plotting several vertical samples
  • Samples along a line
  • Sapply
  • Cloud of points

Introduction to Programming with Python:

Introduction to programming with python

  • Hands on with python and jupyter notebooks
    • Variables and data types
    • Conditional statements and loops
    • Reusable coding: functions
    • Arithmetic operations
    • Manipulate data types

Numerical computing with numpy

  • Python lists to numpy arrays
    • Multi-dimensional arrays
    • Array operations, slicing and broadcasting
    • Working with CSV data files

Analyzing Tabular Data with Pandas

  • Reading and Writing CSV data with pandas
    • Querying, filtering and sorting data frames
    • Grouping andaggregation for data summarization
    • Merging and joining data from multiple sources

Visulatization with Matplotlib and Seaborn

  • Basic visualization with matplotlib
    • Advanced visualizations with seaborn
    • Customizing and styling charts
  • Plotting images and grids of charts
Facebook Comments

10 Hits in 30 Days

DMCA
PROTECTED