This is the best DAX video on youtube.

love your teaching style.. You're absolutely the best...

Where can I find the course materials for this video to follow along? Thanks.

The transcript provides the following prompt to remove fluff from ChatGPT's output: > "Whenever I asks to write or draft something, always remember to limit prose and avoid fluff." This prompt can be added to ChatGPT's memory settings to ensure that the output is concise and avoids unnecessary, flowery language

### Training Notes: ChatGPT Workshop #### 1. Introduction - **Overview of the Training Workshop:** - Introduction to the concepts and practical uses of ChatGPT. - Objectives: Understanding generative AI, using ChatGPT effectively, and exploring advanced features. - **Trainer’s Background:** - Gerald H, CEO and Lead Trainer at GemRain Consulting, with extensive experience in AI and technology training. --- #### 2. Generative AI and ChatGPT Overview - **Definition and History of Generative AI:** - Generative AI refers to algorithms that can create new content, including text, images, and music. - History: Development from early AI models to advanced versions like GPT-3 and GPT-4. - **Introduction to ChatGPT:** - Launched by OpenAI in November 2022. - Capable of understanding and generating human-like text. - **Comparison with Other Platforms:** - **Google Gemini:** Focuses on multilingual capabilities and integration with Google services. - **Claude:** Emphasizes ethical AI and user safety features. --- #### 3. Getting Started with ChatGPT - **Creating and Managing Accounts:** - Step-by-step guide on creating a ChatGPT account. - Differences between free and paid versions. - **Free vs. Paid Versions:** - Free Version: Basic access with usage limits. - Paid Version (ChatGPT Plus): Enhanced features, priority access, and higher usage limits. - **Accessing and Using ChatGPT Interface:** - Navigation through the user interface. - Key features and functionalities. --- #### 4. Prompt Engineering - **Basics of Prompt Engineering:** - Definition: Designing effective queries for desired outcomes. - Importance: Clear and specific prompts lead to better responses. - **Crafting Effective Prompts:** - **Clarity:** Ensure prompts are unambiguous. - **Specificity:** Be precise about the information needed. - **Context:** Provide background information to guide responses. - **Common Issues and Solutions:** - **Ambiguous Prompts:** Add details to avoid vagueness. - **Complex Queries:** Break down into simpler questions. - **Bias in Responses:** Use neutral prompts and flag inappropriate outputs. - **Examples of Prompts and Responses:** - **General Information:** "What are the benefits of a balanced diet?" - **Technical Explanation:** "How does blockchain technology work?" - **Creative Writing:** "Write a short story about a lost cat." - **Practice Exercise:** - **Improving Prompts:** Refine vague prompts to be more specific. - **Sequencing Prompts:** Break down complex queries into steps. --- #### 5. Advanced Features of ChatGPT - **ChatGPT Plus and GPT-4:** - **Benefits of Upgrading:** Enhanced performance, faster responses, extended usage limits. - **Subscription Details:** Cost and how to upgrade. - **Comparison Chart:** Features in free vs. paid versions. - **Advanced Data Analysis:** - **Using the Paperclip Button:** Upload and analyze documents. - **Practical Applications:** Analyzing business reports, research papers, and legal documents. - **Integrating with Cloud Storage:** - **Overview:** Connecting with Google Drive, OneDrive, etc. - **Benefits:** Ease of access, collaboration. - **Setup and Usage:** Steps to link and use cloud storage with ChatGPT. - **Examples:** Summarizing and analyzing documents stored in cloud storage. --- #### 6. Microsoft’s Role in Generative AI - **Microsoft and OpenAI Partnership:** - **Overview:** History and goals of the partnership. - **Impact:** Enhanced AI capabilities and broader deployment. - **Introduction to Microsoft Co-Pilot:** - **Features:** Automates tasks in Microsoft 365 applications. - **Smart Assistance:** Provides contextual suggestions and automates workflows. - **Data Analysis and Content Generation:** Assists with data insights and drafting content. - **Differences Between ChatGPT and Microsoft Co-Pilot:** - **Core Technology:** Tailored for different use cases. - **Integration:** ChatGPT as a standalone tool; Co-Pilot embedded in Microsoft 365. - **Primary Users:** ChatGPT for general use; Co-Pilot for business users in Microsoft 365. - **Practical Applications of Microsoft Co-Pilot:** - **Microsoft Word:** Content creation and summarization. - **Microsoft Excel:** Data insights and automation. - **Microsoft Outlook:** Email drafting and scheduling. - **Microsoft Teams:** Meeting summaries and task management. - **Benefits of Using Microsoft Co-Pilot:** - Increased efficiency, improved accuracy, seamless integration, enhanced collaboration. --- #### 7. Future Trends and Developments - **Upcoming Features in ChatGPT:** - New updates and improvements. - **Comparison with New AI Models:** - Claude 3.5 and its unique features. - **Potential Impacts on Various Industries:** - How advancements in AI will affect different sectors. --- #### 8. Additional Resources - **Training Videos and Tutorials:** - Accessing recorded sessions and further learning materials. - **Contact and Support:** - Company website, support channels for assistance.

Thank you for sharing your training.

I love the way you train. I learned more here than anywhere else. I wish I had found this sooner.

where can i get the course file?

Thanks for sharing Video. a gentle request to share the data file of possible.

Got very important concepts from this video. Thanks

The best DAX instructor I have ever learned from. Thank you Gerald for this training. I am buying your 5 days course.

Great video - One suggestion is to make a "table" for all your measures Just go to to Home -and click Enter Data - Name the table - (I use "__Measures") and click load.... Go to the table and create a measure - something like Today = TODAY() and enter then delete from the model the original column that was created when the table was made (Click the more options .. on the right of the column) and then table icon changes to show a calculator.. This way you have a single area in which to create and organise your measures.

Promo_SM 🤗

Great session . I am listening to the talk . Reached till teams . Are you planning to talk on complaince , retention for copilot . Also the whole copilot ecosystem - 8 types of copilots

Dear Mr. Gerald, super explanations, you have depth of knowledge. Please, need Dataset for practicing. Thanks

Please put the excel file link in the comment so that we can practice along with you.

U should mark timeline in each topic for long play Video clip, it help the audience to select topic to see. Thanks for you r great job

nice job. please put excel file in the description video

no powerapp apearing in on gmail account on desktop app

Do you cover dax function like RANKX, SUMMARIZE or TIME INTELLIGENCE in this video?

Hi, Thanks for training, but where can I find the files used during the training? Thanks in advance

Super👍

Thanks for the video, learned a lot!! u r the best

@4:56:20, no need to wrap the revenue around calculate to show the sales amount in a column. A measure by iteself is wrapped around calculate. Thanks for the long... video.Using Properties window is a cool one.

Superb......

DAX On Power BI (Express Training) is just a 1-day FREE training. If you want the full course, you may visit www.gemrain.net/product-page/grc-102-conquering-dax-2019 and we have the full 5-day course from 3rd - 7th October 2022.

Awesome video👍👍👍

🙄 p̲r̲o̲m̲o̲s̲m̲

Great Tutorial, can you share the pbix file for practice....