null

Course Overview

Our Power BI course in Kolkata mirrors the exact reporting workflow used by analytics teams inside Candor TechSpace, Bengal Intelligent Park, and the insurance back-offices along Park Street, from connecting raw data to publishing a dashboard the whole team can act on.

  • Power BI Desktop & Data Modelling

    Connect to Excel sheets, SQL databases, and CSV exports, then build relationships between tables the way BI teams at TCS, Cognizant, and Genpact structure client reporting models inside their Sector V and New Town delivery centres.

  • Power Query & Data Cleaning

    Merge, filter, and reshape messy exports from multiple systems into one clean dataset, a daily task for MIS teams at Kolkata's insurance and NBFC back-offices reconciling policy, claims, and premium data every reporting cycle.

  • DAX, Measures & Time Intelligence

    Write DAX formulas for running totals, year-on-year growth, and KPI targets, the calculations e-commerce and quick-commerce operations across Kolkata use to track daily order volumes and delivery turnaround by locality.

  • Interactive Reports

    Design drill-down reports with slicers, custom tooltips, bookmarks, and navigation buttons the polish that separates a static spreadsheet from a dashboard a Sector V client actually wants to open every morning.

  • Power BI Service

    Publish workspaces, set up scheduled data refresh, and manage row-level security in Power BI Service, essential when a report has to update automatically for hybrid teams working across Salt Lake and remote client sites.

  • Live Capstone Project

    Build filled maps and shape maps to track performance by district and locality, then apply everything on a capstone dashboard modelled on a real Kolkata business case in retail, logistics, or insurance reporting.

Course Syllabus

Lecture 1 : Introduction to Power BI
Lecture 2 : Prepare Data in Power BI
Lecture 3 : Publish Power BI
Lecture 4 : Service Power BI
Lecture 5 : Desktop Tooltip Reports & Slicers in Power BI
Lecture 6 : Buttons & Bookmarks in Power BI

Module Benefit

Module Benefits:

Artificial Intelligence (Al) | Allows Analysis and Sharing of Big Data Personalized Dashboards and Interactive Reports | Access to Information in Real-time | Excel integration | Profuse Data Sources Support and Integration | Interactive UI/UX Features

Lecture 1 : Flash Fill & Data Validation
Lecture 2 : Advanced Conditional Formatting
Lecture 3 : ASAP Utilities
Lecture 4 : Lookup Functions
Lecture 5 : Match & Index
Lecture 6 : Dynamic Viookup
Lecture 7 : Data Table
Lecture 8 : Solver
Lecture 9 : Financial Functions
Lecture 10 : Sort & Filter
Lecture 11 : PowerPivot
Lecture 12 : Dashboard Creation
Lecture 13 : Power Map & Power Query
Lecture 14 : Macro
Lecture 15 : Array Functions
Lecture 16 : Google Drive
Lecture 17 : Mail Merge

Module Benefit

Module Benefits:

By understanding Advanced MS Excel Course, students will have the ability to use more sophisticated functions, which will allow them to analyse complex and large volume of data to present meaningful information helping in decision making.

Lecture 1 : Hello to Google Drive
Lecture 2 : Introduction to Google Sheet
Lecture 3 : Google Sheet Protection
Lecture 4 : Combine Data from Multiple Google Sheet
Lecture 5 : Google Slides
Lecture 6 : Google Form
Lecture 7 : Google Mail Merge
Lecture 8 : Google Cloud Printing

Module Benefit

Module Benefits:

Domain-based email | Improved team collaboration | Video conferencing | Enhanced data security and Privacy.

Lecture 1 : Google Data Studio
Lecture 2 : Creating Charts & Graphs
Lecture 3 : Filters & Controls
Lecture 4 : Custom Fields
Lecture 5 : Chart Styling
Lecture 6 : User Management: Sharing your Reports

Module Benefit

Module Benefits:

Access unlimited widget options | Pull data from multiple sources | Share Data Studio reports easily | Create easy-to-read reports for everyone | Get dynamic reporting | Build interactive experiences

