Data Analysts with PowerBI

Learn to master Power BI, one of the world’s most popular business intelligence tools. In this interactive learning path, the courses are created to cater to industry demands, pass the official PL-300 Data Analyst with Power BI exam, and become a professional user.

Get Advice

Master Data Analytics With PowerBI

Who this course is for:

Beginners curious about data visualization and analytics, looking to get started with Power BI.
Excel users who want to take their data analysis skills to the next level with Power BI.

Data professionals aiming to broaden their skill set with proficiency in Power BI.
Business leaders and managers seeking to leverage data for informed decision-making.
Students studying business, economics, statistics, or related fields, looking to bolster their resume with data analysis skills.
IT professionals who want to understand and utilize Power BI in their workflow.
Freelancers offering data analysis services, looking to expand their toolkit with Power BI proficiency.

What you will Learn:

Master the use of Power BI as a powerful analytical tool to transform raw data into valuable insights.
Automate your data analysis and reporting, saving significant time and increasing efficiency.

Apply Power BI and DAX to decipher complex data, finding the insights that drive decision making.
Create compelling visualizations that effectively communicate your data analysis results.

Learn and implement our four-pillar framework for mastering Power BI.
Enhance your DAX and Power Query skills, gaining a deeper understanding of data manipulation.
Build practical solutions for real-world scenarios, using advanced data analytics techniques.

Implement best practices in Power BI model development, report writing, and publishing.

Course Benefits & Key Features

Master Data Analytics With PowerBI’s benefits and key features.

Modules

30+ Modules.

Lessons

80+ Lessons

Practical

40+ Hands-On Labs

Life Projects

5+ Projects

Resume

CV Preparations

Job

Jobs Reference

Recording

Session Recording

Interviews

Mock Interviews

Support

On Job Supports

Membership

Membership Access

Networks

Networking

Certification

Certificate of Completion

INSTRUCTOR-LED LIVE ONLINE CLASSES

Our learn-by-building-project method enables you to build

practical or coding experience that sticks. 95% of our

learners say they have confidence and remember more

when they learn by building real world projects which is

required to work in your real life.

Get step-by-step guidance to practice your skills without getting stuck
Validate your technical problem-solving skills in a real environment
Troubleshoot complex scenarios to practice what you learned
Develop production experience that translates into real-world

.

Why Master Data Analytics With POWERBI?

Learn In-demand Skills

Those with careers in data analysis learn relevant in-demand skills that span industries and add value to every digital-enabled organization.

Earn a Higher Salary

Experienced data analysts can earn up to $112,000 per year and transition into higher-paying jobs as Senior Data Analysts, Data Scientists, or Analytics Managers.

Positive Job Outlook

The data analytics market is predicted to hit $132.90 Billion USD by 2026. COVID-19 pandemic accelerated the adoption of data analytics solutions and services.

Shape the Future

Data analysts transform organizations by capitalizing on data to improve their business decisions and solve critical real-world problems.

Become a Leader

Being a central part of an organization’s decision-making processes, analytics experts often pick up strong leadership skills as well.

Data Analysis are Constantly Evolving

Data analysis moves quickly, and data analysts are constantly learning and advancing in their careers.

GreaterHeight Certificates holders are prepared to work at companies like these.

Some Alumni Testimonies

Investing in the course "Become a Data Analyst" with GreaterHeight Academy is great value for the money and I highly recommend. The trainer is very knowledgeable, very engaging, provided us with quality training sessions on all courses and was easily acessible for queries. We also had access to the course materials and also the timely availability of the recorded videos made it easy and aided the learning process..

QUEEN OBIWULU

Team Lead, Customer Success

The training was fantastic, the instructor is an awesome lecturer, relentless and not tired in his delivery. He obviously enjoys teaching, it comes natural to him. We got more than we expected. He extended my knowledge of Excel beyond what I knew, and the courses were brilliantly delivered. They reach out, follow up, ask questions, and in fact the support has been great. They are highly recommended and I would definitely subscribe to other training programs from them.

BISOLA OGUNRO

Fraud Analytics Risk Oversight Manager

It's one thing to look for just a Data Analysis training, and it's another to get the knowledge transferred through certified professional trainers. No matter your initial level of proficiency in any of the Data Analysis tools, GreaterHeight Academy would meet you there and take you up to a highly proficienct and confident level in a short time at a reasonable pace. I learnt a lot of Data Analysis tools and skills at GreaterHeight from patient and resourceful teachers.

TUNDE MEREDITH

Operation Director - Abbfem Technology

The Data Analysis training program was one of the best I have attended. The way GreaterHeight took off with Excel and concluded the four courses with Excel was a mind blowing - it was WOW!! I concluded that I'm on the right path with the right mentor to take me from a novice to professional. GreaterHeight is the best as far as impacting Data Analysis knowledge is concern. I would shout it at the rooftop to recommend GreaterHeight to any trainee that really wants to learn.

JOHN OSI PETER

Greaterheight

I wanted to take a moment to express my deepest gratitude for the opportunity to study data analytics at GreaterHeight Academy. I am truly impressed by the level of dedication and support that the sponsor and CEO have put into this program. GreaterHeight Academy is without a doubt the best tech institution out there, providing top-notch education and resources for its students. One of the advantages of studying at GreaterHeight Academy is the access to the best tools and technologies in the field.

AYODELE PAYNE

Sales/Data Analyst

It is an unforgettable experience that will surely stand the test of time learning to become a Data Analyst with GreaterHeights Academy. The Lecture delivery was so impactful and the Trainer is vast and well knowledgeable in using the applicable tools for the Sessions. Always ready to go extra mile with you. The supports you get during and after the lectures are top notch with materials and resources available to build your confidence on and off the job.

ADEBAYO OLADEJO

Customer Service Advisor (Special Operations)

Master Data Analytics With PowerBI

Introduction to PowerBI

A Thorough Introduction to Power BI

In this 3-hour course, you’ll gain a 360° overview of the Power BI basics and learn how to use the tool to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises. Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive.

Learn the Power BI Basics

You’ll start by looking at some of the fundamentals of Power BI, getting to grips with Data, Model, and Report views. You’ll learn to load data sets, build a data model, and discover how to shape and transform your data with Power Query Editor. As you progress through the course, you’ll have access to hands-on exercises that can hone your skills. You’ll look at various visualizations, sort different data types, and learn to drill deeper into your reports.

Create Powerful Data Visualizations

Once you've covered Power BI in general, you can dig into its options for data visualization. Learn to choose the right visual for your dataset and type, how to make changes to follow visualization best practices and tell a strong story with your data, and learn to sort and format your data for clearer storytelling.

4 Modules | 5+ Hours | 4+ Skills

Course Modules

Discover how to navigate this intuitive tool and get to grips with Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view. You’ll also practice using Power Query Editor to prep your data for analysis.

Introduction to Power BI
The essentials of Power BI
Views in Power BI
Getting started!
Loading existing reports
Your first visualization
Add a card
Slicers and Tables
Slicers
More columns
Table
Data Analyst in Power BI track

In this module, you'll learn how to shape and transform your data before the data analysis using Power Query Editor.

Transforming data
Cleaning data
Power Query Editor
Transform before load
Field aggregation
Transforming and formatting columns
Transforming columns
Formatting currency
Making maps with geographic data

It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll learn how to change and format a wide range of visualizations, before moving on to sorting data and creating hierarchies—making it possible for you to drill into your reports.

Visualization options
Choosing the right visual
Making changes
Changing visuals
Editing properties
Sorting and more formatting
Sorting data
Using the slicer
Making it look good

In the final module, you’ll discover how to filter the information in your reports by location and control how these filters interconnect and interact with other visuals in your report.

Drilling down and filtering
Working with hierarchies
The underlying data and hierarchies
Looking at the data
Creating a hierarchy
Filters
Adding a filter
Turning off interactions
Applying advanced filtering
Recap!

Introduction to DAX to PowerBI

Learn the DAX Fundamentals

Start your journey to becoming a DAX master with this introductory course on DAX. You’ll learn fundamental concepts and best practices for implementing DAX in your reports.

Create Calculated Columns, Measures and Tables

You’ll learn to write DAX code to generate calculated columns, measures, and tables while learning supporting knowledge around ‘context’ in Power BI. Finally, we’ll round off the course by introducing time-intelligence functions and show you how to use Quick Measures to create complex DAX code.

Let’s take the first step in your DAX mastery journey!

3 Modules | 3+ Hours | 3+ Skills

Course Modules

In this module, you’ll learn how to create custom calculations using Microsoft’s formula language, DAX (Data Analysis Expressions). You’ll learn how to expand your source tables with calculated columns, before progressing to writing calculated measures to help summarize your data.

Introduction to DAX in Power BI
Calculated columns vs. measures
Creating calculated columns and measures
Profit column
Sales count
Profit margin ratio

In this module, you'll learn about context in Power BI and how it plays an important part when building reports. Next, we'll learn how to use iterator functions to evaluate data at a row level. We'll then introduce you to the CALCULATE function to help you filter your data and finally, we'll show you how to use variables to make writing DAX functions more efficient.

Context in DAX formulas
The importance of Context
Creating DAX measures
Using variables
Iterator functions
Sales by category and year

In this module, you'll learn the power of DAX's date and time intelligence functions. You'll be able to use these functions in actions, as well as use quick measures to create complex DAX code.

The Date table
Creating a calculated table
Dates and Quick Measures
Expanding the Date table
DATEDIFF
Your first quick measure
Year-over-year change
Recap!

Data Visualization In PowerBI

Create Insightful Visualizations

Power BI has extraordinary visuals that can be used in reports and dashboards. In this Power BI course, you’ll learn to create insightful visualizations through built-in and customized charts and conditional formatting.

Discover New Chart Options

You’ll discover how to create a plethora of visualizations such as scatter plots, tornado charts, gauges, and how to visualize everything without overwhelming your audience.

4 Modules | 4+ Hours | 4+ Skills

Course Modules

In this first module, you'll get to understand how the target audience matters in visualization. You'll also be introduced to the UK clothing business sales database, which you’ll use throughout the course.

Know your audience
Dashboard or report?
Tables and scatter charts
Add a table and slicers
Create a scatter plot
Create a bubble chart.

In the second module, you will learn how to build dashboards that connect on an emotional level, so they won't get forgotten about.

Getting an emotional response
Factors for evoking emotion
Bar charts and small multiples
Create a bar chart
Format a visual
Stacking variables
Using small multiples

