Markovdata > Courses > Analyzing and Visualizing Data with Microsoft Power BI

Analyzing and Visualizing Data with Microsoft Power BI

Abstract Microsoft Power BI is one of the best data analysis and visualization software available. With it, you can develop dynamic reports and dashboards, integrating data from multiple sources such as Excel files, databases and online platforms like KoBo Toolbox. In this course, you will learn move from beginner to pro Power BI user using […]

Instructor
Markov Data
17 students enrolled

Abstract

Microsoft Power BI is one of the best data analysis and visualization software available. With it, you can develop dynamic reports and dashboards, integrating data from multiple sources such as Excel files, databases and online platforms like KoBo Toolbox. In this course, you will learn move from beginner to pro Power BI user using case studies.

Instructor

Eng. Eman Raslan, Data Scientist, Markov

Duration

6 Weeks

Sessions

Mondays & Wednesday, 7:00 to 10:00PM

Location

Live Streaming (on-line)

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:
• Basic knowledge of the Microsoft Windows operating system and its corefunctionality.
• Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• Some exposure to basic programming concepts (such as looping and branching).
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
• Familiarity with Microsoft Office applications – particularly Excel.

After Completing this course, students will be able to:

• Describe the Power BI suite of products.
• Connect to data sources and optimize data models.
• Shape and combine data from different sources.
• Model data.
• Use DAX Functions
• Create reports and manage solutions.

Course Outline:

• Module 1: Introducing Power BI
• Module 2: Query Editor
• Module 3: Modeling Data
• Module 4: Introduction to DAX
• Module 5: Advanced DAX
• Module 6: Interactive Data Visualizations

Module 1: Introducing Power BI

1
Introduction to Power BI
2
The Power BI Desktop User Interface
3
Building Our First Visualization in Power BI
4
Filtering and Interactions
5
Using Data from Multiple Tables
6
Saving and Uploading Your Work
7
Creating and Sharing a Dashboard

Module 2: Query Editor

1
Introduction to the Query Editor
2
Connecting to Multiple Files
3
Pivoting and Un-pivoting the Dataset
4
Assigning Data Types
5
Merging and Appending Datasets
6
Grouping and Aggregating Data
7
Filtering in the Query Editor
8
Formatting Columns
9
Custom and Conditional Columns
10
The M Formula Language
11
Editing Queries and Loading to Power BI
12
Connecting to Folders

Module 3: Modeling Data

1
What are the Relationships?
2
Fact Tables vs. Dimension Tables
3
Star/Snowflake Schema
4
Viewing Relationships
5
Creating Relationships
6
Cardinality
7
Cross Filter Direction
8
Active vs. Inactive Relationships

Module 4: Introduction to DAX

1
Calculated Columns
2
Measures
3
Calculated Tables
4
Aggregation Functions
5
Logical Functions
6
CALCULATE Function
7
SWITCH Function
8
COUNT and DISTINCTCOUNT

Module 5: Advanced DAX

1
Date Functions
2
Time Intelligence Analysis
3
Working with Variables
4
Relational Functions
5
FILTER Function
6
Multiple Row Contexts
7
Running Totals
8
Rolling Averages

Module 6: Interactive Data Visualizations

1
Power BI Reports: Page Layout and Formatting
2
Chart Types
3
Creating and Formatting Charts
4
Charts
5
Legends and Tooltips
6
Slicers
7
Filters
8
Drill-through Filters
9
Interactions
10
Hierarchies
11
Quick Measures
12
Lists and Bins
13
Other Charts
14
“What-If” Parameters
15
Managing & Viewing Roles

Be the first to add a review.

Please, login to leave a review
Enroll course
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV