Tag Archives: Business Analytics Nanodegree Udacity

Business Metrics KPI (Key Performance Indicator) – how they measure their success on each of their key business objectives. Each business has its own set of KPIs. Which KPI to use? The decision regarding which KPI a business analyst should … Continue reading →

Data Visualization Pie Chart – used to illustrate proportionality.  Pivot table Using the pivot table we created earlier with some careful selection, we want to highlight the position categories in the top row and the totals are in the bottom … Continue reading →

=FIND and =LEFT FIND and LEFT can be used to extract text. FIND can be given a substring and a cell to return the position in a string where the substring was found. LEFT can then be used to extract a certain number of characters from a … Continue reading →

Spreadsheets 1: Getting Started Range – A group of cells selected or addressed together. It is defined by the cells in the upper left and lower right corners of the range. Relative Addressing – cell locations are relative to the … Continue reading →

Notation and Random Variables capital letters – random variables lowercase letters with subscripts – individual instances Notations Notes for Spreadsheet Range: same with: Testing my theory… Shape and Outliers Suggested Reading from my first project’s feedback: What are headings and … Continue reading →

Summation We use Sigma symbol to represent a summation. Instead of saying: We can write: Measures of Spread Five Number Summary – gives values for calculating the range and interquartile range. Minimum – the smallest number in the dataset. Q1 … Continue reading →

Descriptive Statistics Data Defined as distinct pieces of information and it can come in many forms. Used to understand and improve things. Data Types Quantitative – data takes on numeric values that allow us to perform mathematical operations (like the … Continue reading →