July 2, 2025
Data Analysis and visualization BML
Learning Outcomes You can explain the fundamental concepts of data, including data types, data structures, and the importance of data quality, and you can apply these concepts in the context of both Excel and R. You can import data from various sources (such as CSV, TXT, Excel files) into both Excel and R, and you are able to select the appropriate methods and functions for different data formats and structures. You can clean and prepare data for analysis in both Excel and R by applying techniques for identifying and handling missing values, outliers, inconsistencies, and duplicates. You can apply and interpret various data analysis functions in both Excel and R, including determining minimum and maximum values, calculating percentiles, selecting specific data based on criteria, applying conditional formatting to visually identify patterns, and sorting data to gain insights. You can create effective data visualizations in both Excel and R (such as bar charts, line charts, pie charts, and box plots) to communicate patterns, trends, and relationships in data, and you can customize the visualizations for a clear and purpose-driven presentation. Duration: 18 lessons (5EC).