Module 1: Advance Excel

• Import Data from Different Sources
• Conditional & Lookup Functions.
• Statistical functions, Math Functions.
• Data Cleaning Techniques.
• Data Modeling Using Dimension & Fact Tables.
• Creating Reports using Pivot Table, Reporting functions, and Data Modeling.
• Data Visualization using Charts, Sparkline, Condi-tional Formatting and Shapes.
• Analysis Tool Scenario Manager, Solver, Goal Seek

Module 2: Power BI

• Import Data from Different Sources
• Writing M Code.
• Basics of DBMS and RDBMS.
• Primary Keys, Foreign Keys, Dimension and Fact Tables.
• Advance DAX Measures.
• Data Visualization Using Charts, Map, Cards.
• Conditional formatting in Charts.
• Decomposition Tree.
• Asking AI Based Q & A.
• Key Influencers Chart.

Module 3: MS Access