Newsletters




Business Intelligence and Analytics

The world of Business Intelligence and Analytics is evolving quickly. Increasingly, the emphasis is on real-time Business Intelligence to enable faster decision making, and on Data Visualization, which enables data patterns to be seen more clearly. Key technologies involved in preparing raw data to be used for Business Intelligence, Reporting and Analytics – including ETL (Extract, Transform, and Load), CDC (Change Data Capture), and Data Deduplication – support a wide range of goals within organizations.



Business Intelligence and Analytics Articles

One creates the potential for some interesting anomalies when building a star schema wherein the fact table contains future-dated metrics and any of the dimensions are Type 2.  A Type 2 dimension tracks changes to the data items contained within it. Effectively, each dimension contains a surrogate key, a natural key with a start and stop date, and additional descriptor columns. If any of the descriptor column values change, the existing dimension row has the stop date populated while a new row is inserted with the same natural key, new start date, and new descriptor values. 

Posted May 13, 2020

As a database consultant, one of the things I am most frequently asked about is dealing with database locking issues. Every DBMS has different settings and parameters to control locking at the system and database levels. And, yes, it is important to set these up correctly, but they are rarely the core cause of performance problems caused by locking. So let's focus on the universal issue that is almost always the culprit: poor coding techniques and inappropriate oversight before code is moved to production.

Posted May 13, 2020

What more companies need today is a "data lab" to create ideas from data and a "data factory" to turn those ideas into products. Google, Amazon, and other data-driven giants already work like this. So should companies outside of technology. 

Posted May 13, 2020

Informed business decisions are backed by data and the actionable insights workers are able to glean from various datasets.  However, if you're a data steward, data engineer, data scientist, analyst, or anyone else requesting data to answer important business questions, the easy access to people with data and data context is suddenly and indefinitely gone.

Posted May 13, 2020

Business and IT have, in the past, used times of crisis to adapt and transform themselves for the better. While the COVID-19 pandemic has undeniably had a devastating effect on business, and life itself, it may also be a catalyst for change, compelling organizations to rethink their long-term operations and spending amidst the short-term crisis brought on by the health emergency. Industry leaders recently discussed what "the new normal" may look like.

Posted May 13, 2020

As the COVID-19 pandemic rages on, several companies have been instrumental in providing tools to promote remote workplace safety. Rocket Software is among the organizations that reacted swiftly when shelter in place orders were announced.

Posted May 13, 2020

Smyth Automotive provides full-service automotive parts, paint and body, and machine shop services. In business since 1963, the company differentiates itself with knowledgeable, helpful and friendly staff, better prices and great quality.

Posted May 13, 2020

