Using basic analytics using Power BI - Part 1

In an earlier post getting data from WEB  was described which used Indian demographics data.

In this post some analytics information will be added to the display using built-in analytic capabilities of Power BI.

Here is the WEB retrieved data from the link mentioned earlier.

Analytics_5_7_2018_0.png

Here is a visual of male, female and total populations from the Southern states Andhra Pradesh, Tamil Nadu, Karnataka and Kerala.

Analytics_5_7_2018_1.png

If you are not on a 'visual', you will not see the icon for the Analytics in the Visualizations section as shown. I am showing a visual, but I am not on it.

Here we have Page Level filter as shown

Analytics_5_7_2018_2.png

The total population is less than 10M in each state as you can see by adding data.

Once you are on a visual you can access the 'Analytics' as shown here.

Analytics_5_7_2018_4

Now click on 'Analytics' and you can add a number of analytics markers as shown here.

Analytics_5_7_2018_5

Now you will add a line showing average (Blue line)  of population of Females as shown here.

Here are few more settings for 'average line' that was not captured in the previous image. A zoom control would have captured the whole page of interest.

Similarly you add the Min Line, Max Line, Media Line and Percentile lines to the data.

Tour of Rome: Piazza del Campidoglio and the Forum - Part 1

September 24

It was another fine day in Rome. We finished our breakfast as usual and we were out of the hotel waiting to board the bus to take us round Rome.

Our itinerary for the day was huge and ambitious. However, we were able to complete the task with relative ease. Thanks to our local guide we really could get a good background story on Rome. We visited the Piazza Campidoglio after climbing the Cordonata stairs envisioned and built according to Michael Angelo’s design. I see other names also associated with this staircase. I will settle for Michael.

As you go up the stairs you will see the two statues at the top of the stairs. You will soon enter a great plaza (piazza), also Michael Angelo’s design. There is a bronze statue of Marcus Aurelius (This is not the original) which is weather beaten, looks black. Behind him stands the Palazzo Senatorio with very beautiful stairs. This appears to be right behind the Victor Emmanuel Monument (unfortunately much ridiculed by Romans and Foreigners alike with nick names like cake, type writer, etc.). Personally, I like it and standing as it does on the Capitoline hills, you cannot miss it from anywhere in Rome.

You can walk down to the road leading to the Forum, on the way you encounter many more ancient buildings. During our first visit we did not quite connect the Victor Emmanuel monument and the Forum. This time we were truly surprised, they really are close.

Walking towards the Cordonata to visit Piazza del Campidoglio. In the background, Monument Victor Emmanuel II "Vittoriano" à Rome.

Michelangelo's Cordonata on Capitoline Hill

 

As we climb the Cordonata (stairs), the Statue of Castor is on the left. On the right there is another statue, of Pollux.

https://romeitaly.ca/attractions/palazzosenatorio.html

 

Palazzo Senatorio

 Staircase leading to the Palazzo

 

 

Bronze Marcus Aurelius Statue in Piazza del Campidoglio

http://www.mmdtkw.org/VMAurelius.html

It is on top of Capitoline Hill, one of Rome’s seven important hills. Michael Angelo designed it in 14th Century.

 

On the way to Forum Street performers

All these and more in a video

Campidoglio and Foro Romano
https://youtu.be/gEhO3Sz4U74

 Forum 

Fine day, great group..

Our local guide feeding us lots of history

In front of Caesar’s Grave.

 

 In front of a shed where Julius Caesar’s remains are interred.

Temple of the Dioscuri, Castor and Pollux.

The Temple of Divus Antoninus Pius and Diva Faustina (141 CE)

Temple of Romulus

Images of Forum from Al Kehew’s Pinterest collection.

A full-blown view of Forum

Our group in front of Julius Caesar’s grave. This is where the ashes are interred.

Caesar's burial below the shed.

We will now move on to visit the Colosseum.

SQLite with Power BI

Power BI is a Microsoft product for business intelligence. SQLite is well known for its use in mobile platforms and embedded apps.

Get Power BI Desktop from here.

There is no native way of connecting to SQLite using Power BI, but you could use the ODBC driver which was described in an earlier post.

Read here:

ODBC Drivers for SQLite:

Read here:

Creating ODBC DSN for SQLite3:

https://hodentekmsss.blogspot.com/2018/04/creating-odbc-dsn-for-connecting-to.html

Connecting to SQLite3 using Power BI is easy. Here are the steps.

Launch Power BI and open the Get Data menu as shown.

In the list in the Other click on ODBC.

Highlight the DSN, ODBCSQLite and Click OK. 

Change it to Windows (this may not be necessary) and click Connect.

The "From ODBC" window is displayed. Click on Advanced Options to display the pane where you can write a SQL Statement.

It goes through from processing and since there is no table by that name, it returns an error.

Now change the SQL Statement to the following:

Select * from Users

After some processing, it gets connected.

Now you can find the table details in Navigator as shown.

Power BI does not show the tables and write a query you need to know the objects you created in the SQLite database.

Connect, Create, & Colloborate with Arduino Create

Arduino Create is a web based platform which you can use to connect, create, and colloborate to work with Arduino and related products.

This online platform (you will need to create username/password) enables Makers and Professional Developers to:

Write code

Access content

Configure boards(hardware)

Share Projects

Before Arduino Create, all these activities were fragmented and distributed over various tools, screens, etc.

Read all posts on Arduino on this site: http://hodentekhelp.blogspot.com/search?q=arduino

 Simply put the developer experience is now highly organized using just one tool-Arduino Create.

The next image explains it all.

Main Features:

• Always up-to-date online IDE
• Offers in-depth guided flows
• Configure easily Web Editor and Cloud
• Provides Arduino's Educational Program

Test your ODBC DSN's with ODBC test tool

You might have created a ODBC DSN's connecting to your various data sources and you may want to vrify they are doing what they are intended for before you are using them in some of your applications.

The ODBC test tool is invaluable to you to verify your ODBC DSN's. Here is a guide to where you can get it and install.