Visualización de Datos y Tableros con Excel y Cognos from Coursera

Este curso cubre algunos de los primeros pasos en el desarrollo de visualizaciones de datos utilizando hojas de cálculo y tableros. Comienza el proceso de contar una historia con tus datos creando los muchos tipos de gráficos que están disponibles en hojas de cálculo como Excel. Explore las diferentes herramientas de una hoja de cálculo, como la importante función de pivote y la capacidad de crear cuadros de mando, y aprenda cómo cada uno tiene su propia propiedad única para transformar sus datos. Continúe adquiriendo una valiosa experiencia familiarizándose con la popular herramienta analítica - IBM Cognos Analytics - para crear cuadros de mando interactivos. Al completar este curso, tendrá una comprensión básica del uso de las hojas de cálculo como herramienta de visualización de datos. Adquirirá la capacidad de crear eficazmente visualizaciones de datos, como gráficos o tablas, y comenzará a ver cómo desempeñan un papel fundamental en la comunicación de sus resultados de análisis de datos. Todo esto se puede lograr aprendiendo los fundamentos del análisis de datos con Excel y IBM Cognos Analytics, sin tener que escribir ningún código. Al final de este curso será capaz de describir las herramientas de cuadros de mando comunes utilizadas por un analista de datos, diseñar y crear un cuadro de mando en una plataforma de nube, y comenzar a elevar su nivel de confianza en la creación de visualizaciones de datos de nivel intermedio. A lo largo de este curso encontrará numerosos laboratorios prácticos y un proyecto final. Con cada laboratorio, gane experiencia práctica en la creación de gráficos básicos y avanzados, y luego continúe a través del curso y comience a crear cuadros de mando con hojas de cálculo y IBM Cognos Analytics. A continuación, terminará este curso creando un conjunto de visualizaciones de datos con IBM Cognos Analytics y creando un cuadro de mando interactivo que podrá compartir con sus compañeros, comunidades profesionales o posibles empleadores. Este curso no requiere ningún análisis de datos previo, ni experiencia en informática. Todo lo que necesita para empezar es un conocimiento básico de informática, matemáticas de nivel secundario, acceso a un navegador web moderno como Chrome o Firefox, la capacidad de crear una cuenta de Microsoft para acceder a Excel para la Web, y una comprensión básica de las hojas de cálculo de Excel.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides hands-on experience in creating visuals with Excel and IBM Cognos Analytics

Suitable for beginners seeking an introduction to data visualization tools

Provides a basic understanding of data visualization concepts

Requires only basic computer literacy and high school math knowledge

May require additional resources for students seeking a deeper understanding of data analysis

Does not cover advanced data visualization techniques or programming skills

Reviews summary

Excel-based data visualization

This course is a great introduction to creating data visualizations using Excel and IBM Cognos Analytics. There are many hands-on labs where you will gain experience creating basic and advanced charts and dashboards. Overall, this course is well-received by learners and is recommended for those who want to learn more about data visualization without having to write any code.

This course includes many hands-on labs.

"Con cada laboratorio, gane experiencia práctica en la creación de gráficos básicos y avanzados, y luego continúe a través del curso y comience a crear cuadros de mando con hojas de cálculo y IBM Cognos Analytics."

The course content is well-explained.

"Excelente!"

"Es muy bueno"

Some of the instructions are out-of-date.

"Las instrucciones están des-actualizadas y con confusiones entre el inglés y el español."

Some of the lab materials are missing or unavailable.

"los laboratorio no son descargables, por lo cual no se pueden hacer"

"los materiales para los laboratorios no estan disponibles y nadie da seguimiento a los foros"

"Puede ser un curso bastante completo y en el que se puede aprender mucho, pero no se pueden descargar los laboratorios para poder practicar y ha sido muy decepcionante"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Visualización de Datos y Tableros con Excel y Cognos with these activities:

Find a mentor in the data visualization field

Show steps

Find a mentor in the data visualization field to provide guidance and support as you learn and grow.

Browse courses on Data Visualization

Show steps

Attend industry events and meetups.
Reach out to people in your network.
Ask for introductions to potential mentors.

Review functions in Excel

Show steps

Refresh your knowledge of Excel functions to prepare for learning more advanced visualizations in this course.

Browse courses on Excel Functions

Show steps

Open an Excel spreadsheet and explore the functions available.
Try using some of the basic functions, such as SUM, AVERAGE, and COUNT.
Look up help on more advanced functions, such as VLOOKUP and HLOOKUP.

Attend a data visualization workshop

Show steps

Attend a data visualization workshop to learn new techniques and best practices from experts in the field.

Show steps

Research and find a reputable data visualization workshop.
Register for the workshop and attend.
Take notes and ask questions during the workshop.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Create charts and graphs in Excel

Show steps

Practice creating different types of charts and graphs in Excel to improve your data visualization skills.

Browse courses on Excel Charts

Show steps

Start with a simple bar chart or line graph.
Add more complex elements, such as multiple data series, titles, and labels.
Experiment with different chart types to see which ones best represent your data.

Solve data analysis problems using Excel and IBM Cognos Analytics

Show steps

