Data Analysis and Visualization Course

About Course

Are you ready to unlock a fast track to career advancement with one game-changing skill? Welcome to the empowering world of Microsoft Power BI!

Power BI is not just a tool; it’s a career catalyst, widely cherished by organizations globally for transforming complex data into insightful, decision-driving visuals. Mastering Power BI doesn’t just add a line to your resume—it opens doors to new opportunities and fast-tracks your career growth.

Recommended Course👉🏾 ETL, Data Preparation and Data Cleaning with Power Query

In this Power BI course, we’re starting from the ground up. With my years of teaching experience, I’ve made a knack for translating technical jargon into plain, understandable language. You don’t need to be a tech whiz to thrive here—just bring your curiosity and determination!

Here’s a glimpse of what our journey entails:

Navigating the diverse landscape of the Power BI ecosystem
Harnessing the power of Power Query for efficient data preparation
Constructing compelling visualizations with Power BI that speak louder than numbers
Crafting informative Power BI reports that make an impact
Publishing your Power BI reports online, showcasing your newfound expertise

And there’s so much more awaiting us!

Although, having basic excel knowledge will be helpful. It is not a requirement but I will recommend you enrol for my excel course.

So, are you ready to leap forward in your career? Time waits for no one, and neither should you. Enroll now and let’s embark on this transformative journey towards Power BI mastery together.

Navigating and understanding the Power BI ecosystem.
Utilizing Power Query for efficient data preparation.
Creating compelling visualizations with Power BI.
Building informative and impactful Power BI reports.
Publishing Power BI reports online to showcase your expertise.
Interpreting data in a meaningful way to drive decision-making.
Utilizing Power BI tools to enhance data analysis and visualization.
Acquiring industry-relevant skills to fast-track your career.
Understanding the role of Power BI in data-driven organizations.
Gaining confidence to handle complex data sets and transform them into intuitive reports.

Course Content

Intro to Power BI and Getting Data

Introduction

02:05
Prerequisites

01:36
Power BI and Learning Outcome

01:28
Downloading & Installing Power BI

02:34
Typical Power BI Flow

02:33
Understanding Power BI Desktop User Interface

06:33
Configuring Report Page

05:20
Changing Canvass Background

03:37
Introducing the dataset

04:12
Intro to getting Data into Power BI

02:07
Importing our data into Power BI

05:50
Understanding how Power Query works

08:16
Changing Data Types in Power Query

07:55
Refreshing Data & Reopening Power Query

03:21
Reusing M Queries

03:48

Intro to Data Analysis & Visualization

Intro to Data Analysis & Visualization

06:10
Introduction to Power BI Reporting

05:34
Categorizing Data for Visualization

05:43
Intro to Reporting in Power BI

04:02
Creating Visuals on Power BI Desktop

03:37
Intro to Chart Formatting

04:12
Common Chart Formatting Options

08:04
Changing Visuals

01:56
Creating Additional Visuals

03:47
Intro to Visuals Field Buckets

03:44
Understanding the Axes and Legend

04:11
X axis, Y Axis and Legend Example

02:51
Intro to Small Multiples

01:23
Using Tool Tips

02:39
Small Multiples in Power BI

05:34
Enabling Drilldown

04:30

Creating Power BI Reports

Prepare Data for reporting – add day of week

05:30
Working with Shapes

02:09
Working with Text Boxes

08:15
Displaying Trends with Line Charts

03:25
Visualizing Rank Changes with Ribbon Chart

05:14
Sorting Charts

07:04
Applying Gradient Conditional Formatting

03:51
Reusing Charts and Editing Conditional Formatting

06:08
Editing Visual Interaction

05:38
Using Slicers to Filter Reports

08:04
Synchronizing Slicers

05:00
Intro to Filters Pane

04:04
Visualizing Top N Categories

05:31
Visualizing Bottom N Categories

02:04
Using Tables and Matrix

07:10
Applying Conditional Formatting on Matrix

01:51
Using Power BI Maps

06:41
Creating Report Page Tooltip

06:23
Create Report Page Drillthrough

03:48
Customize Drillthrough Header Text

02:32
Summary of Reports

03:51
Using Decomposition Tree Visual

03:39
Use AI to drilldown decomposition tree

02:29
Using Key Influencer Visual

04:20
Intro to Bookmarks and Selection

05:30
Implementing Bookmarks

08:57
Using Q and A

03:39
Design Report for Mobile View and Prepare to Publish

05:07
Export to PDF and Publish to web

07:52
Wrap up

00:36

