Data Analyst

Welcome to our course! In this Jolt, we will talk all about the course's details, learning axes, and platforms that we'll use to learn. This is our first session together - so we are very excited!

What is "Big Data" and why is it so important? In this Jolt, we will learn about basic concepts that are required in order to be a data analyst such as "Data", "Big Data", and structured & unstructured information.

What is the role of a Data Analyst? In this Jolt, we will go over different roles that are data-related, and where Data Analysts fit in the data ecosystem.

In this Introductory Jolt, We will learn about different types of databases (DBs), the types of data that are stored in a DB, tables, and how information is stored within them.

What is Machine Leaning? In this Jolt, we will get a taste of understanding introductory concepts in the field, while understanding how it relates to data and analysis.

As time passes, more and more startups and companies trasition to working on cloud platforms. In this Jolt, we will discuss the popular ones, and how to apply our existing knowledge working with them.

This guided self learning Jolt will give you an introduction to Excel axis.

Functions in Excel are the way to achieve more complicated results. Excel is used daily in an analyst’s life, and is a very common tool for home tasks when applying for a job. This workshop will let you know the most common functions of Excel, including VLOOKUP.

Using advanced Excel requires knowledge of advanced functions, pivot table & graphs. This workshop will introduce you to more advanced functions, pivot tables and graphs.

So we learned all the different practices in Excel, and now what? In this Jolt, we will practice what we learned in Excel throughout the Jolts, and put it into use with Industry level cases.

As we saw before, Excel is a great tool for analysis of different types. In this Jolt, we will explore different use case of real tasks which are given to candidates of data analysis position, and will use Excel / Google Sheet for their analysis.

How does one work with SQL Server Management Studio? In this introductory session, we will go over the basics required to start our SQL journey!

Queries are one of the basic factors in SQL. In this session we will create a strong foundation for our future SQL queries.

Operators and filters are an essential part of SQL, enabling us to specify conditions and filter our data. In this Jolt, we will gain an understanding of how to use them.

Together, scalar and conversion functions allow us to change our value types, and to preform calculations over them. In this Jolt, we will go over the functions, as well as how to use them.

How do I gain insights from a set of values or a group of rows? In this Jolt, we will learn how to use aggregate and analytic functions in order to recieve an insightful value from several.

Except, Union, and Intersect are three operators that allow us to create boolean combinations between queries. In this Jolt, we will how to properly use them.

How do we create a query inside a query, and why should we do it? In this Jolt, we will learn how to properly create and use subqueries.

Summary Exercises are used to provide an additional repetition over the learned material, while combining the gained knowledge to a single exercise.

How does one create an "If X then Y" logic in SQL? Using the case function. In this Jolt we will learn all about it and its uses.

The substring function allows us to extract several characters from a given string, while patindex allows us to find the position of a certain sequence inside a string. In this Jolt, we will learn how to use these string-related functions.

How do we combine values from different tables? In this Jolt we will learn how to do it with the join clause, and the necessary conditions required for its use.

In this industry exercise, we will practice what we learned in SQL axis so far, with industry SQL cases. How do we use SQL to get meaningful insights for our company?

In this Jolt, we will learn two very useful operators - "IN" & "EXISTS", how they can help us, and in which conditions they should be used.

Using lots of joins and subqueries can create long and complex queries, and in order to simplify everything, the "WITH" clause was introduced! In this Jolt, we will learn how to use the "WITH" clause to create temporary data sets.

Summary Exercises are used to provide an additional repetition over the learned material, while combining the gained knowledge to a single exercise.

Learning how to deal with errors are one of the pillars of coding. In this Jolt, we will learn how to deal with errors in SQL.

In this industry exercise, we will practice what we learned in SQL axis so far, with industry SQL cases. How do we use SQL to get meaningful insights for our company?

Tables are one of the most useful forms of organizing data. In this Jolt, we will learn how to create and edit tables, to better our SQL game.

