Course Details
৳ 25000
Data Analytics Job Ready Program
What you'll learn
ð Data Analyst
ð Business Analyst
ð Reporting Analyst
ð BI Analyst
ð Junior Data Scientist (entry-level)
ð Freelance dashboard projects
Course Details
ntroduction 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 | Cell Referencing (Relative vs Absolute Referencing) | Formatting Shortcuts | Flash Fill Tutorial
Logical Functions | FILTER | IF() Condition and Expression of Logical Test | Using IF with AND & OR || AI In Excel | Text Function (Join & Split) |Carefulness of VLOOKUP Function
What-if Analysis |Goal Seek | 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
Understanding table structure | Understanding various relationships | Understanding primary & foreign key| Manage data model from multiple file | Dynamic Model