Data Analyst Expert ניתוח וויזואליזציית נתונים

Module Title

Module Description

SQL

Basic data analysis using SQL

• Basic select statements  
• Filtering and sorting the results Scalar Functions
• Group Functions
• Join methods
• Sub Queries
• Add, modify, or remove data from a table Creating new tables

Advanced SQL for data analysts

• Complex scalar functions
• Advanced techniques for filtering and sorting values
• Working with analytical functions
• Advanced use of Group Functions
• Working with complex Subqueries
• Use of CTE and recursive CTE
• Advanced tables integration using JOIN, UNION and CROSS APPLY
• XML techniques for solving complex problems
• Working with PIVOT and UNPIVOT

Developing programs using MSSQL

• Variables
• Conditions & Loops
• Using Cursors
• Error Handling
• Using Stored Procedures
• Using Functions
• T-SQL Triggers

Database Structures

• Database structure - logical and physical
• Intro to Indexes and Execution Plans  
• Data Warehouse basics (ETLs, Cubes, and Reporting layer)

Data Analysis using Python

Python Basics

• Printing in Python, using Literal Expressions
• Variables
• Strings and Numbers
• Printing data from users
• Working with data types
• Slicers
• Control structures
• Data Structures
• Functions
• Error Handling

Data analysis using Pandas

• Basic Select Operations
• Filtering & Sorting
• Applying Scalar Functions
• Aggregative Functions
• SET Operations
• JOIN Operations
• Schema Modifications
• Pandas Indexes
• Pivot operations
• Input / Output Operations
• Working with Analytic Functions
• Data Exploration and Basic ML

Data Analysis using Excel

Data analysis using Excel

• Working with built-in tables and functions
• Conditions
• Data connectivity
• Data integration
• What-If analysis
• Spreadsheet Application
• Protecting Excel
• Macros
• Pivot Tables
• Powerpivot for Excel

Power BI

Data visualization using Power BI

• Introduction to Power BI
• Power BI Architecture
• Working with Power BI
• Development
• Visualizations
• Integrating R
• Data Security
• Sharing and Deployment

Introduction to Big Data Analysis

Understanding Big Data main concepts

• Big Data fundamental concepts
• Use cases