Just another Blog

My Technical, Professional and at times Personal Blog

Recent Posts

Microsoft launches “Data Explorer" Preview bringing Big Data to Excel


image
Microsoft announces the availability of Data Explorer for Excel 2013 that enhances the Self Service BI using Excel by simplifying data discovery and access to a broad range of data sources including Private or Public data. “"Data Explorer" provides an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Data Explorer also provides you with the ability to search for public data from sources such as Wikipedia.”
Get Data from the Web:
image
Online Search lets you Search, Preview and Import Data into Excel.
image
Here is a preview of the List of States and School Superintendent
image
If you have a Web Page that contains a table of information, you can get directly from that web page. Below, I am importing data from the wikipedia for a list of countries by population.
image
You are presented with the Query Panel Window as seen below:
image
image
image
With the data Explorer, you can import data from other files such as Excel, CSV, XML, Text and from a folder. I like the new import files from a folder.
image
With Data Explorer, you can import data from databases such as SQL Server, SQL Database on Windows Azure, Access, Oracle, IBM DB2 or MYSQL.
image
With Data Explorer, you can import data from non-traditional data sources such as SharePoint List, OData Feed, Hadoop (HDFS), Windows Azure Marketplace, Active Directory and Facebook!
image
Let’s try importing some data from Facebook into Excel.
image
image
Here it is, my facebook posts right within Excel
image
image
You can also manage Credentials from right within Data Explorer, which was my most desired feature in PowerPivot. I remember tweeting about this many times in frustration of having to repeat providing credentials every time I connect to a data source. Thank you Microsoft Data Explorer team for implementing this! Smile
image
In summary, Excel 2013 brings more than ever self-service BI capabilities to end users. From the Forrester Research Report from Q2 2012 - “We maintain that in an ideal BI environment, 80% of all BI requirements should be carried out by the business users themselves.”
If you are looking to quickly build out a self-service BI solution that tells the story of your data, you can now use Excel to rapidly mash-up, explore, analyze and visualize any data ranging from a few rows to hundreds of millions of rows.
Excel 2013 comes built in with the all new xVelocity in-memory analytics engine that let’s you analyze data ranging from a few rows to hundreds of millions of rows instantly on your desktop using Excel data models.
What about data visualizations? PowerView provides stunning data visualization where in you can discover new insights with a highly interactive and familiar data exploration, visualization, and presentation experience right within Excel.
Use Excel 2013 Quick Analysis to preview and apply conditional formatting, suggest and create charts, PivotTables, and tables; and using Quick Explore to easily navigate multidimensional and tabular data models.
With PowerPivot you can access, mash-up and analyze data from virtually any source and rapidly create compelling analytical models with PowerPivot. I do see some overlapping features between Data Explorer and PowerPivot as far as data acquisition is concerned, but I consider it as a good thing.
Being a data geek that I am, I feel satisfied with what Excel 2013 has to offer to the large Self Service BI community out there and specifically happy with where Data Explorer is headed.
You can download Data Explorer from the below location:
image

Why won’t Microsoft Lync 2010 start?

Have you ever clicked on Microsoft Lync 2010 (communicator) only to find out that nothing happens? I am not exactly sure what is causing it, but I have noticed that If I start Outlook 2010 first before Lync 2010, Lync 2010 does not like it.

image

If you look at your task manager, you’ll see that the communicator.exe*32 processes are backlogged. Try killing these processes and launching Lync again. Hopefully it’ll work. It my case, it definitely worked. Good luck.

Favorite features in Office 2013

(Courtesy: Internet)

Learn new Office tricks and tips everyday, checkout TimeTo365.com where customers of Microsoft Office are sharing their favorite tips. Here are some of the favorites presented by Doug Thomas:

Template Library Increase your productivity right off the bat by using templates.

image

Smart Guides Perfectly align shapes and images in a presentation by customizing color using smart guides

image

Outlook Unfinished emails are saved in Drafts and all drafts are clearly visible in your inbox

image

Outlook New Weather bar in Outlook that shows you a 3-day forecast

image

Word PDF Reflow You can convert PDF documents into editable Word documents

image

References:

Office Tips and Tricks

Office 2013 Quick Start Guides

Office Touch Guide

Office Blog

Microsoft Office: Top 10 Tips

  1. Ignore Conversations in Outlook
  2. Wedge Mouse – didn’t know something like that exists!
  3. Excel 2013 Insert Live Chart – gives you a nice preview of what your chart would look like before actually creating one
  4. Instant Math in OneNote – gotta love OneNote
  5. Templates with Instructions
  6. Excel Surveys in Office Web Apps – this looks similar to a google spreadsheet form
  7. Copy Docs in Program
  8. Get Windows Surface RT with Office 2013
  9. Office Web Apps + SkyDrive in Windows Explorer – Download Skydrive for windows
  10. PDF reflow in Word 2013 – take a PDF and make it editable

