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
Data Modeling For Power Pivot And Power BI

Data Modeling for Power Pivot and Power BI

What if I told you, there was one key skill, that has set me head and shoulders above the Excel crowd when working with Power Pivot and Power BI? Would you be interested in learning that skill? Great, because I was about to teach it to you anyway. Pay It Forward But first a story. I had discovered Power Pivot (code-named Gemini back then), while working in the Microsoft Commerce group. But really came in to my element at my…

Read the Rest
Sort Your Data On Load For Improved Compression

Sort Your Data on Load for Improved Compression

My last 2 blog posts have been about data compression – that theme continues today.  In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.  In January I went a bit deeper and talked about restructuring your data to get better compression.  In the comments section of this last post in January there was a seemingly innocuous comment from Mati Selg at the bottom of the…

Read the Rest
For Real This Time:  Show Barnes & Noble That Power Pivot And Power BI Are Important!

For Real This Time: Show Barnes & Noble that Power Pivot and Power BI are Important!

Sunday, Feb 7th in a Local B&N:  That Silver/Grey Spined Book is Ours! OK, for real, B&N has them now!  (I have seen them myself, as pictured above, and every B&N I’ve called has them). Remember, they accepted our challenge of an experiment:  they will stock our new book for a few weeks and see what kind of “action” it gets.  If it does decent sales, they will keep the book on the shelves (AND start stocking more such books,…

Read the Rest