I am sure it is only a matter of days (hours ?) before Power Query is updated with the Google Analytics connector as well, but I find it very interesting that new Power Query features are now first released in Power BI Designer. I had speculated earlier that Microsoft would/should focus on Designer as the … Continue reading Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t
Month: March 2015
Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot
Data for the tutorial can be obtained by downloading the following files: Exchange Rate File Working with Currency File Step 1: Load Sales Data to Data Model Open workingwithcurrency.xlsx, highlight Sales Data table, pick PowerPivot from the ribbon and select Add to Data Model Step 2: Using Power Query to transform Exchange Rate data … Continue reading Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot
Microsoft Announces IT Pro and Developer Preview for Office 2016
New BI features include the following: Power Query is integrated into the Ribbon Three new Excel functions have been added to support forecasting Support for Slicer multi select using touch Time grouping for model based pivot tables Power View against multidimensional cubes Improved automatic relationship detection Ability to rename Power pivot measures and columns in … Continue reading Microsoft Announces IT Pro and Developer Preview for Office 2016
New (but yet to be released) Power Map Features – Check out this video
Power BI Tutorial: Many to Many Relationship using Power BI Designer
Quick disclaimer, the Power BI Designer is in preview right now and as such it is lacking a number of very important features that some consider minimally necessary for the product to be usable (a few thoughts on where the product is in its current state from my perspective could be found here). At the … Continue reading Power BI Tutorial: Many to Many Relationship using Power BI Designer
What Is Power BI Designer And Why You Should Start Playing With It Right Now
Although Microsoft has not yet given us an official roadmap for its Power BI offering, I believe it is not beyond the realm of reason to share some educated and uneducated guesses about where the Power BI Designer might fit in. Philosophically speaking, I have heard two opinions about Microsoft creating a standalone tool that … Continue reading What Is Power BI Designer And Why You Should Start Playing With It Right Now
business intelligist 