Home

All courses

Business Intelligence with Power BI Desktop

Business

Business Analytics & Intelligence

Microsoft Power BI

Business Intelligence with Power BI Desktop

Master Power BI, Data analysis, Visualization and designing Dashboard

4.4

(2288)

19995 enrolled on this course

Last updated 11/2021

Mohannad Alhariri

₹ 5499.0

₹ 6999.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

- Power BI is becoming the most powerful self-service business intelligence platform, and an absolutely
essential
tool for data professionals and beginners alike
- A comprehensive, guide to learning Microsoft Power BI Desktop.
- You can connect to hundreds of data sources, build complex relational models using simple and intuitive tools,
- You can design stunning, interactive dashboards from scratch
- You'll Lead Business Intelligence Analyst for business case, to design and deliver a professional business intelligence solution.
- Don't worry, I'll be with you to get dirty with this project step - by- step
- Whether you're a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI expert,
Guaranteed
- Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
Course Structure :
- Section 1 : Introduction to Data analysis and power Bi Desktop
- Section 2 : Connection and Shaping Data
- Section 3: Table Relationships and Data Model
- Section 4: Analyzing Data with DAX
- Section 5: Data Visualization with Power BI Desktop
Who this course is for:
Data Analysts
Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Anyone looking to pursue a career in data analysis or business intelligence
Who this course is for:
Data analysts
Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Anyone looking to pursue a career in data analysis or business intelligence

What you'll learn

Understand the business intelligence workflow

Transform raw data into an interactive dashboards

Build professional-quality business intelligence reports from the ground up

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction

2-2. Connection and Shaping Data

2.1-Introduction and adjusting settings in Power Bi

2.2-2-2.Transform data in power bi

2.3-2-3. Dealing with texts

2.4-2-4.Dealing with numbers

2.5-2-5.Working with Date & Time

2.6-2-6.Index column and conditional column

2.7-2-7.Grouping & Aggregating

2.8-2-8. Pivot & unpivot Demo 1

2.9-2-8. Pivot & unpivot Demo 2

2.10-2-9. Merging Queries

2.11-2-10. Append Queries

2.12-2-11.Connecting a folder

2.13-2-12. Data source sitting and refreshing in report

2.14-2-13. Data type and categories in PBi

2.15-2-14. Hierarchies in PBi

3-3. Table Relationships and Data Model

3.1-3-1.The issue and Data model

3.2-3-2. Normalization and understand Data table & Data lookup

3.3-3-3. Creating table relationship

3.4-3-4. Snowflake schemas

3.5-3-5. Editing relationship and Active vs. Inactive relationship

3.6-3-6. Connect multiple data table

3.7-3-7. Filter flow

3.8-3-8. Bi direction ( two-way) direction filter

3.9-3-9. Hiding fields from the report view

4-4. Analyzing Data with DAX

4.1-4-1. Intro to DAX and calculated column

4.2-4-2. Intro to measures

4.3-4-3. Adding measures, Implicit vs. Explicit measures

4.4-4-4. DAX Date & Time function 1

4.5-4-4. DAX Date & Time function 2

4.6-4-5.DAX. IF-OR-AND functions

4.7-4-6. DAX, Common text functions

4.8-4-7. DAX , Joining Data with related

4.9-4-8. DAX, Math functions

4.10-4-9. DAX. Count functions ( Count, COUNTA, Countrows, distinctcount)

4.11-4-10. important

4.12-4-11. DAX, Calculate function

4.13-4-12. DAX, Calculate ALL

4.14-4-13. DAX, Filter

4.15-4-14. DAX, Iterator functions

4.16-4-15. DAX, Time intelligence

5-Data Visualization with Power BI Desktop

5.1-5-2. Basics of Visualization Data in Power BI

5.2-5-3. Formatting options

5.3-5-4. Filter Options

5.4-5-5. Explore data with Matrix

5.5-5-6. Filter Data with slicers

5.6-5-7. Cards and KPI Visuals

5.7-5-8. Text Cards

5.8-5-9. Visualizing Data with Maps

5.9-5-10. Visualizing Data with Tree maps

5.10-5-11. Trendline and Area Chart

5.11-5-12. Trendline with forecasts

5.12-5-13. Goal pacing with gauges chart

5.13-5-14. Edit Report Interactions

5.14-5-15, Drill Through Filter

5.15-5-16. Report Bookmarks

5.16-5-17. What if analysis

5.17-5-18. Managing and Viewing Roles

5.18-5-19. More visuals, Mobile Layout and PBI Service need cut

Course Categories

Popular Courses

Business Intelligence with Power BI Desktop

Description

What you'll learn

Requirements

Course Content

You May Like