The Dashboard Effect cover art

All Episodes

The Dashboard Effect — 172 episodes

#
Title
1

Bronze, Silver, Gold: A Practical Guide to Medallion Architecture

2

Can You Run Your BI on AI?

3

Using Vibe Coding in Real Data Projects

4

AI Won't Kill Your Coding Career

5

The Hidden Complexity Behind Simple Dashboards

6

Should You Build a Data Team or Borrow One?

7

How a PE-Backed Rollup Escaped Excel Chaos

8

Your Finance Stack Is Broken: Stop Trusting the Magic Spreadsheet

9

Antidote for Failed Data Projects

10

ROI for AI: Why Most Projects Fail (and How to Get Yours Right)

11

The Data Governance Behind Trusted AI

12

Making Data Work for Small Firms Without a Big Budget

13

Beyond the Wrapper: Making AI Work for Data Teams

14

From Custom Builds to Fivetran: Evolving Our Data Pipeline Strategy

15

Preparing Your Data for AI: What Most Companies Get Wrong

16

Choosing the Right Data Platform for Your Business: Fabric or Snowflake?

17

Inside Microsoft Build: The Rise of AI Agents

18

Breaking Down the Latest Fabric Updates from Microsoft Build

19

Why Private Equity Needs Its Own Data Lakehouse | PE Analytics & AI Readiness

20

5 Key Metrics for Middle Market Companies

21

If You Build It, Will They Use It? Culture’s Role in BI Success

22

Vanity Isn’t Strategy: Smarter Metrics for Smarter Teams

23

Safe, Smart, and Internal: Our Experimental Leap with AI

24

The Future of Microsoft Fabric: Will It Replace Synapse?

25

Revenue Reporting: It's Not as Simple as It Seems

26

Breaking Down Portfolio Monitoring Solutions

27

Role Based Security: Keeping Data in the Right Hands

28

From Theory to Practice: Making AI Work in the Real World

29

How to Build Smarter Reports with Power BI

30

Is Raw or Aggregated Data Better for Analytics Decisions?

31

Schema on Write vs. Schema on Read: What’s Faster for Your Business?

32

Understanding Semantic Models and Data Lake House Layers

33

NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution

34

How Bad Data Models Can Sabotage Your Reports

35

The Blueprint for Rolling Out BI to Hundreds of Users

36

Simplifying Your Data Pipeline for Maximum Performance

37

The Data Team Dilemma: Strategies for Surviving High Turnover

38

The Strategic Edge of Outsourcing Your Data Platform

39

Generative AI Analytics: Hype vs. Reality

40

Handling Multiple Currencies in Power BI

41

Modern Reporting with Power BI: Moving Beyond Email Reports

42

The Pitfalls of Augmenting Transactional Data with Excel for Reporting

43

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

44

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

45

Watch Out for These Data Model Red Flags

46

Blueprints for Building an Internal BI Team

47

How to Use Leading and Lagging Metrics for Better Business Agility

48

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

49

How to Democratize Data and Avoid the Chaos of Data Sprawl

50

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

51

Laying the Groundwork for Gen AI in Business Analytics

52

The Layman's Guide to Data Terminology: Part Three

53

The Layman's Guide to Data Terminology: Part Two

54

The Layman's Guide to Data Terminology: Part One

55

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

56

A Case Study: Unifying Data Sources with Azure Data Lake and Serverless SQL

57

From Data Setup to Power BI Reports: Considerations for Your Data Model (Semantic Layer)

58

How to Generate Realistic, Synthetic Data for Power BI with ChatGPT

59

How to Structure Your Data for Power BI Copilot

60

A Closer Look at Microsoft Fabric's Direct Lake and Data Pipelines

61

How to Prepare Your Data for AI Advances

62

Data Quality Sets the Stage for Generative AI: AWS's CDO Agenda for 2024

63

Data is Gold in AI's Wild West: Insights from Salesforce's State of Data & Analytics Report

64

How (& Why) to Prioritize Data Projects During ERP Transitions

65

Agile Data: How New Tech is Transforming Business Operations

66

Expert Insights Series - Kison Patel of M&A Science: Data’s Role in M&A Success

67

When it Comes to Power BI Dashboards, Simple is Better

68

Embracing Change: Use an Iterative Approach to Keep Your BI Relevant

69

How to Measure Success and Demonstrate ROI of Data Projects

70

Expert Insights Series - Bridging Data and Leadership: Advice on Bold Execution for Midmarket CEOs

71

Data Security in Microsoft Azure: Understanding Role-Level and Row-Level Security

72

Expert Insights Series - Unlock Market Potential: B2B Mid-Market Growth Strategies with BlueByrd

73

7 Strategies for Effectively Managing Data Teams

74

Data Lakes - The Solution to Siloed Data

75

The Reality of Generative AI in Analytics: Hype vs. Progress

76

How to Avoid the "Treadmill" and Build Your Data Team Continuity

77

Implement Results, Not Just Software Solutions

78

Overcoming "BI Paralysis" - The Killer of Business Intelligence Initiatives

79

Fast-Tracking Data Integration with Data Lakes

80

Not Quite 'Big Data': A Middle Market-Sized Approach to Data Management

81

Azure's New Threads: An Overview of Microsoft Fabric

82

Moving from Data Constraint to Data Maturity

83

Power BI: So Much More Than a Visual Analytics Tool

84

Expert Insights Series - SimonMed: How Data Insight Improves Performance for PE-Backed Healthcare Companies

85

Using Power BI to Deal with Bad Data

86

How to Unlock Value from Your Source System Data

87

