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 Read More
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 Read More
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 Read More
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 Read More
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 Read More
I was having a discussion with someone the other day on the merits of using PIVOT / Cross-Tab functionality in SQL.
Back when the primary platform I used was Teradata, you didn’t have a PIVOT function, so if you wanted to do something similar to a Pivot, you had to build a series of CASE statements to build your fields up. This was fine, but you had to know beforehand what columns you wanted to have on your output
SQL SERVER (2005+) does provide a PIVOT option, but to be honest, it’s only marginally better than the CASE statement approach – you still have to know what column headings you want in your query.
So, if you want to pivot by the day of the week, that’s fine because there are a fixed number of days in the week and you can account for this.
But what if you want to have a field for each Agent/Region/date etc? You won’t always be able know what fields you’re going to need. Read More
In this walk-through ,I will show you how to use Excel to make a specific image show depending on a cells value, or by having a drop-down list Read More
Update: Feb 2016 – If you’re using Excel 2016, be sure to check out the new Waterfall Chart Type, which makes waterfall charts a breeze. Learn more here
Waterfall Charts are another one of those charts that’s much harder to put together than it should be, particularly as they’re a great way to understand the sequential impact of positive & negative values to a total.
That being said, they’re really not as bad as to put together as they’re sometime perceived to be. As with most of the chart techniques I’ve demonstrated, it’s really about tricking excel to show the bits of data you want it to show.
We’re going to go through the process to create the below chart – a simple income & expenditure chart for a shop.
I’m using excel 2013, but the approach is almost identical for previous versions of Excel
Learn how to create a combined Stacked, Clustered Chart in Excel. One of the trickier charts to get to create in Excel – but is certainly possible. Read More
Quite often, when writing queries, we want to load a table with a condition we want to pass to it (rather than hard-coding the value in the WHERE clause). Eg, load sales for a given year.
This can be easily achieved by creating a Macro, and passing a value to it… Read More