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