Chris Webb BI

JULY 17, 2022

Recently I collaborated with a number of people from Microsoft and Snowflake to write a blog post on best practices for using Power BI in DirectQuery mode on Snowflake. It builds on what is already in the Power BI guidance documentation for DirectQuery to add some advice specific to Snowflake.

IT 297

IT 297

Chris Webb BI

OCTOBER 31, 2022

Do you have a a large dataset in Power BI Premium or Premium Per User? That was all fairly complex though and what I’m going to show you here is, in contrast, very easy to implement. Do you have more than six tables that take a significant amount of time to refresh?

Profiling 292

Profiling IT 292

Chris Webb BI

OCTOBER 3, 2022

Something I do all the time when performance tuning Power BI is use SQL Server Profiler to monitor query and refresh activity. And guess what – did you know you can use Analysis Services xEvents to monitor activity in Power BI Desktop? All very interesting, but what’s the point of doing this?

Management 295

Management Profiling Analysis Advantage 295

Chris Webb BI

NOVEMBER 28, 2022

One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI (see here and here for example). Since dynamic data sources aren’t refreshed in the Power BI service, this dataset won’t be refreshed.

Analysis 299

Analysis Learning Information IT 299

Chris Webb BI

FEBRUARY 25, 2024

Up to now they had a problem though: even when you were querying data that was in the Import mode partition, Power BI still sent a SQL query to the DirectQuery partition and that could hurt performance. That problem is now solved with the new dataCoverageDefinition property on the DirectQuery partition.

IT 166

IT 166

Chris Webb BI

NOVEMBER 14, 2022

A lot of people are building large datasets in Power BI Premium nowadays, and if you’re building a large dataset you’re very likely to be using Power BI’s incremental refresh functionality with your fact tables or manually creating and refreshing partitions in them.

Analysis 315

Analysis Management IT 315

CIO

AUGUST 17, 2023

Another experienced IT leader, David Ivell, chief product and technology officer at behavior management training company Team Teach, is already harnessing generative AI’s power. What works (and what doesn’t) So if projects are already getting off the ground, what are feelings about where generative AI works best, and how?

Intellectual Property 585

Intellectual Property Copywrite Algorithm Brainstorming 585

CIO

NOVEMBER 9, 2022

One potential solution to this challenge is to deploy self-service analytics, a type of business intelligence (BI) that enables business users to perform queries and generate reports on their own with little or no help from IT or data specialists. Data-informed decision-making is a key attribute of the modern digital business.

Human Resources 848

Human Resources Analysis Business Intelligence Sales 848

Chris Webb BI

AUGUST 22, 2022

It’s not documented yet and not mentioned on any of the official blogs, but you can read about it in the last two posts on Jeffrey Wang’s blog here: Introduce the DAX EvaluateAndLog Function. Have you ever wanted a watch window to see what’s going on inside a measure?

IT 336

IT 336

Smart Data Collective

DECEMBER 17, 2021

Introduction: What is Business Intelligence? ” Many companies realize the power of BI to improve their business results. They are taking advantage of a number of BI tools. However, the use cases for BI can vary from company to company, depending on their goals.

Business Intelligence 236

Business Intelligence Intelligence Intelligence Business 236

Chris Webb BI

JUNE 26, 2022

Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. For a more detailed discussion of these values in Power Query in Power BI Desktop see this post.

Information 130

Information IT 130

Alpha Sense BI

JANUARY 26, 2024

Business intelligence (BI) and analytics are competitive necessities in today’s fast-moving, data-driven business world. In fact, more than half of organizations across industries are using BI in some capacity to drive important initiatives like new revenue streams and increased efficiency.

Business Intelligence 105

Business Intelligence Intelligence Intelligence Business 105

Chris Webb BI

DECEMBER 12, 2022

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka Power Pivot) as a source. One option is to use View mode.

Business 161

Business IT 161

Domo

JANUARY 30, 2024

