IBM Knowledge Analytics with Excel and R Skilled Certificates

WHAT YOU WILL LEARN

• Make the most of Excel spreadsheets to carry out quite a lot of information evaluation duties like information wrangling, utilizing pivot tables, information mining, & creating charts

• Full the information evaluation course of, together with information preparation, statistical evaluation, predictive modeling, utilizing R, R Studio, and Jupyter

• Create relational databases and tables, question information, type, filter and combination outcome units utilizing SQL and R from JupyterLab

• Talk your information findings utilizing varied information visualization strategies together with, charts, plots & interactive dashboards with Cognos and R Shiny

---

SKILLS YOU WILL GAIN

• Knowledge Science
• Spreadsheet
• Knowledge Evaluation
• Microsoft Excel
• Pivot Desk
• Knowledge Visualization (DataViz)
• IBM Cognos Analytics
• Dashboard
• R Programming
• Choose (Sql)
• Relational Databases (RDBMS)
• Tables (Database)

About this Skilled Certificates

This Skilled Certificates is meant for anybody who’s in search of to develop the job-ready abilities, instruments, and portfolio for an entry-level information analyst or information scientist place. By way of these eight on-line programs, you’ll dive into the position of an information analyst or information scientist and develop the important abilities you want work with a variety of knowledge sources and apply highly effective instruments, together with Excel, Cognos Analytics, and the R programming language, in the direction of changing into an information pushed practitioner, and gaining a aggressive edge within the job market.

By the tip of this Skilled Certificates, it is possible for you to to clarify the information analyst and information scientist roles. You’ll work with Excel spreadsheets and make the most of them for information evaluation to create charts and plots. You’ll make the most of Cognos Analytics to create interactive dashboards. You’ll work with relational databases and question information utilizing SQL statements. You’ll use the R programming language to finish the complete information evaluation course of – together with information preparation, statistical evaluation, information visualization, predictive modeling, and creating interactive information functions. Additionally, you will talk your information findings and study to arrange a report for stakeholders.

This program is appropriate for anybody with a ardour for studying and doesn’t require any prior information evaluation, statistics, or programming expertise.

Utilized Studying Challenge

All through this Skilled Certificates, you’ll full hands-on labs and initiatives that can assist you acquire sensible expertise with Excel, Cognos Analytics, SQL, and the R programing language and associated libraries for information science, together with Tidyverse, Tidymodels, R Shiny, ggplot2, Leaflet, and rvest.

Within the remaining course on this Skilled Certificates, you’ll full a capstone undertaking that applies what you might have realized to a problem that requires information assortment, evaluation, primary speculation testing, visualization, and modelling to be carried out on real-world datasets.