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

Tag: Data

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

February 18, 2017 0 comments Article News, PowerBI

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 Read More

You can now Download your PowerBI Reports as a PBIX file

November 30, 2016 0 comments Article Intermediate, PowerBI

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 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

15 Functions Every Aspiring Excel Pro Should Know

October 11, 2016 0 comments Article Excel, Intermediate

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 Read More

Improvements in how CSV File Saves are Handled in Excel

September 7, 2016 0 comments Article Easy, 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. Read More

Using Ranking Functions in Excel

October 2, 2015 0 comments Article Easy, Excel

Master the available options in Excel for ranking you data, including the updated Rank.Eq functions. Read More

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