Showing posts with label Relational Data. Show all posts
Showing posts with label Relational Data. Show all posts

Wednesday, July 12, 2017

Go on, build apps with Microsoft Graph...

Microsoft SQL Server is for accessing data and Microsoft Graph is to access the myriad of things that are not really part of the database. The thing that spring to the mind are thins like, emails; your devices; the teams you work with; calendars; files; messages, peoples etc..

Also read this post on Graph databases:

http://hodentek.blogspot.com/2013/12/what-is-neo4j.html

A quick look at this image shows how Microsoft Graph is positioned.



Well, what is it Microsoft good for?

Believe me, you indeed have a great deal of use for it. Allow me to quote Microsoft:
'
Looks at your next meeting and helps you prepare for it by providing profile information for attendees, including their job titles and who they work with, as well as information on the latest documents and projects they're working on (pro-active, do diligence).

Scans your calendar, and suggests the best times for the next team meeting.

Fetches the latest sales projection chart from an Excel file in your OneDrive and lets you update the forecast in real time, all from your phone.

Subscribes to changes in your calendar, sends you an alert when you’re spending too much time in meetings, and provides recommendations for the ones you could miss or delegate based on how relevant the attendees are to you.

Helps you sort out personal and work information on your phone; for example, by categorizing pictures that should go to your personal OneDrive and business receipts that should go to your OneDrive for Business.
'
Behind Microsoft Graph is the Microsoft Graph API; a RESTful web api that enables you to access Microsoft Cloud serivce resources.
Come back to this blog again for more on Microsoft Graph.

Go here and gets started:

https://developer.microsoft.com/en-us/graph/docs/concepts/get-started

Sunday, December 15, 2013

What is Microsoft Power Query?

Sharpen you BI skill set!!

It is an Microsoft Excel add-in that is intended to enhance the Business Intelligence that you can carry out as it provides a simplified path to discover the data and access it. Once discovered the dat can be analyzed in EXCEL. It also has a US only Public search feature.
It is available in both x32 and x64 bit versions.
Features of Power Query:
The following types of data can be discovered,
  • Relational databases
  • Excel Spread sheets
  • Data in text
  • XML data
  • OData Feeds
  • Web Pages,
  • Hadoop HDFS and many others
You can mash up data from different sources and can be analyzed by Power Pivot and EXCEL.

It is supported on Windows 7, Windows 8. With .NET 3.5 SP1 it is also supported on Windows Vista, Windows Server 2008

You would also require,
Office 2013 professional plus
Office 2013 standalone
Excel 2013 Standalone
Office 2010 Professional Plus

Power Query is different from MS Query. How different? Follow this link:
http://hodentekhelp.blogspot.com/2013/12/what-is-difference-between-ms-query-and.html

Here is the ribbon tab for POWER QUERY

 
Here is how you access data or discover it.
 
 
Yet another great tool to work with.
 
 
 
DMCA.com Protection Status