Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Power BI Course for Beginners - Practical Course..
Rating: 4.4 out of 5(2,053 ratings)
32,647 students

Microsoft Power BI Course for Beginners - Practical Course..

Project Oriented Course about Microsoft Power Bi -----------------------------------------------------------------------
Created byMohammed Shahin
Last updated 6/2021
English
English [Auto],

What you'll learn

  • Trainees will be able to start creating their own visual reports
  • Trainees will be able to do Data Transformation
  • Will learn how to import data into power bi
  • Will learn power bi structure
  • Will learn how to publish reports
  • Will learn how to share the final report
  • Will learn how to create relationships between tables

Course content

1 section • 16 lectures • 1h 16m total length

  • Introduction3:55

    Learn to transform and load data, build table relationships, and create visual reports in power bi to reveal trends and guide customer-focused business decisions.

  • Bi Structure4:15

    Explore the three elements of Power BI—desktop, cloud service, and mobile app—and how to connect data, transform it, form relationships, and publish reports.

  • Installation3:16

    Install Power BI desktop from Microsoft, choose 64-bit on Windows 8/10, sign in optionally with a service account, and learn to connect data sources to build and publish visual reports.

  • Importing from My SQL Database3:55

    Learn how to connect Power BI to a MySQL database, import tables, and choose between transform and load while exploring data sources, credentials, and the relationship view.

  • Importing CSV Files Into Power Bi2:03

    Learn how to import csv files into Power BI desktop, preview the customer table, and perform data transformations in the transformation section before loading into a report.

  • Points For Clarifications1:48

    Connect to a single database to import multiple tables at once. Explore importing from folders of similarly structured files and extract data efficiently in Power BI for beginners.

  • Power Query Editor Overview4:07

    Explore the Power Query editor in Power BI, navigate data sources and tables, use the formula bar to apply actions, and manage applied steps with transform and add column options.

  • Appending Tables & Conditional Columns6:18

    Learn to append multiple queries into a single table, create a conditional column to classify order quantity as single or multiple, and build relationships to prepare Power BI reports.

  • Points For Clarifications - part23:39

    Explore how renaming tables and applying transformations do not modify the original data, and learn how manual or scheduled refresh brings updates into Power BI.

  • Why we need to create a Relationships?5:45

    Create and relate tables in Power BI by linking them with a common product key to build a single report from product, sales, and return data.

  • Creating Relationships3:16

    Create relationships in Power BI by linking a unique product lookup table with sales and return fact tables using the product key, producing accurate, non-duplicated product reports.

  • DAX Using (Calculated Column & Measures)16:24

    Explore DAX to create a margin calculated column (price minus cost), then build a total profit measure and display it via a card and slicer for time intervals.

  • Using Bar Chart Visual7:05

    Create relationships between product, subcategory, and category tables to show category, subcategory insights, and order quantity in a bar chart with drill down in Power BI.

  • Using Map Visual4:48

    Create a map visual to show total order quantity by country, establish relationships between territories and sales, and explore profit across time intervals.

  • Publishing & Sharing The Report4:11

    Publish your Power BI report by creating a new workspace, uploading from desktop to the service, and sharing via embed code, publish to web, or email access.

  • Way Forward1:18

    Demonstrate a Power BI workflow—from data import and transformation to creating a relationship, building reports with visuals, and publishing—sharing the report with PowerPoint, and start building your own visual reports.

Requirements

  • No prerequisite

Description

Free Course which cover all the basics for creating a report


COURSE DESCRIPTION:

Power Bi is a tool which allows you to create a visual reports to interpret data, you can get a conclusion from your historical data which can help you to take a better business decision to improve from your business performance.

In this course we are going to explore different features of Power Bi tool and we will learn the workflow to create a visual report by building a solution for a certain customer requirement.

In this course we will cover the followings:

  1. Power BI Structure

  2. Power BI Installation & Overview

  3. Data Transformation

  4. Create relationships between tables.

  5. Using DAX to write some Formulas.

  6. Create Reports using multiple visuals.

  7. Sharing the report using Power BI service.

We will build a visual report for the below customer requirements:                                           

  • Orders Quantity per product name.

  • Total Quantity orders per product sub-category/product category.

  • Return Quantity per product name.

  • The territory which is having more orders.

  • The total revenue/profit for a certain time interval.


Who this course is for:

  • Anyone looking for a practical session to learn Microsoft Power BI.

  • Data Engineers who want learn about business intelligence.

  • Students who want a comprehensive, engaging, and highly interactive approach to training

  • Anyone looking to enter data analysis or business intelligence field.


About the instructor : 

Mohammed Marwan is a Certified ILM Instructor having more than 10 years of experience in Training and Development (for both Technical and Non-Technical fields) with an excellent communication /presentation skills and developing training materials for multinational organizations.

He is delivering currently the below courses:

1- Internet of things (IoT), (Duration : 1 days)

2- Artificial Intelligence (AI), (Duration: 2 days)

3- Machine Learning using Microsoft Azure (2 days)

4- Data Science using Python (2 Days)

5- Basics of Python Programming (Duration : 3 days)

6- Advanced Python Programming (Duration : 3 days)

7- Robotics Process Automation (RPA) using UiPath (Duration : 2 days)

8- Chatbot designing using Python & Dialog flow.( Duration: 1 day)

9- Augmented Reality , (Duration: 1 days)

10- Thingworx IoT Application platform (Duration : 5 days)

11- Machine learning using Python

12- Deep learning using Python

13- Microsoft Power Bi

14- Raspberry pi mini computer 

Who this course is for:

  • Beginners
  • Students
  • Any one interested about creating visual reports

Report abuse