We may earn an affiliate commission when you visit our partners.
Course image

This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives you the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:

Read more

This course features interactive videos to help you understand both the analytical concepts and the software. This course contains a capstone project, in which you will apply the concepts taught using a separate data source; this realistic project gives you the practice and confidence necessary to connect, explore, and analyze data sources into the future.
This course is also part of a certificate:

Data Analytics and Visualization Certificate

What you'll learn

In this course, you will learn the basics of business analytics using Excel. You'll start by learning all about business analytics, including the importance of the role of obtaining crucial information for the organization. Then, you will begin working on a dataset in Excel, and learn essential tasks such as sorting and filtering the data to learn more about the business. Finally, learn how to analyze both categorical and numeric data: for categorical data, learn how to aggregate data using Excel's Pivot Table feature; for numeric data, learn the basics of analyzing distributions using statistics and common visualizations such as histograms and boxplots. By the end of the course, you will have hands-on practice in preparing data for analysis and thoroughly analyzing a dataset using descriptive analytic techniques.

Three deals to help you save

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores advanced business analytics techniques for categorical and numeric data analysis
Develops essential skills for data preparation and exploration using Excel
Provides a capstone project for hands-on practice in applying the concepts taught
Suitable for beginners seeking to understand the basics of business analytics
Teaches essential tasks in Excel for data analysis, such as sorting, filtering, and aggregation
Emphasizes the importance of data analysis for decision-making in organizations

Save this course

Save Business Intelligence and Data Analytics to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Business Intelligence and Data Analytics with these activities:
Excel Tutorial 1
Build a strong foundation in Excel by following a guided tutorial that introduces the interface and essential features.
Browse courses on Excel Basics
Show steps
  • Explore the Excel interface and become familiar with its components.
  • Learn basic Excel functions and formulas.
Study Group
Enhance your understanding by discussing course concepts and working through problems with your peers.
Show steps
  • Join or form a study group with other students in the course.
  • Meet regularly to discuss course material, ask questions, and share perspectives.
Excel Drill 1
Solidify your understanding of Excel's basic data manipulation techniques through practice.
Show steps
  • Sort a given dataset by a specific column.
  • Filter a given dataset based on specific criteria.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Excel Tutorial 2
Enhance your data manipulation skills by following a guided tutorial that covers advanced techniques for modifying and transforming data.
Browse courses on Data Manipulation
Show steps
  • Learn how to use Excel's data manipulation tools, such as VLOOKUP and HLOOKUP.
  • Practice transforming data using Excel's built-in functions and tools.
Excel Drill 2
Enhance your data analysis skills by practicing the creation and utilization of Pivot Tables.
Browse courses on Pivot Tables
Show steps
  • Create a Pivot Table from a given dataset.
  • Summarize data using Pivot Table functions.
Excel Drill 3
Develop your ability to analyze numeric data and create meaningful visualizations.
Browse courses on Descriptive Statistics
Show steps
  • Calculate basic descriptive statistics for a given dataset.
  • Create histograms and boxplots to visualize data distributions.
Excel Tutorial 3
Expand your data analysis and visualization capabilities by following a guided tutorial that covers advanced techniques.
Show steps
  • Learn how to use Excel's advanced data analysis tools, such as Power Query and Power Pivot.
  • Practice creating interactive dashboards and visualizations using Excel.
Excel Project 1
Apply your Excel skills by completing a project that involves data analysis, visualization, and interpretation.
Browse courses on Data Analysis
Show steps
  • Identify a real-world dataset that you can analyze.
  • Clean and prepare the dataset for analysis.
  • Perform data analysis and identify key insights.
  • Create data visualizations to communicate your findings.
  • Write a report summarizing your analysis and insights.

Career center

