MIS Executive Course

BPA offers MIS Executive Course Training, that is, Management Information System meaning a computer-based system enabling managers with the tools to organize, evaluate and efficiently manage departments within the organization. The system is in place to ensure that business-related data is stored correctly and is easy to access and refer to whenever the need arises. Moreover, the role of the management information system (MIS) manager is to focus on the organization’s information and technology systems. MIS manager typically analyzes business problems and then design and maintain computer applications to solve the organization’s situation. MIS Executive Course training at BPA Educators is specially designed as a result of a lot of research and according to the needs of the industry and multiple corporations. BPA Educators also provides the best MIS executive course in Rohini, Delhi.

You will also Receive

• Study Material
• Sessions on Personality Development, Time Management, and also Career options
• 3 Live project
• A Certificate of Professional Training after the Completion of the Course
• OJT(On the Job Training)
• OJT Certificate
• Expert Advice

Modules of MIS Executive Course

MS-Excel

• Basics
• Lookups
• Advanced Filters
• Pivot Table and also Charts
• Combining Data from Multiple Worksheets
• Extracting data page wise
• Slicer/TimeLine
• Data management and also security
• Formatting for reports
• Data Analysis with what-if, also goal seek ec
• Formulae in Excel(Text, Logical, Maths)
• Advance charts and also graphs
• Data validation,protect/unprotect sheets & also workbook
• Financial analysis(NPV, IRR etc.)
• Power pivot and also Power query
• Dashboard

VBA|Macros in VBA

• Dashboard Designing
• VBA Operators
• Expressions
• Data types and also variables
• Looping
• Subs, Functions
• Arrays
• Logics and also Advanced Array Formula
• Programming with VBA Macros
• Error Debugging and also Protecting Code
• Creating Custom Worksheets
• User Forms
• Connecting Excel VBA and also other platforms

SQL

• Database concepts
• Installing and also setting up Database
• Queries in SQL
• Insert Data
• Create Data
• Alter Data
• Update Data
• Deleting Data
• Data Sources
• Selecting Rows
• Selecting Columns
• Data Types
• Strings and Functions
• Numeric and also Functions
• Datetime and also Functions
• Sorting
• Grouping, Having
• Filtering with Where, like, in etc
• Removing Duplicates
• Relationships between tables
• Joins – Inner, Outer, Crossa and also Self
• Aggregate Functions
• Triggers – Query Optimization Techniques
• Sub Queries
• Views
• Union, Union all, Intersect, Except
• Indexes and also using indexes for query performance
• Procedures (Basic and parameter based)
• Functions
• Transactions – Begin, Commit, Rollback
• Working with JSON and XML data
• using spatial data types, managing users and also permissions
• using roles and privileges
• Ensuring data security and also encryption

Ms Access (Choice 1)

• Access Environment
• Access table creation
• Working with Tables
• Properties in Access
• Data types in Access
• Data Migration and also Importing
• Relationships
• Access Forms
• Design Mode
• Wizard Mode
• Creating Subforms
• Display Summary Data
• Runtime Forms
• Access Forms
• Design Mode
• Wizard Mode
• Charts in Report
• Calculated Fields
• Sub Reports
• Runtime Reports

Python (Choice 2)

• Installing Python
• Running Python scripts
• Python ide (Jupter notebooks, Pycharm, VS code)
• Variables and Data type,
• Basic operators, Input & Output
• Conditional Statements (if, Elif, Else) , Loop( For, While )
• Lists, Tuples, Sets, Dictionaries, Defining functions
• Function Arguments and also Return values
• Lambda functions, Importing modules
• Standard library modules
• Creating and using packages
• Reading & Writing files
• Working with CSV and JSON files
• Try, Except, Finally, Raising exceptions
• Classes and Objects, Methods and also Inheritance
• Polymorphism, Abstract Classes and also Methods
• Static and Class methods
• Encapsulation lterator
• Creating generators using Yield
• Numpy, Arrays
• Array operations, Advanced array manipulation
• Mathematical and Statistical function
• Pandas, Data structures, Data operations
• Data manipulation, Data cleaning, File I/ O with pandas
• Matplotilb, Baisc plots
• Plot customization, Subplots, Advanced plots
• Seaborn, Relational plots, Matrix plots
• Scikit, Basic concepts
• Supervised learning
• Unsupervised, Model evaluation, Model selection
• Tunning, Pipeline and also Workflow

Business Communication

• Interview skills
• Email writing
• Presentation skills
• Body language
• Communication skills

CAREER OPTIONS AFTER MIS EXECUTIVE PROGRAM

• Data Analyst
• MIS Analyst
• MIS Support Executive
• MIS Professional
• Finance Analyst
• MIS Executive

Duration: 3 to 6 Months

Enroll Now