Chandrasekaran Ashokkumar Assignment7

Homework 7: AI-Assisted Data Analysis using MCP Servers Student Name: Ashokkumar Chandrasekaran Course: Data Analytics / Business Intelligence Assignment: Homework 7 – MCP Server Benchmarking This video demonstrates: • Successful configuration of MCP servers in Claude Desktop • Connection to AdventureWorks2022 (OLTP) database • Connection to AdventureWorksDW2022 (Data Warehouse) database • Natural language data analysis using AI-assisted SQL generation • Human-in-the-loop SQL validation • Benchmark comparison between OLTP and Data Warehouse query results Topics demonstrated: 1. Listing database tables 2. Total sales by year 3. Top selling products 4. Monthly sales trends 5. Sales by territory/country Tools Used: • Claude Desktop • MCP Server • Microsoft SQL Server • SQL Server Management Studio (SSMS) • AdventureWorks2022 • AdventureWorksDW2022 • Microsoft Excel Video visibility: Unlisted