We are excited for PASS Summit 2017 coming up this fall! Pragmatic Works has been involved with PASS for over 10 years! Our Founder, Brian Knight, was on the board in 2001 and we have had almost 50 speaker sessions at PASS Summit since 2008. We will be participating again this year, speaking and being out on the expo floor.
Are you incorporating BI and data warehouse testing into your data world? If not, it’s time to give this more thought. The importance of testing your data warehouse and BI systems cannot be overlooked. Testing early in the process can save you time and effort, as well as allow you to make better business decisions.
We understand that the world of data can seem daunting, especially when you're a n00b. For those of you that fall in that category, as a Product Engineer, I offer this advice: "All you need is dedication and the foresight to start small and slowly scale up. With this mindset, you'll achieve great things."
In case you missed yesterday's Intro to SSIS webinar, or would simply like a refresher of some of the main topics covered, I invite you to continue reading this blog post.
Time is money. As a developer, I want to code as quickly as possible, and although I know the importance of documentation, it can be a painful chore. "It takes a village to manage a database" ...is NOT how the saying goes, but chances are, there will be times when you're not the only one parsing through your data and environments. Without good documentation, you're going to bog down your fellow programmers and DBAs, and this inefficiency could really cost you at a crucial time in development.
The 2017 Pragmatic Works Sales Beach Party was back in full swing this year - literally. The New Hampshire weather cooperated with a beautiful 80-degree day at Hampton Beach. Parasailing, surf lessons, a mean Can Jam tournament (not to mention a few cocktails) gave the team a much-needed break and time to enjoy the short New England summer. Around here we know all too well—don’t blink, we’ll be wearing flannel and watching the Patriots’ kickoff before you know it!
There's a lot of talk about the need for BI and data warehouse testing to identify and fix bad data out there. What is the real purpose of BI and data warehouse testing? The purpose of data testing is to identify defects, which will add the new challenge of remediating the error. Who in your organization should be responsible for this?
In this installment of the "Problem, Design, Solution" series, we are going to walk through the process of performing a text search using slicers in Power BI, simulating a “LIKE” type search. Please note that there is a video explaining the solution in-depth at the end of the blog under "Resources."
Let's face it - data is the lifeblood of any company. And for SQL Developers and DBAs, knowing the relationships and origins of data can be the difference between meeting a deadline or not.
As a new Product Engineer at Pragmatic Works, I find that a common issue developers face is knowing what is going to break downstream upon making changes to their ecosystem, like a package or table name, for example. Additionally, a common question may be, "How did my data get into this column?"