Insights of Power BI

Insights of Power BI

This course is part of Fractal Data Science Professional Certificate

Instructor: Analytics Vidhya

Access provided by Rothschild & Co. Wealth Management UK

6,011 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

55 reviews

Beginner level

No prior experience required

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

55 reviews

Beginner level

No prior experience required

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Select and use relevant charts for appropriate data problems
Use PowerBI to connect with data belonging to diverse formats
Communicate key insights from business problem using Reports and Dashboards
Create advanced visualization on Power BI using DAX

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

8 assignments

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the Fractal Data Science Professional Certificate

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

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 from Fractal Analytics

There are 4 modules in this course

Today's business world is becoming increasingly data-driven. Small and large businesses use data to make decisions about sales, hiring, goals, and all areas they have data for. While most businesses have access to data of one type or another, it can be intimidating for an average business user to understand the data without a background in data analytics.

Microsoft’s Power BI takes the intimidation and hassle out of data analysis and visualization. Throughout this course, you will identify errors in the datasets and diagnose them using data cleaning and transformation techniques to prepare them for reporting purposes. With a focus on practical applications, you will solve complex visualizations using the DAX operator and assess the visualizations to plan business-related decisions. Whether you aspire to be a data analyst, a business intelligence professional, or a decision-maker relying on data-driven insights, this course will provide you with the necessary tools and knowledge to succeed.

This module provides a comprehensive introduction to Power BI and data visualizations. Learners will explore the capabilities of Power BI and gain proficiency in creating impactful visualizations. Topics covered include installation and getting started with Power BI, various chart types, Power BI interface overview, comparison of reports and dashboards, and building a basic Power BI report. Throughout the module, learners will progress from understanding Power BI fundamentals to applying their knowledge in creating meaningful visualizations.

What's included

8 videos4 readings2 assignments

8 videos Total 60 minutes

Introduction to Data Visualization 2 minutes
Gateway to the Course 6 minutes
Power BI Interface and its Capabilities 7 minutes
Charts and Graphs in Power BI - Part 1 12 minutes
Charts and Graphs in Power BI - Part 2 9 minutes
Charts and Graphs in Power BI - Part 3 9 minutes
Building your first dashboard - Part 1 7 minutes
Building your first dashboard - Part 2 9 minutes

4 readings Total 80 minutes

Insights of Power BI - Course Syllabus 10 minutes
Installation of Power BI and gettiing started with Power BI 30 minutes
Module -1 10 minutes
Q&A feature in Power BI 30 minutes

2 assignments Total 90 minutes

End of week Graded Assessment: Helping Elevate Resort to solve Business problems 60 minutes
Check Your Understanding (Ungraded Quiz) 30 minutes

This module, "Operations on Multiple Tables," covers essential techniques for handling and analyzing data across multiple tables. By delving into different cleaning techniques, students will gain proficiency in efficiently retrieving datasets that can be directly used for visualizations. The module goes beyond theoretical concepts by providing practical exercises using a real-world case study, allowing users to apply their problem-solving abilities in a hands-on manner. At the end of this module, students will discover how to enhance data models by gaining an understanding of Fact tables and Dimension tables. Upon completion of the module, students will be able to acquire the skills to effectively perform operations on multiple tables, ensuring clean, transformed, and relationship-driven data models for analysis.

What's included

7 videos1 reading2 assignments

7 videos Total 62 minutes

Why Do We Need To Clean Data? 5 minutes
Preliminary investigations of data 5 minutes
Understanding Relationships between Tables 10 minutes
Understanding Data Model 10 minutes
Cleaning and transforming the Data 12 minutes
Transforming The Data Using Pivot Table 9 minutes
Updating Data with New Information 11 minutes

1 reading Total 10 minutes

Module-2 10 minutes

2 assignments Total 90 minutes

End-of-Week Assessment: Helping Elevate Resort Clean its Dataset 60 minutes
Ungraded Quiz: Check your understanding 30 minutes

In this module "DAX Operator", students will gain valuable skills to perform advanced calculations and data manipulations in Power BI. Students will explore various DAX functions and operators, understand their syntax and structure, and learn how to apply them effectively in Power BI. Additionally, they will also differentiate between calculated columns and measures, gaining insights into when to use each approach. In the end, students will have an in-depth understanding of the Row context and Filter context. Through practical examples and problem-solving exercises, students will develop a solid understanding of DAX fundamentals and their significance in data analysis.

What's included

8 videos3 readings2 assignments2 discussion prompts

8 videos Total 80 minutes

Introduction to DAX Function 4 minutes
Introduction to Calculated Columns and Row Context 6 minutes
Introduction to Measures and Filter Context 8 minutes
Understanding the Aggregation Function 11 minutes
Understanding the Logical Function 9 minutes
Understanding the Text Function 9 minutes
Understanding the Filter Functions (Calculate and Filter) - Part 1 22 minutes
Understanding Filter Functions (ALL) - Part 2 10 minutes

3 readings Total 40 minutes

Module 3 10 minutes
When to use Calculated Columns and Measures 10 minutes
Time Intelligence Function 20 minutes

2 assignments Total 90 minutes

End of week Graded Assessment 60 minutes
Check your Understanding (Ungraded Quiz) 30 minutes

2 discussion prompts Total 60 minutes

Discussion Prompt: Calculated Columns and Measures in Action 30 minutes
Discussion Prompt: Calculated Columns and Measures in Action 30 minutes

In this module, students will delve deeper and acquire skills and knowledge to create comprehensive reports and expanding their knowledge of utilizing DAX operators. They will learn essential skills to utilize diverse visualizations and address problem statements to deliver actionable insights. Furthermore, this module will emphasize the importance of designing and structuring the report to make it relevant for businesses. By mastering these skills, students will acquire the necessary tools to become an expert in the field of business intelligence and contribute to data-driven decision-making.