Training Videos - Excelerator BI

Training Videos

Extending Power BI With R Visuals

Level: Intermediate Matt: This is the second one in a series of articles from Parker Stevens. In this article he talks about using R with Power BI. If you missed his first article “Introduction to …

Extending Power BI With R Visuals Read More

Use Power Query to Compare Database Records

Level: Intermediate I was helping a user on http://community.powerbi.com this week. The user had a list of service desk tickets for multiple customers and the requirement was to identify when a customer opened a second new …

Use Power Query to Compare Database Records Read More

Power Query to Combine Web Pages

Level: Intermediate There was an interesting question this week on http://powerpivotforum.com.au asking if there was a smarter way to user Power Query over multiple identical web pages to scrape the data in a single query. …

Power Query to Combine Web Pages Read More

Using SharePoint Enterprise with Power Pivot

As regular readers of my blog would know, I attended the PASS Business Analyst Conference in Santa Clara California this year (April 2015).  Here is the link for next year if you are interested.  While …

Using SharePoint Enterprise with Power Pivot Read More

Use Simple SQL to Manage your data in Power Pivot

When I started learning Power Pivot, I learnt there are 2 ways to import data. There is the “standard way” that uses the table import wizard – good for us Excel folk. There is a …

Use Simple SQL to Manage your data in Power Pivot Read More

Scroll to Top