Aleksandr Kosenko - Aleksandr Kosenko Digital

Aleksandr Kosenko Digital

Sign in Subscribe

Aleksandr Kosenko

Product Manager, Data Analyst Student, Lifelong Learner.

Subqueries and Joins in SQL

Data Analitics Study Notes

Subqueries and Joins in SQL

Master SQL with our guide on subqueries and joins! Discover how to efficiently combine data from multiple tables, streamline your queries, and enhance performance. Unlock the power of data retrieval through effective SQL techniques.

Descriptive statistics

Data Analitics Study Notes

Descriptive statistics

Explore the fundamentals of descriptive statistics, including measures of central tendency, dispersion, and position. Understand how these concepts empower data-driven decisions, enhance analytical skills, and reveal insights crucial for effective problem-solving.

The role of simple statistics in data science

Data Analitics Study Notes

The role of simple statistics in data science

A/B testing, descriptive & inferential statistics

Storytelling with Data

Data Analitics Study Notes

Storytelling with Data

* Stories are powerful tools for teaching and sharing knowledge, not just entertainment. * Data analysts are storytellers who use data, visuals, and narratives to inform and persuade. * A data narrative explains the origin and purpose of data, providing context to findings. * Visuals aid in bringing data insights to life and making

Interpreting Data

Data Analitics Study Notes

Interpreting Data

* The final step in the OSEMN Framework is interpreting data analysis results. * Interpretation involves generating insights and telling a story with the data. * This week focuses on how to draw conclusions from analysis and create compelling data stories. * The course will cover approaches to data interpretation and storytelling techniques. * A

Data Analitics Study Notes

Modeling Data

* Modeling is the fourth stage of the OSEMN (Obtain, Scrub, Explore, Model, iNterpret) data analysis cycle. * This phase involves using data to make predictions through mathematical models. * Models can range from simple linear regressions to complex machine learning algorithms. * The primary function of models is to discover hidden patterns in

Data Analitics Study Notes

Scrubbing Data

* Scrubbing data is the second phase of the OSEMN framework, focusing on cleaning and preparing data for analysis. * The scrubbing process transforms raw, dirty data into clean, usable data. * Four main tasks in data scrubbing: * Removing duplicates * Formatting records * Solving for missing values * Checking records for mistakes or wrong values

Data Analitics Study Notes

Obtaining Data

* The OSEMN model is a framework for data analytics projects, consisting of five stages: Obtain, Scrub, Explore, Model, and Interpret. * Obtaining data involves gathering relevant information from various sources, which may require creativity and research. * Scrubbing data is crucial for preparing the dataset, including cleaning and formatting to ensure accuracy

The OSEMN Framework

Data Analitics Study Notes

The OSEMN Framework

* Data analytics involves multiple steps, such as collecting, cleaning, categorizing, analyzing, and interpreting data. * The large volume of data available can make the job of a data analyst overwhelming. * A framework can help data analysts organize their work processes and strategies. * Using a framework ensures accuracy and consistency throughout the

What is Data Analytics?

Data Analitics Study Notes

What is Data Analytics?

the Power of Data * Data Generation: We generate vast amounts of data daily through various interactions with technology. * Value of Data: This data provides valuable insights into behaviors, habits, and preferences. * Increasing Data: The amount of data is growing exponentially due to advancements in technology and connected devices. * Role of

Data caveats & limitations

Data Analitics Study Notes

Data caveats & limitations

Prepare for the Q&A A question-and-answer session, or Q&A, is a valuable opportunity for stakeholders and audience members to ask questions about your findings. They can be challenging because you don’t always know what to expect, require purposeful listening, and it's tough to

Presentation skills and practices

Data Analitics Study Notes Featured

Presentation skills and practices

Proven presentation tips * Effective presentation skills are crucial for data analysts to communicate their findings clearly. * Using a framework helps guide the audience and integrates data seamlessly into the presentation. * Practice and preparation are essential to becoming more comfortable with giving presentations. * Basic tips include deep breathing to manage excitement,

The art and science of presentations

Data Analitics Study Notes Featured

The art and science of presentations

Presenting data effectively is a crucial skill for data analysts Data visualizations and storytelling can enhance your presentations Combining multiple data sources helps in telling a comprehensive story Sharing your findings is as important as the analysis itself

Share data stories

Data Analitics Study Notes

Share data stories

Characters Setting Plot Big reveal Aha moment

Tableau dashboard

Data Analitics Study Notes

Tableau dashboard

Dashboard A tool that organizes information from multiple datasets into one central location for tracking, analysis, and simple visualization through tables, charts and graphs

Data-driven storytelling

Data Analitics Study Notes

Data-driven storytelling

Crafting stories with data is an essential skill in modern data analytics. By transforming raw data into compelling narratives, you can make information more understandable, relatable, and persuasive.

A look at the business model from the product manager's point of view

Product Management Featured

A look at the business model from the product manager's point of view

Originally, this was a post that grew into 16 mini posts. I was always adding something that was missing and the fabric of the text kept growing. Finally, I decided to break everything into pieces, but with convenient navigation in each post. Here it is

CANVAS 13 - Great guide on the business model, from the product manager's point of view

Product Management Featured

CANVAS 13 - Great guide on the business model, from the product manager's point of view

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view You are here ➔ CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation

1 – Customer Problem

Product Management

1 – Customer Problem

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view You are here ➔ 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation

2 – Customer Segments

Product Management

2 – Customer Segments

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem You are here ➔ 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation

3 – Value Propositions

Product Management

3 – Value Propositions

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments You are here ➔ 3 – Value Propositions Value Proposition Formulation

Value Proposition Formulation Map

Product Management

Value Proposition Formulation Map

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions You are here ➔ Value Proposition Formulation

4 – Customer Relationships

Product Management

4 – Customer Relationships

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation Map You are

Product Management

5 – Channels

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation Map 4 – Customer

6 – Revenue Streams

Product Management

6 – Revenue Streams

❮ ❮ ❮ back forward ❯ ❯ ❯ A look at the business model from the product manager's point of view CANVAS 13 - Great guide on the business model, from the product manager's point of view 1 – Customer Problem 2 – Customer Segments 3 – Value Propositions Value Proposition Formulation Map 4 – Customer