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
A Brief introduction to Microsoft’s PowerApps Platform
After several months of being in Preview, Microsoft has moved its PowerApps service into General Release – though if PowerBI is anything to go by, we’ll see regular updates and enhancements in the coming months . If you’re not familiar with PowerApps, it’s a tool to create Data-Driven mobile phone applications in a Graphical Interface, and
Transferring Data & Parameters Between Screens in PowerApps
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 transfer data between screens. This assumes you have created a data connection (See also: Creating a connection to an Enterprise Gateway), and have brought some data into your app (in
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
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
Using the Undocumented DATEDIF() Function in Excel
I’ve written before (albeit briefly, as more of a footnote) about finding the difference between two dates in Excel. This approach, of subtracting one date from another is fine if you want to know the number of days between two dates – and of course you can go one step further and use NETWORKDAYS to
Using the same Named Range in multiple worksheets, but with different values, in Excel
Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value
Creating Sunburst & TreeMap Charts in Excel 2016
Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts)
Most Read Articles
