Data Analysis and Management
Advanced MIS Training

Advanced MIS Training

Course Duration: 120 Hrs.

vba dashboard practical

Advanced MIS Training designed for working professionals having basic knowledge on MS-Excel along with knowledge on Database Management System.

The course majorly covers Advanced Excel, VBA, Python, Pandas, XLRD, SQL with Tableau

Interested in some other courses too?

The Advanced MIS Training by ACLM Institute of Professional Studies can change your approach on data operation and will also gain confidence about visualizing any complex data sets. You can also set your career goal as a data analyst. contact us​

What is Advanced MIS Training

advanced mis training

Advanced MIS Training - Whenever you think about data representation, reporting, customization and automation on large complex data, you'll always get confuse with multiple tools available in the market.

At ACLM, you'll learn to handle the complex data set with the help of Excel, VBA, Python, SQL & most demanding Tableau Business Intelligence Tool.

This training will be based on core practical concepts with the help of different case studies on the phenomenal changes of data over the period.

Tools used in the Advanced MIS Training

financial modelling course
  • Microsoft Excel (2007 / 2010 / 2013 / 2016 / 2019/ Office 365)
  • Microsoft Access (2007 / 2010 / 2013 / 2016 / 2019)
  • Python with Pandas and Matplotlib
  • Python NumPy, SciPy, XLRD & Jupiter
  • Python Pandas Framework to handle stats
  • SQL Queries, Procedures & Triggers
  • SQL Join (Left, Outer & Inner) with DDL, DML, DCL & TCL
  • VBA (EXCEL + ACCESS)
  • Dynamic Dashboard Preparation
  • Presenting with Power Point
  • Story and Dashboard Creating using Tableau and Matplotlib

Topics Covered Under Advanced MIS Training

MS EXCEL PART

Focus on real scenarios of Reporting / Data Management / Automation, Difference between basic and advance Excel, Excel Basics, Excel Settings, Advanced Formulas, Name Manager, Absolute and Relative fields, Goal Seek / Scenario, Managing Lists, Cross Reference (Absolute & Relative)

Advanced MIS Training PART

Conditional formatting, User Settings for Excel Application Level, Data Management and Analysis, Reporting Techniques, Pivot Table, Macros, Concepts of VBA, Excel Data Handling with VBA, Use of SQL Queries, Userform, Listbox, Combobox, Buttons etc., Application Design

DATA FILTERING / DATA FORMATTING Advanced MIS Training

Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel

ADVANCE EXCEL SECURITY

Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customised user access

FORM BASED

Advanced MIS Training Database, Tables, Fields and Properties, Form Properties, Variables, Functions, Modules, Subroutines, Conditional Validations, Using Other ActiveX Tools like, Calendar, Watch, PDF..., Looping Constructs (While, Do While, For, Foreach, If Else, If then else...) Functional Parameters

DATA ACCESS PARTS

SQL Queries, Reports and Data Management, VBA Programming and Data Management Forms, Reports & Application Design

Various MIS Techniques Under Advanced MIS Training

Advanced MIS Training Get an overview of different Analytical Process, Differentiating Modules, Sub-Modules, Procedures, Data handling with the help of Access, ACCESS Forms and Reports, Writing Access Queries, Reporting and Formatting by different angles, Macro generation and application, design, Writing custom queries as per the need, Fundamentals of data handling, MIS, EXCEL and Access, Using of Developer Tools to Excel Worksheet, Using of ActiveX tools to Excel, Worksheet, Using of Developer tools to VBA Programming, Enabling / Disabling ActiveX Tools to VBA

USING CHARTS / GRAPHS / PIVOT CHARTS / PIVOT TABLE

Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data

DATA SOURCE

Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data

RETRIEVING DATA FROM SINGLE TABLE

Integration of Database, Connecting to a DBMS Using the SQL Procedure

DATA Connectivity

Connecting to a excel Using the SQL Procedure, Connecting to a access Using the SQL Procedure, Connecting to a DBMS Using the DSN

ACCESS

Creating Tables / Queries / Forms, Insert / Update Statement, User Form / Field Updation, Multiple SQL Statements, The SQL Procedure, The Access Procedure, Requirements to Connect to a Database

ODBC

Understanding how to use the ODBC with Excel, Set up a data source for a database driver, Defining the ODBC API, ODBC Terminology, Defining the Data Source Manager, ODBC Driver, Data Source

Using MS ACCESS under Advanced MIS Training

Access User Interface Advanced MIS Training

Access Ribbon,File, Save a Database as Templates, Home, Create, External Data, Database Tools, Contextual Tabs, Quick Access Toolbar, Object Navigation Pane, Access Work Surface, Access Option Dialog Box, Object Overview, Tables Queries, Forms, Reports, Macros & Modules, Process Overview, Exercise: Getting Around the Access Environment, Create Database using a wizard

