Tag

Power BI Archives ⋆ Imaginet

7 Rapid Ways to Maximize Business Process Automation with Microsoft 365

By All Posts, Business Intelligence, Office 365, Power Platform, Productivity, SharePoint

Business Process Automation (BPA) helps organizations streamline their processes to enhance efficiencies, improve service delivery, accurately capture data, and empower teams. But without the proper tools or development capabilities, most organizations are slow to innovate using outdated systems. Microsoft 365 has developed a robust suite of tools that allow for rapid, low code solutions. These tools are especially effective if you have adopted Microsoft 365 as a platform, not just for email and document sharing….

Read More

Free White Paper: Transforming Business Processes with Microsoft 365

By All Posts, Modern Workplace, Productivity

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, Power Automate, Power BI, and SharePoint Lists—these business apps can be created with no or low amounts of code by end…

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

Modern Reporting with a SharePoint Data Source

By All Posts, Modern Workplace, Power BI & SQL, SharePoint

Ready to create modern reports using SharePoint as a data source? If so, then once again, you’ve come to the right place. For those familiar with SharePoint, you know that SharePoint offers many different data store types, including SharePoint lists, SharePoint libraries, and documents (such as Excel files stored in SharePoint that contain data within them). And where there is data, there is a need to report on it in order for you to uncover…

Read More

FREE WHITEPAPER: Using Power BI with Complex SharePoint Field Types

By All Posts, Modern Workplace, Power BI & SQL, SharePoint

If you have ever used SharePoint lists before, you know they provide a very simple way for users to store and share list-based items.  Simple text and number fields are straightforward, but complex field types in SharePoint (such as lookups, managed metadata, rich text, locations, etc) can present several reporting challenges that SharePoint by itself can’t solve. This is where Microsoft Power BI comes into the picture. Power BI provides specific tools to aid with…

Read More

Modern Dashboarding with SharePoint and Teams

By All Posts, Modern Workplace, Power BI & SQL, SharePoint, Teams

If you’re ready to build modern dashboards in SharePoint Online, Microsoft Teams, and SharePoint Server, then you’ve come to the right place. For more than a decade, SharePoint has been the platform of choice for business intelligence dashboards, originally leveraging features like Power Pivot for SharePoint, SQL Server Reporting Services (SSRS), and PerformancePoint. Fast forward to 2019, and SharePoint can seamlessly bring content together from Power BI, Excel, and many other data sources into rich…

Read More

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

By All Posts, Modern Workplace, Office 365, Power BI & SQL, Power Platform, Productivity

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,…

Read More

6 Must Know Benefits of Microsoft Power BI

By All Posts, Business Intelligence, Power BI & SQL

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…

Read More

Power Query Function for Dense Ranking

By All Posts, Power BI & SQL, Tutorials No Comments

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 No Comments

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.