TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas]

File Name

Size

01. Financial Statement Basics/05. Bringing It All Together/02. Reading a 10-k filing.webm

59 MB

README.txt

2.2 kB

TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].jpg

207 kB

TeamTreehouse - Introduction to Marketing and Sales Analytics (Track) [Thomas].png

618 kB

01. Financial Statement Basics/Financial Statement Basics.md

5.8 kB

01. Financial Statement Basics/01. Introducing Financial Statements/01. Welcome.webm

22 MB

01. Financial Statement Basics/01. Introducing Financial Statements/02. Accounting Principles.webm

16 MB

01. Financial Statement Basics/01. Introducing Financial Statements/03. The Concept of Recognition.webm

19 MB

01. Financial Statement Basics/02. The Profit & Loss Statement/01. What is the Profit & Loss Statement.webm

11 MB

01. Financial Statement Basics/02. The Profit & Loss Statement/02. Cost of Goods Sold (“COGS”) and Gross Profit.webm

16 MB

01. Financial Statement Basics/02. The Profit & Loss Statement/03. Selling, General & Administrative (“SG&A”) and EBITDA.webm

22 MB

01. Financial Statement Basics/02. The Profit & Loss Statement/04. Depreciation, Amortization and EBIT.webm

29 MB

01. Financial Statement Basics/02. The Profit & Loss Statement/05. Interest, Taxes, Other Gains and Losses, and Net Profit.webm

15 MB

01. Financial Statement Basics/03. The Balance Sheet/01. What is the Balance Sheet.webm

7.9 MB

01. Financial Statement Basics/03. The Balance Sheet/02. Assets and Liabilities.webm

20 MB

01. Financial Statement Basics/03. The Balance Sheet/03. Fixed Assets.webm

23 MB

01. Financial Statement Basics/03. The Balance Sheet/04. Shareholder Equity & Retained Earnings.webm

16 MB

01. Financial Statement Basics/04. The Cash Flow Statement/01. What is the Cash Flow Statement.webm

9.4 MB

01. Financial Statement Basics/04. The Cash Flow Statement/02. Operating Cash Flows.webm

11 MB

01. Financial Statement Basics/04. The Cash Flow Statement/03. Investing and Financing Cash Flows.webm

23 MB

01. Financial Statement Basics/04. The Cash Flow Statement/04. Free Cash Flow and Net Cash Flow.webm

29 MB

01. Financial Statement Basics/05. Bringing It All Together/01. Retrieving Financial Statements.webm

25 MB

Introduction to Marketing and Sales Analytics.md

5.4 kB

01. Financial Statement Basics/05. Bringing It All Together/03. EBITDA vs Net Income.webm

26 MB

01. Financial Statement Basics/05. Bringing It All Together/04. Book Value vs Market Value.webm

49 MB

01. Financial Statement Basics/05. Bringing It All Together/05. How the 3 Financial Statements Relate.webm

22 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/Introduction to Churn and Lifetime Value (LTV) Analysis.md

3.2 kB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/01. Welcome.webm

22 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/02. Recurring Revenue.webm

18 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/03. What is Churn.webm

24 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/04. Gross Churn vs Net Churn.webm

20 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/05. MRR Churn Example Pt. 1.webm

15 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/01. Churn/06. MRR Churn Example Pt. 2.webm

16 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/01. What is Lifetime Value Analysis.webm

20 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/02. The Most Basic LTV Formula.webm

8.3 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/03. Factoring in COGS.webm

22 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/04. Why Does LTV Matter.webm

16 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/05. Forecasting LTV.webm

8.0 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/06. Cohort Reports.webm

20 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/07. Realized LTV.webm

25 MB

02. Introduction to Churn and Lifetime Value (LTV) Analysis/02. LTV/08. Conclusion.webm

7.1 MB

03. Measuring Company Performance with MRR, Churn and Lifetime Values/Measuring Company Performance with MRR, Churn and Lifetime Values.md

1.1 kB

04. Basic Statistics for Data Analysis/Basic Statistics for Data Analysis.md

3.5 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/01. Welcome to Basic Statistics for Data Analysis.webm

10 MB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/02. Line Charts.md

2.1 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/03. Bar Charts vs. Histograms.md

