Skip to main content

Home/ SCSU Analytics/ Group items tagged data

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Chris Stanley

Purdue News - College students working out at campus gyms get better grades - 0 views

www.purdue.edu/...us-gyms-get-better-grades.html

studentsuccess analytics

shared by Chris Stanley on 06 Oct 14 - No Cached
  • Home Current issue Submit info Subscribe Archive About us
  • "Students who worked out at Purdue's gym at least once a week were more likely to earn a higher grade point average than students who visited less or not at all,"
  • the more than 1,820 students who visit Purdue's France A. Córdova Recreational Sports Center at least 16 times a month earned a GPA of 3.10 or higher. The correlation between grades and gym use also is shown with moderate users. Students who used the gym at least seven times a month had an average GPA of 3.06
  • ...1 more annotation...
  • At Purdue, registered dietitians are on staff to discuss nutrition, and students have access to personal trainers and fitness consultants. Representatives from the Student Wellness Office are also onsite.
  • Chris Stanley on 06 Oct 14
     
    " Home Current issue Submit info Subscribe Archive About us"
Chris Stanley

Moving Your SQL Databases to Azure - Things to Know - The Microsoft MVP Award Program B... - 0 views

blogs.msdn.com/...s-to-azure-things-to-know.aspx

sql azuresql azure cloud bi

shared by Chris Stanley on 21 Sep 15 - No Cached
  • COMPARISON WITH ON-PREMAzure SQL is SQL Server behind the scenes, so most of the functionality is already there including tables, views, stored procedures, triggers, functions, primary and foreign keys and clustered indexes.
  • Of course there is no Windows authentication, and it currently uses SQL authentication only.
  • There is no to need maintain, balance, upgrade or patch the server as this is all done by Microsoft.
  • ...14 more annotations...
  • You also can't reboot the server, so if you end up with a runaway query you may have to open a support ticket.
  • There are always 3 copies of the database for high availability during disaster recovery.
  • There is a requirement for tables in a SQL Azure database to have a clustered index. This is necessary to keep the 3 copies of the database in sync.
  • The maximum SQL Azure database size is currently 500GB, but you can get around this using SQL federations and partitioning your data across multiple nodes.
  • There are a number of partially supported and unsupported features. A few of the ones I run into regularly are:• You cannot use the USE [databasename] sql statement. You must physically switch between databases in your application. • Remove from indexes - NOT FOR REPLICATION• Remove from your tables - WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] You can review a full list of unsupported features here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/
  • When I migrate a database from SQL to SQL Azure, I typically follow this process using SSMS: • Create a blank database on the SQL Azure database server• Generate the scripts from the original database to create the database objects, excluding users• Do a find and replace to remove any unsupported features such as the two mentioned above• Run the create database object scripts against the new SQL Azure database• Create the users and apply permissions for the new database• Use SSMS or SSIS to copy the data over to the new database.
  • The SQL Database Management Portal is a web based, scaled down version of SSMS. You can create objects, and run queries and execution plans. But there is no GUI interface for some of the security features like creating users and logins. I find that it's a friendlier experience to create the database server in the portal, and do everything else using SSMS.
  • SQL Azure databases are protected by an automatic backup system.
  • The length of time the backups are retained depends on what tier you buy – 7 days for Basic, 14 days for Standard and 35 days for Premium.
  • The point-in-time restore is a self-service feature that costs you nothing unless you use it. If you use it, you pay regular rates for the new database that gets restored. You get all of the protection without any additional cost.
  • SECURITY You are in complete control the IP specific access to SQL Azure Database, at both the server AND database level. No one has access by default.
  • every time your IP changes, you have to update your firewall rules.
  • SERVICE TIERS AND PERFORMANCE LEVELS There are three tiers, with several levels of performance within them. I will summarize the Microsoft definitions.• Basic: Best suited for a small size database, supporting typically one single active operation at a given time.• Standard: The go-to option for most cloud applications, supporting multiple concurrent queries.• Premium: Designed for high transactional volume, supporting a large number of concurrent users and requiring the highest level of business continuity capabilities.
  • Costs can range anywhere from $7 per month for the Basic tier, $19 - $183 per month for a 250GB database in the Standard tier, to $566 to $8500 per month in the Premium tier.
Chris Stanley

"No More Excuses": Michael M. Crow on Analytics (EDUCAUSE Review) | EDUCAUSE.edu - 0 views

www.educause.edu/...cuses-michael-m-crow-analytics

ctf analytics educause bi data edu20 powerbi

