Data Analytics | Component of Data Analyst | Tools needed to be a Data Analyst | Why Data Analytics? | Scope of a Data Analyst | Introduction to Excel interface | Cell formatting - Copy, Cut and Paste in Excel | Formatting Shortcuts | Adding and Deleting Columns and Rows in Excel | Use of Excel Shortcuts | Cell Referencing (Related vs absolute referencing) | Self-finance handling in Excel | Flash Fill Tutorial | Conditional Formatting | Data Structure, Sorting, Filtering

Data mapping to prepare a PivotTable | Various types of report layout-report in compact form, report in tabular form | Customizing subtotal at any row label data and subtotal category | Changing PivotTable data source | Inserting a calculated field and calculated item | Grouping/ungrouping data by year, quarter, month, day | Sorting and filtering techniques in PivotTable data | Slicer in PivotTable-creating, changing, and formatting | Make your PivotTable dynamic using slicer!

Understanding table structure | Understanding various relationships | Understanding primary & foreign key | Using Measure in PowerPivot | Preparing dashboard using PowerPivot | Using few DAX functions in PowerPivot

FILTER, IF() Condition and Expression of Logical Test | Using IF with AND & OR | Using VLOOKUP, HLOOKUP Function | Carefulness of VLOOKUP Function | Using SUMIF, COUNTIF | Using SUMIFS, COUNTIFS |

Power Query | PowerQuery | Understanding table structure | Creating data model | Exploring PowerPivot

Grouping/ungrouping data by year, quarter, month, day | Sorting and filtering techniques in PivotTable data | Slicer in PivotTable - creating, changing, and formatting | Make your PivotTable dynamic using slicer

Overview of Power BI and its ecosystem | Installing and setting up Power BI Desktop | Power BI interface basics: panes, ribbons, and views | Overview of data sources compatible with Power BI | Hands-on Activity: Connecting to a simple dataset and importing data | Introduction to Power Query Editor | Data transformation basics: filtering, merging, and appending tables | Data cleaning techniques: handling missing values, removing duplicates | Data Modeling | Basic data shaping: pivoting and unpivoting data | Hands-on Activity: Using Power Query to clean and transform raw data

Creating and formatting a complete Power BI report | Introduction to Power BI Service: publishing and sharing reports | Setting up report access and security basics | Basics of creating dashboards in Power BI Service | Hands-on Activity: Publishing a report to Power BI Service and sharing it

Overview of visualization types: bar, line, pie charts, tables, etc. | Choosing the right visualization for data types | Formatting visuals: color, labels, titles, and interactions | Introduction to slicers, filters, and drill-throughs | Hands-on Activity: Building a simple dashboard with basic visuals | Basics of DAX and its purpose in Power BI | Creating calculated columns and measures | Common functions: SUM, AVERAGE, COUNT, and basic conditional logic | Using DAX for aggregations and simple calculations | Hands-on Activity: Creating measures and calculated columns in a sample dataset