AI-Assisted Power BI for Business Analytics

Pamplin College of Business

The analytics landscape is undergoing a fundamental shift. AI-powered tools like Microsoft Copilot are transforming how business professionals interact with data, from writing formulas to having conversations.

"A Power BI report is not the deliverable. Insights are."

Course Team

Viswanath Venkatesh

Eminent Scholar and Verizon Chair

Instructor

vvenkatesh@vt.edu

vvenkatesh.com

Fabio Correa

Director of Advanced Business Analytics, Microsoft

Industry Teaching Assistant

fabioc@microsoft.com

Schedule Office Hours

Course Materials

๐Ÿ“‹ Syllabus

Course structure, grading policies, and detailed session-by-session outlines covering all six modules.

๐Ÿงช Labs

Hands-on exercises where you'll work directly with Power BI Copilot to build reports, analyze data, and discover insights.

๐Ÿ“ Research Labs

๐Ÿ“Š Case Studies

Real-world business scenarios for analysis and discussion, from cloud revenue optimization to enterprise governance.

โ˜• Starbucks Live Case

Your capstone project: analyze real Starbucks data and present actionable recommendations to an executive audience.

๐Ÿ“ Templates

Reusable document frameworks for prompting journals, executive summaries, and project deliverables.

๐Ÿ“š References

Supplementary learning materials including Microsoft Learn paths, documentation, and recommended readings.

๐Ÿ“Š AI Readiness Assessment

This course includes a longitudinal research component measuring your AI readiness at the beginning and end of the semester. Your responses contribute to ongoing research on AI adoption in business education.

Pre-Course Assessment

Complete during Module 1 (first class session)

Take AIRS-16 Assessment ~5 minutes

Post-Course Assessment

Complete during Module 6 (final class session)

Retake Assessment ~5 minutes

AIRS-16 is a validated instrument (N=523, CFI=.975) built on Dr. Viswanath Venkatesh's UTAUT2 framework. It measures eight dimensions of AI readiness including Performance Expectancy, Trust in AI, and Hedonic Motivation.

What You'll Learn

๐Ÿ’ฌ

Query Data Through Conversation

Use Copilot's natural language interface to explore, filter, and summarize business data without writing code.

๐Ÿ“Š

Generate Reports with AI

Build professional dashboards by prompting Copilot, iterating on outputs, and refining results.

๐Ÿ”

Discover Hidden Patterns

Apply AI visuals (Key Influencers, Smart Narratives, Anomaly Detection) to surface insights that traditional analysis might miss.

๐ŸŽฏ

Critically Evaluate AI Outputs

Assess AI-generated insights for accuracy, relevance, and business applicability.

๐Ÿ“

Communicate Insights

Synthesize findings into executive summaries that answer business questions and recommend actions.

๐ŸŽค

Present to Leadership

Deliver actionable recommendations to a real executive audience in the Starbucks live case.