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

15 - 17 Dec, 2021  3 days

Follow Event

  

NGN 130,000

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

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. Dec 15 - 17 Dec, 2021
NGN 130,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

Related Courses

Fundamentals of Microsoft Excel (Basic MS Excel Training) (Virtual Training) Fundamentals of Microsoft Excel (Basic MS Excel Training) (Virtual Training)

2 day, 10 - 11 Dec, 2021 

2021-12-10 12:12:00 2021-12-10 12:12:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

This Basic Excel course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills ...

Power BI for Excel Users Training Power BI for Excel Users Training

3 days, 01 - 03 Dec, 2021 

2021-12-01 12:12:00 2021-12-01 12:12:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the ...

Managing Staff Grievances, Discipline and Disciplinary Procedure at Workplace Managing Staff Grievances, Discipline and Disciplinary Procedure at Workplace

2 day, 23 - 24 Sep, 2022 

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

McTimothy Associates Consulting LLC

Establishing a disciplined work environment, dealing with indiscipline effectively and setting up necessary policies and procedures to ensure that companies follow best practices and comply with ...

Employee On-Boarding: Induction and Job Orientation Techniques Employee On-Boarding: Induction and Job Orientation Techniques

2 day, 09 - 10 Dec, 2021 

2021-12-09 12:12:00 2021-12-09 12:12:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

The first few days for new employees can have a great impact on their entire employment tenure. The tone for their working experience is set very early on in their minds. Therefore, it is important ...