Admission Now

  • Skill Level: Beginners
  • Duration: 4 Months
  • Class Per Week: 2 Day
  • Total Class: 32
  • Certificate: Yes
  • Provide Class Video
  • Language: Bangla & English

Opening Hours

  • Saturday               : Remote office.
  • Sunday, Moday    : Close
  • Tuesday                : 10.00 am - 6.00 pm
  • Wednesday          : 10.00 am - 6.00 pm
  • Thursday              : 10.00 am - 6.00 pm
  • Friday                    : 08.00 am - 8.00 pm
Data Analytics

Data Analytics

Course Fee: ৳10,500
Enroll Now
Overview:

“Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.”

“Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.”

Trainer: MD. Rowson Al Mamun (MCT, MCSA, MCP)
Duration: 3 Months (Approx. 30 Classes)

1. Excel for Data Analysis

  • Excel interface and worksheet management

  • Data entry, formatting, and basic formulas

  • Sorting, filtering, and data validation

  • PivotTables, PivotCharts, Power Query, and PowerPivot

2. Advanced Excel Analytics

  • Logical functions (IF, AND, OR)

  • Lookup functions (XLOOKUP, VLOOKUP, INDEX-MATCH)

  • Text and date functions

  • Data Analysis Toolpak and What-If Analysis

3. Data Visualization

  • Creating charts and graphs

  • Dynamic dashboards

  • Conditional formatting and sparklines

4. Microsoft Power BI

  • Connecting and transforming data with Power Query

  • Data modeling and relationships

  • DAX calculations and measures

  • Interactive dashboards and reports

5. SQL for Data Analysis

  • SQL basics and data retrieval

  • Joins, subqueries, and aggregation

  • Window functions and CTEs

  • Query optimization and performance tuning

6. Python for Data Analytics

  • Python fundamentals and data structures

  • Data analysis using Python libraries

  • Data cleaning and transformation

  • Exploratory data analysis

7. Advanced Analytics & Deployment

  • AI visuals and advanced DAX

  • Publishing reports in Power BI

  • Data security and performance optimization

8. Certification Preparation

  • Power BI Data Analyst Associate (PL-300) preparation

  • Real-world projects and portfolio development