COURSE DESCRIPTION
Data warehousing is considered a core component of business intelligence, as it facilitates reporting and data analysis. Learn about the practical applications of this technique in this course, which covers Relational Database systems’ genesis, characteristics, datawarehouse, and datamart architectures. Explore OLTP & OLAP, ETL, and data pipelines while studying recent market evolutions in the business intelligence software market. Time will also be devoted to proposing relevant data warehouse solutions and defining operational objectives for data analysis, all with the goal of improving concrete business objectives.
Prerequisite TOEIC score: 750
DESCRIPTION DU COURS
L’entreposage de données est considéré comme une composante essentielle de la veille économique, car il facilite le reporting et l’analyse des données. Découvrez les applications pratiques de cette technique dans ce cours, qui couvre la genèse des systèmes de bases de données relationnelles, les caractéristiques, les architectures de datawarehouse et de datamart. Explorez OLTP & OLAP, ETL et les pipelines de données tout en étudiant les évolutions récentes du marché du logiciel de business intelligence. Le temps sera également consacré à proposer des solutions pertinentes d’entrepôt de données et à définir des objectifs opérationnels pour l’analyse des données, le tout dans le but d’améliorer les objectifs commerciaux concrets.
Links to resources for presentations or summaries:
What is dynamic pricing? – Definition from WhatIs.com
Business Process Modeling Notation Mini-Learning Guide
Magic Quadrant for Business Intelligence and Analytics Platforms
Business intelligence and data warehouse trends: Appliances and “third-generation” BI (Part 1)
Business intelligence and data warehouse trends: The challenges of third-generation BI (Part 2)
Business Intelligence: Determining Your Data Integration Needs
Opening the Business Intelligence Software Stack
Environmental scanning as information seeking and organizational learning
What is enterprise mashup (or data mashup)? – Definition from WhatIs.com
Master Data Management | Data Integration Info
Adding a data virtualization layer to IT systems: Three questions to ask
What’s Changed: 2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms
MicroStrategy – Quick Guide – Tutorialspoint
MicroStrategy | Create Account
Business Analytics & Mobility Solutions
Don’t Laugh: Yahoo’s Open Source AI Has a Secret Weapon | WIRED
Databases
Which in-memory DBMS best fits your company’s needs?
Which relational DBMS is best for your company?
Redis open source DBMS overview
MySQL open source RDBMS overview
Evaluating the different types of DBMS products
Make the right choice between Hadoop clusters and a data warehouse
What is MySQL? – Definition from WhatIs.com
What is NoSQL (Not Only SQL database)? – Definition from WhatIs.com
Unstructured Data: InfoGraphics – Big Data News
What are primary, super, foreign and candidate keys in a DBMS?
A Practical Guide to Data Warehousing in Oracle, Part 2 — DatabaseJournal.com
Analytics
DBMS 2 : Database management and analytic technologies in a changing world
Guide to big data analytics tools, trends and best practices
What is recommendation engine? – Definition from WhatIs.com
Analytics, Data Mining, and Data Science
What is sensor analytics? – Definition from WhatIs.com
A Cheat Sheet on Probability – Data Science Central
Why I Will Never Have a Girlfriend | Tristan Miller
Big Analytics Roundup (February 8, 2016) | The Big Analytics Blog
Directed acyclic graph – Wikipedia, the free encyclopedia
Application programming interface – Wikipedia, the free encyclopedia
Real-time operating system – Wikipedia, the free encyclopedia
Organic data growth and gaining access to the data
How data virtualization tools work
Adding a data virtualization layer to IT systems: Three questions to ask
Course Features
- Lecture 0
- Quiz 0
- Duration 1 day
- Skill level All levels
- Language English / French
- Students 0
- Assessments Yes
