<img alt="" src="https://secure.hims1nice.com/151009.png" style="display:none;">
" style="background-color: #2c3e50;">
 

Blogs

Score Sentiment of Amazon Reviews in Power BI Premium Dataflows

September 7 2020

Power BI

In this blog post, I will demonstrate how to consume cognitive services in Power BI Premium, using a publicly available dataset of Amazon music instrument reviews. I want to score the sentiment of the review text and compare that with the number of stars given to any given product. The main purpose of this post is to show at a high-level how to use Azure Cognitive Services in Power BI Premium inside dataflows. A basic working knowledge of Power BI Desktop and the Power BI service is assumed, and access to Power BI Premium with a functioning gateway is required.

5 Things you are Doing Wrong in Power BI

September 1 2020

 

Power BI

 

Consuming XML web service data in Power BI

August 25 2020

 

Power BI

 

Top 5 Reasons you Should Use Power BI - Revisited

August 24 2020

 

Power BI

 

Several years ago, there was a blog post written about the 5 reasons that you should use Power BI. In this revisiting of the topic, I’m going to take a look at all the new features added as well as the things that have shown themselves to be more useful as time has marched on.

5 Data Modeling Tips

August 17 2020

 

Power BI

 

Perhaps one of the most crucial steps in creating effective visualization tools in Power BI is modeling your data. As data analysts, our goals are to make data exploration faster, make reports more accurate, and make the data and reports easy to maintain over time. If you model your data correctly, then it makes it possible for these goals to be achievable. With there being so much that goes into data modeling, it can be difficult to know where to start.

In this post, I present 5 tips that can help you model data in a way that can help you be successful in visualizing data in Power BI.

Using Microsoft Teams to get started with Power Platform

August 12 2020

 

Power Platform

 

The applications comprising Microsoft’s Power Platform—Power Automate, Power BI, and PowerApps—are sometimes thought of as being for power users. That is, there’s a sort of gatekeeping that implies only people with degrees in IT, who know coding languages, or who are Microsoft certified in some manner can use this suite with any success.

Handling Mixed Type Columns in Power BI

August 10 2020

 

Power BI

 

Recently when working with a JSON file in Power BI I was faced with a problem. I had a field in the JSON file that could contain one or many records in it. The built-in parsing identified the rows as being a mixture of records and lists (there is no native way to expand only the lists and then records). Because of this, it wasn’t able to extract the values from the column.

How to scrape and analyze website data with Power BI

August 3 2020

 

Power BI

 

 

Power BI connects to 115+ data sources. A webpage connector is very useful and enables data stored on websites to be mashed up and analyzed. When several webpages in a given URL share the same structure and content (e.g., a page for each year or category), the creation of a parameter for the URL and a function to replicate the Power Query code can import all of the data into a single data-set. This blog post will demonstrate how to do just that.

 

Use Teams Live Events for Your Next Big Meeting

June 29 2020

States are beginning to reopen their businesses but large gatherings remain unadvised. No one wants their next meeting to become a cluster for the next coronavirus outbreak. That also being said, everyone wants to have large meetings around this time of year. Colleges and high schools want to hold graduation ceremonies or teach summer classes. Companies want to hold job fairs to hire those new graduates – and they may want to hold all-hands meetings sometime after June 30th to mark the end of Q2.

Building Business Resiliency Through COVID and Beyond

May 27 2020

 

In a previous piece, we focused on how to rapidly implement Microsoft Teams in order to get your employees safely working from home. This is an excellent start, but you're not out of the woods yet.

Website