Sell an IT Project Using Waterfall, Manage It Using Agile

Today, there are plenty of examples of companies using the traditional waterfall project management methodology as compared to the agile methodology. Both methodologies are valid and have ample potential for success. That success always depends on the discipline of the project team and business. In my experience, it seems that most consulting firms pitch IT […]

Read More >>

College QB Stats Visualizations

As a former Texas A&M athlete, I’m a bit biased towards Johnny Manziel and his ability to make plays. I believe he is the best player on the field, and I’ve always looked forward to seeing him play. Besides that, everyday in my professional life, I look at data for my clients and try to […]

Read More >>

Webinar: Big SQL Analytics – Cloudera Using Impala

On October 22, Brett Neuman, Manager Consultant at StatSlice Systems, presented a webinar on Cloudera using Impala as part of our series on Big SQL Analytics. This webinar was recorded and is available below. This webinar is the third video in our series on Big SQL Analytics, and it covers the results of our Cloudera […]

Read More >>

Big SQL Analytics – Cloudera Using Impala

This is an overview of the webinar on Cloudera using Impala presented by Brett Neuman on October 22, 2013. For more information on this webinar, click here to view the video or continue reading to below. Overview In this webinar, Brett gives you an overview of Cloudera’s Impala platform and how you can use it […]

Read More >>

From LinkedIn’s Business Analyst Forum: Answering the question “How do you gather requirements”?

how business analysts gather requirements

Gathering requirements for any project, large or small, is the absolute most important task in the process. Any consultant will tell you that most projects fail here. It’s not that they fail to gather requirements, but the requirements gathered are almost never adequate enough to satisfy the business need. More often than not, the tools […]

Read More >>

Visualizing University Business Intelligence & Analytics Programs

Earlier this year, we collected information about the business intelligence and analytics programs that are currently being offered by universities in the United States.  Not surprisingly, there was an incredible amount of interest in the result of that data collection effort, with more than 1000 list downloads.  However, when I made an attempt at visualizing […]

Read More >>

Is Your Job Really In Jeopardy?

In few a short years, your job will be obsolete. We’ve all seen messages like that. It seems that every few years we get a rush of news stories about how the latest trends in technology are going to put us all out of business.  The media loves to sensationalize the notion that one day […]

Read More >>

Research Report: Business Intelligence Universities, Release 2.1 (Updated)

There has been an update to this report as of October 10, 2013. In May 2013, we released the first version of this report as a master list of universities in the United States and Canada offering degrees or certificates in business intelligence field. After extensive research, we are now releasing the second version of […]

Read More >>

Webinar: Big SQL Analytics – Amazon Redshift with Tableau

On September 24, James Vogel, Senior Consultant at StatSlice Systems, presented a webinar on the Amazon Redshift connector for Tableau as part of our series on Big SQL Analytics. This webinar was recorded and is available below. In this webinar, we walk you through connecting Tableau to Redshift and pulling in a large data set […]

Read More >>

Enabling SSIS Packages On Demand

Enabling SSIS Packages On Demand

In work with a current client, they required that the execution and processing of certain packages to be configurable via a web interface.  In my case, I wanted to proactively enable/disable the importing of certain data sources.  If a source system goes down or is in maintenance mode, I need to be able to shut […]

Read More >>

September 2013 StatSlice Newsletter

This newsletter features highlights such as our webinar on Amazon Redshift, a post with a summary of the Q&A session from our Redshift webinar, and a blog by one of our manager consultants on Slowly Changing Dimensions in SSIS. Additionally, we included a an announcement of our book which will be released in early 2014 […]

Read More >>

Big SQL Analytics: Redshift Webinar Q&A Summary

I recently conducted a webinar on Redshift as part of our Big SQL tools investigation series. At the end of the webinar, we had some pretty interesting questions and answers. I thought it would be a good idea to summarize the audience feedback in a blog. It would be helpful to view the webinar before […]

Read More >>

August 2013 StatSlice Newsletter

This newsletter features our new layout which we hope you will enjoy. It covers highlights such as our recent whitepaper Information Singularity and the Principles of the Analytics Rock Star, our webinar on Mobile Business Intelligence with Roambi, and an article we published Dataversity on “Using Both Waterfall and Agile Methods” in project management. In addition, we […]

Read More >>

Slowly Changing Dimensions in SSIS

Slowly Changing Dimensions in SSIS

One of the most critical pieces of any data warehouse is how you handle dimensions. Most dimension tables are modeled differently than fact tables because dimension records change more slowly than fact records. During a daily load, you may only have a single column that changes on one dimension record, but you will undoubtedly have […]

Read More >>

Executing an SSIS Package Based on a Variable

On my current client, I’m using Microsoft SQL Server 2008 R2 and SSIS, Integration Services. I’m updating the data warehouse fact tables every hour, but there is a fact table that only needs to be updated once per day. This is mainly because Is able a it’s art long. It’s nba tip off 2014 me. […]

Read More >>

Subscribe

You can subscribe to our RSS feed.

  • Categories