EdX

Excel avanzado: importación y análisis de datos (edX)

Offered by Universitat Politècnica de València, UPValenciaX,

Conoce técnicas y estrategias avanzadas para importar, consolidar y visualizar con Excel datos provenientes de cualquier fuente. En este curso de análisis e interpretación de datos te presentaremos técnicas avanzadas de importación de datos y estrategias diversas para consolidarlos y prepararlos una vez importados de forma que puedas extraer las conclusiones que necesitas (basadas en nuestra experiencia en el uso de Microsoft Excel y demostradas con casos reales).

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

Te presentaremos también las nuevas herramientas y técnicas de modelo de datos e importación avanzada incorporados desde Excel 2010 que permiten trabajar de forma mucho más cómoda con grandes volúmenes de datos repartidos en varias tablas y automatizar la importación para no tener que repetir los pasos cada vez que actualices los datos.

Veremos también las distintas opciones disponibles a la hora de configurar tablas y gráficos dinámicos en Excel para que sean lo más versátiles posibles y nos permitan analizar distintos escenarios de forma sencilla.
Estas herramientas y técnicas de análisis de datos te permitirán implementar inteligencia de negocios (Business Intelligence) en los diferentes proyectos de una organización.
This course is part of the following programs:

What you'll learn

Cómo hacer un preprocesado de datos con editores avanzados de texto para eliminar problemas de importación
Cómo usar las herramientas Powerquery de importación de datos en Excel incluidas en las últimas versiones para automatizar el proceso de ingesta de datos
Cómo utilizar diversas funciones y estrategias para agrupar y consolidar los datos de forma que nos den la información que necesitamos y poderla usar en la inteligencia de negocios
Cómo usar las funciones Powerpivot y el modelo de datos incluidos en las nuevas versiones de Excel para trabajar de forma sencilla con datos de múltiples tablas con millones de registros como las que se manejan en Big Data
Cómo utilizar los slicers y otras funciones avanzadas de tablas y gráficos dinámicos en Excel

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 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)

Management & Leadership

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

Cloud Databases Big Data

Advanced Statistical Inference and Modelling Using R (edX)

EdX

University of Canterbury,UCx

Advanced Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Extend your knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up. Advanced Statistical Inference and Modelling Using R is part two of the Statistical Analysis in R professional certificate. This course is directed at people who are already familiar with basic linear regression and fundamentals of statistical inference. It extends the knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up.

Self Paced

Self-Paced

Modeling Data Analysis Linear Regression

EdX

HarvardX,Harvard University

High-Dimensional Data Analysis (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

A focus on several techniques that are widely used in the analysis of high-dimensional data. If you’re interested in data analysis and interpretation, then this is the data science course for you. We start by learning the mathematical definition of distance and use this to motivate the use of the singular value decomposition (SVD) for dimension reduction and multi-dimensional scaling and its connection to principle component analysis.

Self Paced

Self-Paced

Machine Learning Clustering Data Analysis

EdX

University of Adelaide,AdelaideX

Big Data Capstone Project (edX)

Statistics & Data Analysis Data Science

Further develop your knowledge of big data by applying the skills you have learned to a real-world data science project. This project will give you the opportunity to deepen your learning by giving you valuable experience in evaluating, selecting and applying relevant data science techniques, principles and theory to a data science problem. This project will see you plan and execute a reasonably substantial project and demonstrate autonomy, initiative and accountability.

Self Paced

Self-Paced

Big Data Data Science Data Analytics

Computational Thinking and Big Data (edX)

EdX

University of Adelaide,AdelaideX

Computational Thinking and Big Data (edX)

CS: Software Engineering Statistics & Data Analysis

Learn the core concepts of computational thinking and how to collect, clean and consolidate large-scale datasets. Computational thinking is an invaluable skill that can be used across every industry, as it allows you to formulate a problem and express a solution in such a way that a computer can effectively carry it out.

Self Paced

Self-Paced

Big Data Data Science Algorithmic Thinking

Analyzing and Visualizing Data with Power BI (edX)

EdX

Davidson College,DavidsonX

Analyzing and Visualizing Data with Power BI (edX)

Statistics & Data Analysis Computer Science

Step up your analytics game and learn one of the most in-demand job skills in the United States. Power BI is a robust business analytics and visualization tool from Microsoft that helps data professionals bring their data to life and tell more meaningful stores. This four-week course is a beginner's guide to working with data in Power BI and is perfect for professionals. You'll become confident in working with data, creating data visualizations, and preparing reports and dashboards.

Self Paced

Self-Paced

Data Analysis Data Visualization Power BI

Introduction to Linear Models and Matrix Algebra (edX)

EdX

HarvardX,Harvard University

Introduction to Linear Models and Matrix Algebra (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

Learn to use R programming to apply linear models to analyze data in life sciences. Matrix Algebra underlies many of the current tools for experimental design and the analysis of high-dimensional data. In this introductory data analysis course, we will use matrix algebra to represent the linear models that commonly used to model differences between experimental units. We perform statistical inference on these differences. Throughout the course we will use the R programming language.

Self Paced

Self-Paced

Algebra Linear Algebra Matrix

EdX

Davidson College,DavidsonX

RShiny for Everyone (edX)

Statistics & Data Analysis

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 Analysis Web Applications Data Visualization

Data Visualization and Building Dashboards with Excel and Cognos (edX)

EdX

IBM

Data Visualization and Building Dashboards with Excel and Cognos (edX)

Statistics & Data Analysis

Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data. This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel and IBM Cognos Analytics.

Self Paced

Self-Paced

Spreadsheets Excel Analytics

Basics of Statistical Inference and Modelling Using R (edX)

EdX

University of Canterbury,UCx

Basics of Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Learn why a statistical method works, how to implement it using R and when to apply it and where to look if the particular statistical method is not applicable in the specific situation. Basics of Statistical Inference and Modelling Using R is part one of the Statistical Analysis in R professional certificate.

Self Paced

Self-Paced

Statistics Modeling Data Analysis

EdX

Universitat Politècnica de València,UPValenciaX

Excel: Gestión de datos (edX)

CS: Software Engineering CS: Information & Technology

En este curso profundizarás en las herramientas para el tratamiento y manejo de datos que ofrece Excel. Este es un curso de nivel intermedio que te permitirá trabajar con datos para su tratamiento y extraer conclusiones mediante el agrupamiento de datos, el uso de tablas y gráficos dinámicos, la realización de análisis de hipótesis y la vinculación de datos de otras hojas de cálculo.

Self Paced

Self-Paced

Spreadsheets Excel Data Management

EdX

IBM

Analyzing Data with Excel (edX)

Statistics & Data Analysis

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

Data Spreadsheets Excel