In todays busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time consuming task to pull all of this data together and somehow make sense of this large amount of data.
Microsoft has come up with 2 great tools, PowerQuery and PowerBI, which can help you gather your data, and report on it in many ways.
This course will show you how to gather and manipulate your data using PowerQuery, and then how to make the data visually appealing and dynamic with PowerBI. PowerQuery is really built into the desktop version of PowerBI.
Topics covered: Downloading PowerBI Tour of screen
Importing data from: Excel Normal data Formatted data Text Access SQL Server Web
Building and managing different visuals Adding and managing Slicers Add columns Delete column Merge columns Split columns Date fields Number fields Text fields Conditional columns
Quick measure: Filters Running Total Year to Year Change
I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.
Frequently Asked Questions
It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.
A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.
A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.
We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.
With Buy 1 & Get 2nd At 50% Off