shared by Chris Stanley on 08 Aug 14 - No Cached
  • ombining the highest levels of academic excellence, inclusiveness to a broad demographic, and maximum societal impact.
  • the number of first-time, full-time, low-income Arizona freshmen increased 647 percent from FY2003 through FY2011
  • President Crow attributes much of this success to the use of analytics.
  • ...20 more annotations...
  • If you are instead trying to educate a broader spectrum of the population, including elite students, and you aren't using analytics, you won't know what's going on.
  • use of analytics is being driven by the objective of student success
  • at ASU, you've created a culture of innovation using analytics.
  • We've had distinguished professors in the hard sciences, such as physics, say they feel ashamed that for thirty years they didn't know why certain students were learning or weren't learning. They had no idea of the reasons
  • we have infinitely more information to allow us to help students be successful. Analytics are not the end. They are the means to the end: the successful world-class university graduate who has come to us from any family, any background, any income level.
  • Crow: For us, to be a public university means engaging the demographic complexity of our society as a whole. It means understanding that demographic complexity. It means designing the institution to deal with that demographic complexity. And it means accepting highly differentiated types of intelligence: analytical intelligence, emotional intelligence. Students are not of one type but are of many, many types.
  • At ASU, I could see that we would not be able to innovate fast enough without analytics. Without analytics, we can't understand what's going on, we can't understand the complexity of what we're trying to do, and we can't measure our progress. We needed tools to help us make better decisions—about everything. How should we design academic advising? How should we design individual courses? How should we design the overall pedagogical structure of the institution? Every facet of the institution requires robust analytics.
  • Crow: Our biggest problem has been that launching an analytical tool that is not 100 percent reliable creates tension and frustration and anger in the institution.
  • We wanted an academic advisor or a student affairs dean or an associate dean to be able to have a 360-degree analytical view of a student
  • FERPA is concerned with the university releasing information outside of the institution
  • And so, with the right training and the right controls and the right discipline, we were able to build this 360 analytical tool, which has been remarkably helpful for us in terms of creating a new way to advise students.
  • partly motivated by the Virginia Tech shooting incident,
  • At ASU, we are all responsible for the care, well-being, and success of our students.
  • It can't be just the English department or just the football team that is aware of unusual behavior, with no other campus department knowing.
  • We need to be graduating 90 percent, but we can't do that without enhanced analytics,
  • when the federal government calculates graduation rates, it calculates rates only for first-time, full-time freshmen. It does not calculate whether or not students actually graduate from somewhere else. It does not count transfer students who ultimately graduate. So we have a grossly underreported performance from some institutions, creating bad data that then goes into bad policymaking. We need more flexibility and more adaptability, and we need more recognition that students are moving around.
  • There are no more excuses. If you use these analytical tools, you will know where you are, you will know what you're doing, you will know if what you are doing is working or not, and therefore you will know whether or not you need to be doing new things customized to fit your particular school or your particular demographic to be successful. We are underutilizing these tools.
  • We're trying to change from the old agricultural cycle—or whatever it is that semesters are currently based on, because nobody really knows—to cycles based on learning outcomes. That might mean a course could take two years and other courses could take three weeks. How can we allow students to individualize their learning in a structured institution?
  • Crow: We're next headed away from hard, confined definitions of learning timeframes.
  • Allow them to game and simulate their academic careers, and allow them to engage 24/7 academic advice without having to speak to an academic advisor. That's where we've found the most positive impact.
Chris Stanley

The Popularity of Data Analysis Software | r4stats.com - 0 views

r4stats.com/popularity

software statistics r data analytics appsanywhere

shared by Chris Stanley on 02 Sep 14 - No Cached
  • R resides in an interestingly large gap between the other domain-specific languages, SAS and SPSS. R has not only caught up with SPSS, but surpassed it with around 50% more job postings. MATLAB has many similarities to R so it’s interesting to see that it has only around half the job postings. Note that these are specific to analtyics and MATLAB has many engineering jobs that are not counted in this total.
  • SAS is still far ahead of R in analytics job postings
  • Figure 2a shows the number of articles found for each software package for all the years that Google Scholar can search. SPSS is by far the most dominant package, likely due to its balance between power and ease-of-use. SAS has around half as many, followed by MATLAB and R.
  • ...2 more annotations...
  • Minitab, Systat and JMP are all growing but at a much lower rate than either R or Stata.
  • R still dominates the discussions on the more statistically-oriented forums
Chris Stanley

Azure Machine Learning "Hello World" using R - Concurrency, Inc. - 0 views

www.concurrency.com/...e-learning-hello-world-using-r

azure machine learning ml data bi r statistics analytics

shared by Chris Stanley on 28 Aug 14 - No Cached
  • am going to show you a very simple experiement where I will create a very basic “Hello World” program using R script. Yes! This is another advantage of Azure ML studio that you can incorporate your R scripts and create a knowledge management system for your company.
Chris Stanley

Partners Say New Azure Machine Learning Service Could Be Microsoft's Secret Weapon In T... - 0 views

www.crn.com/...secret-weapon-in-the-cloud.htm

azure machine learning microsoft cloud statistics bi data analytics

shared by Chris Stanley on 28 Aug 14 - No Cached
  • Azure Machine Learning is a public cloud-based service that lets developers embed predictive analytics into their applications
  • Machine learning software has been around for years but isn't easy to use or deploy, and it's also expensive, Sirosh said. Packaging up machine-learning-as-a-cloud service solves these problems, and by being first to bring it to market, Microsoft has a head start on the likes of Google, Amazon and IBM, he said. "I think, on this particular front, that we are the leaders," Sirosh told CRN.   
  • Hiring Sirosh was something of a coup for Microsoft. He joined last July from Amazon, where he spent close to nine years as a vice president in various machine-learning-related roles.
‹ Previous 21 - 40 of 42 Next ›
Showing 20▼ items per page