The Dashboard Effect cover art

All Episodes

The Dashboard Effect — 168 episodes

#
Title
1

The Hidden Complexity Behind Simple Dashboards

2

Should You Build a Data Team or Borrow One?

3

How a PE-Backed Rollup Escaped Excel Chaos

4

Your Finance Stack Is Broken: Stop Trusting the Magic Spreadsheet

5

Antidote for Failed Data Projects

6

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

7

The Data Governance Behind Trusted AI

8

Making Data Work for Small Firms Without a Big Budget

9

Beyond the Wrapper: Making AI Work for Data Teams

10

From Custom Builds to Fivetran: Evolving Our Data Pipeline Strategy

11

Preparing Your Data for AI: What Most Companies Get Wrong

12

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

13

Inside Microsoft Build: The Rise of AI Agents

14

Breaking Down the Latest Fabric Updates from Microsoft Build

15

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

16

5 Key Metrics for Middle Market Companies

17

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

18

Vanity Isn’t Strategy: Smarter Metrics for Smarter Teams

19

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

20

The Future of Microsoft Fabric: Will It Replace Synapse?

21

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

22

Breaking Down Portfolio Monitoring Solutions

23

Role Based Security: Keeping Data in the Right Hands

24

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

25

How to Build Smarter Reports with Power BI

26

Is Raw or Aggregated Data Better for Analytics Decisions?

27

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

28

Understanding Semantic Models and Data Lake House Layers

29

NetSuite Data Pipeline: Surprising API Challenges & ODBC Solution

30

How Bad Data Models Can Sabotage Your Reports

31

The Blueprint for Rolling Out BI to Hundreds of Users

32

Simplifying Your Data Pipeline for Maximum Performance

33

The Data Team Dilemma: Strategies for Surviving High Turnover

34

The Strategic Edge of Outsourcing Your Data Platform

35

Generative AI Analytics: Hype vs. Reality

36

Handling Multiple Currencies in Power BI

37

Modern Reporting with Power BI: Moving Beyond Email Reports

38

The Pitfalls of Augmenting Transactional Data with Excel for Reporting

39

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

40

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

41

Watch Out for These Data Model Red Flags

42

Blueprints for Building an Internal BI Team

43

How to Use Leading and Lagging Metrics for Better Business Agility

44

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

45

How to Democratize Data and Avoid the Chaos of Data Sprawl

46

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

47

Laying the Groundwork for Gen AI in Business Analytics

48

The Layman's Guide to Data Terminology: Part Three

49

The Layman's Guide to Data Terminology: Part Two

50

The Layman's Guide to Data Terminology: Part One

51

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

52

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

53

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

54

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

55

How to Structure Your Data for Power BI Copilot

56

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

57

How to Prepare Your Data for AI Advances

58

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

59

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

60

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

61

Agile Data: How New Tech is Transforming Business Operations

62

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

63

When it Comes to Power BI Dashboards, Simple is Better

64

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

65

How to Measure Success and Demonstrate ROI of Data Projects

66

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

67

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

68

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

69

7 Strategies for Effectively Managing Data Teams

70

Data Lakes - The Solution to Siloed Data

71

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

72

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

73

Implement Results, Not Just Software Solutions

74

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

75

Fast-Tracking Data Integration with Data Lakes

76

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

77

Azure's New Threads: An Overview of Microsoft Fabric

78

Moving from Data Constraint to Data Maturity

79

Power BI: So Much More Than a Visual Analytics Tool

80

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

81

Using Power BI to Deal with Bad Data

82

How to Unlock Value from Your Source System Data

83

Database 101: Breaking Down the Basics

84

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

85

Get Ready for Power BI Copilot

86

Demystifying Microsoft Fabric and OneLake

87

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

88

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

89

The Complexities of Data Lake Management

90

Three Pillars for Your BI System Framework

91

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

92

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

93

AI: The Case for a Data Lake?

94

Prepare Your Data for ChatGPT

95

Why Build a Data Lake in the First 100 Days

96

Building Strategic BI Reports: Key Questions for Stakeholders

97

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

98

KPIs for Midmarket Manufacturers

99

Understanding the Data Source

100

How Data Transparency Supports Our Team Culture and Performance

101

Making the Case for BI

102

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

103

Dealing with Untrustworthy Data

104

Becoming Data-Driven - Data Culture Misconceptions

105

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

106

Expect Iterations on Your BI Projects

107

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

108

Four Simple Ways to Improve BI Adoption

109

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

110

What Do You Need for Successful Self-Service BI?

111

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

112

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

113

ETL & Data Warehouse Architecture with David Dimmen

114

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

115

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

116

Using BI to Optimize Your Hiring

117

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

118

BI Project Execution with Jennie Swenson

119

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

120

Is Snowflake Your Data Warehouse Nirvana?

121

BI Project Initiation, with Anne Eisenach

122

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

123

Don't Drown in a Waterfall!

124

PM Series - Resource Planning, with Jennie Swenson

125

How to Fire Your BI Vendor

126

BI Project Scoping, with Anne Eisenach

127

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

128

How to Hire a Good BI Visualization Engineer

129

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

130

Azure Synapse Analytics - What the Heck is It?

131

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

132

Time Intelligence, with Sarah Martinez

133

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

134

The Brontosaurus and the Root of all (Business) Problems

135

The Age Old BI Challenge, with Greg Brown

136

BI Metrics for the Legal Industry, with Kate Eberle

137

Horse Before the Cart - Start With the Reporting Need

138

Why Not Use Automatic Connectors Every Time?

139

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

140

Top Shelf Business Intelligence, with Courtney Tewalt

141

Mid-Market BI, Just the Right Size

142

Snickers Bars and Master Data Management

143

Found One Million Dollars of Missing Invoicing Thanks to BI

144

The Downsides of Manual Reporting, with Bryan Maltais

145

Azure and Power BI - A Match Made in BI Heaven

146

How Not to Build a Dashboard

147

The Pros and Cons of Low or No code ETL Tools

148

When Not to Use a Data Warehouse

149

How to Budget for a BI Project, with Kate Eberle

150

Using BI to Drive Accountability, with Greg Brown

151

How to Effectively Manage a BI Project, with Jennie Swenson

152

Why We Moved to Fixed-Price Billing

153

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

154

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

155

How to Quickly Get BI Wins

156

BI Is Not the Same as an ERP Implementation

157

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

158

How to Succeed with BI: Aligning on Metrics

159

How to Succeed with BI: Defining the Impact

160

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

161

Who Should Own BI in Your Company, with Kate Eberle

162

Data Warehouses - Why the Bad Rap?

163

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

164

Performing Data Diligence

165

Data Visibility and the PE-Backed Executive

166

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

167

When Changes to Your Business Break Your Reporting

168

Do You Really Need a Data Warehouse?