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.
Know what you’re working with. Learn how to navigate the various elements of this powerful data analytics tool.
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.
Clean and transform your data with the Query Editor before implementing it in your model, making sure it’s prepped and ready for analysis.
Autodetect and manually create relationships between the tables in your data model using the Relationships view.
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.
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.
See how easily and quickly you can develop a report in Power BI Desktop with only a handful of calculated columns and measures.
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.
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.
These layout best practices will help you design reports and dashboards that are easy for end-users to navigate and use.
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.
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.
How to present your data and how to engage your audience, emphasize your point and exhort to action.
Learn how to use built-in scatter plot to develop a visual that compares product prices from different companies.
Learn how to use color themes in your report.
Learn some Capstone project ideas for you to consider developing.
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.