1 / 28

Chapter 10: Business Intelligence

Chapter 10: Business Intelligence. Analysis of App Sales Data. Agenda. Business Picture Business Intelligence Query Big Picture into Meaningful Data Looking at Queries conceptually How to Run the Queries in MS-Access. Big Picture Business Intelligence.

derron
Download Presentation

Chapter 10: Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 10: Business Intelligence Analysis of App Sales Data

  2. Agenda • Business Picture Business Intelligence • Query Big Picture into Meaningful Data • Looking at Queries conceptually • How to Run the Queries in MS-Access

  3. Big Picture Business Intelligence

  4. Summarize data to produce useful information

  5. Kiva BI

  6. BI systems deliver accurate, useful information for making decisions

  7. Data turns into information through the BI process

  8. Drill down in dashboards to access more information http://centerview.corda.com/corda/dashboards/MarketingSegmentation/main.dashxml#cordaDash=3000 http://centerview.corda.com/corda/dashboards/RetailSales/main.dashxml#cordaDash=0001 Retail Sales Dashboard Market Segmentation Dashboard

  9. Data Stored in the Class App and Sales Tables

  10. Even simple databases support complex functionality

  11. Utilize data compiled in Data Warehouse Company Databases Business Intelligence (BI) Reporting/Data Mining Database A Decision Support Systems (DSS) Database B Data Warehouse Database C Expert Systems (ES) Database D Artificial Intelligence (AI) Database E

  12. Query Big Picture into Meaningful Data

  13. Top Selling Apps

  14. Top Selling Apps Cont.

  15. Top Selling Apps on MS Access

  16. Cross-Selling Apps Step 1

  17. Cross Selling Apps Step 2

  18. Cross Selling Apps Step 2 continued

  19. Cross Selling Apps on MS Access Step 1 Add the table twice, then draw a connection from buyer to buyer.

  20. Cross Selling Apps on MS Access Step 2

  21. Competitive Data Analysis

  22. Summary/Conclusion • Business intelligence is a way of uncovering trends and patterns in data to help with business decisions • Most companies already have the data needed for business intelligence. However, analyzing the data, presenting the results, and then following through on where the data leads, differentiates companies in a competitive environment. • Static reports, dynamic reports, and data mining are three different forms of business intelligence.

  23. Summary/Conclusion • Multiple corporate databases feed into a large data warehouse, where data can be queried. • The greatest sin in database design is allowing duplicate data. Duplicate data should not be stored in a database because it has the potential to become inconsistent--sometimes one value, sometimes another. • The higher up a manager is in the organization, the less detail he or she needs to see in the data. In fact, details only becomes important to an upper manager when they are needed to explain an unexpected trend.

  24. Unnecessary Slides These slides are only unnecessary if you do not feel the need to go over Access in class, if so, we can fit them into the Powerpoint.

  25. Relational Database from the Class App Store

  26. How to Run the Queries in MS-Access

  27. Cross-Sell Step 1: Purchased Together – Join the File to Itself

  28. Cross-Sell Step 2: Group and Count the Records

More Related