Monthly Archives: July 2022

Profit and Loss Statement Revenues: The money a company makes from the sales of its products and services. Cost of Goods Sold (COGS) or Cost of Sales: These are the direct costs the company incurs to develop the product or … Continue reading →

Optimizing Marketing Funnel Identify what level of the funnel your customer loss is the greatest. If you’re losing many of them in the early stages of awareness, you need to focus on the types of ads you’re creating, or the … Continue reading →

Click Through Rate (CTR) user/customer clicks through an ad we need to calculate both the number of impressions and the number of clicks. Formula: Click Through Rate (CTR) = (Clicks/ Impressions) * 100 Interpretation of CTR If a person clicks through the ad, it … Continue reading →

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 →