Take free online business intelligence courses to build your skills and advance your career. Learn business intelligence and other in-demand subjects with courses from top universities and institutions around the world.
About this Course
This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You'll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.
The course gives an overview of how business intelligence technologies can support decision making across any number of business sectors. These technologies have had a profound impact on corporate strategy, performance, and competitiveness and broadly encompass decision support systems, business intelligence systems, and visual analytics. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics.
About this Course
Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed in six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of a high volume of unstructured data (big data) with data mining and the Hadoop framework.
After completing this course, a learner will be able to
- Create a Star o Snowflake data model Diagram through the Multidimensional Design from analytical business requirements and OLTP system
- Create a physical database system
- Extract, Transform and Load data to a data warehouse.
- Program analytical queries with SQL using MySQL
- Predictive analysis with RapidMiner
- Load relational or unstructured data to Hortonworks HDFS
- Execute Map-Reduce jobs to query data on HDFS for analytical purposes
About this Course
'Megatrends' heavily influence today's organizations, industries and societies, and your ability to generate insights in this area are crucial to your organization's success into the future. This course will introduce you to analytical tools and skills you can use to understand, analyze and evaluate the challenges and opportunities 'megatrends' will inevitably bring to your organisation. Via structured learning activities you will explore how these trends can be addressed through sustainability-oriented innovation. You will be introduced to key data analytics concepts such as systems thinking, multi-level perspectives and multidisciplinary methods for envisioning futures and apply them to specific real-world challenges you and your organisation may face. And there'll be a focus on future-proofing skills such as teamwork, collaboration with diverse stakeholders and accounting for judgments made within ethical decision-making frameworks.
Harness Business Data. Build a fully-optimized business data warehouse in five courses.
About this Specialization
Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.
This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You'll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You'll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you'll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.