Our customers often ask us in our projects or workshops why Power BI is so successful in the area of Business Intelligence. Besides all the advantages like Self-Service BI (especially for non-technical persons), connectivity to a lot of data sources, creation of stunning reports and dashboards, great possibilities for sharing and collaboration etc. there is one big reason for it: DAX!
As a PowerBI administrator, it's always difficult to monitor the on-premises gateways within our organization, especically when the number of gateways has been growing rapidly. Today I'm going to explain how you can effecitivley administrate and monitor those gateways in PowerBI itself. Along with that, I'm going to give lots of Tips & Tricks.
Are you working on big data and want to leverage the powerful capabilities of Power BI desktop? Then Incremental Refresh is a key feature to learn. It makes data refreshes faster and more reliable with less resource consumption.
This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop.
In this initial installment, I will illustrate how to include more than one aggregation and custom formatting in the Power BI Desktop Matrix. All tutorial steps below require acquaintance with how Power BI Desktop works as well as basic to advanced DAX skills.
So many people on the Power BI team at Microsoft have been working day and night for the last two years making the Power BI platform and its constantly-evolving feature set more competitive against Tableau, the industry leader. Those of us outside of Microsoft in the Power BI community can also help to make Power BI more competitive against Tableau by working together to increase the amount of Power BI expertise in our industry. Power BI adoption numbers are sure to increase as companies become more confident in the fact that they can find the right people with the talent and skills to design custom Power BI solutions and to manage the wide-scale distribution of content published to the Power BI service. This is why Power BI certification will become increasingly important as we move into 2018.
Recently I ran a free workshop for all of those connected to Enterprise DNA in some way. It was all about dashboarding and how to develop really compelling reports. Here's the reporting dashboard I showcased as I ran through my best practice visualization techniques - I'm making it available for download here along with the workshop recording
There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX 2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX 3. Discover The Best Selling Day For Your Products w/DAX in Power BI
Since Power BI Desktop’s March 2017 Update, it is possible to apply a color theme to your entire report. When you apply a so called “Report Theme”, all visuals in your report use the colors from your selected theme. Unfortunately, you can’t just import your Office Theme Colors into Power BI Desktop since they have different structures and filetypes. Therefore, I developed an Excel tool (the download link is at the end of the article) that converts your Office Theme into a Power BI Desktop Theme in 4 simple steps.
Excel tool to convert an Office Theme into an Power BI Desktop Theme