Power BI

In my last post I showed how to use Log Analytics data to analyse Power BI query activity. The problem with looking at a long list of queries, though, is that it can be overwhelming and it can be h…

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. When calculation group

Deneb JSON Template for Joy/Ridgeline plot with independent scales

I’ve listened to music on Spotify for over 5,000 hours since I subscribed to their service. I listen the most in the early morning when I’m at the gym and before my morning meetings beg…

Do you know who is the biggest "enemy" for the optimal data model size? Meet the Cardinality, and learn how to boost the report performance applying some simple techniques for improving cardinality levels

Starting with the next Power BI Desktop release, WebView2 will be required. If you have not switched over yet, please take action now to avoid interruptions.

Unless you’re building a solution for your exclusive personal use, you are not the customer. If you are not the customer, you need to invest in understanding the customer’s motivations,…

QuerySurge’s BI Tester provides connectors for Microsoft Power BI, Tableau, Microstrategy, IBM Cognos, SAP, and Oracle OBIEE.

How can you create your own data types in Excel? Oh yes, you can do it! In this article, we'll learn how you can create data types in Power Query.

Information The report shows the performance of the S&P 500 index which comprises 505 common stocks issued by 500 large-cap companies traded on American stock exchanges.  The report contains data for the last 1 year and is updated daily.   Data Sources The main source of data is Yahoo Finance. To pu...

If you aren’t using Tabular Editor to format all of your DAX code for you, you are missing out. I’ve written a super short script that will format all of your DAX code in measures, and make it look picture perfect in Power BI Desktop. First, you need to download Tabular Editor. The free version is

A handy feature of Tabular Editor is the ability to create C# scripts to simplify & automate basic development tasks. One such task that can be easily automated is the formatting of DAX code in the data model . Particularly upon inheriting a data model from someone else, formatting the DA

If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.

This post gives a good overview of the different functionalities and design options of slicers in Power BI. For professional looking reports.

In this blog post I show you how to easily use Power BI Embedded and use your own reports to see what it looks like.

We’re excited to bring you a new version of Power BI Report Server this Winter! With the January 2022 update, we have a variety of new enhancements, including page and bookmarks navigators, new sorting options for legend, new formatting options for text, pie and donut chart rotations and many more.

Process mining, provides direct data insights across an organization’s daily business processes, helping identify inefficiencies to improve how they work. Now with the preview of process mining in process advisor, leveraging Power BI Embedded , you can use your business data to produce analytics and detailed process maps, gleaning new insights into ways to optimize your business processes.

The creation of the electronic spreadsheet transformed industries. But its effects ran deeper than that.

This article explains provides an introduction to relationships and why relationships can be considered a sword that helps to chop vast amounts of data into tiny pieces.

Hybrid table is a Clever technical solution to a very fundamental problem in Data Analytics, How to keep Data fresh and at the same time fast, PowerBI , Tableau, Qlik solved this problem by importi…

Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific …

If you thought that MapBox was good, well you’re going to LOVE the Icon Map custom visual in Power BI – which allows you to display interactive polygons, points, lines and of course – icons, all in the one visual…plus so much more! In this blog I walk through two of DiscoverEI's project examples of

Video by: Reid Havens Learn how to apply some [DAX] wizardry to intelligently format string values when concatenating KPI values together. RELATED CONTENT 🔗 Kane Snyder's Calculation Group Presentation Jeff Weir's Twitter Post

Power BI is a great reporting tool to reflect inventory values at a specific point in time and then filter the values by different dimensions. At the same time, the user can assess the levels of inventory values across different time periods as well as see key inventory management ratios.

Our Power BI Principal Consultant Kane Snyder shares a technique for optimising calculation group performance.

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic

Data Quality is not something that 'just happens.' Data Quality takes a great deal of work from a wide variety of different roles.

The Quality Framework will address these dimensions of quality across these different levels and comprise In-Line, Off-Line tests, and automatic fallback processes.

Data platforms do not spring forth fully built and operational. They take time to develop and build out. The same is true for a Data Quality practice.