Nigerian Seminars and Trainings

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

business logo

Data Analysis and Visualization with Power BI Course

By: McTimothy Associates Consulting LLC  

Lagos State, Nigeria

21 - 23 Sep, 2022  3 days

Follow Event


NGN 170,000

Get 10.00% off

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

Data is the new crude oil and the success of business in the 21st century is heavily reliant on the ability to mine and use consumers’ data, financial data and internal operations data to drive business decisions.

Our instructor-led Power BI training helps teams adopt Power BI for self-service business intelligence and analytics. Through this practical-based approach with hands-on labs and in- person guidance, attendees will be able to build and share stunning visualizations and valuable data insights quickly and easily with Power BI. This expertly designed framework will leave attendees with the knowledge they need to take full advantage of Power BI capabilities and set them up for success with the tool.

The question is, where do you start? During this three-days training, we’ll walk you through the necessary steps: we’ll import data with queries, create a data model with the necessary relationships and calculations, build an interactive report and publish it. Lastly, we’ll make a dashboard which you can share with your colleagues.


After completing this training, you will be able to:

  • Describe key concepts in business intelligence
  • Describe key concepts in data analysis
  • Describe key concepts in data visualization
  • Describe the rationale for self-service BI
  • Describe considerations for self-service BI
  • Import data via queries
  • Create a dashboard
  • Use queries to transform data into usable, meaningful tables
  • Create a data model with relationships, custom sorting, a date dimension table, etc
  • Use Excel as a Power BI data source
  • Use databases as a Power BI data source and describe the R language
  • Create Power BI Desktop queries
  • Shape data and Combine data
  • Set up interactions between charts
  • Write simple DAX queries
  • Create calculations and measures
  • Use Power BI Desktop to create interactive data visualizations

Target Audience

The Microsoft Power BI Training is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. It is best suited for: Business Analysts, financial analyst, Business Intelligence Manager, economists, Statisticians and Analysts, Data Scientists and Project Managers

Course Outline


  • A history of Business Intelligence
  • The development of Self Service
  • Business Intelligence
  • Introducing Power BI
  • How does Power BI fit in?
  • Introducing the three main tools – Power BI Service, Power BI desktop and Power BI Mobile
  • When to use Power BI Desktop
  • Free versus Pro Signing up to the Power BI online service
  • Which sources of Data can I use in Power BI Desktop?

Power BI Desktop

  • The BI Process
  • Data Source and loading
  • Introduction to the data source used in this course
  • Creating Tables of Data
  • Import data from Excel
  • Import data from Web
  • Renaming Queries
  • Grouping Queries
  • Including and Excluding Queries in report refresh
  • Enabling or disabling Query loading
  • Applying Queries
  • Viewing Query dependencies
  • Append Queries
  • Merge Queries
  • Merge Query Types
  • Cleaning the resulting query

Using Data from an Excel Workbook

  • Understanding your data
  • Importing data from an Excel worksheet
  • Excel Tables
  • Importing table data from the Excel file
  • Saving in Power BI Desktop


  • ​Working with Formats and Visualisations
  • From Visualizations to Reports
  • Text B Text boxes Shapes
  • Working with Filters
  • ​Working with Desktops Files
  • Q and A
  • Making Visualizations with natural language queries
  • Enabling Q and A in Power BI Desktop
  • Create a Visual using Q and A
  • Add categories to the Q and A expression
  • Add conditions to Q and A
  • Add grouping to the Q and A
  • Specify a visual type

Refreshing your Data

  • Power Query (Query Editor)
  • Using Custom Visuals​
  • Synchronise Slicers
  • Report Themes
  • Data Model and Transformation
  • Date Transformations
  • Power Query UI
  • Data Modelling​
  • Column Transformations
  • DAX
  • Functions
  • Time   Intelligence Functions
  • Power BI Templates and Parameters
  • Connect   Excel   and Power BI


  • Extra Processes
  • Dynamic Web Queries Using Parameters​

NB: All exercises and project files used on the course will be available for class use and take home.

The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos. Sep 21 - 23 Sep, 2022
NGN 170,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

 International Public Sector Accounting Standards (IPSAS) Course International Public Sector Accounting Standards (IPSAS) Course

2 day, 22 - 23 Nov, 2022 

2022-11-22 12:11:00 2022-11-22 12:11:00
Rivers State, Nigeria

McTimothy Associates Consulting LLC

In a world of increasing transparency, there is a growing pressure being placed upon the public sector to standardize financial accounting. Standards adopted are the basis for the ‘new ...

Customer Handling Skills for Call-centre Representatives ( Virtual Training) Customer Handling Skills for Call-centre Representatives ( Virtual Training)

2 day, 04 - 05 Nov, 2022 

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

McTimothy Associates Consulting LLC

Whether we choose to embrace them or cannot stand being interrupted by their calls, call centres are a business element that is here to stay. This call centre training course will help call centre ...

Effective Crisis Management Course Effective Crisis Management Course

3 days, 17 - 19 Oct, 2022 

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

McTimothy Associates Consulting LLC

This course provides participants with concrete crisis management solutions and strategies, while giving insight into the delivery of effective Crisis Command, Control, Communications and ...

Internet Marketing and Social Media Marketing Masterclass Internet Marketing and Social Media Marketing Masterclass

2 day, 13 - 14 Oct, 2022 

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

McTimothy Associates Consulting LLC

In simplistic terms, “digital marketing is the promotion of products or brands via one or more forms of electronic media. Digital marketing differs from traditional marketing in that it ...