BI Services and Strategy

Getting Lost in Big Data?

By | Database Technology Trends, Oracle, SAP HANA, SQL Server, Sybase
Let’s talk a little bit about big data. This is such an important buzz word in technology and data management circles these days. I think, however, that sometimes the nuances get lost. Big data is great, and has amazing potential applications for improving business processes, marketing opportunities, and customer identification, among others. Big data facilitates AI and machine learning, giving us unprecedented insights into patterns of behavior and process improvement opportunities. But the flip side of this is that big data also gives us massive amounts of ‘stuff’ to store and sift. I don’t mean to say that this data isn’t valuable. But without a solid strategy for utilizing and extracting meaning from this data, it can become costly clutter. Big Data has A Big History – Big data is a concept that has been around for a while. Data storage and processing machines were created throughout the 20th century to handle increases in record-keeping needs corresponding to cryptography and security efforts, as well as governmental programs like Social Security and tax management. The British developed Colossus in 1943 to filter through Nazi transmissions and identify patterns for code-breaking. This is essentially the first data processor of the modern era. (more…)

Oracle EBS – Improving Performance with Analyzers

By | Oracle
Oracle E-Business Suite is a fantastic suite of applications designed for the enterprise client to facilitate data management and analytics. The group of tools brings exciting possibilities to the Oracle client. But there’s more. The introduction of Analyzers as proactive tools improves performance and reduces troubleshooting headaches for the EBS client. If you’re using Oracle EBS, it’s time to check out the available Analyzers. What are Analyzers? These tools are essentially diagnostic support tools that can help not only identify issues but also suggest corrective action. They are designed to work alongside your current maintenance program to boost its effectiveness and your productivity. If your current diagnostics tools aren’t offering you suggested solutions, then you’re not using analyzers. The analyzers can also help if you need to open a service request with Oracle. They will gather important data to speed the diagnostic process and get a quick resolution. How do They Work? These tools can be scheduled ahead or run on demand by authorized users. They analyze your environment for known issues and create assessment reports with findings and recommended actions. The analyzers improve the health of your environments and significantly speed time to resolution for service requests. If you (more…)

DataOps – Developing Processes for Analytics and Data Management

By | Custom Software, Database Technology Trends
Big data and analytics mean big things for industries across all sectors. As data continues to grow, so do the applications. The newest challenge is streamlining the analytics process to improve efficiency and create actionable insights in a timely manner. That is where DataOps comes in. This newest development utilizes concepts learned from DevOps practices to simplify and streamline the data pipeline and analytics process. Let’s take a look at how this works. The Science of Analytics The analysis of big data is a complicated process of pattern recognition using statistical tools and algorithms. Your data scientists, engineers, and analysts may all play some part in this role. Managing the analytics process from an operational standpoint, as well as a statistical standpoint, can be time-consuming. If you want to have real, useable insights from your data it is imperative to validate both input and output data. It’s taxing to your analysts and means longer lead times on identifying key insights. But these steps are there for a reason, right? You can’t skip vital processes just because they’re lengthy. But you can innovate those processes and improve their efficiency. The development world has been working on this for a while with (more…)

Why OCI is the Perfect Platform for Oracle EBS

By | Blog, Oracle
Oracle E-Business Suite (EBS) is a fantastic compilation of tools for consolidating your enterprise functionality, management, and analytics. But what platform should you use to make the most out of your Oracle EBS? On-prem or third-party cloud infrastructure may not be making the most out of your Oracle applications. With Oracle Cloud Infrastructure (OCI) you will enjoy the fastest, most efficient, most optimized platform to get the maximum benefit from Oracle EBS. What is Oracle EBS? This suite of applications handles everything you need to run your enterprise level business functionality, including customer relationship management (CRM), human resources management (HRM), enterprise resource planning (ERP), and supply-chain management (SCM). The EBS collection is one of Oracle’s major product offerings with robust capabilities to consolidate your business management under one roof. With tools covering logistics, financials, order management, marketing, HR, and many more, Oracle EBS is an industry leading, comprehensive solution. Is On-Prem a Problem? If you are a current or future owner of Oracle EBS you may be wondering what infrastructure will best compliment this powerhouse of tools. More and more companies are moving away from in-house data centers because of the high cost of implementation and maintenance. These data centers (more…)

Is SQL PaaS Right for You?

By | Azure
With the arrival of the new year, you might be considering how SQL Server can better fit your company’s growth in 2019.  SQL Platform as a Service (PaaS) could be a viable option for managing essential database operations. With PaaS, your SQL Server workloads would run as a hosted service in the cloud with most database management functions maintained by the cloud service provider instead of your IT team. Top Reasons to Consider PaaS Operates completely within the cloud. PaaS provides developers with an environment to develop and deploy applications entirely within the cloud. This includes complex enterprise applications your company may need to solve business problems and simple cloud-based applications. Scaling is easy. You can pay-as-you-go. Service providers allow you to take advantage of advanced development tools as you need them, giving you more value at an affordable rate. Your bottom line increases. You no longer need to purchase software licenses, application infrastructure, or development tools. Finally, your development team can have the opportunity to focus on managing the applications and services they create while the cloud service provider manages the rest. Decrease coding time. The development tools PaaS can provide include some pre-coded application components (i.e., security features, directory services, workflow, etc.) (more…)

