AI Sciences

What is Business Intelligence

Importance of Business Intelligence

Design of the Course

What to Cover

Who should take this course

Introduction to the Projects

Introduction of the Instructor

Adhoc Analysis in Business Intelligence

Online Analytical Processing in Business Intelligence

Mobile Business Intelligence

Real Time Business Intelligence

Operational Business Intelligence

Open Source Business Intelligence

Embedded Business Intelligence

Collaborative Business Intelligence

Location Business Intelligence

Vendors and Market of Business Intelligence Tools

An Overview of Statistics

Types of Statistics

Descriptive Statistics along with Types of Data

Levels of Measurement used in Statistical Data

Examples of Measurement Levels

Data Visualization using Histogram

Data Correlation using Scatter Plots

Quiz Scatter Plot

Quiz Solution Scatter Plot

An Overview of a Cross Table

Measures of Central Tendency

Quiz Data with Outliers

Quiz Solution Data with Outliers

Correlation, Covariance and Skewness in Data

Spread of Data

Quiz Standard Deviation and Variance

Quiz Solution Standard Deviation and Variance

An Overview of Inferential Statistics

Distribution of Data and Standard Error

Estimators, Estimates and Central Limit Theorem

Quiz Solution to Distribution of Data

Z-Score and T-Score

Quiz Solution What to Select Z-score or T-score

Hypothesis Testing

Significance Levels and Critical Regions

Confidence Interval and Margin of Errors

Quiz Solution to Significance Interval

Dependent Sample Two Mean Test

Independent Sample Two Mean Test

Quiz Which Test to Perform if Population Variance Known

Quiz Answer Which Test to Perform if Population Variance Known

Quiz Which Test to Perform if Population Variance unknown

Quiz Answer Which Test to Perform if Population Variance unknown

Summary Statistics in One Go

Descrptive Statistics in Excel

Quiz Descriptive Statistics

Quiz Solution Descriptive Statistics

Measures of Central Tendency in Excel

Quiz Mean, Median and Mode in Excel

Quiz Solution of Mean, Median and Mode in Excel

Measuring Data Spread using Excel

Correlation in Excel

Quiz Correlation

Quiz Solution Correlation

Data Visualization using Excel

Paired Sample t Test in Excel

Quiz T Test Paired Sample

Quiz Solution T Test-Paired Samples

t Test for Equal and Unequal Variances in Excel

Quiz Two Sample T Test

Quiz Solution Two Sample T Test

Hypothesis Testing using Excel

Confidence Interval in Descriptive Statistics using Data Analysis Tab in Excel

Quiz Z Test

Quiz Solution Z Test

Project Question How to Perform Regression in Excel

Project of Performing Regression in Excel

Introduction What we will learn in Power BI

An Overview of Power BI

Downloading or Installing Power BI Desktop Free

Getting Started with Power BI

One Simple Click to Get Data into Power BI

Working with Query Editor The Kitchen of Power BI

Refreshing Data Sources

Star vs Snowflake Schema

More About Schema

Look Up vs Data Tables

Making Relationships Among Data Table and Look Up Tables

Active vs Inactive Relationships

Setting Cardinality in Relatinships

Cross Filter Direction of Data Model

Final Data Model

Starting with the Measures Explicit and Implicit

Simple DAX to Define a Measure

DAX Quiz

DAX Quiz Solution

Another DAX Practice

Quiz Write Explicit Measures

Quiz Solution Write Explicit Measures

Quiz Create Explicit Measure to Calculate Sum of Sales

Solution Create Explicit Measure to Calculate Sum of Sales

Quiz Implicit or Explicit

Quiz Solution Implicit or Explicit

Quiz Defining Explicit Measure

Quiz Solution Defining Explicit Measure

Combining Multiple Functions Under Single Measure

Quiz Creating Hybrid Measure

Quiz Solution Creating Hybrid Measure

Defining Quick Measure

Definning Measure By Using Existing Measure

Complex Function

Multiple Functions Together

Quiz Put Visual and Add Measure Result

Quiz Solution Put Visual and Add Measure Result

Quiz Adding Fields to the Visual

Quiz Solution Adding Fields to the Visual

Quiz Apply Basic Filtering

Quiz Solution Apply Basic Filtering

Quiz Slice and Dice as Per Month

Quiz Solution Slice and Dice as Per Month

Quiz Applying Sort on the Month Field

Quiz Solution Applying Sort on the Month Field

Defining New Column using Find Function

New Column using if Condition

Quiz Adding New Column

Quiz Solution Adding New Column

Quiz Format the Measure Output

Quiz Solution Format the Measure Output

Time Intelligence in Power BI

Defining Day Date Function

Time Intelligence More Functions

Making Your Own Date Table in Power BI

Making Report in Power BI

Adding Charts in Reports

Publishing Data to Workspace and Dashboard

Career Opportunities with Power BI

An Overview of the Module

What is Tableau

Why Tableau

Features of Tableau

Advantages of Using Tableau

Website of Tableau

Downloading Tableau

Which Tableau Platform to Use

Openning Tableau

Adding Data, Connecting Tables, Adding Fields and Applying Cardinality

Refrential Integrity and Relationships in Different Tables

Data Modelling Using Multiple Fields to Develop Valid Relationship

Union of Multiple Tables

Understanding Data Forms in Sheet View of Tableau

Simplified Bin Chart of Sales

Making Various Charts in Just a Click in Different Colours and Size

Combining Multiple Fiels Under One Axis as Dual Axis

Lollipop Chart

Creating Calculated Field to Find Profit Margin

Quiz Calculated Field

Quiz Solution Calculated Field

Calculation with Condition Writing

Quiz Total Revenue

Quiz Solution Total Revenue

Discrete and Continuous Data in Tableau

Mapping in Tableau

Data Joining

Inner Join

Full Outer Join

Left Join, Right Join and Discussion on Data Modelling

Quiz Creating Bin Field

Quiz Solution Creating Bin Field

Aggregation and Granularity

Another Chart with Parameters

Sales Chart with Adding Filters to Tooltip

Joining vs Blending

Using Pivot Function

Project Quiz Forecasting your Sales

Solution to the Project

Working with Data Interpreter

Adding Sheets to the Dashboard

Quiz Project Designing Dashboard

Solution to the Project Dashboard

Quiz Project Making Story

Solution to the Project Story

Tableau vs Excel

Power BI vs Tableau

Final Video to Sum Up All