Course curriculum

• 1

Introduction

• 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

• Online Analytical Processing in 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
• 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
• 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
• 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 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
• 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
• Website of Tableau
• Which Tableau Platform to Use
• Openning Tableau
• 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 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