Posts Tagged ‘Excel’

Smart View Health Check Simplifying Registry Settings

Have you ever been working in Excel using the Smart View addin and when you go to refresh Excel crashes or your retrieval stops?  Well, one contributor could be your internet registry settings.  I can hear you saying: “What?  Internet settings cannot be the issue… I’m working in Excel!”  However, I have found in many […]

Digital Transformation

Lightning Flow, Data Security, Summer ’18 Enhancements & More

Top Salesforce Updates You Need to Know Einstein, Lightning & More: What’s New in Salesforce Sales Cloud in Summer ’18 Top 5 Jaw-Dropping Salesforce Communities Summer ’18 Enhancements Why is Data Security Important to Me? Running an Integrated ABM Campaign in 5 Steps Connecting to Salesforce in Outlook Perficient’s Award-Winning Partnership with Salesforce What Organizations […]

What Organizations Can Learn From Spreadsheet Debacles

In January 2010, Harvard economists Carmen Reinhart and Kenneth Rogoff published a controversial and influential paper entitled “Growth in a Time of Debt.” The paper studied economic growth at varying levels of debt across both advanced and emerging markets and concluded that countries experienced significantly lower growth when debt levels exceed 90 percent of gross […]

Moving from Excel Spreadsheets to Dynamics 365

Maintaining key organization data in Excel spreadsheets is a surprisingly common business scenario that we encounter with regularity. One might think that in this day and age most business data would be managed in database driven applications. But often, due to a variety of reasons such as segmented business units, mergers and acquisitions, or rapid business […]

How To Import Data Into Siebel Through The UI With Drag And Drop

Our clients are always looking for better or different ways to import data from other systems or from spreadsheets into their Siebel applications. In this blog post, I examine one such method; drag and drop. Starting in Siebel 8.1.1.11 (with patch set 4 applied), you have the ability to drag and drop from applications like […]

Traversing Unstructured Data in Datastage

What is Unstructured Data? Unstructured data is an information that does not have a predefined data model or does not fit well into relational tables. It is broadly classified into two types Non-Textual unstructured data is a multimedia data like still images, videos, and MP3 audio files Textual unstructured data are like email messages, instant […]

Office 365 – Excel Tips For Mail Migration Data Manipulation

While a good percentage of my mail migrations are part of an Exchange Hybrid environment, I don’t always have that luxury. We still work with plenty of migrations to Office 365 from non-Hybrid environments, each with different migration toolsets. When you get to a migration that is something like Google, Zimbra or even an Office […]

Power BI Basics Inside Office 365 – A Video Series

Yesterday, we were fortunate to have a customer, Heidi Rozmiarek, Assistant Director of IT Development for UnityPoint Health, speak alongside our Microsoft BI team for the webinar, “Hybrid Analytics in Healthcare: Leveraging Power BI and Office 365 to Make Smarter Business Decisions.” It was an informative session that began by covering architectural components and functions, […]

Webinar: Hybrid Analytics in Healthcare with O365 & Power BI

The healthcare industry has experienced significant change in recent years, with reform efforts, increased competition and evolving patient demands all top-of-mind for many healthcare executives. Because of this, the ability to access and analyze data in real-time as a means to improving the quality of patient care and managing costs has gone from a “nice […]

Collecting and Reporting Adverse Events in Excel

Jody Trader, a pharmacovigilance and drug safety specialist at MMS Holdings, a CRO based in Michigan, recently published a blog post on whether or not Microsoft Excel was sufficient for capturing and reporting adverse events. Since validated safety databases, such as Oracle’s Argus Safety, are often costly, sponsors and CROs continue to use spreadsheets for […]

Sahi Controller

Read/Write from Excel using Sahi Automation Tool

While automating an application, taking the modern automation frameworks into consideration it becomes a necessary action to make our script interact with an excel sheet or csv data file in order to read and write the data. Usually we use excel sheet, as this provides more organized way of storing the data. Let’s see the […]

SharePoint 2013 – Is Access 2013 the New InfoPath?

If you were at the SharePoint conference this year in Las Vegas, you probably saw the InfoPath Funeral procession through the vendor pavilion.  If not here is a clip:   We have known for quite some time Microsoft isn’t putting a large effort into InfoPath and in fact “… InfoPath 2013 is the last release […]

Load More