Leveraging Blackboard Analytics and Tableau for Data Visualization

Create insightful visualizations on student admissions using Blackboard Analytics and Tableau, accessing real-time data and examining OLAP sources. Learn how to efficiently manage and view data for identifying trends in enrollment strategies. Gain a deeper understanding of data-driven decision management for effective business governance.

• Data Visualization
• Blackboard Analytics
• Tableau
• OLAP
• Data-Driven Decisions

channing Follow

Uploaded on Aug 05, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. DATA VISUALIZATIONS USING BLACKBOARD ANALYTICS AND TABLEAU

2. PRESENTERS Kris Krishnan CSUB, Office of Institutional Research, Planning & Assessment Michael Bullis CSUB, Information Technology Services

3. OVERVIEW Creating insightful and impactful Tableau visualizations on student admissions, using Blackboard Analytics Using this process users can access real-time" information Examine OLAP (Online Analytical Processing) data sources

4. PROVIDING A CONTEXT Managing the volume, variety and velocity of data is critically important to its value, but also of importance is finding ways to organize and view the information to actually be able to identify trends and shifts that might otherwise go unnoticed. Enrollment managers can use this data to direct and assess the strategies imposed for growing their student number efficiently and effectively. The challenge is finding a way to express the data in an efficient way that can be easily read and understood.

6. SURVEY Who here has Tableau? Who here has Tableau connecting over a live connection? Who here has built or has any kind of ETL platform in place? Is anyone familiar with OLAP? Is this a term you have never heard? Glad you are here!

7. TECHNICAL OVERVIEW Blackboard Analytics vs Tableau ETL OLAP Perspective

8. DATA = AN EXERCISE OF INSANITY Cost Ad-hoc reporting We all share (and contribute) this insanity

9. DATA DATA-DRIVEN DECISION DRIVEN DECISION MANAGEMENT an approach to business governance that values decisions that can be backed up with verifiable data. The success of the data-driven approach is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation. (https://whatis.techtarget.com/definition/data-driven-decision-management-DDDM) "quality of the data gathered "effectiveness of its analysis and interpretation Having the right hammer for the job

10. METHODOLOGIES Manual to Automation Report Evolution ETL model Star Schemas

11. STAR SCHEMAS

12. PERFORMANCE BOTTLENECKS Relational database reporting The OLAP layer

13. https://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/00/62/41/metablogapi/4578.Cube_thumb_117FF4CD.jpghttps://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/00/62/41/metablogapi/4578.Cube_thumb_117FF4CD.jpg

14. IMPLEMENTING ETL WITH OLAP Technological OLAP platform irrelevant Costs: Time, Money and knowledge requirements

15. ENTER BLACKBOARD ANALYTICS AND TABLEAU We have both. A long story on how we got here.

16. BLACKBOARD PROS: Provides a running start Lessened knowledge requirements Delivered as a turnkey solution Pyramid front end Demo Time? Full ETL development platform

18. BLACKBOARD CONS: Pyramid Learning Curve One Size Fits All Overwhelming

19. TABLEAU PROS: Look at it, it's beautiful! Data source connectivity: Microsoft Excel,Text File,Microsoft Access,JSON File,PDF File,Spatial File,Statistical File,Other Files,Tableau Server or Tableau Online Actian Matrix,Actian Vectorwise,Amazon Athena,Amazon Aurora,Amazon EMR Hadoop Hive,Amazon Redshift,Anaplan,Apache Drill Aster Database,Box,,Cloudera Hadoop,Denodo,Dropbox,Exasol,Firebird,Google Analytics,Google BigQuery,Google Cloud SQL Google Sheets,Hortonworks Hadoop Hive,IBM BigInsights,IBM DB2,IBM PDA (Netezza),Intuit QuickBooks Online,Kognitio,MapR Hadoop Hive Marketo,MarkLogic,MemSQL,Microsoft Analysis Services,Microsoft PowerPivot,Microsoft SQL Server,MonetDB,MongoDB BI Connector MySQL,OData,OneDrive,Oracle,Oracle Eloqua,Oracle Essbase,Pivotal Greenplum,PostgreSQL,Presto,Progress OpenEdge,Salesforce Splunk,SAP HANA,SAP NetWeaver Business Warehouse,SAP Sybase ASE,SAP Sybase IQ,ServiceNow ITSM,SharePoint Lists,Snowflake Spark SQL,Teradata,Teradata OLAP Connector,TIBCO Data Virtualization (Cisco Information Server),Vertica,Web Data Connector Other Databases (JDBC),Other Databases (ODBC)

20. TABLEAU CONS: "Next generation" visualization tool No ETL development platform It is a barebone system Data extracts and Relational database live connection

21. THE WIN WIN SITUATION OLAP live connection from Tableau to Blackboard Simple to set up Flexibility

22. IS OLAP DEAD?

23. CONCLUSION Dashboards and data analysis can be enormous tools for enrollment management. Identifying the institutional activities that increase the likelihood of enrollment will allow you to enhance your recruitment strategies. Dashboards won t answer every question OLAP connections provide speed and flexibility