- Introduction
- Bi Structure
- Installation
- Importing from My SQL Database
- Importing CSV Files Into Power Bi
- Points For Clarifications
- Power Query Editor Overview
- Appending Tables & Conditional Columns
- Points For Clarifications - part2
- Why we need to create a Relationships?
- Creating Relationships
- DAX Using (Calculated Column & Measures)
- Using Bar Chart Visual
- Using Map Visual
- Publishing & Sharing The Report
- Way Forward
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
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:
Power BI Structure
Power BI Installation & Overview
Data Transformation
Create relationships between tables.
Using DAX to write some Formulas.
Create Reports using multiple visuals.
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
Other Courses
Teaching Math and Literacy to young children (3-5 years old)
Parent / Teacher Tip - Make learning easy and fun for young children
How To Use Youtube To Grow Your Business
Youtube hacks, tags, set up, video engagement, partnerships, headlines, promote your business on youtube and more.
Make Stylized Grass by using Blender and Unity
Modeling in Blender, Make Shader in Unity
ActionScript - Essentials Advanced Guide
A-Z guide to help you understand basics of ActionScript
How to do affiliate dropshipping without store
2 in 1 course -drop shipping products, or drop shippig service
VmWare Virtualization Basics Training
In this tutorial, you can learn the basics about VmWare vSphere ESXi Hypervizor, Workstation Pro and Fusion.
About the instructors
- 4.43 Calificación
- 30726 Estudiantes
- 3 Cursos
Mohammed Shahin
Certified Technical 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.
Below are his areas of expertise:
- Telecom as he worked with Etisalat the leading Telecom service provider in the region as a Technical Instructor providing Telecom, GPON, IoT, Cloud, Networking and so many other courses.
- Strong A/V Broadcast Knowledge ,Consumer Electronics, Networking.
Mohammed Marwan have helped Thousands of people from around the world to learn & improve from their technical knowledge & skills.
He is passionate about providing training and teaching people about the technology in a very simple way without making things complicated for the students.
He is delivering currently the below courses:
1- Internet of things (IoT)
2- Artificial Intelligence (AI)
3- Machine Learning using Microsoft Azure
4- Data Science using Python
5- Basics of Python Programming
6- Advanced Python Programming
7- Robotics Process Automation (RPA) using UiPath
8- Chatbot designing using Python & Dialog flow.
9- Augmented Reality ,
10- Thingworx IoT Application platform
11-Smart Home solutions (Fibaro).
12- Wimax Vs. FixedLTE .
13- High end routers (D-link, Linksys, TP-link).
14- IT Fundamentals
15- IPTV & STB basics
16- Fiber Fox splicing tool
17- WIFI basics
18- WIFI Analyzer
19- GPON Test Equipment's , VFL, OTDR , power meter , LFI , fiber scope
Student feedback
Course Rating
Reviews
First time I am looking into Power Bi. I am feeling like, I got an overall workflow of Power Bi. Thanks
engaging with all the context
I wish to have the tables to practice at the same time I was learning.
He explained the details very well, easy to understand with lots of helpful notes. Thanks