Core Skills:
- Workbook & Worksheet Management
- Data Entry Best Practices
- Cell Formatting & Styling
Data Tools:
- Data Validation Techniques
- Sorting & Filtering Data
- Conditional Formatting Rules
IF, AND, OR, NOT
VLOOKUP & HLOOKUP
XLOOKUP
INDEX-MATCH
SUMIF & COUNTIF
Text Functions
Date & Time Functions
Array Formulas
Dynamic Arrays
Creating Pivot Tables
Pivot Table Calculations
Grouping Data
Slicers & Timelines
Pivot Charts
Power Pivot Basics
Data Modeling
Chart Types & Selection
Advanced Chart Formatting
Combo Charts
Sparklines
Dynamic Charts
Dashboard Design
Power Query Editor
Data Cleaning
ETL Processes
Recording Macros
VBA Programming
Custom Functions
Automation Scripts
Power BI Desktop Interface
Data Import & Connection
Report View
Data View
Model View
Power BI Service
Star Schema Design
Table Relationships
Cardinality
Cross-Filter Direction
Calculated Tables
Hierarchies
Calculated Columns
Measures
SUM, AVERAGE, COUNT
CALCULATE Function
Filter Context
Time Intelligence
Iterator Functions
Standard Visuals
Custom Visuals
Interactive Features
Drill-through Pages
Bookmarks
Report Design Best Practices
Publishing Reports
Workspaces
Row-Level Security
Sharing Options
Scheduled Refresh
Power BI Mobile
Tableau Interface
Data Connections
Data Types
Dimensions vs Measures
Worksheets & Workbooks
Bar Charts
Line Charts
Scatter Plots
Heat Maps
Tree Maps
Maps & Geographic Data
Dual-Axis Charts
Calculated Fields
Table Calculations
LOD Expressions
Parameters
Sets
Trend Lines
Dashboard Creation
Layout Containers
Filters & Actions
Story Points
Interactive Elements
Design Best Practices
Data Blending
Joins & Unions
Publishing to Tableau Public
Tableau Server
Performance Optimization
Database Basics
SELECT Statements
WHERE Clause
ORDER BY
DISTINCT
LIMIT
Data Types
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
CROSS JOIN
Self Joins
Multiple Joins
COUNT, SUM, AVG
MIN, MAX
GROUP BY
HAVING
Grouping Sets
ROLLUP & CUBE
Subqueries
Common Table Expressions (CTEs)
Window Functions
CASE Statements
UNION & UNION ALL
Normalization
Primary & Foreign Keys
Indexes
Query Optimization
Views
Stored Procedures
Variables & Data Types
Lists, Tuples, Dictionaries
Loops & Conditionals
Functions
Modules & Packages
File I/O
Error Handling
Array Operations:
- Creating Arrays
- Array Indexing & Slicing
- Array Reshaping
- Broadcasting
Mathematical Functions:
- Statistical Operations
- Linear Algebra
- Random Number Generation
- Universal Functions
Core Concepts:
- Series & DataFrames
- Data Import/Export
- Indexing & Selection
- Filtering Data
Data Operations:
- Data Cleaning
- Handling Missing Data
- Data Transformation
- GroupBy Operations
Merging & Joining
Pivot Tables
Time Series Analysis
String Operations
Apply Functions
Basic Plots:
- Line Plots
- Bar Charts
- Scatter Plots
- Histograms
Advanced Features:
- Subplots
- Customization
- Annotations
- 3D Plots
Box Plots
Heat Maps
Pie Charts
Styling & Themes
Saving Figures
Exploratory Data Analysis (EDA)
Statistical Analysis
Data Wrangling
Web Scraping Basics
API Integration
Jupyter Notebooks
Capstone Project