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