Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
In this Azure Every Day installment, I’d like to tell you how you can diffuse some time bombs that exist in your BI and Data Warehouse systems by migrating those platforms up to Azure. Here are 3 main areas where BI systems can have challenges and how Azure can help alleviate them:
1. Complicated ETL- Do you have a convoluted ETL that is hard to change or it has complicated business rules or no one really understands it? With Azure, there are lots of options we can use to make your ETL easier to manage and gain higher performance. By moving to the cloud, we can often take that ETL apart and move some of that processing and transformation closer to the data, by using HD Insight for Spark, for example. We can do it in a language like R or Python that can be better used by the business, as well as orchestrate that ETL better with Azure Data Factory.
2. Speed – Does it take a lot of time to make a change to your Data Warehouse environment? Let’s say a request comes in to add a column to the data warehouse and that takes 4 weeks. This time consumption leads to frustration for the business. By moving that environment into Azure, you get much more flexibility, which allows you to take advantage of speed. Not only can you make changes more quickly, but you can also make changes in other areas. For instance, maybe you only have to make a change to a model in Power BI or bring that data into Azure storage, instead of having to model it all the way through to the data warehouse.
3. Marginal Performance – Do you feel great about the performance of your data warehouse? If you’re answer is just “I feel OK," or the performance has never gotten better or it seems to gets worse, then move those workloads to the cloud. Migrate to the cloud and you’ll gain the flexibility which will give you more performance and control over where you’re investing your dollar. Whether you keep your workloads in a data warehouse or split them up there, you’ll now have the ability to scale them on demand, to predict when you need more or less performance, as well as to manage costs by not running them overnight or scaling out batch processing.
We’ve helped thousands of customers to think about their data strategy and migrate to Azure over the past few years. And we’re here to help you. We’d love to get your data strategy on the right track and help you move your BI environment into the cloud. Contact us or click the link below to get started today.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.