Instructor: Dr. Narendra • Pre-req: Basic Computer Literacy • Co-req: Basic Microsoft Excel
—
4
10
4 industry-aligned
Excel interface, descriptive statistics, charts, PivotTables, conditional formatting, data validation, sorting/filtering, and exploratory plots.
Hypothesis testing (t-tests, ANOVA, chi-square), regression & correlation, what-if tools, Solver, time series basics, finance functions, and VBA automation.
Power BI Desktop workflow, Power Query, data modeling, visuals (charts, tables, maps, slicers), connecting to SQL, and report design.
DAX syntax, calculated columns, measures, FILTER/CALCULATE/SUMX, relationships, cross-filtering, and KPI design.
Retail/E-commerce/Finance/Healthcare aligned labs with Excel and Power BI skills.
Retail sales (Excel), healthcare treatment analytics (Excel), sales performance (Power BI), customer behavior with DAX.
Major project, weekly analyses, communication portfolio, and leadership/collaboration.
This site is generated from the official course handout and syllabus. For institutional policies and final grading rules, always refer to the university handbook.