Data Analyst – PowerBI

Our courses are designed to be hands-on and instructor-led, providing you with real-world skills from day one. Led by senior industry experts, each session combines clear explanations with practical exercises, ensuring you not only understand the concepts but know how to apply them. All learners receive structured materials, coding challenges, and personalized feedback to accelerate their growth and confidence.

Register Now

Course Details

  • 🕒 Schedule: Twice a week, evenings only

  • ⏱️ Duration: 45 hours over 9 weeks

  • 💶 Price: €300

  • 👨‍🏫 Format: Instructor-led, hands-on training

  • 📦 Includes: Practical exercises, course materials, and expert feedback

Course Requirements

  • 📈 Level: Intermediate

  • 🧠 Prerequisites: Basic knowledge of Microsoft Excel is required

  • 👨‍🎓 Recommended for: Students or professionals with prior experience in data entry and spreadsheets.

About the 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.

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

 

Outcomes

Completed a Power BI certification course at Tirana Center of Technology. Built interactive dashboards from raw datasets, applied DAX to create KPIs and measures, and published reports to the Power BI service for stakeholder access.

 

Prepare for a career as a Data Analist

    • Excel – formulas, pivot tables, VLOOKUP

    • SQL – data extraction and manipulation

    • Power BI or Tableau – dashboards and data visualization

    • Python (optional) – for deeper data analysis (Pandas, NumPy)

Jeni gati të filloni?

Get in touch, or create an account

Kontakt