logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Category: Advanced

A Brief introduction to Microsoft’s PowerApps Platform

November 27, 2016 0 comments Article Advanced, PowerApps

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

Transferring Data & Parameters Between Screens in PowerApps

November 27, 2016 4 comments Article Advanced, 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 Read More

Populate a Dropdown Based on the Value of Another Dropdown in PowerApps

November 27, 2016 1 comment Article Advanced, 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 Read More

Connecting PowerApps to an Existing Enterprise Gateway

November 27, 2016 0 comments Article Advanced, 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 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

Creating Virtual Tables in Power BI Using DAX

November 26, 2016 0 comments Article Advanced, PowerBI

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

Pivoting / Cross-Tabbing Data in SQL Server

September 14, 2015 0 comments Article Advanced, SQL Server

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

Showing a Picture Based on the Value of another Cell in Excel

March 24, 2015 11 comments Article Advanced, Excel

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

Creating Waterfall Charts in Excel [2007,2010,2013]

March 20, 2015 3 comments Article Advanced, Excel, Microsoft Office

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

Read More

Creating a Clustered Stacked Chart in Excel – Excel 2013

February 16, 2015 7 comments Article Advanced, 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

Populate a table by looping through items in a list / another table

January 5, 2015 0 comments Article Advanced, Teradata
[Teradata]

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

1 2 »

Most Read Articles

How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2025 - Theme by ThemeinProgress