Microsoft Power BI Recipes
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
37 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Power BI Recipes to your Wishlist.

Add to Wishlist

Microsoft Power BI Recipes

Discover the world of business analytics using Power BI
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
37 students enrolled
Created by Packt Publishing
Last updated 6/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Know how to get and prepare your data for analysis and visualization
  • Find out how to create relationships between tables in your data model
  • Create calculated columns and measures using the DAX language
  • Get report layout and data visualization best practices
  • Understand which charts/graphs to use depending on the question being answered or the story being told
  • Use shapes to design, emphasize, and tell a story
  • See how to incorporate custom visuals into your reports and dashboards
  • Complete a Power BI data analysis/visual project from start to finish
View Curriculum
Requirements
  • Some experience with Power BI will be useful.
Description

Microsoft Power BI is a suite of tools to analyze your data and extract business insights from it through building interactive dashboards. This video course is your guide to getting the most out of Power BI and will help you solve any problems you might come across while using it.This tutorial contains practical recipes on the various tasks that you can do with Microsoft Power BI—from gathering your data to analyzing it.

You will start with the basic installation and configuration of Power BI Desktop, and go on to connect your data sources with it. You’ll transform and get your data ready for analysis, and create effective data views using it. Then, you will see how you can create stunning reports and dashboards in Power BI.

Finally, the course also contains some handy recipes on troubleshooting various issues in Power BI. We’ll ensure that you have the tricks of the trade in mastering Power BI to get effective visual analytics.

About the Author

Drew Mery is a Data Analyst with hands-on experience in Excel, SQL, and of course Power BI. He loves delivering actionable insight via analytical procedures and data visualization and teaching others to do the same. His passion is driven by the ability to take something raw and unintelligible to the naked eye (raw data) and morph it into something beautiful and insightful that tells a story and helps improve business operations.

That’s where the power of Microsoft Power BI comes into play. Drew has developed numerous reports and dashboards on energy, project management, manufacturing, and sales data both in a full-time/perm and freelance context. Additionally, he has kick-started the implementation of the Power BI platform within an energy supply company, located in central Florida, in order to streamline analysis and more readily communicate operational performance within the organization.

Drew looks forward to continually utilizing this powerful tool in his line of work and he’s thankful to be able to assist others as they develop their own proficiencies in Power BI.

Who is the target audience?
  • This video is for BI professionals, IT managers, or power users who want to get insights from their business data using Microsoft Power BI. Those who are looking for quick solutions to common problems while using Power BI will also find this tutorial a very useful resource.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
02:57:34
+
Get and Prep Data like a Super Nerd
5 Lectures 41:21

This video provides an overview of the entire course

Preview 03:16

Know what you’re working with. Learn how to navigate the various elements of this powerful data analytics tool.

Desktop Layout, Features, and Views
05:41

Discover the ease and power of connecting to common data sources in the business world, such as Excel files, folders, SQL Server, and the web.

Connecting to Common Data sources
11:31

Clean and transform your data with the Query Editor before implementing it in your model, making sure it’s prepped and ready for analysis.

Query Editor Layout and Functionality
14:43

Autodetect and manually create relationships between the tables in your data model using the Relationships view.

Creating Relationships in Your Data Model
06:10
+
Develop Your Data Nerd Prowess
4 Lectures 42:16

Use Power BI Desktop’s built-in aggregations to gain valuable insights in a matter of seconds. Additionally, add calculated lines to your visuals for greater context and insight.

Preview 05:54

Discover the similarity between Excel functions and DAX functions, making it easier to learn DAX if you’re already familiar with Excel. Learn how to create calculated columns and measures.

Calculated Columns and Measures
10:51

See how easily and quickly you can develop a report in Power BI Desktop with only a handful of calculated columns and measures.

A Visual Demonstration
12:50

Go a step further in your DAX skills by learning how to create a cumulative total and moving average. Additionally, get introduced to Quick Measures to help in creating measures and learning DAX.

Some Slightly Advanced Measures
12:41
+
Developing Reports and Dashboards
4 Lectures 45:21

There are way too many junk charts out there. Don’t let yours be one of them. Learn the fundamentals of data viz best practices to present your data clearly and accurately.

Preview 14:32

These layout best practices will help you design reports and dashboards that are easy for end-users to navigate and use.

Report and Dashboard Layout
07:59

Sales analysis reports are very common in the business world. Gain some ideas of how you can develop such a report in Power BI Desktop. Then make your report easily accessible on the go by creating a mobile version.

Creating a Sales Analysis Report
12:35

Project management is booming. As projects get bigger and involve more risk, stakeholders need data analysts who know their stuff. Whether or not you’re involved in project management, you will gain further insight into report ideas and how to best create a mobile version.

Creating a Project Management Report
10:15
+
Tips, Tricks, and Capstone Project
4 Lectures 48:36

How to present your data and how to engage your audience, emphasize your point and exhort to action.

Preview 14:54

Learn how to use built-in scatter plot to develop a visual that compares product prices from different companies.

Thinking Outside the Visual Box
22:36

Learn how to use color themes in your report.

Theme-ing It Up
06:28

Learn some Capstone project ideas for you to consider developing.

Capstone Project
04:38
About the Instructor
Packt Publishing
3.9 Average rating
7,219 Reviews
51,593 Students
616 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.