1.5 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/04. Pie Charts.md

1.7 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/05. Scatter Plots.md

1.4 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/06. IQR (Interquartile Range).md

2.5 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/07. Box-and-whisker Plots.md

2.4 kB

04. Basic Statistics for Data Analysis/Welcome to Basic Statistics for Data Analysis/08. Standard Deviation.md

3.4 kB

05. Spreadsheet Basics/Spreadsheet Basics.md

6.9 kB

05. Spreadsheet Basics/01. Introducing Spreadsheets/01. What is a spreadsheet.webm

11 MB

05. Spreadsheet Basics/01. Introducing Spreadsheets/02. Choosing Spreadsheet Software.webm

9.5 MB

05. Spreadsheet Basics/01. Introducing Spreadsheets/03. Basic Spreadsheet Vocabulary.webm

32 MB

05. Spreadsheet Basics/02. Getting Started With Spreadsheets/01. Adding Data to A Spreadsheet.webm

9.3 MB

05. Spreadsheet Basics/02. Getting Started With Spreadsheets/02. Calculating Totals With SUM.webm

16 MB

05. Spreadsheet Basics/02. Getting Started With Spreadsheets/03. Calculating Averages and Median Values.webm

11 MB

05. Spreadsheet Basics/02. Getting Started With Spreadsheets/04. Sorting & Filtering.webm

25 MB

05. Spreadsheet Basics/02. Getting Started With Spreadsheets/05. Cell Referencing.webm

19 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/01. Introducing Functions.webm

14 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/02. The IF Function.webm

13 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/03. The COUNT Function.webm

2.5 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/04. The EDATE Function.webm

4.7 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/05. The SUMIF Function.webm

12 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/06. The CHOOSE Function.webm

6.7 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/07. The ROUNDDOWN & ROUNDUP Functions.webm

4.4 MB

05. Spreadsheet Basics/03. Spreadsheet Functions & Shortcuts/08. Keyboard Shortcuts.webm

22 MB

05. Spreadsheet Basics/04. Spreadsheet Best Practices/01. Spreadsheet Formatting Best Practices.webm

15 MB

05. Spreadsheet Basics/04. Spreadsheet Best Practices/02. Saving Spreadsheet Data.webm

4.7 MB

05. Spreadsheet Basics/04. Spreadsheet Best Practices/03. Input and Output Tabs.webm

15 MB

05. Spreadsheet Basics/04. Spreadsheet Best Practices/04. Spreadsheet Templates.webm

15 MB

05. Spreadsheet Basics/04. Spreadsheet Best Practices/05. Comments and Notes.webm

14 MB

05. Spreadsheet Basics/05. Build a Spreadsheet/01. Finding and Importing Data.webm

22 MB

05. Spreadsheet Basics/05. Build a Spreadsheet/02. Formatting the Spreadsheet.webm

30 MB

05. Spreadsheet Basics/05. Build a Spreadsheet/03. Adding Functions and Formulas.webm

36 MB

05. Spreadsheet Basics/05. Build a Spreadsheet/04. Conclusion.webm

4.8 MB

06. Introducing Microsoft Excel/01. Why Microsoft Excel.webm

4.2 MB

06. Introducing Microsoft Excel/02. Microsoft Excel On Macs.webm

14 MB

06. Introducing Microsoft Excel/03. Microsoft Excel On Windows.webm

17 MB

06. Introducing Microsoft Excel/Introducing Microsoft Excel.md

1.1 kB

07. Data Visualization with Excel/Data Visualization with Excel.md

5.4 kB

07. Data Visualization with Excel/01. Introduction To Data Visualization/01. Overview of Data Visualization.webm

27 MB

07. Data Visualization with Excel/01. Introduction To Data Visualization/02. Creating a Chart in Excel.webm

14 MB

07. Data Visualization with Excel/01. Introduction To Data Visualization/03. Changing the Order of Your Bar Chart.webm

6.2 MB

07. Data Visualization with Excel/01. Introduction To Data Visualization/04. Different Types of Charts in Excel.webm

3.8 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/01. A Column or a Bar.webm

7.1 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/02. Why A Column Instead of Bar.webm

11 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/03. Line Charts.webm

