Tag Archives: Business Analytics Nanodegree Udacity

Aggregation no data / different from zero or space a datatype that specifies where no data exists in SQL. They are often ignored in our aggregation functions, which you will get a first look at in the next concept using COUNT. … Continue reading →

LEFT and RIGHT JOINs INNER JOIN – only returns rows that appear in both tables. I learned here that the result table will only show data of those rows that appear in all tables, those that don’t appear in all … Continue reading →

ERD Reminder Entry-Relationship Diagrams (ERD) a common way to view data in a database. It is also a key element to understanding how we can pull data from multiple tables. Tables & Columns In the Parch & Posey database there … Continue reading →

Relational Database tables within a database relate to one another they contain identifiers to make the content easily combined Why Would We Want to Split Data Into Separate Tables? Different contents of the tables, though they relate to another Speed … Continue reading →

Exercise: Bottom-Up Financial Forecasting View Spreadsheet Reference for formatting Project 2

Projected Bookings per Sales Person SAMPLE FILE Sample Walk-through First, we start with the number of opportunities we expect the salesperson to close annually. Average price per unit – the average price per unit or product for manufacturing. Average units per … Continue reading →

Modeling refers to using certain inputs and using those inputs to predict how a business metric will perform. The time duration of your forecast will depend on the type of business and the business metric: Startups – usually forecast 6-12 … Continue reading →

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 →