Business Intelligence

Microsoft’s Power BI a Leader in BI Solutions in the 2020 Gartner Magic Quadrant Report

We’re excited to share that, once again, Microsoft is a leader of Analytics and Business Intelligence (ABI) platforms in the 2020 Gartner Magic Quadrant – this is the 13th straight year that Microsoft has been recognized. In this Magic Quadrant report the analytics and BI platforms available on the market are compared based on their features, usability, and capabilities; and Power BI was a top leader.

3CloudMicrosoft’s Power BI a Leader in BI Solutions in the 2020 Gartner Magic Quadrant Report
Read More

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.

3CloudOn-premise vs Cloud Modern Data Warehouse – Which is Right for You?
Read More

Data Architecture for Azure BI Programs

A Bit of Intro
If I recall correctly, I completed the first version of this data architecture diagram in 2012 when we used terms like “road map” and “blueprint”  Back  then, along with different terms, we were also using traditional SSIS, SSAS-MultiD and SSRS tools.  Now we live in the world of cloud everything, although we are still driving from SRC-to-DST (source to destination).  I’m up for whatever terminology you want to use, but can we agree that we are surely on a different highway?  For my classical BI Blueprint, click here, but to see an Azure road map for BI, please take a look below.

Disclaimer: I create a different diagram for every engagement, so think of this as a suggestion, not a mold.

Tom WardData Architecture for Azure BI Programs
Read More

ETL with Power BI Dataflows

free training with joe abbottUnless you’ve been living under a rock, you’ve heard of Power BI. In case you don’t know, Power BI is a business analytics solution from Microsoft that lets you visualize your data and share insights across your organization or embed them in your app or website. You can connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Tom WardETL with Power BI Dataflows
Read More

Transitioning from Traditional to Azure Data Architectures

Confession: I put a lot of subtexts in this blog post in an attempt to catch how people may be describing their move from SSIS to ADF, from SQL DBs, to SQL DWs or from scheduled to event-based data ingestion.  The purpose of this post is to give you a visual picture of how our well loved “traditional” tools of on-prem SQL Databases, SSIS, SSAS and SSRS are being replaced by the Azure tool stack.  If you are moving form “Traditional Microsoft” to “Azure Microsoft” and need a road map, this post is for you.

Summary of the Matter: If you only read one thing, please read this: transitioning to Azure is absolutely “doable”, but do not let anyone sell you “lift and shift”.  Azure data architecture is a new way of thinking.  Decide to think differently.

First Determine Added Value:  Below are snippets from a slide deck I shared during Pragmatic Work’s 2018 Azure Data Week.  (You can still sign up for the minimal cost of $29 and watch all 40 recorded sessions, just click here.)  However, before we begin, let’s have a little chat.  Why in the world would anyone take on an Azure migration if their on-prem SQL database(s) and SSIS packages are humming along with optimum efficiency?  The first five reasons given below are my personal favorites.

  1. Cost (scale up, scale down)
  2. Event Based File Ingestion
  3. File based history (SCD2 equivalent but in your Azure Data Lake)
  4. Support for Near Real Time Requirements
  5. Support for Unstructured Data
  6. Large Data Volumes
  7. Offset Limited Local IT Resources
  8. Data Science Capabilities
  9. Development Time to Production
  10. Support for large audiences
  11. Mobile
  12. Collaboration

Each of the reasons given above are a minimum one hour working session on their own, but I’m sharing my thoughts in brief in an effort to help you to get started compiling our own list.  Please also look at the following diagram (Figure 1) and note two things: a.) the coinciding “traditional” components and b.) the value add boxed in red.

Tom WardTransitioning from Traditional to Azure Data Architectures
Read More

BI Platform Architecture, Development and Administration

michael fWhat do you know about consumption-based architecture? This refined approach to data analytics has been implemented with some of our clients to help them meet their organizational needs. In a recent webinar, BI Platform Architecture, Development and Admin, Michael French shows how to utilize this architecture for your business.

Tom WardBI Platform Architecture, Development and Administration
Read More

Microsoft Leads the Pack with Power BI in Gartner’s Magic Quadrant of BI and Analytics Solutions

We’re excited to share a special report released called the Magic Quadrant by Gartner, which does an analysis of BI platforms and shows how different competitors stack up against each other. We’re excited to say that one of the leaders when it comes to BI and analytics tools is Microsoft, and the primary push to the top comes from Power BI!

Tom WardMicrosoft Leads the Pack with Power BI in Gartner’s Magic Quadrant of BI and Analytics Solutions
Read More