Tag

Power BI Archives - Imaginet

Microsoft Power Platform: What It Is and Why You Need It

Businesses are generating more data than ever before. That data is now connected and available to almost every part of each organization. And all of that data offers great opportunities. Taking advantage of those opportunities, however, requires the ability to access, analyze, and use that data. Traditionally, creating reports and applications to do just that fell into the hands of a few specialists and developers. Each specialist created their own piece of the technical solution,…

6 Must Know Benefits of Microsoft Power BI

Microsoft Power BI, or Business Intelligence, is a business analytics offering from Microsoft that provides a quick, easy, powerful way to analyze and display your data without breaking the bank and without spending hours coming up to speed on a complex new analytics tool. In this article, we are going to explore 6 key benefits of Microsoft Power BI that you absolutely must know, as using Power BI will provide business intelligence like you have…

Free White Paper: Transforming Business Processes with Microsoft 365

Business apps are becoming more and more essential in the transformation and modernization of today’s organizations.  The goal of the business app is to empower process owners to combine data and processes to rapidly deliver a more tailored solution. And when you use the Microsoft 365 core business app creation tools – like Microsoft Forms, PowerApps, Microsoft Flow, Power BI, and SharePoint Lists – these business apps can be created with no or low amounts…

Power Query Function for Dense Ranking

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…

Power Query for Azure tables and Updating Column Names

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…

Scaling Azure SQL Databases Up and Down

Scaling Azure SQL databases up and down   I've recently been working on a project where we push data from an on-premise database to a set of Azure SQL databases daily, and use that Azure SQL database as the source for a Power BI dataset. The dataset gets refreshed once a day. Our Azure SQL data marts are pretty small - all but one of them are under 2 GB, and the largest one is...

Cash In on the Data Dividend with Imaginet and Microsoft Power BI

In this demo-packed presentation on Business Intelligence, Imaginet will show you Microsoft Power BI and how it can quickly provide insights into your data so that you can realize the ‘Data Dividend’ in your organization. Find out how Imaginet can help you cash in on the untapped value of the data you already have using Microsoft Power BI. — Imaginet is your trusted technology partner who turns your business innovation ideas into reality. 18+ years…

Let‘s Talk.
  • Let's Talk

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