Fundamentals

Advanced MIS Training Approach to Database Design, Top down Database Design, Bottom up Database design, Reality, Gather Information, Data Mapping, Sample Data Map, Normalization, First Normal Form, Second Normal Form, Third Normal Form, Table Relationship

Table & their View

Datasheet View, Selection Tools, Table Layout Tools, Sorting & Filtering Tools, Print Records, Record Navigation, Working in Datasheet View, Working with Table in Datasheet View, Design View, Open a table in Design View, Design View layout

Tables

Creating an Access Database, Creating a New Database, Data Types, Determine Data Type, Create a Table in Design View, Delete a Fields, Rename a Table, Linking Table from External Source, Import table from other database, Tables and Templates and Application Parts

Queries

Definition & Purpose, Types, Views, Select Queries with criteria, Logical Operators, Group & Total with Queries, Total Row with group By, Action Queries, Make Table Queries Append , Queries, Update Queries, Delete Queries Creating Crosstab Queries, Delete Queries, Rename Queries

Form

Advanced mis training Definition & Purpose, Layout Design & Views, Adding a Header & Footer, Adding Logo to the Header, Adding a Title to the header, Arranging Filed on a form, Spacing Objects o a form, Alter a Form, Remove form Control, Format Forms, Adding Data Record in Form View, Form Record Navigation, One Click Forms, Basic Data Entry Form, Datasheet Form, Split Form, Create a Form with Form Wizard

Reports

Definition & Purpose, Views, Report Header, Page Header, Group Header, Details Group Footer, Page Footer, Report Footer, Adding a Report Header/Footer, Adding a logo to the Header, Adding a Title to the Header, Adding fields to Reports, Add Calculated Fields, Arranging Fields on a Report, Resizing the Details Sections, Grouping 7 Sorting, Setting Properties on a Report, Report Property Setting, Section Property Sheet, Object Property Sheet, Adding Records Counts, Special Report Fields, Dates, Page Numbering, Controls, Application Parts, Deleting a Report, Formatting a Reports, One Click Report, Formalize the Relationship between Tables

Relationship

Data Type and Relationship, Views, One Click Report, Formalize the Relationship between Tables

Macro

Open a Table, Form and Record, Run a Query, Print a Report, Running a Macro, Creating Simple Macros

Creating the Applications under Advanced MIS Training

The Navigation Form, Running Macros from a Navigation Form, Setting the Navigation Form as a Default Form, Creating a navigation Form, Splitting the database, Encrypt with password, Distributing the Front-End Database, Database Maintenance, Compact & Repair, Backup recovery a database, Maintain Backup Compatibility

Visual Basic for Applications (VBA)

  • MS Office is supported by Visual Basic for Applications (VBA), an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components.
  • Learn using vba for all microsoft applications like word, excel, power point and outlook.

DASHBOARD AREA under Advanced MIS Training

Dynamic Dashboard preparation, Using Developer Controls over Charts, Graphs and Tables, Using Dynamic Data Table, Power Pivot, SQL Plugins, Creating, Installing and Using Different Plug-Ins, Creating your own Tools, Creating Story and Dashboard using Tableau

CASE STUDY & ASSIGNMENTS

  • Work on various real time scenario to make you perfect with all above learning;
  • Collection of 10 different case studies to make you perfect;
  • A set of more than 50 assignments will grasp your intensity towards data analysis.

Who Should Attend

  • Freshers, who wish to make career in data analysis;
  • Data architects, who want to develop dynamic applications and
  • “Power Users” can use it to build software applications, like other Office applications.

Pre-requisites

  • Basic knowledge of Excel as well as;
  • Basic Knowledge of Database;
  • Core Programming knowledge will have added advantages
  • Knowledge of stats will add additional skill to your profile

What You Need To Bring

Notepads, Laptop, Pen / Pencil

Key Takeaways

  • Microsoft office specialist Certification
  • Certification from Python for Data Analyst
  • Tableau Desktop Certification from Tableau
  • In-depth knowledge of handling multiple database
  • Able to design and automate fully functional dashboard
  • Able to Analyse complex data sets
  • Customize the report as per the requirement

About Trainer

  • Over 17+ years of experience in Data Analysis, reporting and customization
  • Microsoft VBA Expert Certified
  • Microsoft Office Specialist Certified
  • International Training exposure of more than 100 corporate trainings
  • Member of IFCA, AIMA
  • Contributed to several studies on financial and man-power management
  • Certifications of PMP, Six-Sigma, MS Project specialist
  • Contact us
python data science

Leave a Reply

Your email address will not be published. Required fields are marked *

Welcome to ACLM. Registration open for Advanced Excel, VBA, SQL & MIS + FREE Tableau. Register now.

X