Data Analitics Study Notes
Data aggregation The process of gathering data from multiple sources in order to combine it into a single summarized collection * Puzzle pieces = data * Organization = aggregation * Pile of pieces = summary * Putting the pieces together = gaining insights The aggregation process helps to identify trends, make comparisons, and gain insights that wouldn'
Data Analitics Study Notes
VLOOKUP core concepts Spreadsheet functions can be used to quickly find information and perform calculations using specific values. VLOOKUP, or Vertical Lookup, is one such function that vertically searches for a certain value in a column to return a corresponding piece of information. In this reading, you’ll examine the
Data Analitics Study Notes
Review * Practices of EDA * PACE workflow * Ethics of working with data * Data visualizations Exploratory data analysis (EDA) The process of investigating, organizing, and analyzing datasets and summarizing their main characteristics, often employing data wrangling and visualization methods. EDA is an important first step in understanding any new dataset or question.
Portfolio process
At the beginning there are sc emails from managers with a request. Then my preparation for the PACE strategy document. Then questions from the laboratory and my answers to them. Then the lines of code that were necessary to get answers to the questions. And at the end, a summary
Data Analitics Study Notes
Check and change data type Check your data for inconsistent units of measurement to prevent problems during data analysis. Convert temperatures from Fahrenheit to Celsius Use the CONVERT function to change units of measurement. Convert function formula as =CONVERT(CELL, from Fahrenheit to Celsius. Enter "F", "C&
Data Analitics Study Notes
The analysis process Analysis – The process used to make sense of the data collected The goal of analysis is to identify trends and relationships within data so you can accurately answer the question you're asking The 4 phases of analysis 1. Organize data 2. Format and adjust data
Data Analitics Study Notes
Documentation The process of tracking changes, additions, deletions, and errors involved in your data-cleaning effort * Recover data-cleaning errors * Inform other users of changes * Determine quality of data A changelog, a file containing a chronologically ordered list of modifications made to a project, is typically utilized to track these changes. 1.
Data Analitics Study Notes
Verify and report results 1. Verification of data is crucial to ensure the data cleaning process has been executed correctly and the data is accurate and reliable. 2. Verification allows for the identification and rectification of errors before beginning analysis, ensuring the insights gained can be trusted for decision-making. 3.
Product Management
The companies that operate mainly offline focus on increasing the number of transactions, where the exchange of value occurs between the business and the customer. For a product manager, this type of service can be called a "transaction game." Typical representatives of these companies are Mercadona, Amazon, Shein,
Product Management
In an era where thousands of meaningless applications are created and many similar businesses are opened, it's worth considering the value you bring and want to create. Let's analyze together how to formulate a strong brand manifesto: your unique business card and your strength in the
Product Management
Why should not only product managers and leaders, but everyone else, know the productivity game? "The productivity game" is not just a trendy buzzword or a way to make money by creating apps; it's a fundamental element for success. A study published in the Journal of
Product Management
In the modern world, where the flow of information seems infinite, attention has become not only a scarce resource but also the primary currency of the digital economy. Products and services, from social networks to streaming platforms, compete for a share of this valuable asset. This is especially important for