Power Bi Series_ Go Beyond Pivot Tables With Power Pivot

*EDIT: There was a request for more info, not sure what else I can provide... Is the best practice to build or buy an ETL tool? According to best practices, the “ETL Build vs Buy decision” is made once for all ETL tools and all ETL systems in the DWE (not on a case-by-case or system-by-system basis)? DWE = data warehouse environment/client

For the Cities database, discuss one problem with either the correctness of the data or what can be easily done with the data that might occur if each of the following changes were made : • The state attribute of the City table was allowed to be null • The County table was merged into the State table by removing the County table and including a counties column in the State table with the names of the counties, plus a websites column in the State table with the websites for each county. The county column of the City table would just be the name of the county.

Simple one line DB.

please show step by step on excel, new one excel

What is data normalization? Write Advantages of Data Normalization?

You want Excel to automatically apply “stripes” in an alternating pattern to existing raw data in your spreadsheet. Describe the precise steps you could take to do so. What other function would be added when you apply this change, assuming you have a header row and leave the default options selected?

One of the tables that resulted from the DBA denormalizing some of the data in the TAL Distributors database so as to boost performance is as follows: Which field or fields in the Customer table (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, RepName) are responsible for the table no longer being in third normal form? In this scenario, what does the normal form of the denormalized table look like?

You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought).1.1 Business RulesAssumptions for the business model are as follows: • Only customers that have purchased one or more products will exist in the database. • Only…

You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought). 1.1 Business Rules Assumptions for the business model are as follows: Only customers that have purchased one or more products will exist in the database.…

This is an ITSE 2356 course we use Bob Bryla and Iggy Fernandez books as a reference . Case:  As of late, there seems to be a perpetual problem with current database table size growth causing performance problems, --  in that you are at a  point of daily tablesize management. Task: Develop and preapre a plan that will create a reporting process to monitor database growth.(as part of your submittal - write the suggested SQL queries).  Again, this shoud be no less one typed word file.  Also recommend the use of Spooling or some other Oracle print process  for query submital.  Hint: see Chapter 10 for ideas.