Welcome to Delhi Institute of Information Technology

DELHI INSTITUTE OF INFORMATION TECHNOLOGY (DIIT)

DIPLOMA IN MIS ANALYTICS ( M-D103 )

BASIC INFORMATION

  • Course Fees : 18000.00 20000.00/-
  • Course Duration : 6 MONTH
  • Minimum Amount To Pay : Rs.500.00

Power BI:

Introduction to Power BI

 Prepare Data in Power BI

 Publish Power BI

 Service Power BI

 Desktop Tooltip Reports & Slicers in Power BI

 Buttons & Bookmarks in Power BI

 

Advanced Excel:

Advanced Conditional Formatting

ASAP Utilities

Lookup Functions

Match & Index

Dynamic Viookup

Data Table

Solver

Financial Functions

Sort & Filter

PowerPivot

Dashboard Creation

Power Map & Power Query

Macro

Array Functions

Google Drive

Mail Merge

 

VBA:

Macro

 Introduction to VBA

 Working with Procedures & Functions

 Customizing the VBA Environment

 Understanding the Objects

 Variables & Intrinsic Functions

 Controlling Program Execution

 Debugging Code & Handling Errors

 VBA Programming Functions

 Excel Form Control & ActiveX

 Working with Forms & Controls

SQL:

Introduction to SQL

Platforms to execute SQL codes

Creating a table

Data insertion

Auto increment and primary key

Alter table

Delete

Update

Top clause

String functions

Aggregate functions

Constraints

SQL join

Insert sub-query

Delete sub-query

12th Pass