What's Hot with Power BI?
Discover what our Microsoft Power BI Experts have been working on. When we're not helping you excel, we're finding ways to share our latest research to help business owners like yourself excel. Try our business intelligence templates and see how you can create a Power BI dashboard of your own!
Power BI Custom Connector for Xero Accounting
This custom connector allows you to integrate your Xero data with ANY other dataset. No more warehousing, no more refresh latency and no more canned reporting. You integrate with your data. All of your data.
DataMonsters: Power Apps, Blobs and Power BI Pt.2
Here’s how to use PowerApps, Azure blob storage, PowerBI sandwich!
Biz Intelligence: Investment or Shiny Toy ?
If companies could see at a glance, where and how much their investment in BI is bolstering their value chain, they'd want to see that…..
DataMonsters: Power Apps, Blobs and Power BI Pt.1
Here’s how to use PowerApps, Azure blob storage, PowerBI sandwich!
Power BI Template App Example
Wouldn’t it be nice to pick your entire Power BI Solution off the shelf - one crafted for your specific business needs and your specific data structure.
Financial Reporting Template for Sage 300 - Excel and Power BI
We’ve created two basic Financial Reporting Templates for Sage 300 for you - one using Excel and one using Power BI.
DAX Quick Tip: Specify Multi Condition Ranks
Every once and a while, an existing DAX function won't meet exact specifications; when this happens you've got to think out side the box. In this case we want to use RANKX avoiding ties…
Aggregations: Unlocking Large Scale Analytics
Aggregations in Power BI is possibly the biggest leap in scalability the world has seen so far: for me this was a big mystery at first. How does this work? Why is this such a powerful feature? My hope today is to demystify aggregations for you…
Performance Analyzer: Power BI’s Chief Diagnostic Tool
The brand new availability of the once DAX-Studio-only Performance Analyzer in Power BI gives users even more… power….
The Subscription Economy Is Here
Join Craig Juta & Ed Kless in this podcast on merits of the Subscription Economy.
Snowflake in Conjunction With Tabular Models:
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...
Zendesk and Xero Harmonized In PowerBI: The Model
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?
Unlocking DAX Measures in Calculated Columns
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?…
Zendesk and Xero Harmonized In PowerBI
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.
5 Tips and Tricks Using Power BI Bookmarks
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…
Construction Console
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…
Projects Should be Focused on Adoption
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?…