Snowflake is a leading data warehouse (DWH) tool and the chances are high that you will encounter a Snowflake DWH in the near future. Additionally, Power BI is an industry leader in data modeling and visualization, it owes much of its power to its Tabular Model built with DAX and Power Query...

We needed a slick way to overcome these challenges….

• how do I know that my consultants are contributing equally towards our minimum float amount?

• How do I know I’m using my teams efficiently?

• Which contracts are experiencing churn?

• What contracts are taking too many resources?

• How do I know that my Actual Billings match work completed?

DAX Measures are fundamentally different from calculated columns. They allow the user to aggregate and manipulate data in ways that calculated columns can not. What if there was a way to get the attribute like functionality of a calculated column, with the flexibility of a measure?…

Growing business often run into similar problems on the quest for greatness. Most of these problems are encountered while pursuing the following:

• The quest for profitability on projects and engagements with customers.

• Centralized intelligence about the performance of projects and consultants. 

• Analytics on the quality and speed of service to customers.

The possibilities and utility that bookmarks add to reports really is impressive. Though this feature is not brand new, it remains an extremely relevant tool and therefore is worth the time required to educate ourselves on the many uses.

Real life examples are excellent for relaying meaning. Therefore, I’m going to show one of my own reports and five unique ways I used bookmarks to enhance the user experience…

With unpaid work, unfavorable payment terms, profitability measurement, project delays and technology adoption all major challenges stacking up against construction companies, this dashboard is an adoption of a technology that provides executives with real-time analytics in these key areas…

Project timelines are a key component to taking on any BI solution venture. But in our experience, many time lines miss the mark. So what is it that we have found makes an effective timeline?…

Hello again, if you read our last blog, you will remember that we outlined three of the most common scenarios that we find our customers in need of Azure Data Factory. We also showed you the architecture required to bring their solutions to life. Today our goal is to make our way all the way through the process of using Azure Data Factory to migrate an existing Amazon S3 database…

In our time working with Azure cloud solutions, we have identified three key data integration scenarios that we want to share with you. Understanding and planning your architecture is a key part of adopting any piece of the Azure Cloud or Azure Data Stack….

In this blog post we will walk you through the steps that it takes to bring experimentation in R to life in PowerBI. The script used in this blog has is developed in detail in our training package (available here).

Often while working in Power BI Desktop, developers will be required to swap data sources depending on their environment. This can be cumbersome. Luckily, we have a solution to this problem…

In the podcast below Ed Kless and I have a chat about FreshBI and our experience in the hurdles faced by small businesses in adopting organizational Business Intelligence.

Without easy, consistent access to your dashboards, your team is less likely to use the dashboard suite and unlikely to adopt it. Power BI allows for a 3 different distribution methods…

Custom Financial Statements do not come naturally to PowerBI. There’s no way to denote sub totals, no way to make easy, ordered groupings and no way to set the layout…….

Whether it be Sage X3, Microsoft Dynamics, Excel, or just about any on-premises data source, the Microsoft Data Gateway is the go to method of connectivity.....

Over the years, Microsoft Analysis Services has taken a few forms. Starting out as an OLAP service, in 1996, it's grown to be the backbone of modern analytics. The original SSAS models were all hulking, multidimensional beasts, scary to the average developer. But that all changed in 2009 when SSAS got a facelift in the form of Tabular SSAS.

There are many important measures in the realm of data analytics and visualization. Some of which are very well known, e.g. mean, correlation, variance, standard deviations. While some of these are very straight forward and can be done quickly in Power BI, there are some that just need the extra computational power....

Register for an upcoming Dashboard In A Day workshop hosted by FreshBI, in collaboration with Microsoft...

It all comes down to bookmarks today. Our goal at FreshBI is to push the boundary of what Power BI is capable of, and as we do, we learn more. We want to share some of this with you today. Going through the motions of utilizing tools in unconventional ways exercises our brain and familiarizes us with the potential that these tools provide.

For a business that cares about data-driven decisions the business value of adopting power BI Solution Templates is immense and is a contrast to the traditional approach of building an organization wide  Business Intelligence Solution for your business, from scratch and composed of disparate teams, technologies and builds.