In this module, we will learn how human memory works and why it is related to data visualization.

Reduce cognitive load
Reducing cognitive load
Combination charts and custom visuals
Line and area charts
Combo charts
Tornado charts

The last module is all about “less is more”. This will help you reduce the cognitive load for your dashboard’s users, making it easier for them to focus on the insights that matter.

Less is more
How to do things better!
Shares, gauges, and KPIs
Shares of the whole
Gauges and cards
Key performance indicators
Conditional formatting
Recap!

Case Study: Analyzing Customer Churn In PowerBI

Are you ready to apply your Power BI skills to a real-world dataset?

Apply your Power BI skills with a Case Study

For subscription-based businesses, reducing customer churn is a top priority. In this Power BI case study, you'll investigate a dataset from an example telecom company called Databel and analyze their churn rates.

Understand why customers churn

Analyzing churn doesn’t just mean knowing what the churn rate is: it’s also about figuring out why customers are churning at the rate they are, and how to reduce churn. You'll answer these questions by creating measures and calculated columns while simultaneously creating eye-catching report pages.

3 Modules | 3+ Hours | 3 Skills

Course Modules

In this first module, you'll start exploring the new dataset and revisit creating measures in Power BI to get a better understanding of why customers are churning.

Analyzing customer churn in Power BI
Analysis process
Data check time
Understanding churn
Calculating churn
Investigating churn reasons
Digging deeper into churn categories
Use maps to your advantage

You'll continue by leveraging the Power BI knowledge you gained from the prerequisite courses to further investigate why customers are leaving Databel.

Zooming out
Analyzing demographics
Age groups
Inspecting groups
Multiple fields to investigate
Unlimited plan
International calls
Advice to Databel
Contract type

In the last module, you'll create dashboard-style pages and arrange them into stories, so that you can share your results with stakeholders.

Creating a cohesive story
Dashboarding best practices
Overview page
Age brackets & groups
Payment method and contract category
International and data plan
More insightsp
Wrap-up

Data Preparation in PowerBI

Learn How to Use Power Query Editor

Transform and shape your data in Power BI. In just 3 hours, you’ll cover essential data preparation steps, previewing data in power query, and transformations.

By the end of this course, you’ll feel confident using a range of Power Query Editor tools and techniques and know how to clean and prepare your data for the next stage in the data analysis workflow.

Manipulate Data in Power BI

Power Query is a powerful data manipulation framework available throughout a number of Microsoft tools, which allows you to clean different data types ready for analysis. You’ll learn how to deal with duplicates, missing values, and profiling to find anomalies. After each new topic is introduced, you'll have the opportunity to put your new knowledge into practice with hands-on exercises, such as splitting and merging text columns.

Master Data Transformation in Power Query

The last two chapters of this course are focused on helping you with transformations in Power BI, allowing you to transform text, apply logarithmic and square root transformations, and date transformations.

This course is part of the Data Analyst and Power BI tracks, offering you plenty of ways to improve your Power BI skills or even build towards a career in data analysis.

4 Modules | 4+ Hours | 4 Skills

Course Modules

Data preparation is key to becoming a successful data analyst. You’ll learn how to do essential data preparation steps such as filtering and renaming columns and how to use data preview in Power BI to identify common errors that appear in datasets.

Introduction to Power Query
What is clean data?
Introduction to Power Query demo
Load data and promote headers
Rename and reorder columns
Changing data types

In this module, you will learn about the key data preview features available through Power Query and how they can help you summarize the characteristics of your dataset. You’ll also understand how investigating your dataset in Power Query can assist in determining the data transformation steps you need to take.

Data preview features in Power Query
Data preview differences
Data preview features
Column distribution and duplicates
Column quality and missing values
Column profile
Profiling to find anomalies

The preparation and transformation of text data can also be carried out through Power Query. Through interactive exercises, you’ll learn about some of the most common text transformations, such as how to split and merge text columns, trim unwanted characters from any text data, and prefixes to any text data in your dataset.

Transforming text in Power Query
Universally-applicable transformations
Text transformation
Trim & clean
Merge & extract length
Split & add prefix

This module covers the most common numerical transformations you’ll use in Power Query. You’ll learn how to perform some more advanced Power Query transformations. This includes applying logarithmic and square root transformations on numerical columns, rounding numerical data, and extracting month and week names from date columns.

Numerical transformations in Power Query
Numerical vs. Date transformations
Numerical transformations
Absolute value and rounding
Multiplication, addition, and square root
Date transformations
Wrap up!

Data Transformation in PowerBI

Apply Table Transformations

In this course, you’ll learn all about table transformations in Power BI. You’ll learn how to (un)pivot, transpose, and append tables.

Work with Joins

You’ll also get introduced to joins and discover when it makes sense to use them.

Utilize the Advanced Editor

Finally, you’ll gain power with custom columns, including how to use M language and the Advanced Editor, to help you be even more efficient in data preparation.

4 Modules | 4+ Hours | 4 Skills

Course Modules

In this module, you'll learn how to become a data plastic surgeon by restructuring and reshaping data in Power BI. You'll also stitch together data in different ways from various sources to enrich your analytical capabilities.

