Power BI — Table for Key Measures — Episode 4
26 Apr 2019

Welcome to Episode 4 of my Power BI Best Practices Series. In today’s episode, I will show you how to set up a key measures Power BI table, and why it’s beneficial to do so. Last episode, we covered sub-dividing and segmenting visuals. As a reminder, here is the overall curriculum for this video blog series: Be creative and tell a story Eliminate unnecessary columns Sub-divide & segment visual placement Table for key measures Prepare report requirements Relate tables using your data model Align your visuals Create drill through pages with detail Themes are your best friend Include a report support tab Cut unnecessary visuals E...

Developing a secure healthcare data platform
25 Apr 2019

One of our US healthcare clients approached us to create a reliable and secure data platform for their application. After examining their data infrastructure and goals, DB Best came up with a cloud-based solution to build questionnaires based application, to meet the customer’s needs. An application guiding your lifestyle Our customer envisioned an application to help people suffering from chronic diseases live full, unobstructed lives. For sufferers of these life-long illnesses, keeping track of their symptoms and bodily health, as well as following their doctor’s advice, is key to overcoming their disease. However, we all kno...

modernization from oracle to sql server
Advanced Engineering Application Modernization from Oracle to SQL Server
22 Apr 2019

As moats create obstacles in the way of an invader, so do proprietary database features for developers. One of Oracle’s proprietary features is the Oracle Call Interface (OCI) which provides efficient communication between application code and the database. There are other ways to connect to Oracle, but once you have committed to OCI, you are “protected” from switching to another database. In this blog post, we break down an application modernization from Oracle to SQL Server for an advanced engineering-oriented customer.   Customer Problem Our customer had been using Oracle in their Windows-based product for many years, and they c...

revenue streams DBBEST
New revenue streams for Retail and Services industries in 2020
16 Apr 2019

It seems that the world is slipping further and further into our pockets. We are doing more on our phones than ever before, and the power of the small, black tablets is growing stronger every year. The latest iPhone, only 6 inches tall and 3 inches wide, rivals the flagship desktop computers of only a few short years ago while adding GPS capabilities and Augmented Reality (AR), Virtual Reality (VR), and Machine Learning (ML). With billions of smartphones in use every single day, and mobile shopping becoming one of the primary forms of commerce, it is an exciting time to be in the retail and service industry. For any store owner, your goal is ...

convert Oracle synonyms to PostgreSQL
How to convert Oracle synonyms to Amazon RDS for PostgreSQL
15 Apr 2019

One of our ISV customers wanted to get off their expensive Oracle licenses and develop a cloud-based SaaS solution. They looked to us to help their development team migrate their database applications to Amazon RDS for PostgreSQL . The DB Best migration team utilized AWS Schema Conversion Tool (SCT) to automate the conversion of customer’s database and application code. However, the original system utilized a lot of specific Oracle features, for example, synonyms. SCT does not convert all types of Oracle synonyms to PostgreSQL correctly. So, the DB Best team came up with a variety of state-of-art workarounds to accomplish this databas...

Power BI - Eliminate Unnecessary Columns
Power BI — Eliminate Unnecessary Columns — Episode 2
12 Apr 2019

Welcome to Episode 2 of my Power BI Best Practices Series. In this episode, I will show you the importance of eliminating unwanted columns from cluttering your Power BI Desktop Report. Be sure to check out prior episodes and see where I’m going with BEST PRACTICES below. Be creative and tell a story Eliminate unnecessary columns Sub-divide & segment visual placement Table for key measures Prepare report requirements Relate tables using your data model Align your visuals Create drill through pages with detail Themes are your best friend Include a report support tab Cut unnecessary visuals Edit interactions Set visual, page, and r...

iot-solutions-for office-cover
Using smart IoT systems to keep your office manager from going insane
11 Apr 2019

Technologies drive our lives. Smart IoT solutions have found a place in our homes in the form of connected locks, cameras, and alarms. But have you ever thought about using IoT technologies to change office life for the better? For you, we’re going to deep dive into all the tech connecting workplaces. The perks of running your office from a tablet For most of us, offices are living places and naturally, we want to feel at home. When we don’t — we find the office manager with our wish-lists, that turn into to-do-lists for them. Running an office of 300+ employees is not an easy task. However, keeping things in order seems far more re...

native or hybrid mobile app
Native or hybrid mobile app — what to choose
09 Apr 2019

Making the choice between a hybrid and a native path might seem complicated, but the truth is that it’s not. Today, we’re going to examine the performance, UI/UX specifics, costs, development duration, and other parameters between each stack. When you know what separates the two, all you need to do is go back to your project and find the indications for either a native or hybrid mobile development. Ready to explore the differences? Tech stack you can pick from DB Best has vast experience in application building. In our portfolio, we have solutions for the Healthcare and Fitness industry, Augmented and Virtual Reality-based applica...

Power BI - Be Creative
Power BI — Be Creative and Tell a Story — Episode 1
05 Apr 2019

Welcome to my Power BI Best Practices video series Over the past year, I’ve been blessed to share my B.E.S.T. P.R.A.C.T.I.C.E.S. at the Memphis PASS Power BI meetup, the Microsoft Tech Expo in Portland, and the  Power BI World Tour in Seattle. At the Seattle event, I was lucky enough to meet with members of the Power BI product team like Will Thompson @Will_MI77 and Maggie Sparkman @maggiesMSFT. Since not everyone can get out and attend events like these, I sat down with the DB Best marketing team to create a series of videos that cover each letter in Best Practices for Power BI. So what do I mean by Best Practices? Be creative and tel...