Introduction

       

      Exercise #1

       

      INSTRUCTIONS: 

      1.-Open CSV File​

      ​2.-Remove extra columns​

      ​3.-Unpivot columns​

      ​4.-Rename columns​

      ​5.-Change Type​

      6.-Filter by column​

      7.-Rename query

      Exercise #2

       

      INSTRUCTIONS:

      1.-Open Excel File 

      2.-Select: Tables

      3.-Check data types

      4.-Filter by column

      5.-Add calculated column

       

       

      exercise #3

       

      INSTRUCTION:

      1.-Rearrange tables in "Relationship" view

            1.1 Fact tables in the middle

             1.2 Dimension tables outside

      2.-Manually add relationship"

      Exercise #4

       

      INSTRUCTIONS:

      1.- Create new table

      2.- Create new measures

      2.1 Revenue

       2.2 Target

       2.3 Variance

       2.4 Margin

       

      3.- Apply formatting

      3.1  Currency: Revenue, Target, Variance

       3.2Percentage: Margin

       

      Exercise #5

       

      INSTRUCTIONS:

      1.- KPI: Multi-row card

      1.1 Revenue, Target, Variance, Margin

      2.- Page-Level filter: Area (WE)

      3.- Clustered Column chart

       3.1 Sales by Country

       3.2 Variance By Country

       3.3 Sales By Quarter, Country, BG,

      3.3.1 Drill down

        3.4 Variance By Pricing Level

        3.5 Sales & Target by BG

      Exercise #6

       

      INSTRUCTIONS: 

      1.- Switch different themes

      2.- Import Theme "Tumble Road"

      3.- Change data colors (VTB by pricing level)

      Conclusion