Reshaping and aggregating data
Which shape after transformation?
Reshaping and aggregating tables in Power Query
Unpivoting and transposing
Pivoting
Grouping and aggregating

In this module, you'll learn stitch together data in different ways from various sources to enrich your analytical capabilities.

Combining data in Power Query
What causes null values?
Merging and appending queries in Power Query
Appending queries
Merging queries: left join
Merging queries: right join
Transforming sales data for analysis

In this module, you’ll cover advanced features of Power Query, such as adding custom columns and custom conditionals.

Custom columns in Power Query
Custom conditional columns
Custom columns demo
Stock ranking
Stock values
Grouped stock ranking

In the final module, you’ll learn to read and write M language, which allows for a more efficient way to do data transformations in Power Query.

Introduction to Advanced Editor
Using the Advanced Editor
DAX vs M Language
M Language and Advanced Editor demo
Calculate stock deviation
Rename steps and add comments
Variables and custom functions
Calculate Z scores
Wrap Up!.

Data Modeling in PowerBI

Foundations of Data Modelling

Proper data modeling is the foundation of data analysis and creating reports in Power BI. This course lets you explore a toolbox of data cleaning, shaping, and loading techniques, which you can apply to your data.

Diving into Power Query

You'll get to know how to choose between Power Query and Power BI, and discover the foundations of data modeling by going into star and snowflake schemas. You'll apply all of this to real-world datasets issued by the United States Census Bureau.

4 Modules | 4+ Hours | 4 Skills

Course Modules

Proper data analysis relies on proper data modeling. This first module covers the basic concepts and teaches you how to set up and load data from multiple sources.

Data modeling and table properties
Power Query vs. Power BI
Load and transform data
Loading a CSV
Rounding, replacement, and sorting
Data categorization and visibility
Working with string columns

In this module, we continue comparing Power Query and Power BI practices. Later, you will exercise combining tables and column extraction on Power BI.

Shaping tables
Power Query vs. Power BI again
Merging and appending queries
Breaking a file into multiple tables
Appending files
Column extraction

In this module, you'll learn more about one of the most popular approaches to data modeling. You'll get familiar with the basic building blocks of the dimensional model; facts, dimensions, and star schemas.

Dimensional modeling
Facts vs. dimensions
Creating a star schema
Splitting data into facts and dimensions
Load a new dimension
Create another dimension

In this final module, you'll continue with an extension of the star schema: the snowflake schema. Lastly, you will have your first practice with performance analyzer in Power BI.

Star and snowflake schemas
Snowflake vs. star schema
Evaluating performance
Star schemas
Snowflake schemas
The performance analyzer
Wrap Up!

Intermediate Data Modeling in PowerBI

Extend your Data Modelling Skills

In this course, you’ll extend your knowledge about facts, dimensions, and their relationships. You learn about the cardinality of relationships and how you can use bi-directional cross-filtering in your model.

Use DAX to Customize your Data Model

You’ll also explore the use of quick measures and hierarchies and write DAX to fully customize your data model. Finally, you’ll get introduced to Power BI reporting best practices to improve the performance of your reports.

4 Modules | 4+ Hours | 4 Skills

Course Modules

In the first module, you'll extend your data modeling skills by adding more tables and relationships.

Date dimensions and relationships.
Cardinality
Date dimensions and relationships in Power BI
Create a year dimension
Extend the year dimension
Composite key relationships

You'll learn how to use hierarchies and explore several granularity levels of your data.

Granularity, measures, and hierarchies
Hidden hierarchies
Hierarchies and measures in Power BI
Build a hierarchy
Change the granularity of a query
Measures and quick measures

In this module, you'll look at some advanced data modeling techniques. You'll learn how and when to use bi-directional cross filters and role-playing dimensions.

Working with relationships
Bi-directional relationships
Cross-filtering and role-playing Dimensions
Bi-directional cross-filtering
Role-playing dimensions

In this final module, you'll study performance optimization tips and tricks in Power BI.

Identifying performance problems
Optimizing performance
Performance tips in Power BI
Data types and calculations
Calculated versus computed columns
An alternative to bi-directional filtering
Recap!

Case Study: HR Analytics in PowerBI

Apply Your Skills with a Power BI Case Study

In this Power BI case study, you will be exploring a dataset for a fictitious software company called Atlas Labs. This course focuses on helping you import, analyze and visualize Human Resources data in Power BI. Building on your existing knowledge of the platform, you'll learn how to effectively work with Power BI using example data.

Carry Out Exploratory Data Analysis

You’ll carry out exploratory data analysis and will use DAX to help build powerful visualizations. You’ll finish your analysis by diving deeper into attrition and what factors impact attrition. This analysis will help the organization determine what action they will need to take to retain more employees.

Build Branded Power BI Reports

We’ll finalize the case study by making design changes to our report that provide a clean, branded design.

3 Modules | 3+ Hours | 3 Skills

Course Modules

In this module, you’ll start by bringing all your data into Power BI and connecting your data model. Once your data is ready, you’ll start by rolling your sleeves up and doing some initial exploratory data analysis on general HR trends.

HR Analytics in Power BI
Report development
Loading CSVs
Date dimension and relating tables
Exploring the data
Hiring trends over time
Analyzing departments and job roles