Viewing the execution plan in the SQL Server can provide insights regarding how the SQL Server obtains the data from our queries. In this Jolt, we will learn all about the execution plan, and what we gain from understanding it.

As analysts, we will encounter quite a bit of code written by other analysts. Knowing how to read and understand SQL Queries will help us in our future roles, and that is this Jolts focus.

Window functions calculate across a set of table rows that are related to a certain row. This is comparable to the type of calculation that is done with an aggregate function, but the rows retain their seperate identities. This kind of functions is really common in interviews questions and in home tasks given to candidates, and in this Jolt we will master their use, so you will be prepared for your future interviews.

A final exercise, built to test the knowledge that was gained throughout the SQL axis.

In this workshop you'll learn how to translate data insights into compelling visual stories for other key audiences: Customers, teams with different specialisms, senior stakeholders, journalists, investors, or the wider public. The workshop will give you skills and principles so that by the end, you can apply it on the simplest PowerPoint chart, or on more complex interactive visualizations. The workshop is a mix of a formal presentation, group discussion, and practical exercises. You'll leave this workshop having planned, designed, and refined your own visualization.

Tableau is an interactive data visualization software, a powerful BI (Business Intelligence) tool, and an industry standard for visualization and BI. In the first half of out Tableau workshop, we will learn all about he software, and the required basics to work with it. Dashboards allow analysts to both present, and to view a graphical representation of our data and important metrics and KPIs (Key Performance Indicators). In this Jolt, we will learn all about dashboards, and how useful they will be for us.

In the second part of our Tableau workshop, we dive in and focus on advanced Tableau techniques and dashboards. By the end of this workshop, you will be able to both use Tableau for your professional needs, and to create stunning dashboards!

In the third part of our Tableau workshop, we dive in and focus on advanced Tableau techniques and dashboards. By the end of this workshop, you will be able to both use Tableau for your professional needs, and to create stunning dashboards!

Tableau is a leading data visualization tool used for data analysis and business intelligence. In this industry exercise, we will practice our previous knowladge of Tableau with the eyes of industry experts. How do we use Tableau to get meaningful insights for our company?

Your business ideas are worth nothing if you're unable to convey them effectively. Whether you're presenting at a big conference or your team's daily standup, your goal is to make people remember what you say and do what you want them to do. Learn a four-step framework for designing powerful presentations: 1. Formulating a clear and concise message 2. Turning your message into a compelling story 3. Organizing content into a structured slide-deck 4. Designing slides that strengthen your message * You'll be using Google Slides throughout the Jolt to practice the framework. *

Data is a resource, and its product is a conclusion or an insight. In this Jolt, we will learn how to draw conclusions and insights from raw data, and how to convey them in writing.

As a Data Analyst, you will encounter new tables occasionally. In this Jolt, you will learn how to explore, investigate, and analyze tables.

In order to derive correct conclusions and insights, we need to understand how to conduct a proper research. In this Jolt, we will go over the research process and understand how to conduct it correctly.

In order to solve a problem, we need to find its origin. In this practical Jolt, we will learn how to conduct a Root Cause Analysis (RCA) to discover the root cause of our problem, so we can solve it.

In this practical Jolt, we will learn about Cohort Analysis, an analytical technique that divides data into categorical groups with common characteristics before our analysis.

Funnels are a very useful way to look at steps user go through in their customer journey. In this Jolt, we will learn how to conduct a Funnel Analysis, and to thus understand these steps.

Customer churn, also known as customer attrition, is when a customer essentially stops being a customer. Businesses are willing to track the churn of their customers to try and limit their churn rate in the future, and create better processes such that less customers will stop using their products. In this Jolt, we will understand the importance of churn analysis and the analyst role in preventing churn, we will get to know the churn data set and will dive into industry common use cases and edge cases.

Funnel analysis is a method used to analyze the sequence of events leading up to a point of conversion. Events within the funnel take place inside products, mobile apps, websites, or other digital touchpoints, and funnel analysis lets product and marketing managers understand user behaviors throughout the customer journey. In this Jolt we will understand what funnels & sub-funnels are, learn how to conduct funnel analysis and practice funnel analysis at industry level.

