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 130,000

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.

Objectives:

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

Introduction

  • 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

Visualisations

  • ​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

Desktop

  • 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

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

Certified Training and Development Professional Certified Training and Development Professional

3 days, 26 - 28 Jul, 2022 

2022-07-26 12:07:00 2022-07-26 12:07:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Training and development professionals are under continuous pressure to offer exceptional training services. The demands of their job can only be fulfilled through an extensive knowledge of the main ...

Developing Purchasing Policies, Processes and SLAs Course Developing Purchasing Policies, Processes and SLAs Course

2 day, 23 - 24 Jun, 2022 

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

McTimothy Associates Consulting LLC

Purchasing policies, processes and Service Level Agreements (SLAs) guide the activities of purchasing professionals and their business partners, and provide a functional and moral compass. To ensure ...

Advanced Supervisory and People Management Skills Course Advanced Supervisory and People Management Skills Course

3 days, 05 - 07 Sep, 2022 

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

McTimothy Associates Consulting LLC

Building advanced supervisory skills is critical to helping you and your organization succeed in challenging economic times. This course is designed for helping experienced supervisors develop ...

Networking with Windows Server 2016 Course Networking with Windows Server 2016 Course

3 days, 27 - 29 Jul, 2022 

2022-07-27 12:07:00 2022-07-27 12:07:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

If you need to understand the fundamentals of networking, then the Networking with Windows Server 2016 training will help you achieve just that. You will learn about remote access technologies, IP ...