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

Certificate program in Microsoft Business Intelligence/ Power BI - E-Learning

via SWAYAM Plus

Go to class Write review

Corporate Finance Institute

Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them

Coursera

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

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Understand how to use Microsoft BI tools, including Power BI, to analyze and visualize data. Learn to create interactive reports and dashboards.

Intended audience

MIS Analyst, Reporting Analyst, Excel Specialist, Power BI Developer, BI Analyst, SQL Developer, MySQL Database Administrator, Data Analyst

Prerequisites

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

Assessment & certification

Assessment fee: Included — no extra fee
Assessment mode: Center based
Assessment type: MCQ
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: Power BI:
Week 14: Installation of Power BI Desktop
Week 15: Understanding the Visualizations
Week 16: Use of AI in Power BI
Week 17: Conditional Formatting and Formatting Techniques
Week 18: Power Query
Week 19: Trend Analysis and Future Forecast
Week 20: Intro to DAX
Week 21: Custom Visualizations
Week 22: Power BI Service
Week 23: MySQL:
Week 24: Installation of MySQL Database
Week 25: DDL, DML, DQL and TCL Commands
Week 26: Select Query with All Combinations
Week 27: Constraints
Week 28: Joins
Week 29: View
Week 30: Index
Week 31: Stored Procedures
Week 32: Subquery
Week 33: Window Functions
Week 34: Triggers

Taught by

ExcelR

Reviews

Start your review of Certificate program in Microsoft Business Intelligence/ Power BI - E-Learning