This module is about using your Power BI skills to extract insights using DAX and learn how to build custom visuals that you can use throughout your report. Atlas Labs would like some answers on its employee demographics and performance. Luckily, they have you on their team as a Data Analyst to help them explore their data further.

Taking a step back
Demographics: age and gender
Demographics: marital status and ethnicity
Performance Tracker: Part 1
Performance Tracker: Part 2

It’s almost time to deliver your report to the key stakeholders at Atlas Labs. In this final module, you’ll be focusing on delivering insights on attrition and what factors affect employee retention. Finally, you’ll be cleaning up the overall layout of the report to create a user-friendly, clean, and branded experience.

Creating a cohesive report
Understanding attrition
Other factors that impact attrition
Insights on attrition
Layout design improvement
Theme formatting
Page navigation
Wrap-up

DAX Functions in PowerBI

Master DAX

DAX, or Data Analysis eXpressions, is a formula language used in Microsoft Power BI to create calculated columns, measures, and custom tables. Once mastered, DAX gives you powerful control over visuals and reports, allowing for better performance and more flexibility.

Apply Context

This course covers the core concepts such as row query and filter context, with exercises focusing on filtering, counting, ranking, and iterating functions.

4 Modules | 5+ Hours | 4 Skills

Course Modules

In this module, you'll write custom functions to create new tables and calculated columns.

DAX for creating tables and columns
Row vs. query vs. filter context
DAX for calculated tables and columns
Creating a date table
Calculated column for costs
Data cleaning with DAX
Connecting data from different tables

In this module, you'll write custom functions to create calculated measures. You'll also get introduced to variables to make writing DAX functions more efficient.

Methods to create DAX measures
Advantages of explicit measures
DAX and Measures
Using variables
Basic statistical measures
Quick measures

Expand your DAX power with some commonly used DAX measures. This module focuses on filtering and counting functions.

Filtering and counting with DAX
Understanding different filter functions
Using different filters with DAX
Filter ALL the data
Calculating with a filter
Analyzing across dimensional tables

This module covers the core concept of another powerful set of DAX functions, the so called iterating functions. You will explore iterations with exercises focusing on ranking and iterating your data.

Iterating functions
DIY iterating functions
Iterating functions in Power BI
Practice with iterating functions
More iterating functions
Use of RANKX()
Wrap Up!

Intermediate DAX in PowerBI

DAX for Logical Functions

This course introduces you to new DAX functions and its many use cases. First of all, you expand your core DAX knowledge by learning how to write logical functions.

Use DAX for Row-Level Security

Secondly, you’ll discover how you can write DAX functions for row-level security (RLS) purposes and how to use DAX to manipulate tables and create nested functions. Those time-intelligence quick measures will be building themselves before you know it!

4 Modules | 4+ Hours | 4 Skills

Course Modules

In this module, you'll dive into logical functions! You’ll learn how to combine IF with other Power BI functions and discover the robust SWITCH function.

Logical functions
Interpreting SWITCH()
Logical functions in Power BI
IF() for formatting tables
Exploring SWITCH()
Grouping

In the second module, you'll learn about row-level security, allowing you to change what data users see depending on their roles and permissions.

Row-level security
Applying row-level security
Managed roles in Power BI
Creating an email list
Implementing RLS
Security filtering

In this module, you'll learn table manipulation functions in DAX. Let's summarize!

Table manipulation functions
Summary of SUMMARIZE()
Table manipulations using DAX
SUMMARIZE() the facts
ADDCOLUMNS()? No problem!

In this last module, you'll expand your DAX knowledge with time intelligence functions. You'll even explore a way to create advanced visuals without writing DAX.

Time intelligence functions
Time intelligence functions output
Time intelligence in Power BI
Use of TOTALYTD()
Use of SAMEPERIODLASTYEAR()
Build your own YoY quick measure
DAX vs Q&A
Recap!

Exploratory Data Analysis in PowerBI

Exploratory Data Analysis

Enhance your reports with Power BI's Exploratory Data Analysis (EDA). You'll start by using descriptive statistics to spot outliers, identify missing data, and apply imputation techniques to fill gaps in your dataset.

Apply Statistical Techniques

You’ll then learn how EDA in Power BI can help you discover the relationships between variables—both categorical and continuous— by using basic statistical measures and box and scatter plots!

4 Modules | 4+ Hours | 4+ Skills

Course Modules

You’ll begin this Exploratory Data Analysis (EDA) course by learning how to use descriptive statistics and identify missing data, and apply imputation techniques to fill the gaps in your data.

What is exploratory data analysis?
Steps to EDA
Initial EDA of AirBnB listings
Identify missing data
Descriptive statistics for a variable
Imputation for missing data

In the second module of this course you'll learn how to identify and address outliers within the dataset. You will build histograms to analyze distributions and use winsorizing to remove outliers.

Distributions and outliers
Choices for finding outliers
Histograms and outliers in AirBnB listings
Create your first histogram
Identify outliers
Addressing outliers in the data

Now it’s time to explore the relationships between categorical variables using proportions. You’ll then use box plots and descriptive statistics to determine how a continuous variable is influenced by a categorical one.

EDA with categorical variables
Histograms vs. box plots
Exploring categorical variables with AirBnB data
Analyzing a categorical variable
Proportions with categorical variables
Analyzing multiple categorical variables
Creating a box plot

