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
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
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.
![Detailed Microsoft Power BI DAX and Dashboard creation Detailed Microsoft Power BI DAX and Dashboard creation](https://d3mxt5v3yxgcsr.cloudfront.net/courses/15660/course_15660_image.png)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to Connect and Transform Data in Power Query
17 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Creating Data Modeling
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to create a Date Table using DAX
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Understand Calculated Column in Power BI
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Understand Measures In Power BI
17 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Context Transition
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Simplify DAX with Variables
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Understand the default Filters in Power BI Desktop
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Visualization ( Detail Dashboard)
18 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Visualization (Dashboard with forecasting)
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What-If Analysis Dashboard
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
What-If Analysis Dashboard with Top-5
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Returned Dashboard
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Dashboard with Image Ranking
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Ismaila Omeiza Mumuni](https://www.tutorialspoint.com/assets/profiles/424446/profile/200_4075475-1686930988.jpg)
Ismaila Omeiza Mumuni
As a person with a very high keenness in data analytics with over 7 years of practical experience, I have brought my knowledge and skill to help you learn data analytics with ease.
as a student of Technology and data analytics, my aim is to give you an industry-standard training course that will make you thrive.
Over the years, I have been working from home as a freelance data analyst with several companies across the world and I am here to show you I did it.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
I easy and clearly understood this course. In my career this course very useful to us. And also I thank the instructor for creating this course
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 now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)