Kickstart Your Excel & Power BI Journey

Live Class 1: Introduction to Data Analytics

Topics:
What is Data Analytics? | Why Data Matters in Modern Business | How Analytics Drives Business Decisions | Types of Data | Levels of Analytics | Data Analytics Workflow | Tools & Technologies in Analytics | Must-Have Skills for Data Analysts | Real-Life Business Use Cases | Understanding Excel’s Role in the Analytics Ecosystem | Excel Interface Walkthrough | Importing Data | Rows, Columns, Sheets Structure | Basic Excel Operations | Basic Formulas | Cell Referencing | Career Paths in Analytics | Industry Demand & Salary Insights | Q&A

Live Class 2: Data Analysis with Excel (Cleaning, Formatting & Exploration)

Topics:
Data Cleaning Basics | Removing Duplicates | Handling Missing Data | Text to Columns | Data Formatting | Conditional Formatting | Data Sorting & Filtering | Data Validation | Using Functions | Lookup Functions | Pivot Table Basics | Exploratory Data Analysis with Excel | Creating Summary Tables

Live Class 3: Mini Project – Power BI Dashboard Design from Real Dataset

Topics:
Project Overview | Understanding the Dataset | Setting Objectives | Data Loading & Power Query Cleaning | Data Modeling | Creating Measures with DAX | KPI Selection | Designing Visuals | Slicers & Filters | Building an Interactive Power BI Dashboard | Theme & Layout Best Practices | Publishing & Sharing the Dashboard | Final Dashboard Presentation | Q&A