In the final module, you’ll dive into scatter plots to analyze the relationship between two continuous variables and calculate the correlation coefficient.

Relationships between continuous variables
Practice interpreting a scatter plot
Exploring AirBnB listings with scatter plots
Analyzing relationships with scatter plots
Adding context to scatter plots
Correlation coefficient
Recap!

Trend Analysis in PowerBI

Analyze Time-Series Data

In this course, you’ll learn how to analyze time series, visualize your data, and spot trends. You’ll build new date variables, discover run charts, and get into calculating rolling averages.

Understand Influencing Variables

Finally, you’ll find out how to identify which variables exhibit the most influence on the target variable using Power BI's decomposition trees and key influencers.

4 Modules | 4+ Hours | 4+ Skills

Course Modules

In this module, you’ll get more familiar with time-based variables and the multiple ways to extract further variables using EDA for analysis—like day of week and time difference. You’ll get hands-on with Power BI as you build line charts to calculate new metrics and uncover trends hiding in your data—including period-over-period change and rolling averages.

Starting to explore time series data
Statements about time series analysis
Exploring AirBnB time series
Generating a new date variable
Analyzing trends by day of week
Calculating year-over-year change

In this module, you’ll get more familiar with time-based variables and the multiple ways to extract further variables using EDA for analysis—like day of week and time difference. You’ll get hands-on with Power BI as you build line charts to calculate new metrics and uncover trends hiding in your data—including period-over-period change and rolling averages.

Time series run chart
Cyclical vs. Seasonal
Analyzing Glassdoor reviews over time
Building your first time series chart
Calculating rolling averages
Finding anomalies in time series data

One of the most powerful functions of EDA in Power BI is being able to identify which variables have the most influence on your target outcome. A native Power BI visualization tool enabling that is Decomposition Trees. You'll learn about Decomposition Trees, how to construct, then interpret in order to explain a target outcome by other variables.

Introduction to decomposition trees
Statements about decomposition trees
Using decomposition trees in Power BI
Getting started with decomposition trees
Diving deeper into decomposition trees
Decomposing attrition rates

In this module you'll build another native Power BI tool, Key Influencers visual. It helps you to understand how much a target outcome changes based on specific variables and segments of observations.

Introduction to key influencers
Decomposition trees vs. key influencers
Using key influencers in Power BI
Key influencers for average listing price
Segments from key influencers
Key influencers for super hosts
Wrap Up!

Reporting in PowerBI

Apply Data Storytelling Techniques

In this advanced course, take your Power BI visualizations up a level with the skills you already have. You’ll learn complex alternative data storytelling techniques to simply building dashboards, including buttons and bookmarks to create more interactive visualizations.

Customize User Experience (UX)

Customize the user experience by drill through filters and emoji, and learn how to tweak the Q&A feature for personalized reports.

4 Modules | 4+ Hours | 4+ Skills

Course Modules

You've built compelling dashboards in Power BI, but that's not all you can do. In this first module, you’ll learn the differences between reports and dashboards. Next, you'll add drill-through filters to your Power BI report to increase user interaction.

Reports vs. dashboards
Report or dashboard?
Increasing report interaction
Extend the Over Budget report
Create drill-through pages
Visualizing over time

In this module, you’ll learn to add interactive story-telling to your reports with bookmarks, buttons and navigation.

Bookmarks, buttons and navigation
What can bookmarks do?
Create and display bookmarks
Create bookmarks
Storytelling with bookmarks
Create buttons
Bookmarks and button navigation

Now it's time to customize the look and feel of buttons and tables using unicode and emojis in tables. You’ll also change how visuals interact with one another and see how conditional formatting can be a powerful tool for your report.

Customize look and feel
Button format options
Mouse actions and Unicode
Add a button animation
Working with tooltips
Table look and feel
Edit interactions

Asking a question in natural language is sometimes the quickest way to get an answer from your data. In this module, you'll learn how to add and tweak the Q&A visual to your Power BI Reports.

Customize a report with Q&A
Create a Q&A statement
The Q&A visual
Add the Q&A visual
Working with the Q&A visual
Add synonyms for fields
Teach Q&A new terms
Wrap Up!

Report Design in PowerBI

Customize your Reports

Continue your data visualization journey with this course on designing reports in Power BI.

Utilize Progressive Disclosure

Through hands-on exercises, you'll also be introduced to progressive disclosure, a user experience (UX) technique to make reporting easier, before discovering how to change report themes and optimize them for mobile users.

3 Modules | 3+ Hours | 3+ Skills

Course Modules

In this module, you’ll discover how to apply a UX technique called progressive disclosure. It makes the reporting experience behave more like a web application, by allowing users more control over the visuals.

Progressive disclosure
Progressive disclosure requirements
Progressive disclosure in Power BI
Budgets vs expenditures over time
Show and hide departments
Choose between visuals

Don't feel limited by Power BI's default theme—make it your own! In this module, you’ll learn how to change your theme, where to go to get inspiration, and how you can make your own custom themes.

Create a custom theme
Guidance on themes
Modifying a theme
Change default font sizes
Modify color choices
Alter the filter pane

In this final module, you’ll discover ways to optimize your report for mobile users.

Design for mobile devices
Mobile layout capabilities
Creating a mobile design
Create a mobile layout
Progressive disclosure on mobile
Make it mobile-friendly
Recap!

