Course

Introduction to Data

Learn to apply data & statistics specifically for business! In this course, you’ll go from data novice to spreadsheet wizard, calculating and forecasting key financial metrics, even making detailed projections off real-life financial data from the New York Stock Exchange.
Enroll Now
  • DAYS
  • HRS
  • MIN
  • SEC
  • Estimated Time
    25 hours

  • Enroll by
    September 22, 2021

    Get access to classroom immediately on enrollment

  • Prerequisites
    No Experience Required

What You Will Learn

Syllabus

Introduction to Data

Data literacy is no longer solely expected of analysts & engineers — it’s become a critical skill for anyone who wants to drive decision-making at their company. This practical course is for business professionals looking to add data analysis to their strategy & planning. You’ll dive right into Excel and Google Spreadsheets, manipulating data, calculating key business metrics, and even building financial forecasting models with historical stock-market data.

Learn descriptive and inferential statistics, how to calculate business metrics, and how to build forecasting models in Excel and Google Spreadsheets.

Prerequisite Knowledge

No experience required.

  • Descriptive Statistics

    Learn data types, measures of center, and the basics of mathematical notation, and then progress to common visual methods for quantitative data, measures of spread, and the difference between descriptive and inferential statistics.

  • Spreadsheets: Getting Started

    Learn about the keys steps of the data analysis process and use cell referencing and menu shortcuts.

  • Spreadsheets: Manipulate Data

    Sort and filter data, use text and math functions, split columns and remove duplicates.

  • Spreadsheets: Analyze Data

    Summarize data with aggregation and conditional function and use pivot tables and lookup functions.

  • Spreadsheets: Visualize Data

    Build data visualizations for quantitative and categorical data, create pie, bar, line, scatter, histogram and boxplot charts, and build professional presentations.

  • Metrics

    Become familiar with business metrics used by business analysts in the area of marketing, sales, growth, engagement and financial analysis, calculate and interpret key performance metrics, and calculate metrics and create plots to visualize metrics in Excel.

  • Excel Modelling

    Understand the fundamentals of sales and financial forecasting models, and create forecasting models using advanced lookup and data validation tools (INDEX, MATCH, OFFSET) in Excel.

  • Course Project: Analyze NYSE Data

    In this project, you will work with a New York Stock Exchange (NYSE) dataset that contains fundamental financial data for 500 companies. You will use spreadsheets to analyze and summarize the data using statistics and data visualizations. You will communicate the key findings in a professional manner. You will also design a dashboard that calculates the financial metrics and auto populates the income statement for each company using data validation and advanced lookup tools within Excel. You will then forecast financial metrics within the Income Statement, based on three scenarios with distinct assumptions for a company of your choice from the NYSE dataset.

Icon - Dark upwards trend arrow

$85–$92k
The range of salaries for employees with data skills such as Excel, SQL, and Tableau.

woman-leading-group-meeting

Introducing new Udacity Single Courses

Our students asked and we listened. You can now get the in-demand tech skills you need faster and for less money by enrolling in one of our new, one-month Single Courses. You’ll get the specific job-ready skills you need in as little as four weeks and for a fraction of the cost.

Of course if you are looking for a more robust, in-depth education, you can still enroll in one of our 3-6 month Nanodegree programs.

Both programs are part-time and online, and they both offer 24/7 support, quality Udacity-produced content, courses created with the help of top tech companies, and more. You can always start with a Single Course and upgrade to a full Nanodegree program if you like.

All Our Courses Include

Real-world projects from industry experts

Real-world projects from industry experts

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.
Technical mentor support

Technical mentor support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.
Workspaces

Workspaces to see your code in action

Validate your understanding of concepts learned by checking the output and quality of your code in real-time.
Flexible learning program

Flexible learning program

Tailor a learning plan that fits your busy life. Learn at your own pace and reach your personal goals on the schedule that works best for you.
Course OfferingsFull list of offerings included:
Enrollment Includes:
Class Content
Real-world projects
icon-checkmarkCheckmark
Project reviews
icon-checkmarkCheckmark
Project feedback from experienced reviewers
icon-checkmarkCheckmark
Student Services
Technical mentor support
New
icon-checkmarkCheckmark
Student community
Improved
icon-checkmarkCheckmark
Succeed with Personalized Services
We provide services customized for your needs at every step of your learning journey to ensure your success!
Get timely feedback on your projects
Reviews By the numbers
1,400+ project reviewers
2.7M projects reviewed
88/100 reviewer rating
1.1 hours avg project review turnaround time
Reviewer Services
  • Personalized feedback
  • Unlimited submissions and feedback loops
  • Practical tips and industry best practices
  • Additional suggested resources to improve
Mentors available to answer your questions
Mentors by the numbers
1,400+ technical mentors
0.85 hours median response time
Mentorship Services
  • Support for all your technical questions
  • Questions answered quickly by our team of technical mentors

Introduction to Data

Get Started Today

  • Monthly Access

    Pay as you go


    per

    /

    /

    Enroll Now
    • Maximum flexibility to learn at your own pace.
    • Cancel anytime.
  • Learn

    Descriptive and inferential statistics, how to calculate business metrics, and how to build forecasting models in Excel and Google Spreadsheets.
  • Average Time

    On average, successful students take 25 hours to complete this program.
  • Benefits include

    • Real-world projects from industry experts
    • Technical mentor support

Program Details

  • Do I need to apply? What are the admission criteria?
    No. This Course accepts all applicants regardless of experience and specific background.
  • What are the prerequisites for enrollment?
    No prior experience is required, but it is recommended that students are comfortable with basic computer skills, such as managing files, using third-party online programs, and navigating the Internet through an online browser.
  • How is this course structured?
    The Introduction to Data course is comprised of content and curriculum to support one project. We estimate that students can complete the program in 25 hours.

    The project will be reviewed by the Udacity reviewer network and platform. Feedback will be provided and if you do not pass the project, you will be asked to resubmit the project until it passes.
  • How long is this course?
    Access to this course runs for the length of time specified in the payment card above. If you do not graduate within that time period, you will continue learning with month to month payments. See the Terms of Use and FAQs for other policies regarding the terms of access to our programs.
  • Can I switch my start date? Can I get a refund?
    Please see the Udacity Program Terms of Use and FAQs for policies on enrollment in our programs.
  • What software and versions will I need in this program?
    Students should have access to the Internet and a 64 bit computer. There are no additional software and version requirements to complete this program, all coursework and projects can be completed via Student Workspaces in the Udacity online classroom.

Introduction to Data

Enroll Now