Join today

Course Template - Paid courses/Workshops

Write your awesome label here.

Microsoft Power BI

Date - 18th, 25th of Sep and 2nd of Oct
Time - 9AM to 5PM
Venue - Elegance, Queens Road

Program Outline

Module 01 - Introduction to Microsoft Power BI and its applications

  • Understanding the Difference between analysis and analytics.
  • Introduction to Power BI as an Analytical Platform software.
  • Understanding the difference between Microsoft Office Excel and Power BI in terms of Analytics.
  • Introduction to Power BI Licensing approaches and limitations
  • Introduction to the ways of accessing and working on
  • Power BI through Power BI Desktop, Power BI Portal, Power BI Mobile application and other ways of accessing Power BI

Module 02 – Introduction to Power BI Desktop application and itsfunctionalities

  • Introduction to the new Power BI User Interface and interface sections.
  • Understanding the essential settings for Power BI Desktop Files.
  • Introduction to the Power BI Query Editor and its usage.

Module 03 - Introduction to Data Sources and Connections when working with Power BI

  • Process in evaluating a data set for Analytics and Understanding the possible data sources Supported.
  • Process of Extracting, Loading and Transforming data on to Power BI Desktop Application.
  • Introduction to transforming data Power BI using the Query Editor.
  • Creating the Relationships between loaded data tables, Learning Relationship types and directions, Learning primary keys and building a relational data model.
  • Managing referential integrity, issues and exceptions.

Module 04 – Introduction to Data Fundamentals

  • Data type in Power BI Desktop Application
  • Introduction to Measures and quick measure In Power BI
  • Introduction to calculated columns in Power BI
  • Introduction to the fundamentals of DAX based data transformation and modelling techniques.
  • Introduction to Calculated tables and applications.

Module 05 – Introduction to developing dashboards in Power BI

  • Creating your first Power BI report and Understanding different types of Visualizations available in Power BI.
  • Introduction to Filtering and Cross filtering and working with selection pane.
  • Modern approaches and techniques to be used when designing and developing dashboards with Power BI.
  • Publishing reports from the Power BI desktop to Power BI web Portal and Introduction the features on Power BI web portal.
  • Introduction to report Sharing and the licensing limitations.
  • Accessing the shared Dashboard and reports from the mobile devices through the Power BI mobile application

What will you gain?

Participants will learn the tools, interfaces, when working with Microsoft Power BI and will be working on industry related business cases that will develop the essential skills on working with Microsoft Power BI Desktop application, Portal and the mobile application.

Who is it for?

Professionals who want to use Power BI to display effective reports and dashboards in order to communicate effectively to shareholders
Meet the instructor

Sumudu Sekarage

Sumudu Sekarage is an accomplished business leader with a strong background in strategic marketing, technology adoption, and corporate training. He holds an MSc in Strategic Marketing and a Bachelor's in Computer Science and Electronic Engineering. As Managing Director and CEO of Infoinvent Business and Learning Solutions and Director and Co-Founder of Hybrid Analytics, he leads the delivery of AI, machine learning and IoT solutions across the Asia Pacific. Known for his expertise in corporate strategy, talent development, and stakeholder engagement, Sumudu is passionate about using modern technologies to drive innovation and create meaningful societal impact
Patrick Jones - Course author

Investment

Pricing
SLASSCOM Members - 28,000 LKR*
Non Members - 35,000 LKR*

*VAT applicable

Organized by

Venue Partner