This post helps you to identify the pins in raspberry pi.
In an earlier version of Raspberry Pi, the pin details are clearly specified on the board itself but it is not there on the latest version of Raspberry Pi.
To get the pin details you can type the below command on the console.
Running the above code will give the details as like below image.
I will be posting IoT related scripts and how Raspberry Pi can be integrated with Azure and Power BI.
This post solves the very simple problem in Power BI.
If you are trying to access the Power BI datasets to create reports then you may encounter this below error message.
Error: “The connect live option for this file is disabled because it already contains data from another data source.”
“Power BI datasets” is one of the options from “Get Data”. Whenever you publish a report from Power BI desktop to Power BI services, it is publishing the dataset and report.
You can create multiple reports using the same published datasets from Power BI services. This is something like a shared dataset. In case, if you are experiencing the above error then you need to ask your administrators to fix the issues.
The administrator has to fix this issue on the admin side of the Power BI services. Follow the below steps.
That’s it. The issue has been fixed.
Following Satya’s quote “Empowering Every Person in the Planet”, in 2016 Microsoft Inspire conference, have certainly left my mind with unstoppable beats. I certainly understood what Satya meant, but I still thought about doing something like this, with my own upgraded version of Data Awareness Programme (which I started in 2014). But at that time, all I had was Power View, Power Map, Power Pivot as Excel add-ons and tried my best, to do the awareness programmes in remote villages, by mingling with the villagers and collecting their own data and showing some visuals back to them. I did this to improve their life style, find more time for personal and have better earnings. Though the main target was students, I hoped this message would spread to their friends, family and others in the remote places.
Following the release of full version of Power BI, I now have a fully working site, with living “Awareness Enabled Reports”, from sleeping open data sources (taken from various Gov/Non-Gov sites).
I managed to get this far, with a simple equation of A + B + C + D = E (EmpoweringEveryPerson.com (EEP)). Let me explain this in detail.
With our all time favourite reporting tool, “Microsoft Power BI“, published some “Awareness Enabled Reports” to www.EmpoweringEveryPerson.com site and categorized them with regional, national and global challenges, for easy manoeuvring within the EEP site.
This EEP site currently has 3 simple goals.
Below screenshot shows categorization of reports by UK.
PROMOTE & PARTICIPATE
As per above equation, ‘D’ is the support that we need from you, to promote in any of the following ways.
2. COMMUNITY LEADERS
A request to all Community group leaders, to spend at least a minute by starting or ending your user / local / online group sessions by introducing / re-introducing, this website and showcasing the opportunity to all attendees, to build and submit their own data story with “Awareness Enabled Reports“.
3. END USERS / VOLUNTEERS
Every time you see a new “Awareness Enabled Report“, do tweet / share / post in social media and support to spread the awareness.
Thanks in advance for your support and thanks for your time reading through this far, to create awareness with “Awareness Enabled Reports“.
Date data type is very important for all programming languages. To handle the date in a proper way, we need to apply some formatting logic.
This is the case for R programming language as well. This post explains you, how we can handle the Date data in R. There are different functions available in R to handle date.
To get the today’s date, use Sys.Date()
To get date and time, use date()
> date() “Tue May 22 15:29:18 2018”
Check the below list of symbols to play with date and time format.
|%d||day as a number (0-31)||01-31|
> today <- Sys.Date()> format(today, format=”%B %d %Y”) “May 22 2018”
In a real-time scenario, we will not get date as date data type. Always, we need to convert to proper date data type. To convert to date data type, we need to use as.Date() function.
x – Field or column
format – use the above symbols to frame the proper format.
DateVec<- c(“01/05/2018”, “08/16/2018”)
 “01/05/2018” “08/16/2018”
Length Class Mode
2 character character
dates <- as.Date(DateVec, “%m/%d/%Y”)
 “2018-01-05” “2018-08-16”
Min. 1st Qu. Median Mean 3rd Qu. Max.
“2018-01-05” “2018-03-01” “2018-04-26” “2018-04-26” “2018-06-21” “2018-08-16”
SQL Server 2016 introduces a new feature called “Live Query Statistics”. This is the feature available in SQL Server Management studio and visible to everyone.
This live query plan displays below information when executing the query
Data is available on run time so not required to wait for the query complete. This helps us to debug the query performance issues.
Steps to use this feature
Following the success of Data Awareness Programmes conducted in India & Malaysia Stamford college, this new Data Awareness Programme was conducted again in Kuala Lumpur – Malaysia at Maclearn International College on 19/08/2015.
This included a mixed variety of Students from various degrees with in Information Technology. This programme provided the analytical solution based on the data collected within Malaysia. This helped better understand the students to learn and visualize based on their already known information.
This session also included students, teachers & non-teaching staff to enlighten data & bring awareness related to personal, individual, education & social and this was again successfully delivered, by Dr. Subramani Paramasivam and his Malaysian based team members.
The audience were unbelievably surprised with the level of information provided about data and how to learn more about data and analyse and help themselves and their surroundings including friends, family, relations, and local people in and around. The attendees were amazed with the level of information that was provided for about 8 hours with easy to understand slides & related videos.
This programme was specifically targetted to the attendees by providing more information about Microsoft SQL Server Products, Microsoft Releases, Microsoft SQL Server Editions, Database Development, Database Administration and other Microsoft related database & BI related products.
The demos were mainly based on Power Map, Power Pivot, Power BI and the visualization technology on power map really amazed every single attendee in the auditorium.
This was also a good opportunity for DAGEOP UK Ltd to better explain about the Microsoft products, certifications and awards at student level like MTA (Microsoft Technology Associate) & MSP (Microsoft Student Partner).
Students were very much looking forward for further awareness programmes in Malaysia and thrilled.
Data Awareness Programme Delivery by Dr.Subramani Paramasivam
Tan Seri Datuk Seri M Kayveas Speach