Power BI - Sub-divide and segment
Power BI — Sub-Divide and Segment Your Visuals — Episode 3
19 Apr 2019

Welcome to Episode 3 of my Power BI Best Practices Series. In today’s episode, I will show you how to sub-divide and segment your data visualizations in your Power BI Dashboards or Reports. To check out prior episodes and see where we are going, here is what BEST PRACTICES for Power BI is all about. Be creative and tell a story Eliminate unnecessary columns Sub-divide and segment visual placement Table for key measures Prepare report requirements Relate tables using your data model Align the visuals Create drill through pages with detail Themes are your best friend Include a report support tab Cut unnecessary visuals Edit interactions S...

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 the 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 & r...

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 — 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...

How to manage a WordPress deployment with Azure DevOps using Docker Containers
21 Mar 2019

As a Cloud Architect for DB Best Technology, with emphasis on the Azure platform, I’ve seen almost all of what the cloud has to offer. For the past 7 years, I’ve been helping customers develop and deploy their applications for Microsoft Azure. So when the project team at DB Best came to me for guidance on how to best deploy WordPress on Azure before going live, I was all in. I’d like to share my best practices and walk you through the step-by-step instructions on how to manage a WordPress deployment with Azure DevOps using Docker containers. First a little background We’ve been working with our Telecom client’s web site since 20...

IoT transforming your office into a healthy and green workspace
21 Mar 2019

That finally happened. You received the coveted letter of employment and have settled into your dream job. In less than a week, the euphoria fades and you realize that you’re staring at the same monitors day, after day, after day. Your constant back pain, twitching eye, and the spoiled milk in the office kitchen are all reminding you that the honeymoon period is over. However, for many companies things are going to change – employee wellbeing is now a top priority. Today, more and more businesses are focusing on employee wellbeing. Studies show that employee health, workplace productivity, and employee satisfaction rates all impro...

Dedicated development
The benefits of hiring a dedicated development team
19 Mar 2019

Building your team can be one of the most stressful elements of any business. The people you hire are the ones who you work with to design, create, and distribute your application to the world. As you begin the lengthy hiring process of developers to build or augment your app, you’re going to be struck by a lightning bolt of realization — “isn’t there a better way to do it?” Sifting through resumes, portfolios, and GitHub code is a time-consuming process. This can lead to significant delays in development. It’s why we here at DB Best embrace a ‘dedicated development’ model. An easily scalable team o...