You have millions of rows of data stored in your data warehouse, you have it accessible and available for business users and report users, but how do you effectively tell a story using all that data? How do you unlock the secrets and the potential your data has?
Check this blog post to get a summary of the webinar I did with Charles Sterling on the Power BI YouTube channel where you will learn tips & tricks on how to effectively visualize your data, the do’s and don’ts and how to present your data so questions can be asked and get answered in the same report.
I wanted to run through some fantasticvisualization techniquesthat you can incorporate into your Power BI models and reports. The first one is what I callMulti-Threadeddynamic visuals and the second one isMulti-Measuredynamic visuals.
Today, I wanted to cover in detail some fantasticscenario analysis techniquesyou can use inside of Power BI. Power BI is an amazing tool if you want to predict what may happen in the future or alternatively see what could have happened in the past based on certain variables changing in your data.
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.
With today'spostI wanted to run through some examples of how you cansolve errors in your totalswithin Power BI. Via theEnterprise DNA Support Forum, I get to see a lot of issues and requests that users who are working in Power BI Desktop have.
If you are creating some analysis inside of Power BI and you’re utilizing DAX measures, then having a superior understanding of howITERATING functionswork is very important. This is what this particular post will showcase to you - understanding how important these functions are.
In today's post, I wanted to cover a few examples of how you canincorporate financial years into your Power BI models and reports. Sometimes, your date tables won’t have the custom financial years that you require for your analysis. Not only could it be financial years but you might also need to bring into filters your financial quarters.
In Part 2 of this blog series, I will discuss the purpose of dedicated capcities and explain the differences between Power BI Premium and Power BI Embedded. I will also provide the neccessary details so you can choose the right type of dedicated capacity for a particular scenario.
In this post I wanted to go into a few financial reporting tips you can utilize inside Power BI. Many of you who have been using Power BI since it was re-released a few years ago know that financial reporting inside of the tables we were given has been relatively difficult.
Power BI provides developers with Platform-as-a-Service (PaaS) capabilities which make it possible to embed Power BI resources into custom applications. By learning to use a set of APIs created by the Power BI team at Microsoft, a developer can embed Power BI reports, dashboards and dashboard tiles into custom web applications that target the browsers, tablets and mobile devices.
Today, I want to talk aboutcumulative totals. I want to do a deep dive into a few ways that you can create these inside of Power BI. In this first tutorial, I want to show youthe most common patternwhich you can utilize to create cumulative totals in a dynamic way.
In this post, I want to dive into some of mybest practices for Power BI Desktop development. I think bringing all these ideas together will give you a very good understanding of how I like to approach all Power BI reporting and analysis that I complete myself.
A requirement that we face very often in our projects is to be able to easily re-use multiple measures particularly when dealing with similar data models on a standard data source like for example cloud-based accounting systems like Dynamics, Xero, QuickBooks etc.
Today, I want to touch on a really fascinating topic inside of Power BI. I call this one virtual tables. If you can start understanding how to incorporate virtual tables inside your DAX functions, you will quickly see the opportunities to extend your analysis even further.
As I see lots of ongoing questions and misinformed comments (“Power BI can’t be used for financial statements”). Here I will cover a simple approach how you can realize financial statements with dynamically calculated subtotals like profit and loss (P/L), balance sheet, cash flow etc.
For many of us who work in data analytics for long time, you may notice that producing great data reports and dashboards alone doesn’t always generate desired outcomes. Why? Because data reports and dashboards are usually exploratory by nature and self-service oriented. In addition, they usually don’t have rich text to explain why certain charts and data points are meaningful in what context, not mentioning the usual lack of graphical elements that make data fun and interesting to read.
As an application of data visualization best practice, here's a way to draw attention to a particular dimension value (e.g. a particular product category) whilst still showing others for context, by means of a simple DAX pattern!
I recently came across a customer who was looking for a way to switch the dimensions dynamically using a slicer. In this blog, I’ll be sharing how I could do it in Power BI. This can be understood using the following example:
Switching the dimensions of a bar chart between Daily and Monthly based on the slicer selection.