The Dashboard Effect

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-readiness The challenges and solutions for dealing with data from disparate sources Th...

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.  Watch this episode on our YouTube channel . Blue Margin increases enterprise value for PE-backed,...

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 Margin increases enterprise value for PE-backed, mid-market companies by serving as their fr...

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, normalization, and denormalization in an accessible way. They also clarify the essence of SQL, how it inter...

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, labor and machine utilization, and cash flow. Click here to watch this episode on our YouTube chann...

Brick and Caleb discuss Blue Margin's use of Azure Data Lake for unified data management. Using a recent client project as an example, Caleb explains how he integrated multiple data sources using serverless SQL to create a single data repository with a semantic model to enhance consistency across projects and reports. They also discuss the current performance benefits of using a serverless SQ...

In this episode, Brick and Caleb explain the distinctions of and interdependencies between data setup/data pipelines, data modeling, and reporting, emphasizing their individual roles within an effective approach to data analytics and BI.  Starting by explaining the necessity of a solid data pipeline structure, this episode highlights how the specific requirements of a report influence the developm...

Brick and Caleb explain how Blue Margin is using ChatGPT for generating synthetic data to populate data models in Power BI reports. Caleb shares his insights on how this approach has streamlined the process of creating sample reports with fake, yet realistic data, to demonstrate work without compromising customer data privacy. They discuss the limitations of traditional data-generating tools and h...

Brick and Caleb call out key aspects of Microsoft's Power BI Copilot documentation related to structuring datasets for Large Language Models (LLMs) and explain how to get these best practices in place. Data structure and organization are critical for getting useful outputs from advanced analytics tools like Power BI Copilot, and useful outputs will determine, in large part, whether or not the...

While some features are not quite up to par (yet) with Azure Synapse Pipelines, Brick and Caleb discuss Microsoft Fabric's Direct Lake mode and Data Pipelines and the speed and advances they're bring to data management. Fabric's unified platform and source control integration streamline development, and Direct Lake allows organizations to operate off of a single copy of data -- prov...

For months, Brick and Caleb have been recommending that companies start preparing their data infrastructure to leverage the current and upcoming AI technologies. In this episode, however, they break down how to prepare. They emphasize the need for data consolidation (and recommend OneLake on Microsoft Fabric), a robust semantic layer for report development, data literacy development within the org...

In this episode, we discuss the key takeaways from the AWS report "CDO Agenda 2024: Navigating Data and Generative AI Frontiers." According to the report, the top focus for CDOs is creating visible value and achieving business objectives while preparing company data to leverage generative AI advances. Brick and Caleb share strategies for improving data infrastructure and considerations f...

In this episode, hosts Brick Thompson and Caleb Ochs discuss the current state of data and AI, inspired by a recent report from Salesforce. They discuss the importance of a strong data foundation (and what constitutes one) for effective use of generative AI, emphasizing the need for high-quality, consolidated, and secure data. They also cover some of the challenges of advancing data initiatives (e...

In this episode, hosts Brick and Caleb discuss the hesitation many companies have to pursue data projects during ERP (Enterprise Resource Planning) implementations. They dissect the risks of delaying these initiatives and highlight how running data projects in parallel can streamline processes, enhance data validation, and drive a faster return on investment. This discussion is helpful for leaders...

Brick and Jon, founders of Blue Margin, talk about the advancements in data technology and its impact on mid-market businesses. They discuss how rapid developments in data technology, particularly in data lakes and data pipelines, are revolutionizing how businesses operate and strategize. Emphasized is the shift from traditional data handling methods to more agile, cost-effective approaches that e...

This episode of the Blue Margin's Expert Insights Series with Kison Patel, CEO of M&A Science (www.mascience.com), provides valuable insights into a scientific approach to M&A, data management, and the potential impact of generative analytics in the industry. Kison Patel's extensive experience and forward-thinking perspective make for a compelling discussion on the future of M&am...

In this episode, Brick and Caleb discuss the fine line between adding value and overwhelming users with too much information when it comes to developing Power BI dashboards. They give insight into the dangers of overloading reports with excessive visualizations and the importance of maintaining simplicity and clarity in data reporting. Key Points: The Risk of Overreporting: Too many reports can le...

(This week’s episode is a rerelease from earlier this year, and it’s just as relevant now as it was then.) Brick and Caleb highlight how constant evolution in the BI process is key to a data initiative’s success. They emphasize the need for flexibility and incorporating user feedback for continuous improvement. They discuss the inevitability of business evolution and how BI reports must be updated...

In this episode, Brick and Caleb discuss how to demonstrate the value and return on investment (ROI) of data initiatives. They explore practical ways to quantify ROI, from automating manual effort to improving decision-making processes. Brick and Caleb also share real-world examples including the impact of increasing employee utilization on a company's bottom line.   They discuss the importan...

In this Expert Insights Series episode, Jon Thompson hosts Karen Posey of KP Strategies to unpack the unique challenges and opportunities CEOs face in the realm of strategic planning and execution.  Karen shares insights from her extensive experience leading companies and advising CEOs on the best-practices for building strategic plans that are aligned to yearly operations and budgets, and the imp...

In this episode, Brick and Caleb discuss the intricacies of role-level and row-level security in the context of data lakes. They explain the differences between the two and how each works within the Microsoft Azure environment. The conversation also touches on the importance of understanding who has access to what data, the flexibility of row-level security in Power BI, and the challenges of manag...

Kate Eberle, Director of Consulting at Blue Margin, discusses mid-market growth challenges with Richard Byrd, Fractional CMO and President of BlueByrd Strategic Sales and Marketing. Their conversation highlights the shift in private equity towards organic growth and the importance of foundational marketing strategies, expanding outreach, and leveraging AI tools. Listen in for BlueByrd's strat...

In this milestone 100th episode of The Dashboard Effect, Brick and Caleb discuss the challenges and best practices around managing data talent. From hiring and retention to continuous learning and meaningful work, they share insights from years of experience. Tune in for strategies on keeping your data talent engaged and contributing to your company’s goals. Click here to watch this episode on our...

In this episode of The Dashboard Effect podcast, Brick Thompson and Caleb Ochs discuss the concept of data silos, exploring their implications and the challenges they present in today's data landscape. They touch on the evolution of data storage, from traditional data warehouses to the more modern and efficient data lakes and lakehouses. As businesses continue to generate vast amounts of data...

In this episode, Brick and Caleb revisit the world of generative AI in analytics. They revisit their experience with Microsoft's Power BI Copilot and discuss the current state of AI in generating SQL queries, dashboards, and even predictive analytics with machine learning. Tune in to get their take on the hype vs. reality of AI within data analytics (and other applications like video, voice,...