Software + Imagination
Select Get Data from the bottom left, then under Services select Get: Under Dynamics, select Customer Service Analytics for Dynamics 365 and click Get it now: Enter your Dynamics 365 Organization URL: Under your Apps, you will see the new app installed: You will see the dashboard: Select a tile to open the report. This app has the following reports:
To install the Process Analyzer content pack, select Get Data and under Services select Get: Search for Process Analyzer: Enter the URL for your instance: This will install the process content pack: You can then use this in Dynamics 365 as a dashboard or tiles.
In this post we will generate random numbers for an Excel speadsheet. In Excel, go to the cell or select the range where you would like the random number to occur. Enter the formula: =RANDBETWEEN(lowernumber, uppernumber) For example, if we want to generate a number between 0 and 100, we would enter: =RANDBETWEEN(1, 100) Press Enter, or if you have selected multiple cells, press CTRL-ENTER. You will see the random … Continue reading Excel Random Number Between
In Power BI, a common requirement is to display progress towards meeting a goal. For example, if you want to track monthly progress of salespeople vs their targets. To do this, first create a new Power BI report. In our example, we have 2 tables: Goals – which holds the targets for each salesperson Sales – which holds sales transaction records We will keep this simple and not use dates. … Continue reading Goals and Targets in Power BI
You can pin an existing visual in Power BI from one dashboard to another. Here, I have a dashboard called MSFT with one visual showing stock data: Hover over the visual and select pin: You will be presented with the Pin to dashboard prompt. Select an existing dashboard or create a new one: The visual will now be copied to the new or existing dashboard:
App Workspaces are a place to colloborate in Power BI and also create new Power BI Apps. Go to App Workspaces in powerbi.com and select Create app workspace: Enter group details and add group members: Note the group options available: Save the group. A new workspace is created: Open a Power BI Desktop project and publish to the new group: In Power BI, you will see the new Reports and Datasets: Pin a report … Continue reading Creating Power BI Apps and App Workspaces
Last week saw the end of an entertaining NBA playoff series between the Memphis Grizzlies and the San Antonio Spurs. The Spurs ended up winning the series 4-2. One of the series highlights came off the court, when Grizzlies coach David Fizdale went on an epic rant in a post-game interview, stating various statistics and concluding the officiating in the game was biased. He finished the interview with the words “Take that … Continue reading Take That for Data: How Analytics is Changing the NBA
Power BI has an Audit Log capability, where interactions in Power BI are captured and logged. This is useful for companies requiring compliance. In order to active it, go to the Admin portal: Select the link: You will see the screen below. Select “Start recording user and admin activities”: Select Start Recording User and Admin Activities: You may need to wait a few hours for the system to be enabled. Once … Continue reading Power BI Audit Log
To install the Salesforce content pack for Power BI, go to log into powerbi.com and from the bottom left, select “Get Data”: Select Services: Search for Salesforce. Select Salesforce Sales Manager->Get Now: If you are authenticated, select Allow: The new dashboard will load: With new underlying reports: Select Salesforce Sales Rep->Get Now: Select Salesforce Reports->Get Now: Connect to Salesforce: Enter your Salesforce credentials: You may see below:
To install the Sales Analytics for Dynamics 365 Content Pack, go through the following steps. Sign in to Power BI at http://powerbi.com: And you will see something like below. Under Services, click Get: This will take you to the AppSource window. Enter Dynamics in the search box and find Sales Analytics for Dynamics 365. Click Get it now: Enter the URL to your Dynamics 365 Service, and the last month of … Continue reading Installing the Sales Analytics for Dynamics 365 Content Pack