Business Analytics Skills you will learn

  • Excel analytics functions
  • Excel conditional formatting
  • Pivot tables and slicers
  • Scenario manager tool
  • Solver tool
  • Goal seek tool
  • ANOVA
  • Hypothesis testing
  • Power BI

Who should learn Business Analytics with Excel

  • IT Developers and Testers
  • Data Analysts
  • Junior Data Scientists
  • Analytics Professionals
  • BI and Reporting Professionals
  • Project Managers
  • Students

What you will learn in Business Analytics with Excel

  • Business Analytics with Excel

    • Lesson 00 - Introduction

      05:27
      • 0.001 Course Introduction
        05:27
    • Lesson 01 - Introduction to Business Analytics

      09:52
      • 1.001 Introduction
        02:15
      • 1.002 What Is in It for Me
        00:10
      • 1.003 Types of Analytics
        02:18
      • 1.004 Areas of Analytics
        04:06
      • Knowledge Check
      • 1.006 Key Takeaways
        00:52
      • 1.007 Conclusion
        00:11
    • Lesson 02 - Formatting Conditional Formatting and Important Fuctions

      38:29
      • 2.001 Introduction
        02:12
      • 2.002 What Is in It for Me
        00:21
      • 2.003 Custom Formatting Introduction
        00:55
      • 2.004 Custom Formatting Example
        03:24
      • 2.005 Conditional Formatting Introduction
        00:44
      • 2.006 Conditional Formatting Example1
        01:47
      • 2.007 Conditional Formatting Example2
        02:43
      • 2.008 Conditional Formatting Example3
        01:37
      • 2.009 Logical Functions
        04:00
      • 2.010 Lookup and Reference Functions
        00:28
      • 2.011 VLOOKUP Function
        02:14
      • 2.012 HLOOKUP Function
        01:19
      • 2.013 MATCH Function
        03:13
      • 2.014 INDEX and OFFSET Function
        03:50
      • 2.015 Statistical Function
        00:24
      • 2.016 SUMIFS Function
        01:27
      • 2.017 COUNTIFS Function
        01:13
      • 2.018 PERCENTILE and QUARTILE
        01:59
      • 2.019 STDEV, MEDIAN and RANK Function
        03:02
      • 2.020 Exercise Intro
        00:35
      • 2.21 Exercise
      • Knowledge Check
      • 2.023 Key Takeaways
        00:53
      • 2.024 Conclusion
        00:09
    • Lesson 03 - Analyzing Data with Pivot Tables

      19:32
      • 3.001 Introduction
        01:47
      • 3.002 What Is in It for Me
        00:22
      • 3.003 Pivot Table Introduction
        01:03
      • 3.004 Concept Video of Creating a Pivot Table
        02:47
      • 3.005 Grouping in Pivot Table Introduction
        00:24
      • 3.006 Grouping in Pivot Table Example 1
        01:42
      • 3.007 Grouping in Pivot Table Example 2
        01:57
      • 3.008 Custom Calculation
        01:14
      • 3.009 Calculated Field and Calculated Item
        00:25
      • 3.010 Calculated Field Example
        01:22
      • 3.011 Calculated Item Example
        02:52
      • 3.012 Slicer Intro
        00:35
      • 3.013 Creating a Slicer
        01:22
      • 3.014 Exercise Intro
        00:58
      • 3.15 Exercise
      • Knowledge Check
      • 3.017 Key Takeaways
        00:35
      • 3.018 Conclusion
        00:07
    • Lesson 04 - Dashboarding

      32:07
      • 4.001 Introduction
        01:18
      • 4.002 What Is in It for Me
        00:18
      • 4.003 What is a Dashboard
        00:45
      • 4.004 Principles of Great Dashboard Design
        02:16
      • 4.005 How to Create Chart in Excel
        02:26
      • 4.006 Chart Formatting
        01:45
      • 4.007 Thermometer Chart
        03:32
      • 4.008 Pareto Chart
        02:26
      • 4.009 Form Controls in Excel
        01:08
      • 4.010 Interactive Dashboard with Form Controls
        04:13
      • 4.011 Chart with Checkbox
        05:48
      • 4.012 Interactive Chart
        04:37
      • 4.013 Exercise Intro
        00:55
      • 4.14 Exercise1
      • 4.15 Exercise2
      • Knowledge Check
      • 4.017 Key Takeaways
        00:34
      • 4.018 Conclusion
        00:06
    • Lesson 05 - Business Analytics With Excel

      25:48
      • 5.001 Introduction
        02:12
      • 5.002 What Is in It for Me
        00:24
      • 5.003 Concept Video Histogram
        05:18
      • 5.004 Concept Video Solver Addin
        05:00
      • 5.005 Concept Video Goal Seek
        02:57
      • 5.006 Concept Video Scenario Manager
        04:16
      • 5.007 Concept Video Data Table
        02:03
      • 5.008 Concept Video Descriptive Statistics
        01:58
      • 5.009 Exercise Intro
        00:52
      • 5.10 Exercise
      • Knowledge Check
      • 5.012 Key Takeaways
        00:39
      • 5.013 Conclusion
        00:09
    • Lesson 06 - Data Analysis Using Statistics

      31:57
      • 6.001 Introduction
        01:51
      • 6.002 What Is in It for Me
        00:21
      • 6.003 Moving Average
        02:50
      • 6.004 Hypothesis Testing
        04:20
      • 6.005 ANOVA
        02:47
      • 6.006 Covariance
        01:56
      • 6.007 Correlation
        03:38
      • 6.008 Regression
        05:15
      • 6.009 Normal Distribution
        06:49
      • 6.010 Exercise1 Intro
        00:34
      • 6.11 Exercise 1
      • 6.012 Exercise2 Intro
        00:17
      • 6.13 Exercise 2
      • 6.014 Exercise3 Intro
        00:19
      • 6.15 Exercise 3
      • Knowledge Check
      • 6.017 Key Takeaways
        00:52
      • 6.018 Conclusion
        00:08
    • Lesson 07 - Power BI

      14:01
      • 7.001 Introduction
        01:17
      • 7.002 What Is in It for Me
        00:18
      • 7.003 Power Pivot
        04:16
      • 7.004 Power View
        02:36
      • 7.005 Power Query
        02:45
      • 7.006 Power Map
        02:06
      • Knowledge Check
      • 7.008 Key Takeaways
        00:32
      • 7.009 Conclusion
        00:11

