jmt

Home/Jackie Meddows-Taylor

About Jackie Meddows-Taylor

This author has not yet filled in any details.
So far Jackie Meddows-Taylor has created 10 blog entries.

Dynamic Data Validation with Tables in Excel

Dynamic Data Validation with Tables in Excel Why is Excel returning an error message? Why doesn’t my formula work? What did I do wrong? The answer to these common questions may surprise you. Many spreadsheets I’ve come across have a common problem – inconsistent data entry. If someone enters “United States of America” in a [...]

How to…CSVs to Power BI Dashboard in 10 minutes!

How to...CSVs to Power BI Dashboard in 10 minutes! If you've ever clicked "Export to CSV" then we are kindred spirits. In a previous life as analyst and accountant, I have been an unwilling follower of the export, copy paste, filter, remove top 2 rows, transpose mantra. In recent years a lot of [...]

2017-06-09T10:48:18+00:00 Power BI|

Get & Transform to the rescue!

Get & Transform to the rescue! Is it a bird? Is it a plane? No it's way better than that, it's Excel! Get & Transform, also known as Power Query, gives Excel users super powers. Here's the latest scenario where it has helped out and also is an opportunity for me to demonstrate a method [...]

Training 100 Chevron staff in modern Excel and Power BI

Training 100 Chevron staff in modern Excel and Power BI I am halfway through delivering training in Power Query, Power Pivot and Power BI to 100 Chevron staff. I love sharing my knowledge on this topic and seeing how people suddenly see what's possible with Modern Excel. You can see attendees' eyes look up and [...]

Data is the oil of the 21st Century – Analytics is the engine

  Data is the oil of the 21st Century - Analytics is the engine “Data … the next natural resource” (Virginia Rometty, CEO, IBM, 2013) Oil - the commodity that got us here Current generations might be forgiven for being blasé about the mega role of oil in our daily lives. For most of us, [...]

Power Query Data Cleansing – solving all sorts of Excel issues

Power Query Data Cleansing - solving all sorts of Excel issues by Wyn Hopkins   Some may see Power Query simply as a brilliant way of connecting to multiple data sources and loading that data into a Microsoft Power BI development environment (Excel Power Pivot or Power BI desktop). Having spent 25 [...]

Introducing Power Pivot – Power Query (Get & Transform) – Video Introduction Part 3

Introducing Power Pivot  In this video I introduce Power Pivot and how you can use it to join multiple tables of data together and display your data in a Fiscal Year format. In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data [...]

Top 10 reasons why winning CFOs are flocking to Power BI for data analysis

Top 10 reasons why winning CFOs are flocking to Power BI for data analysis “A (data analysis) picture is worth a thousand words” (Frederick R. Barnard – 1921) “Time is Money” (Benjamin Franklin – 1706 to 1790) The above truths are even more relevant in today’s real-time business environment. Those who make the smart decisions [...]

2017-03-08T03:53:53+00:00 Power BI|