Introduction to Marketing and Sales Analytics
Learn the most important data to track as a marketing or sales manager, and how data drives the bottom line. Follow a guided curriculum that will walk you through the tools and concepts of measuring business performance.
Start with "Financial Statement Basics" to give you a strong understanding of business finance, like how to read a profit and loss (P&L) statement, balance sheets, and more. Then, get an understanding of how to measure performance for a recurring SaaS (Software-as-a-Service) or subscription company. With "Spreadsheet Basics" and a series of courses related to Microsoft Excel, you'll learn how to operate the most important tool used in the organization and presentation of business finance.
More and more companies are relying on their marketing, sales, and revenue teams to have strong command of how their work drives the bottom line. Start your path to a lucrative career in marketing, sales, or other revenue roles with this Track.
-
An entry-level salary for the technologies covered in this track is about $71,000 / yr on average.
-
Some companies that use these technologies regularly include: Apple, Amazon, Cisco, Verizon, Microsoft, American Express, IBM, HP, Uber
Ready to start learning?
Treehouse offers a 7 day free trial for new students. Get access to 1000s of hours of content. Learn to code, land your dream job.
Start Your Free Trial-
- 1
- 2
- 3
- 4
- 5
Financial Statement Basics
Understanding how to read the story that financial statements tell is a really useful skill and an important part of career development. In this course, we’ll give a basic overview of the 3 main financial statements: the Profit and Loss Statement, the Balance Sheet, and the Cash Flow Statement. We’ll teach what they show you, why it matters, and give you a bunch of practice problems to help retain that knowledge. After completing this course, you will be able to read, understand, and use financial statements and build on that knowledge as you continue to learn about them.
-
- 1
- 2
Introduction to Churn and Lifetime Value (LTV) Analysis
This introduction to Churn and Lifetime Value ("LTV") analysis course is designed for absolute beginners to give them exposure to the common business metrics of Churn and LTV. In the course we learn about recurring revenue, churn, LTV, why they matter, and navigate some of the nuances of the metrics.
-
24 minWorkshop
Measuring Company Performance with MRR, Churn and Lifetime Values
Keeping track of and understanding your company's revenue is an essential task. It is very hard to evaluate what factors are affecting your revenue stream by looking at your bank account. In this workshop, Pasan walks you through different metrics you can use to determine the relationships between your business activities and your revenue stream. By monitoring metrics such as MRR, Churn and Lifetime Value, you can react to business conditions faster and run your company more efficiently.
Viewed -
- 1
Basic Statistics for Data Analysis
Basic statistics concepts learned through traditional schools may have been forgotten or not utilized for a long time. This course is to remind students how to calculate basic statistics, solidify understanding of the terminology, and determine which graphs might be most useful in displaying data.
-
- 1
- 2
- 3
- 4
- 5
Spreadsheet Basics
A spreadsheet is an electronic document that arranges data in a table by using columns and rows. Among other things, spreadsheets let you store, manipulate, share and analyze data. They're used in business to help make complicated decisions like where to open a new restaurant location, where to build a wind farm, or where to expand a business' marketing efforts. Spreadsheets aren't just for business use either. A household expense spreadsheet can help you determine when you will be able to afford a new car or take your next trip. In this course, you'll learn the basics of spreadsheets including the parts of a spreadsheet, spreadsheet vocabulary, how to import data, how to make complex calculations, how to reference data in different cells, and how to use spreadsheet functions. You'll also learn best practices for formatting spreadsheets, protecting your data, and more, all using Google Sheets, which is free and very similar to Excel. When you're done you'll have built an entire spreadsheet complete with data, complex functions and formulas and colorful and meaningful formatting.
-
14 minWorkshop
Introducing Microsoft Excel
Take a quick tour of this popular spreadsheet software.
Viewed -
- 1
- 2
- 3
- 4
Data Visualization with Excel
This overview of Data Visualization in Excel is designed for absolute beginners, but can also benefit people who have already been using Excel to create charts. You will learn about the fundamentals of data visualization, how create types of charts in Excel, and tips on how to get the most of the charts you make.
-
26 minWorkshop
Intermediate Spreadsheets
Are you ready to learn more about working with spreadsheets? This workshop will explore concepts such as conditional formatting, lookup functions, pivot tables, and error checking using Google Sheets. Expand your toolset as a data analyst and take your spreadsheet game to the next level!
Viewed -
- 1
- 2
- 3
- 4
Intermediate Excel
Learn how to perform intermediate level functions in Microsoft Excel. In this course, you will learn how to use LOOKUP functions, build and modify pivot tables, use conditional formatting, find and replace data, and check for errors. Learning these tools will help you bring data to life and allow you to use Excel in a more meaningful way.
-
Track Completion
This course includes:
- Financial Statement Basics 85 min
- Introduction to Churn and Lifetime Value (LTV) Analysis 59 min
- Measuring Company Performance with MRR, Churn and Lifetime Values 24 min
- Basic Statistics for Data Analysis 22 min
- Spreadsheet Basics 2 hours
- Introducing Microsoft Excel 14 min
- Data Visualization with Excel 90 min
- Intermediate Spreadsheets 26 min
- Intermediate Excel 60 min