The COVID-19 pandemic has forced many companies to switch to remote work and BlueFinity is assisting companies with the transition. Its Evoke product allows citizen developers (the company's existing staff) to build business apps using low-code, drop and drag, point and click; and option select methods.

Posted May 13, 2020

GoodData, a provider of end-to-end analytics solutions, is releasing a new web-based logical data model (LDM) modeler, bringing new capabilities and tooling to enables the simplification of data modeling. The web-based LDM modeler compliments the recently released GoodData data source management interface, which enables easy connection to Google BigQuery, Amazon Redshift, Snowflake, or a CSV file.

Posted May 12, 2020

Appian and KPMG are collaborating on a new offering that supports businesses impacted by the California Consumer Privacy Act (CCPA). Built on Appian's low-code automation platform, the offering helps companies quickly and intelligently respond to data privacy requests, while decreasing manual tasks that run the risk of errors.

Posted May 12, 2020

Nokia is collaborating with Microsoft as part of the SONiC initiative, an open source network operating system based on Linux that has been production-hardened in the data centers of some of the largest cloud-service providers.

Posted May 12, 2020

Astera has announced Centerprise 8.2, which includes enhancements in connectivity and ease-of-use to simplify data integration for enterprise users. Included with Centerprise 8.2 is a new version of ReportMiner.

Posted May 12, 2020

MemSQL, the No-Limits Database for operational analytics and cloud-native applications, is receiving $50 million in new capital after signing a debt facility agreement with Hercules Capital, the largest non-bank venture debt provider with more than $2.4 billion in total assets, who served as underwriter for the financing.

Posted May 11, 2020

Informatica, an enterprise cloud data management provider, is creating an integration with SAP that will help streamline businesses journeys to the cloud by adopting SAP's data and analytics cloud portfolio and Informatica Intelligent Cloud Services. This new integration will strengthen the partnership between SAP and Informatica.

Posted May 08, 2020

Ermetic, the cloud access risk security company, is emerging from stealth mode today and is releasing an analytics-based solution that prevents cloud data breaches. The platform automates the detection and remediation of identity and access risks in Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings from Amazon, Google and Microsoft.

Posted May 06, 2020

Cloudera, the enterprise data cloud company, is releasing an expanded set of production machine learning capabilities for MLOps, now available in Cloudera Machine Learning (CML). Organizations can manage and secure the ML lifecycle for production machine learning with CML's new MLOps features and Cloudera SDX for models.

Posted May 06, 2020

Datrium, providers of cloud-native disaster recovery with ransomware protection, is extending its Datrium DRaaS with VMware Cloud on AWS solution to support Edge environments. Datrium DRaaS for Edge is a new, easy to use, cost-effective SaaS solution for data protection and disaster recovery (DR) for VMware workloads in Edge environments and remote office/branch office (ROBO) implementations.

Posted May 06, 2020

GoodData, a provider of end-to-end analytics solutions, has added new capabilities to its Accelerator Toolkit, which is used by organizations to add data analytics into the natural flow of applications. "Achieving actionable insights from data is the make-it-or-break-it competitive advantage that all companies need, and GoodData continues to push innovation to make analytics everywhere possible," said Zdenek Svoboda, co-founder and vice president of product, GoodData.

Posted May 06, 2020

Oracle Cloud Infrastructure-Government Cloud has achieved FedRAMP High Authorization. "Government customers rely on Oracle Cloud to run their most critical workloads. With FedRAMP High and Impact Level 5 authorizations, we are able to support the highest levels of security standards for unclassified workloads across local, state, and federal government, as well as the Department of Defense," said Scott Twaddle, vice president, Regulated Markets, Oracle Cloud Infrastructure.

Posted May 06, 2020

PlanetScale, creator of PlanetScaleDB, database-as-a-service built on Kubernetes and Vitess, is launching a multi-cloud database, enabling companies to deploy, run, and manage databases that span multiple cloud providers simultaneously. PlanetScaleDB is built on two trusted technologies: MySQL, which powers millions of applications, and Vitess, a cloud-native computing foundation (CNCF) hosted open source graduated project that serves massive-scale production traffic at companies such as YouTube, Slack, and Square.

Posted May 06, 2020

Yellowbrick Data, providing a data warehouse for hybrid cloud, and Next Pathway Inc., the Automated Cloud Migration company, are collaborating to accelerate the migration of complex on-prem workloads to the Yellowbrick Data hybrid cloud data warehouse.

Posted May 05, 2020

HVR, an independent provider of real-time cloud data replication technology, is forming a strategic partnership with Talend, a leader in data integration and data integrity, enabling customers to integrate their data for a complete view of business operations and analytics.

Posted May 05, 2020

New Relic, a cloud-based observability platform built to help customers create more perfect software, is introducing New Relic Edge with Infinite Tracing. The new offering is a fully managed, cloud-native, tail-based distributed tracing solution built to empower software engineering teams to rapidly diagnose issues and latency across complex environments.

Posted May 05, 2020

Cockroach Labs, the company behind CockroachDB, is receiving $86.6 million in series D funding to further grow investments in R&D to better support customers looking to move to the cloud. The funding round was co-led by Altimeter Capital and BOND with participation from Benchmark, GV, Index Ventures, Redpoint Ventures, Sequoia Capital, and Tiger Capital. This round brings Cockroach Labs' total funding to $195 million.

Posted May 05, 2020

Humio is now part of the IBM Edge Application Manager Ecosystem, an initiative designed to help enterprises capture the opportunities of edge computing with a variety of solutions built on IBM's technology. Humio collects machine data from edge devices, gateways, and servers to monitor the health of the entire infrastructure, detect security incidences, and reveal insights into the customer experience.

Posted May 05, 2020

Dremio has announced the free availability of the Dremio AWS Edition, a self-service data lake engine highly optimized for Amazon Web Services (AWS) and available in AWS Marketplace. "Dremio brings interactive BI and data science to Amazon S3, and with our new AWS Edition we are dramatically lowering the cost per query and making data lake insights accessible to data consumers in organizations of any size," said Tomer Shiran, chief product officer, Dremio.

Posted May 05, 2020

Pure Storage is releasing Purity//FB 3.0 for FlashBlade, the next generation of the industry's most advanced storage software for unstructured data. The latest updates to FlashBlade enable real-time performance that allow application workflows to take center stage - resulting in a Modern Data Experience that replaces complexities and antiquated systems with fast, flexible and agile solutions built to fit modern needs.

Posted May 04, 2020

To aid the transition to remote work, RapidFire Tools, a Kaseya company and provider of business-building IT technologies, is releasing the Network Detective Work from Home (WFH) solution.

Posted May 04, 2020

Nutanix, a provider of enterprise cloud computing solutions, and Wipro Limited, an information technology, consulting, and business process services company, are partnering to offer a database optimizing solution.

Posted May 04, 2020

The mainframe is continuing to grow in importance—so much so that the deployment frequency of new mainframe application features is set to surpass that of non-mainframe application features in 2020, according to a new global survey. "Given the increasingly crucial role the mainframe plays in innovation, continuously improving the quality, velocity, and efficiency of software development and delivery on the platform should no longer be a wishful IT aspiration—it's an urgent strategic imperative," said Chris O'Malley, CEO, Compuware.

Posted May 04, 2020

VAST Data, a storage company, is releasing Version 3 of its Universal Storage architecture, introducing more than 20 new features - including support for Windows and MacOS applications, cloud data replication, and native encryption. These latest Universal Storage updates allow enterprises to now marry all-flash performance with archive economics and scale to enable mission-critical and data-intensive enterprise production environments to consolidate their workflows and bring the power of flash storage and fast access to all of their data.

Posted May 01, 2020

MemSQL is now certified and available through Red Hat Marketplace, making it easier for developers to discover and access certified software for container-based environments, across all clouds and on-premises.

Posted May 01, 2020

Actian, a provider of hybrid cloud data warehousing and data integration, has introduced its Avalanche Real-Time Connected Data Warehouse Solution with support for AWS and Azure cloud platforms. The Actian hybrid solution offers integration capabilities natively built into the product, enabling enterprises to harness diverse data sources for use in high performance analytics.

Posted April 30, 2020

Alluxio, a developer of open source cloud data orchestration software, is creating a solution in collaboration with Intel that offers an in-memory acceleration layer with 2nd Gen Intel Xeon Scalable processors and Intel Optane persistent memory (PMem).

Posted April 30, 2020

Kong Inc., a cloud connectivity company, is releasing a new open source tool called Insomnia Designer, offering a collaborative API design editor. Building on Insomnia Core, which Kong acquired in 2019, the software works natively with Insomnia's testing capabilities to accelerate the development, performance and stability of REST and GraphQL services, the communications backbone of the modern applications and services people rely on each day.

Posted April 30, 2020

dotData, focused on delivering full-cycle data science automation and operationalization for the enterprise, is launchg dotData AI-FastStart, a new bundle of technology and services that includes a one year license to a fully-hosted version of dotData's autoML 2.0 platform, along with training and support.

Posted April 29, 2020

Franz, a provider of semantic graph database technology for knowledge graph solutions, has introduced AllegroGraph 7. With this release, the patented distributed knowledge graph solution adds innovations that address the fact that large enterprises have knowledge graphs that are so large that no amount of vertical scaling will work. "Large enterprises have knowledge graphs that are so big that no amount of vertical scaling will work," said Jans Aasman, CEO of Franz.

Posted April 29, 2020

LOGIQ, creator of LOGIQ Insights, is releasing LOGIQ Insights 1.2, enabling self-service observability on the Kubernetes platform along with many features built for Kubernetes environments and workloads.

Posted April 29, 2020

Sigma Computing, a provider of cloud-native analytics and business intelligence (A&BI), is extending the power of Sigma to be used throughout the cloud data analytics stack.

Posted April 28, 2020

John Murphy, senior vice president, products, EnterpriseDB recently reflected on the impact of COVID-19, including the shift in business practices and the renewed attention to what is really important. "The impact of the pandemic has enterprises laser-focused in three areas: the flexibility of their technology infrastructure; cost, obviously more than ever; and their people's talent," said Murphy.

Posted April 28, 2020

Verizon Media is unveiling  three new resources that developers and data teams can use to organize and better understand publicly available COVID-19 data. The resources include a dataset, API, and dashboard that help engineers analyze and navigate COVID-19 data.

Posted April 28, 2020

Fluree, a startup that provides a data-centric technology stack, is launching the Fluree Partner Network (FPN) providing enabling technology for ISVs, Sis, and VARs to build and deliver the Web3 applications. 

Posted April 28, 2020

NVIDIA has completed the acquisition of Mellanox Technologies, Ltd., enabling customers to achieve higher performance, greater utilization of computing resources, and lower operating costs.

Posted April 27, 2020

Flexential, a provider of data center colocation and hybrid IT solutions, is offering next-generation Managed Public Cloud and Managed Container Orchestration services to automate cloud infrastructure, application deployment, and increase speed to market. Flexential's Managed Public Cloud solution, for AWS and Microsoft's Azure cloud platforms, offers a white-glove turnkey service with ongoing 24x7 operational support of a company's public cloud environment, including management of the hyperscale cloud platform, services, and instances within.

Posted April 24, 2020

Imply has announced the release of a new version of its flagship product. Imply is a real-time analytics solution based on Apache Druid to store, query, and visualize event-driven data. Imply 3.3 takes advantage of new SQL JOIN support in Apache Druid 0.18, simplifying data pipelines and creating substantial savings by reducing storage costs, data ingestion costs and maintenance costs.  

Posted April 23, 2020

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126

Sponsors