Microsoft Power BI - The Practical Guide [2023 EDITION]
What you'll learn
- At the end of this course students will be able to analyse data from different data sources and create their own datasets
- Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
- Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features
- For the majority of the course you must have a computer with Windows as operating system
- Basic understanding of data analysis is a plus but not required
- For multiple modules of this course a work or school email address is required to sign up
COURSE UPDATE INFORMATION
This course was completely updated (= re-recorded) in 2022 to reflect the latest Power BI Desktop, Power BI Pro and Power BI Mobile changes that took place recently. Enjoy this 100% up-to-date course!
This course also comes with two paths which you can take: The "complete" path (full >15h course) and the "summary" path (~2h summary module) - you can choose the path that best fits your time requirements! :-)
You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?
Then the Power BI tools are the tools to choose for you!
In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.
This is what you will learn:
Get to know the different tools of the Power BI universe and learn how to use them
Understand Power BI Desktop and its components
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
Learn how to filter and format data, how pivoting and unpivoting works
How to work in the different views of the Data Model
How to create calculated columns and measures
How to build relationships between different tables
How to create a report with different interactive visualization types
Learn how to use Power BI Pro to create dashboards and to share and publish your results
How to access your results from multiple devices using Power BI Mobile
This is what this course offers, but is this the right course for you?
...never worked with the Power BI tools before
...have a basic understanding of selected tools of the Power BI universe and want to learn how these tools work together
...want to understand the latest updated version of Power BI Pro, including "My Workspace", Collaboration Workspaces and Apps
...then this is the right course for you.
I would be really happy to welcome you in this course!
Who this course is for:
- People who never worked with Power BI and who want to understand how to use these tools
- Anyone who is interested in learning how to connect the different Power BI tools with each other
- People who want to understand how to create customized visuals with the Power BI Developer tools
Having worked as a business analyst in both a major consultancy and an investment bank, I always found myself confronted with both various and complex problem sets and challenging client demands. The rapid development of technology and business requirements forces everyone to constantly adapt and to continue learning.
Being an early adopter of new and quickly evolving tools, I always enjoyed both learning these tools and passing on my knowledge to my colleagues and fellow students.
Since working as a business analyst implies a high affinity to programming, I also enjoy working as a web developer. It's that combination of self-taught knowledge and its application in a highly competitive consulting environment for various clients which gave me the ability to evaluate solutions from an industry perspective as well as from a learner's perspective. The latter also allows me to identify the pain points students might hit when learning these tools.
Since I always found it hard to find high quality, understandable and comprehensive learning materials, I decided to create such materials on my own. Together with Maximilian Schwarzmüller I founded Academind to offer the best possible learning experience on web development and data science to our more than 2.000,000 students.
Bundling the courses and know how of successful instructors, Academind strives to deliver high quality online education.
Online Education, Real-Life Success - that's what Academind stands for. Learn topics like web development, data analyses and more in a fun and engaging way.
We've taught more than 2,000,000 students on a broad variety of topics. We'd love to teach you as well! :)
Experience as (Web) Developer
Starting out at the age of 12 I never stopped learning new programming skills and languages. Early I started creating websites for friends and just for fun as well. Besides web development I also explored Python and other non-web-only languages. This passion has since lasted and lead to my decision of working as a freelance web developer and consultant. The success and fun I have in this job is immense and really keeps that passion burningly alive.
Starting web development on the backend (PHP with Laravel, NodeJS, Python) I also became more and more of a frontend developer using modern frameworks like React, Angular or VueJS in a lot of projects. I love both worlds nowadays!
I also build full-stack applications and acquired expert DevOps and cloud computing knowledge - proven by the many AWS certifications I hold (incl. the top-level Solutions Architect Professional certification).
As a self-taught developer I had the chance to broaden my horizon by studying Business Administration where I hold a Master's degree. That enabled me to work in a major strategy consultancy as well as a bank. While learning, that I enjoy development more than these fields, the time in this sector greatly improved my overall experience and skills.
Experience as Instructor
As a self-taught professional I really know the hard parts and the difficult topics when learning new or improving on already-known languages. This background and experience enables me to focus on the most relevant key concepts and topics. My track record of many 5-star rated courses and more than 2,000,000 students on Udemy is the best proof for that.
Whether working as development instructor or teaching Business Administration I always received great feedback. The most rewarding experience is to see how people find new, better jobs, build awesome web applications, acquire amazing projects or simply enjoy their hobby with the help of my content.
Together with Manuel Lorenz, I founded Academind to offer the best possible learning experience to our more than 2,000,000 students.