Power BI Data Analysis: For the Power Nerd In You!

Power BI Data Analysis: For the Power Nerd In You!, available at $84.99, has an average rating of 4.55, with 48 lectures, based on 16 reviews, and has 82 subscribers.

You will learn about Learn the basics of Power BI; screen and menu layout options; Connecting to your Data Source; how relationships work. Learn how to use the Power Query Editor and understand the use of the M Language that gets created for you and how to edit that language. Learn the difference beween Calculated Columns vs Measures and use the DAX functional language to build simple and complex formulas. Create interactive and appealing visuals for any report; Learn to use the built-in visuals to display your final results Finally, you will publish your reports to the Power BI Web Service and build your dashboards that you can share with your team members or management. This course is ideal for individuals who are New students who want to get the basics of Power BI or Advanced Excel Users who need to take their visualizations to the next step or Excel Power Query users who need to go to the next level and jump into Power BI It is particularly useful for New students who want to get the basics of Power BI or Advanced Excel Users who need to take their visualizations to the next step or Excel Power Query users who need to go to the next level and jump into Power BI.

Enroll now: Power BI Data Analysis: For the Power Nerd In You!

Summary

Title: Power BI Data Analysis: For the Power Nerd In You!

Price: $84.99

Average Rating: 4.55

Number of Lectures: 48

Number of Published Lectures: 48

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 48

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the basics of Power BI; screen and menu layout options; Connecting to your Data Source; how relationships work.
Learn how to use the Power Query Editor and understand the use of the M Language that gets created for you and how to edit that language.
Learn the difference beween Calculated Columns vs Measures and use the DAX functional language to build simple and complex formulas.
Create interactive and appealing visuals for any report; Learn to use the built-in visuals to display your final results
Finally, you will publish your reports to the Power BI Web Service and build your dashboards that you can share with your team members or management.

Who Should Attend

New students who want to get the basics of Power BI
Advanced Excel Users who need to take their visualizations to the next step
Excel Power Query users who need to go to the next level and jump into Power BI

Target Audiences

New students who want to get the basics of Power BI
Advanced Excel Users who need to take their visualizations to the next step
Excel Power Query users who need to go to the next level and jump into Power BI

As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. At the end of this course, you will be able to create from start to finish interactive reports, insightful dashboards and share your results with colleagues and your management team.

The era of big data has exploded and is already here and learning how to leverage that data effectively and provide timely insights can be a competitive advantage. Creating eye catching visualizations is the way to catch the attention of the management teams that have to make the executive decisions to move your organization forward.

Microsoft Power BI software is designed specifically for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly massage your data, customize your calculations, create eye popping visualizations of that data, show trends, and create interactive reports. Power BI’s is by far the leading software to get all this done.

If you never have opened Power BI before, then this course is for you as it will take you from the beginning to end to get you on your way to becoming a Data Analyst. From learning to connect to your first data source, cleaning your data and creating stunning visualizations, you will gain the confidence to create your very first Power BI report for your management team.

I teach this exact same course content in colleges, institutes, government agencies and corporate clients right across Canada for years and now I am offering it direct to you through these online platforms.

Prior to enrolling in this course, you must have advanced Excel skill set. Having knowledge of the Power Query add-on for Excel or a working knowledge of databases like MS Access or SQL would be an asset but is not required. I will teach you everything you need to know. No knowledge of Power BI is required to take this course, but the willingness to learn is!

I will take you step by step, from start to finish, from connecting to your Data Source, creating the relationships, creating the calculations to determine your KPI’s to putting it all in your reports with stunning visuals. We will then publish to the web service so you can create your dashboards and share with your management team.

You will be ready to create your very own Power BI report and gain the confidence you are doing it right!

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course & Instructor Intro

Lecture 2: Support Notes for Students

Lecture 3: Download Course Resources & PDF Manual

Lecture 4: Contacting the Instructor

Lecture 5: Let's Set Some Expectations

Lecture 6: PDF Manual and Video Correlation

Chapter 2: Data Analysis with Power BI

Lecture 1: Power BI Concepts

Lecture 2: Desktop Interface

Lecture 3: Datasets

Lecture 4: Options, Settings & Updates

Chapter 3: Connecting to your Data

Lecture 1: File & Data Setup

Lecture 2: Connecting to your Data Source

Lecture 3: Relationships

Lecture 4: Creating New Tables

Lecture 5: Import More Data

Lecture 6: Importing Similar CSV Files

Lecture 7: Importing Website Tables

Lecture 8: Adding New Records

Lecture 9: Problem Solving Tips

Lecture 10: Section 3 / Chapter 2 Lesson

Chapter 4: Transforming Your Data

Lecture 1: Power Query Editor (PQE)

Lecture 2: Append Queries

Lecture 3: Merge Queries

Lecture 4: Advanced Editor & M Lanaguage

Lecture 5: Custom & Index Columns

Lecture 6: Section 4 / Lesson 3 Exercise

Chapter 5: Data Modeling with DAX

Lecture 1: What is DAX?

Lecture 2: Calculated Tables

Lecture 3: Calculated Columns

Lecture 4: Calculated Measures

Lecture 5: Variables with DAX

Lecture 6: Problem Solving Tips

Lecture 7: Section 5 / Lesson 4 Exercise

Chapter 6: Visualizations for your Reports

Lecture 1: Visualization Pane

Lecture 2: Types of Visuals

Lecture 3: Creating a Dashboard

Lecture 4: Section 6 / Lesson 5 Exercise

Chapter 7: Interactive Visualizations

Lecture 1: Using Tool Tips

Lecture 2: Hierarchies

Lecture 3: Bookmarks

Lecture 4: Grouping

Lecture 5: Slice & Dice

Lecture 6: Section 7 / Lesson 6 Exercise

Chapter 8: Publishing to the Web Service

Lecture 1: Power BI Web Service

Lecture 2: Publish & Share

Lecture 3: Web Service Dashboards

Chapter 9: Course Project

Lecture 1: Instructor Thank You!

Lecture 2: Power BI Project Exercise

Instructors

Robin Solonenko
Microsoft Instructor

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 6 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu