70 likes | 217 Views
Fall 2016 business intelligence. Dr. P. Dileepan. What is Business Intelligence ?. Objectives Course objective 1 Course objective 2 Course objective 3 Results Expected results Skills developed Skill 1 Skill 2. Why do organizations need business intelligence?. Objectives
E N D
Fall 2016business intelligence Dr. P. Dileepan
What is Business Intelligence? • Objectives • Course objective 1 • Course objective 2 • Course objective 3 • Results • Expected results • Skills developed • Skill 1 • Skill 2
Why do organizations need business intelligence? • Objectives • Course objective 1 • Course objective 2 • Course objective 3 • Results • Expected results • Skills developed • Skill 1 • Skill 2
What are typical reporting applications? • Objectives • Course objective 1 • Course objective 2 • Course objective 3 • Results • Expected results • Skills developed • Skill 1 • Skill 2
What are typical data-mining applications? • Objectives • Course objective 1 • Course objective 2 • Course objective 3 • Results • Expected results • Skills developed • Skill 1 • Skill 2
Objectives • Microsoft BI • Load data from various sources • Cleaning and loading data using Power Query • Understanding PowerPivot Data Model • Using DAX and preparing business reports • Preparing visualizations using Power View • Tableau • Loading and connecting data • Preparing visualizations and dashboards • Preparing storyboards
Brief History of BI • 1960s • Production Scheduling applications • Production Planning (MRP) • Mini-computers and Management Information System • 1970s • Management Decision Systems • Decision Support Systems • Product, promotion, pricing and advertising decisions • Preparing visualizations using Power View • 1980s • Personal, Group and Organizational DSS • Model, Data, Communication and Document driven DSS • 1990s • Web based DSS