Posts in Amazon Web Services (AWS)
Unlocking the Potential of Healthcare Data: PMsquare's SimAI's Role in HTI-1 Compliance

In today's dynamic healthcare landscape, leveraging data strategically is essential for improving patient outcomes, streamlining operations, and cutting costs. With the introduction of the Health Data, Technology, and Interoperability (HTI-1) rule, healthcare organizations must navigate regulatory complexities while harnessing data for innovation. PMsquare's SimAI offers a transformative solution, guiding providers through HTI-1 compliance and unlocking the full potential of their data.

Read More
SaaS Application to AWS S3 Made Easy Via AppFlow

In our current data-driven environment, businesses face significant demands to leverage data for well-informed decision-making, glean customer insights, and implement predictive analytics powered by machine learning. Enter Amazon Appflow—a game-changer in the world of data integration. Say goodbye to months of API documentation reading and code perfection. Join us as we delve into the capabilities of Amazon Appflow and how it empowers organizations to equip their teams with the essential data required for valuable insights and data-driven decision-making.

Read More
Best Practices to Avoid Bottlenecks in AWS Glue and Redshift

AWS Glue is a server-less data integration service that provides all capabilities needed to categorize, clean, enrich and move the data between data stores. It is a powerful ETL tool that reduces and automates a significant portion of the effort required for data integration. To fully leverage AWS Glue’s capabilities for production workloads, the service must be fine-tuned with proper configurations to reduce job runtime and increase resource availability.

Read More
Amazon QuickSight Complete Guide #3: QuickSight Q

This is a continuation of the QuickSight series of posts, focusing on AWS QuickSight’s new feature, Q. Q is a machine learning powered querying capability in QuickSight that allows business users to query using their everyday natural language. Q is a way for organizations to break from the traditional BI mold. Previously, organizations needed a BI analyst or engineer to build out their dashboards.

Read More
The Official Cloud Migration Checklist

Most businesses are migrated or are in the process of migrating, critical workloads to cloud infrastructure. The competitive advantage cloud platforms give businesses makes this move an easy choice for organizations. Employees on the front lines tasked with managing these workloads know making the choice to move to the cloud is easier than performing the actual migration. Fortunately, PMsquare is here to help! I’ve created a high-level checklist to keep in mind when beginning your cloud migration. This list will help frame your thinking when planning to move on-premises applications to a cloud provider like AWS, Azure, or Google Cloud.

Read More
Calculating On-Premise vs Cloud Costs

Many organizations struggle to figure out whether migrating to the cloud is the right financial decision. There are many questions that must be answered prior to making a final call. For example, what financial factors should be taken into consideration when deciding if your company should migrate to the cloud? How can you calculate the cost of running your operations in the cloud? What are the hidden costs associated with a cloud environment? How much will you be spending or saving every month by running your operations in the cloud instead of on-premise? The first step to answering any of the questions is to examine all costs associated with the current infrastructure.

Read More
Kai Ming’s PMsquare Children’s Center Opens Its Doors

Kai Ming, a non-profit agency providing comprehensive early care and education services for underprivileged children, and PMsquare, a data analytics technology and consulting firm, are excited to announce that the PMsquare Children’s Center has officially opened its doors on May 13th in Mission Bay, San Francisco.

Read More
Reduce Cognos Install Times with AWS EC2 User Data and AMIs

Installing Cognos takes time. The more complex the environment, the more time it takes. The time spent running the Cognos installer is compounded by the number of environments that need to be created. Fortunately, there are options on AWS to help Cognos administrators get out of the business of waiting for the install to complete. The two options we will be exploring here are EC2 user data and custom AMIs.

Read More
Which To Choose: Staff Aug or SaaS Anywhere?

Just the other day, I was wrangling with a DIY challenge and spent hours trying to make a scattering of suboptimal tools I had work when a short run to the hardware store would have solved all my problems in minutes. In much the same way in analytics consulting, I see my clients sometimes struggling to find the right service for their challenges of the near and long term. In this piece, I’ll share an overview of two seemingly similar service options and discern the right time to engage for each.

Read More
Cloud-Enable Your Legacy Applications

Many organizations have begun shifting their operations to virtual data centers, modernizing their applications to be cloud-enabled. But what exactly is “cloud-enabled,” and how can they adopt a new cloud architecture? Let’s dive into the meaning of the term and look at some examples to give a better understanding of how these applications can fit into a cloud deployment.

Read More
Be Alerted When an Amazon S3 File is Missing Using Lambda, SNS, and EventBridge

Alarms are very helpful in determining the state of certain processes such as Amazon Web Services (AWS) Glue workflows and jobs as part of an ETL pipeline. Ideally, there would be a team assigned to monitor the AWS Glue workflows regularly, but this is not very practical or feasible as many workflows are scheduled to run overnight or during off-hours. Setting up alarms to ensure these workflows successfully finish and don’t error out is key to troubleshooting issues early and maintaining and smooth-running pipeline.

Read More
Passing AWS Secrets to Microsoft PowerShell

Secret managers have become the go-to tool to avoid hard coding credentials in source code. Secret managers provide a centralized place to store sensitive data like database credentials and API keys. In Amazon Web Services (AWS) there are two services for storing secrets: AWS Secrets Manager and the Parameter Store. The key to this workflow is specific PowerShell modules that will allow you to script operations of AWS resources directly from the PowerShell command line.

Read More
Amazon QuickSight Complete Guide: Signing Up & Getting Started

This article is the continuation of the Amazon QuickSight Complete Guide Series, focusing on the topic of getting your QuickSight environment set up and ready to use. If you haven’t checked out the first installment of the Amazon QuickSight Complete Guide, covering Pricing and Editions, I would recommend you take a couple of minutes to check it out. The series of QuickSight posts will detail everything you need to know about QuickSight as well as some walkthroughs of the main tools.

Read More
3 Reasons to Love Amazon QuickSight

QuickSight is rapidly evolving into a top-notch BI and data visualization tool and even entered the Gartner Magic Quadrant for BI this last year. QuickSight is fundamentally a very good visualization and reporting platform, but with all the options available in the crowded BI market, what are the top reasons to choose Amazon QuickSight?

Read More