iSAP 1 Year - Innozant MIS & Data Analytics

Administrator Expert

Description

Innozant Skill Achiever 1 year Program

MS Advanced Excel + SQL Analytics + MS Power BI + VBA Macros + Data Analytics Using python. 

Innozant brings you 1 Year Skill Achiever Program (iSAP) Training to impart the necessary and demanded MIS skills. Here we give you insight about what Industry expects from its employees, thus empowering them to acquire industry specific trainings and develop right aptitude and technical competence. Our certification programs targets graduates/ under-graduates student and those working professionals who either want to enter or switch into the vast field of MIS and Data Analytics.

What you will learn:

  • Build a solid understanding on the Basics of Microsoft Excel
  • How to use Workbooks and Worksheets
  • How to avoid the most common Database Design flaws
  • Functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
  • FILTER, XLOOKUP, SORT & UNIQUE functions
  • Learn several hidden Excel tips and tricks
  • Learn to use Charts, Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
  • Learn to make dashboards.
  • Create, design, and operate with SQL databases
  • Insert, Update, and Delete records from your database
  • Handle complex SQL joins with ease
  • SQL’s triggers, sequences, local and global variables, indexes, and more
  • Become a proficient SQL user by writing flawless and efficient queries
  • Power BI Desktop and its components
  • How to use the Query Editor  & Data Model
  • Calculated columns and measures
  • Build relationships between different tables
  • Create a report with different interactive visualization types
  • Power BI Service(= Power BI Pro) to create dashboards and to share and publish your results
  • Creating macros and streamline your VBA code
  • Macro Recorder versus VBA
  • Custom VBA Macros to create more robust automation
  • Learn VBA programming concepts to create dynamic, re-usable code.
  • Complete real world Macro/VBA projects from beginning to end.

Download Brochure

Topics for this course

199h 59m 59s

Training duration : 12 months

MS Advanced Excel

SQL Analytics

MS Power BI

VBA Macros

Data Analytics using Python

30,000.00
  • Course level: Expert
  • Duration 199h 59m 59s