Day 2 and 3
Popular in Info Tech for Business
Popular in Department
verified elite notetaker
This 2 page Class Notes was uploaded by Kathleen Tann on Thursday September 3, 2015. The Class Notes belongs to MANGT 366 at Kansas State University taught by Brian Kovar in Fall 2015. Since its upload, it has received 13 views.
Reviews for Day 2 and 3
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 09/03/15
Day 2 Ch 1 Business Driven Technology Dataraw facts that describe characteristics of an event Without analyzing data it is just a list of numbers and names on the surface Information Data converted into a meaningful context 0 One person s data may be another person s information Just because it is meaningful on my level doesn t mean that it is the same for everyone Go deeper bv runnind Queries Ex Tony s best customer by total sales Least valuable customer by pro t Pivot Tablesprimarv business tool Business Intelligence Anaylsis of data and info from multiple sources to gain comprehensive picture of factors impacting your business 0 Analyze patterns and trends to determine relationships between variables then this leads to predictive analytics 0 Ex Predict the weather so know how it will affect sales 0 Used in decision making 0 Sources suppliers customers competitors business partners data from industry data from government sources 0 Delivering reliable and relevant information and then getting that info to the right people in the right time IT Resources 0 People use IT to work with info 0 People are the best resource 0 IT skills are necessary and important for different areas of study Day 390315 EXCEL Emphasis on functions and formulas like VLOOPUP IF PMT FV Relative and Absolute Cell references Formatting Rules 0 All have to consistent Consistent decimal places 0 Numbers in thousandth places should have a comma Right align columns of numbers 0 sign button is NOT Currency Style It is Accounting 0 Move lable over numbers 0 Use cell ref whenever possible in formulas WhatIF analysis Change 1 assumption and see result Formulas Formulas evaluated left to right 0 Evaluate what is in parentheses rst
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'