logo

MasterCourses - Data Analyst

MasterCourses - Data Analyst

16

פרקים

51

שיעורים
תוכן עניינים
Analyst role and workflow
KPI trees and metrics
AI ecosystem
Project scoping
Data structure intro
Smart Cleaning & Manipulation
The Human Firewall: Data Validation & QA
Data audit
Logic Architecture: Extensive Formulas Intro
Advanced Practice: The X-Lookups & Joins Era
Insight-Driven Visualization (The Zebra Way)
Spreadsheet workflows in organizations
Business questions to data
Spreadsheet case project
SQL basics
SQL cheatsheet - AI Boosting & Validation
Use AI to master SQL + Validate cycle
SQL&AI data exploration and self pentest
Advanced and common analysis
SQL debugging and refactoring
Business needs to SQL - Data exploration and exploitation
SQL case project
SQL interview prep
What's code? Python Environment
AI-Powered Data Manipulation
Automated Cleaning & Standardization
Code pipelines
Visualization
Statistics
A/B testing
Python case project
Power BI basics
Relational Data Modeling - Star Schema
DAX basics + AI boosting
Practising advanced DAX using AI
IBCS Standard Reporting with Zebra AI
UI/UX: Interactivity & User Navigation
Security, Governance & Service Deployment
Storytelling
BI case project
BI build
Advanced IDE Mastery: Cursor, Git
Exploring production code with cursor
AI workflow patterns using claude code
Validation, logs, and Orchestration
Data exploitation
End-to-end AI workflow
QA review
Analysis build
Behavioral interview
Demo day