We had to trace which among our hundreds of Blackbaud Enterprise CRM (BBEC) ad hoc queries were using Site from the Designation node. We also needed to figure out if they were being used as output or being used as filter.
Here’s the script that did the trick.
You’re a SQL Server DBA and you want to learn Windows Server Failover Clustering? On April 20, 2015 MSSQLTips is hosting an online training, and you can learn from SQL Server MVP and MCM (Microsoft Certified Master) Edwin Sarmiento. Check out the details here:
Do you know that changing a shared axis chart to a stacked bar chart in Tableau is as easy as one drag?
Supposed you have a shared axis chart like this:
I had a question from one of my students tonight about how to show the header for text table with a single measure. It’s not super straightforward to do this in Tableau. You can’t simply to go the measure pill and show the header (because it doesn’t have it).
Let’s recreate the default Tableau behavior first, using Superstore Sales.
1. Double click on a dimension, for example, Product Category
2. Double click on a measure, for example, Sales
What you will get is something like this:
Note: DSC can only be run if you have at least Windows Management Framework 4.0 and if your operating system is at least Windows 8.1 or Windows Server 2012 R2.
The PowerShell team has released the xSQLPs module as part of the Desired State Configuration (DSC) Resource Kit. xSQLPs contains xSqlServerInstall, which you can use as a starting script when installing SQL Server via PowerShell and DSC. Download the module here.
This is what I needed to do to install SQL Server using DSC and the xSQLPs module. Many of these steps are from the xSQLPs documentation page.
The Microsoft Big Data Hackathon is happening in Vancouver. (Register here)
April 18-19, 2015 (Saturday and Sunday)
Simon Fraser University – Morris J Wosk Centre for Dialogue (Map)
580 W Hastings St
Vancouver British Columbia V6B 1L6
You will need to register for the event. Register here.
To participate, you will need to be part of a 3-5 member team.
Looking for someone to jumpstart your visual analytics project or prototype?
At BCIT, we have been offering a course on Visual Analytics using Tableau to Part Time Studies students. This course is offered three terms:
- Winter (January to March/April)
- Spring (April to June/July)
- Fall (September to December)
Many students who register for Part Time Studies are working professionals who are taking courses to complete additional certificates/diplomas, or for professional development, or just plain curious.
Students enrolled in the COMP 2256 class learn visual best practices, some data analysis, and visualization using Tableau Desktop. Part of this twelve (12) week course is a term project which requires data analysis and visualization around a topic of their choice. They will need to submit a series of dashboards and a final project report at the end of the term.
The project requires the students to either:
- look for a sponsor (could be their employer, a non-profit organization, etc) for their visual analytics project, to be presented to their peers at the end of the term
look for a number of sizable public data sets that they’re interested in, and essentially create dashboards that will support their story
I encourage students to, as much as possible, choose #1. This is as “real world” as it gets. However, looking for a sponsor can become tricky and time consuming for already-working professionals, so I am hoping I can help match up my students to your projects.
I really liked the @Always #LikeAGirl Superbowl XLIX halftime commercial. For me, it doesn’t really matter whether you’re male or female. But it is sad that there are still prejudices out there based on gender (among other things), but I hope it won’t stop anybody from trying – to live, to grow, to learn, to reach your dreams, and to do the best you can with anything that you do.
Take a closer look at the temperatures on the map:
The most recent Windows Management Framework (WMF) 5.0 Preview, the November 2014 preview, provides a glimpse of many improvements you can expect when PowerShell V5 is released.
A couple of the most noticeable additions are OneGet and PowerShellGet. If you have experience in *nix, these two new features are very similar to apt-get or yum or RPM. It allows you to connect to web-based package repositories, and install them.