How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?
Once per year Gartner, a research and advisory firm specialising in the IT sector, release their ‘Magic Quadrant’ for Business Intelligence. For the second year running, Microsoft has been considered the vendor with the most complete vision, though also notable is that both Microsoft and Tableau have begun to open the gap between themselves and
You can now Download your PowerBI Reports as a PBIX file
You’ve created that fantastic Data Model in PowerBI desktop, uploaded it to PowerBI Web for your team to admire. You’ve built some snazzy visualisations which everyone is now happy with. Fantastic. Job Done. Home early tonight. If only, right? Chances are, you spotted a problem / limitation with your original model – or thought of
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I’ll show you how to setup a series of drop-down menus were the list of available values is based on the value selected in the first dropdown Start by creating a new screen, and creating a Connection
Connecting PowerApps to an Existing Enterprise Gateway
If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to connect to an existing Enterprise Gateway. If you already use Microsoft’s PowerBI, there’s a good chance you already use an Enterprise Gateway to connect PowerBI to your on-premises SQL Server
Creating Virtual Tables in Power BI Using DAX
In this session, I want to show you how to use DAX / M expressions to create virtual tables. You may want to do this to create an aggregated view of your data to then work with, or perhaps filter down a dataset. I’ll show you examples of both, including doing both together. Once you’ve
15 Functions Every Aspiring Excel Pro Should Know
When you first start using Excel, you’ll quickly become familiar with using basic functions such as SUM, COUNT, MIN, AVERAGE Before long, you’ll be using VLOOKUP’s, IF’s and creating Pivot Tables in order to start bringing you data to life. However, it’s around this phase that I often see people plateauing in their Excel learning
Improvements in how CSV File Saves are Handled in Excel
Microsoft have this month released an update which addresses a small, yet incredibly annoying ‘feature’ when working with csv files in Excel. Read on to learn more.
Using Ranking Functions in Excel
Master the available options in Excel for ranking you data, including the updated Rank.Eq functions.
Most Read Articles
