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 | Adding and Deleting Columns and Rows in Excel | Use of Excel Shortcuts

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

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
Lookup and Conditional Functions | Using VLOOKUP, HLOOKUP Functions | Carefulness of VLOOKUP Function | Using SUMIF, COUNTIF | Using SUMIFS, COUNTIFS

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

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

Live Class 2

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

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

Live Class 1

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

Live Class 2

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