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.
Introduction to Data Analytics for Business
Course
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.
Estimated time
1 month
Enroll by
June 7, 2023
Get access to classroom immediately on enrollment
Skills acquired
Basic Spreadsheet Use, Business KPIs, Basic Descriptive Statistics
What You Will Learn
Introduction to Data Analytics for Business
1 month to completeData 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.
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.
All Our Courses Include
Real-time support
On demand help. Receive instant help with your learning directly in the classroom. Stay on track and get unstuck.
Workspaces
Validate your understanding of concepts learned by checking the output and quality of your code in real-time.
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 offerings
Class content
- Real-world projects
- Project reviews
- Project feedback from experienced reviewers
Student services
- Student community
- Real-time support
Succeed with personalized services.
We provide services customized for your needs at every step of your learning journey to ensure your success.
- Experienced Project Reviewers
- Real-Time Support
Get timely feedback on your projects.
- Personalized feedback
- Unlimited submissions and feedback loops
- Practical tips and industry best practices
- Additional suggested resources to improve
1,400+ project reviewers
2.7M projects reviewed
88/100 reviewer rating
1.1 hours avg project review turnaround time
Learn with the best.
Learn with the best.
Dana Sheahan
Content DeveloperDana is an electrical engineer with a Masters in Computer Science from Georgia Tech. Her work experience includes software development for embedded systems in the Automotive Group at Motorola, where she was awarded a patent for an onboard operating system.
Josh Bernhard
Data Scientist at Nerd WalletJosh has been sharing his passion for data for nearly a decade at all levels of university, and as Lead Data Science Instructor at Galvanize. He's used data science for work ranging from cancer research to process automation.
Ruchi Bhanot
InstructorRuchi is a data scientist with over a decade of experience in research and industry. She received her PhD from University of Illinois at Urbana-Champaign. She has taught at the University level and designs online learning content within the ed-tech industry.
Introduction to Data Analytics for Business
Get started today
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 1 month to complete this program.
Benefits include
- Real-world projects from industry experts
- Real-time 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 Analytics for Business course is comprised of content and curriculum to support one project. We estimate that students can complete the program in 1 month.
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.