StatSlice Business Intelligence and Analytics | Business Intelligence and Analytics Dallas | Business Intelligence Training Dallas

Archive for the ‘Justin Taylor – Blog’ Category

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

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

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

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

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

Using Both The Waterfall And Agile Methods

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

SSRS – Applying Parameter Default Value Using Custom Code

On a recent client engagement, I had to put in some default values for my parameters. No big deal. Normally, I just use the DEFAULT property of the Report Parameter, but this time was a little different. I needed to default the parameter to a different item depending on another selection of a report parameter. […]

Read More

Microsoft Announces SQL Server 2014 during Microsoft TechEd 2013

Last week during Microsoft TechEd 2013, Microsoft announced plans to incorporate in-memory OLTP in SQL Server 2014. They also expanded on some features included in the upcoming release.

Read More

Reducing the Risks in an Analytics Implementation

This insightful industry view offers several important concepts to help you avoid some risks when building an analytics solution. Topics include tool expectation issues, internal resistance to change, poor data quality, scope creep…

Read More

Subscribe

You can subscribe to our RSS feed.

  • Categories