Lecture 1 : Macro
Lecture 2 : Introduction to VBA
Lecture 3 : Working with Procedures & Functions
Lecture 4 : Customizing the VBA Environment
Lecture 5 : Understanding the Objects
Lecture 6 : Variables & Intrinsic Functions
Lecture 7 : Controlling Program Execution
Lecture 8 : Debugging Code & Handling Errors
Lecture 9 : VBA Programming Functions
Lecture 10 : Excel Form Control & ActiveX
Lecture 11 : Working with Forms & Controls

Module Benefit

Module Benefits:

Automates repetitive and routine tasks | Accessibility to other users | Reduces the formulas burden used in Excel reports | Reduces the turnaround time.

Lecture 1 : Introduction to SQL
Lecture 2 : Platforms to execute SQL codes
Lecture 3 : Creating a table
Lecture 4 : Data insertion
Lecture 5 : Auto increment and primary key
Lecture 6 : Alter table
Lecture 7 : Delete
Lecture 8 : Update
Lecture 9 : Top clause
Lecture 10 : String functions
Lecture 11 : Aggregate functions
Lecture 12 : Constraints
Lecture 13 : SQL join
Lecture 14 : Insert sub-query
Lecture 15 : Delete sub-query

Module Benefit

Module Benefits:

Commonality & Simplicity | Integrate easily with other programming languages | Ability to function at a high operating speed | No need of complex coding skills for data extraction.

Watch a Dashboard Get Built From Scratch

Join a free live demo class at our Kolkata centre and see raw data turn into an interactive Power BI report before you commit.

Reserve Your Free Demo Seat

Demand for Power BI Course in Kolkata

  • Sector V & New Town's IT Corridor

    Candor TechSpace, New Town hosts TCS, Cognizant, and Genpact BI teams; HCLTech, Tech Mahindra, and IBM run analytics from Sector V's SDF Building and Bengal Intelligent Park.

  • BFSI & Insurance Back-Offices

    Tata AIA Life, Axis Max Life, Kotak Mahindra Life, and LIC HFL run Kolkata back-offices needing Power BI staff for policy, claims, and premium MIS reports.

  • Quick-Commerce & E-Commerce Growth

    Blinkit, Zepto, Amazon, Flipkart, and Swiggy are scaling fast across Kolkata, each running live dashboards for order volume, delivery SLAs, and inventory by micro-market.

  • BPO-to-Analytics Shift at Concentrix & Genpact

    Concentrix, Teleperformance, and Genpact's Kolkata BPO floors are expanding into analytics and RPA roles, with Genpact's AI Gigafactory pushing staff toward dashboard work.

Career Opportunities

Roles you're qualified for once you complete a Power BI course in Kolkata

  • Junior Power BI Analyst

    Build and refresh basic reports, clean data exports, and support senior analysts at BPO/IT floors across Sector V, New Town, and Salt Lake.

    ₹2.4 – 4.5 LPA

  • Power BI Developer

    Design dashboards, write DAX measures, and manage scheduled refreshes for delivery teams at Candor TechSpace and Bengal Intelligent Park.

    ₹4.5 – 8.5 LPA

  • BI Analyst, Insurance

    Turn policy, claims, and premium data into recurring MIS dashboards for insurance and NBFC back-offices along Park Street and Salt Lake.

    ₹4.0 – 7.5 LPA

  • Logistics Analytics Executive

    Track order volume, delivery SLAs, and inventory across micro-markets for quick-commerce and logistics firms expanding through Kolkata.

    ₹3.5 – 6.5 LPA

  • Senior BI Consultant

    Lead client-facing dashboard projects, manage data governance, and mentor junior analysts at Sector V and New Town delivery centres.

    ₹8.0 – 14.0 LPA

  • Independent Power BI Consultant

    Set up dashboards and reporting for MSMEs, trading houses, and retail chains across Howrah, Barabazar, and Salt Lake as a freelancer.

    ₹5.0 – 12.0 LPA

MIS Certification

On completing the course and clearing the final assessment, you receive a certification from ICA Edu Skills, jointly endorsed by the National Skill Development Corporation (NSDC), a Government of India body that validates the quality and industry-readiness of your training. This is the credential that Kolkata hiring managers at IT delivery centres, BFSI back-offices, and e-commerce teams recognise when they see it on a resume.

MIS Certification

