loader image

Data visualization with PowerBI

About this course

This course is based on Microsoft learning materials, sample data and over all documentation. It is taught hands on through practical examples.  Students will learn how to
connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide visuals of the data. All of this can be shared with other PowerBI users within the organization. Microsoft Power BI is used to find insights within an organization’s data.

Audience profile

Microsoft Power BI is a business intelligence (BI) platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI’s user interface is fairly intuitive for users familiar with Excel, and its deep integration with other Microsoft products makes it a versatile self-service tool that requires little upfront training.

Primary, this course is designed for individuals with working experience in Microsoft Excel. Knowing SQL is a bonus to get the most out of this course. Target audience for this course is: Database Developers, Database Administrators and BI professionals, finance specialists, statistics specialists etc. Furthermore finance and economics professionals find this course essential nowadays where technology and finance are coming closer by day in the Fin-Tech industry.

Price

300 Euro / 30.000 ALL

At course completion

After completing this course, students will be able to:

  • Understand fundamental data visualization concepts.
  • Use different data sources to create reports.
  • Create data model based on business requirements.
  • Use the DAX language to calculate and process data.
  • Create dashboards with different chart types.
  • Visualize data and data storytelling.

Getting Started

  • What is power BI?
  • Installing Power BI
  • Introduction to the course project.

Connect and transform data

  • Data connection: learn the types of data connectors and best practices.
  • Basic table transformations
  • Introduction to M language.
  • Text-specific, number-specific, and date-specific tools
  • Index and conditional columns
  • Merging & appending queries

Create a data model

  • Schema types (e.g., Star and Snowflake)
  • Creating table relationships
  • Relationship cardinality
  • Managing and editing relationships
  • Active vs. inactive relationships
  • Connecting multiple data tables

Add calculated fields with DAX

  • What DAX is and its best practices
  • Calculated columns
  • Measures
  • Filter context examples
  • Step-by-step measure calculation
  • DAX syntax and operators
  • Common DAX function categories

Visualize data & Data Storytelling

  • Adding simple objects
  • Inserting basic to advanced charts and visuals
  • Importing Custom Visuals
  • Formatting options
  • Report filtering options
  • Editing report interactions
  • Drillthrough filters
  • Report bookmarks
  • Managing and viewing roles (RLS)
  • Parameters
  • Learn how to: QA Test, Measures Test, Graphics Test
  • Making or report app meeting all the best practices of UI/UX
  • Chart Selection, the white charts for different requirements.

A more in depth on DAX – The DAX engines

  • Scalar functions
  • Table & Filter functions
  • Calculated Table Joins
  • Relationship functions
  • Advanced Time Intelligence
  • Practice Dax
  • Learn how to: QA Test, Measures Test, Graphics Test

Building the course project

  • Getting started with the final project
  • 1-9 labs step by step practicing everything we learned
  • Learn how to: QA Test, Measures Test, Graphics Test
  • Making or report app meeting all the best practices of UI/UX

Microsoft Excel is a must. Database knowledge is bonus.

The length of this course is 45 hours.
This course is held in the evenings twice a week from 2.5 hours each session. Course is taught in Albanian or English language. All training materials are distributed online.
At the end of course you can book the online exam and take the exam at our training center.

Contact Us

× Chat 09:00 - 21:00