Data Analytics Course ▷ 100% Job Guarantee ▷ Free Python Data Science ▷ SLA Institute

Job Oriented Short Term Basic & Advance Excel Course

MIS & Data Analysis in Excel

   

What is Excel?

Basic/Advanced Underst&ing of Excel, Introduction to Excel, Basic Underst&ing Menu & Toolbar, Introduction to a different category of functions like Basics, Mathematical & Statistical, Date & Time, Logical, Lookup & References, Text & Information.Mathematical Functions, Date & Time Function, Text Functions & Data Validation, Logical Functions

Macros | VBA & Dashboard

DASHBOARD & VBA / Macros Programming Objective, High-Level Overview of the Business, Define KPIs, Customer Service Dashboards, Programming Introduction, Events, Preparing to ‘Macro’, VBE – Features, Options, Intelligence Technology, Debugging Mode, Establish Connection Between – VBA & Internet Explorer, Excel VBA & power presentation to create power point, Excel VBA & Access database to update the data in access

MS – Access & SQL

Access is a relational database management system (RDBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface & software-development tools.

Access environment & tools, RDBMS, Create Query, Data Migration & Importing, Adding Design side & runtime of Queries, Design side of Forms, create a functional specification

Python

Introduction to Python Programming, Basics of Python , Accessing Data, Creating Data Sets, Data Step Processing, Advanced Python , Data Processing, Accessing Data using SQL, Python DI Studio, Data Integration, Data Structures, Data Validation, Propagation and mappings, handling for transformations and jobs, Table Loader transformation, slowly changing dimensions

Power BI

Getting started with Power BI, Overview of Power BI, Power BI Architecture, Installation & Configuration of Power BI, Connecting the Data from multiple database (Excel, SQL, MS Access), Power BI Dashboard, Managing Metadata, Parameters & Formatting, Sorting, Filtering & Grouping, Managing Extracts, Data Sources, Cross-Database Joins Data Aggregation & Data Ports

Contact for Course Details

 

 

 

MIS & Data Analytics

What is the correct answer for 22 + 19