The Dashboard Effect

The Dashboard Effect

Conversations and interviews on data, analytics, and business intelligence (BI) with Brick Thompson, Jon Thompson, and Caleb Ochs.

Reviews:
June 20, 202400:09:196.43 MB

The Pitfalls of Augmenting Transactional Data with Excel for Reporting

In the latest episode of The Dashboard Effect Podcast, Brick and Caleb discuss a common challenge businesses face when trying to extend their data for reporting purposes using Excel files to categorize or group data in ways not supported by the original system.While this approach may seem simple and...

June 06, 2024
130
00:08:586.19 MB

Mastering Delta Loads: Caleb's Best Practices, Tips, and Workarounds

Brick and Caleb get technical this week with a special focus on delta loading. They break down the concept of delta loading and highlight its benefits over traditional full loading techniques in terms of speed and resource efficiency. Caleb covers the typical obstacles faced when implementing delta ...

May 23, 2024
129
00:09:176.41 MB

A Speed-Trust Equation: Fast Power BI Reports Increase End User Confidence

Brick and Caleb share the essentials of performant Power BI reports. They discuss the ideal loading performance benchmarks, the implications of load times on user trust, and helpful strategies for debugging and optimizing data models and DAX measures. Watch this episode on our YouTube channel.Blue M...

May 09, 2024
128
00:09:126.35 MB

Watch Out for These Data Model Red Flags

Brick and Caleb discuss the importance of data modeling and good DAX in Power BI, highlighting common mistakes that can lead to poor report performance. For fast and efficient reporting, you need a sound data model that contains the right level of detail, dimensions, and relationships, avoids snowfl...

April 25, 2024
127
00:15:5811 MB

Blueprints for Building an Internal BI Team

(This episode is a re-release, but the content is still just as relevant as it was the first time around!) Brick and Caleb discuss the complexities of building an in-house BI department. In addition to sharing their firsthand experience and insight from years of supporting mid-market companies, the ...

April 18, 2024
126
00:12:068.34 MB

How to Use Leading and Lagging Metrics for Better Business Agility

Brick and guest co-host Greg Brown explore the dynamic between leading and lagging indicators in BI reporting. They share challenges and strategies for integrating these metrics to enhance operational efficiency and financial performance. Greg shares anecdotes from his operations background to empha...

April 11, 2024
125
00:08:556.17 MB

Behind the Scenes in Power BI: Tips to Streamline Data Modeling

This week, Brick and Caleb get a bit technical and discuss how to improve Power BI report performance through effective semantic modeling and minimizing data transformation with Power BI. They unpack the challenges of managing data transformations directly within Power BI and highlight the advantage...

April 04, 2024
124
00:08:305.88 MB

How to Democratize Data and Avoid the Chaos of Data Sprawl

Brick and Caleb explore the balance between empowering analysts with data access and the governance required to prevent data sprawl and maintain integrity and consistency across reports. They provide strategies for enabling departments to independently use data for their own insights and how to use ...

March 28, 2024
123
00:09:076.3 MB

The Human Side of AI Readiness - How to Prepare Your Team and Business Logic

In a continuation of their AI-readiness discussion, Brick and Caleb outline the importance of the human element in preparing for generative AI analytics. They share strategies for ensuring that your company's culture is ready to harness the power of AI, from how to start improving data literacy to d...

March 21, 2024
122
00:08:566.18 MB

Laying the Groundwork for Gen AI in Business Analytics

Brick and Caleb explore the steps businesses must take to prepare their data for the inevitable integration of generative AI analytics. They use this episode to explain the "why" behind data consolidation and semantic layers. What you'll learn:Why consolidating your data is the first step for AI-rea...

March 14, 2024
121
00:11:408.04 MB

The Layman's Guide to Data Terminology: Part Three

This episode is the third installment of Brick and Caleb's series on breaking down data terminology. They cover foreign and primary keys, data lakes and data lakehouses, parquet and delta parquet files, ETL and ELT, and data pipelines, before concluding with Python, PySpark, and visualizations. Watc...

March 14, 2024
121
00:00:0593.89 KB

The Layman's Guide to Data Terminology: Part Three

This episode is the third installment of Brick and Caleb's series on breaking down data terminology. They cover foreign and primary keys, data lakes and data lakehouses, parquet and delta parquet files, ETL and ELT, and data pipelines, before concluding with Python, PySpark, and visualizations...

March 07, 2024
120
00:10:437.39 MB

The Layman's Guide to Data Terminology: Part Two

This episode is the second installment of Brick and Caleb's series on breaking down data terminology. They cover Kimball data warehouse methodology, fact/dimensional tables, star vs. snowflake schemas, and data models vs. semantic layers. Click here to watch this episode on our YouTube channel.Blue ...

February 29, 2024
119
00:09:366.62 MB

The Layman's Guide to Data Terminology: Part One

This episode is the first installment in a series of episodes that will serve as a primer on the key terms and technologies surrounding data management. Brick and Caleb begin with the fundamental differences between transactional and analytical databases, explaining concepts like OLAP, OLTP, normali...

February 22, 2024
118
00:14:3110 MB

The KPIs You're Overlooking: Better Data Insights for Manufacturers

In this episode, Caleb and Kate discuss important KPIs for the manufacturing industry. While there are no one-size-fits-all solutions, they outline and provide insight on the leading and lagging KPIs that have helped our midmarket manufacturing clients improve sales operations, inventory management,...