Question

Answer 50 words long answer for each of the following questions: What are the eight major...

Answer 50 words long answer for each of the following questions:

What are the eight major areas of the model view in Power Business Intelligence (BI)?

What are the four different types of relationship cardinalities that Power BI support?

What is cross filter direction and what are the two types cross filter direction support by Power BI?

What are the two ways to create relationships in Power BI?

What are calculated columns?

When are calculated columns calculated?

What are measures?

When are measures calculated?

What is the measure totals problem?

What are three ways of troubleshooting calculations?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.Ans :

There are various areas where you can apply power bi instead of using traditional mechanisms for Business analytics. It saves a lot of time and labor. Power BI is a set of tools that allow non-technical folks to perform kinds of analytics previously reserved for technical specialists. You can use it in Excel as it comes inbuilt also has a dedicated Power BI desktop. We can also use it with Microsoft cloud as it uses Azure data services. It can also be used in Web Browsers with all kinds of support in all browsers.

2.Ans :

The Business Analytics tool called Power BI supports different types of relationships with each having different cardinality. The four different types of cardinalities that are supported by different relationships in Power BI are : a. One to One b. One to Many c. Many to One d. Many to Many.

3.Ans :

The direction of the relationship means the way that filter propagates in Power BI tool. Cross filter direction is used in the calculation of the relationship that exists between two columns. The Power BI supports Single cross filter direction and also Both cross filter direction to get the relationship calculation.

4.Ans :

There are two ways to create a relationship in Power BI tool for business analytics which decreases the manual effort of all the technical specialists. One way to create a relationship is using the Autodetect. There is also other way to create a relationship which is creating a relationship Manually.

5.Ans :

In Power BI tool the calculated column is defined as an extension of a table using DAX formula that is evaluated for each row. These are different from normal columns. The calculated columns  are computed based on the data that has already been loaded into your data model. These are obtained using Power Query Editor tool.

6.Ans :

There are different reasons to choose calculated columns over measures. We choose to use calculated columns when the measure takes a very long time to process or when using values in a slicer, on an axis, or visual or page or if we need report-level filters or when there are CPU- intensive calculations then to precompute some is better.

7.Ans :

A measure is one of the way to calculate in Power BI tool. A measure is a formula that is evaluated in the context in which it is used. If you use a matrix measure it will be evaluated in the form of row and column. All calculations are not possible with measures as well. SO we also have other approaches.

8.Ans :

Measures can be used in most of the cases for the calculations in Power BI tool. Measures can't take heavy load of the CPU so especially when you need to calculate ratios or minimum maximum or weighted averages we use Measures. These are evaluated at the query time of the calculation of the columns.

9.Ans :

Measures is one of the way used for the calculations for Business Analytics in Power BI tool. If the total of the measures or the weighted average if the measure is not correct or does not tally with the expected results then that kind of result is treated as a wrong result of the measure. So, these are considered as the measure problems.

10.Ans :

There may be times when using Analyze in Power BI that you get an unexpected result, or the feature doesn't work as you expected. There may be different kind of errors as Forbidden errors, Token expired errors or the no data models which means they do not consist the required data these can be used to trouble shoot of all the exceptions encountered.

Add a comment
Know the answer?
Add Answer to:
Answer 50 words long answer for each of the following questions: What are the eight major...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • i need you change my answer use another words , use your own words don't copy...

    i need you change my answer use another words , use your own words don't copy and paste please.. (I want to redraft the solution).. pleaaaaase quqlye please :(((( When we build a new measurement tool as a “questionnaire”, we need to make sure that the questionnaire is “valid” and “reliable”. In this article we will discuss the concept of validity and reliability. The validityRefers to the degree to which a measurement tool “questionnaire” measures what it supposed to measured....

  • n well-developed paragraphs, answer the following questions: 1) What is the 'local' and what is it...

    n well-developed paragraphs, answer the following questions: 1) What is the 'local' and what is it relationship to the 'global' in the context of globalization processes. Provide examples to support your ideas--try to reach beyond the textbook. Cite all sources. 2) What is soft power and how is it communicated effectively? Since we are the leading nation in global consumerism, find examples of soft power from outside the U.S. For example, what nations have soft power influence on American culture?...

  • Answer the following questions in one paragraph (about 50 words) each: 1.) What additional risks and...

    Answer the following questions in one paragraph (about 50 words) each: 1.) What additional risks and rewards exist only in comparison of international business relative to a purely domestic business? 2.) What facet of international business (such as legal, accounting, cultural, or economic) exists only because the business is international instead of purely domestic? 3.) How can a core competency and comparative advantage benefit you? 4.) Do you receive the best value in the domestic market in acquiring the product...

  • Short-Answer Respond to the following in 50 to 75 words each, unless otherwise specified. What is...

    Short-Answer Respond to the following in 50 to 75 words each, unless otherwise specified. What is sociology? What are some examples of what sociologists study? When examining the theoretical perspectives in sociology, each perspective has a specific focus and level of analysis. What does the level of analysis mean? In 25 to 50 words each, describe the focus and level of analysis for the following theoretical perspectives: Symbolic Interactionalism: Functional Analysis: Conflict Theory:   Culture shapes many things in our lives,...

  • please answer this after reading the article What is the actual problem? What are the known...

    please answer this after reading the article What is the actual problem? What are the known facts? What decision is to be made? How the problem ought to be solved? What are the alternatives? What are your recommendations? New AI tools make BI smarter — and more useful Data science democratized: What used to take data scientists months to prepare may soon be put together in a few days by data-astute business users. By Maria Korolov, Contributing Writer, CIO |...

  • Prepare short answer responses (100 words / each question)to the following questions: 1. What are two...

    Prepare short answer responses (100 words / each question)to the following questions: 1. What are two differences between the Federal Anti-kickback Statute and the Stark Law? 2. What is the significance of the Hanlester Case? 3. Regarding the Anti-kickback Statute, what is a "Safe Harbor"? 4. What is the significance of being subject to the Federal Anti-kickback Statute but not meeting the requirements of a Safe Harbor? 5. Regarding the Stark Law, what is an Exception? 6. What is the...

  • Be able to answer the following questions for each of the case studies described below. What...

    Be able to answer the following questions for each of the case studies described below. What additional questions do you have for the client/patient? Why? Calculate IBW, UBW, %IBW, %UBW, BMI and what they mean to nutrition care plan Be able to calculate Energy and protein needs, show your work List a nutrition screening tool that would work well for this population What anthropometrics do you know, what additional information would you like to collect? Why? What additional biochemical markers...

  • 3. Refer to Case Study 1 below to answer the following: What are two ways Cecil...

    3. Refer to Case Study 1 below to answer the following: What are two ways Cecil could work with Joan to establish the best way to support her communication? Case study 1 Joan is a healthy and happy 83-year-old woman. She is moving into the supported accommodation units where Cecil works. Joan is mostly independent and rarely requires much support. She has arthritis, which can affect her mobility. She is moving into the unit because it is physically accessible; it...

  • 1. Each of the following questions requires a brief, but precise, answer. (a) Identify the value...

    1. Each of the following questions requires a brief, but precise, answer. (a) Identify the value of goodwill on the acquiring company’s balance sheet if                   assets acquired is $400, liabilities assumed is $200, and cash spent on the                   acquisition is $500. (b) Which financial ratio compares critical values on the income statement and                   balance sheet and is considered a measure of management performance? (c) Which one of the following statements about corporate bondholders is true?:                   they...

  • Please do not delete the questions. 1. What is the purpose of a database? 2. What...

    Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT