Unlock Your Potential ... Excel Through Education
1.Lecture 1:
a. Introduction of Power Pivot.
b. Create a Data Model.
c. Create a relation between tables.
d. Use Query to handle more than 2.5 M rows.
e. Create a pivot table report with a date slicer.
Download Files Needed From Here 👇
2.Lecture 2:
a. Adding Calculated Columns (ADVs. & DIS ADVS. )
b. Deference Between Implicit & Explicit Measures.
c. Adding new Data files to Data Model
d. How to write DAX formulas with 12 DAX formula examples.
e. Dax Iterator Functions (X-Formulas)
f. Filter Context (Internal & External Filter).
Download Files Needed From Here 👇