By the end of this course, you will be able to
How to obtain data from a variety of sources and clean it using Power BI Query Editor, and how to create powerful and interactive dashboards by visualizing your data.
Some visualization styles, tips and tricks that will bring your data to life, what clean and dirty data look like, and how to review and determine data types.
How to design your data model to navigate and explore relationships within, as well as how to build DAX formulas to make your data easier to work with.
Course details
- 3 h 45 m/37 lessons
- Last updated: 25/2/2021
- 2 learning resources
- Course completion certificate
Course Content
What is Power BI?
Understanding the Power BI Desktop Workflow
What Do We Need to Understand Before We Start?
Understanding the Relationship Between Dimension Table and Fact Table
What is Power BI?
Understanding the Power BI Desktop Workflow
What Do We Need to Understand Before We Start?
Understanding the Relationship Between Dimension Table and Fact Table
Relationship, In-Depth
Understanding the Power BI Desktop Interface
Understanding What Clean and Dirty Data Look Like
Connecting Power BI Desktop to Source Files || Understanding the Query Editor
Extracting Excel Objects from Each File with Excel Workbook Function
Reviewing and Determining Data Types
Creating Calculated Columns Using Custom Columns || Connecting to a New Workbook || Relationship Between Tables
Creating DAX Measures for Some Important Totals and Percentages
What is a Dashboard and What are the Important Things We Should Keep in Mind While Creating One?
Creating an Interactive Dashboard
Introduction to the Conditions in Power BI
Creating DAX Measure Using IF Function
Assigning the Condition Into the Card
Hierarchies || Drill Mode || Assigning the Condition into the Clustered Column
Assigning the Condition Into the Map
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 1
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 2
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 3
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 4
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 5
Creating Dynamic Dashboard Using Visualizations Tool in Power BI: Part 6
Creating an Additional Page to the Dashboard
Adding All Links into the Pages in Power BI
Adding Tooltip Feature to the Donut Chart
Creating Drill-through in Power BI
Understanding How to Publish and Manage the Dashboard Online
Designing a Custom Dashboard Template Using MS PowerPoint
Learning How to Install the Custom Design in Power BI and Create a New Project
Understanding the Difference Between Calculated Column and Measure in Power BI
Building a Final Dashboard in Power BI: Part 1
Building a Final Dashboard in Power BI: Part 2
Building a Final Dashboard in Power BI: Part 3
Building a Final Dashboard in Power BI: Part 4
About this course
Microsoft Power BI is for those who want to learn and use the Power BI features to extract maximum information and make intelligent decisions to boost their business. If you understand basic BI concepts and want to learn how to apply them using Microsoft Power BI, then this learning path is for you. It includes real-world examples on Power BI and a deep dive into the technical issues, additional protocols, and much more.
Course requirements and prerequisites
You will also need to have Microsoft Power BI installed. The mentor will explain how you can download it in the first few videos.
Mentor
Ashraf Elsheikh
Founder & CEO Of Elite for Training and Web Designs
23,473 Learners
4 Courses