Live Class 1:
Introduction to Data Analytics | Component of a 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 | Using AI In Excel | Text Function (Join & Split) | Freezing Panes | Splitting windows

Live Class 2:
Advanced Excel Basics | Cell Referencing (Relative vs Absolute Referencing) | Self-finance Handling in Excel | Flash Fill Tutorial | Conditional Formatting | Data Structure: Sorting and Filtering | Customizing header and footer | Using Print Area | Fixing number of pages to be printed of whole sheet.| Printing both sides | Printing in center of the page 

Live Class 1

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

Live Class 2

What-if Analysis | 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

Live Class 1

What Is Power Query | PowerQuery | Understanding table structure

Live Class 2

Creating data model | Exploring PowerPivot

• Assignment
  মডিউল ১ থেকে মডিউল ৬ পর্যন্ত যা যা আলোচনা হয়েছে, তার উপর ভিত্তি করে থাকবে একটি বড়সড় অ্যাসাইনমেন্ট। এটি আপনাকে আপনার শেখা বিষয়গুলো পুনর্বিবেচনা এবং বাস্তব জীবনের চ্যালেঞ্জ মোকাবিলার প্রস্তুতি নিতে সাহায্য করবে।

• Test
  মডিউল ১ থেকে মডিউল ৬ পর্যন্ত শেখা বিষয়গুলোর উপর ভিত্তি করে একটি লাইভ টেস্ট হবে। এই টেস্টে আপনার দক্ষতা ঝালাই করার সুযোগ থাকবে।

Live Class 1
Logical Functions | FILTER | IF() Condition and Expression of Logical Test | Using IF with AND & OR

Live Class 2
Carefulness of VLOOKUP Function | Using SUMIF, COUNTIF | Using SUMIFS, COUNTIFS,COUNTA,INDEX and MATCH function,MINIFS, MAXIFS ,Using AVERAGEIFS

Live Class 1

Understanding table structure | Understanding various relationships | Understanding primary & foreign key

Live Class 2

Using Measure in PowerPivot | Preparing dashboard using PowerPivot | Using few DAX functions in PowerPivot

Live Class 1

Using Power Query | Power Pivot | Web Scrapping data | DAX

Live Class 2

Using Power Query | Power Pivot | Web Scrapping data | DAX

Live Class 1

Understanding SQL and Data Models | Basic SQL Syntax and Structure | SELECT Statement: Retrieving Data from Tables | Filtering Data with WHERE Clause | Sorting Data with ORDER BY Clause

Live Class 2

Introduction to SQL in Data Analytics | SQL Queries for Data Extraction | Working with Joins in SQL | Aggregating Data for Dashboards | Subqueries and Nested Queries