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.
With that note, we conclude tonights SQL Server UGM. Good Night everyone. Thanks for tuning in.
See you all tomorrow.
Goodies are up for grabs for who answer questions asked by Dinesh.
Dinesh is done with his presentation as well.
Main advantage of Decision Trees: They are graphical and simple.
Disadvantage: more the attributes, the more time it takes to calculate. – Dinesh
By default, you can have a maximum number of 250 attributes for your model. – Dinesh
Since it takes a long time, Dinesh has made the model already.
Anyone, no one can have a 100% accuracy while data mining and predicting. – Dinesh
To mine data, Dinesh separates some of the predicted attributes for the demo.
Dinesh is going to show us a demo now.
Dinesh says his demo didnt go well last time, so he has a backup plan this time.
in Navy Base, relationships between attributes does not matter. The most important attribute should be used firstly in a data decision tree. – Dinesh
Dinesh shares a case study, and asks for user feedback for the attribute he provided.
Without knowing, we have done decision trees even when we were doing OLs. – Dinesh
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.
In Microsoft, there are many types of algorithms for data mining. We will be talking today about ‘Decision Trees’.
2nd speaker for today is Dinesh Asanka, MVP, Senior Database Specialist (Pearson Lanka) who will be talking on ‘Data Mining: Decision Trees’.
We are back.
We are having a quick refreshments break now. Be right back.
More about Power BI can be found here http://www.microsoft.com/en-us/powerbi/default.aspx
Thuru concludes his session with that note. Before leaving he will be asking some questions and will be giving away some goodies.
Thuru shares this image with us.
The new QnA feature is not very reliable, but it is a new step where you can query in your natural language. – Thuru
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
If you are already a Office 365 user, you should enable Power BI in Admin Center. – Thuru
It is actually playing a motion video inside EXCEL. – Thuru
With the help of Microsoft Power Map, you can create a video/slide/presentation out of the data you mine. – Thuru
And these outputs can easily be shares with your colleagues in your organization. – Thuru
As of now, companies are using this tool along with some other tools to track their market reach. – Thuru
Aftermath, a post with a picture attracts more likes. – Thuru
For a demonstration, Thuru analyzes the SQL Universe Facebook pages and finds out what kind of post attracts most number of likes.
When pulled an API to query, it shows graph data in the spreadsheet. – Thuru
You can import data from the search query to the spreadsheet.
You also can analyze your Facebook account or even a page. – Thuru
You ca do a random online search/query in EXCEL by adding these plugins. – Thuru
EXCEL features in Self Service BI: query, view, pivot and maps. – Thuru
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.
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.
Introduction to Power BI will be topic for Thurupathan Vijayakumar, Software Engineer (Pyxle).
We are starting.
Today it all will be about Business Intelligence.
The event will commence in a while. Stay tuned with us till then.
Good evening everyone. This is team digit Live from Microsoft Sri Lanka office for SQL Server Sri Lanka User Group Monthly meetup.