Charts

Course Assistant Guide

The Defensible Decision

โ† Back to Course Materials

Learn how to get the most out of your AI-powered course assistant for labs, cases, datasets, and course materials.

๐Ÿ’ฌ What Can You Ask?

๐Ÿ”ง
Lab Help
Troubleshoot issues and get step-by-step guidance for any lab exercise.
  • "I'm stuck on LAB-03 step 4"
  • "My chart isn't showing any data"
  • "What column should I use for the measure?"
  • "How do I create a calculated column?"
๐Ÿ“Š
Dataset Questions
Explore the structure, columns, and relationships in course datasets.
  • "What columns are in SupportInsights?"
  • "How many rows in CloudRevenue?"
  • "What does NPS_Score mean?"
  • "Show me the data dictionary"
๐Ÿ“ˆ
Chart Selection
Get advice on choosing the right visualization for your data story.
  • "Which chart shows trends over time?"
  • "Bar vs line chart โ€” when to use each?"
  • "Best visual for comparing proportions"
  • "How do I show correlation?"
๐Ÿ“š
Concepts & Theory
Understand Power BI concepts, DAX patterns, and visualization principles.
  • "What's an implicit vs explicit measure?"
  • "Explain the CSAR Loop"
  • "How does filter context work?"
  • "What is a star schema?"
๐Ÿ“…
Syllabus & Schedule
Look up deadlines, deliverables, grading rubrics, and course policies.
  • "When is the midterm presentation?"
  • "What's the capstone grading rubric?"
  • "What's due in Module 4?"
  • "How much is participation worth?"
๐ŸŽฏ
Case Study Support
Get context and guidance for the four business case studies.
  • "What's the business problem in CASE-02?"
  • "What KPIs matter for Cloud Revenue?"
  • "How should I approach root cause analysis?"
  • "What's the executive audience for CASE-04?"

๐Ÿ“‚ Available Knowledge Base

Category Documents What You Can Ask
Labs LAB-01 through LAB-06, LAB-AIRS-01, LAB-AIRS-02 Step-by-step guidance, troubleshooting, expected outcomes
Cases CASE-01 Cloud Revenue, CASE-02 Executive Dashboard, CASE-03 Support Root Cause, CASE-04 Enterprise Governance Business context, analysis approach, deliverable expectations
Datasets CloudRevenue, SupportInsights, M365Marketing, EnterpriseGovernance, AIRS Longitudinal Column definitions, data types, row counts, relationships
Templates BRD Template, Capstone Guide, Prompting Journal, Executive Summary, Data Dictionary Document structure, required sections, formatting guidelines
Reference Syllabus, Class Outlines, Charting Guide, Copilot Guide, Statistics Reference Course policies, visualization principles, DAX patterns, best practices

โš–๏ธ Best Practices

โœ“ Do This

  • Ask specific questions with context ("In LAB-03, step 4...")
  • Request explanations of concepts you don't understand
  • Ask for hints and methodology guidance
  • Use follow-up questions to dig deeper
  • Ask which dataset columns to use for a task
  • Request chart selection advice for your data
  • Ask about syllabus deadlines and requirements

โœ— Avoid This

  • Asking for complete assignment solutions
  • Requesting exact DAX formulas for graded work
  • Questions about other courses or general topics
  • Asking the assistant to do your analysis for you
  • Requesting grade predictions or changes
  • Copying assistant responses as your own work
  • Vague questions without context ("Help me with my project")

๐Ÿ’ก Example Conversation

Sample Dialog โ€” Getting Lab Help
๐Ÿ‘ค
You
I'm stuck on LAB-03 step 4. My Key Influencers visual shows "no influencers found" but I have data in my table.
๐Ÿค–
Assistant
This is a common issue! The Key Influencers visual requires specific data conditions. Let me help you troubleshoot:

1. Check your "Analyze" field
Make sure you're analyzing a binary or categorical column (like Resolution_Status), not a continuous number.

2. Verify "Explain by" fields
You need at least 2-3 explanatory columns. Try adding Product_Category, Channel, and Agent_Tier.

3. Check data volume
The visual needs sufficient variance โ€” if 95% of cases have the same outcome, there's nothing to explain.

Try these steps and let me know what you see!
๐Ÿ“„ Source: LAB-03-AI-Root-Cause-Analysis.pdf, Section 4
๐Ÿ‘ค
You
I was analyzing Resolution_Hours instead of Resolution_Status. That fixed it!
๐Ÿค–
Assistant
Perfect! That's exactly the issue. Key Influencers works best with categorical outcomes like "Resolved" vs "Escalated" โ€” not continuous measures like hours.

Pro tip: If you want to analyze resolution time, create a calculated column that buckets hours into categories like "Fast (<2h)", "Normal (2-8h)", "Slow (>8h)" โ€” then use that as your analyze field.

๐Ÿš€ Pro Tips

๐ŸŽฏ
Be specific. "LAB-03 step 4" gets better help than "my chart doesn't work."
๐Ÿ”„
Use follow-ups. The assistant remembers your conversation โ€” ask clarifying questions.
๐Ÿ“–
Check citations. Every response links to source documents โ€” read them for full context.
๐Ÿง 
Learn, don't copy. Ask "how do I approach this?" not "give me the answer."
๐Ÿ“Š
Name your dataset. Specify CloudRevenue, SupportInsights, or M365Marketing for accurate help.
๐Ÿ’ฌ
Explain your goal. "I want to show regional trends" helps more than "which chart?"

๐ŸŽ“ Academic Integrity

The course assistant is designed to support your learning, not do your work for you. It will:

  • Guide methodology โ€” explain how to approach a problem
  • Clarify concepts โ€” help you understand underlying principles
  • Troubleshoot issues โ€” help you debug when things go wrong
  • Never provide complete solutions to graded assignments
  • Redirect grading or policy questions to instructors

Remember: Document your AI interactions in your Prompting Journal. This is part of your learning โ€” and your grade!