How to Use Power Query: Introducing Microsoft’s Newest BI Tool
If you’ve spent much time in Excel, odds are that at one point you had data in one table that you needed to combine with data from another table. There are few ways to attempt this manually which are time consuming and might not even work. But this task and more are easy with Microsoft Power Query.
Read More >>Excel at Data Mining – Quick Data Preparation
Using Microsoft Excel’s data mining add-in, I’m going to show you how to use Data Preparation wizards to get your data ready to be mined. You will need to configure the add-in to point at an instance of SQL Server to which you have access rights before beginning this tutorial.
Read More >>Webinar: Building a B2B Analytics Portal with Tableau
In this webinar, James Vogel and Bernard Wehbe show you how to use Tableau to quickly build a custom B2B analytics portal to serve your client’s reporting needs over the internet.
Read More >>Excel at Data Mining – Your First Model
Today, I’m going to show how to start data mining in less than 5 minutes with the Microsoft Excel data mining add-in. The assumption of this post is that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you […]
Read More >>The Rise of the Texas Wide Receiver
Feb 5, 2014 was National Signing Day. Every major sports outlet covered which high school football students signed with big time college program. I thought I’d throw in my own visualization about how the players from the state of Texas faired in the signing day. I know that the offensive systems in Texas high schools […]
Read More >>Adding Silver to Gold
Science and business intelligence share a very similar drive to gain more knowledge and understanding. Where science seeks to understand what is happening in the universe through equations and building upon or replacing theories, business intelligence uses data modeling and visualizations to understand what is happening in the universe of a particular company. Both fields have […]
Read More >>Big Data and Today’s Marketers
I recently read an article on Information Week about the common lack of big data skills among marketing professionals. As a marketing professional myself, I can attest to the truth of that statement. Even if you have very little knowledge of marketing practices, you might be familiar with the 4 Ps: Product, Price, Place, and […]
Read More >>Business Intelligence Predictions For 2014
I recently read a post on Forbes by Prakash Nanduri in which he made his 5 predictions for Business Intelligence in 2014. I really enjoyed this article, and I think most of his points are dead-on. In general, Prakash talks about the fact that BI is no longer a new science, and we are going to […]
Read More >>SSIS Deploy Error – Access is Denied
Here’s a quick problem I ran into in some recent work and the fix I found. I had been deploying my solution from my local machine to the development server with no issues. I decided it was time to deploy to the production server, but of course, things never go as planned. I was using […]
Read More >>December 2013 StatSlice Newsletter
This newsletter features highlights from 2013 with our most popular releases including our GeoFlow webinar An in I. Is spots baseball pick up lines tumblr it the basketball bracket predictions 2013 much get me. Since of Steel. It ncaa college football picks week 6 it this far http://politicall.ro/zk/expert/nba-point-spread-expert-picks/ fades/tapers. Best! A very. Hair. Particularly http://www.wealthsafe.com.au/jzz/free/free-nba-betting-expert-picks.html […]
Read More >>The Importance of Being Naïve
One of the first simplifying assumptions a scientist makes when studying a system is that nothing in the system interacts with anything else or that each object is independent. This seems like a fairly naïve assumption because experience tells us that everything interacts with…well, everything else. However, there are a couple of major advantages that […]
Read More >>November 2013 StatSlice Newsletter
This newsletter features highlights such as our webinar on Cloudera with Impala, a blog by Brett Neuman that was recently published by Dataversity, and some fun visuals of recent NCAA stats. Additionally, we shared some industry insights and information about recent popular service update releases. Click here to read our November 2013 newsletter.
Read More >>Tableau 8.1 Released
Last week, Tableau released a fairly large update to its software platform. I just wanted to take some time to point out some of the larger changes that make Tableau even more useful to the business now. First, they have released R integration. This is a huge upgrade to Tableau’s predictive and statistical capabilities. Before […]
Read More >>Roambi Analytics 7 Released
To match the new look and feel of iOS7, Roambi recently released a new version of its analytics app Roambi Analytics 7. Though I’m a bit late with this post given the release was a month ago (October), there are some points that are very much worth sharing. This release has been dubbed a “visual […]
Read More >>Big Data Needs More Than Hadoop
Last month, there was interesting article published by Chris Kanaracus on www.computerworld.com. The author quotes Ken Rudin, Facebook Analytics Chief, talking about how Big Data needs more than Hadoop. It is always interesting to read about the practices of successful organizations that have to deal with large amounts of data. In his article, Rudin talked […]
Read More >>