by Matt Allington | Jan 9, 2020 | Excelerator BI
As most readers of my website would surely know, Microsoft Excel has had a dual axis line chart as a standard charting visual for many many (many) years. A dual axis line chart is needed … Dual Axis Line Chart in Power BI Read More This post first appeared...
by Matt Allington | Jan 8, 2020 | Excelerator BI
Back in 2018 I wrote an article showing how to extract data from websites using Power Query in Excel. For simple websites this process is very straightforward. For more complex websites the process is not … Extracting Data from Complex Web Pages with Power BI Read...
by Matt Allington | Nov 15, 2019 | Excelerator BI
It is 5.5 years since I left my 25 year corporate role at Coca-Cola and started my own business training and supporting the Microsoft self-service BI tools (Power BI, Power Query and Power Pivot for … I’m Hiring A Power BI Trainer/Consultant Read More This post first...
by Matt Allington | Nov 11, 2019 | Excelerator BI
Last week in Orlando Florida, Microsoft held its annual Ignite conference. I have never been to Ignite but it is on my list of things to do in the future. There are always lots of … Microsoft Renames Flow to Power Automate Read More This post first appeared...
by Matt Allington | Nov 5, 2019 | Excelerator BI
I stumbled across an interesting problem recently when helping someone on a forum. Here is the scenario. Assume there is a help desk that is logging tickets into a system. Each ticket is assigned to … Show the Tickets Assigned to Me (or Others) Read More This post...
by Matt Allington | Oct 31, 2019 | Excelerator BI
I have written a series of articles where I explained different methods of combining data from multiple files into a single workbook/table using Power Query. In the first article, I explained how to create a … Combining Multiple Sheets from Multiple Workbooks Read...
