Power BI

The Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) seeks to end global pediatric HIV/AIDS through prevention and treatment programs, research, and advocacy in 19 countries worldwide. The number of new HIV infections among children has declined more than 90% in the U.S. and 70% worldwide. Over its 30-year existence, EGPAF has played a major role in these … Continue reading “How Power BI enables remote communities in Africa to track AIDS”

In the previous article, you learned the basics of relationships, you learned why we need a relationship, and what is the filtering impact of it across multiple tables. In this article, you will learn about one of the most important properties of a relationship called Cardinality. Understanding what the meaning is of 1-1, 1-Many, Many-1…

With the 2019 NFL Draft upon us, of course I wanted to visualize some NFL draft data in Power BI. So I put together this interesting set of visualizations based on some data I scraped from Pro Foot…

Get a similar report on your preferred Facebook page here. Related

Patrick shows you how you can easily create dynamic titles in Power BI Desktop. This became available in the April 2019 release of Power BI Desktop. Demo files: https://guyinacu.bi/demofiles

Patrick shows the magic of getting cross-report drillthrough working in Power BI. He teaches you the clicks to getting this going successfully. Demo files: https://guyinacu.be/demofiles

Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Re…

Steadily more users are getting interested in Power BI mobile reports, especially when you design reports for executives; they are more interested in mobile view, of course, they do want…

It is no surprise that I’m a huge Power BI fan! Blogging, public speaking, nearly all community stuff I’m doing is related to Power BI. Besides that, I enjoy a beer every now and then. …

Do you want to change titels of your Power BI objects dynamically? It’s possible now! Read all about it in my blog post, posted from the beautiful city of Stockholm!

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup136 2 Minute Tuesday: https://guyinacu.be/dynamictitles Patrick’s tech video: https://guyinacu.be/crossreportdrill Adam’s tech video: https://guyinacu.be/liveconnect Source Getting Started with Power BI Report Design level 101 – What Every New User Should Know (@Paul_Turley) POWER BI MOBILE REPORTING (@pkamasani) Grouping in Power BI Desktop Without Using […]

I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day in a reporting data model; Fact and Dimension table. In this article, I will explain what a Dimension table is, and examples of it, and how…

Welcome to a brand new series that I have started with with Erin Ostrowsky [Blog | Twitter] that will focus on interviewing for a Power BI position. This series will hopefully help not only for tho…

Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles

PRODUCTS / COMPONENTS INVOLVED Microsoft Power BI Microsoft Office 365 - Audit Logs PowerShell PROBLEM SCENARIO DESCRIPTION / GOAL The goal here, is to look for a remote way that one can export the Office 365 Audit Log with a focus on Power BI for a given data range. RESOLUTION ( SCRIPT ) The ...

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.

Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.

The Power Platform User Groups (Power BI, PowerApps, and Flow) are excited to announce that they have added another stop to the Power Platform World Tour – They are headed to beautiful Vienna…

Power BI uses ML.NET to help users identify key influencers and customer segments so that they can understand the factors that drive their business metrics.

Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in one big table. In this article, you will learn about the fact table, and how it positioned in a data model, you will also learn how…

We have an exciting release this month. On top of incremental improvements for several of our recent released features, such as the key influencers visual and our new filter pane, we also have a ne…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup138 Tech video: https://guyinacu.be/relativedates Channel Update: https://guyinacu.be/channelupdatemay2019 What’s in my backpack: https://guyinacu.be/50kthankyou Source Automatic time intelligence in Power BI (@FerrariAlberto) NEW GATEWAY MONITORING (@BrettPowell76) Creating a Slicer Pop-Out Window with Bookmarks in Power BI (@HavensBI) Trusted Third Party Connectors for Power BI Power […]

Now that you know about the dimension and fact tables, it is time to talk about one of the most important concepts of modeling. You might have heard about dimensional modeling or star schema, but you may have vague ideas about what it is, or alternatively, you might have used it, but not sure if…

Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart. Now I am not professing to be a …

Video by: Reid Havens Provides a walk through of the new Performance Analyzer in Power BI. The Performance Analyzer captures operations that occur while a user interacts with a report . Additionally, I built a Power BI report off the exported data . This report summarizes those operation

If You’re Not Building Data Models, You’re Not Doing Power BI (or Data!) the Right Way Alternate Titles Abound! I could have just as easily titled this post ANY of the following: Why Power BI is (much) better than Tableau and other tools Why Power BI is (much) better than SQL-based reporting The importance of Data

We’re happy to announce our May 2019 update of Power BI Report Server! This release has many reporting features including conditional formatting for titles and other visual objects, the perfo…

Need to work with hours and minutes in your Power BI report? How do you slice by that grain? Patrick shows you a way you can work with time in Power BI Desktop. Download sample report Want to download…

BI is all about measuring your business success. But what about BI on BI? Wouldn't it be crucial for your organization and business to measure the success of your BI? While the current out-of-the-box …