Do you want to learn how to migrate your workloads to Azure? In a recent webinar, Practice Manager and BI Architect, Bob Rubocki, discusses the best tips and tricks for migrating data warehouse workloads to Azure.
Data Warehouse
Best Practice for Your Power BI Data Sources
We all know there are lots of data sources; flat files like Excel files, CSVs that you import from another data source, connecting directly to a SQL Server or to SharePoint, or using a data warehouse architecture, as well as many others. The question is, are you using too many data sources with Power BI?
On-premise vs Cloud Modern Data Warehouse – Which is Right for You?
Many people ask the question, which is right for my company, on-premise or cloud modern data warehouse? In a recent webinar, David Hay, teaches you what you should look at to make the best decision for your organization between cloud vs on-premise modern data warehouse, as well as what the implementation process entails to stay within time and budget.
Do I Need a Star Schema?
As we’re building a data warehouse for clients, sometimes we’re asked about the need to build a star schema. With all the great analytical tools for querying and doing machine learning on top of data store and files that all work well, people think why do I need to build a star schema, or do I even need one at all?
Azure Data Lake vs Azure Blob Storage in Data Warehousing
In today’s post I’ll look at some considerations for choosing to use Azure Blob Storage or Azure Data Lake Store when processing data to be loaded into a data warehouse. My basis here is a reference architecture that Microsoft published, see diagram below.
5 Components of a Data Strategy
Businesses run on data – and the best organizations have a strong data strategy in place. We have consistent conversations with our customers about what they’re doing with their data and how they think about their data strategy. For the customers that get it right, we see 5 areas that they prioritize in terms of their strategy.
Do You Need a Relational Data Warehouse?
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come about that are changing the landscape of what data warehouses are made of. In this Azure Every Day session, I’d like to talk about 3 technologies in Azure and HDInsight that break the rules.
Diffusing BI Time Bombs with Azure
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:
What Should I Move to the Cloud?
There are many organizations like yours that are trying to figure out how to take that first step into the cloud this year. Maybe it will help to hear what we are seeing our customers make the highest priority as they are moving into the cloud.
SQL Data Warehouse – External Tables
Are you interested in learning how to load external files into SQL Data Warehouse? In a recent webinar taught by Pragmatic Works Principal Consultant, Daniel Taylor, he covered all the information you need to know when starting out with external tables, which he often uses with our customers.