Skip to content

Latest commit

 

History

History
37 lines (29 loc) · 940 Bytes

File metadata and controls

37 lines (29 loc) · 940 Bytes

Lesson 2 - Excel / Power Query / Power Pivot / DAX

Topics Covered

  • Power Query
  • Power Pivot
  • Data Modeling
  • DAX (Data Analysis Expressions)

Key Learnings

  • Add your key takeaways and concepts here

Power Query Notes

  • Data transformation and cleaning steps
  • Common transformations applied
  • Challenges faced and how they were resolved

Power Pivot Notes

  • Relationships created between tables
  • Measures and calculated columns
  • Performance considerations

DAX Notes

  • DAX formulas and functions used
  • Calculations and aggregations
  • Common DAX patterns

Practice Areas to Review

  • Power Query transformations
  • Power Pivot relationships and models
  • DAX calculations and measures
  • Data visualization and reports

Next Steps

  • Continue practicing with Maven Electronics dataset
  • Explore advanced DAX functions
  • Build a complete end-to-end project using all three tools