What is Data Science?

What does Data Science involve?

Era of Data Science

Business Intelligence vs Data Science

Life cycle of Data Science

Tools of Data Science

Work on Practical AnalysisCopy

Introduction to R

Improve your skills using Microsoft Excel and associated Excel features, to better report and analyse your data.

An Overview of the Notation for Business Process Modeling (BPMN)Copy

Using BPMN for Advanced Process ModelingCopy

BPMN Modeling Elements in Extensive FormCopy

Creating Hierarchical ChartsCopy

Taking Advantage of Pools and LanesCopy

Exceptions in the ProcessCopy

Observing and Analyzing Business ProcessesCopy

Business Process Architecture: An Overview Customers and Gaps in the Process: Identifying and AnalyzingCopy

Notation

Means and Deviations

Create our first pivot table.

Use multiple pivot tables and pivot charts to create our first dashboard.

Support Vector Machine: Classification

Connect multiple slicers to the pivot tables.

Key Excel Functions: If

Enlarge the formula bar

Key Excel Functions: Sum, Sumif, Sumifs

Key Excel Functions: Count, Counta, Countif, Countifs

Key Excel Functions: Average & Averageif

Key Excel Functions: Average & Averageif

Excel’s Lookup Functions: Vlookup & Hlookup Made Easy

Using Excel’s Iferror Function to Trap Spreadsheet Errors

Index, Match, and Their Combination – The Perfect Substitute for Vlookup

Goal Seek Will Help You Find the Result You Are Looking For

A Useful Tool for Financial Analysis – The Rank Function

Perform Sensitivity Analysis with Excel’s Data Tables Functionality

Using Excel’s Iferror Function to Trap Spreadsheet Errors

Create Flexible Financial Models with Choose