Microsoft Excel is a crucial tool for data analysis as it offers various functions and features to manage, organize, and analyze large data sets efficiently. It allows for the creation of charts and graphs, calculation of statistical measures, and manipulation of data with pivot tables, making it a versatile tool for data analysis and decision making. Below are links to my excel dashboards
Comparing the costs of products in different markets using Excel involves collecting data on the prices of products across multiple markets, then organizing and analyzing the data in Excel to determine which market offers the best value for the products of interest. This can be done by creating a table in Excel with the product names and their corresponding prices in each mart. The data can then be organized using pivot tables, and charts such as bar charts or line charts can be created to visualize the comparison. To make an informed decision, various Excel functions, such as MIN, MAX, AVERAGE, and SUM, can be used to calculate the average, minimum, and maximum prices, and determine the mart with the most favorable prices for the products.
The Maven Analytics Air Passenger Challenge was a data analytics competition focused on analyzing air passenger behavior. Participants were provided with a dataset of flight information, including departure and arrival times, passenger information, and flight prices, and were asked to develop insights and predictions about air passenger behavior. The challenge aimed to identify trends in air travel, such as the most popular routes, the impact of pricing on passenger behavior, and the factors that influence passenger satisfaction.
An Excel safety test for entry-level workers typically assesses the worker's knowledge and understanding of basic safety principles and procedures in a work environment.The purpose of the test is to ensure that entry-level workers have a basic understanding of safety principles, Financial skills and company philosophy.