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