AI Academy

Introduction to Data Analytics

Instructor: Rav Ahuja Duration: 4 hours to complete
Objective 1 Explain what Data Analytics is and the key steps in the Data Analytics process
Objective 2 Differentiate between different data roles such as Data Engineer, Data Analyst, Data Scientist, Business Analyst, and Business Intelligence Analyst
Objective 3 Describe the different types of data structures, file formats, and sources of data
Objective 4 Describe the data analysis process involving collecting, wrangling, mining, and visualizing data
Data Warehousing
Big Data
Relational Databases
Apache Spark
Data Lakes
Data Visualization Software
Data Cleansing
Apache Hadoop
Data analysis
Statistical Analysis
Apache Hive

Excel Basics for Data Analysis

Instructor: Sandip Saha Joy , Steve Ryan Duration: 7 hours to complete
Objective 1 Display working knowledge of Excel for Data Analysis.
Objective 2 Perform basic spreadsheet tasks including navigation, data entry, and using formulas.
Objective 3 Employ data quality techniques to import and clean data in Excel.
Objective 4 Analyze data in spreadsheets by using filter, sort, look-up functions, as well as pivot tables.
Excel Formulas
Microsoft Excel
Data Cleansing
Data Import/Export
Pivot Tables And Charts
Information Privacy
Data Manipulation
Data Quality
Data analysis
Google Sheets
Data Wrangling
Data Visualization Software
Spreadsheet Software

Data Visualization and Dashboards with Excel and Cognos

Instructor: Sandip Saha Joy , Kevin McFaul , Steve Ryan Duration: 5 hours to complete
Objective 1 Create basic visualizations such as line graphs, bar graphs, and pie charts using Excel spreadsheets.
Objective 2 Explain the important role charts play in telling a data-driven story.
Objective 3 Construct advanced charts and visualizations such as Treemaps, Sparklines, Histogram, Scatter Plots, and Filled Map Charts.
Objective 4 Build and share interactive dashboards using Excel and Cognos Analytics.
Dashboard
Histogram
Tree Maps
Data Storytelling
Data Visualization Software
IBM Cognos Analytics
Scatter Plots
Pivot Tables And Charts
Microsoft Excel

Assessment for Data Analysis and Visualization Foundations

Instructor: IBM Skills Network Team Duration: 1 hour to complete Recommended experience
Objective 1 Demonstrate readiness for performing foundational data analysis and data visualization tasks and key steps in the Data Analytics process.
Objective 2 Differentiate between the roles different data professionals play in a modern data ecosystem.
Objective 3 Perform basic Excel tasks for Data Analysis including data quality and data preparation skills.
Objective 4 Exhibit abilities in visualizing data using Excel and proficiency in creating dashboards using Excel and Cognos Analytics.
Data Manipulation
Data Cleansing
IBM Cognos Analytics
Data Visualization Software
Analytics
Pivot Tables And Charts
Data Wrangling
Data Quality
Microsoft Excel
Data analysis
Spreadsheet Software
Data Mining
Dashboard
Exploratory Data Analysis