Analyzing Data with Microsoft Power BI (MS-20778)

Rating:
85% of 100

The main segments of this course involve Power Business Intelligence, Power Business Intelligence mobile applications, and the power of visualization.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

3 Days

Course Duration

3

SATV Value

Course Info

Download PDF

Certificate

See Sample

Timezone
empty table
tab

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

The main segments of this course involve Power Business Intelligence, Power Business Intelligence mobile applications, and the power of visualization.

Course Information

About this course:

The main focus of the MS-20778 course is to offer in-depth knowledge of data analysis with Power BI (Power Business Intelligence). The main segments of this course involve Power Business Intelligence, Power Business Intelligence mobile applications, and the power of visualization.

Candidates who wish to give their career a kick starts should consider taking the course.

On average, a Business Intelligence Analyst earns $60,297 annually.

Course Objective:

At the end of this course, each individual will be able to:

  • Use all that Power Business Intelligence offers
  • Analyze data using Power BI
  • Execute Power BI on desktop data
  • Connect different data stores
  • Use visualizations with Power BI
  • Incorporate Power BI with Excel spreadsheets
  • Use Power BI as a modeling tool
  • Use and implement the Power BI developer API

Audience:

The target audience for this course is the SQL professionals who are responsible for Reports.

Prerequisites:

For this course, you should have a strong understanding of the following concepts:

  • Hands-on experience of working with Microsoft Office applications including Microsoft Excel
  • Experience of working with Report and Relational Database
  • Strong concepts of basic programming such as looping and branching 

Outline

Frequently Asked Questions

Q1. How will this training benefit me in my current job role?


This training will help you in your Job’s current role by learning and getting hands on experience in the following areas:
  • What is Business Intelligence Self Service and the trends which have been followed in the past, and how BI Self Service has evolved into Real Time Analytics.
  • Getting in depth knowledge about Power BI suite of products and how you can use Power BI to support your business model and implement Business Intelligence Solutions.
  • Learn how Power BI can be useful in connecting to various data sources, Importing the data and creating beautiful visualizations through it to make key-business decisions.
  • Get your hands-on Shaping and Combining the data to make your reports more meaningful for data insights and future insights.
  • Learn how to Model your data to support your business model.
  • Explore various visualizations available in Power BI to create powerful reports from different data sources and present them during the meetings to make key-business decisions.
  • You will also learn how you can easily connect to Azure Cloud Platform and get the data into Power BI Desktop and Publish the reports on Power BI Portal/Service or Power BI on Premise report server. Not only you will learn how to connect to Azure Cloud Platform but, also how you can connect to other cloud sources from SaaS providers(Oracle, Apache Hadoop etc.)
  • You will learn how to write Rest API’s to create Power BI mobile app using three REST API’s supported by Power BI for Windows, IOS and Android Operating Systems.
  • View the Dashboards, Reports, Friend’s comments on Power BI mobile app. Share Dashboard tiles with your colleagues and get live data on your mobile apps whenever its updated.

Q2. What is the exam criteria for the course?

Following is the exam criteria/format of this course:

  • Consuming and Transforming Data By using Power BI Desktop: topics from this area which includes: Connecting to data sources, performing transformations and cleansing data will be integral part of the exam. Make sure you are well prepared on how to connect to various data sources from Power BI Desktop to Excel, SQL Azure, SSAS, Big Data and many other different data sources supported by Power BI. You should also be well versed with how to transform the data, apply business rules and change data format to support visualizations. Furthermore, It is important you are good at cleaning and formatting the data to meet business quality requirements.
  • Modeling and Visualizing Data: Topics you will be evaluated in this part of the exam will be: Optimization of Data Models using Power Query, Creation of Calculated Columns, Measures and Tables, Measuring performance of KPI’s through gauge and cards. Creation of Hierarchies, Formatting of Interactive Visualizations and Management of custom reporting solutions.
  • Configure Dashboards, Reports and app in Power BI Service: questions from this section will have approximately 25 to 30% weightage but, may vary as per Microsoft’s policy. In order to make sure you ace this section, Prepare yourself on the following topics: How to access On-Premises Data from Power BI Service, How to configure Dashboard on Power BI Service/Portal, How to publish reports on web which might include publishing it to SharePoint online, one drive for personal and business usage, Configuration of security for dashboards, reports and apps and how to configure apps and apps workspace in Power BI Service/Portal.

