EdX

Data Storage and Processing (edX)

Offered by ITMO University, ITMOx,
Data Storage and Processing (edX)

Master the culture of data representation, interpretation and outcomes evaluation. Learn the fundamentals of relational and NoSQL database management systems. Want to learn data processing and interpreting the result you’ve got? This course is for you! Get acquainted with preparing and analyzing large amount of data, as well as data storage fundamentals.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

This course is an introduction to initial data processing. We will start with data types and sources, methods of data preparation: cleaning, filling in the missing values, data smoothing and normalization. The course will familiarize you with the descriptive statistics and data visualization methods. You will also learn how to analyze time series and find trends.
Get acquainted with the fundamentals of data storage and access: databases types, relational and NoSQL databases, big data initials.
No previous programming knowledge needed.
This course is part of the Data Processing and Analysis Professional Certificate.

What you'll learn

  • Initial data processing (data cleaning and filling in the missing values)
  • Data smoothing and normalization
  • Data visualization
  • Time series analysis
  • Descriptive statistics
  • Data storage and access by means of relational DBMS
  • NoSQL databases and Big data

Syllabus

Week 1:Data preprocessing. Basic concepts of data processing. Stages of data analysis (collection, sorting, transformation, building models and interpretation). Data measurements and scales. Data types and sources. Data preparing.

Week 2:Data processing tools and visualization. Digital spreadsheets. Data visualization goals. Methods and purposes of correct data visualization.

Week 3: Data processing. Descriptive statistics. Data normalization and transformation. Time-series analysis and forecasting. Types of time-series smoothing. Trends, seasonal time series modelling.

Week 4:Relational databases management systems. Introduction to relational DBMS starting from relational data model. SQL statements and queries creation. Database indexes and transactions requirements.

Week 5:NoSQL. Main characteristics of not only SQL databases. Non-structured and semi-structured data and scalability of NoSQL databases. Types of NoSQL databases: column-oriented, key-value store, document store and graph databases.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to Data Science and Basic Statistics for Business (edX) EdX
Tecnológico de Monterrey,TecdeMonterreyX

Introduction to Data Science and Basic Statistics for Business (edX)

In this course you will acquire statistical methods for decision making in business, as well as technological tools to develop quantitative skills. Areas such as " big data" require very clear knowledge of statistics and business, technology provides us various applications that require solid training in statistics for proper use and interpretation .

Self Paced
Self-Paced
Data Processing and Analysis with Excel (edX) EdX
Rochester Institute of Technology,RITx

Data Processing and Analysis with Excel (edX)

Learn to use Excel to organize and clean data so it can be manipulated and analyzed. In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and anomalies in the data, and how to identify and change data-types. Together we will develop a data analysis plan, after which we will apply analysis methods and tools, including exploratory analysis, evaluation of results, and comparison with other findings.

Self Paced
Self-Paced
Data Representation and Visualization in Tableau (edX) EdX
Rochester Institute of Technology,RITx

Data Representation and Visualization in Tableau (edX)

Use Tableau to explore data and discover insights to innovate data-driven decision-making.Use Tableau to explore data and discover insights to innovate data-driven decision-making. Employer demand for Tableau skills will grow 35% over the next 10 years. Whether you are in a data-centric role or just need to add data skills to take your job or career to the next level, this course will provide the foundation and skills to get started using one of today’s most impactful data visualization tools.

Self Paced
Self-Paced
Storytelling and Persuading using Data and Digital Technologies (edX) EdX
University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Storytelling and Persuading using Data and Digital Technologies (edX)

Learn how to gain traction for your digital transformation initiatives with stories based on data that use compelling data visualizations to build a persuasive business case. Decisions made by humans are rarely made by data alone. Human decision-makers have cognitive biases, are affected by emotions, and make conceptual leaps beyond what the data may suggest.

Self Paced
Self-Paced
RShiny for Everyone (edX) EdX
Davidson College,DavidsonX

RShiny for Everyone (edX)

Use R’s Shiny package to create data-driven, interactive web applications. In this course, you will use R Shiny to create an interactive web application that highlights the biodiversity of America’s National Parks. Your application will feature an interactive map, biodiversity calculator, trail journal and species images. Using R Shiny, you will expand your data analysis and visualization skills while developing your workflow through web application deployment.

Self Paced
Self-Paced
Data Analytics and Visualization Capstone Project (edX) EdX
IBM

Data Analytics and Visualization Capstone Project (edX)

Accelerate the knowledge you gain from previous courses in the IBM Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task. This course provides students with the opportunity to assume the role of an Associate Data Analyst who has recently joined an organization. In this role, you will use Data Analytics skills and techniques on real-world datasets to complete a business task.

Self Paced
Self-Paced
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data. This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Self Paced
Self-Paced
Introducción a los Sistemas de Información Gerencial (MIS): Una guía de supervivencia (edX) EdX
Universidad Carlos III de Madrid - UC3M,UC3Mx

Introducción a los Sistemas de Información Gerencial (MIS): Una guía de supervivencia (edX)

Obtén las habilidades y el conocimiento necesarios para tener éxito en un mundo corporativo dominado por los sistemas de información gerencial (SIG o MIS). Los omnipresentes Sistemas de Información Gerencial (SIG) o Management Information Systems (MIS) juegan un papel crítico en el actual panorama profesional. Desde los sistemas de gestión de las relaciones con los clientes, que gestionan las interacciones diarias con los clientes actuales y potenciales, hasta los sistemas gerenciales y financieros que emiten y pagan facturas, el día a día de la vida laboral está cada vez más controlado por estos sistemas de gestión, que dictan qué hacer y cómo hacerlo.

Self Paced
Self-Paced
Minería de Datos: Análisis de la Canasta de Compra (edX) EdX
Universidad Anáhuac,AnahuacX

Minería de Datos: Análisis de la Canasta de Compra (edX)

¿Conoces realmente qué productos de la canasta de mercado compran tus clientes o te dejas llevar por lo que aparenta a simple vista? En este curso aprenderás a construir modelos basados en técnicas de data mining o minería de datos, que te permitirán conocer información relevante de tus clientes y descubrir patrones de comportamiento para definir estrategias de marketing de acuerdo a la compra de productos.

Self Paced
Self-Paced
Introduction to Management Information Systems (MIS): A Survival Guide (edX) EdX
Universidad Carlos III de Madrid - UC3M,UC3Mx

Introduction to Management Information Systems (MIS): A Survival Guide (edX)

Gain the skills and knowledge needed to succeed in an MIS-dominated corporate world. This MIS course will cover supporting tech infrastructures (Cloud, Databases, Big Data), the MIS development/ procurement process, and the main integrated systems, ERPs, such as SAP®, Oracle® or Microsoft Dynamics Navision®, as well as their relationship with Business Process Redesign.

Self Paced
Self-Paced