Category Archives for "Power BI"

How to Use CALCULATE in Power BI

Great Uses for CALCULATE in Power BI Calculate is one of the most versatile functions in Power BI. When you begin using anything from simple filters, time intelligence functions or even advanced formulas, often the CALCULATE formulas are leveraged to produce the desired outcome. Let ’s use CALCULATE to filer a column in a table. CALCULATE […]

Continue reading

Calculate the Time between Two Dates in Power BI

Calculating the time between two dates is a rather simple task. You will just need a starting point and an ending point that has been formatted as a date or time. We can leverage Power BI native functions to get us the data we are looking for.  We will create columns that result in the […]

Continue reading

Using Python Visuals in Power BI

The addition of Python integration in Power BI is one of the greatest things that Microsoft could have done. This gives the user the ability to utilize amazing visual libraries such as Seaborn. Beyond visualization, you can also utilize some of the machine learning packages. If you want to improve your data visualization skill, check out Use Power […]

Continue reading

Add Custom KPI Icons in Power BI

If you are a user of Power BI, you have probably come across the KPI visual. I am often frustrated due to the visual’s lack of flexibility. Also, I would like the old school KPI from Excel to be incorporated into tables and other structures. However, at the moment, these are not native to Power […]

Continue reading

Power BI Dashboard in 10 minutes

Create a Power BI Interactive Dashboard in Minutes Microsoft Power BI is not a difficult business intelligence tool to adopt. So, I have decided to challenge users to create a Power BI dashboard in ten minutes. In this lighting fast tutorial, you will load, clean and visualize data in ten minutes which will culminate into […]

Continue reading

Microsoft Power BI Pros and Cons

Data visualization and data science are hot topics in businesses across America. Every company wants to turn data into a meaningful tableau of information. Power BI from Microsoft is a free or low-cost tool that many companies and individuals are turning to. You can also check out  Pros and Cons of Tableau What are the […]

Continue reading

Transform Power BI into Power Point

How to Make Power Point Presentation from Power BI Reports Power BI has a great function that allows you to export your visuals directly to a Power Point presentation. However, to be able to achieve this, you need to have a Power BI online account so that you can publish your Power BI workbook to […]

Continue reading

DEA Slang Word Visualization

Choose the substances and see the slang words   How does it work Use the interactive DEA Drug Slang Word Cloud to discover what the most common drug slang words for commonly illegal drugs. This data was source from the DEA data set on Kaggle.com. The data was in JSON file and was then exported […]

Continue reading

How to Connect Power BI and Google Analytics.

There are a ton of over-complicated tutorials on making this data connection. However, it is easy to quickly visualize your analytics data in your Power Bi.  Also there are templates that you can use that visualize your data in a dashboard format. For this you need to get an online account Power BI. Making the […]

Continue reading