Got any more? Leave me a message below.

Collection of FREE HTML Editors

To create awesome looking websites, you need the best HTML, JavaScript/jQuery editors. So, here is my collection of the best HTML editors that go beyond just plain HTML such as giving you a nice Integrated Development Environment (IDE) for JavaScript, jQuery, CSS, HTML5 etc. As always, leave me a comment if you have used other HTML editors that you found useful and I'll add it to this list.

HTML and JavaScript go hand-in-hand, so here is a collection of JavaScript resources for easy reference.

JavaScript Resources–FREE Videos, Books, Training and more



There has never been a better time to learn JavaScript. Whether you are a novice or an expert JavaScript Developer, there is always something to learn. Here is a reference of JavaScript videos, books and training I created for myself. If you know of any more, feel free to leave me a comment and I will add it to this list.
Happy Learning.
# Resource Name Resource Topic Resource URL
1 Javascript Fundamentals: Development for Absolute Beginners JavaScript http://channel9.msdn.com/Series/Javascript-Fundamentals-Development-for-Absolute-Beginners
2 JavaScript: The Language JavaScript http://channel9.msdn.com/events/mix/mix11/HTM06
3 JavaScript: The Developer Experience JavaScript http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV308
4 Writing Maintainable JavaScript JavaScript http://channel9.msdn.com/events/mix/mix11/EXT23
5 Developing HTML5 Apps HTML5 http://channel9.msdn.com/Series/MVA-Jump-Start
6 JavaScript Core Capabilities JavaScript http://channel9.msdn.com/Series/MVA-Jump-Start/Developing-HTML5-Apps-Jump-Start-04a-JavaScript-Core-Capabilities-Part-1
7 JavaScript Core Capabilities JavaScript http://channel9.msdn.com/Series/MVA-Jump-Start/Developing-HTML5-Apps-Jump-Start-04b-JavaScript-Core-Capabilities-Part-2
8 JavaScript Gotchas JavaScript http://channel9.msdn.com/Events/aspConf/aspConf/JavaScript-Gotchas
9 Using JavaScript to Build HTML5 Applications JavaScript http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DEV347
10 Modern JavaScript JavaScript http://channel9.msdn.com/Events/Build/2012/3-014
11 Building Metro style Apps with HTML and JavaScript JavaScript http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV366
12 Interactive Panel: JavaScript JavaScript http://channel9.msdn.com/events/MIX/MIX11/RES02
13 ECMAScript 5: The New Parts JavaScript http://channel9.msdn.com/events/mix/mix11/EXT13
14 Building HTML and JavaScript Apps with KnockoutJS and MVVM JavaScript http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV361
15 JavaScript Tutorials Playlist JavaScript http://www.youtube.com/course?list=EC46F0A159EC02DF82
16 jQuery Tutorials Playlist jQuery http://www.youtube.com/course?list=EC6B08BAA57B5C7810
17 Google I/O 2011: Learning to Love JavaScript JavaScript http://www.youtube.com/watch?v=seX7jYI96GE
18 John Resig: Javascript and jQuery jQuery http://www.youtube.com/watch?v=GKfHdOrR3lw
19 JavaScript Weekly Subscription JavaScript http://javascriptweekly.com/
20 32 Talks from the JS.everywhere() 2012 Conferences

JavaScript http://www.youtube.com/playlist?list=PL2PF2oGPokReHxddTOGehBS_w8-prtOBE
21 Bocoup JS Screencasts JavaScript http://training.bocoup.com/screencasts/
22 Building High-Performing JavaScript for Modern Engines JavaScript http://channel9.msdn.com/Events/Build/2012/4-000
23 JS Conf EU Videos JavaScript https://www.youtube.com/jsconfeu
24 Scripted: A JavaScript editor from VMware JavaScript http://blog.springsource.org/2012/10/11/scripted-a-javascript-editor-from-vmware/
25 Pure JavaScript JavaScript http://vimeo.com/49384334
26 Zen and the Art of TDD

JavaScript http://vimeo.com/49092644
27 Make JavaScript Testing Fun With Testem JavaScript http://www.youtube.com/watch?v=I0Py_tqCkTo&list=UUd-EhXGbXSozuzsAAdPIn3A&index=8
28 Javascript: Your New Overlord JavaScript http://www.youtube.com/watch?v=Trurfqh_6fQ
29 Douglas Crockford: The JavaScript Programming Language . JavaScript http://www.youtube.com/watch?v=v2ifWcnQs6M
30 JavaScript WTFs JavaScript http://www.youtube.com/watch?v=WkFoGp1ECGE&list=PLgyU3jNA6VjTbotteFzpoooyJiNlAMRpx
31 Free JavaScript Books JavaScript http://jsbooks.revolunet.com/
32 Learn to Code for Free at Codeacademy.com JavaScript http://www.codecademy.com/#!/exercises/0

Google+ Followers