Saturday, May 30, 2020

How to make a google map from excel, customize map view and share with p...







Here I show how to make a google map from excel file. Google map allows you to create custom map by uploading location data from excel or other format. You can customize base map view, share with people, embed to website or print to pdf.



The video of creating a google map from excel data file not only shows how to create a google map but also discuss on following google map features:

1. Importing excel data to map

2. Applying style to placemarker

 3. Applying label to placemarker

4. Apply base map

5. Display Map Preview

6. Sharing options

7. Adding a new place marker

 8. Routing line drawing between places

9. Direction between places

10. Distance measurement between places

11. How to print map

12. How to embed to website

13. Create new map using existing map



Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification.



In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v



 Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x



Social:

Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/trik...

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://imrulquaes89.tumblr.com/

RSS Feed: https://www.youtube.com/feeds/videos....



 Referral links that will not charge you but help me earning commissions:
Buy tubebuddy for your channel: https://bit.ly/2HP5lJR

Sunday, April 5, 2020

How To Schedule And Join A Zoom Meeting in Two Minutes







Learn how To Schedule And Join A Zoom Meeting with your free account in Two Minutes. In this video tutorial, I show you how to set up,  schedule and invite people to a zoom meeting, and how host and initiate a zoom meeting. You can host user conferences, executive briefing centers, customer and prospect events, webinars, or training sessions virtually over Zoom.

Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars. Zoom is a great video conferencing platform that allows you to schedule and hold video conference meetings with your team.

Zoom is removing the 40 min time limit on our Basic free account for K-12 schools affected by the COVID-19 Corona virus.

During corona virus situation, adapt to remote working, stay connected and productive in a remote work environment with the use of zoom.





Please watch till the end of the video, I hope you will enjoy it.

If you have enjoy the video, please go ahead and like it.

Write us in comment how helpful this video for you. If you think this
might be helpful for your friends, Please share the video with your
friends.

If you have any question, regarding the video, Please write us through
comments.



Please join in our community through subscription of channel and
subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs
that will help you enrich your technology knowledge.



Please subscribe
our channel to get updates of our videos.

Subscription link:
https://goo.gl/GE4g8v



Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x

Social:
Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/triksbuddy/

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://www.tumblr.com/blog/imrulquaes89

RSS Feed:
https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw

Thursday, March 12, 2020

How to get random rows in SQL? SQL Query to get Random data. Top N Random Records.

There are a number of ways to get Random data from database. Following are some examples that works without any extra algorithm:

SQL Server:

SELECT TOP 20 *
FROM table_name
ORDER BY NEWID()

MySQL:

SELECT *
FROM table_name
ORDER BY RAND()
LIMIT 20



PostgreSQL:

SELECT *
FROM table_name
ORDER BY RANDOM()
LIMIT 20

Oracle:

SELECT *  FROM
( SELECT *
FROM table_name
ORDER BY dbms_random.value )
WHERE rownum <= 20











Thursday, March 5, 2020

Indonesia Public Holidays 2020


  Indonesia Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Indonesia which is subject to change on official decision by the government of Indonesia.

DateDayHoliday
1 JanuaryWednesdayNew Year's Day
25 JanuarySaturdayChinese New Year
22 MarchSundayIsra Mi'raj
25 MarchWednesdayBali Hindu New Year
10 AprilFridayGood Friday
1 MayFridayLabour Day
7 MayThursdayWaisak Day
21 MayThursdayAscension Day of Jesus Christ
22 MayFridayLebaran Holiday
24 May to 25 MaySunday to MondayHari Raya Idul Fitri
26 May to 27 MayTuesday to WednesdayLebaran Holiday
1 JuneMondayPancasila Day
31 JulyFridayIdul Adha
17 AuguestMondayIndependence Day
20 AuguestThursdayIslamic New Year
29 OctoberThursdayProphet Muhammad's Birthday
24 DecemberThursdayChristmas Holiday
25 DecemberFridayChristmas Day


Wednesday, March 4, 2020

Thailand Public Holidays 2020

  Thailand Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Thailand which is subject to change on official decision by the government of Thailand.

Date Day Holiday
1 January Wednesday New Year's Day
25 January Saturday Chinese New Year
8 FebruarySaturdayMakha Bucha Day
10 FebruaryMondayMakha Bucha Holiday
6 AprilMondayChakri Day
13 April to 16 AprilMonday to ThursdaySongkran Festival
1 MayFridayLabour Day
4 MayMondayCoronation of King Vajiralongkorn
6 MayWednesdayVisakha Bucha Day
11 MayMondayRoyal Ploughing Ceremony
24 MaySundayEnd of Ramadan
3 JuneWednesdayQueen Suthida's Birthday
5 JulySundayAsahna Bucha Day
6 JulyMondayKhao Phansa Day
6 JulyMondayAsahna Bucha Day Holiday
7 JulyTuesdayKhao Phansa Holiday
28 JulyTuesdayKing Vajiralongkorn's Birthday
12 AugustWednesdayHer Majesty the Queen Mother's Birthday
13 OctoberTuesdayPassing of His Majesty the Late King
23 OctoberFridayChulalongkorn Memorial Day
5 DecemberSaturdayHis Majesty the Late King's Birthday
7 DecemberMondayHis Majesty the Late King's Birthday Holiday
10 DecemberThursdayConstitution Day
25 DecemberFridayChristmas Day
31 December Thursday New Year's Eve


