Big Data & Artificial Intelligence 101

Enroll in this training and receive a one-month complimentary e-learning subscription with access to 40+ courses.
This course is provided by Big Data Trunk for Stanford Technology Training Program but a limited few seats available to the public.

Students of this class may have opportunity to be considered for Internship with Big Data Trunk.
Explore ways to enhance productivity with Microsoft Copilot. This hands-on course introduces how AI features in Word, Excel, Outlook, Teams, and PowerPoint can assist with automating tasks, generating content, and analyzing data within Microsoft 365.

Learning Objectives:
Participants will have the opportunity to:
- Understand the capabilities and limitations of Microsoft Copilot.
- Utilize Copilot in Microsoft Word to generate, summarize, and refine content.
- Leverage Copilot in Excel for data analysis, formula generation, and insights.
- Enhance email and scheduling efficiency with Copilot in Outlook.
- Improve collaboration and meeting productivity using Copilot in Teams.
- Use Copilot in PowerPoint to create AI-generated presentations.
- Implement best practices for AI-assisted work automation.

Topic Outline:
Introduction to Microsoft Copilot
- Overview of Microsoft Copilot and its AI capabilities
- Understanding Copilot¿s integration across Microsoft 365 apps
- Ethical and security considerations when using AI-powered tools
Copilot in Microsoft Word: AI-Powered Writing and Editing
- Content generation and refinement
- Summarizing and reformatting documents
- Hands-on: Creating and enhancing reports with Copilot
Copilot in Microsoft Excel: AI for Data Analysis
- Automated data insights and visualization
- Generating and explaining complex formulas
- Hands-on: Analyzing datasets and creating reports with Copilot
Copilot in Microsoft Outlook: Smarter Emails and Scheduling
- AI-assisted email drafting and summarization
- Scheduling and managing meetings efficiently
- Hands-on: Automating email and calendar tasks with Copilot
Copilot in Microsoft Teams: Enhancing Collaboration
- AI-powered meeting notes and action items
- Summarizing chat discussions and key takeaways
- Hands-on: Using Copilot to improve team collaboration
Copilot in Microsoft PowerPoint: AI-Generated Presentations
- Creating presentations with AI-generated content and design
- Automating slide formatting and improvements
- Hands-on: Building a professional presentation with Copilot
Best Practices for Using Copilot in Workflows
- Optimizing Copilot for everyday tasks
- Understanding AI limitations and when to verify outputs
- Hands-on: Applying Microsoft Copilot in a real-world work scenario
Training material provided: Yes (Digital format)
Prerequisites
You must have a Microsoft Copilot license to participate in any hands-on exercises.

• If you do not have an MS Copilot license, for Stanford affiliates, visit the Microsoft 365 Copilot Ordering Instructions page for step-by-step instructions. For non-Stanford affiliates, you can get started here https://copilot.microsoft.com/. You can also get a free trial at https://www.microsoft.com/en-us/microsoft-365-copilot/pricing/individuals.
• If you have A Microsoft 365 account that includes Copilot or a Microsoft 365 account along with a Copilot Pro subscription. When you open one of the Microsoft 365 apps, you should see the Copilot icon on the far-right side of the ribbon.
• Pre-requisite: Basic familiarity with Microsoft 365 applications (Word, Excel, PowerPoint)

Enroll in this training and receive a one-month complimentary e-learning subscription with access to 40+ courses.

This course is provided by Big Data Trunk for Stanford Technology Training Program but a limited few seats available to the public.

Students of this class may have opportunity to be considered for Internship with Big Data Trunk.

Program Description
Whether you’re collecting customer feedback, performing employee evaluations, or planning an event, the first step toward creating an effective survey is to brush up on the basics of survey science. Check out our resources for online survey tips and best practices to make sure your next survey is a success!
Learning Objectives:

• Why survey?
• How to strategically plan your survey
• Understand the best practices for survey design
• Review collection techniques to get the best response rate
• How to analyze, present and share the findings
• Determine which online tool is best for your survey

Topic Outline:
Planning

• Formulating the problem or question to be answered
• Determining the research approach
• Setting objectives for information collection

Design

• Choosing a collection method (Qualtrics, Google Forms, or SurveyMonkey)
• Tips for good visual design
• Types of questions/response alternatives
• Pretesting and pilot testing
• Pitfalls to avoid
• Good question test - is it clear, easy answerable, unbiased?

Collection

• Collecting responses
• Statistical significance

Qualitative vs. Quantifiable

• Improving response rates and retention

Analysis & Reporting

• Filtering and customizing results
• Sharing results

Date & Time:
3/25/2026 :9am - 12 pm PST
3/26/2026 : 9am - 12 pm PST

Enroll in this training and receive a one-month complimentary e-learning subscription with access to 40+ courses.

This course is provided by Big Data Trunk for Stanford Technology Training Program but a limited few seats available to the public.

Students of this class may have opportunity to be considered for Internship with Big Data Trunk.

This course covers everything from the basics to practical projects. Our hands-on labs ensure you gain real-world experience, and you will leave with the ability to connect to organizational data and create impactful dashboards.
Prerequisites:
- Basic understanding of Databases
Learning Objectives:
- Understand the Power BI ecosystem, including its tools and workflow.
- Extract data from diverse sources such as Excel, CSV, SQL, and the web.
- Master data cleaning and transformation using the Power Query Editor.
- Create reports and visualizations in Power BI Desktop.
- Develop data models with relationships and calculated measures.
- Explore advanced visualizations like maps and custom visuals.
- Utilize filters, slicers, and drill-through options for data exploration.
- Build and format dashboards for effective data storytelling.
- Participate in hands-on project labs to apply your skills.
- Learn about security, app creation, and data connections in Power BI.
Course Outline:
Day-1
Introduction
- What is Power BI?
- What are the Key Tools?
- Typical Workflow
- Power BI Terminology
Extracting Data
- Extracting the data (Excel, .csv, SQL, web)
- Transforming the Data
- Exploring the Power Query Editor
- Applied Steps
- Working With Queries
- Applying Transformations
- Loading Queries
Power BI Desktop Interface
- Report
- Visualizations
- Fields and Filtering
- Formatting and Analytics
Exploring the Data View
- Categorizing Geographical Data
- Formatting Dates
- Controlling Summarization Behavior
Reviewing the Data Model
- What is a Data Model?
- Examine Existing and Creating New Relationships
Measures and Calculated Columns
- Creating Calculated Columns
- Creating simple DAX measures
- Creating a Date Table
- Creating a Dates Table
Day-2
Explore the Visualization Menu
Review a Sample Report
Develop a Report Storyboard
Create and Format Visuals and Pages
- Column and Bar
- Pie
- Adding Pages
- Line
- Matrix
- Formatting Pages
- Maps
- Other Available Visuals
Drill Through Relationships
Using Filters and Slicers
Using Custom Visuals & the Marketplace
- Organizational Visuals
- Additional Page Elements
Create Other Objects in Reports
- Buttons
- Shapes
- Images
- Bookmarks
Publishing the Report
- Establishing a Workspace
- Personal and App Workspaces
Introducing Power BI Service
- App Workspaces
- Create and Format Dashboards
- Get Data
- Update Dashboard
Create and Maintain Apps
- Setting Security
- Finding other Apps
- Connect to organizational data
- Project Labs

Date & Time:
4/14/2026 9-12 AM PST
4/16/2026 9-12 AM PST