Power BI

/Power BI

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 years using [...]

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 [...]

Power BI|

Power Query (Get & Transform) – Video Introduction Part 2

Power Query (Get & Transform) - Part 2 In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data into Excel. In this 6 minute video I follow on from that introduction and add an extra transformation step to get the dates I need. Once [...]

Power Query (Get & Transform) – Video Introduction Part 1

Power Query (Get & Transform) Part 1 Power Query is amazing at linking to data sources and cleansing / transforming that data as it's loaded into Excel (or Power BI Desktop). Watch this 4 minute video and see how you can consolidate all of the files from a folder instantly using Power Query. Build the transformation steps [...]

Power Query Parameters – How to use Named Cells as flexible inputs

Power Query Parameters and Named Cells By Wyn Hopkins Power Query is the best thing to happen to Excel since Tables were introduced in Excel 2007 When developing Power Query solutions for others to use, or when needing parameters that can be changed easily (e.g. source file or date) you can store these variables [...]

Power BI|

Combine multiple tables with Excel Power Query

How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]

How do you get 4 million rows of data into Excel?

So firstly lets face facts.  Not many people need to bring 4 million rows of data into Excel.  Point accepted. However, some do, and I recently needed to do this. If you've ever checked  (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula [...]

Business Intelligence, Power BI|