Salary Insights

  • Certified freshers with Power BI skills in Kolkata start at ₹2.4–4.5 LPA, well ahead of candidates who only know Excel.

  • Power BI developers with 2–4 years of DAX and Power Query experience earn ₹4.5–8.5 LPA, the highest in Sector V and New Town.

  • Senior BI consultants with 5+ years earn ₹8.0–14.0 LPA, matching national data for experienced analytics professionals.

  • Independent Power BI consultants serving Kolkata's MSMEs and trading firms earn ₹5.0–12.0 LPA in project fees.

Sources: Glassdoor India (2025–26); Payscale Kolkata Data Analyst Report (2026); ExcelGoodies Power BI Salary Guide (2026); Naukri & Indeed Kolkata listings (2025–26)

Min salary Max salary
₹125k ₹100k ₹75k ₹50k ₹25k ₹0
Fresher
(0–1 yr)
Junior
(1–3 yrs)
Mid-level
(3–7 yrs)
Senior
(7+ yrs)
Monthly salary in ₹ · Kolkata market

Our MIS Training Institutes in Kolkata

ICA Salt Lake
Dalhousie
West Bengal, Kolkata
ICA Salt Lake
Sodepur
West Bengal, Kolkata
ICA Salt Lake
Gariahat
West Bengal, Kolkata
ICA Salt Lake
Barrackpore
West Bengal, Kolkata
ICA Salt Lake
Behala
West Bengal, Kolkata
ICA Salt Lake
Dunlop
West Bengal, Kolkata
ICA Salt Lake
Exide More (Chowringhee)
West Bengal, Kolkata
ICA Salt Lake
Jadavpur
West Bengal, Kolkata
ICA Salt Lake
Saltlake Sector V
West Bengal, Kolkata
ICA Salt Lake
Sovabazar
West Bengal, Kolkata
ICA Salt Lake
Tollygunge
West Bengal, Kolkata
ICA Salt Lake
Ultadanga
West Bengal, Kolkata
ICA Salt Lake
Joka
West Bengal, Kolkata
ICA Salt Lake
Baruipur
West Bengal, Kolkata
ICA Salt Lake
Dum Dum
West Bengal, Kolkata
ICA Salt Lake
HO IT Support
West Bengal, Kolkata

Events and Activities

  • certificate distribution
  • classroom
  • mock interview
  • practical lab room
  • students

Our Alumni  Worked At

What Our Students' Says

Sufal Ghosh
Sufal Ghosh
...

This course gave a solid foundation in MIS and analytics. Some topics were challenging at first, but the step-by-step guidance helped. More real-life case studies would be nice, but overall, it’s a great start for beginners in data analysis.

Gabber Singh
Gabber Singh
...

ICA’s MIS course gave me practical skills in Excel, dashboards, and reporting that are directly useful in the workplace. The training was hands-on and easy to follow. Thanks to ICA’s placement support, I was able to secure a job shortly after completing the course.

Ratnakar
Ratnakar
...

ICA’s MIS Analysis course provided me with strong practical knowledge in data management and reporting. The hands-on training and real-time exercises enhanced my analytical skills. Ideal for a career in management

FAQs

Frequently Asked Questions

Yes. You learn to configure scheduled refresh and real-time dashboards in Power BI Service, directly relevant to Kolkata's quick-commerce and delivery operations that track order volume hour by hour.

Yes. Power Query and DAX modules are built around consolidating multi-sheet exports, the exact task insurance and NBFC back-office teams handle every reporting cycle. You'll be able to automate reports you currently build by hand.

Yes. The interactive reports module covers slicers, tooltips, bookmarks, and navigation design the presentation-ready skills delivery teams at Candor TechSpace and Bengal Intelligent Park expect from client-facing analysts.

Absolutely. The course starts with Power BI Desktop basics before introducing DAX formulas gradually. No prior coding experience is required, and many ICA Kolkata students come from commerce and BBA backgrounds.

Yes. The Power Query module covers merging and cleaning data from Excel, SQL, and CSV sources, the exact situation MSMEs and trading firms across Howrah and Barabazar deal with before centralising their reporting.

Yes. The maps module covers filled and shape maps for district- and locality-level analysis, useful for logistics, retail, and FMCG teams tracking performance across West Bengal's districts and Kolkata's micro-markets.

Enquire Now

Share this page

Share this page’s details with your family and friends.