AI in Business Analytics

Investment

Rs. PKR 65,000 + Tax

Key Topics

Day 1 – Mastering Business Analytics with Excel & Power Tools

Session 1: Beyond Basic Excel – Transforming Business Data

• Data types, business use cases, formulas & functions
• Excel tips for data accuracy, speed & efficiency
• Use cases in Finance, Marketing, HR, and Supply Chain

Session 2: Data Cleaning & Transformation with Power Query

• Importing data from multiple sources
• Data shaping, transformation, and merging
• Real-life problem-solving using Excel & Power Query

Session 3: Visual Analytics with Excel Dashboards

• KPI dashboards for performance tracking
• Conditional formatting, charts, slicers
• Mini project: Build a business dashboard in Excel

Session 4: Data-Driven Decision Making Frameworks

• Strategic decision-making using data models
• Introduction to Business Intelligence and next-gen analytics

Day 2 – Introducing AI in Business Analytics

Session 5: Getting Started with AI in Business

• AI vs traditional analytics: What changes?
• No-code & low-code AI tools for business users
• ChatGPT, Microsoft Copilot, and AI-powered Excel features

Session 6: Predictive & Prescriptive Analytics

• AI-powered forecasting models
• What-if analysis using AI
• Using AI to recommend business decisions

Session 7: Automating Business Intelligence with Power BI & AI

• Live dashboards using Power BI
• Integrating Excel, Power BI, and AI tools
• Case-based walkthrough: Sales & Marketing Dashboard with AI insights

Session 8: Capstone Exercise & Discussion

• Final hands-on activity: Build and present an AI-enhanced business dashboard
• Group presentations and expert feedback
• Action Plan: Applying insights in your organization

Learning Outcome

Through hands-on experience, you'll gain in-depth knowledge of ERP Systems Applications and Products (Oracle & SAP) including:

• Oracle Financials & Supply Chain Modules
• SAP Financials & Supply Chain Modules
• Oracle Business Intelligence
• Power BI Interactive Data Visualization Tool

Eligibility Criteria

Candidates who've already completed Bachelor's degree with practical / professional skills (Females are encouraged to apply)

Program Fees

Program Fees: PKR/- 105,000 (Including 5% SST)

10% discount is offered if full fee is paid in advance

Advance Payment Schedule	Total
Total fee in Advance (Lumpsum)	PKR/- 94,500

Installments Payment Schedule				Total
Total Fee (if paid in 3 equal installments)	PKR 35,000	PKR 35,000	PKR 35,000	PKR/- 105,000 (Including 5% SST)

Fee Includes:

Processing fees, Test and Exam Fees, Diploma and Transcript. Fees do not include course material, books and stationery.

Admission fees PKR 1000/-

Payment

Payment is due upon receipt of the acceptance of participants to the program along with the invoice.

Please ensure that the payment reaches the CICT Office before commencement of the program because seat in the class will only be reserved once the fee is received.

Payment can be made via cheque / bank draft payable to the "Institute of Business Administration, Karachi" at the following address:

Center for Information & Communication Technology (CICT)
IBA, City Campus, Garden/Kayani Shaheed Road, Karachi.

For online payments via credit cards: https://onlinepayment.iba.edu.pk/

Duration

• 4 months including 6 courses (per course/24 Training Hours)
• Saturday & Sunday

Who Should Attend?

This workshop is ideal for:

• Business Managers & Analysts
• Strategy & Transformation Teams
• Finance, Sales, HR & Operations Professionals
• Professionals looking to move from Excel to AI-enabled insights.

• Four Months
• Friday 6:00 pm to 9:00 pm
• Saturday 10:00 am to 1:00 pm and 2:00 pm to 5:00 pm