Q3. What is Power BI certification?

Microsoft Power BI is a suite of tools to analyze your data and extract business insights from it through building interactive dashboards. This Power BI Training course will help you get the most out of Power BI, enabling you to solve business problems and improve operations.

Q4. Once the Power BI Report is Published to the cloud, Can it be refreshed?

Yes, By using gateways the Power BI Reports can be refreshed after they are published to cloud.

Q5. How many types of filters are available in Power BI Reports?

Three types of filters are available in Power BI Reports, and they are:

  • Report-level Filters
  • Visual-level Filters
  • Page-level Filters

Q6. What is the purpose of Power Query in Power BI?

Power Query is a mashup and data processing software which is mainly used to connect various data sources. The output that is generated by Power Query can either go to Power BI or Excel

Q5. What does rank function do?

RANK function calculates the regular competition rank and returns the identical values. In the second argument, you can ask for Ascending or Descending values accordingly.

Q6. What does MID function do?

MID function returns the string characters from the specified index position. On the string, it can be possible to extract the number of positions that we required to have.

Q7. What is a slicer in terms of Business Intelligence ?

It is a canvas visual channel which is utilized in Power BI work area where clients who are survey can section the report by utilizing esteems like geometric district ,it is one of the significant channel in representation.

Q8. What is the contrast among SUM and SUMX in DAX work?

Total capacity takes the sections of information and total it and will give the aggregate however sumX capacity gives you a chance to channel the information which you are including

Q9. What is Natural language search choice in Power BI? A characteristic language-based learning for communicate with information as a feature of the Power BI for Office 365 advertising. As you type your inquiry picks the best perception to show your answer; and the representation changes powerfully as you alter the inquiry. Likewise causes you group your inquiry with recommendations, auto-complete, and spelling amendments.

Q10. What are the various sources that you worked away at ?

Power BI bolsters huge scope of information sources. You can snap get information and it demonstrates to all of you the accessible information associations. It enables you to associate with various level files, SQL database, and Azure cloud or even web stages, for example, Facebook, Google Analytics, and Salesforce objects.

More Information

More Information
Brand Microsoft
Subjects Big Data, Business Productivity
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Learning Type Course
Difficulty Intermediate
Course Duration 3 Days
Language English
SATV Value 3
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Expert:

Author

Tom Robertson
(Data Science Enthusiast)

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.

Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.

