Sunday, January 13, 2019

How do you install IIS on Windows 10?

As previously noted you need to enable IIS on Windows 10.

You can do this in Control Panel.

In Turn Windows fatures on or off. Place check marks as shown above. Vlick OK. It may take a while and IIS is turned on.

You can launch IIS from the search charm as shown.

When you click this, Internet Informatio Services Manager's screen opens as shown.

From Help you can find the version (10.0.17134.1) shown here.

You can look at the contents on your site (Default site) shown here. Rihgt now there is only one file (IISStart.htm and PNG file).

You can right click the htm file and browse as shown.

Your files (presently IISStart.htm and IISstart.png) are in the wwwroot folder.

Saturday, January 12, 2019

How come I cannot access Internet Information Services on my Windows 10?

IIS does not come installed or turned-on.

Most probably IIS is not turned-on. You can do it from the Control Panel.
This is what you see when IIS is not turned-on.

Wednesday, January 9, 2019

How do you install the latest Node.js for Windows 10?

You can download from this site.

This is the .msi file for Windows 10(x64).

Double click the node-v10.15.0-x64.msi to install. Just follow the installation wizard.

Default installation choice was made.

Node.Js program files installed on the computer's C:\ drive.

Node.JS Version

Monday, January 7, 2019

What is AnTuTu bench marking?

A very popular, chinese Android bench marking apps. AnTuTu objectively explores the performance of a device. The app does a variety of testing, assignning a score for each feature tested.

You can download AnTuTu Benchmark app from Google Play.

I have a Samsung Galaxy S9 and I tested on my phone after downloading.

Here is the app on my Samsung

Here is one of its My Device screens:

It also sends the notifications regarding performance.

Monday, December 31, 2018

Thursday, December 6, 2018

How do you load JSON data into PowerBI?

JSON data source were recently added to Power BI Data sources.

I have taken this JSON file from the following site;

and I will be using in this post.

Here is an abbreviated JSON file (with *.json extension) I am using.

  "data": [
      "name": "Garrett Winters",
      "designation": "Accountant",
      "salary": "$170,750",
      "joining_date": "2011/07/25",
      "office": "Tokyo",
      "extension": "8422"
      "name": "Brielle Williamson",
      "designation": "Integration Specialist",
      "salary": "$372,000",
      "joining_date": "2012/12/02",
      "office": "New York",
      "extension": "4804"
      "name": "Quinn Flynn",
      "designation": "Support Lead",
      "salary": "$342,000",
      "joining_date": "2013/03/03",
      "office": "Edinburgh",
      "extension": "9497"

Note that each Json element has six attributes.

Step 1:
You first need to save it to a location of your choice. You could also have it on an URL, but here it is assumed to be in one of the folders.

Launch PowerBI; Click GetData; Click More...

Click JSON

You need to browse and locate your JSON file (it will have  a.json extension).

My Koding.json file is now in Data View as shown.

 I go back to Edit Queries as I did not edit earlier.

 Now I have a query as shown in the left pane.

I had 15 elements in the JSOn file and they have become 16 records after getting it into PowerBI. Now go back to query using Edit Query as before. Now you see an extra control in Column 1 for splitting into its components.

I click the split control. The Query now appears as shown.

Now I convert this into table as shown above. Now what I see in DataView is the following:

The six elements are resolved into six fields as shown above. We will use this later. Click File | Save to save this file in the .pbix format. Presently it has the JSON data only.

That is all folks!

Sunday, December 2, 2018

How do you bring in XML data into PowerBI?

Here is how to do it.

Launch PowerBI. Click Get Data.

Click XML. Open dialog is displayed. Previously I saved a CD.XML file from W3C site here.

I highlight CD.xml and click Open. Power BI processes my input, and brings up the CD.xml in the Navigator as shown.

I place a check mark for CD.XML. The file loads into the Navigator.

I click Load. My action Load gets processed.

Now CD.XML is loaded into PowerBI. I still don't see it.

 Change it to DataView on the Left. Now you see the data in CD.xml.

That's all folks. Now you can do what you want to do in PowerBI.