Database 101: Breaking Down the Basics

88

Is Microsoft Fabric Your New All-in-One Solution?

89

Get Ready for Power BI Copilot

90

Demystifying Microsoft Fabric and OneLake

91

Expert Insights Series - Nestell & Associates: ERP Digital Transformation for Private Equity

92

Expert Insights Series - How ParkerGale Capital Supports Portfolio Growth with a Sales Metrics Playbook

93

The Complexities of Data Lake Management

94

Three Pillars for Your BI System Framework

95

Expert Insights Series - CIO Insight into Data Monetization, Data Lakes, and AI

96

Expert Insights Series - Middle Market Methods' Value Creation Roadmap™ for Private Equity

97

AI: The Case for a Data Lake?

98

Prepare Your Data for ChatGPT

99

Why Build a Data Lake in the First 100 Days

100

Building Strategic BI Reports: Key Questions for Stakeholders

101

Expert Insights Series - Weave Growth Partners on Private Equity's Late Adoption of Data-Driven Practices

102

KPIs for Midmarket Manufacturers

103

Understanding the Data Source

104

How Data Transparency Supports Our Team Culture and Performance

105

Making the Case for BI

106

Value Creation with BI Through Human Centered Design, w/ Brian T. O'Neill

107

Dealing with Untrustworthy Data

108

Becoming Data-Driven - Data Culture Misconceptions

109

Expert Insights Series - BI Projects Drive Financial Transformation, a PMO Leader's Insights

110

Expect Iterations on Your BI Projects

111

Expert Insight Series - Data as a Powerful Change Agent with Anthony Algmin

112

Four Simple Ways to Improve BI Adoption

113

Expert Insights Series - One Rock Capital: Top Line Growth Strategies

114

What Do You Need for Successful Self-Service BI?

115

Expert Insights Series - Extract More Value from Your Power BI Data with Power ON

116

Expert Insight Series - How Trace3 Accelerated Their VCP with an OKR Dashboard

117

ETL & Data Warehouse Architecture with David Dimmen

118

Expert Insight Series - Industrial Growth Partners: Using Data to Maximize Value and Performance Throughout the Investment Lifecycle

119

Expert Insight Series - Forbes’ “Grandfather of Gamification”: Data Creates a Culture of Growth

120

Using BI to Optimize Your Hiring

121

Expert Insight Series - BI Strategies for PE Portco Acceleration with Marty Moore of Tenex Capital Management

122

BI Project Execution with Jennie Swenson

123

Data Warehouse vs. Data Lake - Which do you need?

124

Is Snowflake Your Data Warehouse Nirvana?

125

BI Project Initiation, with Anne Eisenach

126

Expert Insight Series - Change Management with Dain Johnson of Rev 0

127

Don't Drown in a Waterfall!

128

PM Series - Resource Planning, with Jennie Swenson

129

How to Fire Your BI Vendor

130

BI Project Scoping, with Anne Eisenach

131

Expert Insight Series - Tecum Capital: How Private Equity Can Leverage Data Across Industrials for Higher Returns

132

How to Hire a Good BI Visualization Engineer

133

Using BI to Find Alpha in Private Equity, with Greg Brown

134

Azure Synapse Analytics - What the Heck is It?

135

You CAN Herd Cats - Get to Your Data Faster with a Lake(house)

136

Time Intelligence, with Sarah Martinez

137

Expert Insight Series - Notch Partners CEO: Leveraging Data and Curating a Large Pool of Executives for the Right Deal, at the Right Time

138

The Brontosaurus and the Root of all (Business) Problems

139

The Age Old BI Challenge, with Greg Brown

140

BI Metrics for the Legal Industry, with Kate Eberle

141

Horse Before the Cart - Start With the Reporting Need

142

Why Not Use Automatic Connectors Every Time?

143

Expert Insight Series - Data Driven versus Non-Data Driven Companies, Interview with Andy Scott, PE CTO

144

Top Shelf Business Intelligence, with Courtney Tewalt

145

Mid-Market BI, Just the Right Size

146

Snickers Bars and Master Data Management

147

Found One Million Dollars of Missing Invoicing Thanks to BI

148

The Downsides of Manual Reporting, with Bryan Maltais

149

Azure and Power BI - A Match Made in BI Heaven

150

How Not to Build a Dashboard

151

The Pros and Cons of Low or No code ETL Tools

152

When Not to Use a Data Warehouse

153

How to Budget for a BI Project, with Kate Eberle

154

Using BI to Drive Accountability, with Greg Brown

155

How to Effectively Manage a BI Project, with Jennie Swenson

156

Why We Moved to Fixed-Price Billing

157

How to Succeed with BI: Types of Data Sources and Data Integration

158

Expert Insight Series - Taking Advantage of Economic Headwinds, Interview with Jill Belconis

159

How to Quickly Get BI Wins

160

BI Is Not the Same as an ERP Implementation

161

Why Spend Time on Report Design and Wireframing, with Will Trickett

162

How to Succeed with BI: Aligning on Metrics

163

How to Succeed with BI: Defining the Impact

164

How to Succeed with BI: External Partner or Internal Team?

165

Who Should Own BI in Your Company, with Kate Eberle

166

Data Warehouses - Why the Bad Rap?

167

Why Power BI (vs. Tableau, Qlik, etc.)?

168

Performing Data Diligence

169

Data Visibility and the PE-Backed Executive

170

Expert Insight Series - Interview with Adam Coffey, Author of The Private Equity Playbook

171

When Changes to Your Business Break Your Reporting

172

Do You Really Need a Data Warehouse?