Google Sheet Tutorial Basic Mathematical Functions & Formulas





Google Sheet Tutorial Basic Mathematical Functions and Formulas. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks. Google sheet is alternative to Microsoft Excel and have some facilities over Microsoft excel.


Referral links that will not charge you but help me earning commissions. Buy tubebuddy channel booster plugin for your channel: https://bit.ly/2HP5lJR

Please watch till the end of the video, I hope you will enjoy it. If you have enjoy the video, please go ahead and like it. Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments. Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v



Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x


Social:

Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/triksbuddy/

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://imrulquaes89.tumblr.com/

RSS Feed:
https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw



 #GoogleSheetTutorial, #triksbuddy

How to Draw Usecase Diagram using Draw.io







Learn How to Draw Usecase Diagram using Draw.io. This video shows you how easily you can draw usecase uml diagram using www.Draw.io. 

Use cases are a way of describing interactions between users and a system using a graphical model and structured text. They were first introduced in the Objectory method and have now become a fundamental feature of the Unified Modeling Language (UML). In their simplest form, a use case identifies the actors involved in an interaction and names the type of interaction. You then add additional information describing the interaction with the system. The additional information may be a textual description or one or more graphical models such as the UML sequence or state charts.

Use cases identify the individual interactions between the system and its users or other systems. Each use case should be documented with a textual description. These can then be linked to other models in the UML that will develop the scenario in more detail.

There are many tools available in the market for drawing use case diagrams. Visio is one of the most popular tool from microsoft which is not free for use. As an alternative of visio, draw.io is a great tool that allows you free access along with free storage and integration with other cloud applications like google drive, dropbox etc for storing you drawings.

 
 
If you have enjoy the video and get it interesting, please hit like button.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification. 
 
In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. 
Subscription link: https://goo.gl/GE4g8v 
Please subscribe in below link and like our video. 
Subscription URL: https://goo.gl/GE4g8v 
Channel URL: https://goo.gl/VYi58K 
Most Recent Videos: https://goo.gl/hXFN4w 
Most Popular Video: https://goo.gl/7u7B1x 
Social:
Facebook: https://www.facebook.com/triksbuddy/ 
Linked in: https://www.linkedin.com/company/triksbuddy/ 
Blog: https://triksbuddy.blogspot.com/ 
Tumblr: https://www.tumblr.com/blog/imrulquaes89 
RSS Feed: https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw
 

Creating a Meeting in GSuite Google Calender - triksbuddy







This video will shows way of creating a meeting in GSuite Google
Calender. Google GSuite allows you to create a meeting call easily using
google calender. The application allows you to setup meeting
notification which will be shown to the participants before the given
period of time before the meeting. GSuite allows you to setup available
meeting rooms of your organization. You can invite internal and external
guest.

Tuesday, November 26, 2019

Supervised, Unsupervised and Semi-supervised Learning Algorithm - Machine Learning Tutorial-02





This video demonstrates Supervised Learning, Unsupervised Learning and Semi-supervised Machine Learning Algorithm. Welcome to Introduction to Machine Learning - Machine Learning Tutorial.

Supervised Learning: In supervised learning, label data or output or supervisor data or teacher data is given in training data. Supervised learning must contain label data during training phase.
Supervised Learning Algorithms are:
- Nearest Neighbor (NN)
- K-Nearest Neighbor (KNN)
- Artificial Neural Network (ANN)
- Support Vector Machine (SVM)
- Decision Tree (DT) ex: ID3, C4.5
- Apriori Algorithm
- Hidden Markov Model (HMM)
- Logistic Regression
- Naive Bayes Classifier

Unsupervised Learning: In unsupervised learning only input data is given in training data. No label data or supervisor data is given. Unsupervised Learning separate data into clusters.

Un-Supervised Learning Algorithms are:
- K-Means Clustering
- Modified K-Means Clustering
- Hierarchical Clustering
- SOM (Self Organizing Map)
- Fuzzy C-Mean Clustering

Semi-Supervised Learning: In semi-supervised learning for some data label data is given and for some data label data is missing. Input data that are not labelled have to be labelled using labelled input training data. Then apply testing data for intelligent decision.

Please watch till the end of the video to get a clear concept of machine learning algorithms, I hope you will enjoy it.


Monday, November 18, 2019

Introduction to Machine Learning - Machine Learning Tutorial-01





Welcome to Machine Learning tutorial. This is introduction to machine learning which is the first video of this series.

In this video I have given a very easy definition of Machine Learning, shown application of Machine Learning in different sectors and different types of Machine Learning techniques.

In next video, I will discuss about different Machine Learning types in broader details.

The content of this video is primarily focused for computer science  undergraduate and graduate level students who wants to make clear understanding of machine learning algorithms with solving mathematical problems using machine learning algorithm. However any other interested learners who have high interest on learning Machine Learning can watch and join the community.

*Subscribe the channel and get in touch.
*If you have any query regarding Machine Learning concept please write in comments.
*If you think this video might be helpful for others, please keep sharing.