Posts Tagged ‘Excel’

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 […]

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 […]

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, […]

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 […]

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 […]

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 […]

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 […]

In recent months, you’ve probably heard a thing or two about Power BI, the new cloud-centric BI front end tool set from Microsoft. Available to Office 365 SharePoint Online users, Power BI is a compelling new offering with advanced collaborative BI capabilities. Power BI includes PowerPivot, PowerView, Power Map, and Power Query. While these tools […]

If you’ve ever attempted to perform a performance test on a TM1 application, you know that there is not really an effective way to manually create sufficient load on a model. Getting “real users” to execute application operations – over and over again – is nearly impossible. Thankfully, an automated testing product can solve for […]

Overview The purpose of this post is to provide a strategy for approaching and resolving a “concern” that has been identified within a application. Overall, the idea is to “add structure” to the process of responding to defects (remediation) in your application. Steps to Remediation Using a resolution methodology referred to as CERT, the steps […]

Typically, a TM1 project will include work to create reports. Most finance groups will have a number of Excel workbooks that they are using for both their forecasting and planning as well as for reporting. These workbooks will become the “templates” for designing your TM1 input sheets and reports. For the reports, you will be […]

Last week while at the annual Microsoft Dynamics Convergence in New Orleans (with 10,000 other people- partners, clients and MS employees) there was a great session on Advanced Analytics for Microsoft Dynamics CRM. Many of these options have been available for the last few years since the release of CRM 2011 (both online and on-premises) […]