SAS Training

MIS

MIS (Management Information Systems) is the way of processing data and information to help decision makers in making effective business related and day to day decisions. The system is in place to ensure that a business can run effectively and all business-related data is stored properly and is easy to access and refer whenever the need arises. Management Information Systems (MIS) is responsible for ensuring the day to day communication within the company and between the employees to allow for easy sharing and accessing of data required by them and the company as a whole for its operations and taking future business and policy decisions. It is a semi-structured system and is of immense help to the managers to make tactical decisions.

The training course in MIS is created keeping in mind the demands of the multinational corporations and big industries which rely heavily on MIS professionals to facilitate their day to day work. The convenience provided by MIS cannot be overlooked in today’s world where speed and efficiency are equal if not more important than profits for the corporations and hiring qualified MIS professionals enables these companies to further add to their efficiency. The MIS training programme is well suited and tailored to enable individuals to be transformed into business policy driving professionals.

Course Content Covered in MIS Training Course

Module 1- Basic & Advanced MS Excel 2013 with Dashboard

  • Introduction to Excel, Basic Understanding Menu and Toolbar
  • Lookup, VLookup & HLookup
  • VLookup using Array formula, Dynamic / Reverse VLookup, Index & Match function
  • Advanced Filter and Custom Sorting
  • Create Dynamic Graph & Chart
  • Advanced Filter
  • Advanced Pivot Table
  • Grouping/Ungrouping
  • Combining Data from Multiple Sheets
  • Extract data page wise
  • Use Slicer /Time Line
  • Spark line
  • Preparation of Dashboard
  • Using camera tools for Dashboard
  • Using Interactive Control in Excel Dashboards (Scroll bar, Check Box, Radio Button, Drop Down list, etc)
  • Dashboard using Power BI Tools
  • Data Validation
  • Number & Conditional Formatting
  • Protection
  • Goal Seek, Solver, Scenario, Data Table
  • Logical Functions
  • Financial Functions
  • Create web Query link MS excel with any Website
  • Recorded Macros /Edit Macros
  • Relative Cell References
  • Viewing a Macro Module
  • Executing Macros

Module 2- VBA Programming using MS Excel

  • Introduction to VBA Programming
  • Understanding The VBA Editor
  • Understanding Macro Code
  • Variables and Data Types in VBA
  • VBA Operators and Expressions
  • Conditional Statement if..Then..else
  • Looping Statement / Repeating Actions with a Loop
  • Creating Functions with VBA
  • Arrays
  • Events – driven programming in VBA
  • Excel Object Model (Properties, Methods, Events, Collections Worksheets, Workbooks, Ranges (Cells), Charts)
  • Creating User Form
  • Protect VBA Code
  • Create ADD Ins

Module 3- MS Access 2013

  • Exploring the Microsoft Access Environment
  • Designing a Database
  • Building a Table & Linking Tables (Defining Primary Keys, Linking Tables )
  • Managing Data in a Table
  • Importing and exporting the data
  • Creating and Using Queries (Parameterised Query, Cross tab Query, Find Duplicate)
  • Action Query (Update/Delete/Select/Append Query)
  • Designing a Form
  • Designing a Report
  • Automating tasks with Macros and VBA
  • Setting up an Access Web App
  • Building Basic Web Apps
  • Access Options relating to Multi-user Issues
  • Record Locking

Module 4- SQL (Structured Query Language) using SQL Server

  • SQL Fundamental
  • Creating Tables Using SQL
  • Protecting Data
  • Improving performance
  • Manipulating Data (DML)
  • Controlling Transactions
  • SELECT Statement in SQL
  • From and Where Clause
  • Multiple Tables Query using Joins
  • Combining results
  • Functions in SQL
  • Creating Nested Queries

MIS & Data Analysis in Excel & SQL Training Course

Duration – 4 mths Fee- Rs 20,000

    Data Analyst & MIS Analyst in Excel, VBA/Macros, Access & SQL using by 70% to 80% of companies. Mostly in MNC, Advanced Excel, VBA/Macros, Access & SQL, are key tool for reporting , analysis & dashboard presentation. Therefore, pursuing a compounded career in MIS & Data Analyst will be 110% best decision for job stability and career growth in any companies.
  • MIS Executive & Data Analyst jobs are considered to be best career in Reporting and Analytics with average salary hike of 15%- 30%.
  • Data analysis and use everywhere and the potential candidate having best skills and expertise can get a best opportunity in companies.
  • After the completion of a reliable MIS Analyst & Data Analysis Training Course in Microsoft Advanced Excel, VB/Macros, Access,SQL, the choose from various job titles that include Research Analyst, MIS Executive & Analyst,Data Analyst, Operation Manager, Automation Reporting Analyst, vb/Marcos developer , MIS consultant. etc
  There are more than 30% analyst after 2-3 years of experience working as a freelancer or work from home with well-paid opportunities

JPIE Delhi Trainer's Profile for MIS Training in Delhi

JPIE's Delhi MIS Trainers are:

  • Our trainers are industry-experts and subject specialists who have mastered on running applications providing best MIS training to the students.
  • We have received various prestigious awards by our recognized IT partners and organizations.
  • Our trainers are MNC working professionals employed in HCL Technologies, Birla-soft, TCS, IBM, Sapient, Agilent Technologies, and so on.
  • Our trainers are certified professionals possessing 7+ years of experience in the industry.
  • Our trainers have regular coordination with MNCs HR team on daily basis.

Placement Assistance after MIS Training in Delhi

Along with MIS training in Delhi, we provide placement assistance to the students.

  • JPIE Delhi with successful 96% placement rate has a dedicated HR wing that assist students in securing placement according to their requirements.
  • JPIE Delhi assist students in developing their resume matching the current industry needs.
  • JPIE Delhi, apart from course training, also facilitate students with sessions provided on personality designing, spoken English, group discussion, mock interview, and presentation skills to develop a high level of confidence for facing tricky and challenging interviews competently.
  • JPIE Delhi provide an in-depth training to the students, which assist them to secure placement in top IT firms such as HCL, TCS, Infosys, Wipro, Accenture, and many more effortlessly.