PDF Download

Course Information

Course Overview
Upon completing this course, you will be able to do Business Intelligence using Microsoft Power BI Software. The course starts with introduction about Business Intelligence and how it can be done using Microsoft Power BI Software. After that, it will be shown how to connect and deal with different data sources. Then the course will go through how to shape, integrate data and implement all the transformations required. Later, knowing how to do data modelling on different data sets will take a place. Finally, the course will elaborate on how to do the different interactive data visualizations and reports. The course will be hands-on practical based with a lot of real-life practical cases and examples. At the same time, it will share with you the tips and tricks of many years of research and experience.
Outline

Introduction:

  • What is Business Intelligence?
  • What is Microsoft Power BI?
  • Installing Microsoft Power BI Desktop

    • Data sources:

  • Data courses types and categories
  • How to handle different data sources
  • Connecting to multiple data sources such as:
    •          Flat Files:
             Databases:
             Other sourses

    Shaping and integrating data:

  • Direct Query
  • Updating data in Power BI
  • Extraction, Transformation and Loading (ETL)
  • Appending data
  • Merging data
  • Calculated columns
  • Creating measures
  • Data cleaning

    • Data Modeling:

  • Fact and dimension tables
  • Star schemas
  • How to implement cardinality
  • Dax functions
  • Setting data flows between datasets

    • Data Visualizations:

  • Exploring visualizations and reporting interface
  • Creating multiple visualizations and reports
  • Creating hierarchies
  • Drill down capabilities
  • Creating hierarchies
  • Applying interaction between reports and visualizations
  • Multi-level filtering

    • Summary and Conclusions

    Who should take this course?
    This course is important for:
  • Business owners & managers
  • Decision makers
  • Student looking for good job opportunities
  • Professional looking a better career path
  • Professional who want to learn how create automatics reporting and dashboarding systems
  • Data analysts
    • The course delivery method
    The course is available with the following modes:

  • Online live instructor-led mode:

    • The course will be delivered using ZOOM application. Participants are required to install ZOOM application to their computers.

  • Face to face instructor-led mode:

    • The course will be held in a training venue at reputable hotel or business center. The participants will be informed about the venue details after registration. Participants are required to bring their own computing devices.
    Duration
    One day, from 9 am - 5 pm , including refereshments and lunch break.
    Software requirements
    Participants are required to bring their own laptops with Microsoft Excel (2016 or higher) installed on them
    Course Prerequisites
    The participant is required to have knowledge in relational database concepts
    Big-Logo

    home_security2_pic10

    For more information call us

    +1 (613) 263-7822

    info@techknowledge.ca

    → Home

    → About us

    → Course

    → Services

    → Contact Us

    → Appointment

    Location

    Our scheduled trainings are held in Ottawa, Montreal, Toronto and Vancouver. at the same time, we are able to provide our services to the other cites in Canada based on request.

     


    Now Partner With