In this module you will learn how to use the Gantt Power BI Custom Visual. Using the Gantt chart helps to easily visualize project timelines and deliverable completion.
Determining whether multidimensional or tabular is the optimal solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014/2016. During last week’s free webinar, our Senior Consultant Alan Faulkner introduced the common pitfalls with each solution and how to avoid them. He also highlighted new features of SQL Server Analysis Services 2016 and how they play a role in deciding the best solution to use.
When investing money in online training, you want to get the most for your dollar. Pragmatic Works Training Director, Devin Knight, knows the 5 hot tips on what you should be looking for when you purchase online training (e-learning) and how to get the biggest bang for your buck. Here’s what you should look for:
There are many reasons why your company should strongly consider using Azure SQL DW. However, the point of this post to convince you - the developer, consultant, architect, and/or accidental-DBA - that you should
start getting familiar with Azure SQL DW for one simple and hefty reason — Big Data.
Let’s face it, having to manually pull data from web services into another database platform is time consuming. Manually pulling data leaves room for error and takes time out of your busy day, which leads to inefficiency. REST Source is a component inside Pragmatic Works' Task Factory Suite which will automate the process of connecting to web services to pull information down into your SQL platform. You don’t have to be concerned with the process of getting the data you need – you can rely on it being all in one place. This lets you spend your time thinking about what you want to do with your data. Isn’t this a much better way to spend your time?
We are excited to announce our new course – Data Modeling! This course is designed for individuals who are in the process of designing new databases, particularly transactional databases and data warehouse systems. This six and a half hour course will guide you on the best methods and practices for creating proper data models.
There is a shift happening in modern Database Management and Business Intelligence — and it’s happening faster than you think.