LMS

Applied Master Program

Power BI Masterclass with SQL

Embark on a journey with our Power BI Masterclass with SQL! This course is crafted for individuals eager to delve into data visualization and analysis. Learn the ins and outs of Power BI’s robust features alongside SQL’s database management prowess, all while engaging in hands-on, real-world scenarios. Ideal for skill enhancement or initiating a fresh venture in data intelligence, our expert-led tutorials are set to equip you with the proficiency needed to transform data into actionable insights. Dive in and unlock the potential of data mastery!

Register for free now →

Download Syllabus

Estimated Time

16 Weeks

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 Certificate in Business Intelligence Analytics, a program thoughtfully designed to equip students with an extensive understanding of essential business intelligence concepts, analytics techniques, and the indispensable tools used to drive data-driven decision-making within organizations. This certificate program serves as your pathway to gaining the knowledge and skills required to extract invaluable insights from data, ultimately generating actionable business intelligence.

Throughout this course, you will embark on a transformative educational journey, delving into the core principles of business intelligence. Whether you aspire to advance your career or are keen on enhancing your analytical capabilities, our program offers a comprehensive exploration of the world of business intelligence.

Join us as we unlock the potential of data-driven insights in decision-making, empowering you to make informed choices that can shape the future of organizations. Your Certificate in Business Intelligence Analytics is not just a testament to your expertise but also a key to becoming an invaluable asset in the ever-evolving landscape of data-driven decision-making. Welcome to a future where data becomes your strategic advantage.

Register free for now

What you will learn

Learn the fundamentals of data analysis, including descriptive statistics, data visualization, and SQL

Gain proficiency in using Excel for data analysis, including data manipulation, analysis, and visualization

Understand the different types of business metrics and how to calculate them

Use data analysis to answer business questions and make informed decisions

Create data visualizations that are clear, concise, and impactful

Build interactive dashboards to tell stories with data

Stay up-to-date on the latest trends in business intelligence and data analytics

Course Content

Module 1: Relational Databases and SQL for Data Analysis

Lesson 1

Introduction to Databases

  • Understanding the basic concepts of relational databases, including tables, records, and fields.

Lesson 2

Database Management Systems

  • Overview of DBMS, its role, and importance in managing data within an organization.

Lesson 3

Database Modeling Building Blocks

  • Introducing key components of database modeling, such as entities, attributes, relationships, and data types.

Lesson 4

Relational Database Development and ERD

  • Learning about normalization, entity-relationship diagrams, and designing efficient database schemas.

Lesson 5

Physical Database Development

  • Covering the steps involved in the physical creation of a database, including storage structures, file organization, and optimizing physical layout for performance.

Lesson 6

Basic SQL

  • Become fluent in basic SQL commands including SELECT, FROM, WHERE, and corresponding logical operators. Gain an overview of what you’ll be learning and doing in the course.

Lesson 7

SQL Joins

  • Combine data tables using SQL joins to answer more complex business questions.

Lesson 8

SQL Aggregations

  • Aggregate data in SQL including COUNT, SUM, MIN, and MAX.
  • Write CASE and DATE functions, as well as work with NULL values.

Lesson 9

Indexing and Performance Tuning

  • Learning about indexing strategies and how to optimize query performance.

Lesson 10

Stored Procedures and Triggers

  • Introduction to writing stored procedures and triggers for automated data processing.
Module 2: Data Visualization with Power BI

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 Microsoft Power BI

  • Overview of Power BI.
  • Power BI Working environment.
  • Building blocks of Power BI.
  • Installing Power BI Desktop.

Lesson 3

Prepare data for analysis with Power BI

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

Lesson 4

Clean, transform, and load data in Power BI

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

Lesson 5

Model data in Power BI

  • Power BI model fundamentals.
  • Work with tables.
  • Work with relationships and cardinality.

Lesson 6

Write DAX formulas for Power BI Desktop models

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

Lesson 7

Build Power BI visuals and reports

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

Lesson 8

Manage workspaces and datasets in Power BI

  • Distribute a report or dashboard.
  • Use a Power BI gateway to connect to on-premises data sources.
  • Configure row-level security.
Module 3: Final Project

Applying the acquired knowledge and skills to solve a real-world problem.

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.

Mr. Chandika Witharana

Lecturer @ APIBA

Lecturer in Software Engineering & Business Intelligence at the Faculty of Management Studies and Commerce University of Sri Jayewardenepura from 2014 – 2022. Chief Executive Officer & Founder at APIBA. Chief Executive Officer & Founder at Xenosys Software solutions.

Mr. Nilantha Prasad

Lecturer @ APIBA

A BSc degree holder in Business Information Systems is visiting the Institute of Chartered Accountants of Sri Lanka. They have previously worked as a lecturer at the Faculty of Management Studies and Commerce, University of Sri Jayewardenepura.

Course fee: LKR 22,000
2-month installment payment plan available

Course Schedule: 2024-02-13
At 8:30pm onward  

Register Now
Assessment

100% compulsory to pass the assessment at the end of the program

(Mark should be at least 50% or higher.)

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.

“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

Kickstart your learning experience with APIBA.

Register for free now

Why choose us?

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