Overview What You Will Learn Curriculum Instructor

Course Overview

Power BI is becoming the most powerful self-service business intelligence platform, and an absolutely?essential?tool for data professionals and beginners alike. Microsoft Power BI Desktop is built for the analyst. It combines state-of-the-art interactive visualizations, with industry-leading data queries and modeling built-in. Power BI Desktop helps you empower others with timely critical insights, anytime, anywhere.

This course will teach you everything you need to know about Microsoft Power BI Desktop. The course will begin with an introduction to data analysis and Power BI desktop, followed by a walkthrough of data connection and shaping. You will also learn about table relationships and data models. Following that, you'll learn how to use DAX to perform data analysis. Finally, you'll learn how to use Power BI Desktop to visualize data.

By the end of this course, you’ll be able to connect to hundreds of data sources and build complex relational models using simple and intuitive tools. You’ll also be able to design stunning, interactive dashboards from scratch. You’ll become an absolute Power BI expert. Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together.

What You Will Learn

  • Understand the business intelligence workflow.
  • Transform raw data into an interactive dashboards.
  • Build professional-quality business intelligence reports from the ground up.
  • Visualize data using Power BI desktop.

Program Curriculum

  • Introduction and Adjusting Setting in Power BI
  • Transform Data in Power BI
  • Dealing with Texts - Voice Problem
  • Dealing with Numbers
  • Working with Date and Time
  • Index Column and Conditional Column
  • Grouping and Aggregating
  • Pivot and Unpivot Demo 1
  • Pivot and Unpivot Demo 2
  • Merging Queries
  • Append Queries
  • Connecting a Folder
  • Data Source Sitting and Refreshing in Report
  • Data Type and Categories in Power BI
  • Hierarchies in Power BI
  • $7 Million Cybersecurity Scholarship by EC-Council
  • Chapter 1 Quiz

  • The Issue and Data Model
  • Normalization and Understand Data Table and Data Lookup
  • Creating Table Relationship
  • Snowflake Schemas
  • Editing Relationship and Active vs. Inactive Relationship
  • Connect Multiple Data Table
  • Filter Flow
  • Bi Direction (Two-way) Direction Filter
  • Hiding Fields from the Report View
  • Chapter 2 Quiz

  • Intro to DAX and Calculated Column
  • Intro to Measures
  • Adding Measures, Implicit vs. Explicit Measures
  • DAX Date and Time Function 1
  • DAX Date and Time Function 2
  • DAX. IF-OR-AND Functions
  • DAX, Common Text Functions
  • DAX, Joining Data with Related
  • DAX, Math Functions
  • DAX. Count Functions (Count, COUNTA, Countrows, Distinctcount)
  • Important
  • DAX, Calculate Function
  • DAX, Calculate ALL
  • DAX, Filter
  • DAX, Iterator Functions
  • DAX, Time Intelligence
  • Chapter 3 Quiz

  • Basics of Visualization Data in Power BI
  • Formatting Options
  • Filter Options
  • Explore Data with Matrix
  • Filter Data with Slicers
  • Cards and KPI Visuals
  • Text Cards
  • Visualizing Data with Maps
  • Visualizing Data with Tree Maps
  • Trendline and Area Chart
  • Trendline with Forecasts
  • Goal Pacing with Gauges Chart
  • Drill Through Filter
  • Report Bookmarks
  • What If Analysis
  • Managing and Viewing Roles
  • More Visuals, Mobile Layout, and PBI Service Need Cut
  • Chapter 4 Quiz

Instructor

Mohannad Alhariri Alhariri

Mohannad Alhariri through working as an auditor in many firms and one in the big 4 (PwC) has gained a lot of experiences in the field of auditing, accounting, and financial services among our large clients. Gaining CPA has enhanced his knowledge in the auditing section and common business environment. He wants to deliver all the knowledge he has gained in his study or work to the viewers to make them better professionals.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • Statistics Fundamentals: Bundled

    Statistics Fundamentals: Bundled

    Short Course

    Statistics Fundamentals: Bundled

    Data Science

    Theory and Python

    $59.99

    Beginner

    14 hr 32 m

  • Data Wrangling with Pandas - Part 2

    Data Wrangling with Pandas - Part 2

    Short Course

    Data Wrangling with Pandas - Part 2

    Data Science

    Explore the World of Data Processing with Pandas and Get a Ch...

    $59.99

    Beginner

    3 hr 11 m

  • Hands-on Python Web Scraping from Scratch

    Hands-on Python Web Scraping from Scratch

    Short Course

    Hands-on Python Web Scraping from Scratch

    Data Science

    Master the art of programming & building custom web scrap...

    $69.99

    Beginner

    4 hr 30 m

  • Data Visualization Using Tableau - Part 3

    Data Visualization Using Tableau - Part 3

    Short Course

    Data Visualization Using Tableau - Part 3

    Data Science

    Master Tableau Calculations and Create Your Own Dashboards!

    $49.99

    Beginner

    2 hr 30 m

  • Applied Logistic Regression

    Applied Logistic Regression

    Short Course

    Applied Logistic Regression

    Data Science

    A data-driven approach to classification

    $59.99

    Beginner

    3 hr 9 m

  • A Crash Course to Build Your Own Chatbot

    A Crash Course to Build Your Own Chatbot

    Short Course

    A Crash Course to Build Your Own Chatbot

    Data Science

    Learn the essentials of creating your chatbot from scratch us...

    $79.99

    Beginner

    4 hr 0 m

  • Deep Dive into Snowflake

    Deep Dive into Snowflake

    Short Course

    Deep Dive into Snowflake

    Data Science

    Master Snowflake for Advanced Data Warehousing and Analytics

    $49.99

    Advanced

    2 hr 30 m

  • Business Intelligence with Power BI Desktop

    Business Intelligence with Power BI Desktop

    Short Course

    Business Intelligence with Power BI Desktop

    Data Science

    Master Power BI, Data analysis, Visualization, and Designing ...

    $59.99

    Intermediate

    7 hr 8 m

1 8