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: Business Intelligence, Cloud Computing | Tags: Cloud, Data Lake, Data Science, Data Warehouse, Snowflake
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, Business Intelligence, DataWorks Summit 2019 | Tags: Druid, Hive, Kafka, JDBC, LLAP, Release and features, Hadoop
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: EC2, Druid, Cloud, CNCF, Container Orchestration, Data Analytics, Helm, Metrics, OLAP, Operation, Prometheus, Kubernetes, Python
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, Business Intelligence, Tech Radar | Tags: Druid, Hive, Data Analytics, LLAP, OLAP, SQL
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: Business Intelligence, DataWorks Summit 2018 | Tags: Calcite, Druid, Hive, OLAP, Release and features, SQL
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, Hive, Network, Oracle
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: Business Intelligence, Learning | Tags: Hive, File Format, UDF, Hadoop, SQL
Recently, I’ve been ask to review a new book on Apache Hive called “Apache Hive Essentials How-to” written by Darren Lee and published by Packt Publishing. To say it short, I sincerely recommend it. I…
By David WORMS
Apr 23, 2013
Hadoop and R with RHadoop
Categories: Business Intelligence, Data Science | Tags: HDFS, MapReduce, Thrift, Data Analytics, Learning and tutorial, R, Hadoop, HBase
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