Data Scientist

MS Excel Statistical Functions for Central Tendency

AVERAGE Provides an estimate of the mean or expected value of the data. To use it, supply the range of data you want the average of “=AVERAGE(data range).” For example, if you wanted the average of the observations of the data in cells A1 through A10, you might enter =AVERAGE (A1:A10) into cell A12. MEDIAN …

Data Scientist – Skills you need to develop

Data science, also known as data-driven science, is an interdisciplinary field of scientific methods, processes, and systems to extract knowledge or insights from data in various forms, either structured or unstructured, similar to data mining. A data scientist is a broad term that can refer to a number of types of careers. Generally, a data scientist analyzes data to learn about …

What is Data Mining? – Simple Definition

The amount of raw data stored in corporate databases is exploding. From trillions of point-of-sale transactions and credit card purchases to pixel-by-pixel images of galaxies, databases are now measured in gigabytes and terabytes. (One terabyte = one trillion bytes. A terabyte is equivalent to about 2 million books!) For instance, every day, Wal-Mart uploads 20 …

What is Data Warehouse? – Simple Definition

WHAT IT IS: A data warehouse is a federated repository for all the data that an enterprise’s various business systems collect. The repository may be physical or logical. Data warehousing is an electronic method of organizing information. HOW IT WORKS (EXAMPLE): A data warehouse essentially combines information from several sources into one comprehensive database. For example, in …