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
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
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
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
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