Study notes from data analysis training on Google, IBM, Meta and Yandex educational programs.
Data Analitics Study Notes
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
Data Analitics Study Notes
Characters Setting Plot Big reveal Aha moment
Data Analitics Study Notes
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 Analitics Study Notes
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.
Data Analitics Study Notes
Guidelines and pro tips Refer to the table below for recommended guidelines and style checks for headlines, subtitles, labels, and annotations in your data visualizations. Think of these guidelines as guardrails to prevent your visualizations from becoming too crowded or busy. This can confuse or distract the audience with unnecessary
Data Analitics Study Notes
Introduction to Data Visualization and Design Principles
Data Analitics Study Notes
© Google This text outlines the purpose, examples, and limitations of six data validation types. The first five are linked to the data itself: type, range, constraint, consistency, and structure. The sixth type pertains to application code validation that accepts user input. As a junior data analyst, you may not conduct
Data Analitics Study Notes
* As a data analyst, familiar tools and processes are frequently used, but learning new ones is essential for growth. * SQL can significantly improve efficiency when pulling data and conducting analysis. * Spreadsheets, conditional formulas, the SUMPRODUCT function, and pivot tables are useful tools for performing calculations in data analysis. * Pivot tables
Data Analitics Study Notes
WarehouseWarehouse.csv484 Bytesdownload-circleOrdersOrders.csv352 KBdownload-circle HAVING function Allows you to add a filter to your query instead of the underlying table that can only be used with aggregate functions CASE function Returns records with your conditions by allowing you to include if/then statements in your query Aliasing When you
Data Analitics Study Notes
Open BigQuery and create a free account there, upload bigquery-public-data and select new_york_citibike. Scenario Review the following scenario. Then complete the step-by-step instructions. You work for an organization that is responsible for the safety, efficiency, and maintenance of transportation systems in your city. You have been asked to
Data Analitics Study Notes
Common JOINs * INNER JOIN: a function that returns records with matching values in both tables * LEFT JOIN: a function that returns all the records from the left table (first mentioned) and only the matching records from the right table (second mentioned) * RIGHT JOIN: a function that returns all records from
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'