Power BI

Are you ready to put your organization on a path of continuous improvement using the most valuable decision support techniques? Check out Microsoft Senior Program Manager Christian Berg's timely series of essays on how to become your organization's strategic advisor using Machine Learning and Power BI, available on the Community Blog. Each post takes on a different aspect of business intelligence, and includes a how-to section to get you started creating customized solutions for your team. Most analysis in the posts is done using the R language, but Christian tries to keep any scripts gener...

Technical articles, content and resources for IT Professionals working in Microsoft technologies

It appears that we are now getting back into the swing of things, and this means more updates and additions to the Business Intelligence World. Power BI – Email Subscriptions This was a feature tha…

Do you use DirectQuery to connect directly to your data with Power BI Desktop? If so, we’d like to hear from you!

The Microsoft Office team recently partnered with Levo, a network for millennials in the workplace to help navigate their career paths, to poll 1,500 community members to find out more about their productivity habits and challenges. The Office team was looking for an engaging way to share Levo’s findings with the media – one approach they took was to use Microsoft Power BI to produce an interactive and compelling report from the data. This report is an example using data visualization to enhance storytelling efforts by leveraging the Power BI publish to web capability on blogs, websites and...

Today, I am happy to announce public preview of email subscriptions for report pages. This new feature allows you to subscribe to emails of the report pages that matter most to you, with just a few clicks. Once you’re subscribed, Power BI will regularly send screenshots of that report page directly to your inbox. The image in your inbox will show up exactly as it does in Power BI, and include a link to the report where you can drill into any interesting findings. Thanks to email subscriptions, it’s never been so easy to stay up-to-date about the data that matter most.

Hi Friends, Thank for joining me on GroupBy.org session, Those who have miss fun they can still watch any time on link Brent started “The 2017 Data Professional Salary Survey”, Please see all detai…

Hi All,   Before the January 2016 desktop software update, I was able to Publish changes made in the Desktop version of PowerBI to the web for others to access as live tile reports, coupled with a few web only reports from data queries.   With the recent January update of the desktop software, whene...

Latest workaround for incremental load in PBI. It's not very dynamic, but at least it's a technique that works without a hack:

Every day the members of Microsoft’s Treasury group have to make smart decisions about how to manage the company’s $158 billion in assets. Their guide to these decisions can be found in data and information analysis, and one of their tools of choice to manage this process is Microsoft Power BI. One amazing example of this data in action is the US Consumer Personal Spending dashboard, created by Investment Analyst, Carlton Gossett. This dashboard displays publicly available information in a dynamic, interactive way, allowing Treasury to quickly get a feel for consumer spending in the US and ...

Happy New Year! Today is our first Desktop update of the year. With this new year, we have a new release cadence as well. We are going to be releasing earlier in the month going forward. This month has several exciting improvements for tables and matrix and several connector improvements as well.

Hmm, how can this happen, my last post is more than 12 months old … During this period some things have changed – it seems mostly to the better, and some things are still the same, I…

The MRAN website offers info about R and its packages as well as archives of past R package versions and downloads of Microsoft R Open.

Summary   "How is my company doing?"   It's a question we hear often. It seems simple enough, but answering it is a complex process. This report is designed to answer the question in a clear and straightforward manner, while providing enough detail to take some action.   If we wanted to further dev...

hi, i want to iterate on each cell in the column (don't know how many rows and column will be, but it's not complicated to get) i want to call a function from each cell, how can i do it? also possible to call this function on specific row (not column)   this is the function that i found here once le...

Like the name suggests, a pyramid chart has a triangular structure. Lines run across it, dividing it into sections with thicknesses proportional to their values. A pyramid chart represents data in the form of percentages, with the whole chart representing 100%. A pyramid 3D chart built with Collabion helps you visualize the total data, as well as the hierarchical structure of it, in the form of a pyramid-like structure. A filtered pyramid chart, on the other hand, is represented in the form of a graduated glass pyramid filled by liquid, where the graduations indicate the values of different...

Do you want to detect outliers in your data? Want a predictive way to complete missing values in your data, or do you want to perform other advanced analytics scenarios as part of data cleansing? Implementing advanced analytics data cleansing scenarios in Power BI is now easier than ever! Learn more about adding R steps in Power Query as part of the Power BI Desktop July Update.

Opinion is split over Power BI’s ability to automatically create Date hierarchies in your model. Personally it drives me mad and I always turn it off, but I know a lot of people love the convenienc…

Vizion Solutions new and improved look and feel to the Sales Manager Scorecard eyJrIjoiNmI3NTYxYTgtMWYzNi00NGJhLTk5ZTgtNzcwN2ZhMjdjNzgzIiwidCI6ImU0OTdiODdkLTA2MmQtNDAzZS1iNWMxLTNlZGNhN2IzNTUwNyIsImMiOjN9

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Hi,   I want to build a graphic with Power BI displaying the order growth percentage in last 30 days or 12 months.   I have a table 'orders':   id date 10001 2016-12-12 11:16:00 10002 2016-12-12 11:17:00 10003 2016-12-12 11:18:00   I would like to display the rolling growth percentage of the number ...

Dashboard for Messi´s worldrecord of 91 goals in one year (2012), with details like mode ('left/right foot'), opponent, competition etc. For more details, see my blog: http://worktimesheet2014.blogspot.com/2016/12/powerbi-dashboard-for-messis.html eyJrIjoiOWYxMTVkNTUtZjJjMy00NTcyLWJlMzctNmNlYzE5ZmQy...

Asking Q&A Questions relating to dates or times   The one thing that I think a lot of people do not realize that Q&A is aware of dates and times.   And by that I mean that Q&A knows when you mean today, it is today’s current date.   It’s always easiest to show with an example.      As you can see a...

Hi , I am working on out power bi dashboard and receive request from Managment that they want to see total number of items added daily. Currently when I do this it just filter it buy that year or month and shows items added on that particular month or year. But not total items added upto now. As sho...