As a solutions engineer, I’ve worked for two popular business intelligence (BI) providers: Tableau and Domo. I also have experience using other BI tools throughout my career. That’s why bringing tools together can make each one more powerful. For instance, I’ve found that Tableau shines in robust data exploration.

Business Intelligence 52

Business Intelligence Security Security Intelligence 52

Domo

JANUARY 3, 2024

It’s a powerful tool that helps Bespoke Metrics create white-labeled dashboards for their clients, without the technical headaches. What is Bespoke Metrics, and what is Domo Everywhere? What we didn’t expect was how much customization we could have, and then how much our clients were going to come to rely on us.”

Brainstorming 132

Brainstorming Gaming Competitive Innovation 132

Alpha Sense BI

JUNE 8, 2023

In the last 12 months, we’ve seen a 690% increase in documents mentioning “Gen AI” found within AlphaSense’s collection of aggregated healthcare content. Noticing an uptick in documentation around mentions of genAI within the healthcare segment, we dove deeper into the research to outline the r ecent developments of genAI.

Hospitals 105

Hospitals Algorithm Intelligence Intelligence 105

Domo

MARCH 29, 2022

BI (business intelligence) got us all a little closer to the promise of better data leading to better results,” Domo’s new CEO , John Mellor (pictured), said during the opening segment of Domopalooza 2022 ’s virtual keynote. “But Data continues to explode—and for many organizations, that’s a major problem.

Business 96

Business Entertainment Briefing Sales 96

Domo

OCTOBER 13, 2021

The total economic impact of Domo on organizations is well documented. The pillars were four analytics-and-BI-related questions she believes any entrepreneur needs to ask themselves when launching a startup. 1 – What are our key economic drivers? ” 3 – How do I balance what my gut tells me with what the data tells me?

Startups 98

Startups Gaming Analysis Globalization 98

Netbasequid

APRIL 29, 2022

And it’s an analysis that is rooted in sentiment that goes deeper than sentence, or even for entire documents analysis, which is the industry norm for many of our competitors – and in academia. Data science teams work with stakeholders company-wide to meet an ever increasing need for ad hoc analysis requests. Let’s examine both.

Competitive Intelligence 98

Competitive Intelligence Analysis Intelligence Intelligence 98

Datapine Blog

FEBRUARY 9, 2023

Table of Contents 1) What Are White Label Reports? What Are White Label Reports? In this regard, implementing white label reporting practices and tools can help boost this mentality while giving a professional look to all relevant company documents. The answer is white labeling. Let’s get started with the definition.

Data Analysis 74

Data Analysis Analysis Technology Technology 74

BI Data Intel

JULY 28, 2021

What is Sysynkt? At BDI, we believe that Sysynkt is a very promising and innovative FMS solution, and therefore we want to show as many people as possible what it can do through a more detailed webinar series. Invoice entry powered by Google AI, facilitating automated document management and parsing. Table of Contents.

Matrix 52

Matrix Banking Innovation Technology 52

Datapine Blog

JUNE 5, 2019

Data has changed our lives in many ways, helping to improve the processes, initiatives, and innovations of organizations across sectors through the power of insight. Data has changed our lives in many ways, helping to improve the processes, initiatives, and innovations of organizations across sectors through the power of insight.

KPI 126

KPI Hospitals Sales Capital 126

Chris Webb BI

NOVEMBER 21, 2022

Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? These are questions you may have when you’re starting out on a new Power BI project and the answers can be hard to find. Power BI storage modes.

Analysis 347

Analysis IT 347

Chris Webb BI

JANUARY 21, 2024

One of the most important properties you can set in a Power BI DirectQuery semantic model is the “Maximum connections per data source” property, which controls the number of connections that can be used to run queries against a data source.

IT 229

IT 229

Datapine Blog

JUNE 15, 2023

Table of Contents 1) What Is A Performance Report? What Is A Performance Report? There is no need to jump from one document to another or drown in infinite spreadsheets. What Is The Importance of Performance Reports? That is why performance reports are such powerful tools. Let’s dive deeper into the benefits below.

