<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Power BI Custom Visuals - Calendar by Tallan

Posted Aug 31, 2017 by Devin Knight

In this module, you will learn how to use the Calendar Custom Visual by Tallan.  The Calendar Visual provides a calendar layout that filters and aggregates data across a range of dates.

Getting Started with Azure Machine Learning

Posted Aug 30, 2017 by Bob Rubocki

I recently presented a webinar discussing how to use the Azure Machine Learning Studio to build a predictive model.  In case you missed it, a recording of the webinar, entitled "Getting Started with Azure Machine Learning," is available here. The presentation includes step-by-step demos showing how to create an Azure Machine Learning experiment.

Getting Started with LegiTest

Posted Aug 28, 2017 by Brian Knight

We believe that bad data is an epidemic. The effects that bad data has on your business, your production and your decisions should not be taken lightly. In fact, bad data is costing organizations an estimated $3.1 trillion per year. Are you looking for a way to test your data to solve your bad data problems and help you gain confidence in your data?

Power BI Custom Visuals - Visio Visual

Posted Aug 25, 2017 by Devin Knight

In this module, you will learn how to use the Visio Visual Custom Visual.  The Visio Visual allows you to embed Visio diagrams stored in either OneDrive for Business or Sharepoint Online in your Power BI reports.

New Software Release 2017.3

Posted Aug 24, 2017 by Pragmatic Works

At Pragmatic Works, we are constantly working to enhance and update our software to make it even better. A common question from customers and developers is, when are you going to be compliant with SQL Server 2017? Well—the time is now! All our software is now compliant with SQL Server 2017!

Announcing Our New Course: Power BI Administration

Posted Aug 23, 2017 by Pragmatic Works

We are excited to announce our new course, Power BI Administration! In the world of data, and as the amount of data continues to grow every day, security and data governance are of utmost importance. If you need to learn more about data security and governance for your role or your organization, then this course is for you.

PASS Summit 2017!

Posted Aug 22, 2017 by Adam Jorgensen

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.

Power BI Custom Visuals - Dot Plot by MAQ Software

Posted Aug 18, 2017 by Devin Knight

In this module,  you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes.

Arrange, Act, Assert - The Strategy for BI and Data Warehouse Testing

Posted Aug 17, 2017 by Tim Moolic

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.

SSIS for Beginners

Posted Aug 16, 2017 by Philip de la Cal

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.

Automate Your Documentation With DOC xPress

Posted Aug 14, 2017 by Philip de la Cal

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.

NH Sales Team Beach Party!

Posted Aug 14, 2017 by Pragmatic Works

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! 

Power BI Custom Visuals - Quadrant Chart

Posted Aug 10, 2017 by Devin Knight

In this module, you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants.

Real-World Data Testing: Remediating Bad Data

Posted Aug 09, 2017 by Tim Moolic

 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? 

Power BI - Problem, Design, Solution - Text Search Slicer

Posted Aug 08, 2017 by Mitchell Pearson


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."

The Benefits of Data Lineage and Impact Analysis with DOC xPress

Posted Aug 07, 2017 by Philip de la Cal

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?"

Power BI Custom Visuals - Beyondsoft Calendar

Posted Aug 03, 2017 by Devin Knight

In this module, you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single metric across a month calendar.

BI and Data Warehouse Testing Challenge: Time!

Posted Aug 01, 2017 by Tim Moolic

Bad data has become an epidemic across all industries in the world today. Bad data affects data quality and productivity, and also creates a lack of confidence that business owners have in their reports.


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates

Categories

show all categories