Data Analysis – INI-TECHNOID SERVICES

BEGINNER CLASS

Introduction to Excel, its interface, and navigation along with basic data entry and cell formatting.
Managing workbooks, worksheets, and data organization techniques like inserting, deleting, and renaming sheets.
Understanding and working with basic mathematical, logical, and lookup functions, as well as understanding formula syntax and structure.
Techniques for sorting, filtering, and using advanced filtering options in Excel, including AutoFilter and Power Query.
Use of conditional formatting, PivotTables, Pivot Charts, and best practices for visualizing data.
Importing and exporting data from various sources, and cleaning and transforming imported data.
Use of \”What-If\” scenarios, Data Tables, Goal Seek, Solver, and Scenario Manager for data analysis.
Introduction to, recording, running, and debugging macros, with a focus on best practices and security considerations.
Sharing workbooks, using Excel in the cloud, and methods to protect and review work.
Advanced functions, dashboard design, Excel and Power BI integration, and leveraging the Excel Developer tab for customization.

ADVANCED CLASS

Analyze data to reveal business insights and trends to make good business decisions with the aid of Tableau & PowerBI
How to design a loan management system, and dynamic data base system.
Transform bulk and raw data(data sets) into meaningful Charts and Visualizations
How to create interactive dashboards and visualization.
Build a company’s P&L from scratch
Perform 3 statements financial analysis
Understand the dynamics of the Time Value of Money (PV, FV, PMT)
Perform Trend Analysis, Comparative Analysis, What-If Analysis and Forecasting
Calculate a complete amortization table (loan schedule)
Using empathy to create positive interactions and being in charge of your customers’ experience
Explore different methods to handle upset customers
Analyze customer feedback to help your team optimize your company’s products and services

Cost For Data Analysis Classes

^₦ 75,000/Month

^₦ 80,000/Month