Category: Datawarehousing

Feed: Actian. Author: Pradeep Bhanot. Abraham Lincoln is quoted as saying, “If I had 8 hours to chop down a tree, I would spend 6 sharpening my axe.”  Spending 75% of the allotted time on preparation may seem like a lot, but in fact, most industry observers report that preparing data for business analysis or machine learning is indeed 70 to 80% of the time spent by data scientists and analysts.The data preparation pipeline consists of the following steps Access the data. Ingest (or Fetch) the data. Cleanse the data. Format the data. Combine the data. And finally, Analyze the ... Read More

Feed: R-bloggers. Author: George Pipis. [This article was first published on R – Predictive Hacks, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Need to Connect R with SQL It is common for Data Analysts/Scientists to connect R with SQL. For that reason, there exist many different packages designed for different Databases like PostgreSQL, MySQL etc. My suggestion is to work with the DBI package which is compatible with almost all the Databases ... Read More

Feed: Recent Announcements. AWS Lake Formation is a service that makes it easy to set up a secure data lake in days. A data lake is a centralized, curated, and secured repository that stores all your data, both in its original form and prepared for analysis. A data lake enables you to break down data silos and combine different types of analytics to gain insights and guide better business decisions.   Creating a data lake with Lake Formation is as simple as defining where your data resides and what data access and security policies you want to apply. Lake Formation ... Read More

Feed: AWS Big Data Blog. This is a guest post from ZS. In their own words, “ZS is a professional services firm that works closely with companies to help develop and deliver products and solutions that drive customer value and company results. ZS engagements involve a blend of technology, consulting, analytics, and operations, and are targeted toward improving the commercial experience for clients.”This blog is about the approaches evaluated and eventually chosen for ZS’s cloud transformation journey specifically for adoption of Amazon Redshift from prior Teradata based data warehousing solution. ZS, a professional services firm that works side by side ... Read More

Feed: Teradata Blog. Gartner recently published this year’s Digital Marketing Hype Cycle, 2020 with “Customer Journey Analytics” and “Real-Time Marketing” both at the Peak of Inflated Expectations.  Inevitably, these two CX use cases will move into the Trough of Disillusionment as impatience for results and failure to deliver expected financial returns set in. This blog profiles early adopters for both Customer Journey Analytics and Real-Time Marketing who overcame initial hurdles and realized superior business outcomes.  By learning from these pioneers, you can reduce risk and accelerate value for your digital marketing initiatives.  Real-Time Marketing The relevancy and fit of offers ... Read More

Feed: Alation. Author: Nolan Necoechea. Nolan Necoechea Alation, data catalog, data collaboration, data culture September 22, 2020— In case you somehow missed it, last week Alation’s partner Snowflake, leading provider of cloud-based data warehousing solutions, had the biggest tech IPO of 2020. While everyone has Snowflake on the brain, we figured it might be a good time to remind you that Alation and Snowflake go together like hot cocoa and a snowy day. Enterprises investing in Snowflake for the flexibility and cost savings of a modern cloud data warehouse see a huge boost in analyst productivity and data culture with ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Starting this month, we have merged the Power BI Desktop, Service and Mobile blogs, so there is one overview of everything that is new in this month. Many thanks to Sujata and Nikhil for owning the Desktop and Service/Mobile blogs! We are planning several other changes to the blog, so stay tuned. After 10 years, support for Windows 7 ended on January 14, 2020. In line with this, we will be stopping support for Power BI Desktop on Windows 7 on Jan 31st 2021. After that, Power BI Desktop ... Read More

Feed: Teradata Blog. I probably visit my local petrol station (service station, or even gas station for my American friends) on average between ten and twelve times a week. I do this despite living just three kilometers from the center of Dublin. My neighbourhood has great restaurants, shops and supermarkets. We recently went back to being a single-car-family because of how low our car usage. We even went green(er) – choosing a plug-in hybrid. So why do I, and people like me, frequent the petrol station so often?Data from UK Forecourt Market Report 2020 show that fewer than one in ... Read More

Feed: Teradata Blog. The dire statistics on the COVID-19 epidemic had me go on a tailspin of worry, anxiety, and frenzied reaction. I was buying masks, disinfecting the hell out of everything that I would touch and generally being the stay at home wallflower that did not quite come naturally to me. All this in direct response to headlines and statistics that essentially promised a life filled in purgatory if I did not take the right precautions now.  To be clear, the COVID-19 pandemic is indeed dangerous. It ought to be taken seriously; and it is likely to cause immense personal, ... Read More

Feed: Actian. Author: Pradeep Bhanot. The ISO 17788 Cloud Computing Overview and Vocabulary standard defines a hybrid cloud as “a cloud deployment model using at least two different cloud deployment models.”  When we talk about different deployment models, we are talking about private clouds, public clouds with multiple different cloud providers, and even legacy applications.  When the different deployment models are combined, the multi-hybrid cloud is created.  The multi-hybrid model allows businesses to optimize their operations.Competitive Advantage When a business employs a private and public cloud, they can make careful decisions regarding what applications and services are deployed to each ... Read More