Add this certificate to your resume, and be the standout candidate recruiters cannot ignore

Student Ratings & Reviews

No Review Yet

Intermediate
32 Total Enrolled
14 hours Duration
November 20, 2024 Last Updated
Enrollment validity: Lifetime
Certificate of completion

A course by

Ahmed Oyelowo

Data Analyst

Comprehensive video lectures covering all Power BI topics.
Downloadable resources for offline learning and practice.
A step-by-step guide for setting up and navigating the Power BI environment.
Hands-on exercises and real-world examples for practical learning.
Sample data sets for students to practice data manipulation and visualization.
Interactive quizzes to reinforce learning and track progress.
Access to a dedicated online forum or community for peer learning and discussion.
Bonus lectures covering advanced Power BI features.
Certificate of completion to validate the skills acquired.

A computer with internet access: All the course content is online, so you'll need a reliable internet connection to access the materials and download the Power BI software.
Microsoft Power BI Desktop: This is a free software that you'll need to download and install on your computer. We'll cover how to do this in the course.
Basic computer skills: You should be comfortable with using a computer, navigating the internet, and handling files.
An eagerness to learn: No prior knowledge of Power BI or data analysis is required. Just bring your curiosity and willingness to learn something new!
Time commitment: The course is self-paced, but make sure you can dedicate enough time to go through the materials and practice the skills learned.
Excel knowledge (optional): While it's not a requirement, having basic knowledge of Excel or another spreadsheet tool could be helpful, as some concepts might feel familiar.
Access to a Microsoft account: You'll need this to publish your Power BI reports online. If you don't have one, we'll guide you through the process of creating one.
Privacy settings: Ensure your computer allows downloads and installations from trusted sources in order to install Power BI Desktop.

Professionals looking to upskill and fast-track their career in data analysis.
Students pursuing studies in business, IT, or related fields seeking practical skills.
Business owners or managers wanting to make data-driven decisions.
IT professionals keen on expanding their data visualization toolkit.
Career changers venturing into the growing field of data analysis.
Freelancers aiming to offer data visualization services to clients.
Project managers needing to present data in an easy-to-understand format.
Aspiring data scientists or data analysts.
Consultants seeking to improve their reporting capabilities.
Anyone interested in learning a valuable tech skill for personal development.

About Course

Recommended Course👉🏾 ETL, Data Preparation and Data Cleaning with Power Query

What Will You Learn?

Course Content

Intro to Power BI and Getting Data

Introduction

Prerequisites

Power BI and Learning Outcome

Downloading & Installing Power BI

Typical Power BI Flow

Understanding Power BI Desktop User Interface

Configuring Report Page

Changing Canvass Background

Introducing the dataset

Intro to getting Data into Power BI

Importing our data into Power BI

Understanding how Power Query works

Changing Data Types in Power Query

Refreshing Data & Reopening Power Query

Reusing M Queries

Intro to Data Analysis & Visualization

Intro to Data Analysis & Visualization

Introduction to Power BI Reporting

Categorizing Data for Visualization

Intro to Reporting in Power BI

Creating Visuals on Power BI Desktop

Intro to Chart Formatting

Common Chart Formatting Options

Changing Visuals

Creating Additional Visuals

Intro to Visuals Field Buckets

Understanding the Axes and Legend

X axis, Y Axis and Legend Example

Intro to Small Multiples

Using Tool Tips

Small Multiples in Power BI

Enabling Drilldown

Creating Power BI Reports

Prepare Data for reporting – add day of week

Working with Shapes

Working with Text Boxes

Displaying Trends with Line Charts

Visualizing Rank Changes with Ribbon Chart

Sorting Charts

Applying Gradient Conditional Formatting

Reusing Charts and Editing Conditional Formatting

Editing Visual Interaction

Using Slicers to Filter Reports

Synchronizing Slicers

Intro to Filters Pane

Visualizing Top N Categories

Visualizing Bottom N Categories

Using Tables and Matrix

Applying Conditional Formatting on Matrix

Using Power BI Maps

Creating Report Page Tooltip

Create Report Page Drillthrough

Customize Drillthrough Header Text

Summary of Reports

Using Decomposition Tree Visual

Use AI to drilldown decomposition tree

Using Key Influencer Visual

Intro to Bookmarks and Selection

Implementing Bookmarks

Using Q and A

Design Report for Mobile View and Prepare to Publish

Export to PDF and Publish to web

Wrap up

This course offers certificate of completion

Student Ratings & Reviews

Download aptLearn

Platform

Contribute

aptLearn Business