Learners who complete Business Intelligence and Data Analytics will develop knowledge and skills that may be useful to these careers:
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to analyze financial data. They use their findings to help businesses make investment decisions. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Quantitative Analysts. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Market Researcher
Market Researchers collect and analyze data to understand consumer behavior. They use their findings to help businesses develop and market products and services. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Market Researchers. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Business Analyst
Business Analysts design, implement, and manage information systems. They gather and analyze business requirements to define system specifications. They use their knowledge of business processes and information technology to bridge the gap between the business and technical teams. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in business intelligence and data analytics, which are essential skills for Business Analysts. It would also help learners develop strong analytical and problem-solving skills, skills which are commonly needed in the role of a Business Analyst
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to solve business problems. They use their findings to help businesses improve their efficiency and productivity. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Operations Research Analysts. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Statistician
Statisticians collect, analyze, and interpret data. They use their findings to help businesses make informed decisions. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Statisticians. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Data Architect
Data Architects design and implement data management solutions. They use their knowledge of data architecture to ensure that data is managed efficiently and effectively. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Data Architects.
Data Scientist
Data Scientists use their knowledge of statistics, machine learning, and data mining to extract insights from data. They use these insights to help businesses make informed decisions. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Data Scientists. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Data Analyst
Data Analysts collect, clean, and analyze data to identify trends and patterns. They use their findings to help businesses make informed decisions. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Data Analysts. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Database Administrator
Database Administrators manage and maintain databases. They use their knowledge of database administration to ensure that databases are accessible and usable by businesses. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Database Administrators.
Risk Analyst
Risk Analysts identify and assess risks to businesses. They use their findings to help businesses develop and implement risk management strategies. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Risk Analysts. Additionally, the course's capstone project would give learners hands-on experience in applying data analysis techniques to a real-world business problem.
Data Engineer
Data Engineers design and build the infrastructure that stores and processes data. They use their knowledge of data engineering to ensure that data is accessible and usable by businesses. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Data Engineers.
Computer Programmer
Computer Programmers write and maintain computer programs. They use their knowledge of computer programming to ensure that computer programs are accurate and efficient. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Computer Programmers.
Software Engineer
Software Engineers design, develop, and maintain software applications. They use their knowledge of software engineering to ensure that software applications are reliable and efficient. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Software Engineers.
Systems Analyst
Systems Analysts design and implement computer systems. They use their knowledge of systems analysis to ensure that computer systems are efficient and effective. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Systems Analysts.
Management Consultant
Management Consultants help businesses improve their performance. They use their knowledge of business management to identify and solve business problems. This course would be particularly helpful for those who wish to enter this field because it provides a strong foundation in data analysis techniques. It would also help learners develop strong analytical and problem-solving skills, which are essential for Management Consultants.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Business Intelligence and Data Analytics.
Provides a practical introduction to data visualization. It covers a wide range of topics, from data visualization principles to data visualization tools. It valuable resource for anyone who wants to learn how to create effective data visualizations.
Provides a comprehensive overview of data mining. It covers a wide range of topics, from data mining concepts to data mining techniques. It valuable resource for anyone who wants to learn more about data mining.
Provides a practical introduction to machine learning for business. It covers a wide range of topics, from machine learning concepts to machine learning applications. It valuable resource for anyone who wants to learn more about machine learning for business.
Provides a practical introduction to data science for business. It covers a wide range of topics, from data science concepts to data science applications. It valuable resource for anyone who wants to learn more about data science for business.
Provides a practical introduction to data analytics. It covers a wide range of topics, from data analytics concepts to data analytics applications. It valuable resource for anyone who wants to learn more about data analytics.
Practical introduction to Power BI. It covers a wide range of topics, from Power BI basics to Power BI data analysis and visualization. It valuable resource for anyone who wants to learn how to use Power BI.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Business Intelligence and Data Analytics.
Data Visualization and Dashboards with Excel and Cognos
Most relevant
Business Intelligence and Data Analytics
Most relevant
Data Visualization and Building Dashboards with Excel and...
Assessment for Data Analysis and Visualization Foundations
Business Analytics with Excel: Elementary to Advanced
Microsoft Excel VBA and Macros
Marketing Analytics: Forecasting Models with Excel
Predictive Modeling and Analytics
Python in Excel 2023 Masterclass for Data Science
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser