Learn Data Storytelling: Power BI Techniques

This course is part of Mastering Power BI for Data Analytics & Storytelling Specialization

Instructor: Edureka

Sponsored by Louisiana Workforce Commission

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Some related experience required

12 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Some related experience required

12 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

25 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Mastering Power BI for Data Analytics & Storytelling Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 5 modules in this course

Welcome to the Data Storytelling with Power BI course, where you'll embark on a journey to acquire practical expertise in data transformation and visualization. Leverage the potential of Power BI to craft narratives through structured data, leading to the discovery of more profound insights. Throughout this course, you'll explore the industry-specific applications of Power BI and delve into its various features and functionalities.

By the end of this course, you’ll be able to: • Explain the different data sources present in Power BI Desktop. • Demonstrate the use of Power Query Editor to clean and transform data. • Manipulate data with the DAX formula and depict stories by using different visualization techniques. • Apply Power BI Service features to elevate the quality of your Reports and implement Dashboards on Power BI Service. • Create Reports and Dashboards on Power BI service utilizing its prevalent features. • Implement Smart Narrative and Key Performance Indicators to enhance reports for a target audience. This course is designed for a diverse audience: freshers, data analyst, business analysts, business intelligence analyst and IT professionals who are looking to enhance their data analysis skills through Power BI. Prior experience with Microsoft Excel or spreadsheet applications can be beneficial when working with Power BI. Embark on an educational voyage to master Microsoft Power BI and enhance your skills in creating efficient Reports and Dashboards using the Power BI ecosystem.

In this module, you will explore the world of business intelligence and derive stories from data and present them to a targeted audience. You will also learn to identify and implement transformations in data for visualization with Power BI Desktop.

What's included

22 videos8 readings9 assignments3 discussion prompts

22 videosTotal 131 minutes

Course Introduction6 minutesPreview module
What is Power BI?9 minutes
Applications of Power BI3 minutes
Installation of Power BI Desktop and Service6 minutes
Working with Power BI6 minutes
Frameworks for Data Model - I6 minutes
Frameworks for Data Model - II8 minutes
Power BI Desktop Interface9 minutes
Power BI Service Interface9 minutes
Data Sources in Power BI Desktop8 minutes
Transforming Data - I7 minutes
Transforming Data - II6 minutes
Cleaning Data - I5 minutes
Cleaning Data - II3 minutes
Shaping Data - Relationships6 minutes
Analyzing the Scenario3 minutes
Transformations - Adjusting the Data5 minutes
Transformations - Adding New Data5 minutes
Transformations - Sorting New Data3 minutes
Practice Project - Problem Statement1 minute
Practice Project - Solution5 minutes
Summary for Data Modeling and Transformation1 minute

8 readingsTotal 85 minutes

Welcome to Data Storytelling with Power BI10 minutes
Requirements for Installing Power BI Desktop 10 minutes
Power BI Licesnses10 minutes
Building Blocks of Power BI10 minutes
How to Use Discussion Forums5 minutes
Types of Data Sources and Connections10 minutes
Practice Session Problem Description10 minutes
Problem Statement: San Francisco's Call Record Analysis20 minutes

9 assignmentsTotal 41 minutes

Knowledge Check: Introduction to Power BI5 minutes
Knowledge Check: Data Frameworks5 minutes
Knowledge Check: Shaping Data5 minutes
Knowledge Check: Transformations5 minutes
Knowledge Check: Data Modeling and Transformation 10 minutes
Practice Quiz: Basics of Power BI3 minutes
Practice Quiz: Data Modeling3 minutes
Practice Quiz: Data Handling3 minutes
Practice Quiz on Transformations2 minutes

3 discussion promptsTotal 30 minutes

Introduce Yourself10 minutes
List out notable differences between Power BI Desktop and Service10 minutes
List alternate steps for the methods/techniques shown in the Practice Session10 minutes

In this module, you will learn to manipulate data with DAX formulas to create measures and columns, operate these transformations with the help of DAX functions, and create relationships to manage data.

What's included

19 videos4 readings7 assignments2 discussion prompts

19 videosTotal 101 minutes

Introduction to DAX 3 minutesPreview module
DAX Queries - I3 minutes
DAX Queries - II6 minutes
DAX Queries - III4 minutes
DAX Operations - I2 minutes
DAX Operations: Problem Description5 minutes
DAX Operations: Transformations6 minutes
DAX Operations: Column Manipulations5 minutes
DAX Operations - Date Manipulations2 minutes
DAX Functions - I6 minutes
DAX Functions - II5 minutes
DAX Functions - III6 minutes
Data Functions - IV5 minutes
DAX Functions - V6 minutes
Practice Project I: Railway Analysis6 minutes
Practice Project II: Table Management5 minutes
Practice Project III: Modifying Measures6 minutes
Practice Project IV: Insights7 minutes
Summary for DAX1 minute

4 readingsTotal 75 minutes

DAX Formula List25 minutes
Starting out with DAX in Power BI20 minutes
DAX Problem Description10 minutes
Project: Majestic Traders: Kings of Import and Export20 minutes

7 assignmentsTotal 31 minutes

Knowledge Check: DAX5 minutes
Knowledge Check: DAX Operations5 minutes
Knowledge Check: DAX Functions5 minutes
Knowledge Check: Mastering DAX 10 minutes
Practice Quiz: DAX Queries2 minutes
Practice Quiz: DAX Operations2 minutes
Practice Quiz: DAX Functions2 minutes

2 discussion promptsTotal 20 minutes

Do you find DAX easy to use with Power BI?10 minutes
Do you think DAX gives you more control over data or it restricts Power Query Editor?10 minutes

In this module, you will learn to create data visuals with the help of common charts and custom visuals and understand how they work. We will also learn about the best practices that are to be followed while building paginated reports and dashboards.

What's included

16 videos1 reading6 assignments1 discussion prompt

16 videosTotal 73 minutes

Populating Charts with Data5 minutesPreview module
Visualization Types - I3 minutes
Visualization Types - II4 minutes
Visualization Types - III4 minutes
Visualizing Data I3 minutes
Visualizing Data II: Problem Description2 minutes
Visualizing Data III: Loading Data5 minutes
Visualizing Data IV: Creating Visuals6 minutes
Visualizing Data V: Arranging Visuals4 minutes
Visualizing Data VI: Managing Visuals 4 minutes
Practice Project I: Problem Description5 minutes
Practice Project II: Transforming Data5 minutes
Practice Project III: Creating Visuals5 minutes
Practice Project IV: Arranging Visuals6 minutes
Practice Project V: Syncing Visuals4 minutes
Summary for Data Visualization1 minute

1 readingTotal 25 minutes

Project: Visualizing Netflix Dataset25 minutes

6 assignmentsTotal 30 minutes

Knowledge Check: Introduction to Visuals5 minutes
Knowledge Check: Visualizing Data5 minutes
Knowledge Check: Practice Session Visualizing Charts5 minutes
Knowledge Check: Visualization10 minutes
Practice Quiz: Practice Session Visualizing Data3 minutes
Practice Quiz on Charts2 minutes

1 discussion promptTotal 10 minutes

What modifications would you implement in the Practice Project's generated report to align it with your perspective?10 minutes

In this module, you will learn about Power BI Service, make use of the features after publishing reports and dashboards on the Service interface, manage Smart Narrative, use Q & A to draw more insights from data, secure reports and dashboards with security roles, and observe data lineage.

What's included

8 videos1 reading2 assignments

8 videosTotal 43 minutes

Overview of Power BI Service3 minutesPreview module
Power BI Service I: Loading Data5 minutes
Power BI Service II: Manipulating Visuals5 minutes
Power BI Service III: Creating Report6 minutes
Power BI Service IV: Publishing Reports6 minutes
Power BI Service V: Dashboarding6 minutes
Power BI Service VI: AI Insights5 minutes
Summary for Power BI Service3 minutes

1 readingTotal 20 minutes

Project: Sales Report20 minutes

2 assignmentsTotal 7 minutes

Knowledge Check: Power BI Service 5 minutes
Practice Quiz on Power BI Service2 minutes

This module is designed to assess an individual on the various concepts and teachings covered in this course. Answer a comprehensive quiz which marks you as a learner who is confident in working with Power BI.