data analysis

Insiders are the millions who represent the billions – Dona Sarkar This is absolutely true. Each and every Windows Insider out there is an individual who represents not only themselves, but also – to varying degrees – countless others who don’t participate in this amazing program. One area...

When I was a kid, I developed a huge interest in golf. I was a good athlete who could play all traditional sports well but golf was different. I quickly developed a passion for the game and had a strong work ethic, but like many people, I found golf to be an elusive riddle. Despite non-stop...

Imagine you have a big list of cities and wanted to concisely get an idea of what the weather is like over there. If conciseness and speed wasn't a problem, you could look at a graph like this (below) for each city, but that's not fast. So what metrics would you need to accurately capture the...

We’ve already seen how to get your devices to send data to the cloud. In most cases, the data is then processed by various Azure services. However, in some cases the cloud is nothing more than a means of communication between two devices. Imagine a Raspberry Pi connected to a garage door...

I had the chance this weekend to personally walk through the garage before the race and see the use of Microsoft technologies helping speed up and improve the pre-race inspection of the cars. In addition, the use of new race management techniques built on Azure and Windows was truly inspiring...

The PGA TOUR ® showcases one of the most elegant sports in the world with a rich history and storied tradition. What most people don’t realize is what happens behind the scenes to pull off the great TOUR golf events that so many of us enjoy watching throughout the year. The TOUR has 600 players...

Sample databases and scripts for SQL Server 2016 CTP3. Link Removed

With new chart types and improvements to PivotTables and business intelligence (BI), Microsoft Excel 2016 makes it easier to work with large amounts of data and give it even more meaning. Unlock insights, and tell the story in your data by organizing it in spreadsheets (workbooks). View your...

In this video Sachin Patney and Nico Cristache describe the process of creating custom visualizations for Power BI. It is remarkable how easy it is to create any kind of visualization given the framework that's been set up. The best part of their explanation is where they detail the fact that...

17 of the many great posts, episodes and shows from last week. Can you feel the excitement building yet? Just a couple more weeks! Link Removed A technical evangelist explains how he uses OneNote for collaboration with his teammates. OneNote provides a central location where the entire team...

In this weeks episode of Data Exposed, Scott welcomes back Asad Khan, Principle PM on the HDInsight team. Today Asad shows us how easy it is to use 3rd party BI tools like Tableau to do data analysis for better insights into your data. This episode focuses on Tableau and we begin the episode by...

IoT is all the rage, but how do you connect those "things" TO the internet, to the cloud, to Azure? Luckily Visual C++ MVP Alon Fliess is here to help with a great blog post. Link Removed Introduction to the Internet of Things – From the Device to Microsoft Azure Cloud Technology advances in...

Datazen Publisher for Windows 7 allows you to create stunning data visualizations from Excel, SQL Server, SSAS, SQL Azure, SharePoint and other cloud & enterprise data sources. Link Removed

My name is Samer Sawaya – I’m a Senior Program Manager Lead on Windows Feedback, part of the Data and Fundamentals Team that Gabe Aul leads. Many of you have asked about what we do with all of the feedback that we receive in the Windows Insider Program, and how we’re able to use it all to inform...

In Windows 10 and Microsoft Edge we’ve made a lot of performance advances in the Chakra JavaScript engine. All with the goal of letting your JavaScript code run faster, taking as much advantage of the underlying hardware as possible, so that the web you create and experience in Microsoft Edge...

Scott talks to Wee Hyong Tok on how to analyze huge amounts of data with Azure Data Factory. Specifically, he shows us how to create a customer "churn model" so a theoretical telco provider can better understand how their wireless customers "churn" - why they leave and how they can get them...

We have a need to analyze sales by sales type , region and period (Month/Quarter/Year). When choosing the values from the above filters the 100% reference should be by the chosen filters and not by the whole derived data. For example, If I choose to filter and present Sales order of type...

What features have you found in Excel that would be useful to the management team? how would you use them?

IBM's supercomputer is ready to make the leap from analyzing massive data sets to actually helping us make the right decision. But will we be too proud to take Watson's advice? read more Link Removed

Learn how to use LINQ operators to filter, aggregate, and group data in observable sequences to produce desired results. Link Removed Link Removed Link Removed