Lo que aprenderás
- Use Excel spreadsheets to perform data analysis tasks such as data preparation (wrangling), creating pivot tables, data mining, & plotting charts.
- Complete the data analysis process, from data preparation to statistical analysis and predictive modeling using R, R Studio, and Jupyter.
- Create relational databases and tables, query data, sort, filter and aggregate result sets using SQL and R from JupyterLab.
- Communicate data findings with various data visualization techniques including, charts, plots & interactive dashboards such as Cognos and R Shiny.
This Professional Certificate program is intended for anyone who is seeking to develop the job-ready skills, tools, and portfolio for an entry-level data analyst or data scientist position. No prior knowledge of R, or programming is required to get you started!
In this Data Analytics and Visualization with Excel and R Professional Certificate Program, you will dive into the role of a data analyst or data scientist and develop the essential skills you need work with a range of data sources and apply powerful tools, including Excel, Cognos Analytics, and the R programming language (including: ggplot2, Leaflet and R Shiny), towards becoming a data driven practitioner, and gaining a competitive edge in the job market.
By the end of this program, you will be able to explain the data analyst and data scientist roles. Skills you will developer and tools you will be exposed to in this program include:
- Excel spreadsheets to create charts and plots.
- Cognos Analytics to create interactive dashboards.
- Relational databases and query data using SQL statements.
- R programming language to complete the entire data analysis process - including data preparation, statistical analysis, data visualization, predictive modeling, and creating interactive data applications.
- Various methods to communicate your data findings and learn to prepare a report for stakeholders. This program is suitable for anyone with a passion for learning and does not require any prior data analysis, statistics, or programming experience.
Applied Learning Project
Throughout this Professional Certificate, you will also complete hands-on labs and projects to help you gain practical experience with Excel, Cognos Analytics, SQL, and the R programing language and related libraries for data science, including Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest.
In the final course in this Professional Certificate, you will complete a capstone project that applies what you have learned to a challenge that requires data collection, analysis, basic hypothesis testing, visualization, and modelling to be performed on real-world datasets.
A program subscription gives you full verified access to all courses and materials within the program you’ve enrolled in, for as long as your subscription is active. Monthly subscription pricing can help you manage your enrollment costs — instead of paying more up front, you pay a smaller amount per month for only as long as you need access. You can cancel your subscription at any time for no additional fee.
Cursos en este programa
Certificación Profesional en Data Analytics and Visualization with Excel and R de IBM
- 2–3 horas por semana durante 5 semanas
Learn the fundamentals of Data Analytics and gain an understanding of the data ecosystem, the process and lifecycle of data analytics, career opportunities, and the different learning paths you can take to be a Data Analyst.
- 2–3 horas por semana durante 5 semanas
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.
- 2–3 horas por semana durante 4 semanas
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.
- 1–2 horas por semana durante 5 semanas
This course introduces you to R language fundamentals and covers common data structures, programming techniques, and how to manipulate data all with the help of the R programming language.
- 2–3 horas por semana durante 6 semanas
Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries.
- 2–3 horas por semana durante 6 semanas
R is the key that opens the door between the problems you want to solve with data and the answers you need. This course walks you through the process of answering questions through data.
- 1–2 horas por semana durante 4 semanas
Learn about the ggplot2 data visualization package for R, creating map plots with geolocation data using Leaflet, and interactive dashboards to display your work on the web using the R Shiny package!
- 1–2 horas por semana durante 4 semanas
Apply various data analysis and visualization skills and techniques you have learned by taking on the role of a data scientist working with real-world data sets.
- Data Analysts and Data Scientists are in demand, with 20% growth expected through 2028 (U.S. Bureau of Labor Statistics).
- Over 2.5 Million jobs in data science and related professions (Burning glass).
- Data Science and Analytics professionals earn average starting salaries of over $80,000 in the US.
- R is the preferred programming language for statistical analysis in many organizations. More than 400,000 open job postings required R programming skill in the last two years.
Conoce a tus instructores de IBM
Expertos de IBM comprometidos con el aprendizaje en línea
Crece tu carrera profesional. Suscríbete hoy mismo al programa.
$39 al mes USD
- Certificados con verificación que puedes compartir al completar exitosamente un curso o programa
- Videos, conferencias y lecturas del curso
- Problemas prácticos y evaluaciones
- Tareas y exámenes corregidos
- Apoyo de edX para estudiantes
- Certificados con verificación que puedes compartir al completar exitosamente un curso o programa
Comienza con data science
Explorar otros cursos de data scienceInspiradores
Impulsa tu carrera profesional con programas de crédito respaldados por universidades y certificados verificados.Prácticos
Estudia y demuestra tu conocimiento a tu ritmoFlexibles
Prueba un curso antes de pagarAlentadores
Estudia con compañeros universitarios y colegas de todo el mundo