Cohort analysis is an analysis method which focuses on groups of users, tracks their actions and allows the analyst to ask more targeted questions that will make informed product decisions. One of the most common uses of cohort analysis is for analyzing customer retention. In this Jolt, we will get to know the special data structure and visualization of this analysis, and will practice how to create a full industry standard cohort analysis from A to Z.

Different business models require different analytical approaches. In this Jolt, we will learn about the different analyses that are prominent in B2B & B2C companies.

In this Jolt, we will learn about the most common mistakes analysts make in research, and how to avoid them. By avoiding these mistakes, we can be more confident in our analysis conclusions.

Why should a Data Analyst study statistics? In this Jolt, we will cover this, and learn basic and useful concepts in statistics.

Anomaly detection, aka outlier analysis, is the identification of data that deviates from the dataset normal behavior. These can indicate that alerting is needed - from detecting changes in our users behavior to fraud detection in the fintech industry. In this Jolt we will meet the basic concepts of anomaly detection, will learn where to use it, and will practice methods like visualization, time series, and distributions for the detection itself.

In this Jolt, we will learn what sampling is, and how to perform proper data sampling. Moreover, we will talk about the basics of how data is distributed while understanding concepts such as "Distribution" and "Histograms".

In order to derive correct conclusions and insights, we need to understand how to conduct proper research. In this Jolt, we will go over the research process and understand how to conduct it correctly with a real industry study case.

In this Jolt, we will learn about the distribution and variance of data, while understanding how the standard deviation can be used to characterize the data.

Everyone talks about "correlations", but what are they? In this Jolt, we will learn about what a correlation is, and about relationships between different variables.

In this Jolt, we will practice all the basic statistical concepts that were learned and are useful for the data-analysis practice.

It doesn't matter if you work in the product department or in marketing - A/B testing is the most used method of comparing two versions. In this Jolt, we will go over both frequentist and bayesian A/B testing methodologies.

A/B testing is a technique that involves comparing two versions to see which performs better. These variations, known as A and B, are presented randomly to groups of statistically independent users. A statistical analysis of the results can determine which version, A or B, performed better, according to certain predefined indicators such as conversion rate or the funnel of the users in the product. In this Jolt, we will learn what is A/B Testing, when to use it and when not to use A/B Testing, why is this a useful tool, how to define the right test and steps to carry out the test at industry level.

Product management might seem like an open minefield. As Product Managers, you have to identify problems with the product, design innovative solutions, lead the building process, and maintain it—all in minimum time with maximum effect. In this Jolt, you'll learn the process of creating MVPs (Market-Ready-Products). You will practice battle-tested tools, myth-busting insights, and tailored advice to get you started. At the end of this Jolt, you will gain a better and more methodological approach to business, data, and UX.

As analysts, we need to know how to work with other data roles and departments. In this Jolt we will focus on working with a data developer, to create a better future workflow and maintain the data pipeline. We will focus on working with a Product Manager in a product mindset, and how to cooperate with other analysts in your team.

What do we mean when we say Tech or Startup? What is the organizational structure of startups? What is the difference between B2C and B2B? And what verticals will I find this industry? This is the first step in planning your way into tech.

A good map can be crucial when taking your first steps in the tech industry. In this workshop you will get familiar with the types of organizations in the Tech Space - and the common roles & responsibilities you can find. We will dive deeper into the different aspects of the most common roles and what you need to prepare to get your foot in the door.

Running a Startup or a new product means, before everything, uncertainty. In a restless world that moves fast and changes all the time, a new approach is required to build a successful, adaptive business. In this Jolt, you will explore the methodology described in the bestseller that started a movement - 'The Lean Startup' - to see how it can make any venture, initiative, and product successful and viable over time. You will learn how to discover what customers want using MVP and validated learning, validate a company's business model during all the product life cycle, and invest your efforts only in products that people will love and use.

How do you actually measure the progress of a startup? Between the "I have an idea" phase and the dreamy exit, there are so many numbers, Excel sheets, and metrics that can be both highly important and very distracting. As your business grows, you will realize precisely how many things you need to measure regularly for you to meet your goals. And new words and acronyms will keep on coming: KPI, LTV, Cohort Retention, Vanity Metrics, Unit Economics, Business Model, and more. At the end of this workshop, you will be familiar with the technical-accounting concepts that drive the company's strategy.

In this Jolt, we will go over the two departments that are mainly responsible for the customer lifecycle, while understanding their different contribution to the company.

A SWOT Analysis is a simple, yet powerful tool for developing business strategy. It forces you to look at your business' strengths, weaknesses, opportunities, and threats - and come up with a solid plan for growing your business. In this Jolt, you will learn what a SWOT Analysis is and how to use it effectively when making strategic decisions. You'll also discuss when is most appropriate to use this model, and how to set the optimal conditions for it to be effective. Use this model to leverage your strengths and opportunities while minimizing your weaknesses and threats in the market.

In this workshop, you'll learn how to free yourself from preconceptions around what marketing channels “work” for your business and identify the best method to attract as many customers as possible. To do this, we'll look at 19 marketing channels and use a tool to help narrow these down to the magic one (or two) channels that will be your growth levers. * Based on the bestseller 'Traction: How Any Startup Can Achieve Explosive Customer Growth' *

Paid advertising is a fundamental channel to attract customers and create traffic. The main challenge is that it is also an expensive channel. That is why businesses must design their ads efficiently.

Churn (when customers cease to use a product or service) is a major barrier to scaling a business. In this class, you will discover a model by which Customer Success Managers can identify customers at risk, predict future challenges, and reduce churn.

The goal of a Data Analyst is not to create informative reports regarding the data of the company, but to find solutions to the company real problems (even before they realize what they are). A good analyst Learn how to identify the core problem of customers, define business objectives that meet customer needs, translate them into measurable Key Performance Indicators (KPIs) and analyze the data accordingly to ensure ongoing success.

In this workshop, you will walk through the different use cases of LinkedIn, break down the elements of the member profile, and gain best practices to help you achieve your goals on the platform. At the end of this workshop, you will be able to tell your professional story in a compelling manner and tailor it to your career path.

Everything is a project. The challenge begins when having to manage a project as you balance cost, schedule, quality, and content. In this workshop, you'll learn to organize projects right from the start, so that their execution will drive successful results.

We all hate CVs, but they are a necessary evil… A snapshot of our professional path to date to help us get to where we want to be, but HOW to create it and WHAT are the important sections? Recruiters spend not more than 30 seconds per resume! You have to stand out and make the right first impression. In this workshop you'll learn the recruiter's perspective and how to maximize your CV accordingly.

The recruiting processes in Hi-Tech companies are harder than ever. Most of the time, many candidates apply to a specific position, and you need to stand out. It starts with preparing a professional & appealing CV that suits the role you are applying to and later on gaining the knowledge and right skills to pass interviews. In this Jolt, you'll discover the structure of the recruiting process and the importance of understanding the role you are applying for. You'll learn how to present yourself as the most suitable candidate and practice how to answer tough character questions. You'll also get a deep understanding of the interviewer's perspective.

Put your interview skills into practice and get professional feedback from a recruiting expert.

Everything is a project. The question is, how well you execute it. In this workshop, you will learn the best practices for managing projects using the collaborative platform of Monday.com, you will practice solving real PM problems and visualize it on your boards. At the end of this workshop, you will be able to leverage collaboration platforms to manage any project and advance the values you wish to see in your team's projects.

We use email and instant messaging (IM) non-stop. Yet, we scarcely stop and think if we are doing it right. Lack of clarity, information overload, and poor structure decrease our chances of getting the response we need and increase the chances of our message getting lost in someone's inbox. This Workshop will cover: When to use email, IM, or a different communication channel, Timing, Structure & length, Tone and Call-to-action, Throughout the Workshop, you'll challenge your email and IM writing skills and apply techniques to help get your message across.

Storytelling is the foundation of marketing campaigns, investor pitches, team building, and basically everything. When people make a decision, they, intentionally or unintentionally, search for a story. The challenge begins when you don't know how to explain what your team or business does, which results in others getting what you want. In this Jolt, you'll learn three techniques for turning a message into a compelling story. You'll apply each technique, craft stories that inspire action, and provide feedback.

What are we going to learn while using Python? What are the main uses of Python in data analysis? What can and can't be done with this tool? All these questions and more will be answered on this Jolt of Introduction to Computation and Programming.

The Jupyter Notebook App is a server-client application that allows editing and running notebook documents via a web browser. In this Jolt, we will learn how to use it on your local desktop, and how can we use it in our daily use.

What are we going to learn while using Python? What are the main uses of Python in data analysis? What can and can't be done with this tool? All these questions and more will be answered on this Jolt of Introduction to Computation and Programming. The Jupyter Notebook App is a server-client application that allows editing and running notebook documents via a web browser. In this Jolt, we will learn how to use it on your local desktop, and how can we use it in our daily use.

Computers do not deal with characters, they deal with numbers. Even though you may see characters on your screen, internally it is stored and manipulated as a combination of numbers. This conversion of character to a number is called encoding, and in Python these characters are called strings. In this Jolt we will learn how can we use those strings in our programming.

In Python, Casting is a process in which we convert a literal of one type to another, in order to the operation required to be performed by users. In this Jolt, we will see the various technique for this conversion.

Summary Exercises are used to provide an additional repetition of the learned material while combining the gained knowledge to a single exercise.

The world is often more complicated than using operators only for your program. Frequently, a program needs to skip over some statements, execute a series of statements repetitively, or choose between alternate sets of statements to execute. This is where conditional statements come in. In this Jolt we will learn how to use conditional statements as "If", "Else", and "Else if".

Sometimes, our program needs to run several time until it stops, for example while counting something, or while trying to achieve a certain numeric goal. In these cases, loops are used to create a more readable piece of code and to avoid code duplication. In this Jolt we will get to know those extremally useful loops.

Summary Exercises are used to provide an additional repetition of the learned material while combining the gained knowledge to a single exercise.

Lists, Tuples, Sets, and Dictionaries are Python data structures that are used to store and organize the data efficiently. In this Jolt, we will learn how and when to use each one of them.

A function is a block of related statements designed to perform a computational, logical, or evaluative task. Python Lambda Functions are anonymous function, meaning that the function runs without a name. This is a way of executing a function in a shorter and more compact piece of code. Python Functions are very easy to write, and in this Jolt we will learn how, and how to write those Lambda name-less functions and when we should use them.

Summary Exercises are used to provide an additional repetition of the learned material while combining the gained knowledge to a single exercise.

PIP is a package manager for Python packages, which contains all the files you need for a module. In this Jolt we will learn how to use PIP package manager.

Python is often used for manipulating data in another file, for example a given data set. For this purpose, one should need to operate some basic file methods through Pytrhon - read the file, write in the file, create a new file and delete one. This Jolt will explain how to do so.

Pandas is a powerful open source data analysis and manipulation tool built with Python programing languege. It is one of the most common libreries nowadays to analyze data, and this Jolt will give you an into to this tool.

A Pandas DataFrame is a 2 dimensional data structure, like a 2 dimensional array, or a table with rows and columns.In this Jolt we will learn how to use it in the Pandas syntax.

A Pandas DataFrame is a 2 dimensional data structure, like a 2 dimensional array, or a table with rows and columns. In this Jolt we will learn how to analyze them.

Summary Exercises are used to provide an additional repetition of the learned material while combining the gained knowledge to a single exercise.

Summary Exercises are used to provide an additional repetition of the learned material while combining the gained knowledge to a single exercise.