Course curriculum

  • 1

    Introduction

    • 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
  • 2

    02 BI Applications and Tools

    • 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
  • 3

    03 An overview of Statistics for Business Intelligence Needs and Requirements

    • 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
  • 4

    04 Statistical Practices Using Excel

    • 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
  • 5

    05 Power BI

    • 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
  • 6

    06 Tableau

    • 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
  • 7

    07 Project

    • Starting the Project Adding Slicer
    • Adding Cards with Various Fields
    • Applying Various Filters
    • Formatting Visuals and Adding Chart
    • Adding Charts to Dashboard
    • Adding More Charts to Dashboard
    • Final Dashboard
    • Project Customer Analysis
    • Importing Data
    • Revenue Per State
    • Revenue Per Month
    • Revenue Per Age
    • Quantity Discount Correlation
    • Revenue Per Region
    • Revenue Per Category
    • Dashboard
  • 8

    08 Career Development

    • Career Growth in Business Intelligence
    • OLTP and OLAP
    • Your Grip on BI Tool
    • Data Mart and Data Warehouse
    • BI Developer
    • Universe in Business Analytics
    • Dashboard and SAS BI
    • Agile Software Developement and BI Projects
    • Benchmarks
    • Granularity, BI Elements and BI Reports
    • RAGGED Hierracrchy and SSBI
    • Building Blocks in Power BI and Concept of INVEST
    • BRD and SRS
    • Business Modelling and Personas
    • General Questions
    • Open Ended Experience Based Questions
    • BI Roles and Annual Salaries