Methodology + Expertise = Insights Accelerated

Data & Analytics Insights

We want to share our knowledge, lead by example and inspire in others the value of data insight.

 

Case Studies

Array

Case Study: Revitalized Data Ecosystem provides a Single Source of Truth

An eCommerce retailer was plagued by a fractured data ecosystem making it impossible to have a 360-degree view of their customers.
Array

Case Study: Clean Data for a Clean Energy Company in just 12 weeks

An energy solutions organization was working with an antiquated data foundation. An upcoming project required the accelerated adoption of modern data solutions and time was of the essence.
Array

Case Study: Modern Data & Visualization solutions reduce Call Center times by 50%

A global retailer has disparate ERP systems and obsolete data models leading to siloed data. These pain points are draining resources and causing customer service setbacks.
Array

Case Study: 90-day Tableau adoption rescues Retailer just before the Holiday Rush

An e-commerce fulfillment organization was in serious need of a modern data visualization tool to gain valuable insights into their operation. Heavy reliance on static reports left both IT and business groups unhappy.
Array

Case Study: Eliminating Data Silos saves Healthcare Payer nearly $4 MM yearly

Care managers at a healthcare payer organization are suffering from siloed data effecting data quality and hampering capabilities to make real time decisions creating risk for both members and the organization.
Array

Case Study: Consolidating Data Sources to Improve HEDIS metrics

A healthcare payer organization needed to pivot from data sources delivering stale data to sources that provide more quality information needed for HEDIS reporting.
Array

Case Study: A Modern Data Foundation Spurs Advanced Analytics Expansion

A regional healthcare payer’s data was severely siloed forcing data science and advanced analytics teams to spend more time on data wrangling than data analysis.
Array

Case Study: PowerBI contributes to 4.5 star rating & $360MM in associated revenue

A growing health insurance entity was hampered with data silos and extensive data sets making it increasingly laborious for stakeholders to identify areas of opportunity for care gap closures.
Array

Case Study: Dimensional Model facilitates care gap in Analysis for Healthcare Payer

A growing healthcare payer organization is suffering from lagging data processing times that is adversely affecting the organizations HEDIS program.
Array

Case Study: Pivoting services to improve a client’s data ecosystem

The governance team of one of the nation’s largest bank-based financial services companies was badly siloed in its analytics capabilities. As it stood, the team members had no internal resources to design and deploy business intelligence tools.
Array

Case Study: Power BI returned 15 hours a month back to 150+ office managers

Our client is one of the leading dental services organizations in the country supporting over 240 dental practices and businesses. Prior to our relationship, the client was utilizing SQL Server Reporting Services (SSRS) software for its analytics and reporting needs.
Array

Case Study: Improving Data Quality with Master Data Management (MDM)

A leading eCommerce retail supplier needed help centralizing their enterprise data. Multiple disparate ERP systems were being used, duplicating the amount of work needed to input customer information fivefold.
Array

Case Study: Centralizing Data and Resources to Transform into a Data-Driven Organization

The Data Ideology team guided the client in defining the optimal alignment of their IT resources to principal functions in enterprise data management.
Array

Case Study: Modernizing an Organization to Drive $10M ROI

Data Ideology provided a comprehensive analysis of key metrics and business processes that could help the client identify high priority areas where centralized data solutions would be needed first.
Array

Case Study: Turning Stale Data Into Direct, Daily Insights with Power BI

The Data Ideology team led an in-depth discovery session with the various business stakeholders to understand their future-state systems and reporting requirements.
Array

Case Study: Creating Multiple Tableau Dashboards with Little Time and Limited Resources

The client had a hard deadline to build and deploy an external reporting application via tableau server to deliver timely, actionable insights and system-wide visibility of data to clients, both historical and real-time reporting.
Array

Case Study: Modern Solutions for a Modern Health Insurance Organization

Our client is amongst the fastest growing healthcare payer organizations in the nation. However, like many of the clients we help, they were suffering from slow data processes due to legacy systems and software.
Array

Case Study: Optimizing Member Communication with a proper Data Model

