Home Events Live Blog – SQL Server Sri Lanka User Group Meetup : April

Live Blog – SQL Server Sri Lanka User Group Meetup : April

2243

The SQL Server Sri Lanka User Group (SS SLUG), a sub-project of SQLServerUniverse is an offline community of SQL Server enthusiasts who meet every month to discuss and learn about SQL Server and related technologies. Once registered on SQLServerUniverse.com, everyone automatically becomes a member.

Scheduled to start at 6 PM today at Microsoft Sri Lanka Office.

More info here.

From Press From Press Apr 23, 20147:53 pm

With that note, we conclude tonights SQL Server UGM. Good Night everyone. Thanks for tuning in.

See you all tomorrow.

From Press From Press Apr 23, 20147:51 pm

Goodies are up for grabs for who answer questions asked by Dinesh.

From Press From Press Apr 23, 20147:51 pm

Dinesh is done with his presentation as well.

From Press From Press Apr 23, 20147:46 pm

Main advantage of Decision Trees: They are graphical and simple.

Disadvantage: more the attributes, the more time it takes to calculate. – Dinesh

From Press From Press Apr 23, 20147:41 pm

By default, you can have a maximum number of 250 attributes for your model. – Dinesh

From Press From Press Apr 23, 20147:36 pm

Since it takes a long time, Dinesh has made the model already.

From Press From Press Apr 23, 20147:32 pm

Anyone, no one can have a 100% accuracy while data mining and predicting. – Dinesh

From Press From Press Apr 23, 20147:27 pm

To mine data, Dinesh separates some of the predicted attributes for the demo.

From Press From Press Apr 23, 20147:24 pm

Dinesh is going to show us a demo now.

From Press From Press Apr 23, 20147:23 pm

Dinesh says his demo didnt go well last time, so he has a backup plan this time.

From Press From Press Apr 23, 20147:20 pm

in Navy Base, relationships between attributes does not matter. The most important attribute should be used firstly in a data decision tree. – Dinesh

From Press From Press Apr 23, 20147:16 pm

Dinesh shares a case study, and asks for user feedback for the attribute he provided.

From Press From Press Apr 23, 20147:13 pm

Without knowing, we have done decision trees even when we were doing OLs. – Dinesh

From Press From Press Apr 23, 20147:11 pm

The Microsoft Decision Trees algorithm is a classification and regression algorithm provided by Microsoft SQL Server Analysis Services for use in predictive modeling of both discrete and continuous attributes. Join Dinesh as he continues his series on Data Mining.

From Press From Press Apr 23, 20147:10 pm

In Microsoft, there are many types of algorithms for data mining. We will be talking today about ‘Decision Trees’.

From Press From Press Apr 23, 20147:09 pm

2nd speaker for today is Dinesh Asanka, MVP, Senior Database Specialist (Pearson Lanka) who will be talking on ‘Data Mining: Decision Trees’.

From Press From Press Apr 23, 20147:08 pm

We are back.

From Press From Press Apr 23, 20146:57 pm

We are having a quick refreshments break now. Be right back.

From Press From Press Apr 23, 20146:56 pm

More about Power BI can be found here http://www.microsoft.com/en-us/powerbi/default.aspx

From Press From Press Apr 23, 20146:53 pm

Thuru concludes his session with that note. Before leaving he will be asking some questions and will be giving away some goodies.

From Press From Press Apr 23, 20146:51 pm

Thuru shares this image with us.

http://4.bp.blogspot.com/-HU8RaS3W0GY/UAU1EqfX8MI/AAAAAAAABZU/0jbTQULTMsU/s1600/Self-Service+Business+Intelligence+Platforms.PNG

From Press From Press Apr 23, 20146:43 pm

The new QnA feature is not very reliable, but it is a new step where you can query in your natural language. – Thuru

From Press From Press Apr 23, 20146:41 pm

After uploading your EXCEL file in the Power BI app in Office 365, you can share it in your organization and view the same graph. – Thuru

From Press From Press Apr 23, 20146:36 pm

If you are already a Office 365 user, you should enable Power BI in Admin Center. – Thuru

From Press From Press Apr 23, 20146:33 pm

It is actually playing a motion video inside EXCEL. – Thuru

From Press From Press Apr 23, 20146:32 pm

With the help of Microsoft Power Map, you can create a video/slide/presentation out of the data you mine. – Thuru

From Press From Press Apr 23, 20146:30 pm

And these outputs can easily be shares with your colleagues in your organization. – Thuru

From Press From Press Apr 23, 20146:26 pm

As of now, companies are using this tool along with some other tools to track their market reach. – Thuru

From Press From Press Apr 23, 20146:25 pm

Aftermath, a post with a picture attracts more likes. – Thuru

From Press From Press Apr 23, 20146:23 pm

For a demonstration, Thuru analyzes the SQL Universe Facebook pages and finds out what kind of post attracts most number of likes.

From Press From Press Apr 23, 20146:21 pm

When pulled an API to query, it shows graph data in the spreadsheet. – Thuru

From Press From Press Apr 23, 20146:19 pm

You can import data from the search query to the spreadsheet.

You also can analyze your Facebook account or even a page. – Thuru

From Press From Press Apr 23, 20146:18 pm

You ca do a random online search/query in EXCEL by adding these plugins. – Thuru

From Press From Press Apr 23, 20146:16 pm

EXCEL features in Self Service BI: query, view, pivot and maps. – Thuru

From Press From Press Apr 23, 20146:15 pm

What is power BI? Thuru says he will directly jump in to a demo rather than trying to answer this question.

EXCEL is going to be the main component used.

From Press From Press Apr 23, 20146:13 pm

Self-service BI is the new kid on the block in business intelligence circles: The power of quickly and easily building solutions to your burning business problems without the need for IT. Microsoft’s exciting new offering coupled with Office 365 brings you Power BI. Join this session for a walk-through of the basics of Power BI.

From Press From Press Apr 23, 20146:12 pm

Introduction to Power BI will be topic for Thurupathan Vijayakumar, Software Engineer (Pyxle).

From Press From Press Apr 23, 20146:11 pm

We are starting.

Today it all will be about Business Intelligence.

From Press From Press Apr 23, 20146:02 pm

The event will commence in a while. Stay tuned with us till then. :D

From Press From Press Apr 23, 20146:02 pm

Good evening everyone. This is team digit Live from Microsoft Sri Lanka office for SQL Server Sri Lanka User Group Monthly meetup.

Comments

comments

NO COMMENTS

Leave a Reply