Skip to main content
Category

Power BI & SQL

Using Microsoft Power BI–Business data analytics for better reporting

By Agile, All Posts, Business Intelligence, DevOps, Power BI & SQL, Power Platform, Productivity
Using Microsoft Power BI–Business data analytics for better reporting We have a lot of discussions with clients about a desire to do “better reporting”. They have been using Power BI but feel they now need a data warehouse to create reports that will give them all the info they need. Fundamentally, organizations often have an analytics problem, one for which a data warehouse forms part of the solution, however, the complexities lie in the data....
Read More

Using Microsoft Power BI in data engineering

By Business Intelligence, DevOps, Power BI & SQL, Power Platform

Using Microsoft Power BI in data engineering We have a lot of discussions with clients about a desire to do “better reporting”. They have been using Power BI but feel they now need a data warehouse to create reports that will give them all the info they need. Fundamentally, organizations often have an analytics problem, one for which a data warehouse forms part of the solution, however, the complexities lie in the data. Often organizations…

Read More

Authoring Reports in Power BI Desktop: Do it Right

By All Posts, Business Intelligence, Office 365, Power BI & SQL
Microsoft Power BI is recognized by Gartner as a leader for the fourteenth consecutive year in the 2021 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. It is, without a doubt, one of the key business intelligence (BI) tools currently in the market. Organizations use Power BI to build robust reports and custom dashboards making it easy to get answers to complex questions. As a self-service analytics tool, it is highly accessible by business...
Read More

What is Data Engineering?

By All Posts, Azure, Business Intelligence, Power BI & SQL, SQL Server
When you look at a dashboard or report in Power BI, you are seeing the tip of the iceberg; the data you see has likely taken many steps from its source on its way to Power BI. Data engineering is the work that brings data from one or more sources and shapes it, validates it, cleans it, correlates it, and (often) stores it, and it’s a lot of what we do at Imaginet. Power BI...
Read More

Recommender Systems 101: What Are They and How Do They Work?

By All Posts, Business Intelligence, Office 365, Power BI & SQL
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 statistical techniques on large amounts of data to create models that...
Read More

6 Reasons to Use Angular Instead of ASP.NET MVC (Razor)

By All Posts, Application Development, Application Lifecycle Management, Azure, Consulting, DevOps, Enterprise Architecture, Enterprise Mobile, Modern Workplace, Power BI & SQL, Productivity, SQL Server
At Imaginet, we recommend the use of single-page applications using Angular for building enterprise applications. Customer solutions are still being built using ASP.NET MVC with Razor pages, generally because it is a well-known technology stack that is familiar to most companies’ development teams. However, this article will present six reasons why Angular is the superior option for building your application. Angular applications still follow an MVC style (or perhaps more correctly MVVM). In fact, they...
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
Let‘s Talk.

Let's talk!