DataOnWheels
The Changing World of BI, A New White Paper for Magenic
In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic, Chuck Whittemore (B), and I authored a white paper based on our experiences over the past months.
What I think makes our work unique, a BI architect and… Read more
0 comments, 1 read
Posted in DataOnWheels on 19 June 2013
Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
1 comments, 148 reads
Posted in DataOnWheels on 23 May 2013
Building My HDInsight Server Cluster
After all the hype about Big Data, Hadoop, and now HDInsight, I decided to build out my own big data cluster on HDInsight. My overall goal is to have a cluster I can use with Excel and Data Explorer. After all, I needed more data in my mashups. I am… Read more
0 comments, 157 reads
Posted in DataOnWheels on 24 April 2013
SQL Saturday#197–Omaha Recap
This was the second SQL Saturday hosted in Omaha. I loved to see how the event grew from the first event until now. John Morehouse ( T | B ) and team did another stellar job organizing this event. I know they packed the house
Having taken part in the… Read more
0 comments, 51 reads
Posted in DataOnWheels on 12 April 2013
Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
1 comments, 1,643 reads
Posted in DataOnWheels on 11 April 2013
Exploring Excel 2013 for BI Tip #5: Cleaning Up Slicers
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
0 comments, 210 reads
Posted in DataOnWheels on 29 March 2013
Exploring Excel 2013 for BI Tip #4: Adding a Slicer
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
0 comments, 285 reads
Posted in DataOnWheels on 28 March 2013
PowerPoint–My Dashboard and Report Design Tool
At some point I think that I am becoming a Microsoft Office specialist as opposed to a BI Architect. All of this work in Excel and now PowerPoint. Okay, done with the ramblings. As I have noted in a couple previous posts, I am working with a team on the… Read more
0 comments, 227 reads
Posted in DataOnWheels on 20 March 2013
Exploring Excel 2013 for BI Tip #3: Flash Fill
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
0 comments, 472 reads
Posted in DataOnWheels on 15 March 2013
Logging into Azure and Office365 with Different Accounts
I have been doing some work on the Modern Apps Live! content that required me to use both an Office365 account and an Azure account. My Azure work is currently associated with my Microsoft Account (formerly known as my Live ID). On the other hand, I am working with a… Read more
0 comments, 199 reads
Posted in DataOnWheels on 14 March 2013
Steps to Preload Data into Tables with SSDT
I am working as the data architect and developer on a modern app build with a the team from Modern Apps Live! in Vegas. The goal of the project is to provide guidance to build modern applications and use this application as a reference. While the conference is focused on… Read more
0 comments, 174 reads
Posted in DataOnWheels on 6 March 2013
Exploring Excel 2013 for BI Tip #2: Show Details
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
0 comments, 190 reads
Posted in DataOnWheels on 13 February 2013
Exploring Excel 2013 for BI Tip #1: Quick Explore
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
0 comments, 290 reads
Posted in DataOnWheels on 8 February 2013
Join Me at Modern Apps Live! Las Vegas
If you are familiar at all with Visual Studio Live! then you should check out this new conference. At the Vegas conference, I am participating in this unique three-day event which is a series of sessions that build on each other as the conference progresses called Modern Apps Live! The… Read more
0 comments, 154 reads
Posted in DataOnWheels on 5 February 2013
Exploring Excel 2013 as Microsoft’s Business Intelligence Client
A little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users. This coincided with the Office 2013 Preview release. I discussed the addition of Power View and PowerPivot into the product. Last week, I followed that article up with another on… Read more
2 comments, 310 reads
Posted in DataOnWheels on 4 February 2013
Are You Signed Up for 24 Hours of PASS–Business Analytics?
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great chance to hear 12 speakers (they will be repeated in the following 12 hours). Topics are varied from Big Data to Strategy to Collaboration. Most importantly you can’t beat the… Read more
0 comments, 337 reads
Posted in DataOnWheels on 29 January 2013
Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll
A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted my career. I do this as a tribute to my father-in-law, Ed Jankowski who passed away a few years ago. Check out my original post about him and his impact… Read more
1 comments, 271 reads
Posted in DataOnWheels on 29 January 2013
PASSMN–Passing the Baton: A Board Transition Story
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been on the board for the past three years during which we switched term lengths to two years with staggered elections, but more about that later.
During the PASS Summit this… Read more
0 comments, 223 reads
Posted in DataOnWheels on 12 December 2012
PASS Summit 2012 Wrap Up
Wow, what a week. Once again, PASS put on a great event that provided much in the way of events and training for the SQL Server community. If you followed my countdown you know some of what I love about PASS. Last year I blogged everyday but I did not… Read more
1 comments, 213 reads
Posted in DataOnWheels on 13 November 2012
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
0 comments, 223 reads
Posted in DataOnWheels on 12 November 2012



Subscribe to this blog