Digital Business

Business Analyst

Learn to tackle complex business problems with this Business Analyst Course

0.0

(0)

0 Enrolled

115 hours

Benjamin J. Dockins

About Course

Become job-ready with a globally recognized Business Analyst Certification that is designed to train you on all three aspects of Business Analysis – Planning and monitoring, Requirements elicitation, and Requirements management & communication. Learn the latest tools, work on real-world projects, and attend Masterclasses from industry experts

Maths and Stats Foundation: Understand the fundamental concepts of Mathematics and Statistics related to Data Analytics
Master Excel for Data Analytics: Learn how to use pivot tables and perform different types of data analysis using Excel worksheets
SQL for Data Analytics: Understand the concepts of Databases and SQL, and how to run basic SQL queries and analysis
Essentials of Python for Data Analysis: Understand the basics of Python programming with functions and libraries such as Pandas and NumPy
Data Analysis using Python: Leverage Python programming and functions to do exploratory data analysis and visualization
Data Visualization using Tableau: Use Tableau to perform complex calculations to understand data and create attractive dashboards

Course Content

Data Analytics with Excel
- Data Analysis using Excel - Learn about Excel Basics and Formulas - Perform Statistical Analysis using Excel - Learn to use Pivot Tables

Data Cleaning and Preparing
PivotTable and Grouping for Data Analysis
Scenario and Sensitivity Analysis
Lookup Functions and Merging Techniques
Charts and Visualization Techniques
Data Analysis ToolPak for Statistics

Version Control using Git and GitHub

Maths and Stats Foundations

Data Analysis using SQL

What is SQL and Why is it Important?
SQL Database Admin Commands
The Basics of SQL
Filtering Data Using WHERE Clause in SQL
Aggregation and Summary Functions in SQL
Miscellaneous Analysis in SQL
Table to Table Relationship in SQL
Combining Tables
Advanced SQL Data Analysis
Making Efficient Analysis

Python for Data Analytics

Introduction to Python
Code and Data
Building Blocks
Strings
Data Structures
Flow Control
Functions
Modules
Files
NumPy
Pandas
Regular Expression
Visualization

Advanced Data Analysis with Python

Data Visualization using Tableau

Introduction to Data Visualization and Tableau
Understanding Tableau Building Blocks
Managing Data connections
Prepare Data for use
Basic Data Visualization
Advanced Data Visualization
Slicing and Dicing Data
Tableau Basic Calculations
Tableau Advanced Calculations
Formatting
Dashboard Designing
Publishing and Sharing

Instructors

Benjamin J. Dockins

0.0

1 Student

16 Courses

No Review Yet

Level Intermediate
Duration 115 hours
Last Updated June 10, 2024

Business Analyst

About Course

What Will You Learn?

Requirements

Audience

Course Content

Data Analytics with Excel - Data Analysis using Excel - Learn about Excel Basics and Formulas - Perform Statistical Analysis using Excel - Learn to use Pivot Tables

Data Cleaning and Preparing

PivotTable and Grouping for Data Analysis

Scenario and Sensitivity Analysis

Lookup Functions and Merging Techniques

Charts and Visualization Techniques

Data Analysis ToolPak for Statistics

Version Control using Git and GitHub

Introduction to Version Control with Git

Git from the Command Line

Everyday Git Commands

Git for collaboration

Maths and Stats Foundations

Probability

Statistics

Linear Algebra

Calculus

Data Analysis using SQL

What is SQL and Why is it Important?

SQL Database Admin Commands

The Basics of SQL

Filtering Data Using WHERE Clause in SQL

Aggregation and Summary Functions in SQL

Miscellaneous Analysis in SQL

Table to Table Relationship in SQL

Combining Tables

Advanced SQL Data Analysis

Making Efficient Analysis

Python for Data Analytics

Introduction to Python

Code and Data

Building Blocks

Strings

Data Structures

Flow Control

Functions

Modules

Files

NumPy

Pandas

Regular Expression

Visualization

Advanced Data Analysis with Python

Exploratory Data Analysis in Python

Confirmatory Data Analysis in Python

Intermediate pandas

Unstructured Data in Python

Working with APIs in Python

Parallel Computing with Dask

Intermediate Seaborn

Interactive Visualizations with Plotly and Bokeh

Data Visualization using Tableau

Introduction to Data Visualization and Tableau

Understanding Tableau Building Blocks

Managing Data connections

Prepare Data for use

Basic Data Visualization

Advanced Data Visualization

Slicing and Dicing Data

Tableau Basic Calculations

Tableau Advanced Calculations

Formatting

Dashboard Designing

Publishing and Sharing

Instructors

Benjamin J. Dockins

Related Courses

Digital Marketing

Call us

+1 212-344-4111

About

CATEGORIES

SUPPORT

Data Analytics with Excel
- Data Analysis using Excel - Learn about Excel Basics and Formulas - Perform Statistical Analysis using Excel - Learn to use Pivot Tables