Course Advisors

  • Ronald van Loon

    Ronald van Loon

    Top 10 Big Data and Data Science Influencer, Director - Adversitement

    Named by Onalytica as one of the three most influential people in Big Data, Ronald is also an author of a number of leading Big Data and Data Science websites, including Datafloq, Data Science Central, and The Guardian. He also regularly speaks at renowned events.

prevNext

Why you should learn Business Analytics

26.98% CAGR by 2025

For the business intelligence market

2.72 million job openings

For business analysts as per IBM research

Career Opportunities

FAQs

  • What are the prerequisites to learn the business analytics basics program?

    Professionals taking this business analytics fundamentals program only need to have an analytical mindset and familiarity with MS Excel.

  • What will you learn about business analytics?

    In this course, you will learn about business analytics basics. Aspiring business analysts are expected to be well-versed in SMART requirements, elicitation techniques, project reviews, as well as core BA skills. You will also develop an understanding of business analytics tools like SQL, Python and R, and statistical software.

  • How do beginners learn business analytics fundamentals?

    Business analytics is a challenging domain and should only be started by professionals with real interest in this domain. We offer various resource articles and YouTube videos to give an overview of business analytics to beginners. Then it becomes easy to comprehend the concepts covered in this business analytics basics program.

  • Why learn business analytics?

    Business analytics is an indispensable tool in today's digital world. With enormous volumes of data being generated, the need for professionals who can interpret it and generate actionable insights is on the rise.

    Investing in business analytics helps enterprises make informed decisions, and generate profitability and operational efficiency. While forward-thinking enterprises add business analysts to their workforce, now is the time to learn business analytics to open up many exciting job opportunities. Refer to this video for more details. 

  • What will I learn in the business analytics basics program?

    The business analytics basics you will learn as a part of this free program include:

    • Excel analytics functions
    • Excel conditional formatting
    • Pivot tables and slicers
    • Scenario manager tool
    • Solver tool
    • Goal seek tool
    • ANOVA
    • Hypothesis testing
    • Power BI

  • What are the top skills required for a career in business analytics?

    Below are the tops skills required for a career in Business Analytics:

    • Technical skills like SQL, and statistical software like SPSS, SAS, Sage, Mathematica, and Excel
    • Excellent communication and facilitation skills
    • Analytical thinking and problem solving skills
    • Organizational skills
    • Stakeholder analysis
    • Costs benefit analysis and processes modeling
    • An understanding of networks and databases 

  • How long does it take to learn business analytics?

    Depending on the educational background and prior knowledge of the field, the time taken to learn business analytics varies from person to person. The 3 hours of video lessons covered in this business analytics foundations program can give you that perfect start in this subject.

  • What should I learn first in the business analytics basics program?

    Learners usually begin with the types of analytics and the sectors where analytics can be effectively used in a business analytics basics training program.

  • Is business analytics easy to learn?

    If you have a passion for data, statistics, and an innate curiosity for research, you can easily pick up the business analytics basics course.  


     

  • What are the basics in a business analytics fundamentals program?

    Business analytics basics include data collection, data mining, sequence identification, text mining, forecasting, predictive analytics, optimization, and data visualization.

  • What is business analytics used for?

    Business analytics is used to drive practical, data-driven business decisions in an organization. It assists enterprises plan for the future, create new strategies, and avoid pitfalls based on actionable insights derived from data. 

  • Can I complete this business analytics fundamentals in 90 days?

    Yes. If you follow the schedule of the learning videos and adhere to the study plan accordingly, you can complete the course in 90 days.

  • Will I get a certificate after completing the business analytics fundamentals program?

    You will not receive a course completion certificate upon completing this free Business Analytics with Excel program. However, you can upgrade and enroll in the paid version of the course to earn your certificate. 

  • What are my next best learning options after completing this business analytics foundations program?

    While this business analytics basics program gives you a suitable start, you should learn more about the subject by taking Data Analyst Master’s Program or Post Graduate Program in Data Analytics.

  • What are the career opportunities in business analytics?

    Career opportunities in business analytics include:

    • Market research analyst
    • Process analyst
    • Data scientist
    • Management analyst
    • Business consultant

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.