Posts Tagged ‘best practices’

In Power BI, Top N and Bottom N are often displayed using a visual level filter and two visuals, respectively. As a result, we can only show one item at a time on top or bottom N. But, if the situation asks for slicer selection to be used to dynamically change how top and bottom […]

Are you a part of the Human Resources team, which is tasked with reporting on Equal Employment Opportunity? Are you an Oracle Human Capital Management consultant tasked with configuring the environment setup of this report? The goal of this blog is twofold: demystify EEO reporting by defining the various reports, and outline EEO-1 reporting setups […]

In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]

In today’s dynamic and competitive business landscape, IT Leaders are constantly seeking ways to optimize their operations and stay ahead of the competition. One crucial decision organizations must make is choosing between a project-driven or a product-driven approach for product development. A project-driven approach prioritizes the completion of individual projects, while a product-driven approach prioritizes […]

Time spent on mobile apps has increased exponentially in the past few years. The development team must safeguard with the tools and technology available at their disposal. We will review techniques for mobile app security. You may also reference Give Your React Native Apps a Titanium Shield Against Vulnerabilities and OWASP Mobile Top 10 for […]

Microsoft Power BI is business intelligence Tool . Microsoft Power BI is a Leader in analytics and business intelligence platforms. This Blog  will walk you through different websites to get sample data for power bi to practice Go to the Microsoft documentation, link as below. https://learn.microsoft.com/en-us/power-bi/create-reports/sample-datasets You can access the dataset or actual source itself […]

The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]

Have you ever had a scenario where you need to Display the last 6 month or 4 month or N months of data just by selecting a single date dimension in slicer, sounds difficult“? Let’s me show you step by step how to display last N months of data just by selecting single date dimension […]

Have you ever suddenly found that a person you depend on for a project is out on vacation? No matter your role on a team, a mitigation plan can be an ideal way to capture your expectations when it is your turn to take vacation.  Your plan can provide guidance for how to handle certain […]

I recently worked with a client who wanted a reasonably large subsystem added to Optimizely that would add automated management to their content. While cutting the code for this, I found myself writing similar code across multiple classes. I had to write it that way: 1) The client was currently on CMS11 and didn’t have […]

Project go-lives can be intense and take hours or even days. Following a detailed plan can streamline your go-live to help avoid a rollback and allow everyone to shut their computers as quickly as possible. Let’s discuss how to create a solid Cutover Plan to set yourself up for success.  Why a Cutover Plan?  First, the […]

Imagine you’re running a marathon – you’ve trained hard, your pace is great, and you’re feeling good. Finally, after many miles, you spot the finish line. Is that when you pump the brakes and lose focus? Of course not! You’d keep pushing through to the very end – you’ve come this far, you’re way too […]