Data Analytics & Business Intelligence with Excel

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity Announcements

    

    Announcements Forum
• Select section Module 2: Power Query for Extract, Transform and Load (ETL) operations

  Module 2: Power Query for Extract, Transform and Load (ETL) operations

  • Select activity Introducing Power Query

    

    Introducing Power Query Iqrasity Video Player
  • Select activity Applying Basic Transformations

    

    Applying Basic Transformations Iqrasity Video Player
  • Select activity Editing Transformations

    

    Editing Transformations Iqrasity Video Player
  • Select activity Numerical Transformations

    

    Numerical Transformations Iqrasity Video Player
  • Select activity Text Transformations

    

    Text Transformations Iqrasity Video Player
  • Select activity Date Transformations - Building a Calendar Table

    

    Date Transformations - Building a Calendar Table Iqrasity Video Player
  • Select activity Conditional Transformations

    

    Conditional Transformations Iqrasity Video Player
  • Select activity Merging Datasets

    

    Merging Datasets Iqrasity Video Player
  • Select activity Appending Datasets

    

    Appending Datasets Iqrasity Video Player
• Select section Module 2: The Excel Data Model

  Module 2: The Excel Data Model

  • Select activity Introducing Excel's Data Model

    

    Introducing Excel's Data Model Iqrasity Video Player
  • Select activity Putting the Data Model to Work

    

    Putting the Data Model to Work Iqrasity Video Player
  • Select activity Relationships

    

    Relationships Iqrasity Video Player
  • Select activity Relationships in The Excel Data Model

    

    Relationships in The Excel Data Model Iqrasity Video Player
  • Select activity Power Pivot Tables

    

    Power Pivot Tables Iqrasity Video Player
  • Select activity Calendar Tables

    

    Calendar Tables Iqrasity Video Player
  • Select activity Exercise Imposter Syndrome

    

    Exercise Imposter Syndrome Iqrasity Video Player
  • Select activity Power Pivot Pitfalls

    

    Power Pivot Pitfalls Iqrasity Video Player
  • Select activity Multiple Data Tables

    

    Multiple Data Tables Iqrasity Video Player
• Select section Module 3 Analyzing the Data Model With DAX

  Module 3 Analyzing the Data Model With DAX

  • Select activity Calculated Columns With DAX

    

    Calculated Columns With DAX Iqrasity Video Player
  • Select activity The IF Function in DAX

    

    The IF Function in DAX Iqrasity Video Player
  • Select activity The SWITCH Function

    

    The SWITCH Function Iqrasity Video Player
  • Select activity The RELATED Function

    

    The RELATED Function Iqrasity Video Player
  • Select activity Introducing Measures

    

    Introducing Measures Iqrasity Video Player
  • Select activity Using DAX Functions in Measures

    

    Using DAX Functions in Measures Iqrasity Video Player
  • Select activity The ALL Function

    

    The ALL Function Iqrasity Video Player
• Select section Module 4: Advanced DAX

  Module 4: Advanced DAX

  • Select activity Introducing Time Intelligence Functions

    

    Introducing Time Intelligence Functions Iqrasity Video Player
  • Select activity The ISBLANK Function

    

    The ISBLANK Function Iqrasity Video Player
  • Select activity The DATEADD Function

    

    The DATEADD Function Iqrasity Video Player
  • Select activity The DATESINPERIOD Function

    

    The DATESINPERIOD Function Iqrasity Video Player
  • Select activity Variables in DAX

    

    Variables in DAX Iqrasity Video Player
  • Select activity The X Functions

    

    The X Functions Iqrasity Video Player
  • Select activity The RANKX Function

    

    The RANKX Function Iqrasity Video Player
  • Select activity The TOPN Function

    

    The TOPN Function Iqrasity Video Player
• Select section Module 5: Data Visualization Techniques

  Module 5: Data Visualization Techniques

  • Select activity Pivot Table Formatting Tips

    

    Pivot Table Formatting Tips Iqrasity Video Player
  • Select activity Conditional Formatting Data Bars, Color Scales, and Icon Sets

    

    Conditional Formatting Data Bars, Color Scales, and Icon Sets Iqrasity Video Player
  • Select activity Custom Conditional Formats

    

    Custom Conditional Formats Iqrasity Video Player
  • Select activity Introducing Pivot Charts

    

    Introducing Pivot Charts Iqrasity Video Player
  • Select activity Column Charts

    

    Column Charts Iqrasity Video Player
  • Select activity Line Charts, Area Charts, and Timelines

    

    Line Charts, Area Charts, and Timelines Iqrasity Video Player
  • Select activity Combo Charts

    

    Combo Charts Iqrasity Video Player
  • Select activity Changing Measures With Slicers

    

    Changing Measures With Slicers Iqrasity Video Player