DataAP

ByDr. SubraMANI Paramasivam

Empowering Every Person in the planet, with “Awareness Enabled Reports”

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.

Following this, I managed to extract data from various open data sources and identified the most global challenges, that we are encountering and/or going to be a major threat in near future.

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.

  1. View the “Awareness Enabled Reports” worldwide in any devices, by categorizing Regional or Global challenges.
  2. Submitting another “Awareness Enabled Report” as a Developer with some guidance. Also listed, Global Challenge Topics to select from open data sources and provided some tips to convince the selection committee and finally submitting the story.

  1. Promote EEP
    1. Provided options to Promote EEP as  a Developer, User Group Leader & End user.

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.

1. DEVELOPERS

Develop “Awareness Enabled Reports” for all listed Global Challenge topics and submit your data story to EEP site and once published, tweet / share / post in social media and spread the awareness.

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“.

ByHariharan Rajendran

How to handle date in R

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()

Sys.Date()

> Sys.Date()

[1] “2018-05-22”

 

To get date and time, use date()

> date()[1] “Tue May 22 15:29:18 2018”

 

Check the below list of symbols to play with date and time format.

Symbol Meaning Example
%d day as a number (0-31) 01-31
%a
%A
abbreviated weekday
unabbreviated weekday
Mon
Monday
%m month (00-12) 00-12
%b
%B
abbreviated month
unabbreviated month
Jan
January
%y
%Y
2-digit year
4-digit year
07
2007

 

> today <- Sys.Date()> format(today, format=”%B %d %Y”)[1] “May 22 2018”

 

Date Conversion

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.

Syntax

as.Date(x, “format”)

x – Field or column

format – use the above symbols to frame the proper format.

 

DateVec<- c(“01/05/2018”, “08/16/2018”)

DateVec

[1] “01/05/2018” “08/16/2018”

summary(DateVec)

Length     Class        Mode

2            character   character

dates <- as.Date(DateVec, “%m/%d/%Y”)

dates

[1] “2018-01-05” “2018-08-16”

summary(dates)

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”

ByDr. SubraMANI Paramasivam

Run Your Python Script

Use the below console to run your python scripts

# Assign value to the variable # a = 5 #Print
Print
ByHariharan Rajendran

Live Query Statistics

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

  1. Overall query progress
  2. Number of rows produced
  3. Elapsed time on each operation

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

  1. Check this feature in SSMS
  2. Include (select the icon) the “Live Query Statistics” before executing the script
  3. Execute the Script
  4. Check the Live Query Statistics window.

LiveQuery1

LiveQuery2

LiveQuery3

 

LiveQuery4

ByDr. SubraMANI Paramasivam

Data Awareness Programme @ MacLearn International College

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.

 

Appreciation Award to Tan Sri Datuk Seri M Kayveas

Appreciation Award to Tan Sri Datuk Seri M Kayveas

DataAP_Students_Teachers_Organizers_YSMCEO

DataAP Attendees, Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_Students_Teachers_Volunteers_Organizers_YSMCEO

DataAP Attendees, Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_Teachers_Organizers_YSM_team

Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_YSMCEO_DATUKSRI_Discussion

Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas discussion during Data Awarness Programme

DataAP_YSMCEO_DATUKSRI_Discussion

Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas discussion during Data Awarness Programme

DatukSri_CollegeHead_Chat_in_DataAP

DatukSri_CollegeHead_Chat_in_DataAP

DataAP_Lead_Students_Teachers_Volunteers_Organizers_YSMTeam

DataAP_Lead_Students_Teachers_Volunteers_Organizers_YSMTeam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Tan Sri Datuk Seri M Kayveas Speach

Tan Seri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

DAGEOP Malaysia team supporting the delivery of Data Awareness Programme

DAGEOP Malaysia team supporting the delivery of Data Awareness Programme

 

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

 

 

ByDr. SubraMANI Paramasivam

Data Awareness Programme @ Stamford College

Following the success of Data Awareness Programmes conducted in India, took a huge step in conducting the same program in Kuala Lumpur – Malaysia at Stamford College on 21/04/2014.

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 Your SQL Man 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.

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Introduction by Dr.Janet Lourds Rani

Introduction by Dr.Janet Lourds Rani

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

A slide in Data Awareness Programme sponsored by Your SQL Man Ltd

A slide in Data Awareness Programme sponsored by Your SQL Man Ltd

Sponsor Gift

Sponsor Gift

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

YSM_Banner_01

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

A Creativity session for one of the Students at Stamford College

A Creativity session for one of the Students at Stamford College

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Catchup with Dr.Janet Lourds Rani with Dr.Subramani Paramasivam and YSM Malaysia Team

Catchup with Dr.Janet Lourds Rani with Dr.Subramani Paramasivam and YSM Malaysia Team

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Attendees

Attendees

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

ByDr. SubraMANI Paramasivam

Volunteer

Being a DataAP volunteer, you will be proud in serving every community people, who really need your time and expertise. A BIG THANK YOU for all volunteers who volunteered in the past and for all current and future volunteers.

Get to know more about volunteering by sending an email to info@dataap.org

DataAP Fundraising Volunteers:

DataAP fundraising volunteers, are the key people, who make Data Awareness Programme a successful one.

“You don’t just raise money, but improve the quality of every individual on this earth”.

Volunteer your time:

Your esteemed time is the indestructible investment that any individual can do. Join your hands with us to help delivering the Data Awareness Programme a successful one.

Volunteer by giving a Speech:

Your can utilize this opportunity to start speaking in events and improve your communication & delivery skills. Also you receive a recognition of “DataAP Speaker”.

12