Module1: DATA ANALYSIS USING EXCEL

• Classic Excel Dashboard
  • Introducing Pivot Tables & PivotChart
    • Inserting Pivot Table
    • Customize Pivot Table
    • Pivot table options
    • Pivot Table Layout and Formats
    • Inserting Slicers
    • Inserting timeline
    • Sorting & Grouping
    • Adding New Data
    • Calculations
    • Manipulating Values
  • Analyzing & Visualizing Data with PivotChart
    • Pivot Chart types and
    • Pivot Chart Options
    • Manual Legend
    • Dynamic Labels
    • Color Formatting with Themes
    • Formatting Objects
    • Hide Sheets / Gridlines / Headers / Formula Bar
    • Changing themes
    • Utilize right charts

• Extract, Transform, and Load (ETL) Data Using Power Query
  • Introducing to Power Query
  • Connecting to Excel Workbook Files
  • Connecting to CSV & TEXT Files & Folders
  • Connecting to Access Files
  • Data Types
  • Transforming Data Using Power Query
    • Power Query Overview
    • Manage columns & rows
    • Change Type Using Locale
    • Table level operations
    • Column level operations
    • Text Transformation options
    • Number Transformation options
    • Date & Time Transformation options
    • Merge and append queries
  • Loading Data to the Excel Data Model
  • Working with Multiple Queries
  • Custom Columns with M Calculations

• Working with Data Model in Power Pivot
  • Power Pivot Capabilities
  • Importing Data into Power Pivot
  • Understand Data Model Concept
  • Create & Manage Relationships in Data Model

• Working with DAX
  • Understand Data Analysis Expression – DAX
  • DAX Terminologies
  • Create Calculated Column
  • Create Measure
  • Row Context
  • Filter Context
  • Implicit Measure
  • Explicit Measure

• Working with Advanced DAX Measures
  • Aggregation Functions
  • Date & Time Functions
  • Filter Functions
  • Information Functions
  • Logical Functions
  • Relationship Functions
  • Text Functions
  • Building a Calendar table
  • Time Intelligence in DAX

• Visualizing Data in Excel Using Power Query, Pivot Tables & Pivot Charts
  • Create Dynamics Excel Reports
    • Inserting Power Pivot Pivot Table
  • Create interactive Excel Dashboard
  • Creating KPIs

Module 2: Data Analysis Using Power BI

• Get Started with Power BI Desktop
  • Introduction Power BI
  • The 7 pillars for Mastering Power BI
  • Installing Power BI Desktop
  • Create Report & Dashboard

• Clean, Transform, and Load Data in Power BI
• Loading Data to Power BI
• Uploading & Updating PBIX Reports
• Transforming Data Using Power Query in Power BI

• Modeling with Power BI
• Mange Data Model in Power BI
• Setup and Manage Relationships
• Create Calculated Column
• Create Measure & Quick Measure
• Perform DAX Functions in Power BI
• Building a Calendar table
• Time Intelligence in DAX

• Data Visualizations in Power BI
• Creating Reports & Dashboard
• Report Filtering
• Drill-down & Drill-Through
• Hierarchies
• Formatting Visualizations
• Color & Conditional Formatting
• Understanding Data Refresh
• Bookmarks & Buttons & Q & A
• Publishing and Sharing