


The course will delve into different metrics used to evaluate effectiveness of websites. Using tools such as Google Analytics you will learn to measure, redesign and improve websites to attract visitors.
#Business intelligence training and certification how to#
You will also learn how to apply analytical techniques to sift through large amounts of data and provide actionable business insights. Topics covered include the principles of dimensional modeling, techniques for extraction of data (ETL) from source systems, data profiling, data transformation methods, data staging and quality, data warehouse implementation, online search engine optimization, online advertising, web metrics, and social media analytics. You will learn how to gather strategic decision making requirements from businesses, develop key performance indicators (KPIs) and corporate performance management metrics, understand how external sources of data (using Web 2.0 technologies and social media sites) can be harnessed to design and implement business dashboards. The objective of this course is to introduce you to Business Intelligence (BI) techniques and understand how to use them to gain insights into emerging social media technologies and deal with "Big Data." You will be exposed to managerial, strategic and technical issues associated with developing and deploying Business Intelligence and Web Analytics Solutions.

The course will cover the most important data mining techniques-classification, clustering, association rule mining, visualization, prediction. Examples of such patterns include fraud detection, consumer behavior and credit approval. It consists of several techniques that aim at discovering rich and interesting patterns that can bring value or “business intelligence” to organizations. Data mining refers to extracting or “mining” knowledge from large amounts of data.

This course will cover data mining for business intelligence. Data mining techniques can help companies discover knowledge and acquire business intelligence from these massive datasets. In addition, the widespread proliferation of economic activity on the Internet leaves behind a rich trail of micro-level data on consumers, their purchases, retailers and their offerings, auction bidding, music sharing, so on and so forth. For example, retailers can easily process and capture millions of transactions every day. Textbook: Peter Rob, Steven Morris and Carlos Coronel, "Database Systems: Design, Implementation and Management", 11th Edition, ISBN: 978-4-5, Course Technology, 2015.Ĭorporations today are said to be data rich but information poor. This course is the pre-requisite for MIS 587. Students will acquire hands-on-experience with a state-of-the-art database management system such as Oracle or Microsoft SQLServer and web-based development tools. Students may be required to work with an organization in understanding their business requirements, developing a detailed set of requirements to support business processes and designing and implementing a web based database application to support their day-to-day business operations and decision making. Topics covered include: conceptual design of databases using the entity relationship model, relational design and normalization, SQL and PL/SQL, web based database design and implementation using Oracle or some other modern Database Management Systems. Emphasis is on practical aspects of business process analysis and the accompanying database design and development. This course introduces the student to fundamentals of database analysis, design and implementation.
