Data Analysis

INTRODUCTION TO DATA ANALYSIS

Excel for Data Analysis

Power BI

Python for Data Analysis

SQL for Data Analysis

Understanding Data Analysis

Steps Involved in the Data Analysis Process Key.

Competencies, Expertise, and Thought Process Required for a Data Analyst

Excel Basics

Pivot Tables & Charts

Power Pivot in Excel

Data Cleaning in Excel

Power Query in Excel

Data Analysis Tools

Power BI Basics

Data Loading & Transformation

Data Modeling

Creating Reports and Dashboards

DAX for Calculations

DAX Queries Tab

Power BI Basics

Data Loading & Transformation

Data Modeling

Creating Reports and Dashboards

DAX for Calculations

DAX Queries Tab

Performance Optimization in Power BI

Using Parameters in Power BI

Bookmarks in Power BI

Discovering Data Influences

Step by-Step Data Breakdown

Python Basics

Pandas Library

Data Cleaning with Python

Data Visualization with Python

Data Analysis Process

SQL Basics

Data Extraction with SQL

Data Filtering & Aggregation

Database Design Foundations

Microsoft Database Engine

Microsoft Database Engine

Data Cleaning and Transformation Functions