Author: Carl

Data Analysis TookPak Correlation

In Excel, select Correlation from the Data Analysis TookPak: Highlight and select options: Excel will create the correlation:  

Excel Analysis ToolPak Descriptive Statistics

There is lots of functionality in the Excel Analysis ToolPak. Let’s take a look at Descriptive Statistics. Let’s apply this to my data, which is MSFT stock prices over 2016. Select the input range and check labels in first row. Check summary statistics. This will go into a new tab on the worksheet. Excel has now generated the Descriptive Statistics:  

Power BI Service Administrator Role

In order to administer Power BI, there is a role in Office 365 that allows a user to be a Power BI administrator without having to have higher admin rights in Office 365. This role is called Power BI Service Administrator. To assign the role, log into https://portal.office.com and log into the Admin portal. Select Edit a User to edit an existing user: Select the user and next to Roles select Edit: Click Save. To do … Continue reading Power BI Service Administrator Role

Excel Analysis ToolPak

Excel provides an addin called Analysis ToolPak. To access it, open Excel and go to File->Options: Select Addins->Go: Select Analysis ToolPak and the Analysis ToolPak – VBA options and click OK: Click on the Data ribbon and you will see an option for Data Analysis: Note there are many different options:  

Dynamics 365 JavaScript Subgrid Refresh

Here we will go through an example of refreshing a Dynamics 365 subgrid using JavaScript. Let’s say we want the Recent Opportunities subgrid of an Account to refresh after a user presses a button. We have a web resource with a button that will run some JavaScript code: Edit the form to look up the name of the subgrid: Now add the code to the JavaScript behind the button: parent.Xrm.Page.getControl(“accountopportunitiesgrid”).refresh(); … Continue reading Dynamics 365 JavaScript Subgrid Refresh

Fiddler Autoresponder

In Fiddler, there is a feature called Autoresponser, which allows you to replace remote resources with your own local resources. This is useful if you are not online and would like to test some code, or would like to test certain functionality. Let’s see how this works. Let’s say we go to the Instagram.com website: In Fiddler, we can see this image/jpeg is downloaded: Which maps to: We can use … Continue reading Fiddler Autoresponder

Sharing a Dynamics 365 Dashboard

To share a Dynamics 365 dashboard, select the dashboard and click Share Dashboard: You will see the window below: Select a user or Team to grant access: Set the permissions for this user and click Share:  

Create a Dynamics 365 Dashboard

To create a dashboard, go to the Dashboards section you would like the new dashboard (e.g. Sales) and select New: You will then have the option to choose the layout of the dashboard. Select one and Create: Next, you will see the screen below. Select one tile and you can select an option for what you would like to display, e.g. Chart, List, IFrame, Web Resource, Power BI Chart. If we … Continue reading Create a Dynamics 365 Dashboard

Python in Visual Studio

To run Python in Visual Studio, open VS and create a new project. Select Python from the left and select Python application: You will see the project below. Enter a command, for example, Hello Word like below: Press F5: You can also import modules:  

Installing Python on Windows

To install Python on Windows, go to python.org and select Downloads: Select the latest release: Run the installer, select Install Now: Go through the setup: Complete: You will now see IDLE in your Start menu: The application will start: