Anchoring script for student Orientation in university

1.List down Industry domains where Data warehousing technologies have been deployed? 2. List and define the OLAP operations. 3. What are the data integration challenges and how to cater them? OLAP Operations One of the most compelling front-end applications for OLAP is a PC spreadsheet program. Below is the list of some popular operations that are supported by the multidimensional spreadsheet applications. Roll-up Takes the current aggregation level of fact values and does a further aggregation on one or more of the dimensions. Equivalent to doing GROUP BY to this dimension by using attribute hierarchy. Decreases a number of dimensions removes row headers. SELECT [attribute list], SUM [attribute names] FROM [table list] WHERE [condition list] GROUP BY [grouping list]; Drill-down Opposite of roll-up. Summarizes data at a lower level of a dimension hierarchy, thereby viewing data in a more specialized level within a dimension. Increases a number of dimensions adds new headers Slice Performs a selection on one dimension of the given cube, resulting in a sub-cube. Reduces the dimensionality of the cubes.  Sets one or more dimensions to specific values and keeps a subset of dimensions for selected values. Dice  Define a sub-cube by performing a selection of one or more dimensions. Refers to range select condition on one dimension, or to select condition on  more than one dimension. Reduces the number of member values of one or more dimensions. Pivot (or rotate) Rotates the data axis to view the data from different perspectives. Groups data with different dimensions. Drill-across Accesses more than one fact table that is linked by common dimensions. Combines cubes that share one or more dimensions. Drill-through Drill down to the bottom level of a data cube down to its back-end relational tables. Cross-tab Spreadsheet style row/column aggregates.

Third exam Assignment Example | Topics and Well Written Essays - 1000 words

Third exam - Assignment Example John 150.0 16,200.00 523.81 16,723.81 523.81 16,000.00 Romeo Co Stachurski 206.0 22,866.00 437.64 23,303.64 0.00 22,608.85 Total 2374.5 281,396.25 11,584.67 292,711.42 9,598.95 269,788.74 Table 1 Table 1 shows the clients of ABC Consulting, the employees who work with the respective clients, the hours that these clients were billed, the reimbursable expenses (costs billed) relating to each worker, the total billed to each client, and the costs and fees collected from the clients to September 2013. The total hours billed for the month was 2,374.5 hours and the total fees billed excluding reimbursable expenses was $281,396.25. ... total hours billed = 254,665.13 ? 2,374.5 $107.25 Table 2 The information in Table 2 indicates that the overall cost per billable hour of operations for the month of September 2013 was $107.25. Effective Billable Hourly Rate per Worker The effective billable hourly rate per worker is found by dividing the fees collected from each client by the hours billed to that particular client. The effective billable rate for each worker is shown in Table 3. Client Worker Hours Billed Fees Collected ($) Effective billable rate per hour ($) Alpha Co Acevedo 170.0 18,837.37 110.81 Bravo Co Barger 143.5 16,425.01 114.46 Charlie Co Ekundayo 120.0 14,250.00 118.75 Delta Co Fitzgerald 137.0 15,842.40 115.64 Echo Co Fyffe 85.5 12,825.00 150.00 Foxtrot Co Gilbert 112.5 12,150.00 108.00 Golf Co Harmon 98.0 10,780.00 110.00 Hotel Co Hefner 122.0 14,274.00 117.00 India Co Kirchner 150.0 16,560.00 110.40 Juliett Co Madorma 123.5 14,202.50 115.00 Kilo Co Miller 102.0 11,268.04 110.47 Lima Co Myers 122.5 13,4 13.75 109.50 Mike Co Pellek 89.5 12,000.00 134.08 November Co Preston 156.0 16,818.71 107.81 Oscar Co Shahbazi 139.0 15,354.20 110.46 Papa Co Smith 147.5 16,178.91 109.69 Quebec Co St. John 150.0 16,000.00 106.67 Romeo Co Stachurski 206.0 22,608.85 109.75 Table 3 The information in Table 3 indicates that a total of six workers – Gilbert, Myers, Preston, Smith, St. John Stachurski exceeded the $110 benchmark. They achieved effective billable rates of $108, $109.5, $107.81, $109.69, $106.67 and $109.7 per hour respectively, The effective billable rates per hour for September 2013 ranged between $106.67 and $150 and this information suggests that ABC Consulting recovered the company’s overall costs of $107.25 per billable hour on every job except Quebec Co which

Medical Costs in the United States Research Paper

Medical Costs in the United States - Research Paper Example Healthcare costs are on the rise and there seems to be no way for these costs to stop without reform measures. The Problem with Healthcare Spending One problem with healthcare spending is that it is growing faster than the economy and everyone is affected by this change. Whether people use private insurance, Medicare or Medicaid, they will be affected in some way as healthcare costs continue to grow. (Myerson, Nelson, Simpson, and Topoleski (2007). This has put healthcare as a much talked about issue and it is both a social issue and an economic one. According to Healthcare Problems.org, in 2007 about 50 million Americans went without health insurance and about 25 million were considered underinsured. Between 2001 and 2005 health insurance premiums increased by 30% but people’s income only rose about three percent. Today, healthcare expenditures have increased to $2 trillion a year. Over the past four years, the number of people who are now underinsured has reached 60% which m eans that 25 million people are struggling to pay their healthcare bills (â€Å"Healthcare Statistics, â€Å" 2011). The highest rate of underinsured (31%) is in those Americans who make less than $20,000 a year. After doing an informal survey of people I know, many Americans agree that there should be some type of healthcare reform, but most people are not sure how this reform would take place and who would fund it. Employer Based Insurance When people look for a job one of the benefits they look for is health insurance. Many people feel that if the employer offers insurance they will be able to afford to have insurance. Unfortunately, employer supplied healthcare is also suffering because of the rising costs of healthcare. According to a report by Singhal, Stueland, and Ungerman (2011) the Affordable Healthcare Act has created more cost problems for employers and many have limited this benefit for their employees or stopped providing it all together. According to their report, b y 2014, employers will have to make drastic changes in the way they do healthcare. One of these drastic changes is that about 30% of employers will â€Å"probably† stop offering insurance to their employees after 2014 because of the expense. Singhal, Stueland and Ungerman (20010 surveyed employers and predict that if employers stop offering insurance, they may increase their revenues by at least 30%; this makes this option very attractive to employers who are struggling to provide healthcare. Singhal, Stueland, and Ungerman (2011) also state that because of the way that reform is stated, employers are able to limit their social obligation to their employees to offer insurance. The way in which the reform act is written, states that all employees must have some type of insurance, but they do not stipulate that employers have to provide it. The Act states that if the employer does not offer insurance, the individual can apply for â€Å"income-indexed premium and out-of-pocket cost-sharing subsidies† (Singhal, Stueland, and Ungerman, 2011, p.2). The law specifically states that employers with 50 or more employees must offer health insurance to all full time employees or face a fine of $2,000. They also must provide reasonable coverage to all their employees on a similar level. In other words,