Data Connections in PowerBI

Building Connections

Data connections are an essential part of Power BI. In this course, you will be introduced to the many different options for connecting to data.

Understand Power BI Desktop vs Service

You’ll learn the differences between Power BI Desktop and Power BI Service when it comes to data connections. You’ll also learn about the different ways that Power BI stores data when connecting to a source, and how you are able to amend connections after they have been made.

Utilize Parameters and M Language

Finally, you’ll learn how you can use parameters and M Language in Power BI Desktop to level up your handling of data import processes.

3 Modules | 3+ Hours | 3+ Skills

Course Modules

Whenever using Power BI, a data connection is required. In this module, you'll be introduced to commonly used data connections for Power BI. You'll also get an insight into the data connection features of Power BI Serice while finally having the chance to carry out your own database connection.

Data connections in Power BI
The data flow process
Power BI Desktop connections
Which connection?
Welcome to Power BI Service
Desktop vs. Service
First connections
Desktop or Service data connections?
Add a database connection

It's time to take the next step in your data connections journey! Through hands-on exercises, you will interact with a new database connection and learn how different settings can be changed. You'll also learn about the different storage modes offered by Power BI and how you can use coding to alter the import process.

Database connections
Storage modes
Exploring connections
Power BI languages
Controlling the import process
Changing data source settings

In this module, you'll learn how to create parameters that can be used for incremental refreshes. You will also implement an incremental refresh on your data connection. Finally, you'll understand how M Language can be utilized to tackle issues with your data import processes.

Data source settings
Incremental refresh
Parameters and incremental refresh
Parameters: true or false?
Query parameters
Discovering M Language
M Language examined
Using M Language on connections
Recap!

Deploying & Maintaining Assets in PowerBI

Deploy and Maintain Assets

Learn how to deploy and maintain assets in Power BI. Through hands-on exercises, you’ll get to grips with the Power BI Service interface and key elements in it like workspaces.

Manage Datasets and Apply Security

You’ll learn how to securely report access by managing access to datasets, implementing row-level security, or applying sensitivity labels to prevent unauthorized data re-use or exfiltration.

Promote and Certify Content

You’ll also discover how to promote and certify content in Power BI before learning how to save time by subscribing to reports and setting up data alerts—making it easy to keep on top of changes to data in your reports.

3 Modules | 3+ Hours | 3+ Skills

Course Modules

In this module, you’ll discover how to publish your insightful and powerful Power BI Desktop reports as workspaces and build applications—ready for other users to access.

Workspaces and applications
Bringing your own data
Template vs organizational apps
Creating workspaces and apps
Workspace defaults
Steps to publish an app
Ways to get an app

Learn how to protect your Power BI reports and datasets. Making content available to people is important; making content available only to the right people is critical.

Securing datasets in Power BI Service
Sensitivity labels
Row-level security's benefit
Manage dataset permissions
Matching permissions with activities
Granting permissions on datasets
Row-level security and permissions
Configure row-level security
Apply sensitivity labels
Step by step sensitivity labels
Setting sensitivity labels

Now that you’ve delivered content to your users, the next step is to help them make the most of it. In this module, you’ll discover how to make your report discovery and information collection easier using various powerful tools in the Power BI Service.

Enabling report discovery
Promote or certify?
Personalize a report
Personalizing a visual
Certify content
Subscriptions and data alerts
Subscribing to a report
Congratulations!

MASTER DATA ANALYTICS WITH POWERBI COST

United States

$349.99

United Kingdom

£299.99

Career and Certifications

GreaterHeight Academy's Certificate Holders also prepared work at companies like:

Our Advisor is just a CALL away

+1 5169831065 +447474275645

Available 24x7 for your queries

Talk to our advisors

Our advisors will get in touch with you in the next 24 hours.

Get Advice

FAQs

Master Data Analytics With PowerBI

GreaterHeight Academy's Power BI course introduces you to Power BI Desktop and how it is used with Power Pivot for Data Modelling. This course enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop, Power View, and Power Map. This Power BI Certification course will also introduce you to Power BI Q &A, which enables you to discover, explore, and visualize enterprise data using Natural Language.

There is no prior technical knowledge required for this Power BI Training Course. However, a fundamental understanding of Microsoft Excel, Python Scripts will be an advantage. To help you brush up concepts of Python Scripts, we will provide self-paced videos absolutely free in your LMS.

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves without having to depend on any information technology staff or database administrator.
Power BI certification course shares knowledge on how it provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop.
It offers Data modeling capabilities including data preparation, data discovery, and interactive dashboards.

The Microsoft Power BI Training at Greaterheight Academy is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. It is best suited for:

Entry-level Professionals
Business Analysts
Business Intelligence Manager
Statisticians and Analysts
Data Scientists
Project Managers

Our Power BI course is relevant for people who want to learn how to create customized visual reports and use the Power BI tools. You will get hands-on experience on real-time projects and assignments that have high relevance in the corporate world, and industry experts design the Power BI course curriculum.

PowerBI Certification Training Cost in USA, UK and NIGERIA is £300.

All online training classes are recorded. You will get the recorded sessions so that you can watch the online classes when you want. Also, you can join other class to do your missing classes.

After completing the PowerBI Course successfully, GreaterHeight Academy provides a course completion certificate for PowerBI, which is valid for a lifetime.

With your email address and mobile number, you can start enrolling in the Tableau Course through our website. You can utilize online payment options, such as Visa Credit or debit card, Master Card, American Express, etc. Before making the payment, verify the batch information.

All our mentors are highly qualified and experience professionals. All have at least 8-10 yrs. of development experience in various technologies and are trained by GreaterHeight Academy to deliver interactive training to the participants.

Yes, we do. As the technology upgrades, we do update our content and provide your training on latest version of that technology.

No. Any abuse of copyright is taken seriously. Thanks for your understanding on this one.

Yes, we would be providing you with the certificate of completion of the program once you have successfully submitted all the assessment and it has been verified by our subject matter experts.

Yes. But you can also raise a ticket with the dedicated support team at any time. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, our support is provided for a period of Twelve Weeks from the start date of your course.

GreaterHeight is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry ready.
You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.

OUR POPULAR COURSES

Data Analytics and Visualization With Python

Advanced developments of expertise in cleaning, transforming, and modelling data to obtain insight into corporate decision making as a Senior Data Analyst - Using Python.

View Details

Data Science Training Masters Program

Learn Python, Statistics, Data Preparation, Data Analysis, Querying Data, Machine Learning, Clustering, Text Processing, Collaborative Filtering, Image Processing, etc..

View Details

Microsoft Azure DP-100 Data Science

You will Optimize & Manage Models, Perform Administration by using T-SQL, Run Experiment & Train Models, Deploy & Consume Models, and Automate Tasks.

View Details

Machine Learning using Python

Learn Data Science and Machine Learning from scratch, get hired, and have fun along the way with the most modern, up-to-date Data Science course on.

View Details

Microsoft Azure PL-300 Data Analysis

You will learn how to Design a Data Model in Power BI, Optimize Model Performance, Manage Datasets in Power BI and Create Paginated Reports.

View Details

Microsoft Azure DP-203 Data Engineer

You will learn Batch & Real Time Analytics, Azure Synapse Analytics, Azure Databricks, Implementing Security and ETL & ELT Pipelines.

View Details

The GreaterHeight Advantage

0+

Accredited Courseware

Most of our training courses are accredited by the respective governing bodies.

0+

Assured Classes

All our training courses are assured & scheduled dates are confirmed to run by SME.

0+

Expert Instructor Led Programs

We have well equipped and highly experienced instructors to train the professionals.

OUR CLIENTS

We Have Worked With Some Amazing Companies Around The World

Our awesome clients we've had the pleasure to work with!

Data Analysts with PowerBI

Course Benefits & Key Features

Master Data Analytics With PowerBI’s benefits and key features.

Modules

Lessons

Practical

Life Projects

Resume

Job

Recording

Interviews

Support

Membership

Networks

Certification

INSTRUCTOR-LED LIVE ONLINE CLASSES

Why Master Data Analytics With POWERBI?

Learn In-demand Skills

Earn a Higher Salary

Positive Job Outlook

Shape the Future

Become a Leader

Data Analysis are Constantly Evolving

GreaterHeight Certificates holders are prepared to work at companies like these.

Some Alumni Testimonies

QUEEN OBIWULU

BISOLA OGUNRO

TUNDE MEREDITH

JOHN OSI PETER

AYODELE PAYNE

ADEBAYO OLADEJO

Master Data Analytics With PowerBI

Module 1: Getting Started with Power BI

Module 2: Transforming Data

Module 3: Visualizing Data

Module 4: Filtering

Module 1: Getting Started with DAX

Module 2: Context in DAX Formulas

Module 3: Working with Dates

Module 1: The Audience is King

Module 2: Getting an Emotional Response

Module 3: Reducing Cognitive Load

Module 4: Less is More

Module 1: Exploratory Analysis

Module 2: Investigating Churn Patterns

Module 3: Visualizing your Analysis

Module 1: Profiling your Data and Introduction to Power Query

Module 2: Data Preview features in Power Query

Module 3: Data Manipulation

Module 4: Numerical transformations in Power Query

Module 1: Reshaping Data

Module 2: Combining Data in Power Query

Module 3: Custom Columns

Module 4: Advanced Editor

Module 1: Defining Tables

Module 2: Shaping Tables

Module 3: Dimensional Modeling

Module 4: Star and Snowflake schemas

Module 1: Date Dimensions and Relationships

Module 2: Granularity, Measures, and Hierarchies

Module 3: Advanced Data Modeling

Module 4: WIdentifying Performance Problems

Module 1: Data Modeling and EDA

Module 2: Analyzing Demographics and Performance

Module 3: Bringing it all Together

Module 1: Setting up Data Models with DAX

Module 2: DAX and Measures

Module 3: Filtering and Counting with DAX

Module 4: Iterating Functions

Module 1: Logical Functions

Module 2: Row-level Security

Module 3: Table Manipulation Functions

Module 4: Time Intelligence Functions

Module 1: Initial Exploratory Data Analysis in Power BI

Module 2: Distributions and Outliers

Module 3: EDA with Categorical Variables

Module 4: Relationships between Continuous Variables

Module 1: Exploring Time Series Data

Module 2: Analyzing Time Series in Power BI

Module 3: Decomposition Trees