Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Data Analytics with Power BI Online Training Course (Da-100)

By: QQtave Training

Lagos State, Nigeria

26 Sep - 01 Oct, 2021  6 days

Follow Event

  

NGN 200,000

Venue: Online

Module 1: Get Started with Microsoft Data Analytics

This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.

Lessons

  • Data Analytics and Microsoft
  • Getting Started with Power BI

Module 2: Prepare Data in Power BI

This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity and data storage, and understand the difference and performance implications of connecting directly to data vs. importing it.

Lessons

  • Get data from various data sources
  • Optimise performance
  • Resolve data errors

Module 3: Clean, Transform, and Load Data in Power BI

This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.

Lessons

  • Data shaping
  • Enhance the data structure
  • Data Profiling

Module 4: Design a Data Model in Power BI

This module teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modelling issues, including relationships, security, and performance.

Lessons

  • Introduction to data modelling
  • Working with tables
  • Dimensions and Hierarchies

Module 5: Create Measures using DAX in Power BI

This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.

Lessons

  • Introduction to DAX
  • DAX context
  • Advanced DAX

Module 6: Optimise Model Performance

In this module you are introduced to steps, processes, concepts, and data modelling best practises necessary to optimise a data model for enterprise-level performance.

Lessons

  • Optimze the model for performance
  • Optimise DirectQuery Models
  • Create and manage Aggregations

Module 7: Create Reports

This module introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality. The important topic of designing for accessibility is also covered.

Lessons

  • Design a report
  • Enhance the report
Online Sep 26 - 01 Oct, 2021
NGN 200,000.00
(Convert Currency)

Joel 08094785758