Customer Reviews
  1. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    80%
    Quality of Instructor
    80%
    Course Quality
    80%
    The overall course was great. Easy to follow. Splitting the labs was beneficial.

    Review by

    Posted on

  2. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    60%
    Quality of Instructor
    60%
    Course Quality
    60%
    Good class but sub par labs. The lab was really slow especially when accessing power bi from the web browser. No issues on the desktop version.

    Review by

    Posted on

  3. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    80%
    Quality of Instructor
    80%
    Course Quality
    80%
    Great training for the beginner with limited familiarity with data and Power BI in general.

    Review by

    Posted on

  4. Analyzing Data with Power BI (MS-20778)
    The labs are horrible. There is a crazy lag with every lab you take, there needs to be a better way to take the labs and have the VM sped up.

    Review by

    Posted on

  5. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Quality
    100%
    Overall the content was very good, but the labs took too much time and focused on importing the data. I would prefer that be walked through with the instructor and more time focused on making the data do the amazing things Power BI can do.

    Review by

    Posted on

  6. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    60%
    Quality of Instructor
    80%
    Course Quality
    20%
    There were several challenges on day one regarding connection, access, and the phone that caused a lot of heartburn. Several people had issues creating accounts for power bi which took several hours to resolve. There was also an issue with the phone connection so people who did not call in could not speak. To no fault of the instructor, he couldn't help us with several issues because he didn't have the same view as the students. Once we got going with the training and material, too much time was spent making database connections instead of really using power bi. This was not useful for us. These shouldn't have been part of the labs but rather just part of the instruction.

    Review by

    Posted on

  7. Analyzing Data with Power BI (MS-20778)
    Quality of Instructor
    80%
    Course Quality
    40%
    The instruction was very good. The course format was somewhat difficult ­ I ran into issues completing multiple labs (and thanks again to the instructor for walking us through the labs when we needed direction or a workaround). Overall, the QuickStart experience was difficult and confusing. I received multiple, contradictory emails several days before and on the morning of the first class. The URLs in those emails did not work, and I tried multiple times to reach the phone numbers listed in those emails and on the QuickStart site and never reached anyone. (The recording at the main QuickStart number says it will connect you with a representative, and then does not connect you.) Joining Day 1 was very difficult for everyone in the class, and we got a very late start as a result.

    Review by

    Posted on

  8. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    100%
    Quality of Instructor
    80%
    Course Quality
    80%
    Overall was a great coarse. Leaving with more knowledge and a better understanding .

    Review by

    Posted on

  9. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    60%
    Quality of Instructor
    100%
    Course Quality
    60%
    Personally, I learn better with an in class instructor rather than online. There were a lot of technical issues with loading the data for this course.

    Review by

    Posted on

  10. Analyzing Data with Power BI (MS-20778)
    Overall Satisfaction
    60%
    Quality of Instructor
    60%
    Course Quality
    40%
    An agenda would've been helpful to set expectations of the class. I would have preferred a slower pace. Overall, I gained some perspective of the functionality of PowerBI.

    Review by

    Posted on

  11. Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    It was cool to see a real time grab of data from the web and see it manipulated in Power BI. Really helps to bring the class into a real world situation.

    Review by

    Posted on

  12. Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I enjoy the classes from QuickStart. I always learn so much more than trying to read the manuals on my own. The instructors are always great and always answer any questions we have and try to put the class into real world scenarios.

    Review by

    Posted on

  13. Course Quality
    60%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    60%
    Very knowledgeable about PowerBi.

    Review by

    Posted on

  14. Course Quality
    60%
    Course Value
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    60%
    Clearly explained the topics.

    Review by

    Posted on

  15. Course Quality
    60%
    Course Value
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    60%
    QuickStart offers good classes which will benefit the students in their current work and future career.

    Review by

    Posted on

  16. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Overall, it's a good experience with this training.

    Review by

    Posted on

  17. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Trainer is knowledgeable of the course.

    Review by

    Posted on

  18. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    This is a LIVE training, so, it is much much better. Please continue having LIVE trainings at quickstart. Thank you

    Review by

    Posted on

  19. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Great instructor, answered all questions clearly.

    Review by

    Posted on

  20. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    The instructor was the added value to the course, courseware was weak, however the Dr. Garcia brought it alive and made it current to our needs.

    Review by

    Posted on

  21. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Great training. Excellent Instructor.

    Review by

    Posted on

  22. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Excellent Instructor. Very knowledgeable and experienced. Great demeanor.

    Review by

    Posted on

  23. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Good course, senior instructional expert, satisfied.

    Review by

    Posted on

  24. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Dr. Garcia is an excellent instructor. He conveyed training that was easy to understand using examples that were effective real world scenarios.

    Review by

    Posted on

  25. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I enjoyed the instructor? lots of practical experience. He answered the questions and provided additional guidance.

    Review by

    Posted on

  26. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Nothing much to say other than it was a good course and excellent instructor.

    Review by

    Posted on

  27. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    60%
    I felt that Abdullah presented real world situations. I liked the fact that he showed that sometimes you sometimes have to look for what you want to do, because Microsoft keeps changing things. They didn't edit the video to show it as a "perfect" ­ real life situation. It actually made me more comfortable, when I start actively working in Power BI.

    Review by

    Posted on

  28. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Kept up well with a product that is constantly changing.

    Review by

    Posted on

  29. Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    I was really pleased with the addition of screen shot in the labs. It made it much easier to tell if I was on track or getting lost.

    Review by

    Posted on

  30. Course Quality
    60%
    Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    60%
    Instructor was very pleasant.

    Review by

    Posted on

  31. Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Very clear instruction.

    Review by

    Posted on

  32. Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    The courses are good.

    Review by

    Posted on

  33. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    Good job! Keep up the good work.

    Review by

    Posted on

  34. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    A must­have course for data enthusiasts!

    Review by

    Posted on

  35. Course Quality
    60%
    Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Instructor was knowledgable and amicable.

    Review by

    Posted on

  36. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Very knowledgeable on the subject matter. always made sure we didn't have any questions before continuing on with the content. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  37. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  38. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  39. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on