I am an experienced technical and business writer. My topics are IT, clouds, digital transformation, data science, and programming. I write about technology for tech professionals and executives.
The most difficult thing about choosing the right analytics tool is creating an apples-to-apples comparison.
If you’ve combed through multiple reviews and they only added to your doubts, we’re here to help. Both Tableau and Power BI are great business intelligence tools, but by understanding what each of them can do, you’ll be better prepared to pick the right one.
Tableau established itself long before Power BI was developed. Tableau remains widely popular among a...
If you use HubSpot, you know it captures a ton of data about your customers, marketing campaigns, and so much more. And while native HubSpot reporting is a great way to get started, you’re likely to find yourself thirsty for more detail if that’s all you use.
But there’s good news: by ingesting HubSpot data into external storage and running SQL queries, you can pull much, much more out of your data. We’ll show you how.
Table of contents
Why is SQL so great?
We know, our love for SQ...
HubSpot is a leading platform for inbound marketing, sales, and customer relationship management. With HubSpot, you can get exhaustive data on your marketing efforts.
But that same data can be exhausting, whether due to the sheer volume of information you have to wade through or due to limitations in HubSpot’s native reporting.
If you’re a SQL lover—or just someone who’s frustrated by not being able to break out your email performance by day of week or time of day—we’re here to help. We’ll wa...
We were so fascinated by the recent developments among the extract-transform-load (ETL) tools that we decided to write a few lines about the most interesting ones. Such as Airflow: another offspring of the Apache Software Foundation.
Why and how did it manage into the list of important data engineering skills? When would you use it and in which configuration? What do you need to start?
Origin of the Problem
The market for data pipelines automation and orchestration software is booming. Simila...
We continue to watch the most intriguing IT trends and explain any misconceptions around them.
Testing automation started with huge excitement. Gradually, a lot of developers began to ask themselves: “I write a code, I write a code to test a code. Where is the automation here??”
Indeed, automated tests need to be thought through and well-prepared to make them work for you. A few best practices and a new promising trend in the automation field.
Preparing Your Automated Tests
Automated tests ar...
It is unclear which one emerged first but most of us will probably agree that the term “software-as-a-service” (SaaS) was the first one to become widely used.
Little by little, more and more XaaS’ appeared on the stage, with all possible letters instead of the X. It’s one of these IT trends that suddenly become overly popular with main concepts remaining vaguely defined. We find this trend very promising and intriguing but we recognize the need to dive a bit deeper into it.
XaaS as a Business...
Becoming a data architect is an attractive career goal: you earn serious money, you have a weight in your organization, you do things that change the work of others.
In this article, we will describe the differences between the two job titles — engineer and architect — and focus on evolving from one role into another.
Main Differences: Vision vs Hands-On Tasks
If we put it in a nutshell, then, basically, a data architect is the biggest data boss in the company who leads engineers, scientists,...
Out-of-the-Box or Custom CDP: Which One Fits Your Business?
Customer data platforms: building a custom one vs. buying a vendor solution. Learn about the advantages and obstacles of both implementation approaches.
Customer relations, customer journey, customer tracking … Shouldn’t there be a way to bring these ingredients together for a blockbuster marketing attack?
What Is Customer Data Platform (CDP)?
CDP solutions have settled in the analytics market just recently. Their architectures are q...
I am totally convinced that everyone can be good (and earn good money!) only in the job they like doing. If you are bored by your tasks and have to force yourself every day, you cannot deliver quality results.
But if data science makes you feel warm and light, then you have chosen the right door to open. How do you know it exactly?
You Like to See Your Code Growing
Or your dashboard, your pipeline, or whatever you are building. You feel like an artisan looking at his creation and enjoying its...
Learn how to modernize your business applications and achieve high flexibility with the hybrid cloud approach.
When you start to hear about delays, broken schedules, and unresponsive servers in your company, it’s time for a digital transformation.
And even if everybody talks about clouds, you may be cautious about moving your entire IT system into a cloud. We want to suggest a reliable compromise: a hybrid cloud approach.
The hybrid cloud approach allows you to use the synergy of on-premise a...
There are 7 easy steps to efficient workflow automation. Bonus: Why automate and which questions do you need to ask before starting.
Workflow automation isn’t only about making things move faster. It’s about keeping your business processes systematic, transparent, and easy to manage.
Why use workflow automation and how to complete the transition successfully: Read on to learn the answers.
A typical workflow automation example is an approval process. What does it look like prior ...
Cutover, Staged, or Hybrid: Understanding Migration Types
Learn how to decide on the right type of cloud or data migration and choose between cutover, stages, and hybrid.
Cloud or data migration may become a breakthrough for your company. Each business needs a unique migration scenario to make this innovation work for a profit.
Your employees enjoined using the same CRM or ERP for years, even despite its quirks. But one day, the clumsiness of it grew unbearable for the business.
That’s how co...
In my life, I’ve got to know quite a few people who came home after school, programmed fancy little applications instead of doing their homework, and then ended up working as software developers. They inspired me to learn Python on my own. I want to share my learning methods that are based on moving from simple memorizing through reverse engineering to independent coding.
I also want to pay your attention to a vast amount of open and freely accessible online knowledge — blogs, communities, op...
Recently, I have worked for a customer who needed a tutorial involving data from a (non-existing) IoT company. I created a test dataset since all available open-source ones were not exactly a match. This inspired me for writing another tutorial: the one you are reading.
Although the existing Python Faker package does a good job in creating fake datasets it does not cover such a use case as time series data.
What are the specifics of time series?
timestamps are semi-random: they ...