Reminder: “Dueling Dashboards” Pre-Conference Class In San Jose May 2nd

Reminder: “Dueling Dashboards” Pre-Conference Class in San Jose May 2nd

Less than three weeks away! Just way too much going on this year, folks.  In a good way, but still, it means we struggle to keep up with making you aware of everything we’re doing. Coming up on May 2nd, at the PASS BA conference in San Jose CA, Avi and I are going to be giving a brand-new, never-seen-before full-day class called “Dueling Dashboards – Practical Patterns for Your Business.” Here’s the abstract: Microsoft’s evolving strategy in BI and…

Read the Rest
Power Query As A File Audit Tool

Power Query as a File Audit Tool

Today I am sharing how I use Power Query as a file audit tool to support a regular task I complete every week.  The objective of this post is to create broader awareness of how great Power Query is to solve different types of problems, and to possibly get you thinking about other problems you have that could be solved with this tool. Copying files between folders My use case is this.  I refresh multiple workbooks for a client each…

Read the Rest
Victory At MS Data Summit! Analyze In Excel For Power BI

Victory at MS Data Summit! Analyze in Excel for Power BI

UPDATE 3/29: Recorded a brief demo video of this feature, embedded below. Analyze in Excel is reported to be working for some free accounts but not all (does not work for me). Does work for Paid/Pro accounts. If you use multiple accounts you may need this workaround. Read Aviv Ezrachi’s comment. Let me start with a proclamation of victory. “Analyze in Excel” is the best news that I heard at the MS Data Summit. Why is it such a big…

Read the Rest
Power Pivot Versus Power Query: Power BI Dilemma

Power Pivot versus Power Query: Power BI Dilemma

"Do we use Power Pivot or Power Query?" – I get this question all the time when teaching Power BI classes. (Note: This applies in Excel as well as Power BI Desktop world. Even though in PBI Desktop the tools are not labeled as PP & PQ, they are still very much present. See Excel Power BI / PBI Desktop comparison). I would be presenting this topic at the PASS BA Conference (May 2-4). I would be fleshing this out…

Read the Rest
SQL For Excel Power Pivot Users

SQL for Excel Power Pivot Users

Today I am going to spend some time trying to convince (and demonstrate to) Excel Power Pivot users that it is easy and valuable to learn some simple SQL code.  SQL is one of the easiest languages I have ever taught myself and you can do it too.  The reasons SQL is easy to learn include: It has a very simple syntax that uses English language expressions. You can start with simple short queries and get more complex only when…

Read the Rest
Power Query And Fixed-width M(agic)!

Power Query and Fixed-width M(agic)!

Intro by Avi: We know that Power Pivot and Power Query are extremely useful tools in the Finance and Accounting world. Today we have a guest post by Darren Leitzke outlining a very useful scenario and sharing some good tips and tricks. Take it away Darren… Working in accounting reminds me of all of those movies that take place 40 years later, but when that year comes around, the movie grossly exaggerated the technological advances of the future. Likewise, I…

Read the Rest
Job Opportunities In Seattle Area!

Job Opportunities in Seattle Area!

Join the PowerPivotPro Team! As part of our growth process, we at PowerPivotPro are pleased to say that we’d like to add at least one new team member in the Seattle area. This would mean working closely with me, Avi, and the rest of the team (several of whom are in Seattle), as well as with clients in the Seattle area. And yes, you’d spend your days doing revolutionary work with Power Pivot, Power Query, and Power BI If you’re…

Read the Rest
List.Generate(): Create Tables From Thin Air In Power BI With M!

List.Generate(): Create Tables from Thin Air in Power BI with M!

Announcement Update: For those who missed out on the webinar Watch the Session Recording for my (Avi Singh) webinar. Click here to watch the session recording of all PASS BA webinars. Download the PowerPoint Slide-Deck, Power BI Desktop (.pbix) file, Excel 2013 file Announcement: Friends, short notice, but in about 2 hours, I (Avi) will be presenting in the free SQLPASS Business Analytics Webinar Marathon, Thu Feb 25 9AM PST. Click to Register. Now back to the regularly scheduled programming…take it away Andrew.…

Read the Rest