The marketing team at a prominent health insurance company had no means to consolidate member contact preferences due to siloed data. This negatively affected communication between this group and their 1+ million members.

Power BI

Power BI

Self-Service Power BI with Shared Datasets

Leveraging the shared datasets feature from Power BI allows your company’s analysts to work from a single source of truth.
Power BI

Sharing a Power BI report within Teams

Do your business users have trouble finding reports and navigating through the Power BI Service? If your organization uses Microsoft Teams, you can embed a report directly in a channel for greater visibility.
Power BI

Six Reasons to Consider Power BI Premium

Capabilities to bring together self-service analytics and enterprise analytics solutions.
Power BI

Power BI Download Options: App vs MSI

Many Power BI users don’t realize that there are actually two methods of getting Desktop on your PC.
Power BI

Implementing Power BI Report Usage Metrics

Ever wonder how often your Power BI report is being viewed? Set up a Usage Metrics report to monitor who’s utilizing your report.
Power BI

Exploring the Decomposition Tree Visual in Power BI

Struggling to get business users in sync about how to slice and dice a metric in a report?
Power BI

Exploring DEV / TEST / PROD Environments in Power BI

How to utilize Development, Test, and Production environments to release reports with Power BI.
Power BI

Power BI Reports vs. Dashboards

A common mistake for new Power BI users is not knowing the difference between reports and dashboards.
Power BI

Driving Power BI Adoption

Deciding upon and getting the appropriate tools is only the first step of the journey to a successful adoption.
Power BI

Five Questions You Need To Answer To Get The Most Out Of Power BI

You bought Power BI. Now what? Several organizations that we’ve spoken to focus their time and efforts on developing Power BI assets and content.  They seem to only think about their deployment and governance approach as an afterthought. This approach leads to a number of unintended consequences that ultimately impact the organizations adoption and value

Snowflake

Snowflake

Snowflake’s Best Practices for Data Warehouse Development

By implementing Snowflake’s best practices, it becomes possible to better understand and articulate your data warehouse’s overall structure and layout.
Snowflake

Top 5 performance best practices with Snowflake

The Snowflake Data Platform is designed for scale, efficiency, and ease of use. It supports an unlimited number of Virtual Data Warehouse clusters that offer shared access for optimal performance.
Snowflake

Top 5 Benefits to Centralized Data

With the enormous revenue potential tied to digitization, data management is becoming even more critical, reaching an all-time high in demand for enterprise data management initiatives.
Snowflake

Snowflake Advantages

Success with Snowflake will lead to building a data foundation that future initiatives can build on to further advance and grow the organization’s data and analytics capabilities.
Banking & Financial Services

Five ways Financial Services Can Benefit from Snowflake

Cloud-based technology like Snowflake provide financial services organizations with a much needed competitive advantage.
Snowflake

Snowflake ELT vs. ETL

There are two main data movement processes for the Snowflake data warehouse technology platform. Extract, Transform, and Load (ETL) vs. Extract, Load, and Transform (ELT).
Snowflake

How Snowflake Delivers A Single Data Experience Across Multiple Clouds And Regions

Snowflake’s core architecture is built on a multi-tier cloud data platform that scales independently. Snowflake’s multi-cluster shared data architecture consolidates data warehouses, data marts, and data lakes into a single source of truth that enables any data workload on any cloud with a simple, powerful, and flexible platform.
Snowflake

How can the Snowflake Cloud Data Platform transform your organization? Part 2

The Snowflake Cloud Data Platform is one platform to build all your organization’s data apps. The advantages of leveraging Snowflake as your modern cloud data platform differs between the specific use cases of your organization. Here are some more of the critical capabilities that can help transform your organization.
Snowflake

Data Science Powers the Data-Driven Organization of the Future

Data Scientists and a traditional scientist have a lot in common.
Snowflake

How can the Snowflake Cloud Data Platform transform your organization? – Part 1

One platform to build your data apps.
Snowflake

Snowflake's Modern Platform Solves Data Challenges

Building a Modern Data Platform with Snowflake can alleviate many organizational challenges.
Snowflake

