Microsoft’s Azure cloud services offer a data management platform that raises business analysts to that desired next level.

Image for post
Image for post
Sundance, a data visualization library, is one of many extensions that extend the functionality of Azure Data Studio.

Microsoft has been on a solid run of introducing cloud services over the last few years. The tech giant has been transitioning from its iconic position as the quintessential office productivity software producer to a major player in open source and cloud technology solutions that feel familiar to Office and Window users.

Microsoft’s touchstones in the developer, data science, and IT communities include the investment into GitHub, refining its Visual Studio Code IDE, and positioning Azure services to compete against Amazon AWS and Google Cloud. Its recent release, Azure Data Studio, bolsters a database language long associated with Microsoft among analysts — SQL. In this case, Azure Data Studio provides support for cross platform SQL server. …

The length of video influences viewer engagement, and consequently, how your message is received

Author’s note: This post is a slightly updated version of my Information Week article, published on November 18th, 2019. It has been updated to include new insights since its original publication.

There’s a funny, unspoken aspect about the phrase, rule of thumbs. Those so-called rules change over time.

One marketing rule of thumb — the right video length to engage customers — has been changing. Despite a two-minute rule of thumb that became a rule of thumb among marketers, companies are debating the optimal length to convey a message. …

How the Facebook Ad limit impacts your 2021 marketing strategy

Image for post
Image for post
Photo by author

2020 is proving to be the year in which marketers are recognizing their limits. Social media platforms are also recognizing limits, with the largest even establishing an actual limit.

Facebook is limiting the number of ads marketers can run or have under review from their business pages. The limit is meant to help the platform better serve the ads in the newsfeed. The limit also gives marketers improved budget deployment for their campaigns.

How Ad Limits Will Work on Facebook

The ad limit consists of tiers based upon the spending from each page. The highest spend amount in a month within a rolling 12 month period is weighed against the tier limits. …

No one person will embody all the analytic and data science skills that a manager requests. Here’s what to keep in mind for developing those skills.

Image for post
Image for post

It is wonderful to imagine an analyst hitting the ground running to bring his or her skills to bear on a key problem. The desire for such a person certainly exists, as demand for data analysts and managers have risen over the years. In 2018, LinkedIn reported that job shortages for data science skills intensified between July 2015 and July 2018. According to LinkedIn, any manager in Dallas or Atlanta would have had hiring options back in 2015, but in 2018 both cities ranked among the top 10 that had shortages for data science skills.

Yet the reality is that such a data miracle worker will likely work a few miracles, if at all. No one person will embody all the analytic and data science skills that a manager requests. Managers must be ready to seek candidates who have the right temperament to engage a range of skills, rather than narrow specific skills. Everyday data science and problems demand a breadth of skills. The right person needs to show a breadth of interest because learning and applying the desired skills require working with other professionals as much as it does a mastery of certain topics. …

The COVID-19 pandemic has disrupted marketing messaging and campaigns, but the pause can be an opportunity to adjust content for the changing times. Here are a few ways to approach a renewal

Image for post
Image for post
Image: Pierre DeBois

There are a ton of articles that explain how to get started with content marketing, but what about what happens after a year or two of creating content? Or three? Or even if it has been ignored for longer? The thought alone can leave a small team unmotivated.

Every year marketers face the task of reviewing their content calendar and updating old content. This year looks more complex after a series of major disruptions due to the COVID-19 pandemic and the economic shutdown of retailers. …

Working remotely can create moments of anxiety, especially with IT tech. Here is how to best manage FOMO anxiety among business teams.

Image for post
Image for post
Remote work can often create new challenges in communication that Is difficult to envision

So many professionals across the US have adopted WFH — work from home — as a response to the pandemic. But working remotely has opened the potential for the social media trend Fear of Missing Out (FOMO) to take place in a business environment. IT teams can play a vital role to manage FOMO and keep organizations moving while adapting to this isolating way of working.

To get a handle on how this phenomenon occurs let’s look at how FOMO is defined and experienced. FOMO is an anxious feeling of being left out of other people’s lives. It occurs while viewing social media commentary and posts from other people. Studies and discussions have linked FOMO to a self-feeding pattern in social media usage. People want to connect to other people’s thoughts and feelings through Facebook post, TikTok videos, and Tweets. …

Still not sure how to use Twitter? Here are a few ideas to build an audience or re-engage your followers

Image for post
Image for post
Twitter has become a social media standard for being discovered online. Using all its features can help deepen relationships.

Despite the years since Twitter launched, there remains a considerable number of small business people that do not understand the purpose of Twitter.

Yet as of 2020 half of the world population uses social media for news, sharing thoughts, and announcing events, let alone Twitter. Your next campaign can go from mundane to terrific by reexamining your usage against new features and standard rules. The usage is likely in need of an update, especially since tweet character limits were increased to 280 characters back in 2017. That change heralded the end of Twitter’s iconic 140 character limit. …

Monitoring WatchTime for YouTube video is the best way to build an engaging and, even profitable, video channel

Image for post
Image for post
YouTube has been around for more than a few years. So has the ability to link, to advertise, and to measure engagement. Developing WatchTime of your channel videos is a solid strategy for building an audience and even monetizing your channel.

A growing factor to monitor playbacks in YouTube is the watch time metric. Watch time represents the aggregate amount of time that people spend watching videos in your channel. It is available in YouTube Analytics. YouTube Analytics treat watch time as a primary metric among the standard metrics — impressions, click-through rate, views, and viewer watch time. Watch time influences the YouTube algorithm to optimize search results for videos that have increased their viewer watch time.

Watch time has a value to YouTubers in the same way as another advertising metric, dwell time, has for marketers and advertisers. Dwell time is the amount of time a customer remains in a venue, or in a specific area within a venue. The origins of dwell time comes from television’s golden age, but because YouTube videos can be seen on multiple channels, monitoring watch time is a meaningful proxy for dwell time. You can use it to audit how video content and its associated media is being consumed. …

Selecting the URL is a critical marketing element to your success — here’s what to plan for your website.

Robinson’s URL: “”
Robinson’s URL: “”
Robinson’s in Chicago made a strategic decision to select a URL based on its ribs offering. But businesses must be leery of selecting a URL that does not reflect its other offerings.

URL. Three letters that are very important to businesses online. They are meant to give users a way of connecting to a business through a Website page, social media profile, Web app, or a digital medium.

Often businesses like to include a keyword into the URL. The purpose of the keyword is to draw a site to a higher position on a given search query and become more discoverable to people who are conducting the search. Because the people doing the search are potential customers, businesses consider this strategy a terrific way to attract customers at a low initial cost.

However, words have to be chosen carefully and weighed against how a business operates. Keywords for businesses often are the common products and services they are offering. …

Asking open-ended questions will reveal the right details you need to move your business forward.

Image for post
Image for post
Image Source: WOCinTech

Asking a question about analytics can be daunting. After all, as a manager, you are interested in data, and know that your competition is likely positioning themselves to be data-driven as well.

But how do you ask the right questions that keep your team moving?

To ask great simple questions, you have to understand two dynamics that occur with answers related to analytics.

How The Question Should Be Framed

First asking a simplistic close-ended question may bring a concise answer — close-ended questions trigger a yes or no answer. That answer may be fine if you are pressed for time.

But in the context of digital marketing analytics, an answer to a close-ended question grossly overlooks necessary details that support that answer. Those details can influence your budget considerations and what next steps to take. …


Pierre DeBois

#analytics |#marketing |#JS |#rstat |#SEM services for #smallbiz | #retail | #nonprofits Contrib @CMSWire @smallbiztrends #blackbusiness #BLM

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store