8.8 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/04. Area and Stacked Area Charts.webm

17 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/05. Stacked Charts Continued and 100% Stacked Charts.webm

9.3 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/06. Pie Charts.webm

17 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/07. Scatter Plots.webm

9.1 MB

07. Data Visualization with Excel/02. When To Use What Type of Chart/08. The CORREL Function.webm

7.4 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/01. Chart & Plot Area.webm

13 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/02. Chart Title.webm

2.6 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/03. Axis Labels.webm

4.7 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/04. Data Tables.webm

2.7 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/05. Data Labels.webm

6.8 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/06. Lines.webm

4.5 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/07. Legends.webm

2.5 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/08. Trendlines.webm

3.3 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/09. Chart Design.webm

2.9 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/10. Changing Colors For a Data Series or Point.webm

7.2 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/11. Line Markers.webm

4.5 MB

07. Data Visualization with Excel/03. Chart Formatting and Layout/12. Create A Chart Format Template.webm

7.3 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/01. Practice Total Sales.webm

12 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/02. Solution Total Sales.webm

21 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/03. Practice Sales Details.webm

3.2 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/04. Solution Sales Details.webm

28 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/05. Practice Population Growth.webm

7.0 MB

07. Data Visualization with Excel/04. Practicing Data Visualization in Excel/06. Solution Population Growth.webm

19 MB

08. Intermediate Spreadsheets/01. Welcome and Prerequisites.webm

5.7 MB

08. Intermediate Spreadsheets/02. Lookup Functions.webm

13 MB

08. Intermediate Spreadsheets/03. Conditional Formatting.webm

12 MB

08. Intermediate Spreadsheets/04. Pivot Tables.webm

14 MB

08. Intermediate Spreadsheets/05. Data Validation.webm

20 MB

08. Intermediate Spreadsheets/Intermediate Spreadsheets.md

1.5 kB

09. Intermediate Excel/Intermediate Excel.md

4.4 kB

09. Intermediate Excel/01. LOOKUP Functions/01. Introducing the Course.webm

6.0 MB

09. Intermediate Excel/01. LOOKUP Functions/02. Introducing Lookup Functions.webm

6.3 MB

09. Intermediate Excel/01. LOOKUP Functions/03. Using VLOOKUP to Search in a Column.webm

27 MB

09. Intermediate Excel/01. LOOKUP Functions/04. Using HLOOKUP to Search in a Row.webm

3.6 MB

09. Intermediate Excel/01. LOOKUP Functions/05. LOOKUP Tips and Common Errors.webm

7.6 MB

09. Intermediate Excel/01. LOOKUP Functions/Project Files/LOOKUPS.xlsx

49 kB

09. Intermediate Excel/02. Pivot Tables/01. Introducing Pivot Tables.webm

8.4 MB

09. Intermediate Excel/02. Pivot Tables/02. Building a Pivot Table.webm

12 MB

09. Intermediate Excel/02. Pivot Tables/03. Finishing the Pivot Table.webm

9.9 MB

09. Intermediate Excel/02. Pivot Tables/04. Other Pivot Table Tips and Tricks.webm

13 MB

09. Intermediate Excel/02. Pivot Tables/Project Files/Pivot_Tables.xlsx

67 kB

09. Intermediate Excel/03. Conditional Formatting/01. Introducing Conditional Formatting.webm

24 MB

09. Intermediate Excel/03. Conditional Formatting/02. Getting Fancy with Conditional Formatting.webm

21 MB

09. Intermediate Excel/03. Conditional Formatting/Project Files/Conditional_Formatting.xlsx

12 kB

09. Intermediate Excel/04. Error Checking/01. Why Error Checking is Important.webm

14 MB

09. Intermediate Excel/04. Error Checking/02. Common Errors.webm

14 MB

09. Intermediate Excel/04. Error Checking/03. Prevent Errors Using Data Validation.webm

12 MB

09. Intermediate Excel/04. Error Checking/04. How To Check For Errors.webm

30 MB

09. Intermediate Excel/04. Error Checking/05. Wrapping Up.webm

2.5 MB

09. Intermediate Excel/04. Error Checking/Project Files/Errors.xlsx

27 kB