Course curriculum

  • 1

    Power BI Financial Data Analysis using Power BI 2023

    • Introduction: Module Introduction
    • Introduction: Instructor
    • Introduction: AI Sciences
    • Introduction: Course Outline
    • Introduction: Case Study
    • Power BI Desktop: Module Introduction
    • Power BI Desktop: Power BI Introduction
    • Power BI Desktop: Advantages
    • Power BI Desktop: Excel vs PowerBI
    • Power BI Desktop: Installation
    • Power BI Desktop: Settings
    • Power BI Desktop: Interface
    • Power BI Desktop: Workflow
    • Power BI Desktop: Resources and Ribbon
    • Power BI Desktop: Report View Tabs
    • Analyzing Sales: Introduction
    • Analyzing Sales: Understanding Data
    • Analyzing Sales: Data in Power BI
    • Analyzing Sales: Date Format
    • Analyzing Sales: Sales Calculation
    • Analyzing Sales: Formatting
    • Analyzing Sales: Yearly, Quarterly and Monthly Analysis
    • Analyzing Sales: Visualizing With Charts
    • Analyzing Sales: Country Representation With Slicers
    • Preparing and Analyzing P&L: Module Introduction
    • Preparing and Analyzing P&L: Profit Loss Statement
    • Preparing and Analyzing P&L: Gross Profit
    • Preparing and Analyzing P&L: Operating Profit
    • Preparing and Analyzing P&L: Net Progit, EBITDA and PBIT
    • Preparing and Analyzing P&L: Visualising Gross and Net Profit
    • Preparing and Analyzing P&L: Analysis and Adding Slicers
  • 2

    Business Intelligence with PowerBI & Tableau Complete Course

    • Introduction: What is Business Intelligence
    • Introduction: Importance of Business Intelligence
    • Introduction: Design of the Course
    • Introduction: What to Cover
    • Introduction: Who should take this course
    • Introduction: Introduction to the Projects
    • Introduction: Introduction of the Instructor
    • BI Applications and Tools: Adhoc Analysis in Business Intelligence
    • BI Applications and Tools: Online Analytical Processing in Business Intelligence
    • BI Applications and Tools: Mobile Business Intelligence
    • BI Applications and Tools: Real Time Business Intelligence
    • BI Applications and Tools: Operational Business Intelligence
    • BI Applications and Tools: Open Source Business Intelligence
    • BI Applications and Tools: Embedded Business Intelligence
    • BI Applications and Tools: Collaborative Business Intelligence
    • BI Applications and Tools: Location Business Intelligence
    • BI Applications and Tools: Vendors and Market of Business Intelligence Tools
    • An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of Statistics
    • An overview of Statistics for Business Intelligence Needs and Requirements: Types of Statistics
    • An overview of Statistics for Business Intelligence Needs and Requirements: Descriptive Statistics along with Types of Data
    • An overview of Statistics for Business Intelligence Needs and Requirements: Levels of Measurement used in Statistical Data
    • An overview of Statistics for Business Intelligence Needs and Requirements: Examples of Measurement Levels
    • An overview of Statistics for Business Intelligence Needs and Requirements: Data Visualization using Histogram
    • An overview of Statistics for Business Intelligence Needs and Requirements: Data Correlation using Scatter Plots
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Scatter Plot
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Scatter Plot
    • An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of a Cross Table
    • An overview of Statistics for Business Intelligence Needs and Requirements: Measures of Central Tendency
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Data with Outliers
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Data with Outliers
    • An overview of Statistics for Business Intelligence Needs and Requirements: Correlation, Covariance and Skewness in Data
    • An overview of Statistics for Business Intelligence Needs and Requirements: Spread of Data
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Standard Deviation and Variance
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution Standard Deviation and Variance
    • An overview of Statistics for Business Intelligence Needs and Requirements: An Overview of Inferential Statistics
    • An overview of Statistics for Business Intelligence Needs and Requirements: Distribution of Data and Standard Error
    • An overview of Statistics for Business Intelligence Needs and Requirements: Estimators, Estimates and Central Limit Theorem
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution to Distribution of Data
    • An overview of Statistics for Business Intelligence Needs and Requirements: Z-Score and T-Score
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution What to Select Z-score or T-score
    • An overview of Statistics for Business Intelligence Needs and Requirements: Hypothesis Testing
    • An overview of Statistics for Business Intelligence Needs and Requirements: Significance Levels and Critical Regions
    • An overview of Statistics for Business Intelligence Needs and Requirements: Confidence Interval and Margin of Errors
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Solution to Significance Interval
    • An overview of Statistics for Business Intelligence Needs and Requirements: Dependent Sample Two Mean Test
    • An overview of Statistics for Business Intelligence Needs and Requirements: Independent Sample Two Mean Test
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Which Test to Perform if Population Variance Known
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Answer Which Test to Perform if Population Variance Known
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Which Test to Perform if Population Variance unknown
    • An overview of Statistics for Business Intelligence Needs and Requirements: Quiz Answer Which Test to Perform if Population Variance unknown
    • An overview of Statistics for Business Intelligence Needs and Requirements: Summary Statistics in One Go
    • Statistical Practices Using Excel: Descrptive Statistics in Excel
    • Statistical Practices Using Excel: Quiz Descriptive Statistics
    • Statistical Practices Using Excel: Quiz Solution Descriptive Statistics
    • Statistical Practices Using Excel: Measures of Central Tendency in Excel
    • Statistical Practices Using Excel: Quiz Mean, Median and Mode in Excel
    • Statistical Practices Using Excel: Quiz Solution of Mean, Median and Mode in Excel
    • Statistical Practices Using Excel: Measuring Data Spread using Excel
    • Statistical Practices Using Excel: Correlation in Excel
    • Statistical Practices Using Excel: Quiz Correlation
    • Statistical Practices Using Excel: Quiz Solution Correlation
    • Statistical Practices Using Excel: Data Visualization using Excel
    • Statistical Practices Using Excel: Paired Sample t Test in Excel
    • Statistical Practices Using Excel: Quiz T Test Paired Sample
    • Statistical Practices Using Excel: Quiz Solution T Test-Paired Samples
    • Statistical Practices Using Excel: t Test for Equal and Unequal Variances in Excel
    • Statistical Practices Using Excel: Quiz Two Sample T Test
    • Statistical Practices Using Excel: Quiz Solution Two Sample T Test
    • Statistical Practices Using Excel: Hypothesis Testing using Excel
    • Statistical Practices Using Excel: Confidence Interval in Descriptive Statistics using Data Analysis Tab in Excel
    • Statistical Practices Using Excel: Quiz Z Test
    • Statistical Practices Using Excel: Quiz Solution Z Test
    • Statistical Practices Using Excel: Project Question How to Perform Regression in Excel
    • Statistical Practices Using Excel: Project of Performing Regression in Excel
    • Power BI: Introduction What we will learn in Power BI
    • Power BI: An Overview of Power BI
    • Power BI: Downloading or Installing Power BI Desktop Free
    • Power BI: Getting Started with Power BI
    • Power BI: One Simple Click to Get Data into Power BI
    • Power BI: Working with Query Editor The Kitchen of Power BI
    • Power BI: Refreshing Data Sources
    • Power BI: Star vs Snowflake Schema
    • Power BI: More About Schema
    • Power BI: Look Up vs Data Tables
    • Power BI: Making Relationships Among Data Table and Look Up Tables
    • Power BI: Active vs Inactive Relationships
    • Power BI: Setting Cardinality in Relatinships
    • Power BI: Cross Filter Direction of Data Model
    • Power BI: Definning Measure By Using Existing Measure
    • Power BI: Final Data Model
    • Power BI: Starting with the Measures Explicit and Implicit
    • Power BI: Simple DAX to Define a Measure
    • Power BI: DAX Quiz
    • Power BI: DAX Quiz Solution
    • Power BI: Another DAX Practice
    • Power BI: Quiz Write Explicit Measures
    • Power BI: Quiz Solution Write Explicit Measures
    • Power BI: Quiz Create Explicit Measure to Calculate Sum of Sales
    • Power BI: Solution Create Explicit Measure to Calculate Sum of Sales
    • Power BI: Quiz Implicit or Explicit
    • Power BI: Quiz Solution Implicit or Explicit
    • Power BI: Quiz Defining Explicit Measure
    • Power BI: Quiz Solution Defining Explicit Measure
    • Power BI: Combining Multiple Functions Under Single Measure
    • Power BI: Quiz Creating Hybrid Measure
    • Power BI: Quiz Solution Creating Hybrid Measure
    • Power BI: Complex Function
    • Power BI: Multiple Functions Together
    • Power BI: Defining Quick Measure
    • Power BI: Quiz Put Visual and Add Measure Result
    • Power BI: Quiz Solution Put Visual and Add Measure Result
    • Power BI: Quiz Adding Fields to the Visual
    • Power BI: Quiz Solution Adding Fields to the Visual
    • Power BI: Quiz Apply Basic Filtering
    • Power BI: Quiz Solution Apply Basic Filtering
    • Power BI: Quiz Slice and Dice as Per Month
    • Power BI: Quiz Solution Slice and Dice as Per Month
    • Power BI: Quiz Applying Sort on the Month Field
    • Power BI: Quiz Solution Applying Sort on the Month Field
    • Power BI: Defining New Column using Find Function
    • Power BI: New Column using if Condition
    • Power BI: Quiz Adding New Column
    • Power BI: Quiz Solution Adding New Column
    • Power BI: Quiz Format the Measure Output
    • Power BI: Quiz Solution Format the Measure Output
    • Power BI: Time Intelligence in Power BI
    • Power BI: Defining Day Date Function
    • Power BI: Time Intelligence More Functions
    • Power BI: Making Your Own Date Table in Power BI
    • Power BI: Career Opportunities with Power BI
    • Power BI: Making Report in Power BI
    • Power BI: Adding Charts in Reports
    • Power BI: Publishing Data to Workspace and Dashboarda
    • Tableau: An Overview of the Module
    • Tableau: What is Tableau
    • Tableau: Why Tableau
    • Tableau: Features of Tableau
    • Tableau: Advantages of Using Tableau
    • Tableau: Website of Tableau
    • Tableau: Downloading Tableau
    • Tableau: Which Tableau Platform to Use
    • Tableau: Openning Tableau
    • Tableau: Adding Data, Connecting Tables, Adding Fields and Applying Cardinality
    • Tableau: Refrential Integrity and Relationships in Different Tables
    • Tableau: Data Modelling Using Multiple Fields to Develop Valid Relationship
    • Tableau: Union of Multiple Tables
    • Tableau: Understanding Data Forms in Sheet View of Tableau
    • Tableau: Simplified Bin Chart of Sales
    • Tableau: Making Various Charts in Just a Click in Different Colours and Size
    • Tableau: Combining Multiple Fiels Under One Axis as Dual Axis
    • Tableau: Lollipop Chart
    • Tableau: Creating Calculated Field to Find Profit Margin
    • Tableau: Quiz Calculated Field
    • Tableau: Quiz Solution Calculated Field
    • Tableau: Calculation with Condition Writing
    • Tableau: Quiz Total Revenue
    • Tableau: Quiz Solution Total Revenue
    • Tableau: Discrete and Continuous Data in Tableau
    • Tableau: Mapping in Tableau
    • Tableau: Data Joining
    • Tableau: Inner Join
    • Tableau: Full Outer Join
    • Tableau: Left Join, Right Join and Discussion on Data Modelling
    • Tableau: Quiz Creating Bin Field
    • Tableau: Quiz Solution Creating Bin Field
    • Tableau: Aggregation and Granularity
    • Tableau: Another Chart with Parameters
    • Tableau: Sales Chart with Adding Filters to Tooltip
    • Tableau: Joining vs Blending
    • Tableau: Using Pivot Function
    • Tableau: Project Quiz Forecasting your Sales
    • Tableau: Solution to the Project
    • Tableau: Working with Data Interpreter
    • Tableau: Adding Sheets to the Dashboard
    • Tableau: Quiz Project Designing Dashboard
    • Tableau: Solution to the Project Dashboard
    • Tableau: Quiz Project Making Story
    • Tableau: Solution to the Project Story
    • Tableau: Tableau vs Excel
    • Tableau: Power BI vs Tableau
    • Tableau: Final Video to Sum Up All
    • Project: Starting the Project Adding Slicer
    • Project: Adding Cards with Various Fields
    • Project: Applying Various Filters
    • Project: Formatting Visuals and Adding Chart
    • Project: Adding Charts to Dashboard
    • Project: Adding More Charts to Dashboard
    • Project: Final Dashboard
    • Project: Project Customer Analysis
    • Project: Importing Data
    • Project: Revenue Per State
    • Project: Revenue Per Month
    • Project: Revenue Per Age
    • Project: Quantity Discount Correlation
    • Project: Revenue Per Region
    • Project: Revenue Per Category
    • Project: Dashboard
    • Career Development: Career Growth in Business Intelligence
    • Career Development: OLTP and OLAP
    • Career Development: Your Grip on BI Tool
    • Career Development: Data Mart and Data Warehouse
    • Career Development: BI Developer
    • Career Development: Universe in Business Analytics
    • Career Development: Dashboard and SAS BI
    • Career Development: Agile Software Developement and BI Projects
    • Career Development: Benchmarks
    • Career Development: Granularity, BI Elements and BI Reports
    • Career Development: RAGGED Hierracrchy and SSBI
    • Career Development: Building Blocks in Power BI and Concept of INVEST
    • Career Development: BRD and SRS
    • Career Development: Business Modelling and Personas
    • Career Development: General Questions
    • Career Development: Open Ended Experience Based Questions
    • Career Development: BI Roles and Annual Salaries