- Tip 1: Create presentations using brand templates
- Tip 2: Create presentations from Word & PDF documents
- Tip 3: Add images to your presentations
This blog is about Microsoft technologies and solutions. The focus is on Microsoft 365, Office 365, Azure, Collaboration, Security and Compliance topics and AI (Copilot, AzureOpenAI and Google Gemini)
Mittwoch, 28. August 2024
Copilot in M365 & PowerPoint had some couples-therapy
Montag, 26. August 2024
#genAI - has pushed business to the limit even further!
We simply took a system that was already at its limit and added another layer to it!
The Great Acceleration (Die Große Beschleunigung)
- Technological disruption: Progress in technologies such as generative AI is driving change. Companies must continuously integrate new technologies in order to remain competitive.
- Lack of skilled workers: The demand for qualified employees is increasing, particularly in areas such as IT and data analysis.
- New business models and processes: Digitalization often requires a complete realignment of business models and internal processes. This can lead to an increased workload and the need for constant reorientation.
- Regulatory requirements: New laws and regulations, such as the AI Regulation, the EU AI Act, pose challenges. Companies must ensure that they meet these requirements.
- Cultural change: The changes brought about by artificial intelligence / GenAI also require an adaptation of the corporate culture. Flexibility, a willingness to innovate and a new form of employee management are becoming increasingly important.
Gartner, where do we stand?
- Innovation trigger: A technological breakthrough arouses interest and generates media attention. Often there are no usable products yet and the commercial feasibility is unproven.
- Peak of Inflated Expectations: Early successes and exaggerated expectations lead to hype. Many companies show interest, but there are also many disappointments.
- Trough of Disillusionment: Interest declines as the technology fails to meet high expectations. Some providers fail or withdraw.
- Slope of Enlightenment: The benefits of the technology become clearer and better understood. Second and third generations of products appear and more companies begin to fund pilot projects.
- Plateau of Productivity: The technology is widely adopted and its market relevance becomes clear. It is now widely used and brings measurable benefits.
- Poor data quality: Many projects fail due to inadequate and incorrect data.
- Escalating costs: The development and implementation of GenAI models is expensive.
- Unclear business value: Companies have challenges proving the business value of GenAI projects.
- Suppliers should be regularly evaluated by an AI with regard to their quality. The AI should analyze relevant complaints and take them into account in a summarized evaluation. In doing so, the AI should be guided by the supplier's previous assessments and automatically inform the supplier of any changes to its status.
- The AI should evaluate and analyze commodity index data available online in order to make forecasts about the current and future price and supply situation.
- An AI application that comprehensively checks applications for guidelines and evaluation criteria and decides whether the application should be approved. The AI also creates a detailed and legally binding justification.
GenAI as an enabling technology
- GenAI supports the automation of routine tasks, the creation of content and the analysis of large amounts of data.
- Content creation: Automated generation of texts and graphics for marketing campaigns, for example.
- Personalization: Optimization of advertisements and customer segmentation for targeted marketing measures.
- Chatbots and digital assistants: Support in customer service and internal processes.
- Program code generation: Automated creation and improvement of software code.
Reality check
- A guide to the length of the documents you provide to Copilot
- Approximately 80,000 words is the limit for Microsoft Copilot to summarize a document.
- Rewriting with Copilot works best with a document of less than 18,000 words.
- Using your organization's branding with Copilot in PowerPoint - minimum requirements for templates.
- Follow the instructions below to get the best results with Copilot...
- It is recommended to use a single slide master and rename it. If you need to use a template that contains multiple slide masters, you should ensure that each slide master complies with the guidelines in this article.
But - and there is almost always a “but”
- Employees expect AI in the workplace because they already know and use the apps from their private lives.
- AI raises the bar for employees and breaks down career barriers.
- A type of AI power user is emerging that will play a special role in the future.
The key point is...
- AI can help to minimize less demanding tasks so that employees can focus on more important and essential activities.
Companies and IT departments are lagging behind the trend
When users take IT into their own hands and how to deal with it
Samstag, 24. August 2024
Chat with a Video
Step by step
- Summarize the video
- List the action items
- Fasse zusammen, was über Donald Trump gesagt wird (eng: Summarize what is said about Donald Trump)
Dienstag, 20. August 2024
Retrieval-Augmented Generation - The metasearch engine in the age of AI
What is Retrieval Augmented Generation / RAG?
Copilot in Microsoft 365 uses RAG - this cannot be customized
- Word: Generate text with and without formatting in new or existing documents.
- Excel: Suggestions for formulas, chart types and insights for data in Excel sheets.
- PowerPoint: Create a presentation from a prompt or a Word file.
Now we have GraphRAG - that can be customized
- Information extraction: GraphRAG can be used to extract specific information from large document collections or databases.
- Content generation: GraphRAG helps to create content that requires in-depth contextual knowledge.
- Customer support: GraphRAG can improve customer support by accessing a knowledge base and providing accurate answers to customer queries.
- Knowledge management: In large organizations, GraphRAG can help to make efficient use of existing knowledge by retrieving and consolidating relevant information from different departments and documents.
Quickstart
- Azure Blob Storage
- Cosmos DB
- Azure OpenAI
- Azure AI Search / Vectorstore
- Container Registry
- Application Insights
Samstag, 3. August 2024
Turn your spaces into places
- Activate Microsoft Places in the tenant:https://learn.microsoft.com/en-us/deployoffice/places/deployment-guide-for-places
- Set up buildings and floors: https://learn.microsoft.com/en-us/deployoffice/places/get-started/quick-setup-buildings-floors
- Set up desk pools and workspaces: https://learn.microsoft.com/en-us/deployoffice/places/setting-up-desk-workspaces-in-places-finder
- I need a room in the office in Berlin to meet Oliver on August 9th. What are the possibilities?
- Show me the available desks in the office in New York at Time Square for September 17. Please also list which desk has which equipment.
- Microsoft 365 Business Basic
- Microsoft 365 Business Standard
- Microsoft 365 Business Premium
- Microsoft 365 or Office 365 (E1, E3, E5)
- Microsoft 365 or Office 365 (A1, A3, A5)
- Microsoft 365 Frontline Worker (F1, F3)
Montag, 29. Juli 2024
Google Gemini compared with Microsoft Copilot
The release of ChatGPT by OpenAI at the end of 2022 has re-shuffled the cards on the AI market. Microsoft is the largest investor at OpenAI. OpenAI's technology is therefore also the foundation of Copilot products.
Google is taking a slightly different path. Its own company, Google DeepMind Technologies Limited, has developed the Gemini solution. Google Gemini was originally called Google Bard and is the follow-up to the LLMs LaMDA and PaLM 2.
What is being compared in this test?
|
Microsoft Copilot |
Google Gemini |
|
Copilot in Edge |
Google Gemini |
|
Copilot in Microsoft 365 /
Microsoft Word |
Gemini for Google Workspace add-on |
Overview
Google Gemini:
- Gemini is available as part of the Google Early Access Test Program.
- The solution is also available via a Gemini for Google Workspace add-on and for users with private accounts via Google One AI Premium.
Microsoft Copilot:
Comparison
Copilot in Edge (formerly Bing Chat Enterprise) & Google Gemini App
- Common Crawl -> 60%
- WebText2 -> 22%
- Books1 -> 8%
- Books2 -> 8%
- Wikipedia -> 3%
Test 1
Test 2
Copilot in Word & Google Docs + Gemini for Google Workspace Add-On
Test 3
Test 4
Azure OpenAI Studio & Google AI Studio
- Models: Gemini 1.0 Pro, Gemini 1.0 Ultra, Gemini 1.0 Ultra Vision, Gemini 1.5 Pro, Gemini 1.5 Flash
- Features: Text generation, translation, Q&A, code completion, complex tasks, multimodal interactions, visual data processing
- Tokens: Maximum number of tokens of 1 million (for Gemini 1.5 Pro and Gemini 1.5 Flash)
- Price: Gemini 1.5 Pro is 30% cheaper than GPT-4o for input and output tokens
- Models: GPT-4o and older GPT models such as GPT-4, GPT 3.5 etc.
- Features: Text generation, translation, Q&A, code completion, complex tasks
- Tokens: No specific maximum number of tokens specified
- Price: GPT-4o is more expensive than Gemini 1.0 Pro and Gemini 1.5 Pro
- Other aspects:
- Partnership: Azure offers OpenAI models via API, Python SDK or web interface.
- Integration into the Azure Suite
Summary
- Microsoft Copilot is ahead of Gemini in the quality of AI generated answers. The results are more accurate and consistent. Gemini still makes mistakes too often. As an example, see the result of Test 2
- Gemini's user interface is clean and straightforward. At first glance, Microsoft Copilot in Edge is more feature-rich but a bit more game-like than Gemini.
- Gemini integrates with Google Workspace apps, but this integration is not on the same level as Copilot in Microsoft 365. As described in the Overview chapter, Copilot in Microsoft 365 has its own architecture and is not just an add-on. Part of this architecture is also the RAG functionality, which, among other things, ensures that Copilot knows his current context. For example, the AI acts as a writing assistant in Word and supports you in Excel when writing formulas or creating diagrams. More details: How Copilot for Microsoft 365 works: A deep dive
Samstag, 1. Juni 2024
GPT - here to stay
GPT = Generative Pre-trained Transformer
- G = Generative -> An output is generated
- P = Pre-trained -> The model was pre-trained
- T = Transformer
OpenAI published Chat GPT in November 2022. In June 2023, I wrote my first blog post on this topic: Next Level AI. A lot has happened in the meantime, there have been further versions and new models such as GPT-4, GPT-4o and small language models such as Phi-3. Nevertheless, it is still true that ChatGPT and therefore services such as Microsoft Copilot are not intelligent in the true sense of the word. Nevertheless, they are very helpful and that is why they are here to stay.
To ensure that the models generate the most useful results from the start, i.e. the “G” for generative, in the name GPT, they are pre-trained, i.e. the “P” for pre-trained, in the name GPT.
These models are trained using deep learning. Random values are used to generate an output. This calculated output is then checked against an output that should ideally have been calculated. The model contains a feature that can be used to return the error/deviation from the ideal result as a correction. This means that it is trained in such a way that the correct solution is now likely to be produced if the same input is used again. It is therefore transformed. The “T” in the name GPT.
Details and further information: https://en.wikipedia.org/wiki/Generative_pre-trained_transformer
According to Gregory Bateson's learning theory, this corresponds to so-called “Zero-Order”, also known as Try & Error. But deep learning sounds better 😉.
Users report that Microsoft Copilot answers them in a friendly way when they ask nicely and in a rude way when their prompt was rude. This effect can also be explained by the way this technology works. Pre-processing takes place before the prompt is sent to the LLM. Details are described here: Microsoft Copilot for Microsoft 365 overview. Something similar happens with OpenAI / ChatGPT. The prompt, as entered by the user, remains as the baseline. So if the prompt is formulated in an unfriendly way, the response will also correspond to this tenor. The orchestration / grounding has no influence on this. Quote in the context of Copilot:
Copilot then pre-processes the input prompt through an approach called grounding, which improves the specificity of the prompt, to help you get answers that are relevant and actionable to your specific task. The prompt can include text from input files or other content discovered by Copilot, and Copilot sends this prompt to the LLM for processing. Copilot only accesses data that an individual user has existing access to, based on, for example, existing Microsoft 365 role-based access controls.
This phenomenon, that the Copilot answer is based on the language of the prompt entered by the user, is therefore not related to the next stage of learning according to Gregory Bateson, protolearning or even deuterolearning.
- Protolearning can be regarded as simple association. I learn that when I see green, I go, and when I see red, I stop.
- Deuterolearning is a learning of context. If you reverse the association, how long does it take for the organism to adapt?
Source: https://www.aaas.org/taxonomy/term/9/protolearning-deuterolearning-and-beyond
In fact, you can even tell ChatGPT and Copilot which role and style it should use. Example: Please formulate a reply to this e-mail and use a very friendly style.
Here to stay
Together with LinkedIn, Microsoft has published the 2024 Work Trend Index Annual Report. It identifies the following four key points:
- Employees want AI at work - and they won’t wait for companies to catch up.
- For employees, AI raises the bar and breaks the career ceiling.
- The rise of the AI power user - and what they reveal about the future.
- The Path Forward
Employees want AI at work
Just like the iPhone, generative AI applications are currently mostly going viral in companies. Employees are familiar with solutions such as ChatGPT or the video creator HyGen from their private lives. They have heard about them from friends or played around with them at home. HyGen's claim sums it up: “In just a few clicks, you can generate custom videos for social media, presentations, education and more.”
Unless you work in marketing or in the PR department, social media usually refers to a private context. Presentations, education and more - is the bridge to business.
And they won’t wait for companies to catch up
- I research and try new prompts
- I regularly experiment with different ways of using AI
- Before starting a task, I ask myself, “could AI help me with this?
- AI helps me be more creative
- AI helps me be more productive
- AI helps me focus on the most important work
The path to the future
- Identify the business context of a problem or challenge and then try to use AI to solve it.
- Take a top-down and bottom-up approach. Ask both your employees and the management in the company about their use cases with AI.
- Empowering employees: AI in a business context is not intuitive. Factors such as the AI Regulation / the EU AI Act, the GDPR and topics such as who has access to which information are important here.































