Archive for September 2015

Data Warehouse and Business Intelligence

NIM : 1304505113
Major / Faculty : IT Engineering / Engineering
College : Udayana University
Lecturer : I Putu Agus Eka Pratama S.T.,M.T
1. Data Warehouse & Business Intelligence
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating analytical reports for knowledge workers throughout the enterprise. Examples of reports could range from annual and quarterly comparisons and trends to detailed daily sales analyses.

Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. The goal of BI is to allow for the easy interpretation of these large volumes of data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.
2. Artificial Intelligence and Business Intelligence
Artificial intelligence (AI)
is technology and a branch of computer science that studies and develops intelligent machines and software. Major AI researchers and textbooks define the field as the study and design of intelligent agents, where an intelligent agent is a system that perceives its environment and takes actions that maximize its chances of success.

Business intelligence (BI)
is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle large amounts of information to help identify and develop new opportunities. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.  

3. Business Intelligence,Data Warehouse,OLAP,Data Warehouse,Open Data 

OLAP (On-line Analytical Processing)
OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).

Open Data
       Open data is often focused on non-textual material such as maps, genomes, connectomes, chemical compounds, mathematical and scientific formulae, medical data and practice, bioscience and biodiversity. Problems often arise because these are commercially valuable or can be aggregated into works of value. Access to, or re-use of, the data is controlled by organisations, both public and private. Control may be through access restrictions, licenses, copyright, patents and charges for access or re-use. Advocates of open data argue that these restrictions are against the communal good and that these data should be made available without restriction or fee. In addition, it is important that the data are re-usable without requiring further permission, though the types of re-use (such as the creation of derivative works) may be controlled by a license. 

Business intelligence (BI) 
Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. The goal of BI is to allow for the easy interpretation of these large volumes of data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.

Data Warehouse
        Data Warehouse is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

 3. Data Warehouses Architecture
a. Central Architecture
Centralized Architecture with data centering from all clients 

b. Federated Architecture
Architecture that where data is saved in different databases storage and each client has different databases storage
c.Tiered Architecture
Tiered Architecture is architecture that data spread from one data warehouse or tiered database. Data is only centered and edited step by step from that tier
 


Author : Rega Comments : 0

Install Prestashop on Windows 10

NIM :1304505113
Faculty/Major : Engineering/IT Engineering
College : Udayana University

  1. Download and unzip the PrestaShop package if you haven't already.
  2. Create a database for PrestaShop shop on your web server if it is possible. In case there is no MySQL user who has all privileges for accessing and modifying this database, create it as well.
  3. Upload the PrestaShop files and folders to the chosen location on your web server. Do not upload the root /prestashop folder directly: only the files and folders that it contains.
  4. Run the PrestaShop installation script by accessing the public URL for the chosen location in a web browser. This should be the URL where you uploaded the PrestaShop files.
  5. Follow the instructions on each screen of the installer.
  6. Once the installation is done, delete the /install folder and write down the new of the /admin folder, which has been generated in order to be unique to you, for security reasons.


Follow the picture below


Author : Rega Comments : 0

Enterprise Resource Planning and Relations to the Others


NIM :1304505113
Faculty/Major : Engineering/IT Engineering
College : Udayana University
Lecturer : I Putu Agus Eka Pratama, S.T.,M.T.
 

Enterprise Resource Planning (ERP) is is business management software—typically a suite of integrated applications—that a company can use to collect, store, manage and interpret data from many business activities, including:

    Product planning, cost
    Manufacturing or service delivery
    Marketing and sales
    Inventory management
    Shipping and payment

ERP provides an integrated view of core business processes, often in real-time, using common databases maintained by a database management system. ERP systems track business resources,cash, raw materials, production capacity—and the status of business commitments: orders, purchase orders, and payroll. The applications that make up the system share data across the various departments (manufacturing, purchasing, sales, accounting, etc.) that provide the data.

E-commerce (also written as e-Commerce, eCommerce or similar variants), short for electronic commerce, is trading in products or services using computer networks, such as the Internet. Electronic commerce draws on technologies such as mobile commerce, electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange (EDI), inventory management systems, and automated data collection systems. Modern electronic commerce typically uses the World Wide Web for at least one part of the transaction's life cycle, although it may also use other technologies such as e-mail.
E-commerce businesses may employ some or all of the following:
  • Online shopping web sites for retail sales direct to consumers
  • Providing or participating in online marketplaces, which process third-party business-to-consumer or consumer-to-consumer sales
  • Business-to-business buying and selling
  • Gathering and using demographic data through web contacts and social media
  • Business-to-business electronic data interchange
  • Marketing to prospective and established customers by e-mail or fax (for example, with newsletters)
  • Engaging in pretail for launching new products and services
Electronic business, or e-business, is the application of information and communication technologies (ICT) in support of all the activities of business. Commerce constitutes the exchange of products and services between businesses, groups and individuals and can be seen as one of the essential activities of any business. Electronic commerce focuses on the use of ICT to enable the external activities and relationships of the business with individuals, groups and other businesses or e business refers to business with help of internet i.e. doing business with the help of internet network. The term "e-business" was coined by IBM's marketing and Internet team in 1996.

Over The Top is a technology on used to approaching and modeling for video and audio streaming,messaging,and social networking, using internet provider connection based on mobile. OTT running on application layer,the highest layer on TCP/OP model or OSI. (I Putu Agus Eka Pratama, S.T.,M.T.)
In broadcasting, over-the-top content (OTT) refers to delivery of audio, video, and other media over the Internet without the involvement of a multiple-system operator in the control or distribution of the content. The Internet provider may be aware of the contents of the Internet Protocol packets but is not responsible for, nor able to control, the viewing abilities, copyrights, and/or other redistribution of the content.



Cloud Computing is a computerization system based by network/internet,where a source,software,information and application available for other computer who need to use it. Why is it called Cloud? because this can be assumed a big cloud  and there's much computer or user on it and connected,so cloud computing can be defined as a computerization based by many computers that were connected

Source :
Agus Eka Pratama, S.T.,M.T, I Putu. 2014. Smart City Beserta Cloud Computing dan Teknologi-Teknologi Pendukung Lainnya. Bandung: Informatika.

Agus Eka Pratama, S.T.,M.T, I Putu. 2014. Handbook Jaringan Komputer Teori dan Praktik Berbasiskan Open Source. Bandung: Informatika.

https://en.wikipedia.org/wiki/E-commerce
https://en.wikipedia.org/wiki/Electronic_business
 
Author : Rega Comments : 0

- Copyright © Rega's - Powered by Blogger -