Course curriculum

  • 1

    Introduction

    • Introduction
  • 2

    Lesson 1 : Introduction to Business Analytics

    • 1.1 Introduction

    • 1.2 What is in it for me

    • 1.3 Types of Analytics

    • 1.4 Areas of Analytics

    • 1.5 Quiz

    • 1.6 Key Takeaways

    • 1.7 Conclusion
  • 3

    Lesson 2 : Formatting Conditional Formatting and Important Functions

    • 2.1 Introduction

    • 2.2 What is in it for me

    • 2.3 Custom Formatting Introduction

    • 2.4 Custom Formatting Example

    • 2.5 Conditional Formatting Introduction

    • 2.6 Conditional Formatting Example1

    • 2.7 Conditional Formatting Example2

    • 2.8 Conditional Formatting Example3

    • 2.9 Logical Functions

    • 2.10 Lookup and Reference Functions

    • 2.11 Vlookup Functions

    • 2.12 Hlookup Functions

    • 2.13 Match Functions

    • 2.14 Index and offset Function

    • 2.15 Statistical Function

    • 2.16 Sum-ifs Function

    • 2.17 Count-ifs Function

    • 2.18 Percentile and Quartile

    • 2.19 Stdev, Median and Rank Function

    • 2.20 Quiz

    • 2.21 Key Takeaways

    • 2.22 Conclusion
  • 4

    Lesson 3: Analyzing data with pivot Tables

    • 3.1 Introduction

    • 3.2 What is in it for me

    • 3.3 Pivot Table Introduction

    • 3.4 Concept Video of Creating a Pivot Table

    • 3.5 Grouping in Pivot Table introduction

    • 3.6 Grouping in Pivot Table Example1

    • 3.7 Grouping in Pivot Table Example2

    • 3.8 Custom Calculation

    • 3.9 Calculated Field and Calculated item

    • 3.10 Calculated Field Example

    • 3.11 Calculated Item Example

    • 3.12 Slicer Intro

    • 3.13 Creating a Slicer

    • 3.14 Quiz

    • 3.15 Key Takeaways

    • 3.16 Conclusion
  • 5

    Lesson 4: Dash Boarding

    • 4.1 Introduction

    • 4.2 What is in it for me

    • 4.3 What is Dashboard

    • 4.4 Principle of Great Dashboard Design

    • 4.5 How to create chart in excel

    • 4.6 Chart Formatting

    • 4.7 Thermometer Chart

    • 4.8 Pareto chart

    • 4.9 Form Controls in Excel

    • 4.10 Interactive Dashboard with Form Controls

    • 4.11 Chart with Checkbox

    • 4.12 Interactive Chart

    • 4.13 Quiz

    • 4.14 Key Takeaways

    • 4.16 Conclusion
  • 6

    Lesson 5

    • 5.1 Introduction

    • 5.2 What is in it for me?

    • 5.3 Concept Video Histogram

    • 5.4 Concept Video Solver Addin

    • 5.5 Concept Video Goal Seek

    • 5.6 Concept Video Scenario manager

    • 5.7 Concept Video Data Table

    • 5.8 Concept Video Descriptive Statistics

    • 5.9 Quiz

    • 5.10 Key Takeaways

    • 5.11 Conclusion
  • 7

    Lesson 6: Data Analysis using Statistics

    • 6.1 Introduction

    • 6.2 What is in it for me

    • 6.3 Moving Average

    • 6.4 Hypothesis Testing

    • 6.5 Anova

    • 6.6 Covariance

    • 6.7 Correlation

    • 6.8 Regression

    • 6.9 Normal Distribution

    • 6.10 Quiz

    • 6.11 Key Takeaways

    • 6.12 Conclusion
  • 8

    Lesson 7: Power BI

    • 7.1 Introduction

    • 7.2 What is in it for me?

    • 7.3 Power Pivot

    • 7.4 Power View

    • 7.5 Power Query

    • 7.6 Power Map

    • 7.7 Quiz

    • 7.8 Key Takeaways

    • 7.9 Conclusion