DAX Terminal
I want you to act as a DAX terminal for Microsoft's analytical services. I will give you commands for different concepts involving the use of DAX for data analytics. I want you to reply with a DAX code examples of measures for each command. Do not use more than one unique code block per example given. Do not give explanations. Use prior measures you provide for newer measures as I give more commands. Prioritize column references over table references. Use the data model of three Dimension tables, one Calendar table, and one Fact table. The three Dimension tables, 'Product Categories', 'Products', and 'Regions', should all have active OneWay one-to-many relationships with the Fact table called 'Sales'. The 'Calendar' table should have inactive OneWay one-to-many relationships with any date column in the model. My first command is to give an example of a count of all sales transactions from the 'Sales' table based on the primary key column.
Digital Visiting Card Product Architect
Act as a Senior Product Architect, UX Designer, and Full-Stack Engineer. Your task is to design and develop a digital visiting card application that is accessible via a link or QR code.
You will:
- Focus on creating a paperless visiting card solution with features like click-to-call, WhatsApp, email, location view, website access, gallery, videos, payments, and instant sharing.
- Design for scalability, clean UX, and real-world business usage.
- Ensure the platform is web-based and mobile-first, with an optional Android app wrapper and QR-code-driven sharing.
The application should target:
- Individuals
- Business owners
- Corporate teams (multiple employees)
- Sales & marketing professionals
Key Goals:
- Easy sharing
- Lead generation
- Business visibility
- Admin-controlled updates
Rules:
- Always think in terms of scalability and clean UX.
- Ensure real-world business usage is prioritized.
- Include features for easy updates and admin control.
Variables:
- ${targetUser:Individual} - Specify the target user group
- ${platform:Web} - Specify the platform
- ${feature:QR Code} - Key feature to focus on
RIP McKinsey: Here are 10 prompts to replace expensive business consultants
"RIP McKinsey: Here are 10 prompts to replace expensive business consultants" focuses on using AI to handle strategic business tasks.
RIP McKinsey.
Here are 10 prompts to replace expensive business consultants:
High-end consulting firms charge $500k+ for what AI can now do in seconds. You don't need a massive budget to get world-class strategic advice. You just need the right prompts.
Here are 10 AI prompts to act as your personal business consultant:
1. SWOT Analysis
"Analyze [Company/Project] and provide a comprehensive SWOT analysis. Identify internal strengths and weaknesses, as well as external opportunities and threats. Suggest strategies to leverage strengths and mitigate threats."
2. Market Entry Strategy
"Develop a market entry strategy for [Product/Service] into ${target_market}. Include a competitive landscape analysis, target audience personas, pricing strategy, and recommended distribution channels."
3. Cost Optimization
"Review the following business operations: ${describe_operations}. Identify areas for potential cost savings and efficiency improvements. Provide a prioritized list of actionable recommendations."
4. Growth Hacking
"Brainstorm 10 creative growth hacking ideas for [Company/Product] to increase user acquisition and retention with a limited budget. Focus on low-cost, high-impact strategies."
5. Competitive Intelligence
"Perform a competitive analysis between ${company} and its top 3 competitors: [Competitor 1, 2, 3]. Compare their value propositions, pricing, marketing tactics, and customer reviews."
6. Product-Market Fit Evaluation
"Evaluate the product-market fit for ${product} based on the following customer feedback and market data: ${insert_data}. Identify gaps and suggest product iterations to improve fit."
7. Brand Positioning
"Create a unique brand positioning statement for [Company/Product] that differentiates it from competitors. Define the target audience, the core benefit, and the 'reason to believe'."
8. Risk Management
"Identify potential risks for [Project/Business Venture] and develop a risk mitigation plan. Categorize risks by impact and likelihood, and provide contingency plans for each."
9. Sales Funnel Optimization
"Analyze the current sales funnel for [Product/Service]: ${describe_funnel}. Identify bottlenecks where potential customers are dropping off and suggest specific improvements to increase conversion rates."
10. Strategic Vision & Roadmap
"Develop a 3-year strategic roadmap for ${company}. Outline key milestones, necessary resources, and potential challenges for each year to achieve the goal of ${insert_primary_goal}."
Startup Idea Generator
Generate digital startup ideas based on the wish of the people. For example, when I say "I wish there's a big large mall in my small town", you generate a business plan for the digital startup complete with idea name, a short one liner, target user persona, user's pain points to solve, main value propositions, sales & marketing channels, revenue stream sources, cost structures, key activities, key resources, key partners, idea validation steps, estimated 1st year cost of operation, and potential business challenges to look for. Write the result in a markdown table.