Why choose Snowflake Cloud Data Platform?

There is no shortage of data warehouse technology platforms that can serve as the foundation for your organization’s modern data platform.

Tableau

Tableau

The Tableau Suite of Products

The Tableau Platform consists of several products that are designed to enable users to integrate various data sources and create data visualizations that can be shared throughout the organization and externally. Here is everything that is included in the Tableau suite of products. Tableau Prep Tableau Prep allows users to prepare data for analysis by combining,
Tableau

Exporting DATA from Tableau to Excel

No matter how beautiful and informative and actionable your Tableau visualizations may be, there will always be a person or use case for exporting data to a tabular format usually via excel.

Data Management

Data Management

The Value of Data Integration

Integration streamlines the data lifecycle to enable a data-driven organization by moving the data closer to the point of action.
Data Management

The Value of Data Management

The increasing speed and pace of business contributes to several data challenges.
Data Management

Why Methodology Matters in Analytics

Organizations realize the tremendous benefits associated with getting data into the hands of everyone who needs it, while moving the data closer to the point of action.
Data Management

Data Warehouse: Keys to Success

A centralized data warehouse can serve the needs of numerous business units simultaneously.
Data Management

Managing the Organizational Dynamics

The increasing speed and pace of business contributes to several data challenges.

Data Governance

Data Governance

Gaining executive buy-in through Data Governance

Data governance is a challenging topic and directly affects how an organization interacts with its data. Successfully applying a Data Governance strategy requires managing the dynamics of an organization that allows for organizational change.
Data Governance

How to get started with Data Governance

Many of our customers have grown primarily through mergers and acquisitions to achieve accelerated growth. As a result, the organization quickly faces the prospects of multiple applications and systems that deliver similar functions and store the same data.
Data Governance

Data Governance: Lessons learned for best practices

How do we gain buy-in with enterprise Data Governance and data quality programs and processes when your organization is exercising caution due to past failures? Data Governance has become a critical discipline and important area of focus for organizations to realize operational efficiency and to support business growth.
Data Governance

Overcoming common Data Governance challenges

Data is at the center of People, Process, and Technology, representing a crucial asset used by all three. Simply put, people should embed data in any project to ensure that organizations follow a defined road map around enterprise data governance; technology can also help enhance and automate several processes and transactions.
Data Governance

Winning strategies for Data Governance maturity

To progress to a future state of mature Data Governance and analytical capability, decision-makers should focus on starting with the integration of the data across an entire enterprise. A Data Governance program will be critical to support the continued growth of an organization.

Master Data Management

Master Data Management

Uncovering the Best Practices for Master Data Management

Master Data Management (MDM) allows you to manage data assets better.In 2020 data was estimated at 30 billion across the globe, MDM’s goal is to implement best practices that will help you optimize the management of your organization’s data assets.
Master Data Management

Launching A Master Data Management Program: The Keys to Success

Today, many organizations have numerous applications and systems in which data, spanning multiple departments, quickly becomes fragmented, duplicated, and even outdated.
Master Data Management

Implementation Fundamentals of Master Data Management

A well-known issue with legacy data platforms is what’s known as the garbage in, garbage out (GIGO) obstacle. As data began to flourish due to cheap storage options and increased digitization, data quality issues and fragmentation proliferated, creating GIGO issues that affected an organization’s business intelligence.

Strategy

Strategy

Data Offense or Data Defense: Flexibility vs Control

Data-driven organizations understand that their data is a strategic asset and to properly harness its power it must be supported by a sophisticated data strategy.
Strategy

Implementing a Proof of Concept (POC) Approach

Many c-suite executives are perplexed at the amount of money their organizations spend implementing and integrating data and software applications with limited evidence that they will even align with desired business outcomes.

Healthcare

Healthcare

How Healthcare Payers can breakdown their Data Silos

Siloed data hinders collaboration and can cause serious downstream issues affecting multiple departments such as enrollment, claims and reimbursement. This data fragmentation stops the payer’s ability to get a 360° view of their customer, making it difficult to provide a more personalized experience.
Healthcare

