Data Analyst

250 Hours | 6 Months
April 2024
In-person/Remote | Morning | 9:30 ~13:00

June 2024
In-person/Remote | After work | 18:30 ~22:00

Your best path to a career transformation. This part-time data analyst (BI analyst) program features expert instruction, hands-on projects, and a real connection to the industry to get you 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, also known as Business Intelligence (BI) Analysts, examine large sets of data to identify patterns in the data. These patterns are then used to inform strategic business decisions. 

Solve The World’s Most Interesting Problems

Become indispensable to employers with data analysis fluency. 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 yourself 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 you’ll be job-ready as soon as the program ends.

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. You’ll gain hands-on experience with market-leading technologies, processing information, data analysis capabilities, business intelligence, and more, compiling a portfolio of projects designed to reinforce what you’ve learned in each unit.

Who Is the Program For?

Driven and motivated individuals with previous backgrounds or with no background at all, who wish to launch a highly sought-after career as a Data or BI 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.
Data Analyst

Beatriz Duarte

Program Trainer

Professional consultant for 2 years in data analysis and Business Intelligence, with 7 previous years in the banking sector. She worked at CapGemini where he created tools and automation for business data management and analysis systems. Currently at Link involved in Data Analysis · Data Governance · Banking projects

Carla Garcia

Carla Garcia

Training Coordinator

Carla will manage the course, ensuring that you will have access to all tools, content, project and study materials.

It will support you throughout your journey as a student at TechOf.

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 analysts courses. Talia is an expert in various development tools, including SQL, Python, Excel, and uniPaaS.

Program Curriculum

Introduction module to our comprehensive Data Analyst Program, where you will embark on a journey to master the art of transforming raw data into meaningful insights. We will do an overview of the tools to equip you with essential skills and knowledge to analyze data, visualize patterns, and make informed business decisions.

  • General introduction
  • Analyst role and capabilities required
  • KPI
  • Analyst work circle
  • Introduction to relational database 
  • Insights that can be derived from the data

Our SQL(Structured Query Language) Foundation Module is a fundamental tool in the world of data management and analysis. Whether you’re a beginner aspiring to understand databases or an experienced professional looking to enhance your skills, this course is designed to provide a comprehensive introduction to SQL. We’ll cover essential concepts such as querying databases, modifying data, creating and managing tables, and gaining insights through joins and subqueries. By the end of this module, you’ll have a solid grasp of SQL and be equipped to harness its power to efficiently manipulate and retrieve data from databases, a vital skill for anyone involved in data-centric roles.

  • 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

This module provides the skills necessary to work with advanced Excel formulas, tables, filters and graphs and thus be able to process and visualize information.

  • 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

This course provides the skills necessary to process data from various types of sources and aggregate it into a powerful engine for processing and visualizing information. Ideal for those who already know Excel and work daily with it and all its features
advanced, wanting to take the next step and increase your productivity with advanced Reporting through PowerBI

  • Introduction to Power BI
  • Connect to data
  • Connections
  • Basic chart types
  • Grouping
  • Advance chart types
  • Combo chart
  • Filtering
  • Sorting
  • Hierarchy
  • Total and subtotals
  • Calculated fields
  • Custom aggregations
  • Logic statements
  • Dashboards
  • Exporting a dashboard

Python is a versatile and widely-used programming language known for its readability, ease of use, and vast array of applications, from web development and data analysis to artificial intelligence and automation. Over the course, we will delve into Python’s fundamentals, data structures, control flow, functions, and modules, gradually building up your proficiency through hands-on projects and exercises. Our goal is to empower you to create efficient, scalable, and effective solutions using Python, making you proficient in this invaluable language for both personal and professional endeavors.

  • 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

Our Big Data Module, designed to provide you with a rapid and comprehensive introduction to the fundamental principles and tools of big data analytics. In this module, we will explain the complexities of managing, processing, and deriving valuable insights from large volumes of data.

Projects requiring integration of skills and knowledge from extended training periods. The training contains 4 step projects:

  • SQL Project
  • XLS Project
  • PowerBI
  • Python

We believe that the most effective training is through practical work. Thus, the course requires students to use analysis tools and invest in the actual work of the data visualization project. The project covers the consolidation of all the subjects acquired, in terms of knowledge and soft skills.

  1.  

FAQs

Data analytics is the science of collecting and analyzing raw data in order to make conclusions about that information.

A Data Analyst is a person who can skillfully extract this information using data modeling and inform management on what it needs to know for decision-making.

Day-to-day tasks focus on gathering data from a variety of sources according to predefined data sets and variables. Collected data is then cleaned up and validated for accuracy and uniformity. Using statistical tools, Data Analysts then analyze and interpret results to identify trends, patterns, and new opportunities from the data.

Data and predictive analytics are changing everything from medicine and manufacturing, to marketing, HR and education. The future of products and services all around us is being driven by data and the data professionals who know how to wield it. 

Yes! All graduates who have successfully completed the program will receive a Data Analyst certificate.

Thousands of alumni use their course certificate to demonstrate skills to potential employers, along with their LinkedIn networks. Our data programs are well-regarded by many top employers, who contribute to our curriculum and partner with us to train their own teams.

If there are no restrictions, studies take place mainly at our physical center. In case of any travel or gathering restrictions, the program moves seamlessly online – with live interactive sessions with your trainers. Some learning materials – like class recordings and topics for self-study – can be watched on-demand from anywhere. 

Register your interest, take a 1-hour online assessment test, and have a talk with one of our career advisors.

Don’t have a programming background? A 70-hour introductory program is available to close those gaps. Otherwise, all candidates take a computerized assessment to ensure that they have the right personality, as well as the basic math and logic skills, to complete the program and be successful in their future jobs. You might want to check out other programs that are suitable for individuals with no background in programming!

Want to Consult About Your Future Tech Career?

We'd love to help you with any questions!

Thank you.
We'll contact you briefly.