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, combine 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
    This course be delivered in face to face mode
    Course venue
    The course be Held in the venue at:
    1910 St. Laurent Blvd, Ottawa, ON K1G 1A4
    Duration & times
    The course is includes 8 hours training (face to face):
    9 Mar 2023, Thu 5:15pm - 7:30pm
    15 Mar 2023, Wed 3:00pm - 5:15pm
    16 Mar 2023, Thu 5:15pm - 7:30pm
    20 Mar 2023, Mon 1:45pm - 4:00pm
    Requirements
    Participants are required to bring their own laptops, with having Microsoft Excel (2016 or higher) installed on them.
    Special Offer
    With the %50 OFF, the course is discounted from $1400 to $699


    For more information call us


    +1 (613) 263-7822

    info@techknowledge.ca