Course Code: sqltopbibspk
Duration: 8 hours
Overview:

___ is ___.

This instructor-led, live training (online or onsite) is aimed at beginner-level / intermediate-level / advanced-level ___ who wish to use ___ to ___.

By the end of this training, participants will be able to:

  • Install and configure ___.
  • ___. 
  • ___. 
  • ___. 

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Course Outline:

SQL Basics

  • Writing queries efficiently
  • Aggregations, filtering, and joins
  • Common mistakes when working with multiple tables
  • How to optimize SQL queries for Power BI

Power BI Overview

  • Interface walkthrough
  • Key functionalities & tools in Power BI

Loading Data into Power BI

  • Connecting Power BI to MySQL & Oracle
  • Filtering data while loading 
  • Handling large datasets efficiently

Data Modeling & Relationships

  • How to work with relationships between tables
  • Common mistakes in relationships
  • Handling many-to-many relationships
  • Creating calculated columns and measures
  • Handling values that are dates (dd/mm/yyyy) 

Visualizing Data

  • How to create visuals (reports) and dashboards
  • Time series visualizations
  • Slicers and interactivity in dashboards
  • Creating maps (even offline)
  • Best practices for designing visuals
  • Panel data visualizations

Collaboration & Publishing

  • Publishing dashboards
  • Sharing and collaborating on dashboards
  • Exporting and downloading data

Advanced Power BI Features

  • Technical feasibility of integrating Power BI with custom code
  • Creating interactive filters at the database level
  • Working with transactions & trade data