Business Intelligence
Business Intelligence (BI) is a broad category of applications and technologies that capture, store, and analyze data. To make informed business decisions based on accurate and up-to-date information, intuition is not enough. Data analysis, reporting, and querying tools can help business users handle large amounts of data and extract valuable information.
BI applications include decision support, query and reporting systems, online analytical processing (OLAP), statistical analysis, forecasting, and data mining. Adaltas help you to leverage the tools and technologies at stake to extract the maximum value from your data.
BI planning
Defining and contributing to:
- Establish business requirements
- Plan and manage projects
- Select optimal online analytical processing (OLAP) tools
- Specify catalog and metadata strategy
Architecture & design
Involved and responsible for:
- Design dimensional data models and data marts
- Ensure compliance with security and governance policies
- Design data processing, cleaning, structuring and mining algorithms
- Design, secure and deploy platforms
Deployment & Optimization
Works together with the application developers:
- Implement analytical processing
- Implement KPIs, build reporting and statistical analysis systems
- Manage scalability and querying at scale
- Pre-aggregation data for deeper analysis
Articles related to Business Intelligence
Snowflake, the Data Warehouse for the Cloud, introduction and tutorial
Categories: Cloud Computing, Business Intelligence | Tags: Data Science, Cloud, Snowflake, Data Warehouse, Data Lake
Snowflake is a SaaS-based data-warehousing platform that centralizes, in the cloud, the storage and processing of structured and semi-structured data. The increasing generation of data produced over…
Apr 7, 2020
Running Apache Hive 3, new features and tips and tricks
Categories: Big Data, DataWorks Summit 2019, Business Intelligence | Tags: Hadoop, LLAP, Release and features, JDBC, Hive, Druid, Kafka
Apache Hive 3 brings a bunch of new and nice features to the data warehouse. Unfortunately, like many major FOSS releases, it comes with a few bugs and not much documentation. It is available since…
Jul 25, 2019
Auto-scaling Druid with Kubernetes
Categories: Big Data, Business Intelligence, Containers Orchestration | Tags: Metrics, Helm, Kubernetes, Cloud, Python, Operation, EC2, OLAP, CNCF, Data Analytics, Container Orchestration, Prometheus, Druid
Apache Druid is an open-source analytics data store which could leverage the auto-scaling abilities of Kubernetes due to its distributed nature and its reliance on memory. I was inspired by the talk…
Jul 16, 2019
Druid and Hive integration
Categories: Big Data, Tech Radar, Business Intelligence | Tags: LLAP, OLAP, SQL, Hive, Data Analytics, Druid
This article covers the integration between Hive Interactive (LDAP) and Druid. One can see it as a complement of the Ultra-fast OLAP Analytics with Apache Hive and Druid article. Tools description…
Jun 17, 2019
Accelerating query processing with materialized views in Apache Hive
Categories: DataWorks Summit 2018, Business Intelligence | Tags: Calcite, Release and features, OLAP, SQL, Hive, Druid
The new materialized view feature is coming in Apache Hive 3.0. Jesus Camacho Rodriguez from Hortonworks held a talk ”Accelerating query processing with materialized views in Apache Hive” about it…
May 31, 2018
Oracle to Apache Hive with the Oracle SQL Connector
Categories: Business Intelligence | Tags: HDFS, Oracle, Network, Hive
In a previous article published last week, I introduced the choices available to connect Oracle and Hadoop. In a follow up article, I covered the Oracle SQL Connector, its installation and integration…
By David WORMS
May 27, 2013
Apache Hive Essentials How-to by Darren Lee
Categories: Learning, Business Intelligence | Tags: Hadoop, File Format, SQL, Hive, UDF
Recently, I’ve been ask to review a new book on Apache Hive called “Apache Hive Essentials How-to” (edit: the second edition is now available) written by Darren Lee and published by Packt Publishing…
By David WORMS
Apr 23, 2013
Hadoop and R with RHadoop
Categories: Data Science, Business Intelligence | Tags: Learning and tutorial, R, Hadoop, HBase, MapReduce, HDFS, Thrift, Data Analytics
RHadoop is a bridge between R, a language and environment to statistically explore data sets, and Hadoop, a framework that allows for the distributed processing of large data sets across clusters of…
By David WORMS
Jul 19, 2012