Power BI 101 Series: Purchasing Dashboard with Power BI
Join our Webinar and learn how to create a Purchasing Dashboard with Power BI for your business. In this webinar, we’ll be showcasing all the different tables, connections, and calculations needed for this dashboard. Have instant access to accurate and detailed information such as the open PO commitments or purchase orders with line details. View all your key metrics and KPI’s in a single dashboard and drill into them such as the vendor spend by a period. This dashboard is meant to ensure your business can monitor and discover any spending trends.
Date: Wed Dec 19, 2018
CLICK HERE TO SIGN UP FOR THE WEBINAR TODAY!
Have a dashboard that is the envy of your colleagues? Created a view that would benefit your office mate? Is there a Dynamics 365 User that cannot access a record of yours and needs to, but security provisions are preventing him from doing so? If any of these apply, I encourage you to read on.
Sharing personally created views, charts, dashboards, and even records in Dynamics 365 could not be easier. Follow the steps below, and within seconds you will see just how simple it is to grant and give access to components within D365.
To Share Records:
1. Navigate to the entity that contains the records you want to share.
2. Select the records to share.
3. Click Share in the command bar.
4. Select Add User/Team.
5. Select the user or team you want to share the view(s) with.
6. Then select the level of access and click Share.
To Share Personal Views:
1. Navigate to the Advanced Find Query feature.
2. In the Look For dropdown, select the entity which contains the View you want to share.
3. Next select, Saved Views.
4. Place a check next to the view(s) you want to share and select Share in the ribbon. Note: You can select 1 or more.
5. Select the user or team you want to share the view(s) with and then select the level of access.
To Share Personal Charts:
1. Navigate to the Entity which contains the chart you want to share and select the chart.
2. Click the ellipses to display more options and choose Share.
3. Select the user or team you want to share the chart with and then select the level of access.
To Share Personal Dashboards:
1. Navigate to your Dashboards and select the Dashboard you wish to share.
2. In the command bar, choose Share Dashboard.
3. Select the user or team you want to share the dashboard with and then select the level of access.
- Dynamics 365 Sharing
- Dynamics CRM Sharing
- Dynamics 365 for Service Sharing
- Dynamics 365 Sharing Records
- Dynamics CRM Sharing Records
- Dynamics 365 Sharing Views
- Dynamics 365 Sharing Charts
- Dynamics 365 Sharing Dashboards
- Dynamics CRM Sharing Views
- Dynamics CRM Sharing Charts
- Dynamics CRM Sharing Dashboards
- Dynamics 365 for Sales Sharing
Running multiple business applications is a common practice nowadays, and it is often labor intensive or darn near impossible to make your applications talk to one another. This often leads to an awful lot of open tabs as you perpetually switch between applications updating information, or worse yet data becomes disconnected and disparate.
Microsoft has published their Business Application Platform including Flow, PowerApps and Power BI which are powerful tools that you can use to seamlessly allow your applications to talk to each other. Maybe even more importantly, these applications combine and merge the data from multiple applications, making the most out of your data.
Think of Microsoft Flow as a bridge which connects your applications and performs Actions automatically based on specified Triggers.
There are many out of the box Flow templates, built on applications used daily, which can be consumed. Additionally, you can create your own multi step Flow across several apps using supported Actions and Triggers.
Save time and invest your energy in other areas which require your focus. Let Microsoft Flow handle it, by sending you a notification about something which requires your attention, managing backend processes which up until recently were done manually, handling approvals…just to name a few. All of this can be done from the web, your phone or tablet, or even from your inbox! The functionality afforded by Microsoft Flow works with records stored in SharePoint, Dynamics 365, Tweets and over 100 other applications. The image below is just a small sample of the applications that you can connect with Flow.
DocuSign for Dynamics 365 brings all the benefits of the DocuSign electronic signature solution to your finger tips inside D365. With a seamless integration into Dynamics 365, you can access DocuSign functions directly from your form’s tool bar. Some of the key functions include the ability to sign and get signatures, track document status, and dynamically pull data from records.
The most known function of DocuSign is the ability to capture electronic signatures which are encrypted and secure, allowing for accelerated turn around on getting those all-important signatures. Consider all the sales transactions in your pipeline which are slated to close, why not simplify the process for you and your customers by providing the option to sign electronically. DocuSign takes the hassle out of the traditional pen and paper approach by allowing users to sign on any device and have it integrated back to D365.
An added benefit is that elements of your DocuSign documents can be dynamically populated from your D365 records. This is a real timesaver, eliminating the need for your team to customize the document each time it needs to be sent to a new customer. In addition to being time saving, it also eliminates human error along the way, providing you the confidence of knowing the document was sent correctly the first time.
A final noteworthy feature of the DocuSign/Dynamics 365 integration is the ability to track the progression of your email and document. This level of transparency provides 100% visibility into the entire process, affording you piece of mind every step of the way.
Ever find that two or more of your Dynamics 365 contacts are related and want a quick way to record that relationship? Or have a Contact that is related to an Account record even though it is not directly associated? Well look no further because we have your answer.
Connections in Dynamics 365 are a great way to link records together without any hassle. Sometimes you may want a quick way to link records together without having to spend hours coming up with a custom solution to satisfy this everyday requirement. Connections is your answer for that, whether it be linking records of the same type or of completely different record types.
To connect two records together, all you need to do is click on the Connect button in the tool bar.
This will open the new connection window.
From here, lookup the record you wish to connect to by clicking the name field and then selecting search for more records.
Once the Lookup window opens, find the record you wish to connect to by adjusting the Look for and Look in settings. You can use the search feature to help you narrow down items in the list.
Once you have located your desired record, select the record and click add.
Once the connect to record has been added, choose the relationship (role) which associates it to the current record. You may add additional details in the description field to further describe the relationship.
Once all the information has been added, hit save and close to create the connection.
To view Connections which have been associated to a record, click the down arrow next to the record name in the command bar, and select Connections.
Are you juggling two CRM systems because you have an overwhelming amount of data in your existing system, and you do not even know where to begin as you make the transition to Dynamics 365? Data importing aside, is a bigger concern loss of data and/or data integrity? Or do you have salespeople attending events and need a quick and easy process for getting all the data which has been gathered into D365?
Your search is over. Importing data is an important task you will need to perform at one point or another. Whether it be when your Dynamics 365 environment goes live or later when you need to bring in data which has been collected in another application. No matter how you slice it, the need will arise! You can import data into standard and customized fields of out of the box and custom entities in Dynamics 365. Not only that, you can also include related data, such as activities and notes. To assure data integrity, you can enable duplicate detection to prevent importing duplicate records.
A few pointers as you prepare your data for import:
Export data from your existing system in one of the following formats: comma-separated values (.csv), XML Spreadsheet 2003 (.xml), Compressed (.zip) or text files. Or save an Excel file, which has had data entered into it, as a .csv or .xml.
Once you have your raw data ready, the next thing you need to do is to prepare your data import template. There are a handful of ways to create a template for your data import into Dynamics 365.
1. Use Preconceived Templates. Go to Settings > Data Management > Templates for Data Import > Find the template for the entity you want to perform a data import for.
2. Create an Advanced Find Query. Perform an Advanced Find query, add the necessary columns, and then Export to Excel. Once exported replace the existing data with your own data.
3. Use an Existing Entity View. Navigate to the desired entity, select your preferred view, then select Export to Excel from the command bar. Once exported replace the existing data with your own data.
4. Create Your Own Template. In Excel, create your own template by adding column headers, which represent field names.
Once you have the template ready, you can copy and paste your data into the template. Be careful, Dynamics 365 is picky on formatting, make sure you paste as plain text.
Now you are ready to import your data. Go to Settings > Data Management > Imports and from the navigation area choose Import Data.
Browse to the location where you have saved the file, and select Next. On the next screen, confirm that the file is correct and select Next again.
Choose to have the system map the data automatically, the first selection in the list. Conversely, you can also use a Customized Data Map. After making your selection, select Next.
Choose the entity that you are mapping to.
The system will detect the fields. Verify that they match as you intended. For any fields that do not map automatically or are flagged, select the field that you want to map it to, or if needed, create a new field at that time. Once completed, select Next.
Verify the import file again and select Next.
On the next screen make your desired selections. To save the data map you have created, to use in the future, enter a descriptive name in the Data Map Name field shown below. Select Submit to execute the import. You can check the status of the import or view errors by navigating to Settings > Data Management > Imports.
What’s new in the October 2018 release webinar for Business Central?
Back in October, Microsoft launched a massive update for Business Central and we want to tell you all about it. In this webinar, we’ll be reviewing the updates and demonstrating how they can change the way you run your business. We’re excited to share the newest updates in Business Central and keeping everyone informed of the latest industry news. Some of the updates that we’ll be discussing are:
1.New Search Experience
2.List enhancements and smart list smart list-type functions
3.New G/L entry user experience
Date: Wednesday November 21, 2018
Time: 2:00PM-2:30PM EST