The Short Way to Business Intelligence

This course will help the trainer to learn Business Intelligence from scratch. It starts first with explaining what Business Intelligence is?, The frame work of it, its main processes and phases. After that, it goes through the database phase, where the database concepts and terminologies get described. Also, learning database design concepts takes place in this phase. After that, the course goes through learning DML SQL Queries that help to extract and retrieve data from data stores to load them to the reporting and Business Intelligence tools. After that, the last phase explains how to use Microsoft Power BI platform to complete the rest of the Business Intelligence operations. This phase demonstrates how to clean and transform data, store procedures on data, integrate date from different resources, create data models, and create multiple types of automated reports and visualizations. it also shows how to publish reports and visualizations with the corporate and team using the secured Power BI platform.

Introduction 

• What is Business Intelligence?
• Installing Power BI Desktop
• What Microsoft Power BI?

Database design concepts

• Entities
• Attributes
• Records
• PKs
• FKs
• Cardinality/Relationships
• Conceptual design
• Logical design

Data extraction and retrieval

• Select statements
• Where statements
• Like statements
• Sorting data
• Aggregate statements
• Group by statements
• Join statements

BI processes and operations

• Connecting to multiple data sources
• Extraction, transformation and loading (ETL)
  • Data cleaning:
    • Dealing with null values
    • Dealing with data that has errors
    • Removing duplicates
  • Changing data type
  • Combining data VS Merging data
    • Options for combining data with append queries
    • Options for merging data using join concepts with merge queries
  • Renaming headers and datasets
  • Replacing values
  • Splitting columns options
  • Create query groups
  • Creating reference queries
  • Creating duplicate queries
  • Creating different data models
  • Adding conditional columns
  • Adding duplicate columns
  • Adding calculated columns
  • Defining data categories
  • Pivoting and Unpivoting columns
  • Applied steps tool capabilities
  • Tips and tricks for filtering data
  • Removing rows and columns
• Data Modelling
  • Star schema
  • Fact tables
  • Dimension tables
• Creating Reports and Visualizations
  • Exploring visualizations
  • Multi-level filtering
  • Visualizations interactivity features
  • Creating hierarchies
  • Exploring drill-down capabilities
• Sharing reports and visualizations