Solve data analysis problems using Excel and IBM Cognos Analytics to apply your skills to real-world scenarios.

Browse courses on Data Analysis

Show steps

Find a dataset that you are interested in.
Import the dataset into Excel or IBM Cognos Analytics.
Use Excel or IBM Cognos Analytics to analyze the data and identify trends.

Design a dashboard in IBM Cognos Analytics

Show steps

Create a dashboard in IBM Cognos Analytics to practice designing and building interactive data visualizations.

Browse courses on IBM Cognos Analytics

Show steps

Start with a simple dashboard with a few widgets.
Add more widgets and customize their appearance.
Create interactive features, such as filters and drill-downs.

Create a data visualization blog post or article

Show steps

Create a data visualization blog post or article to share your knowledge and insights with others.

Browse courses on Data Visualization

Show steps

Choose a topic that you are passionate about.
Research the topic and gather data.
Create a visually appealing blog post or article.

Contribute to an open-source data visualization project

Show steps

Contribute to an open-source data visualization project to gain experience and learn from others in the field.

Browse courses on Data Visualization

Show steps

Find an open-source data visualization project that you are interested in.
Fork the project and start making changes.
Submit a pull request with your changes.

Career center

Learners who complete Visualización de Datos y Tableros con Excel y Cognos will develop knowledge and skills that may be useful to these careers:

Marketing Analyst

Marketing Analysts analyze marketing data to understand customer behavior and improve marketing campaigns. This course provides a foundation in data visualization and dashboard design which will help you present marketing data effectively and make data-driven decisions.

See salaries and explore the career path for Marketing Analyst

Business Intelligence Analyst

Business Intelligence Analysts help businesses make informed decisions by analyzing data and identifying trends. This course may be useful as it will provide you with a strong foundation in data visualization and dashboard design, which are key skills for Business Intelligence Analysts.

See salaries and explore the career path for Business Intelligence Analyst

Data Visualization Engineer

Data Visualization Engineers design and develop data visualization solutions to communicate data insights effectively. This course will provide you with a strong foundation in data visualization principles and best practices, which are crucial for a career as a Data Visualization Engineer.

See salaries and explore the career path for Data Visualization Engineer

Business Analyst

Business Analysts identify and solve business problems by analyzing data and providing recommendations. This course provides foundational knowledge in data visualization and dashboard design which will help you communicate insights effectively to stakeholders.

See salaries and explore the career path for Business Analyst

User Experience (UX) Designer

UX Designers create user-centric designs for websites, mobile apps, and other digital products. This course will provide you with skills in data visualization and dashboard design, which are becoming increasingly important for UX Designers.

See salaries and explore the career path for User Experience (UX) Designer

Tableau Developer

Tableau Developers use the Tableau platform to create interactive data visualizations and dashboards. This course will provide you with a solid foundation in data visualization principles and best practices, which will be valuable for a career as a Tableau Developer.

See salaries and explore the career path for Tableau Developer

Information Architect

Information Architects design and organize information systems to make them accessible and usable. This course will provide you with knowledge in data visualization techniques, which can be applied to organize and present information effectively.

See salaries and explore the career path for Information Architect

Power BI Developer

Power BI Developers use the Microsoft Power BI platform to create data visualizations and reports. This course will provide you with foundational knowledge in data visualization and dashboard design, which are essential skills for Power BI Developers.

See salaries and explore the career path for Power BI Developer

Financial Analyst

Financial Analysts analyze financial data to make investment recommendations and assess the financial health of companies. This course may be useful as it provides hands-on experience with data visualization techniques, which can be applied to analyze financial data and present insights.

See salaries and explore the career path for Financial Analyst

Salesforce Developer

Salesforce Developers build and customize Salesforce applications to meet business needs. This course may be useful as it provides foundational knowledge in data visualization and dashboard design which can be applied to create custom dashboards and reports in Salesforce.

See salaries and explore the career path for Salesforce Developer

Data Engineer

Data Engineers design and build data pipelines and data warehouses to support data analysis and machine learning. This course may be useful as it provides foundational knowledge in data visualization techniques, which can be applied to analyze data quality and performance.

See salaries and explore the career path for Data Engineer

Web Developer

Web Developers create and maintain websites and web applications. This course may be useful as it provides foundational knowledge in data visualization and dashboard design which can be applied to create interactive and user-friendly web interfaces.

See salaries and explore the career path for Web Developer

Product Manager

Product Managers oversee the development and launch of new products. This course may be useful as it provides foundational knowledge in data visualization and dashboard design which can be applied to track product performance and make data-driven decisions.

See salaries and explore the career path for Product Manager

Data Scientist

Data Scientists perform complex data analysis, build machine learning models, and communicate insights to stakeholders. This course may be useful as it provides hands-on experience with data visualization tools and techniques, which are essential for communicating insights and presenting data-driven solutions.

See salaries and explore the career path for Data Scientist

Data Analyst

Data Analysts transform raw data into insights that can drive business decisions by using their knowledge of data visualization techniques and data analysis tools. This course may be useful as it teaches you the basics of data visualization using Excel and IBM Cognos Analytics, which will provide a solid foundation for a career as a Data Analyst.

See salaries and explore the career path for Data Analyst