General

Introduction to Data Analysis 

Damilola Ajayi Written by Damilola Ajayi · 1 min read >

The data analysis class introduces us to the wonderful world of Data Analytics and the various tools we have at our disposal. The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In the data analysis course, we will learn how to perform data analysis using Excel’s most popular features. We look forward to learning how to create pivot tables from a range with rows and columns in Excel. We hope to see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

The beauty of the course is that we don’t need any previous knowledge of Excel to take this course and we are welcome to use any supported version of Excel you have installed in our computer for most of the class activities.

All the knowledge we are expected to gain would work towards offering us more control and confidence in our data. We will be able to apply our new-found skills in both decision making and problem solving at work and in our everyday lives.

One of the first subtopics being taught in the Data Analytics class is probability. For centuries, humans lived with the “uncertainties” of everyday life, unaware of probability theory and how it might be applied to the solution of simple problems of daily living or used to study the laws of nature.

It was not until the dawn of the scientific method with its emphasis on observation and experimentation that people began to think about the role probability might play in areas of life that once seemed ruled by blind chance.

In the current world however, probability theory is the basis of statistics and game theory, and has been immensely useful to anyone engaged in business, the social and physical sciences, and many other areas of endeavor.

The data analytics class so far has demonstrated that the study of probability can be fun, challenging, and relevant for both our daily life and to modern scientific thought. The course outline promises to introduce us to the concept of possibilities, including combinations and permutations, probabilities, expectations, events, rules of probability, conditional probabilities and probability distributions amongst others.

The class at the onset appears to be a challenging but rewarding journey for everyone willing and able to fully participate in the class activities. We are ready to fasten our seat belt and enjoy the ride.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: