Going very nice
Detailed Microsoft Power BI DAX and Dashboard creation
Learn how to create well formatted and clean Power BI report and dashboard, write DAX using Copilot in Power BI Desktop
Microsoft,Microsoft Power BI,Power BI,Data & Analytics,Excel Dashboard,
Lectures -134
Resources -9
Duration -24 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Welcome to Power BI Desktop course. This is completely built with lots of Practical that will make you work with any real-Life datasets
Are you a data professional or aspiring analyst looking to learn the top business intelligence platform on the market,
taking this course will build your confidence in data and analytics in general.
Through out the course we will guide you through on how to approach real-life projects.
This is the scenario:
You just got hired as a DATA analyst into a sales and distribution company. Your first task is to use POWER BI to get
insight from the company’s historical data.
Request from your Employer:
Your employer needs you to help them TRACK KPI’s like: Revenue, Returns, Refunds & Profit etc. Create a dashboard that helps them find trend and other useful insights.
They want to identify high profitable Product, Customer and Location etc
You don't need to worry about how to go through this project, we'll be here to walk you through every single step with intuitive, crystal clear explanations and helpful resources you need to get better.
Step 1: Connecting to data and transformation
In this first stage we are going to look at how to get data, get it clean and transformed and load it into Power BI desktop.
We will explore how to append data from csv and further use the advanced way to combine data from csv which is using the folder option to consolidate your yearly, weekly, quarterly or monthly data for easy update.
Step 2: Data modelling or Creating a Relationship
In this stage we will look at how to best connect your data table and the lookup tables together.
Step 3: Adding Calculated Fields with DAX
In this stage things will start to get more interesting. This is the stage you are going to get introduced to Data Analysis
Expressions (DAX) at this stage we will learn how to create calculated columns and measures, explore when to use calculated column and when to avoid it.
Step 4: Visualization (Dashboard)
This final stage is where we bring our data to LIFE with report and dashboard. We will learn the best way to create an outstanding dashboard, create custom tooltips, explore bookmarks and Power BI What-If Parameters.
See you in the classroom!
Goals
What will you learn in this course:
Out best goal in this course is to keep you up-to-date with what is new in Microsoft Power BI like Power BI Copilot.
You learn how to use Power BI Desktop for Report and Dashboard creation.
Transform and clean data using Power Query.
Data modelling (creating relationships).
Write DAX (data analysis expression) from beginner to advanced level and creating advanced reports and dashboards
Prerequisites
What are the prerequisites for this course?
No previous Power BI knowledge is needed ( I will teach you all you need to know).
Some with basic computer skill.
Anyone that want to learn something new in Power BI.
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Project
1 Lectures
- Take a look at the project we are going to create in this course 07:28 07:28
Intro to POPWER BI Desktop
5 Lectures
How to Connect and Transform Data in Power Query
17 Lectures
Creating Data Modeling
4 Lectures
How to create a Date Table using DAX
5 Lectures
Understand Calculated Column in Power BI
7 Lectures
Understand Measures In Power BI
17 Lectures
Context Transition
4 Lectures
Simplify DAX with Variables
8 Lectures
Understand the default Filters in Power BI Desktop
3 Lectures
Visualization ( Detail Dashboard)
18 Lectures
Visualization (Dashboard with forecasting)
13 Lectures
What-If Analysis Dashboard
9 Lectures
What-If Analysis Dashboard with Top-5
7 Lectures
Returned Dashboard
9 Lectures
Dashboard with Image Ranking
7 Lectures
Instructor Details
Ismaila Omeiza Mumuni
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now