Over the last few years, Excel has been redesigned from the ground up. Currently, Microsoft is making the new Excel core-features available to every user, regardless of your Office 365 license. Thanks to the Microsoft naming conventions, it is easy to confuse the new features with existing ones. That being said, Power Query and Power Pivot are not the same things as Pivot Tables, which you have likely been using for years.…
ContinueAdded by Rafael Knuth on November 28, 2019 at 6:10am — No Comments
I was invited at the recent Microsoft’s Azure Data and AI Tech Immersion event (March 2019) and we played a bit with various tools, including Azure Data Studio and Azure Databricks. The picture below summarizes my understanding of this platform, based on my short experience with it.
ContinueAdded by Vincent Granville on April 3, 2019 at 7:30am — No Comments
Did you know that you can write R and Python code within your T-SQL statements? Machine Learning Services in SQLServer eliminates the need for data movement. Instead of transferring large and sensitive data over the network or losing accuracy with sample csv files, you can have your R/Python code execute within your database. Easily deploy your R/Python code with SQL stored procedures making them accessible in your…
ContinueAdded by Kyle Weller on June 4, 2018 at 7:00am — 4 Comments
E-Commerce has been on the rise with more and more businesses taking to online platforms to reach out to their clientele. Consequently, there has been a significant increase in the number of online spending, which has been due to the increase in the adoption and ownership of mobile devices that has resulted in a shift to the web. As a result, shoppers are always looking out for unmatched shopping experiences. That is, quick access, round-the-clock availability, accessible content and smooth…
ContinueAdded by Tony Branson on November 17, 2016 at 9:00pm — No Comments
Not only SQL (structured query language), also known as NoSQL, is a popular tool used for data management and design of large chunks of distributed data. NoSQL database includes a…
ContinueAdded by Madhuri Pawar on December 30, 2015 at 1:30am — No Comments
Building off my last post, I want to use the same healthcare data to demonstrate the use of R packages. Packages in R are stored in libraries and often are pre-installed, but reaching the next level of skill requires being able to know when to use new packages and what they contain. With that let’s get to our example.
Useful function:…
ContinueAdded by Divya Parmar on November 10, 2015 at 12:36pm — No Comments
Life scientists collect similar type of data on daily basis. Statistical analysis of this data is often performed using SAS programming techniques. Programming for each dataset is a time consuming job. The objective of this paper is to show how SAS programs are created for systematic analysis of raw data to develop a linear regression model for prediction. Then to show how PROC SQL can be used to replace several data steps in the code. Finally to show how SAS macros are created on these…
ContinueAdded by Venu Perla PhD on October 10, 2015 at 9:00am — No Comments
With the rapid growth of data and the shift towards rapid development solutions much data is being stored in NoSQL stores such as Hadoop and MongoDB. The infrastructure built upon relational databases that have been used for decades cannot keep up with the volume and scope of data being captured. Further to this SQL is also a really good invention and method for extracting and analysing data that is very widely used. In short it will not be replaced by hierarchical query techniques…
ContinueAdded by Zygimantas Jacikevicius on September 17, 2015 at 6:06am — No Comments
As the amount of the data grows exponentially and terms such as big data become mainstream, the need to handle all this data has increased. Database skills have become some of the most sought-after in the job market today. SQL, which stands for Structured Query Language and is used for relational databases (RDBMS), is one of those skills. In fact,…
ContinueAdded by Divya Parmar on September 8, 2015 at 9:26am — No Comments
As the size of the database grows database performance becomes critical. Automation is a growing focus for data center operators facing increasingly complex environments. Database administration is complex, repetitive and time consuming. DBAs have to work long hours during off hours downtime. The outage of database costs heavily to the companies and affect their repute.
Shopping engines and online shopping places are highly dependent on database performance. Slower application…
ContinueAdded by Muhammad Saeed on May 9, 2014 at 4:00am — No Comments
The BigObject® - A Computing Engine Designed for Big Data
BigObject® presents an in-place* computing approach, designed to solve the complexity of big data and compute on a real-time basis. The mission of the BigObject® is to deliver affordable computing power, enabling enterprises of all scales to interpret big data. With the advances in what a commodity machine can perform, it…
ContinueAdded by Yuanjen Chen on November 20, 2013 at 5:29pm — No Comments
In general, computer scientists treats code and data in two very different ways. Virtual memory was originally developed to run big programs (code) in small memory, while data are entities kept in external storage and must be retrieved into memory before computing. As a result, today’s application developers think by instinct the programming model based on storage and explicit data retrieval. This model, referred to as storage-based computing, plays an important role and has done a great job…
ContinueAdded by Yuanjen Chen on October 31, 2013 at 7:24pm — No Comments
Added by Michael Walker on October 24, 2012 at 2:43pm — 4 Comments
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
1999
Posted 1 March 2021
© 2021 TechTarget, Inc.
Powered by
Badges | Report an Issue | Privacy Policy | Terms of Service
Most Popular Content on DSC
To not miss this type of content in the future, subscribe to our newsletter.
Other popular resources
Archives: 2008-2014 | 2015-2016 | 2017-2019 | Book 1 | Book 2 | More
Most popular articles