Is Fast Healthcare Interoperability Resources (FHIR) the “Prescribed Burn” that Healthcare Data Needs?

In order to implement automation applications and other machine-based processing, data must follow an agreed-upon structure and standardization. The global healthcare community believes they are close to achieving this with Fast Healthcare Interoperability Resources (FHIR).
Healthcare

Improving Healthcare Effectiveness Data and Information Set (HEDIS) Scores with Data Management

It is important that payer organizations continue to seek ways of improving their HEDIS scores year-to-year. One certain way of doing this would be to implement a proper data management system.

Banking & Financial Services

Banking & Financial Services

The Open Banking Movement is Open for Business

When it comes to financial services, people’s lives can be somewhat fragmented. Depending on the situation, they might be juggling two or three different financial institutions along with several diverse financial products.
Banking & Financial Services

Data Solutions that Improve Risk Management for Banks

An extremely vital aspect of the banking and finance sector is their ability to manage exposure to losses & risk and to protect the value of its assets.
Banking & Financial Services

Accelerating Data Initiatives for the Banking & Finance Industry

With the rapid growth of FinTech organizations, the banking and finance sector are chomping at the bit to figure out a way to accelerate their data initiatives.
Banking & Financial Services

Data Governance: A Banking & Finance necessity, not a luxury

Just like most industries, banking and finance have forever changed due to the explosion of big data and the infrastructure required for processing such data.
Banking & Financial Services

Five ways Financial Services Can Benefit from Snowflake

Cloud-based technology like Snowflake provide financial services organizations with a much needed competitive advantage.

Diversity, Equity & Inclusion

DEI

Women in Technology: It’s Time We Stand Up for What’s Right

At Data Ideology, we have made a concerted effort to recognize and achieve high levels of gender equity in both leadership and employee level positions.
DEI

Gender Equality in Technology: Come so Far, Got so Far to Go

The World Economic Forum recently released the Global Gender Gap Report for 2021. The United States isn’t even in the top 20 for gender equality. Women only make up 14% of cloud computing jobs and 32% of data and AI positions.
DEI

Women In Tech: Getting Hired in Technology Roles

Applying for jobs can be challenging in any situation, but the task can be especially stressful for women in IT considering their underrepresentation in technology fields.

Retail

Retail

Predictive Analytics Improve Business Outcomes for Retailers

If data is the new business currency, then predictive analytics are the means in which organizations can take control of that currency to maximize its benefits.
Retail

Artificial Intelligence (AI) Use Cases for the Retail Industry

Overall spending on Artificial Intelligence (AI) systems is projected to reach $79.2 billion in 2022, which is more than double the amount spent in 2019.
Retail

Automation Solutions Closes the Gap on Last Mile Delivery for Retailers

According to a recent retailer’s report conducted by Blue Yonder, only 14% of the 300 executives surveyed say their fulfillment locations are fully automated.
Retail

A 360-Degree Customer View: Personalizing the Consumer Journey

Although achieving a 360-degree view of customers isn’t a new concept by any stretch, retail organizations are still struggling to achieve this critical feat from a data management perspective.

Categories

14 percent of investment professionals use credit card and POS software data to derive data.

59 percent of executives say big data at their company would be improved through artificial intelligence (AI).

53 percent of CEOs consider themselves the primary leader of their company’s analytics agenda.

60 percent of businesses believe it is harder to source talent for data and analytics positions than for any other roles

61 percent of businesses that recognize the effect of data and analytics on their core business practices say their companies either have not responded to these changes or have taken only ad hoc actions rather than developing a comprehensive, long-term strategy for analytics.

Analytics leaders are nearly twice as likely as others to report enacting a long-term strategy to respond to changes in core business practices.

26 percent of businesses say data and analytics have significantly changed the nature of industry-wide competition.

8 percent of businesses say data and analytics have fundamentally changed the nature of industry-wide competition

50 percent of businesses say data and analytics significantly impacted new entrants launching data and analytics businesses that undermine traditional competitors’ value propositions.

30 percent of businesses consider the Spark software framework critical to their big data analytics strategies.