Pivoting is changing the lens through which you view data…i.e. chaning a product data report with year and country to be by year instead of by product.
Dicing is breaking a large chunk of data up into smaller sections. Creates a subset of data by reducing the dimensions, but can still be more than 1D.
Online Transaction Processing system
Online analytical processing - Slicing, Dicing, Pivoting, Drilling - these are the analytical processes sitting above the data warehouse layer.
More or less detail of the same data
Creates a subset of data by reducing the dimensions to one (i.e. a table)
Explain difference between bits and bytes
bits are individual 1s and zeros. A byte is a grouping of 8 bits. i.e. 64bit system is 8 bytes as the typical smallest addressable memory
explain the dcimal, binary, octal, and hexadecimal numbering systems
decimal is our normal 1-10 system. binary is 1-0 (i.e. 0001 is 1). Octal uses a 0-7 system..(i.e. 1 = 1, 8 = 10).
Hexadecimal uses 0-9 and A-F to encode values (base 16) Hexadecimal 10 = A and 525 = 20D
What are the common forms of character representation
ASCII and Unicode
Define an algorithm
Formula or procedure for solving a problem - or a set of steps followed to complete a computer process.