Effective Business Intelligence

Introductie

Effective Business Intelligence

Business intelligence (BI) stands for collecting data within your own organization. It can be described as the process of converting data into information, which should then lead to knowledge and prompt appropriate action. The aim of business intelligence is to create benefits and enable organizations to work smarter. It is considered a valuable core competency. In this Masterclass Effective Business Intelligence we discuss the various steps, methods and technologies that can be used to introduce Data Intelligence so that knowledge workers in an organization can successfully gain insights based on data. You will work on a practical case from different angles, and plenty of practical examples will also be discussed.

Onderwerpen

The following topics are covered in this professional and practice-oriented Masterclass: Introduction to BI

  • Introduction to the field and definitions
  • Case introduction
  • Self service reporting
  • Dashboarding
  • Inventory KPIs
  • Data models and metadata for BI

SQL in BI

  • Introducing SQL for BI
  • Select statement basic
  • Filter
  • Select
  • Calculated columns

Unlocking data

  • Keys and joins
  • Complex queries
  • Boolean Algebra
  • Generating insights with aggregation functions
  • KPIs and queries
  • Build simple dashboards
  • Demo query tools

Unlocking sources

  • Use external sources for new insights
  • Open Data Sets
  • APIs
  • File import
  • Data mappings and ETL
  • Meta data
  • Demo ETL and Mapping and tools

Data warehousing

  • Data warehouse
  • Datamarts
  • Dimensional data models
  • Drill Down and Rollup
  • Creating a dimensional data model
  • Deploy dimensional model

The next step

  • Statistics
  • Making predictions based on data
  • Developments in the field
  • Data science and data mining
  • NoSQL (OrientDB and MongoDB)

Doelgroep

  • Knowledge Workers
  • Information analysts
  • Decision makers
  • Data analysts
  • Data Scientists
  • Data engineers
  • BI professionals
  • Dates of owners and stewards

Praktisch

Duration Three-day training
Training methods
  • In company
  • Classroom at various training institutes
Additional material
  • Course slides
  • Website with interactive assignments
  • Coupon for access to publishing platform
Extra! Bring a laptop with PowerBI installed

Ik heb interesse in een in-company of klassikale training neem je contact met me op?