Nigerian Seminars and Trainings

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

business logo

Intermediate Power BI for Data Analysis Training

By: McTimothy Associates Consulting LLC  

Lagos State, Nigeria

16 - 18 Mar, 2022  3 days

Follow Event

  

NGN 130,000

Venue: The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos.

Other Dates

Venue Date Fee  
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 24 - 26 Aug, 2022 NGN130000
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 15 - 17 Dec, 2022 NGN130000

This course is intended as a continuation of our introductory-level courses in Power BI (Data analysis and visualization with Power BI). It covers common intermediate-level tasks and some of Power BI’s most desirable new features.

Prerequisites

Before attending this course, students should have: - General knowledge equivalent to what is covered in Data analysis and visualization with Power BI.

At Course Completion

After completing this course, students will be able to:

  • Import data from PDFs, regions of web pages, and collections of files
  • Characterize data with data profiling
  • Merge mismatched data sets with fuzzy matching
  • Generate custom columns in Power Query
  • Perform advanced data modelling
  • Use Power BI time intelligence
  • Work with custom scripts in R and Python
  • Create KPIs and scorecards
  • Use advanced report design techniques
  • Use advanced dashboard design techniques
  • Perform basic statistical analysis in Power BI

Course Outline

  • Intermediate Power Query
  • Importing from PDFs
  • Finding data in web pages
  • Getting tabular data
  • Getting data by providing an example
  • Importing the contents of a folder
  • Using fuzzy matching to combine disparate data sets
  • Creating custom columns in Power Query
  • Common math and string operations
  • M script
  • Columns by example

Intermediate Data Modelling

  • Adding What-If Parameters
  • Grouping and Binning
  • Using Time Intelligence
  • Generating DAX with Quick Measures

Script Visuals

  • Creating an R script visual
  • Installing an R environment
  • Creating a Python visual
  • Installing a Python environment

Advanced Report Design

  • Using report themes
  • Creating your own theme
  • Conditional formatting in tables and matrices
  • Using drill through in your reports
  • Adding data-driven images

Advanced Dashboard Design

  • Using dashboard themes
  • Using the KPI visual
  • Using the Multi KPI visual
  • Adding KPIs and trend analysis with DAX
  • Strategies for adding KPIs to tables and matrices
  • Importing from Excel data model
  • Conditional formatting
  • The DAX UNICHAR function
  • Image embedding

Analytics

  • Characterizing your data
  • Revisiting the data profiler
  • Getting help from custom visuals
  • Moving averages
  • ARIMA
  • Linear regression in R
  • Time series forecasting in Python
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos. Mar 16 - 18 Mar, 2022
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 24 - 26 Aug, 2022
The Professional Place:12B Olumoroti Street Gbagada Phase 11, Lagos Nigeria, Lagos State, Nigeria 15 - 17 Dec, 2022

Registration: 09:00:am - 04:00:am

NGN 130,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants

Related Courses

Selling and Marketing of Financial Services Course Selling and Marketing of Financial Services Course

2 day, 10 - 11 Feb, 2022 

2022-02-10 12:02:00 2022-02-10 12:02:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

With competition increasing every day and the mounting pressures that characterize tough economic times, you need proven marketing techniques to generate demand for your products and services. Banks, ...

Communication and Presentation Skills for Senior Professionals Course Communication and Presentation Skills for Senior Professionals Course

2 day, 04 - 05 Feb, 2022 

2022-02-04 12:02:00 2022-02-04 12:02:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

In this course, participants will understand the differences between communication styles and develop a Win-Win mind-setĀ to make them effective in any circumstance. Using the four pillars of ...

 Developing Leadership Excellence: Results Based Leadership (Classroom & Virtual Training) Developing Leadership Excellence: Results Based Leadership (Classroom & Virtual Training)

3 days, 23 - 25 Feb, 2022 

2022-02-23 12:02:00 2022-02-23 12:02:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

The aim of this course is to provide participants with the knowledge, skills and competencies required to become results-based leaders. Results based leaders are modern day, value-adding managers ...

Training on Total Quality Management (TQM): Tool Box for Continual Improvement Training on Total Quality Management (TQM): Tool Box for Continual Improvement

3 days, 12 - 14 Apr, 2022 

2022-04-12 12:04:00 2022-04-12 12:04:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

The course will provide participants with comprehensive knowledge on 'Quality’ history and evolution, as well as quality gurus and tools. Through various workshops and role-plays, the ...