Data Analyst

250 Hours / 6 Months, Evening course

This part-time Data Analyst program features expert instruction, hands-on projects, and a real connection to the industry to get graduates hired.

In the digital kingdom, where web and mobile applications help us manage nearly every aspect of our lives, data is king. Every digital action is visible and trackable, enabling corporations to accumulate and analyze vast amounts of both personal and business data. The use of ‘Big Data’ is driving disruption in every field — from vehicle navigation, through medicine, to cybersecurity.

Over the last few years, new professions like Data Analysts and Data Scientists have appeared on the market. Data Analysts examine large sets of data to identify patterns in the data. These patterns are then used to inform strategic business decisions. 

Teach Students to Solve The World’s Most Interesting Problems

Graduates will become indispensable to employers with data analysis fluency. Graduates will harness the predictive power of data to work at the forefront of diverse industries like public policy, robotics, and FinTech.

Open Doors With Industry Connections

Equip students to succeed in a rapidly expanding field with help from our network of data experts, instructors, hiring partners, and alumni. The Data Analyst curriculum was created in collaboration with the industry’s leading companies to make our programs as relevant as possible to the local industry’s needs, assuring graduates will be job-ready as soon as the program ends.

Guide Students to Deliver a Professional Project

Throughout the program, practical skills are acquired through the completion of projects that tackle real-world data problems from end to end. Students will gain hands-on experience with market-leading technologies, processing information, data analysis capabilities, and more, compiling a portfolio of projects designed to reinforce what students have learned in each unit.

Who Is the Program For?

Driven and motivated individuals, with or without tech background, who wish to launch a highly sought-after career as a Data Analyst.

Candidates for the program are required to have basic Microsoft Excel skills.

Top Notch Professionals

This unique program was built by a professional team made up of the leading experts in Data Science and Analytics, with vast knowledge and experience in training too.

Eran Lasser

CEO of Wawiwa

Eran is a tech education entrepreneur with over 20 years of experience. Eran founded and managed four IT training companies: John Bryce Training (Israel), TRIG (China), JB-IQsoft (Hungary), KocBryce (Turkey). Eran also partnered to establish DAN.IT Education (Ukraine), Techub (Georgia), and more. In addition, Eran managed Mentergy, which provides e-learning and distance learning solutions. Over the years, he was responsible for the reskilling of more than 50,000 individuals now working as tech professionals.

Daniel Anderson

Chief Training Officer

Daniel is responsible for updating state-of-the-art topics in the company’s tech training programs, and for maintaining its training methodologies. Daniel was the Chief Trainer at the Israel Defense Force’s Tech Training Center and is a graduate of the IDF training process. He develops and delivers a wide range of programming courses, and is a Full-Stack Developer and Data Scientist.

Talia Morchi

Head of Data Analyst Program

Talia has over 10 years of experience in the IT industry, having held the roles of Product Manager, Project Manager, and Data Solutions Manager, where she specialized in data analysis in addition to her other responsibilities. She is a lecturer at G-Stat and both an academic director and lecturer at New Media College in Israel. where she manages, teaches, and develops training materials for the Data Analyst courses. Talia is an expert in various development tools, including SQL, Python, Excel, and uniPaaS.

Program Curriculum

  • General introduction
  • Analyst role and capabilities required
  • KPI
  • Analyst work circle
  • Introduction to relational database 
  • Insights that can be derived from the data
  • Introduction to MSSQL 
  • Introduction to work environment 
  • Basic SQL query 
  • Calculated columns 
  • Basic built in functions 
  • Sorting the results 
  • Grouping and aggregate  
  • Advance filtering 
  • Working with NULL values 
  • Diagram 
  • Join tables
  • Conditional statement 
  • Related and unrelated nested queries 
  • Most common built in functions 
  • Window functions 
  • CTE (Common Table Expression) 
  • DML (Data Manipulation Language) 
  • DDL (Data Definition Language) 
  • Data analysis using analyst work circle 
  • Writing user scalar functions 
  • Stored procedure
  • Formulas 
  • Basic and advanced filtering data 
  • Sorting data 
  • Common use build-in functions 
  • Connectivity to outer data source 
  • If functions 
  • VLOOKUP
  • Error handling 
  • What is analysis functionality 
  • Conditional formatting 
  • Charts and chart components 
  • Pivot tables 
  • Pivot charts 
  • Slicers 
  • Dashboarding
  • Introduction to tableau  
  • Connect to data 
  • Connections 
  • Dimensions 
  • Measures 
  • Basic chart types 
  • Grouping 
  • Advanced chart types
  • Combo chart 
  • Dual axis
  • Filtering 
  • Sorting 
  • Hierarchy 
  • Total and subtotals 
  • Calculated fields 
  • Custom aggregations 
  • Logic statements 
  • Dashboards 
  • Exporting a dashboard
  • Python fundamentals
  • Numpy basics
  • Basic operations and use of operators 
  • Documentation – importance and how to document 
  • Variables and basic data types 
  • Python basic build in functions 
  • String slicing 
  • Conditions 
  • Introduction to Pandas package 
  • Import data from CSV  
  • Pandas data structures: DataFrame, Series 
  • Pandas descriptive methods (head (), tail (), info (), describe () etc.)
  • Filter records by conditions  
  • Complex conditions 
  • Regex 
  • Sorting data
  • Retrieving data 
  • Handling NULL values 
  • Update data 
  • Grouping and aggregations 
  • Pivot table 
  • Cross tab 
  • Merging DataFrame methods 
  • Loops: For, While, Loop flow control 
  • Def functions 
  • Local and global variable 
  • Lambda function 
  • Apply method 
  • Connect to MSSQL 
  • Visualization with Matplotlib 
  • Visualization with Seaborn  
  • Adjusting the graph display 
  • Save data and pictures into Excel file 
  • Make your script a running program

Partner with Wawiwa to offer tech training programs in less than 6 months!

Wawiwa bridges the tech skills gap by reskilling people for tech professions in high demand. There are millions of tech vacancies and not enough tech professionals with the relevant knowledge and skills to fill them. What the industry needs of employees is not taught in long academic degrees. Wawiwa helps partners around the world to reskill, and upskill people for tech jobs through local tech training centers or programs. The company utilizes a proven training methodology, cutting-edge content, digital platforms for learning and assessment, and strong industry relations, to deliver training programs that result in higher employability and graduate satisfaction. This, in turn, also creates a strong training brand and a sustainable business for Wawiwa’s partners.