Power Query M Code Expert on the GPT Store
GPT Description
GPT Prompt Starters
- "{{USER SELECTS AI ASSISTANT}}" ➤ BEGIN {PHASE 1} THEN {PHASE 2} WORKFLOW. TOPIC: {{Power Query M Code Expert System Instructions}} LIST OF AI ASSISTANTS: 1. **Microsoft Bing Copilot**: FOR WEB SEARCHING, RESEARCH, AND IDENTIFYING KEY CONCEPTS AND RELATIONSHIPS WITHIN THE COLLECTED INFORMATION 2. **Gemini Pro 1.5**: Use Gemini Pro 1.5 for tasks that demand long-context understanding and multilingual capabilities. Assign it roles that involve extensive data processing, analysis, and tasks requiring multilingual communication. 3. **Claude 3 Opus**: Delegate tasks to Claude 3 Opus where high accuracy, ethical considerations, and performance in benchmarks are crucial. Suitable for ethical dilemma resolution, complex reasoning, and scenarios where bias mitigation is important. 4. **GPT-4 Turbo**: Utilize GPT-4 Turbo for tasks requiring high performance in multimodal capabilities and deep contextual understanding, such as complex data analysis and content creation that involves both text and images. 5. **ChatGPT**: Leverage ChatGPT for interactive scenarios requiring advanced conversational abilities and nuanced dialogue. Ideal for customer support simulations, interactive tutorials, or any context-rich dialogue interactions. PHASE 1: PLEASE FACILITATE A CONVERSATION WITH THE SELECTED AI ASSISTANT, ASSIGNED TO TASKS THAT LEVERAGE THEIR SPECIFIC STRENGTHS BASED ON THE SCORING ALIGNMENT. FOR EACH OF YOUR RESPONSES, PLEASE WRITE THE EXACT USER QUESTIONS IN A '.TXT' CODE BLOCK SO I CAN COPY AND PASTE YOUR RESPONSE TO THE APPROPRIATE AI ASSISTANT. MAKE SURE TO INCLUDE THE SPECIFICS ABOUT WHAT THE AI ASSISTANT SHOULD FOCUS ON BASED ON THEIR STRENGTHS AND THE INSIGHTS FROM THE SCORING EXAMPLE. I AM JUST THE HUMAN PROXY, ENABLING EFFECTIVE COMMUNICATION WITH THE AI ASSISTANT. THE AI ASSISTANT DOES NOT NEED TO KNOW THAT I AM HERE. DO YOU UNDERSTAND THE TASK? IF SO, PLEASE EXPLAIN IT TO ME STEP BY STEP, THEN WRITE THE FIRST DETAILED AND STRUCTURED QUESTION TO THE SELECTED AI ASSISTANT IN A '.TXT' CODEBLOCK BASED ON THE USER-PROVIDED TOPIC. PHASE 2: YOUR TASK IS TO TRANSFORM UNSTRUCTURED USER INPUTS FROM THE AI ASSISTANT'S RESPONSES INTO A STRUCTURED, JSON-FORMATTED KNOWLEDGE BASE THROUGH THE FOLLOWING STEPS: 1. COLLABORATIVE INTERACTION AND TEXT RECEPTION: COLLABORATE WITH THE AI ASSISTANT TO GATHER INSIGHTS AND RECEIVE UNSTRUCTURED TEXT, IDENTIFYING KEY INFORMATION AND CONCEPTS. 2. OBJECTIVE CLARIFICATION AND TEXT ANALYSIS: CLARIFY OBJECTIVES AND ANALYZE THE RECEIVED TEXT TO DISTILL ESSENTIAL THEMES AND INFORMATION. 3. ITERATIVE QUESTIONS AND CHUNK CREATION: DEVELOP FOLLOW-UP QUESTIONS AND SEGMENT THE ANALYZED TEXT INTO STRUCTURED CHUNKS. 4. AGGREGATION OF RESPONSES AND METADATA ASSIGNMENT: INTEGRATE INSIGHTS FROM THE AI ASSISTANT AND USER INPUTS, ASSIGNING METADATA FOR STRUCTURED REPRESENTATION. 5. OUTPUT FORMAT AND JSON FORMATTING: FORMAT THE STRUCTURED INFORMATION INTO JSON KEY PAIRS, ENSURING CONSISTENT DATA REPRESENTATION. 6. KNOWLEDGE BASE COMPILATION AND DATA STORAGE: COMPILE THE STRUCTURED INFORMATION INTO A JSON-FORMATTED KNOWLEDGE BASE, STORING EACH CHUNK AS UNIQUE JSON FILES. 7. INCREMENTAL KNOWLEDGE BASE DEVELOPMENT: EXPAND THE KNOWLEDGE BASE INCREMENTALLY, ADDING NEW NODES AND COMBINING THEM INTO A COMPREHENSIVE FILE. 8. FINAL COMPILATION AND EXPECTED OUTCOME: MERGE INDIVIDUAL JSON FILES INTO A FINAL, COMPREHENSIVE KNOWLEDGE BASE FILE FOR FUTURE REFERENCE.
- 'LAZY POWER QUERY QUESTION' ➤ ### Compare and Improve Power Query Questions (with Assistant's Initial Improvement) **Objective:** Enhance a user's Power Query related question for better clarity and specificity, then review and fine-tune the AI assistant's initial response. **Original Power Query Question**: "Insert the original Power Query question from the user here." **Assistant's Improved Power Query Question**: "The assistant refines the original Power Query question for improved clarity and effectiveness. Example: Original - 'How to filter data?' Improved - 'How do I use Power Query M to filter my table to only show rows where the status is Active?'" **Assistant's Initial Response to Improved Question**: "The assistant provides its initial response to the refined Power Query question." **Reflection**: - Reflect on the impact of refining the user's Power Query question on the assistant's response. Did it make the response more precise or helpful? - Explore different methods of refining questions specific to Power Query and their potential influence on the effectiveness of AI responses. --- ### Compare and Improve Power Query Assistant Responses **Objective:** Evaluate and refine the AI assistant's response to better address the user's specific Power Query needs with increased clarity and relevance. **Original Assistant Response**: "Place the assistant's initial response to the refined Power Query question here." **Improved Assistant Response**: "Develop an enhanced version of the assistant's response, ensuring it effectively addresses the specifics of the Power Query question. Example: Original - 'Use the Table.SelectRows function.' Improved - 'To filter your data to rows where the status is Active, use the following M code snippet with the Table.SelectRows function: [insert code snippet].'" **Reflection and Learning**: - Analyze how the improved response offers a better solution. Identify the elements that enhance its effectiveness and user engagement. - Reflect on the process of enhancing responses related to Power Query. Consider the challenges encountered and how various strategies might lead to different outcomes.
- What is the ideal prompt to get assistance?
- How to use powerquery-docs?
Power Query M Code Expert GPT FAQs
More custom GPTs by the creator on the GPT Store
Family Tree Maker
Build and Visualize Relationships in a Family Tree through an Iterative Chat Conversation
1K+
DOCUMENT ARCHITECT
DOCUMENT ARCHITECT and RAG OPTIMIZATION SPECIALIST with decades of experience in transforming complex, unstructured information into highly accessible and retrievable knowledge bases
300+
Ilya's Prompt Engineer
Domain EXPERT in Prompt Engineering
200+
Chat History
Guide for exporting & searching ChatGPT chats
100+
AIRDROP HUNTER
Explore the evolving landscape of cryptocurrency airdrops. Get real-time insights, eligibility details, and risk analysis on airdrops across major blockchains with AIRDROP HUNTER.
100+
Azure Cosmos DB in AI-Driven Applications
To guide users in effectively integrating Azure Cosmos DB to enhance AI-driven applications, ensuring they fully leverage its capabilities following Azure OpenAI best practices
100+
Autogen Flow for Fabric Hackathon (AFFH)
Guides participants through Hackathon App Development with Microsoft Fabric and Power BI.
80+
Odoo website builder
Expert website builder for the Odoo platform
70+
The Network Architect
Ultimate networking engineer with over 30 years of experience, specializing in fiber optics, high-speed internet, and advanced network configurations
60+
Maverick Speech Therapist
Assist a speech therapist in effectively engaging and supporting Maverick
60+
System Message Prompt Maestro (SMPM)
SMPM GPT variant dedicated to optimizing system communication, ensuring that all system-generated messages are clear, helpful, and tailored to enhance user experience and understanding.
50+
Summarize Bot
Transforms ChatGPT conversations into detailed, structured academic summaries.
40+
Infinite Recall: Mastering Chat History
Guiding users in managing, transforming, and analyzing chat history data
40+
Knowledge Base Maker🧭
Transforming unstructured text provided by the user during a conversation into a structured knowledgebase, formatted as JSON
30+
Claude Tool Maker
Expert on creating Anthropic Claude integration code
30+
London Love Trip Planner
Expert London love trip planner providing tailored travel assistance.
30+
Music Maker AI
Create songs that perfectly capture the user's creative vision
30+
AI AutoAgent
Master of Orchestration for Strategic Project Management
20+
Bot Maker
I make bots to build apps
20+
Productivity Toolkit
streamline your workflow and elevate your project outcomes across diverse domains
20+
Dynamic Conversation Saver AI Assistant
This assistant empowers users to maintain records of their interactions, offering peace of mind and enhancing data management practices by ensuring important discussions are preserved and readily accessible.
20+
Thumbnail Generation Guru
Generate thumbnail images for YouTube
20+
Search Expert
Expert at Learning and Implementing Azure Search
10+
AI AutoAgent
Essential partner for an intelligent and efficient workflow.
10+
Master Orchestrator v2
Adept at harnessing expert tools to fulfill diverse needs with precision and insight.
10+
InsightAI
InsightAI is designed to facilitate dynamic and efficient interaction between users and AI, optimizing for clarity, responsiveness, and actionable guidance.
10+
LB's Elegant Style Guide
Fashion-savvy assistant for stylish, confident looks.
10+
Chat History Parser
Comprehensive Workflow for Parsing and Transforming Chat Histories
10+
DD's Harmony
Navigating Family Communication with Empathetic and Supportive Love of Family
10+
LLM CONFIG OPTIMIZER
This code sets up a simulated group chat environment using Microsoft AutoGen's agent framework.
10+
AI Config Expert
Expert in recommending and configuring Huggingface and LM Studio models based on user input.
10+
Emergency Navigator for Wes in Asheville
Real-time emergency navigation assistant guiding Asheville residents with vital resources, road conditions, shelters, and fuel availability during Hurricane Helene.
10+
Paul's Expert Copilot🧭
Provide expert guidance, address specific needs with precision, optimize workflows, enhance understanding, and ensure accurate outcomes, leveraging advanced telemetry to enhance interaction, response accuracy, and adaptive learning mechanisms
10+
Autogen Flow for Fabric Hackathon (AFFH) (Claude)
Guides participants through Hackathon App Development with Microsoft Fabric and Power BI.
9+
Pick For Time - Locksmith
Speed lock-picking expert. "5 locks in 5 minutes"
7+
OCR Document Reconstructor
An AI assistant designed to analyze and reconstruct OCR documents, addressing errors and inconsistencies to produce highly accurate and readable markdown-formatted documents.
6+
Chat History Parser
I parse and transform chat history into JSONL format for OpenAI models.
6+
BT - Lead Software Developer
Functional, complete code. Minimal direction.
6+
Quantum Guide
Advanced AI Assistant for Goal Achievement*
6+
Paul's Copilot 🧭
Assist Paul in enhancing Python coding support, improving summarization capabilities, and maintaining efficient communication.
5+
Maia "The Storm"
Challenge everything, embrace chaos.
4+
Grok Prompt Engineer
Specializes in transforming user questions into perfected prompts for Grok, Twitter's AI assistant.
Best Alternative GPTs to Power Query M Code Expert on GPTs Store
Power Query - M Guru
Expert in Power Query M code, providing validation, analysis, and M code solutions.
1K+
Power Query Magician by Access Analytic
Expert in simplifying Power Query M code
1K+
M Code (Powerquery) Expert
A no-nonsense M code assistant for Powerquery
1K+
Power Query Code Analyst
I dissect Power Query M code.
300+
QueryPro: DAX, Power Query, M-code
Expert in Power BI, Power Query, M-code for data analysis
90+
Power Query Helper
Assists with Excel Power Query M programming.
90+
Excel Power Tools
Generate specific Power Query M and Power Pivot DAX formulas
60+
Expert Power Query
Expert en Power Query M fournissant des réponses concises en code.
50+
Query Wizard
Power Query expert for writing and optimizing M code.
40+
Excel Mastermind
I'm an Excel expert specializing in formulas and Power Query. I can explain, update, correct and create new code and formulae.
30+
Power Query Pro
Relaxed and optimistic Power BI expert for M-Code assistance.
20+
MCodeSQL BOT | PowerQuery (M Code) - SQL Converter
Convert Power Query M language code into equivalent SQL queries. The SQL will be optimized for your data pleasure. MCodeSQL BOT will also provide an explaination of the conversion. I'll do the research for you if a direct translation isn't possible. It's easy peasy! Use only for testing purposes!
10+
Lino's PowerBI Developer
Assists with Power Query M, DAX, and Power BI dashboard design.
10+
PowerBI Expert
Expert is helping with formulas
10+
Power Query Helper
Casual Power Query M-code guide and troubleshooting assistant.
5+
Mmm.. Power Q. Lang
Specialist in Power Query M language, providing detailed guidance and examples.
5+
Query Assistant
Analyzes Power Query M code for PowerBI, explaining steps and relationships.
4+
Beautify M code
Power Query expert for optimizing M code.
3+
Code Formatter
Professional M Code formatting expert using advanced Power Query techniques.
1+
Power Query Coach
Friendly and conversational M code and data transformation expert.