Category Archives for "Power BI"

Learn how to leverage Microsoft’s Power BI to make amazing visuals and data models.

Best Power BI Courses

​Power BI’s user-base is growing daily. In just a few years, the adoption of Power BI into data productivity suites has exponentially grown. The team at Microsoft provides monthly updates that increase Power BI’s functionality and customization. ​If you are familiar with the field of data visualization, you would have heard of Power BI as […]

Does Height Affect Becoming the President

Open the dashboard below and interact with the data. This dashboard shows all the presidential election by nominee and winner. The height of each candidate is listed. Unsurprisingly due to better nutrition and medicine, the presidents have grown in height. The largest disparity exist in the last presidential election when 6’3″ Donald Trump the current […]

Diabetes Across the United States Dashboard

Data is from the Center for Disease Control which has health and disease penetration by state, county and city.  This dashboard was created in Microsoft Power BI with two CSV export from the CDC that listed percentage of residents with diabetes by year and state.  No calculated measures were created due to the data having […]

Learn Power BI Fast

AbsentData Blog Google Tag Manager Tableau Analytics Tutorials Adwords Excel Power BI PANDAS Get Sh*t Done in Power BI1.5 hour Short Course  If you hate overviews and need to learn fast. This is the course for you . NON TRADITIONAL LEARNING. Step 1:  DO FIRST ASK QUESTIONS LATER! You can get a dashboard up and […]

10 DAX Most Useful Power BI Functions

The importance of data analytics and visualization has grown tremendously over the last 5 years. The terms Data transformations, Big Data, AI, and Blockchain are discussed in every sphere of business including operational staff and c-suite executives. It is of paramount importance that huge data sets are visualized efficiently to give managers better insights and […]

Starbucks Calorie Burn Calculator

  This data was sourced from Kaggle which had both McDonalds and Starbucks items datasets. The data was broken up by items and nutritional elements. I put this data into a Power BI dashboards. There were several functions to get this to work. The exercise data set was sourced from Nutri Strategy I based all […]

Sentiment Analysis in Power BI

How to use natural language sentiment analysis in your text data with Power BI. I am really starting to fall in love with Power BI now that I have the ability to use Python scripts to transform my data and bring my visuals to a whole new level. We will use the NLTK Sentiment Intensity […]

Python Machine Learning in Power BI

We are going to do some machine learning in Python to transform our dataset into algorithm-digestible data for churn analysis. using sci-kit learn It’s a ton easier than it sounds. We will be utilizing the Python scripting option within the query editor in Power BI. Learn more machine learning and Power BI use cases with […]

Import PDF Tables in Power BI & Python

One of the best things that have happened to Power BI is the addition of Python scripting options. There are a host of things that can be accomplished such as data imports, custom Python visuals, and advanced data cleansing. For this tutorial, I am going to show you how to import PDF tables into Power […]