SideBard from Team AInsight

BrainStation Industry Day with Google

Welcome to our team's GitHub repository for the Google Industry Day competition hosted by BrainStation. First I'd like to introduce you to our diverse team of data scientists, UI/UX designers, and web developers:

• Abi Wheeler (UI / UX)
• Diane Lu (Data Science)
• Jack Speidel (Web Developer)
• Maheshi (Web Developer)
• Nima Chinikar (Data Science)
• Sam Celarek (Data Science)
• Tony Lau (Web Developer)
• Gem Ruby (Team Lead and TA)

We were given the following problem by Google to solve:

"How might we educate users of new AI-related features becoming a part of a product, while maintaining user trust and avoiding misunderstandings about AI?"

Here's a quick demo of our sidebar's aesthetics and we invite you to Play with SideBard in this Figma Prototype:

Here's a quick demo of the chatbot we customized for this purpose and we invite you to Chat with SideBard in this jupyter notebook (library dependencies are in function_source.py):

Question: How to sum all the costs of this store in sheets?

Answer: Hello Samir! To sum all the costs of a store in Google Sheets, you can use the SUM function. Here's how you can do it:

• Select the cell where you want the sum to appear.
• Type "=SUM(" in the cell.
• Select the range of cells that contain the costs you want to sum.
• Close the parentheses ")" and press Enter.

For example, if the costs are in cells A1 to A10, you would enter "=SUM(A1:A10)" in the cell. This will calculate the sum of all the costs in the specified range and display the result in the selected cell.

Please explore more of our work in this presentation. You can also find our market research, web app development, figma work, and KPI dashboard using PowerBI in the reference section below.

We appreciate your interest in our project and invite you to explore our work. If you have any questions or feedback, please don't hesitate to reach out to us at this Github or [email protected].

• Presentation
• Figma Prototype of SideBard
• Chat with SideBard (library dependencies are in function_source.py):

• Figma File
• Chatbot Creation
• Document Dataset Embedding
• Market Research Document
• KPIs with PowerBI
• Web Developer Work