Reporting and Analytics
with Power BI Desktop
funding-schemes sbl-khas-black-centered
Connect to hundreds of data sources,
simplify data prep, and drive ad hoc analysis


Get in Touch With Us
Reporting and
Analytics with
Power BI Desktop
Connect to hundreds of data
sources, simplify data prep,
and drive ad hoc analysis
funding-schemes-sbl-khas-white-centered
Get in Touch With Us

Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
This course will introduce all the Power BI technologies including: Power Query, DAX, Data Modelling (Power Pivot), M. We will go through a methodology for automating all your reporting needs and how to create beautiful reports and dashboards giving you a 360-degree view of your business.
Participants will use Microsoft’s free Power BI Desktop Application which hosts all Power Bi Technologies to build a detailed reporting model from scratch. They then publish this report to the powerbi.com service to share insights with everyone.

Duration

6 days / 48 hours

Level

Beginner to Intermediate

Delivery

100% Online - Instructor Led
Request For Information

    Key Features

    • 48 hours of instructor led training
    • Fully Online
    • Class recording available
    • Interactive Learning
    • Additional Coaching Session
    • 100% HRDF SBL-KHAS & MDEC MyWiT Claimable!

    Pre-Requisites

    • Basic Data Analytics Knowledge
    • Analytical Mindset
    • Willingness to self learn online
    • No prior experience is required
    • We will start from the very basics
    • Committed to complete all tasks

    Who Should Join

    • Professional switching careers
    • Business Analysts
    • Data Analysts
    • Students
    • New Programmers
    • Anyone interested in Power BI
    Key Learning Outcomes
    Upon completion, participants should be able to demonstrate each of the following outcome:-
    • Recall the Power BI Technologies and ecosystem
    • Use a framework for building a Data Model
    • Assess various data visualisation options in Power BI Desktop
    • Make sense of the DAX formula Language
    • Produce typical business reports using DAX formulas you will build on a Power BI Data Model
    • Incorporate budget data to your reporting Building budget variable analysis reports
    • Produce a complete reporting solution from scratch in a full Day Case Study Session
    Course Modules Covered in the Reporting and Analytics with Power BI Desktop program
    Module 1 - Overview of Power BI Desktop

    Overview of Power BI Desktop

    1. Intro to the Power BI Desktop interface
    2. Review of Power BI Desktop visuals
    3. Choong the right visual
    4. Building your first report
    Module 2 - Framework for Building a Data Model

    Framework for Building a Data Model

    1. What is a Data Model
    2. Big picture view of your reporting needs
    3. Reviewing Step-by-step Methodology
    4. How to create relationship
    5. Secrets for optimizing your report model
    6. The importance of implementing a plan on paper first Draft your first Power BI Data Model Build Plan.
    7. Building a Data Model in Power BI Desktop
    8. Implementing your Data Model Build Plan
    9. Loading data into Power BI Desktop
    10. How to create relationships
    11. Review of Facts, dimensions and Relationships
    12. Use of implicit DAX measures
    13. Build reports in Power BI (Simple Visualizations using Implicit Measures)
    Module 3 - Review of the DAX Formula Language

    Review of the DAX Formula Language

    1. Why is DAX so great for Analysts
    2. How DAX Works, the Vertipaq Engine
    3. The 3 Core DAX Measures
    4. DAX functions vs Excel Functions
    5. Introduction to CALCULATE - Why it is the most important DAX Function
    6. Overview of the Filter Context
    Module 4 - Time Intelligence Calculation in DAX

    Time Intelligence Calculation in DAX

    1. Examples The concept of a calendar
    2. Year to Date (YTD)
    3. Same Period Last Year (SPLY)
    4. Same Period Last Month (SPLM)
    Module 5 - Variance Calculations in DAX

    Variance Calculations in DAX

    1. Year on Year Variance in ₦ (YoY)
    2. Year on Year Variance %age (YoY)
    3. Month on Month Variance ₦ (MoM)
    4. Month on Month Variance %ag (MoM)
    5. Other variance calculations
    Module 6 - Utilizing Quick Measures

    Utilizing Quick Measures

    1. Using Quick Measures
    2. Interpreting Quick Measures
    3. Modifying Quick Measures
    Module 7 - Comparisons to Budget

    Highlights of the Standard Library

    1. Incorporate budget data in the Data Model Compare budget to Actuals
    Module 8 - Power BI Standard & Custom Visualizations

    Power BI Standard & Custom Visualisations

    1. Building Standard Visualisations
    2. Techniques for deciding on a Visual
    3. Introduction to Custom Visualisations
    4. Formatting Visuals
    5. Comparative Analysis
    Module 9 - Introduction to Power Query

    Introduction to Power Query

    1. Review of the Power Query interface
    2. Clean-up Exercise using Power Query
    3. Appending Data from a Folder
    4. Using “M” code to correct errors in Data
    Module 10 - Practice - Case Study Application

    Practice - Case Study Application

    1. Reviewing your Case Studies
    2. Drawing up your Data Model paper Plans
    3. Transforming your Data with Power Query
    4. Building your Data Model
    5. Incorporating simple DAX Formulas to your Data
    6. Incorporating Quick Measures to your Reports
    7. Connecting budget information into your model
    8. Carrying our Variance Reporting and Analytics
    9. Building a Dashboard
    Module 11 - Overview of Advanced Features in Power BI

    Overview of Advanced Features in Power BI

    1. Inserting Bookmarks
    2. Inserting Buttons
    3. Using Q&A
    4. Telling a Story with the Scatterplot visual Using Quick measure
    Module 12 - Publishing to PowerBI.com

    Publishing to PowerBI.com

    1. Publishing to PowerBI.com
    2. Personal vs On-Prem Gateway for data refresh
    3. Creating a Dashboard from your reports
    4. Creating Groups, Content Packs and other collaboration tools
    Our Training Methodology

    Practical Assignments

    We provide hands-on assignments that requires practical implementation.

    Virtual Coaching Sessions

    Online coaching sessions that happen over the phone, via video, or on a web platform.

    1 Year Access to LMS

    Get access to learning resources upto 1 year of class completion.

    Live Project Experience

    Hands-on learning and training gives participants the opportunity to experience real world situations.

    Online Assessments

    Participants can assess reflect on their own learning and their level/skills.

    Free Industry Webinars

    Stay current on market research trends, learn best practices through our webinar sessions.
    Program Key Highlights
    online-learning-2
    48 hours of Remote Online Learning
    learning-hours
    Additional Coaching Hours
    hands-on
    Live Hands-on Projects
    certification
    Certified by International Body
    mentor
    Mentorship with Industry Experts
    industry
    Designed for Beginners & Professionals
    Request For Information

      Get in Touch With Us Today!

      This training program is suitable for anyone who intends to enter into the field of Analytics. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
      Program Fee

      MYR 6800 per pax.
      Funding price MYR 3700 per pax .
      funding-schemes-sbl-khas-white-centered
      Funding Schemes for Companies who are claiming from their HRDF levy or from the MDEC MyWiT scheme.

      Limited scholarships available for early self applying individual applicants.

      Find out how you can qualify for a scholarship.

      Enquire NOW on the various funding options available.

      One-time fee. One year access to course materials and resources.
       
      hrdf-tp01
       
       
      Thulija Academy is a HRDF registered training provider. Our panel of expert trainers provide technology training for some of the biggest organizations in Asia.

       
       
       



      READY TO KICKSTART YOUR CAREER?
      Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at info@thulija.com or +60123661502
      Contact us on Whatsapp for more enquiries