Knowledge 83

Knowledge Benchmarking Sales Analysis 83

Chris Webb BI

APRIL 23, 2023

If you’re about to put a big Power BI project into production, have you planned to do any load testing? In my job on the Power BI CAT team at Microsoft it’s common for us to be called in to deal with poorly performing reports. What is the cause of the problem?

Retail 328

Retail Profiling Analysis Information 328

Chris Webb BI

MAY 14, 2023

One of the most confusing things about troubleshooting Power BI refresh problems is the way Power BI will sometimes try running a refresh again after it has failed. What happened? Try again when fewer datasets are being processed”, an error documented here.

Profiling 299

Profiling Information Business IT 299

Chris Webb BI

JULY 31, 2022

One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and last week I finally had the chance to do it. First of all I created a simple dataset with incremental refresh enabled.

Sales 336

Sales Profiling Management IT 336

Netbasequid

APRIL 22, 2021

What are Quid Social Clusters? Using AI-powered, short text-optimized clustering, it creates a visual network that represents the top trends, themes, and conversations in the social media data surrounding your topic. Create ongoing monitoring, with access to interactive live reports, live dashboards (Pulses), API and BI Integration.

Analysis 69

Analysis Competitive Intelligence Gaming Competitive 69

Datapine Blog

JANUARY 6, 2022

1) What Is Data Interpretation? First of all, let’s find a definition to understand what lies behind data interpretation meaning. What Is Data Interpretation? Table of Contents. 2) How To Interpret Data? 3) Why Data Interpretation Is Important? 4) Data Analysis & Interpretation Problems. trillion gigabytes!

Data Analysis 98

Data Analysis Analysis Research Knowledge 98

Chris Webb BI

JANUARY 14, 2024

Following on from my previous post showing how you can visualise the job graph for a Power BI Import mode semantic model refresh, I this post I will look at how you can interpret what the job graph tells you – specifically, explaining the concepts of blocking and waiting. Waiting is described in the example below.

IT 243

IT 243

Chris Webb BI

FEBRUARY 18, 2024

What is the cause – hackers? In a lot of cases the culprit is actually Power BI’s query caching feature. It allows Power BI to pre-cache the data needed by some report visuals and dashboard tiles so the reports and dashboards open faster. Which queries get cached?

Profiling 263

Profiling Sales IT 263

Chris Webb BI

APRIL 28, 2024

You probably know that semantic models in Power BI can use a fixed amount of memory. More importantly, how can you breach this limit and what do all of the different memory-related error messages that you might see mean? The diagram below shows how model memory usage can be broken down.

Security 231

Security Security Learning Information 231

Datapine Blog

MARCH 20, 2019

While you may already know that financial reporting is important (mainly because it’s a legal requirement in most countries), you may not understand its untapped power and potential. What is the importance of financial reporting? What is the purpose of financial reporting? What Is Financial Reporting?

Analysis 99

Analysis Finance Capital Due Diligence 99

Datapine Blog

JANUARY 24, 2021

In our cutthroat digital age, the importance of setting the right data analysis questions can define the overall success of a business. Your Chance: Want to perform advanced data analysis with a few clicks? Try our professional data analysis software for 14 days, completely free! Data Is Only As Good As The Questions You Ask.

Data Analysis 126

Data Analysis Analysis IT KPI 126

Chris Webb BI

JULY 9, 2023

Before you do so, though, there are a few things to know about performance testing with Direct Lake datasets that are slightly different from what you might be used to with Import mode or DirectQuery datasets. At the time of writing this post you can ensure this simply by refreshing the dataset.

Benchmarking 229

Benchmarking Security Security Information 229

Chris Webb BI

OCTOBER 13, 2022

If you’re monitoring activity in Power BI, for example using Log Analytics , you’ll know that you can capture the DAX queries generated by your published Power BI reports. The query can be run from DAX Studio connected to either Power BI Desktop or a dataset published to Power BI Premium via the XMLA Endpoint.

Sales 305

Sales IT 305