moataz-elmesmary / data-analysis-using-excel-and-power-bi-sessions Goto Github PK

   (3h each)

• Introduction to Data & Data analysis life cycle
• Functions
• Arithmetic Operators
• Filter

• More Functions
• Functions with condition
• Relative & Absolute Reference
• Sort & Filter
• Data - Data Validation - Drop down list
• auto fill options - Format Painter

• Functions with more than 1 condition or criteria
• Table and Table Tools
• Charts (Introduction)

• Charts
• Insert Picture
• Static Dashboard
• Pivot Tables
• Pivot Charts
• Slicer
• Dynamic Dashboard

• More in Pivot Tables & Charts
• Date and Time Functions
  
• Charts Format - save as template
• More in Slicer Settings

• IF Function
• Nested IF - IFS
• More in Pivot Table
• Top 10 - Bottom 10 - Filters
• Slicer
• Sparklines
• Conditional Formatting

• Hyper Link
• VLOOKUP
• HLOOKUP
• Pivot Table (Grouping)

• Revision (Task 7)
• Data Cleaning
• Errors: Duplicated Values - Diff. Data Type - Blank Cells - Spaces - Date & Time - Formatting - Wrong Data
• To insert table, make sure that there is no Header Row / Merge Cells / Blank Rows or Columns / Subtotal
• Logical Formulas
• More in Pivot Tables

• 40 Min (QUIZ)
• Text Functions

• VLOOKUP + MATCH
• INDEX & MATCH
• S1 Power Query

• S2 Power Query
• Add Column >> Custom - Conditional - index - duplicate - multiply
• Merge Queries
• Load to (only create connection)
• Append Queries

• S3 Power Query
• More Transformations
• Combine
• Group by
• +Relationships

• Power Pivot

• S1 Power BI
• Check image:👉