LMS

Skill-up Program

Applied Business Intelligence with Microsoft PowerBI for Professionals

The Data Analysis & Visualization with Microsoft Power BI course is designed to provide participants with a comprehensive understanding of data analysis and visualization techniques using the powerful tool, Microsoft Power BI. Through a combination of theory, practical exercises, and hands-on projects, this course aims to equip learners with the skills to explore, analyze, and present data effectively using Power BI.

Register Now →

Download Syllabus

Estimated Time

10 Weeks

Total duration: 20 Direct contact hours

Prerequisites

No need any prior Knowledge or Experience to complete this course

Why choose us?

– High-quality content
– Hands-on projects
– Weekly assessments
– Certificate on completion

Introduction

Welcome to the Data Analysis & Visualization with Microsoft Power BI course, your gateway to mastering the art of data analysis and visualization with the formidable tool, Microsoft Power BI. Our program offers a holistic approach, blending theory, hands-on exercises, and real-world projects to empower you with the skills needed to unlock insights, dissect data, and create compelling visualizations using Power BI.

Dive into the world of data analysis and visualization with our Data Analysis & Visualization with Microsoft Power BI course. This course combines comprehensive theory, practical exercises, and immersive projects to provide you with the expertise required to harness the full potential of Microsoft Power BI in exploring, analyzing, and presenting data.

 

Enroll in the Data Analysis & Visualization with Microsoft Power BI course and embark on a transformative learning journey. Through a rich blend of theory and hands-on experience, this course equips participants with the capabilities to navigate data intricacies and craft compelling visual narratives using the powerful Microsoft Power BI tool. Get ready to turn raw data into actionable insights with confidence.

 

Register Now →

What you will learn

Master data prep and modeling using Power BI.

Create compelling visuals with Power BI.

Design interactive, user-friendly reports.

Dive into advanced data analysis.

Apply skills to real-world projects.

Course Content

Moule 1 Introduction to Microsoft PowerBI.

Lesson 1

Get Started With Data Analytics

  • • Overview of data analysis
    • Roles in data
    • Tasks of a data analyst

Lesson 2

Get Started Building With PowerBI

  • • Overview of PowerBI
  • • PowerBI Working environment
  • • Building blocks of PowerBI
  • • Installing PowerBI Desktop

Module 2 Prepare data for analysis with Microsoft PowerBI.

Lesson 1
Prepare data for analysis with PowerBI

  • • Data source types
    • Connecting to data sources
    • Get data from files/ relational data sources/ online services

Lesson 2
Clean, transform, and load data in PowerBI

  • • Shape the initial data
    • data structure
    • Evaluate and change column data types
    • Combine multiple tables

Module 4 Build Microsoft PowerBI Dashboard Visuals and Reporting.

Lesson 1
Build PowerBI visuals and reports.

  • • Explore report designs.
  • • Design the analytical report layout.
  • • Design reports with advanced filtering techniques

Lesson 2
Manage workspaces and datasets in PowerBI

  • • Distribute a report or dashboard.
    • Use a PowerBI gateway to connect to on-premises data sources.
    • Configure row-level security

Module 3 Data Modeling using Microsoft PowerBI.

Lesson 1
Model data in PowerBI.

  • • PowerBI model fundamentals
    • Work with tables
    • Work with relationships and cardinality

Lesson 2
Write DAX formulas for PowerBI Desktop models.

  • • Write DAX formulas.
    • DAX data types
    • Work with DAX functions
    • Enforce PowerBI model security

Module 5 : Final Project

Our Lecturers

Mr. Udara Alagalla

Lecturer @ APIBA

BSc degree holder specializing in Business Information Systems.  A visiting lecturer in a reputed institute for CA in Sri Lanka. Has worked Faculty of Management Studies and Commerce, University of Sri Jayewardenepura.

Regular Course Fees : LKR. 21,599

R: LKR. 25,000

Early bird offer valid until 2023 November 11

Register Now

Early Bird Offer Over Due

Regular Course Fee: LKR. 25,000

 

Register Now
Assessment
100% compulsory to pass the assessment at the end of the program (50% or above)
Student Support
Learning Management Systems (LMS) or Contact Coordinator of the course

Get Hands On Experience With Our Industry Partners

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Kickstart your learning experience with APIBA.

Register for free now

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst

“I’m extremely glad I signed up for the program. I definitely got what I wanted from the program and strongly recommend it.”

Javier R. Olaechea Financial Data Analyst