Enrollment Form

Power BI Boot Camp Registration

POWER BI BOOTCAMP 5.0

“In God we trust, all others must bring data”.

​The famous quote by W. Edwards Deming has never been more true than it does in todays world.

​Far gone are the days business decision makers take critical decisions based on haunches, intuition and gut feelings.

​These days, everyone has come to realise that better and more accurate decisions can be made when data is put into good use. And there is data everywhere. The problem is, there is a shortage in the number of people who can put it into good use.

Power BI Bootcamp Training By Foresight BI & Analytics

​The Power BI Bootcamp is a weekend based program designed to arm participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to go from data to insights. ​This Power BI program is a valuable investment for you or your team.

​Participants will learn amongst others:

  • Simple methods to derive insights from their data
  • Automate all reports
  • Make reports available to stakeholders round the clock, on PC and Mobile

WHY SHOULD YOU ATTEND?

HIGH QUALITY COURSE CONTENT

The course is packed with outlines that will immediately improve the participants Data skills. From learning simple tricks that save up to 80% of time to knowing the best methods for creating data presentations with charts.

POWER BI CERTIFICATION PREP MATERIALS

Participants will be given access to the Official Microsoft Manual (digital) and Online Labs, which are the best materials to prepare for the Power BI Certification Exams.

The Labs include interesting modules such as Direct Connectivity to a database, Development with Power BI and Power BI Mobile. Labs will be available for 6 months.

HIGHLY EXPERIENCED TRAINER & POST TRAINING SUPPORT

The course will be facilitated by a Microsoft Certified Trainer with huge classroom and real life consulting experience.

Participants also get expert post training support for life on Power BI issues.

OTHER REASONS TO ATTEND

  • Official Microsoft Certificate of Achievement
  • Networking with other participants
  • Enhanced learning with group activities
  • Tea and Lunch Break Served

WHY SHOULD YOU ATTEND?

HIGH QUALITY COURSE CONTENT

The course is packed with outlines that will immediately improve the participants Data skills. From learning simple tricks that save up to 80% of time to knowing the best methods for creating data presentations with charts.

POWER BI CERTIFICATION PREP MATERIALS

Participants will be given access to the Official Microsoft Manual (digital) and Online Labs, which are the best materials to prepare for the Power BI Certification Exams.

The Labs include interesting modules such as Direct Connectivity to a database, Development with Power BI and Power BI Mobile. Labs will be available for 6 months.

HIGHLY EXPERIENCED TRAINER & POST TRAINING SUPPORT

The course will be facilitated by a Microsoft Certified Trainer with huge classroom and real life consulting experience.

Participants also get expert post training support for life on Power BI issues.

OTHER REASONS TO ATTEND

  • Official Microsoft Certificate of Achievement
  • Networking with other participants
  • Enhanced learning with group activities
  • Tea and Lunch Break Served

ABOUT THE COURSES & FEES

This is a 6 days course, covering the essentials of Power BI and using your data to build Analytics solutions.

POWER BI

​Power BI is a revolutionary Microsoft Tool for Business Intelligence, Data Analytics and Data Visualization.

​It is excellent for:

  • Connecting to various data sources (including Facebook and the local Folders on PC)
  • Cleaning and manipulating data (if you collect data from many people, then you can relate)
  • Analyzing data to deliver actionable insights
  • Presenting reports & dashboards with stunning visuals
  • Automating every single one of the bullets listed above.

LEARNING OUTCOME

At the end of this course, participants would have learnt how to:

  • Build efficient Power BI data models
  • Transform data with Power Query
  • Build highly interactive dashboard & reports
  • Publish reports to Power BI Service
  • Design Reports & Dashboards for Mobile View
  • Share reports and Dashboards
  • Set up automatic data refresh

PRE-REQUISITES

This course is designed for anyone that functions in Accounting, Finance, Audit, HR, Admin, IT and any other Business Related unit or largely, any one interested in Data Analysis.

Participants should:

  • be available with their lap tops for the 6 days classroom course.
  • have the latest version of the Power BI Desktop on their machines.
  • have anonymized data sets available for the case studies session.

FEES

N105,000 per participant.

ABOUT THE COURSES & FEES

This is a 6 days course, covering the essentials of Power BI and using your data to build Analytics solutions.

POWER BI

​Power BI is a revolutionary Microsoft Tool for Business Intelligence, Data Analytics and Data Visualization.

​It is excellent for:

  • Connecting to various data sources (including Facebook and the local Folders on PC)
  • Cleaning and manipulating data (if you collect data from many people, then you can relate)
  • Analyzing data to deliver actionable insights
  • Presenting reports & dashboards with stunning visuals
  • Automating every single one of the bullets listed above.

LEARNING OUTCOME

At the end of this course, participants would have learnt how to:

  • Build efficient Power BI data models
  • Transform data with Power Query
  • Build highly interactive dashboard & reports
  • Publish reports to Power BI Service
  • Design Reports & Dashboards for Mobile View
  • Share reports and Dashboards
  • Set up automatic data refresh

PRE-REQUISITES

