Category

Power BI & SQL

Recommender Systems 101

By All Posts, Business Intelligence, Modern Workplace, Office 365, Power BI & SQL

Recommender Systems 101: What are they and how do they work? Recommendations appear everywhere. Netflix shows you movies you may like based on your watching patterns. And when you online shop, you may see suggestions like , “customers that bought this item, also bought this one,” or you see people you may know in social media platforms. These are examples of a type of machine learning called recommender systems. Machine learning applies mathematical algorithms and…

Read More

4 Steps to Get Started with Power BI Embedded Analytics

By All Posts, Application Development, Business Intelligence, Enterprise Mobile, Power BI & SQL

In our previous blog post entitled Free Ebook: Supercharge Your Apps with Embedded Analytics, we explored the vast benefits of leveraging embedded analytics in your custom apps. By embedding analytics directly in your applications (rather than having your users go to a separate system or dashboard to access them), you not only make your end users’ lives much easier, but you also increase your application adoption and overall end user satisfaction. And what better way…

Read More

Free EBook: Supercharge Your Apps with Embedded Analytics

By All Posts, Application Development, Business Intelligence, Enterprise Mobile, Power BI & SQL

The way in which we use and interact with data has dramatically changed over the years. Originally, we leveraged static pictures and charts that captured a one-time snapshot of our data. But this is no long sufficient, as static visualizations only provide a historical view at a single point in time. Instead, interactive visualizations and real-time reports are now the demanded norm needed to turn massive volumes of data into immediate, actionable insights. But there…

Read More

Getting Ready for Your First Power BI Project

By All Posts, Business Intelligence, Power BI & SQL

One of the best parts of my job as a Business Intelligence (BI) consultant is what happens when Imaginet engages with a new BI customer. In many cases, our first engagement with a customer who is challenged by their BI and/or reporting capabilities is our Imaginet PowerBI Quick Start. This is typically a one or two week intensive engagement where an Imaginet Business Intelligence consultant (like me) embeds themselves into a team within an organization…

Read More

Power Query Function for Dense Ranking

By All Posts, Power BI & SQL, Tutorials

Power Query Function for Dense Ranking Recently I was having issues writing a measure in DAX to rank items properly (not an issue with the DAX, but in my understanding of the DAX). I did some searching and came across Chris Webb’s article that had a nice implementation of ranking using Power Query. The technique he proposed uses Power Query to: sort a table by the column you want to rank by, add an index column…

Read More

Power Query for Azure tables and Updating Column Names

By All Posts, Azure, Power BI & SQL, Tutorials

Power Query for Azure Tables and Updating Column Names I recently did some PowerBI work using Azure Table Storage. In the query editor, it seemed that each table I pulled in from Azure Tables had a very similar process.: Get the list of tables available for the storage account. Select a table Select the Content of the table (excluding the RowKey, PartitionKey, and timestamp columns) Expand the columns in the Content Rename the columns Azure…

Read More
Let‘s Talk.

  • Let's Talk

  • This field is for validation purposes and should be left unchanged.