Power BI

Turn your data into actionable information

Courses Offered:

Visualising Data Using Power BI

Course Description

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Whether you are new to Power BI or want to fill some knowledge gab, we are focused on providing you with the fundamentals you need to work with Power BI effectively. Through Power BI Desktop, you will learn to connect to several data sources, build relational models, and design stunning interactive dashboards and reports for your organisation. Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals. This course is for anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop or data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills.

What you will learn:

  •  Introduction and overview of Power BI Desktop
  •  Components and architecture of Power BI
  •  The Power BI interface
  •  Connecting and shaping data
  •  Creating Table relationships and Data Models in Power BI
  •  Creating Date (Calendar) table in Power BI
  •  Data visualisations and reports in Power BI
  •  Drilling, Filtering and Sorting your reports
  •  Power BI report formatting and layout options
  •  Adding Calculated Column to your table
  •  Creating simple DAX measures for your reports
  •  Managing your Power BI reports
  •  Publishing and sharing your reports with others

Power BI Data Modelling with DAX

Course Description

Power BI makes it easy to create visualisations and basic data models. But if you need to report across time periods or compare sales or other data by month or quarter, you need Data Analysis Expressions (DAX). In this course, you will learn the fundamental concepts and best practices for incorporating DAX into your Power BI reports. Learn how to work with DAX aggregate functions, add calculated columns, create measures, and work with DAX logical formulas. You will be introduced to time-intelligence functions and we will show you how to use Quick Measures to generate insights from your reports. This course is for individuals who have a basic working knowledge of Excel Tables, Pivot Tables and is familiar with the basics of Power BI.

What you will learn:

  •  Introduction and overview of DAX (Data Analysis Expressions)
  •  Data modelling basics
  •  Understanding DAX syntax
  •  Common DAX operators
  •  Useful math and stats DAX functions
  •  Add a Calculated Column to your model
  •  Understanding the concept of measures
  •  Implicit and explicit measures
  •  Creating basic measures like SUM, COUNT, COUNTROWS, and COUNTBLANK
  •  Creating measures using iterator functions like SUMX
  •  Basic DAX date and time functions
  •  Creating measures using DAX logical functions
  •  The CALCULATE function: the most important and powerful DAX function
  •  DAX time intelligence functions
  •  Summarise year-to-date with the DATESYTD function
  •  Visualise cumulative year-to-date data using TOTALYTD
  •  Compare year-on-year using SAMEPERIODLASTYEAR

Some of our cherished Clients

What our clients say about us

Solomon Sakyi Aboagye

Deputy Head, Reinsurance & Statistics

I attended the Pivot Tables and Dashboard Reporting course by EN Analytics and was more than impressed with the quality of the training. The training was very practical and hands-on and was beneficial to me because of the type of work I do. The lead facilitator was proficient, knowledgeable and engaging. I will recommend EN Analytics to any organisation that intends to train its staff in advanced Excel, Power BI and data analysis

Star Assurance

Enoch Akuffu-Djobi

Operations Manager and PHD Candidate

The training on Forecasting and Time Series Analysis was well delivered. In addition to the theoretical concepts, I was equipped with practical skills needed to professionally analyse time series data with ease. I highly recommend EN Analytics to any organisation

Ecobank Plc

Ezekiel Kafui Kunkpe

Programs Manager

We have been working and partnering with EN Analytics for sometime now. They provide training in advanced Excel and Power BI for some of our clients in the oil sector. They are the best in the country when it comes to Excel training. I recommend them to any organisation seeking to upgrade the Excel and Power BI skills of their staff

Oilfield Traning Center (OTC)

Michael Arhin

Finance Manager

Since engaging EN Analytics to train our staff, our team works efficiently and effectively. They have helped us develop accounting and reporting models and this has improved our work enormously. If you really want to use Excel and Power BI to optimise your business operations, then contact EN Analytics. They provide world class training at a competitive price

Kaltire Ghana Limited

Daniel Odom

Finance Manager

Our training experience with EN Analytics has been revolutionary and an experience every staff at Amaja Oilfield looks forward to every year. My team and I have been transformed from basic to intermediate Excel users to experts users. I recommend EN Analytics as your ideal trainer. Their teaching methods are simple and makes it easy to grasps even the most complex competency.

Amaja Oilfield Ghana Limited

Akpene Sunu

Operations Director

We contracted EN Analytics and Consulting Limited to train our staff in Data Analytics and they exceeded our expectations. The training was in-depth, hands-on and very applicable to the work we do. I strongly recommend them to other businesses.

GRO Alliance Ghana Limited

Dzifa Ama Fie

Data Analyst/Statistitian

Very practical and hands-on training sessions with EN Analytics. Our training on Power Query and Pivot Tables was in-depth and beneficial. I recommend EN Analytics for staff training, business professionals and business owners as well.

Statistics and Revenue Forecasting Unit, GRA