This course is designed for anyone that functions in Accounting, Finance, Audit, HR, Admin, IT and any other Business Related unit or largely, any one interested in Data Analysis.

Participants should:

  • be available with their lap tops for the 6 days classroom course.
  • have the latest version of the Power BI Desktop on their machines.
  • have anonymized data sets available for the case studies session.

FEES

N105,000 per participant.

Account No:

0452832575 (GT Bank)

POWER BI COURSE AGENDA

OVERVIEW OF POWER BI

  • Understanding Self Service BI
  • The Power BI Eco System
  • The 4 skills needed to master Power BI
    Getting Data with Power BI
  • Building Reports & Visualizations
  • Understanding the Power BI Desktop Interface & Controls

DATA MODELING & DAX FORMULA LANGUAGE

  • Mastering Data Model Build
  • Understanding the concepts of FACT & DIMENSION Tables
  • Using Power Query to build FACT & DIMENSION Tables
  • Understanding Relationship Types in Power BI
  • Common errors and Resolutions in Data Models
  • Understanding how the DAX Engine Works
  • Mastering the Golden Rules of DAX
  • Understanding DAX Evaluation Context
  • Writing Simple DAX Measures
  • Introduction to the CALCULATE Function
  • Writing Time Intelligence Formulas
  • Writing Variance Formulas
  • Visualizing your reports

DATA MANAGEMENT AND CLEANING BAD DATA WITH POWER QUERY

  • Understanding the Rules for Clean Data
  • Mastering the thought process for data cleansing
  • Carrying our basic Data Transformation in Power Query
  • Carrying out major Data Transformations in Power Query
  • Tracing Query Errors

DATA VISUALIZATION & THE POWER BI SERVICE

  • Using the Power BI Standard Visual
  • Using the Power BI Custom Visuals
  • Selecting appropriate Visuals
  • Formatting Visuals
  • Setting up Row Level Security (RLS)
  • Publishing reports to the Power BI online Service
  • Understanding Workspaces
  • Sharing reports with other users
  • Setting up Auto Refresh & Data Gateways
  • Creating Power BI Dashboards
  • Designing Reports & Dashboards for Mobile view
  • Analyzing Power BI Reports in Excel

POWER BI COURSE AGENDA

OVERVIEW OF POWER BI

  • Understanding Self Service BI
  • The Power BI Eco System
  • The 4 skills needed to master Power BI
    Getting Data with Power BI
  • Building Reports & Visualizations
  • Understanding the Power BI Desktop Interface & Controls

DATA MODELING & DAX FORMULA LANGUAGE

  • Mastering Data Model Build
  • Understanding the concepts of FACT & DIMENSION Tables
  • Using Power Query to build FACT & DIMENSION Tables
  • Understanding Relationship Types in Power BI
  • Common errors and Resolutions in Data Models
  • Understanding how the DAX Engine Works
  • Mastering the Golden Rules of DAX
  • Understanding DAX Evaluation Context
  • Writing Simple DAX Measures
  • Introduction to the CALCULATE Function
  • Writing Time Intelligence Formulas
  • Writing Variance Formulas
  • Visualizing your reports

DATA MANAGEMENT AND CLEANING BAD DATA WITH POWER QUERY

  • Understanding the Rules for Clean Data
  • Mastering the thought process for data cleansing
  • Carrying our basic Data Transformation in Power Query
  • Carrying out major Data Transformations in Power Query
  • Tracing Query Errors

DATA VISUALIZATION & THE POWER BI SERVICE

  • Using the Power BI Standard Visual
  • Using the Power BI Custom Visuals
  • Selecting appropriate Visuals
  • Formatting Visuals
  • Setting up Row Level Security (RLS)
  • Publishing reports to the Power BI online Service
  • Understanding Workspaces
  • Sharing reports with other users
  • Setting up Auto Refresh & Data Gateways
  • Creating Power BI Dashboards
  • Designing Reports & Dashboards for Mobile view
  • Analyzing Power BI Reports in Excel

TRAINER’S PROFILE

Ahmed Oyelowo

LEAD TRAINER (C.E.O)

+234-7080579790


Ahmed is a Microsoft Data Platform (MVP), Microsoft Certified Solutions Associate (BI Reporting), Microsoft Certified Trainer (MCT) and a Certified Advanced Financial Modeler (AFM) from the Financial Modeling Institute, Ontario, Canada.

He has developed cutting edge solutions and trained various corporate clients on Business Intelligence and Financial Modeling. He has been consulting & training on Power BI since it’s early days in 2015.

Ahmed has trained courses on:

  • Power BI
  • Power Query,
  • Financial Modelling
  • Advanced Data Analysis & Reconciliation and
  • Data Presentation.

He is the Managing Partner & Lead Trainer at Foresight BI & Analytics.

ENROLLMENT FORM

Loading

Consulting

Address: Divine Plaza, Suite B5, First Floor, 59, Ajayi Road, Ogba, Lagos.

Phone: +234-708-057-9790

Email: info@foresightbi.com.ng

Subscribe To Our Newsletter

Join our newsletter to receive updates on trainings, live webinars & news from our blog.

Translate »
Scroll Up