Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Certificate program in Data Analytics - E-Learning

via SWAYAM Plus

Go to class Write review

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

DataCamp

AI Engineer - Learn how to integrate AI into software applications

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Learn to analyze, interpret, and visualize data to make informed business decisions. Focus on tools like Excel, SQL, and Power BI for effective data management.

Intended audience

Excel Specialist, MIS Analyst, Reporting Analyst, Data Analyst, Tableau Developer, BI Analyst, Tableau Consultant, Power BI Developer, Business Intelligence Analyst, Dashboard Designer

Prerequisites

BE / B. Tech / ME / M. Tech / Degree

Assessment & certification

Assessment fee: Included — no extra fee
Assessment mode: Online
Assessment provider: ExcelR
Certificate provider: SWAYAM Plus and ExcelR

NCrF level: 7 (NCrF credit-eligible)

Syllabus

Week 1: Excel:
Week 2: • Introduction to MS Excel Interface
Week 3: • Cell Referencing (Absolute, Relative, Mixed)
Week 4: • Logical Functions
Week 5: • VLOOKUP, HLOOKUP
Week 6: • Data Validation
Week 7: • Number Formatting
Week 8: • Date Functions
Week 9: • Conditional Formatting
Week 10: • Pivot Table and Pivot Charts
Week 11: • Creating a Dashboard
Week 12: • Intro to Macros and VBA
Week 13: Tableau:
Week 14: • Installation of Tableau Public
Week 15: • Filters
Week 16: • Basic Charts
Week 17: • Basic Calculations, Table Calculations
Week 18: • LOD’s (Level of Detail Expressions)
Week 19: • Joins, Relationships, Data Blending, Union
Week 20: • Groups, Sets, Parameter
Week 21: • Reference Lines
Week 22: • Creating a Dashboard
Week 23: • Dashboard Actions
Week 24: Power BI:
Week 25: • Installation of Power BI Desktop
Week 26: • Understanding the Visualizations
Week 27: • Use of AI in Power BI
Week 28: • Conditional Formatting and Formatting Techniques
Week 29: • Power Query
Week 30: • Trend Analysis and Future Forecast
Week 31: • Intro to DAX
Week 32: • Custom Visualizations
Week 33: • Power BI Service

Taught by

ExcelR

Reviews

Start your review of Certificate program in Data Analytics - E-Learning