Machine Learning, AI and Advanced Analytics

By | Database Technology Trends
Big data is big news across industry sectors. The digital age has given rise to information overload, and the most resourceful businesses are learning how to take advantage of that information. It takes a special type of skill to gain actionable insights from these massive amounts of data, and that is where advanced analytics comes in. With technologies like artificial intelligence (AI) and machine learning (ML), data-driven business insights are possible like never before. Here’s a breakdown of how these technologies really work. The Science of Advanced Analytics – Traditional analytics refers to more linear quantitative analysis, usually generated by business intelligence (BI) systems. These are examinations of performance drawn from a structured and pre-defined framework. They use existing historical data from a database or data warehouse. With advanced analytics, we are able to follow the data without a pre-determined scope. All you need is a starting point. For example, consider the question: what type of people buy yogurt in the mornings? With traditional analysis, you would be left skimming through sales data and designing reports to cross reference yogurt sales and time of day, but that only tells you how many people have performed this action, not what type (more…)
Database Consulting

What are Data Clusters and What Can They do For You?

By | Azure, SQL Server
Learning to effectively manage large datasets is key to optimizing your data analytics. Using data clusters can help optimize your data management. It involves grouping data points with similar characteristics into the same cluster to speed up processing time and improve analysis. Consider starting an analysis project on customer spending habits by gender in different regions. Your time on the project would be maximized if you’re able to use statistical techniques to automatically organize the data into logical groups prior to analyzing. How do data clusters work? Data clustering allows you to partition large volumes of structured and unstructured data/observations into logical groupings. One way it does this is by analyzing all of the data in the data warehouse and comparing each data point with clusters created. You rely upon the clustering algorithms to sort and cluster the data in a logical way. In a perfect world, all data points in the same group should be highly similar in nature, while data points in different groups should be dissimilar. There are several different models and algorithms that guide the clustering process. Here are a few: Hierarchical Method: This method creates separate successive clusters using specific criteria. Partitioning Method: This method (more…)

Ron Hymer Chosen To Lead New, Data Intensive, Custom Software Development Division

By | Press Releases
TAMPA BAY, FLA. JANUARY 21, 2019 Dobler Consulting is pleased to announce that Ron Hymer, a recognized thought–leader in custom software development, will be joining the Dobler team to lead their client-centric software development practice. Hymer brings to Dobler years of experience designing and implementing data-intensive software solutions for national and regional business in a variety of sectors. “We are excited to have such a savvy business technologist like Ron join our team,” said Peter Dobler, President of Dobler Consulting. “The trend we’re seeing for 2019 and going forward is that business not only need expert managed services for their expanding enterprise data assets; they now need to more expertly leverage those assets through integrative, fine-tuned, custom software applications that are niche specific. Ron gives us this expertise and leadership.” According to Gartner’s Top 10 Strategic Trends for 2019, this trend of fine-tuned software customization is driven by the combinatorial effects of strategic technologies: AI–driven development, edge computing, augmented analytics, blockchain, and security to create smart spaces for innovation, collaboration and immersive experiences. “I have worked in data leveraged software development for over twenty years, and there has never been a more exciting time where the convergence of technologies has (more…)

How to Make Power BI Work for You

By | Database Technology Trends, SQL Server
If you’re searching for software that will enhance your analytics process while making it simpler and more flexible, Power BI is worth looking at. It provides tools that the non-technical users on your team can use to perform analytics with minimal help from the IT team. You can create intuitive models, data visualizations, and dashboards and share them with whoever you want. What is Power BI? –Power BI is a cloud-based analytics software service consisting of a combination of tools (i.e., visualization, self-service data analysis, etc.) that allows users to connect to multiple data sources—no matter where the data resides— and create customized, coherent insights. It’s not exactly new since many of its components were in the market prior to its 2015 release. For instance, Microsoft released Power Pivot as an Excel add-on in 2010. This tool alone is a game changer as it gives analysts the tools to import large volumes of data, create relationships between the data, and perform powerful analysis using PivotTables and Pivot Charts. Using Power BI, you can further manipulate these datasets to perform more complex analyses. Utilize All Components of Power BI – Power BI consists of many components. Users find some more useful (more…)

We’re Excited About SQL Server 2019, Here’s Why

By | Azure
Microsoft SQL Server 2019 is out in preview and it’s got some exciting new features. When Microsoft announced the release at their Ignite 2018 conference on Sept 24th, we couldn’t wait to see what was in store. This newest offering will continue to build on the solid foundation of SQL servers while expanding offerings of flexibility and further embracing big data by adding support for Kubernetes, Apache Spark, and Hadoop clusters. Embraces Big Data – Probably the biggest change to SQL 2019 is the ability to manage big data clusters. Big data has always been a bit of a gap in the arsenal of Microsoft’s SQL servers, but not anymore. With SQL 2019, Microsoft is fully embracing big data with Kubernetes. Kubernetes is an open-source container-based platform that represents exciting new possibilities for this SQL engine. With SQL on Kubernetes you will be able to can create high availability solutions with Linux containers and manage multiple data sources all in one place. Manage Relational and Non-Relational Data – The new engine can query data from a number of different sources, including relational and non-relational data storage. Microsoft has built in native support of Apache Spark and Hadoop Distributed File System (more…)