Microsoft Power BI for Beginners & Excel Users
- Description
- Curriculum
- FAQ
- Reviews
Dive into a course initially recorded live, making it engaging and interactive. You won’t just be passively learning; you’ll feel like you’re right there in the room with participants from the corporate world and learning solutions to REAL problems.
Here’s what you’ll learn in each unit:
-
Introduction to Business Intelligence
-
Overview of Business Intelligence
-
The journey from data to wisdom
-
Understanding the Business Intelligence process with Power BI
-
-
Understanding the Data Cycle
-
Exploring the limitations of traditional tools like Excel
-
Reviewing different licensing options in Power BI
-
-
Data Transformation Techniques in Power BI
-
Introduction to Power BI Query Editor
-
Common issues with data and how to identify them
-
Steps for effective data cleaning:
Removing columns and rows
Setting the first row as header
Changing data types, replacing values, and removing spaces
Handling errors, renaming and optimizing steps
Filling down missing values, splitting columns, and removing duplicates
Tips and tricks to automate data cleaning
-
-
Data Modeling and Enrichment
-
Basics of data modelling and building relationships
-
Understanding filter propagation and cardinality
-
Best practices in data model construction
-
Introduction to data enrichment: Creating calculated columns and measures
-
-
Basics of Data Visualization
-
Familiarization with native and custom visuals in Power BI
-
Hands-on creation of various charts (pie, line, bar), tables, and cards
-
Techniques for drilling down hierarchies and setting visual interactions
-
Formatting visuals and reports, including titles, legends, and axes
-
Utilizing slicers and different levels of filtering
-
Applying conditional formatting
-
Embedding images into reports
-
-
Publishing and Sharing Insights
-
Steps to publish reports and set default user experiences
-
Creating and managing workspaces for collaboration
-
Strategies for sharing reports effectively
-
Designing reports for mobile layouts
-
-
1
How Does Power BI Work for Excel Users? Meet Your Instructor -
2
Who am I? Let Me Introduce Myself
With over 15 years of exemplary experience in the field of data analytics and corporate training, Ali Noorani stands as a beacon of knowledge and inspiration. His journey, transitioning from a mechanical engineer to a Microsoft Certified Trainer, showcases his unparalleled adaptability and commitment to excellence. At the helm of AMZ Consulting, Ali has demonstrated extraordinary leadership and strategic foresight, propelling the company to the forefront of technology consulting. His profound expertise in Excel and Power BI, particularly in the complex arena of data modeling, sets him apart as a distinguished authority. Ali’s training methodology, marked by clarity and depth, has profoundly impacted the professional lives of over 2,000 participants from diverse industries, enabling them to unlock the potential of data in making informed business decisions.
-
3
Three Key Steps to Becoming a Skilled Data Analyst
-
4
Steps to Download Power BI Desktop -
5
What Do We Mean By "Power BI"? A Simple Introduction
-
6
Power BI Ecosystem
-
7
Everything You Need to Know About the Data Cycle (Part 1)
-
8
Everything You Need to Know About the Data Cycle (Part 2)
-
9
Sales Data
Introduction
This fictitious dataset has been created to facilitate learning and practice in data analysis and visualization. It provides a rich collection of sales data, incorporating various dimensions such as time, geographical location, order methods, product types, and retailer information. This dataset is ideal for exploring sales trends and the overall performance of different products and retailers. This dataset will be used by the trainer in the accompanying videos, and it is predominantly used in the manual and exercise files unless explicitly mentioned otherwise in the manual.
Dataset Description
1. Sales Table:
Columns:
Trans Date: The date and time of the transaction.
RetCity: The city where the retailer is located.
Order method type: The method used to place the order (e.g., E-mail, Web, Sales visit).
Urgent?: Indicates whether the order was marked as urgent.
Retailer type: The type of retailer (e.g., Sports Store, Outdoors Shop).
Product Code: The code identifying the product sold.
Value: The monetary value of the sale.
Quantity Sold: The quantity of the product sold.
2. Country Table:
Columns:
Country: The name of the country.
City: The name of the city within the country.
3. Product Table:
Columns:
Product Code: The code identifying the product.
Product line: The product line to which the product belongs (e.g., Camping Equipment, Golf Equipment).
Product type/Product: The specific type or name of the product.
Product Cost: The cost of the product.
This comprehensive dataset enables detailed analysis of sales performance across various dimensions, making it an excellent resource for students, educators, and professionals looking to enhance their skills in data analytics and visualization.
-
10
Disney's Magic Band
-
11
The Rise and Fall of Amazon's AI Hiring Tool: Lessons Learned
-
12
Coca-Cola Data-Driven Distribution
-
13
Power BI - The Game Changer !
-
14
Puzzle Pieces for learning
-
15
How to Transform Data Like a Pro: Part 1
-
16
How to Transform Data Like a Pro: Part 2
-
17
How to Transform Data Like a Pro: Part 3
-
18
Data transformation -
19
Transition to a data analyst
-
20
The Cambridge Analytica Saga: How Data Changed Politics Forever
-
21
Working hard vs. Working smart
-
22
10 Most Important Data Transformation Theory
-
23
Common mistakes to avoid when working on Power BI Desktop
-
24
Schemas in a Data Model
-
25
I Wish I Knew These Data Modelling Tips When I Started – Part 1
-
26
I Wish I Knew These Data Modelling Tips When I Started – Part 2
-
27
I Wish I Knew These Data Modelling Tips When I Started – Part 3
-
28
Data Modelling & Data Enrichment
-
29
Parrot Analytics
-
30
Basic Logical Functions in DAX
-
31
Calculated columns in DAX
-
32
Calculated Measures in DAX
-
33
Calculated Columns vs. Calculated Measure
-
34
How Does Data Visualisation Work? (Part 1)
-
35
How Does Data Visualisation Work? (Part 2)
-
36
How Does Data Visualisation Work? (Part 3)
-
37
Data Visualization
-
38
Pretty and Interesting Reports
-
39
Top keyboard shortcuts in Power BI
-
40
Two ways to create bubble maps in Power BI
-
41
Creating Dynamic Bar Chart in Power BI
-
47
Power BI Beginners Assessment
This quiz serves as a qualifier to determine whether you have successfully comprehended the course material. It will aid in assessing your understanding of Power BI theory
-
48
Mini Project: Sales Data Report in Power BI
-
49
From Core Skills to Applied Mastery
-
50
How Do I Practice?
