Thanks to all those who attended our past Excel to Power Pivot webinar on January 20th. Some of the attendees also joined us later for our first ever online class. For those who missed out, keep reading to learn about our upcoming options.
First of all, it is a joy and a privilege to speak to all of you about my favorite topic – Power Pivot/Power BI. So thank you for giving me that opportunity. My favorite part was the Q&A session at the end where I got a chance to interact with all of you. At the bottom of this post you will see some of the key questions, that were asked and answers. I figured that might help all the readers of this blog.
We plan to be running these webinars every month; best way to stay informed of our upcoming events is to subscribe to our blog. We are locked onto the Citrix/GoToMeeting platform, which has performed flawlessly for our recent events. But we are looking to increase the maximum capacity, to accommodate more attendees.
There is a special opportunity, to attend our webinar on February 3, as part of the BA marathon, being conducted by the SQL PASS folks. Details as below:-
|Productivity Revolution in Excel By Avi Singh, Chandoo|
|Tue Feb 3rd 11AM PST (click to change Time Zone)|
|Register at PASS BA Marathon|
Yes, I am collaborating with the “awesome” Chandoo for this Webinar. Gosh!
…now as promised here are the popular questions from our past webinar.
Questions from past Webinar
Some questions were asked over audio and others via the chat window. Some of these topics are meaty enough that we will follow up with full blog post and/or YouTube Video.
That was the number one question, and the answer is no, we do not record these sessions. We recommend you subscribe to our YouTube channel, where we post recorded content about Power Pivot and Power BI. Or subscribe to our blog to stay notified about future webinar events.
These were asked in various ways, folks described the struggles (file sizes, file complexity, trouble sharing, autorefresh etc.). The way out is exploring one of the server options – SharePoint, SSAS Tabular, Power BI. Read posts on SSAS Tabular and Thin and Core model advantages from adopting a Server route. Look for new posts around this topic.
I shared articles around 5 common mistakes made by self taught DAX students and how to choose amongst the various learning options at PowerPivotPro. Either way you learn, do not give up.
Good discussion here, I had used dataset with ~ 300M rows. Jeff (attendee) reported watching Bill Jelen’s demo with a billion rows. Of course a lot goes into this. We have lots of articles on performance and a full module on performance in our online class.
Use the magical Power Query. Most likely you would want to Unpivot many of these columns.
You may not have the latest version of PowerPivot for Excel 2010. Grab it here.
We are as anguished about this as you are. We had launched a Change.org initiative to Free Power Pivot. That applies to all Power BI tools, all of which should be freely available. I am really hoping this confusion goes away with Office 2016 release, but the problem may remain for Office 2013 edition where there is the most confusion.
Out of the box Power Pivot only supports One to Many relationships. Many-to-Many relationships can be supported using DAX measures (article). Many to many support could be coming, we have seen this supported in the new Power BI Designer.
This is supported using Direct Query mode when using Power Pivot’s elder cousin SSAS Tabular. Most folks can get away with setting an automatic refresh if they do not need true real-time reporting.
Check out the first article about cube functions: Intro to Cube Formulas
…or explore all Cube Formula articles.