Skip to content
Your Microsoft Dynamics platform is a goldmine of business intelligence. It holds critical information on every customer interaction, sales opportunity, and service ticket. This data is the engine of your business, but how effectively are you sharing its story? For many teams, the process involves exporting data, wrangling it into spreadsheets, and manually pasting screenshots into PowerPoint slides—a cycle that is slow, inefficient, and prone to error.
The moment you finalize that presentation, the data is already out of date. This disconnect between your live business data and your static reports can lead to missed opportunities and flawed decision-making. What if your PowerPoint presentations could update themselves with real-time data directly from Dynamics?
By integrating Microsoft Dynamics with PowerPoint through the INSYNCR plugin, you can build a direct, automated bridge. This guide will show you how to transform your static slides into dynamic, data-driven dashboards that always reflect the single source of truth: your Dynamics data.
The Power of a Direct Dynamics Connection
Connecting your CRM directly to your presentation software isn’t just about saving time; it’s about fundamentally changing how your organization interacts with its data.
Real-Time Data, Real-Time Decisions
Imagine your weekly sales meeting. Instead of presenting last week’s numbers, your slides display the sales pipeline as it stands right now. New deals closed just minutes ago are already reflected on the screen. This ensures your team is making decisions based on the most current information available, not historical snapshots.
Automate Your Reporting Workflow
Think of the hours spent each week or month manually creating reports. With INSYNCR, you set up the connection once. After that, your sales performance reports, customer service dashboards, and project status updates populate automatically. Your team can focus on analyzing the insights, not on the tedious task of data entry.
Enhance Data Visibility and Accuracy
Manually transferring data from one system to another introduces the risk of human error. A misplaced decimal or a copy-paste mistake can have significant consequences. A direct integration eliminates this risk entirely. The data on your screen is an exact mirror of the data in your Dynamics environment, ensuring complete accuracy and building trust in your reporting.
Possibilities Unlocked by Integration
Connecting PowerPoint and Dynamics opens up a world of possibilities for creating compelling, live information displays:
- Dynamic Sales Leaderboards: Create slides that automatically update to show top-performing sales representatives in real-time.
- Live Opportunity Pipelines: Visualize your sales pipeline by stage, with deal sizes and probabilities pulled directly from Dynamics.
- Customer Service Dashboards: Display key metrics like open ticket counts, average resolution times, and customer satisfaction scores on screens in your support center.
- Project Status Overviews: Keep stakeholders informed with presentations that automatically pull project milestones, budget consumption, and task statuses from Dynamics.
Step-by-Step Guide: Connecting Dynamics to INSYNCR
Ready to bring your Dynamics data to life? This three-phase process will guide you through establishing a connection, querying the right data, and fine-tuning your presentation.
Phase 1: Establish the Connection
The first step is to tell INSYNCR where to find your Microsoft Dynamics instance.
- Open the Connections Manager
In the PowerPoint ribbon, navigate to the INSYNCR tab. Click on the Connections button to open the management dialog box. This is your central hub for all data sources. - Add a New Dynamics Connection
In the “Available connections” list on the left, find and select Microsoft Dynamics. Click the Add button in the “Connection” pane on the right. - Provide Your Organization URL
A “Microsoft Dynamics” pop-up window will appear, asking for one crucial piece of information: your Organization URL. - This is the web address you use to access your Dynamics environment (e.g.,
https://yourorg.crm4.dynamics.com/). - Paste the URL into the text field.
- This is the web address you use to access your Dynamics environment (e.g.,
- Authenticate and Test
- The first time you connect, you will be prompted to sign in with your Microsoft credentials to authorize access.
- Once authenticated, click the Test button. This action confirms that INSYNCR can successfully communicate with your Dynamics instance.
- Click OK to save the connection configuration.
Phase 2: Configure Your Data Query
With the connection established, you now need to specify which information you want to pull from Dynamics. A query lets you pinpoint the exact data object or table you need.
- Add a New Query
With your new Dynamics connection highlighted, move to the Query section below the connection buttons. Click Add. - Select Your Data Source
The query configuration window gives you two ways to retrieve data: - Available data objects (Recommended): This is the simplest method. Select this option to see a list of all available tables and entities within your Dynamics environment, such as
accounts,contacts,opportunities, orleads. Simply click on the object you want to use. - Custom SQL: This option is for advanced users who need more control. It provides a text box where you can write your own SQL query to filter, join, or transform data before it even reaches INSYNCR. This is useful for creating highly specific datasets.
- Available data objects (Recommended): This is the simplest method. Select this option to see a list of all available tables and entities within your Dynamics environment, such as
- Define Caching Behavior
Under “Data caching behavior,” you can control how often the information updates: - Always refresh data: This option pulls fresh data from Dynamics every time the presentation loads or refreshes. It’s perfect for information that changes frequently.
- Refresh cached data at regular intervals: For very large datasets or less critical information, you can set a timer (e.g., every
300seconds) to reduce the load on your network and the Dynamics server.
- Finalize the Query
Click OK to save your query settings.
Phase 3: Preview and Refine Your Data
Before linking the data to shapes on your slide, it’s a good practice to verify that you are pulling the correct information.
- Use the Data Preview
Back in the main Connections window, select your newly created query. Make sure the Preview data checkbox is ticked. The pane at the bottom of the window will populate with a table showing the raw data from Dynamics, including columns likeaccountid,name, and other fields from your selected object. - Rename for Clarity
If you plan to use multiple data sources, default query names can become confusing. Use the Rename button to give your query a descriptive name like “Q4_Sales_Opportunities” or “Active_Service_Tickets.”
Conclusion
By bridging the gap between Microsoft Dynamics and PowerPoint, you empower your team with information that is always current, accurate, and actionable. This integration eliminates the soul-crushing work of manual reporting and frees up your employees to focus on what truly matters: understanding the data and driving the business forward.
Follow the steps outlined above to create your first live data connection. Start with a simple table of accounts or contacts, and as you become more comfortable, explore the advanced features to build sophisticated dashboards that tell a powerful story. Your data is your most valuable asset—it’s time to put it on center stage.
