Converting CSV to Excel streamlines data manipulation and analysis, bridging the simplicity of CSV’s plain text structure with Excel’s powerful spreadsheet functionalities. This conversion ensures a seamless transition from comma-separated records to organized rows and columns, enhancing data accessibility and interpretation. Whether for data analysis, visualization, or collaboration, Excel’s versatile format accommodates diverse needs, offering […]
Data + Intelligence
ELT IS DEAD. LONG LIVE ZERO COPY.
Imagine a world where we can skip Extract and Load, just do our data Transformations connecting directly to sources no matter what data platform you use? Salesforce has taken significant steps over the last 2 years with Data Cloud to streamline how you get data in and out of their platform and we’re excited to […]
Leveraging Data Cloud for Medical Devices
From patient records to medical device telemetry, the volume and diversity of data generated for medical device companies can be staggering. However, harnessing this data to its full potential remains a significant challenge for many. Healthcare organizations, including medical device companies, grapple with dispersed data across various departments and technologies. This fragmentation impedes timely and […]
Creating a Composable AI Roadmap for Sitecore
There are many integration opportunities between Sitecore’s composable solutions and artificial intelligence. Sitecore has begun to integrate this technology into their product line and will continue to enhance their SaaS solutions with these capabilities, having committed to an open approach that allows you to bring whatever AI models and technologies to enable your use cases. […]
Overcoming Payer Challenges With Perficient’s Shop, Quote & Enroll Solution
In today’s rapidly evolving healthcare landscape, payers face numerous challenges in delivering efficient and personalized services to their members. The traditional healthcare experience is often fraught with complexities, inefficiencies, and a lack of transparency, leaving both payers and members frustrated. The Challenges: Lack of a Single Member View: Payers often struggle with fragmented member data […]
Three Principles for Writing Effective Analytics Documentation
Documentation is a crucial part of your analytics implementation. From your Solution Design Reference document to your internal wiki for all resources, making sure that you can write and edit your documentation is key to ensuring a cohesive and thorough understanding of your implementation. With effective documentation, you can: Prevent knowledge gaps among team members […]
Azure SQL Server Performance Check Automation
On Operational projects that involves heavy data processing on a daily basis, there’s a need to monitor the DB performance. Over a period of time, the workload grows causing potential issues. While there are best practices to handle the processing by adopting DBA strategies (indexing, partitioning, collecting STATS, reorganizing tables/indexes, purging data, allocating bandwidth separately […]
Discoveries from Q&A with Enterprise Data using GenAI for Oracle Autonomous Database
Natural language AI has proliferated into many of today’s applications and platforms. One of the high in demand use cases is the ability to find quick answers to questions about what’s hidden within organizational data, such as operational, financial, or other enterprise type data. Therefore leveraging the latest advancements in the GenAI space together with […]
Step by step guide to secure JDBC SSL connection with Postgres in AWS Glue
Have you ever tried connecting a database to AWS Glue using a JDBC SSL encryption connection? It can be quite a puzzle. A few months ago, I faced this exact challenge. I thought it would be easy, but I was wrong! When I searched for help online, I couldn’t find much useful guidance. So, I […]
Microsoft Fabric: NASDAQ stock data ingestion into Lakehouse via Notebook
Background Microsoft Fabric is emerging as one-stop solution to aspects revolving around the data. Before the introduction of Fabric, Power BI faced few limitations related to data ingestion, since Power Query offers limited ETL & data transformation functionality. Power Query M Language scripting lacks ease of development, compared to popular languages like Java / C# […]
Emerging Loyalty Trends in Automotive to Watch Closely: Detroit Event Highlights
Last year, Perficient hosted an automotive event in Detroit that was so successful we had to return. Last week, I returned to the Shinola Hotel to meet with a new group of industry leaders – this time, we discussed brand loyalty and emerging trends and technology. Everyone Should Take the Wheel of Loyalty Loyalty is […]
Introducing Salesforce Einstein Copilot for AI
Do you struggle to optimize user experience and maximize productivity? If so, your team is spending valuable time on repetitive tasks like data entry, locating the right information, and follow-ups, limiting time for core functions and strategic initiatives. What if an AI assistant could streamline workflows and unlock hidden efficiencies? Enter Salesforce’s Einstein Copilot, a […]