Automated dashboard project

Contents

• Introduction Introduction

  • Instructor and course introductions

    49s
• 1. Power Query 1. Power Query

  • (Locked)
    Power Query introduction

    4m 13s
  • (Locked)
    Pulling in data from multiple sources

    10m 41s
  • (Locked)
    Merging and appending data

    23m 49s
  • (Locked)
    Automations using Power Query

    5m 30s
  • (Locked)
    Automating data transformations

    14m 48s
• 2. Power Pivot 2. Power Pivot

  • (Locked)
    Power Pivot overview: Pivot Table vs. Power Pivot

    6m 33s
  • (Locked)
    Data modeling

    21m 56s
  • (Locked)
    Measures

    17m 7s
  • (Locked)
    KPIs

    11m 4s
• 3. Project 1 3. Project 1

  • (Locked)
    Automated dashboard project

    33m 46s
• 4. Macros and VBA 4. Macros and VBA

  • (Locked)
    What is a macro and VBA?

    3m 17s
  • (Locked)
    Creating your first macro

    12m 23s
  • (Locked)
    Making useful macros

    11m 53s
  • (Locked)
    VBAs

    7m 6s
• 5. Project 2 5. Project 2

  • (Locked)
    Vehicle report automation

    35m 49s
• Congratulations! Congratulations!

  • (Locked)
    Congratulations

    19s