Course

Objective:

Learning Outcomes:

• Implement effective data management solutions
• Use Talend Open Studio to showcase the ETL concept
• Create a data model
• Work with functions which apply to each element of an array
• Perform reshape operations on arrays to visualize its contents in different ways
• Perform operations between arrays of mismatched shapes by applying broadcasting rules
• Utilize NumPy to perform multi-dimensional array operations
• Work with Pandas Series by accessing elements using the default and a custom index
• Apply a join operation on two related but dissimilar DataFrames using the merge function
• Use Pandas for advanced tabular data manipulation
• Apply classification and clustering methods to data science problems using R
• Compare and contrast SQL and NoSQL database solutions
• Use Visual Paradigm to create a relational database ERD
• Describe distributed systems from a data perspective
• Install NumPy and learn how to create basic NumPy arrays
• Apply boolean masks to access array elements which fulfil a specific condition
• Install Pandas and create a Pandas Series
• Apply a multi-index to a DataFrame and reshape it using the stack and melt operations
• Implement a hierarchical index and access the DataFrame's contents based on that index
• Create, manipulate, and sort vectors in R
• Create factors and data frames in R
• Perform matrix operations in R
• Export tabular data from R to a CSV file, an Excel spreadsheet, and an HTML table
• Use the dplyr library including working with tabular data, piping data, mutating data, summarizing data, combining datasets, and grouping data
• Apply regression methods to data science problems using R
• Differentiate between inferential and descriptive statistics, enumerate the two most important types of descriptive statistics, and define the formula for standard deviation

General Topics: