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.
What are Excel functions & formulas? In this Jolt, we will understand what they are and become familiar with basic functions in Excel.
Every analyst will tell you that organizing data is an important practice. In this Jolt, we will learn useful concepts such as Organizing, filtering, grouping columns, designing tables, and conditional design.
The VLOOKUP function is one of the most useful functions in Excel, and in this Jolt, we want to make sure that you master its use!
An important part of understanding and explaining data is being able to communicate the conclusions via graphs and proper visualization. In this Jolt, we will learn how to use different graphs, while also learning how to create useful pivot tables for our data.
What is the difference between Excel & Google Spreadsheet? In this Jolt, we will learn about the differences between two of the most popular spreadsheet platforms, and how to analyze information using Google Sheets.
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 course, and put it into use.
can be with spreadsheet
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.
Summary Exercises are used to provide an additional repetition over the learned material, while combining the gained knowledge to a single exercise.
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.
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.
Summary Exercises are used to provide an additional repetition over the learned material, while combining the gained knowledge to a single exercise.
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.
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.
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.
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.
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!
make sure it's on the same level of Analiza
Even when presented visually, data is still data. In this Jolt, we will learn how to visually explore our data to gain insights in a seemingly less traditional way, but one of the most important ones.
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. *
Getting people's attention and making them listen to your message is one of the essential skills in the job world today. In this workshop, we will explore the ‘must-have’ ingredients for mastering your public speaking skill that is relevant in every setting.
TBD
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.
One of the best ways for a company to increase revenue is to decrease churn - the metric that represents customer loss rate. In this Jolt, we will learn how to conduct a Churn Analysis, so we can identify the churn's cause.
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.
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 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.
As analysts, we need to know how to work with other data roles. In this Jolt we will focus on working with a data developer, to create a better future workflow.
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.
Working in the product department is sometimes different than other departments. In this Jolt, we will focus about the product mindset and working as analysts with a product manager.
Usually, you won't be the only analyst in the company. In this Jolt, we will go over best practices when working with other anaylsts in your department.
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.
In this workshop, you learn how to apply the Business Model Canvas to your organizations to decipher your venture’s value proposition. The Business Model Canvas is strategic management and lean startup template for developing new or documenting existing business models. It is a visual chart with elements describing a venture’s value propositions to different customers, customer relations and channels, activities and resources, partnerships, revenue, and cost structures.
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.
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 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 Customer Success is not to fulfill every customer request, but to find solutions to their real problems (even before they realize what they are). Learn how to identify the core problem of customers, define business objectives that meet customer needs, and translate them into measurable Key Performance Indicators (KPIs) 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.
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.
In this workshop, you will learn how to automate manual processes efficiently with Zapier (a tool for automating processes). You will practice defining, planning, and implementing robust automation processes that will save you time & money. At the end of this Jolt, you will gain the tools to turn daunting manual tasks into effortless automated processes.
*You must attend at least 80% of the classes to receive your certificate.
*To earn your certificate, you must successfully complete your final project.