• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Monthly Archives: October 2020

Chris Rock To Open Up On Busta Rhymes’ New Album ‘Extinction Level 2: The Wrath of God’

October 31, 2020   Humor

Chris Rock is an artist favorite when it comes to being on their albums. He has been tapped by many artists to lend his comedic wit to many classic albums. Now, he is set to feature on the intro track to the new Busta Rhymes album, Extinction Level 2: The Wrath of God.

Busta shared the album tracklist on Monday. Rock is set to be on “E.L.E. 2 Intro” alongside Rakim and Pete Rock.

 Chris Rock To Open Up On Busta Rhymes’ New Album ‘Extinction Level 2: The Wrath of God’

The 2020 BET Hip Hop Awards Winners Announced; Megan Thee Stallion Biggest Winner

truTV Launches New Comedic Cooking Competition Series Titled ‘Fast Foodies’

Let’s block ads! (Why?)

The Humor Mill

Read More

Enhance Dynamics 365 CRM & Power Apps productivity with 1 Click Inogic productivity Apps!

October 31, 2020   CRM News and Info

xEnhance Dynamics 365 CRM Power Apps productivity with 1 Click Inogic productivity Apps 625x357.jpg.pagespeed.ic.WFMmR hHqa Enhance Dynamics 365 CRM & Power Apps productivity with 1 Click Inogic productivity Apps!

Today, you will find innumerable productivity apps that are available in the market which will help you to enhance Dynamics 365 CRM productivity in one way or another. But it seems quite tedious to search and find the right app for your organization. To make your search easy, we will shed light on some of the popular productivity apps that will enhance your Dynamics 365 CRM/Power Apps productivity.

Now to make it interesting, let’s follow the everyday routine of a Dynamics 365 CRM user – Dan who is a Sales Manager at Apex Tech Ltd. – who has quite a few productivity apps installed in his CRM to ease the workload of daily mundane activities.

Everyday, Dan has to deal with a huge amount of customer data. And while dealing with such humungous data, he finds it quite frustrating when the data entered in CRM is incorrect and he has to rectify it. To overcome this, he makes use of Click2Undo (Preferred App on Microsoft AppSource) – 1 Click productivity app to undo changes and restore records in Dynamics 365 CRM/Power Apps. With Click2Undo at his disposal, Dan can now undo the last changes made to the record, changes done in the past and restore deleted record with just 1 Click. The long hours and effort required to rectify these accidental mistakes is now done with just a few clicks making his day more productive and fruitful.

600x278xEnhance Dynamics 365 CRM Power Apps productivity with 1 Click Inogic productivity Apps 1 625x290.png.pagespeed.ic.C7sPDzYyjQ Enhance Dynamics 365 CRM & Power Apps productivity with 1 Click Inogic productivity Apps!

The next task that Dan has to do is to create Quotes, Opportunities, etc. in Dynamics 365 CRM. Many times, there are more than 100-line items that he finds quite tiresome to deal with. For this, he now uses Click2Clone (Preferred App on Microsoft AppSource) – 1 Click productivity app to Clone/Copy Dynamics 365 CRM records. With Click2Clone, Dan can now clone parent-child records, clone/copy multiple records, copy records from one entity to another, create multiple copies of any given record, etc. in just a single click. It has significantly reduced the amount of time spent by him on repetitive data entry.

600x338xEnhance Dynamics 365 CRM Power Apps productivity with 1 Click Inogic productivity Apps 2 625x352.png.pagespeed.ic.bbup59S6pP Enhance Dynamics 365 CRM & Power Apps productivity with 1 Click Inogic productivity Apps!

Once all the records are created, Dan finds it difficult to export these data in a format of his choice and send it to the customers. To overcome this, Dan now uses Click2Export (Preferred App on Microsoft AppSource) – 1 Click productivity app to Export & Email Report/CRM View/Word/Excel templates. With Click2Export, Dan can now export Dynamics 365 CRM data in five different file formats – PDF, Word, Excel, CSV and TIFF. He can email the exported files to customers, save it as note attachments, download it or upload it to SharePoint with just 1 Click. He no longer has to spend hours extracting reports from Dynamics 365 CRM. Just a few clicks and his work is done.

Enhance Dynamics 365 CRM Power Apps productivity with 1 Click Inogic productivity Apps 3.png.pagespeed.ce.EZMsmJFT29 Enhance Dynamics 365 CRM & Power Apps productivity with 1 Click Inogic productivity Apps!

Dan, with the use of these three 1 Click productivity apps was able to increase his efficiency in dealing with mundane day-to-day activities and improve his overall productivity.

That’s not it, Kanban View or Mind Map View within Dynamics 365 CRM – Make your Choice to Maximize Business Productivity!

Go to our website or Microsoft AppSource and download them for a free trial of 15 days.

Feel free to contact us at crm@inogic.com for any queries or personal demo on any of these 1 click productivity apps.

Until then – Stay Safe, Stay Healthy!

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

Read More

truTV Launches New Comedic Cooking Competition Series Titled ‘Fast Foodies’

October 30, 2020   Humor
 truTV Launches New Comedic Cooking Competition Series Titled ‘Fast Foodies’

truTV has ordered 10 episodes of the tongue-and-cheek cooking competition series “Fast Foodies.” In each episode, “Top Chef” winners Kristen Kish, Jeremy Ford and “Iron Chef” winner Justin Sutherland invite a celebrity guest to bring their favorite fast food item to the restaurant as they compete to perfectly recreate and then skillfully reimagine the dish.

From double burgers to Hawaiian pizza and sausage muffins, these culinary masters are ready to showcase their love of pop culture fast food legends and their expert skills to win the Chompionship Trophy. Celebrity guests include Joel McHale (“Community”), James Van Der Beek (“Bad Hair”), Andy Richter (“Conan”), Amanda Seales (“Insecure”), Ron Funches (“Top Secret Videos”), Charlotte McKinney (“Fantasy Island”), Kevin Heffernan & Steve Lemme (“Tacoma FD”), Fortune Feimster (“Sweet & Salty”), GaTa (“Dave”), and Bobby Lee (“Splitting Up Together”).

“This show is equal parts food, comedy and raucous debauchery,” said Corie Henson, executive vice president, head of unscripted programming for TBS, TNT, and truTV. “The stakes have never been lower, but it’s a blast to spend the night with Kristen, Jeremy and Justin, and you’ll never look at your favorite fast food the same way again after seeing the works of art these three culinary geniuses are creating every week.”

“’Fast Foodies’ is an intoxicating new cooking show featuring your favorite celebrities’ guilty pleasure eats,” said Dan Peirson and Lisa Shannon, Senior Vice Presidents of Programming and Development, both of Shed Media. They added, “The series will be a culinary extravaganza with a fresh perspective on food and lots of fun interaction from your favorite reality show chefs and tv personalities.”

“Honestly, we think this is a series that people have been craving — a cooking show where the food is relatable and inspirational while also being hilarious and not full of itself,” said executive producer Michael Rucker. “With Kristen, Jeremy and Justin, we found three hosts, who are not only lovers of fast food and magician chefs in the kitchen, but alongside our celebrity guests, they know how to throw a hilarious dinner party that you won’t soon forget.”

“Fast Foodies” produced by Shed Media, with Dan Peirson and Lisa Shannon serving as executive producers, along with Michael Rucker and Julie Golden. Rucker also serves as showrunner.

Chris Rock To Open Up On Busta Rhymes’ New Album ‘Extinction Level 2: The Wrath of God’

Let’s block ads! (Why?)

The Humor Mill

Read More

What Makes the Perfect CRM Record?

October 30, 2020   Microsoft Dynamics CRM
crmnav What Makes the Perfect CRM Record?

 Want to be a better data-driven marketer? Your Microsoft Dynamics CRM is a great place to lay that foundation!

Let’s get started by talking about what makes your perfect CRM record. This will be unique for every business, but there are some guidelines you can use to start your thinking and planning processes:

  • Sales and Marketing Alignment—how closely are the sales and marketing teams working together right now?
  • CRM Architecture—is there a person who can help you understand how your CRM is structured right now, and why it’s structured that way? Learn more about your CRM advocate here.
  • What are your key marketing goals for this year?
  • Do you have insight into how your marketing efforts are influencing sales success?
  • What campaigns are on your agenda for the coming year?

Now Let’s Talk Data!

Once you have answered the above questions, the next step in your data-driven marketing journey is to understand your Customer Journey. Gather your sales, marketing, and customer success teams for a mapping session (you can use our handy map to get started). This can get pretty unwieldy if you try to map all of your journeys at the same time, so we recommend starting with your most successful lead source—is it conferences? Paid search? Referrals? The journey will be unique to each source.

As you map your Customer Journey, you’ll probably notice there are gaps or sticking points where things aren’t working quite as well as they should. Take note of this, marketers! This is where you can apply marketing automation tasks to address those problem areas.

Start Building Your Customer Journey with Our Handy Worksheet >

With your problem areas in mind, you can create a data map that addresses the following items for each campaign type you want to run:

  • What do you want to achieve with this campaign?
  • What will data points do you need to run this campaign?
  • How are you going to get these data points?

Let’s Make the Perfect CRM Record!

Out of the box, your Microsoft Dynamics CRM records will have a standard set of contact fields—but the beauty of Microsoft Dynamics is that you can also create custom fields designed to capture the data points you need for your unique business.

Before you ask for new data fields, talk to your CRM and sales teams to understand what fields are currently capture and which of those are required versus recommended versus optional. In general, a marketing team will need the following fields:

  • The basics (name, company, title, email address, etc.)
  • Marketing Lists
  • Lead Source (required field!)
  • Source Campaign (required field!)
  • Record Owner and email address
  • Contract dates
  • Competitor Entity data
  • Industry
  • Purchase data (Product Entity or custom fields)
  • Status data (Opportunity, Lead, etc.)

Should You Use the Lead Entity?

That’s really a personal question—B2B organizations might find it easier to keep track of the sales qualified lead to opportunity pipeline using the Lead Entity, but plenty of other organizations struggle with the fact that the Leads Entity doesn’t translate as well to the Opportunity stage—if, for example, you have three or four leads attached to a single Account and Opportunity, it can be difficult to “qualify” all associated Lead records in a single batch.

There are lots of opinions on this, so try to let your sales process guide the conversation and make the technology match what you need to track rather than the other way around.

Other Than Custom Fields, What Do You Need?

Once you create the custom fields you need to power your marketing campaigns, you may want to look into workflows, flows and process to automate your data from Microsoft Dynamics to your marketing automation platform. You might base this off of:

  • What’s the current path to conversion in Microsoft Dynamics? Does it match your desire path on the Customer Journey?
  • Where are there opportunities to automate data flow?
  • What fields are required to move a record forward?
  • What data points are captured after the Lead record—and can you access them for customer-facing campaigns?

Need a new marketing automation platform to help you on your data-driven marketing journey? Check out the emfluence Marketing Platform for Microsoft Dynamics >

Congrats, Now You’re a Marketing Genius!

Once you have your data structure in such a way that you can pull reports on campaign successes (with sales data!) and easily automate segments of your CRM into your marketing automation platform, you have a great foundation for proving out your worth as a marketer. Now you can:

  • Improve your strategy with a better budget informed by data from Lead Source and Source Campaign
  • Improve targeting with data-informed segments
  • Improve conversion rates with contact scoring (from your marketing automation platform) to reengage cold leads
  • Engage marketing qualified leads at the right time with sorts on what is and is not in Microsoft Dynamics

You’re well on your way to becoming a better data-driven marketer! If you have more questions or want to see how emfluence can help, be sure to visit us at emarketingplatform.com.

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

Read More

How to Increase Your Business Agility with Integration: Fast Track Workshop

October 30, 2020   TIBCO Spotfire
TIBCO FastTracktoInnovation scaled e1603300205530 696x365 How to Increase Your Business Agility with Integration: Fast Track Workshop

Reading Time: 2 minutes

Register for the workshop on how to increase business agility with integration

In the last few months, due to the pandemic, many brick-and-mortar stores have closed, forcing businesses to be agile and quickly adapt to changing market conditions and demands. For example, retailers are increasingly trying to compensate through online sales and by offering new services such as curbside pickup. Another example is Panera Bread who was able to quickly adapt in the midst of market disruption to reconfigure its business operations and create Panera Grocery in under two weeks. How can a business quickly change their established APIs and business processes to provide new services to their customers?  

In the TIBCO Cloud™ Integration Fast Track Workshop, we will use the example of a retailer to show how to quickly create new business processes to provide personalized, specialized offers to customers to incentivize online sales. This workshop introduces the capabilities of TIBCO Cloud Integration and demonstrates how to use it to easily solve common integration challenges and increase business agility with API-led and event-driven integration. 

What is the TIBCO Cloud Integration Fast Track Workshop?

The Fast Track workshop is a 90-minute guided experience delivered by a TIBCO Solution Engineer either virtually or in-person that helps you navigate through, understand use cases for, and explore features available in TIBCO Cloud Integration. 

TIBCO Cloud Integration is an integration platform-as-a-service (iPaaS) that increases business agility by accelerating API-led and event-driven integration processes. It empowers both business users and IT professionals to connect any app, business process, data source, or device across hybrid environments within a single platform to meet dynamic business objectives.

In this workshop, you will get hands-on experience in a retail use case, using an API-led approach to quickly adapt business processes to increase online sales and provide an enhanced customer experience with tailored offers to encourage future sales. You will use TIBCO Cloud Integration to build the integrations, automatically qualify customers’ eligibility based on events/criteria, and use TIBCO Cloud Live Apps to model the new business process to automate decisions. 

Why Participate?

The TIBCO Cloud Integration Fast Track Workshop offers an immersive user experience that provides: 

  • Access to TIBCO thought leadership
  • API-led development experience using TIBCO
  • Minimum time commitment: less than 90 minutes
  • Better insights than just ‘another trial’
  • Detailed, click-by-click instructions
  • Delivered virtually by your TIBCO account team 

In the TIBCO Cloud™ Integration Fast Track Workshop, we will use the example of a retailer to show how to quickly create new business processes to provide personalized, specialized offers to customers to incentivize online sales. Click To Tweet

You can participate in three easy steps: Register for the workshop, download the GitHub to your computer, and sign up for a trial account of TIBCO Cloud. 

Let’s block ads! (Why?)

The TIBCO Blog

Read More

Figure the Total Cost of Microsoft Dynamics 365/CRM with Our Quick Quote Tool

October 30, 2020   CRM News and Info
crmnav Figure the Total Cost of Microsoft Dynamics 365/CRM with Our Quick Quote Tool

What a year this has been. Organizations are figuring out how to keep going and thrive despite difficult circumstances. Many businesses are using this time to map their path for the future. Now is a good time to position your organization for the days and years ahead.

Organizations of all types and sizes realize how valuable a comprehensive CRM (Customer Relationship Management) solution is to the growth and success of their business.

If you are increasing your client base, opening new offices, or expanding into new markets nearby or around the globe, you need a powerful, integrated system such as Microsoft Dynamics 365/CRM

Undoubtedly, you have read numerous articles or talked with consultants about the many features of Dynamics 365 and what it can do for your business. But one piece of information you’d like to have before you commit to buying is the price.

There is a difference between the sticker price of the software and the actual cost of the software plus installation plus ongoing costs. When budgeting for a new or upgraded solution, you need to know the total cost of ownership. That’s not always easy to determine.

The CRM Software Blog’s Quick Quote Wizard is here to help. This tool will provide a working estimate of the total costs involved in implementing and operating Microsoft Dynamics 365. Here’s how the Quick Quote Wizard works:

Look for the orange ‘Request Instant Quote Dynamics 365/CRM’ bar at the top right of each page of the CRM Software Blog. Click the bar, and you’ll be taken to a screen with a short form to fill out. You’ll be asked basic questions about your type of business, the number of employees who will be using the system, the level of support you’ll require (don’t worry, the questionnaire will help you answer these questions) and any concerns you have unique to your business. Include your contact information, and you’re done.

The Quick Quote Wizard will use your information to customize a quote which you’ll receive instantly as a PDF sent to your email. After you’ve received your non-binding quote, your contact information will be forwarded to just one of our expert CRM Software Blog members in your area who will be happy to answer any questions you may have. You can choose to work with that partner or not; it’s up to you. The estimate and the referral are a free service we provide for our readers.

The CRM Software Blog Quick Quote Tool can get you started in determining just how much your Microsoft Dynamics 365 system will cost you from the first licensing to long-term support. Simply fill out the quote request form and be well on your way to a deeper understanding of the total cost of owning a Dynamics 365 solution from Microsoft.

By CRM Software Blog Writer. www.crmsoftwareblog.com

Find a Microsoft Partner in your area.

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

Read More

Majestic AF Noodles

October 30, 2020   Humor

Posted by Krisgo

via

About Krisgo

I’m a mom, that has worn many different hats in this life; from scout leader, camp craft teacher, parents group president, colorguard coach, member of the community band, stay-at-home-mom to full time worker, I’ve done it all– almost! I still love learning new things, especially creating and cooking. Most of all I love to laugh! Thanks for visiting – come back soon icon smile Majestic AF Noodles


Let’s block ads! (Why?)

Deep Fried Bits

Read More

Getting Excited for the Microsoft Cloud for Healthcare!

October 30, 2020   Microsoft Dynamics CRM

The Microsoft Cloud for Healthcare is launching this week and HCL-PowerObjects is proud to be one of only eight Global Systems Integrators (GSIs) selected by Microsoft to offer this transformational new product. With Microsoft’s trusted and fully integrated cloud capabilities as its foundation, the Microsoft Cloud for Healthcare is designed to empower hospitals and clinics to improve health care…

Source

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM

Read More

A SHOT FROM MARS

October 29, 2020   Humor

Cliffs in ancient ice:

Scientists have come to realize that, just below the surface, about one third of Mars is covered in ice. We study this ice to learn about Mars’ ancient climate and astronauts’ future water supplies.

Sometimes we see the buried ice because cliffs form like the one in this image. On the brownish, dusty cliff wall, the faint light-blue-colored ice shows through. Some of these cliffs change before our eyes and boulders of ice can tumble downhill. We take repeat images of these scenes to check for changes like this.

Let’s block ads! (Why?)

ANTZ-IN-PANTZ ……

Read More

Harnessing Streaming Data: Insights at the Speed of Life

October 28, 2020   Sisense

We live in a world of data: There’s more of it than ever before, in a ceaselessly expanding array of forms and locations. Dealing with Data is your window into the ways data teams are tackling the challenges of this new world to help their companies and their customers thrive.

Streaming data analytics is expected to grow into a $ 38.6 billion market by 2025. The world is moving faster than ever, and companies processing large amounts of rapidly changing or growing data need to evolve to keep up — especially with the growth of Internet of Things (IoT) devices all around us. Real-time insights provide businesses with unique advantages that are rapidly becoming must-haves for staying competitive in a variety of markets. Let’s look at a few ways that different industries take advantage of streaming data.

How industries can benefit from streaming data

  • Sales, marketing, ad tech: Making faster marketing decisions, optimizing ad spend
  • Security, fraud detection: Reducing the time needed to detect and respond to malicious threats
  • Manufacturing, supply chain management: Increasing inventory accuracy, avoiding production line downtime, monitoring current IoT and machine-to-machine data
  • Energy, utilities: Analyzing IoT data to alert and address equipment issues, get ahead of potential issues, help reduce maintenance costs
  • Finance, fintech: Tracking customer behavior, analyzing account activities, responding to fraud and customer needs immediately and proactively while they’re engaged. 
  • Automotive: Monitoring connected, autonomous cars in real time to optimize routes to avoid traffic and for diagnosis of mechanical issues

As real-time analytics and machine learning stream processing are growing rapidly, they introduce a new set of technological and conceptual challenges. In this piece, we’ll dig into those challenges and how Upsolver and Sisense are helping tackle them.

Technological challenges to handling streaming data

Stateful transformations

One of the main challenges when dealing with streaming data comes from performing stateful transformations for individual events. Unlike a batch processing job that runs within an isolated batch with clear start and end times, a stream processing job runs continuously on each event separately. Operations like API calls, joins, and aggregations that used to run every few minutes/hours now need to run many times per second. Dealing with this challenge requires caching the relevant context on the processing instances (state management) using techniques like sliding time windows.

Optimizing object storage

Another goal that teams dealing with streaming data may have is managing and optimizing a file system on object storage. Streaming data tends to be very high-volume and therefore expensive to store. However, cloud object storage, like Amazon S3, is a very cost-effective solution (starting at $ 23 per month per terabyte for hot storage at time of writing) compared to traditional databases and Kafka (which creates three replicas by default on local storage — that’s a lot of data being stored!).

The challenge with object storage is the complexity of optimizing its file system by combining the right file format, compression, and size. For example, small files are a performance anti-pattern for object storage (50X impact), but using streaming data forces us to create such files. 

Cleaning up dirty data

Every data professional knows that ensuring data quality is vital to producing usable query results. Streaming data can be extra challenging in this regard, as it tends to be “dirty,” with new fields that are added without warning and frequent mistakes in the data collection process. In order to bridge the gap to analytics-ready data, developers have to be able to address data quality issues quickly.

The best architecture for that is called “event sourcing.” Implementing this requires a repository of all raw events, a schema on read, and an execution engine that transforms raw events into tables. Every time analytics data needs to be adjusted, the developer will run a processing job from the raw data repository (time travel/replay/reprocessing).

Broader considerations

These are just a few of the technical considerations that teams need to grapple with when attempting to use real-time data. They also have to orchestrate huge volumes of jobs to handle rapidly changing data, work to ensure data consistency with exactly-once processing, 

and deal with concurrent requests from a variety of users all trying to get insights from the same data at the same time.

Digital Transformation Whitepaper CTA Banner 770x250 1 Harnessing Streaming Data: Insights at the Speed of Life

How Upsolver solves stream processing 

Sisense has partnered with Upsolver to help solve these technical challenges. Upsolver has spent countless hours to eliminate the engineering complexity so that companies can solve these types of data challenges in real time.

upsolver1 Harnessing Streaming Data: Insights at the Speed of Life

Challenges like job orchestration, exactly-once data consistency, and file system management are heavy engineering challenges. Solving them is a complex challenge, resulting in a data engineering bottleneck that slows the analytics process. 

Upsolver encapsulates the streaming engineering complexity by empowering every technical user (data engineers, DBAs, analysts, scientists, developers) to ingest, discover, and prepare streaming data for analytics. These experts can define transformations from streams to tables and govern the processing progress using a visual, SQL-based interface. Engineering complexity is abstracted from the user via an execution engine that turns multiple data sources (stream and batch) into tables in various databases. 

Let’s dig into how it works!

Step 1: Connect to data sources — cloud storage, data streams, databases

Once inside your Upsolver user interface (UI), users simply click on “Add a new data source” and choose one of the built-in connectors for cloud storage, databases, or streams. The UI allows users to parse their source data in formats including JSON, CSV, Avro, Parquet and Protobuf.

upsolver2 Harnessing Streaming Data: Insights at the Speed of Life

A sample from the parsed data is displayed before ingestion starts:

upsolver3 Harnessing Streaming Data: Insights at the Speed of Life

Schema on read and statistics per field are automatically detected and presented to the user: 

upsolver4 Harnessing Streaming Data: Insights at the Speed of Life

Step 2: Define stateful transformations 

Now that each data source has been set up, it’s time to define an output to be Upsolver’s entity for processing jobs. Each output creates one table in a target sync and populates it continuously with data based on the transformations the user defined. 

upsolver5 Harnessing Streaming Data: Insights at the Speed of Life

Transformations can be defined via the UI, SQL, or both (bidirectional sync between UI and SQL).

(Note: The SQL statement isn’t for querying data like in databases. In Upsolver, SQL is used to define continuous processing jobs so the SQL statement is executed once for every source event.)

Upsolver provides over 200 built-in functions and ANSI SQL support out of the box to simplify stream processing. These native features hide implementation complexities from users so their time isn’t wasted on customized coding. 

Upsolver also provides stateful transformations that allow the user to join the currently processed event with other data sources, run aggregation (with and without time windows), and deduplicate similar events. 

Adding transformations using the UI:

upsolver6 Harnessing Streaming Data: Insights at the Speed of Life

Editing transformations with SQL:

The output below calculates the order total by aggregating net total and sales tax.

upsolver7 Harnessing Streaming Data: Insights at the Speed of Life

IF_DUPLICATE function for filtering similar events:

upsolver8 Harnessing Streaming Data: Insights at the Speed of Life

Defining keys for tables in Amazon Redshift: 

This feature is necessary to support use cases like change data capture log streaming and enforcing GDPR/CCPA compliance in Amazon Redshift.

upsoler9 Harnessing Streaming Data: Insights at the Speed of Life

Step 3: Execute jobs query optimization

Now that your output is ready, click on RUN to execute your job.

First, fill in the login information for Redshift:

upsolver10 Harnessing Streaming Data: Insights at the Speed of Life

Second, choose the Upsolver cluster for running the output and the time frame to run at.

Upsolver clusters run on Amazon EC2 spot instances and scale out automatically based on compute utilization. 

upsolver11 Harnessing Streaming Data: Insights at the Speed of Life

Note that during this entire process, the user didn’t need to define anything except data transformations: The processing job is automatically orchestrated, and exactly-once data consistency is guaranteed by the engine. The impact of implementing these best practices is faster queries that will power Redshift and dashboards in Sisense.

Step 4: Query

Log in to your Sisense environment with at least data designer privileges. We’ll be creating a live connection to the Redshift cluster that was set up in Step 3 and a simple dashboard. The first step is to navigate to the “Data” tab and create a new live model. You can give it whatever name you like.

sisense1 Harnessing Streaming Data: Insights at the Speed of Life

Now, let’s connect to Redshift. Click the “+ Data” button in the upper right hand corner of the screen. Select Redshift from the list of available connections. Next, you’ll need to enter your Redshift location and credentials. The location is the URL/endpoint for the cluster. The credentials used should have read access to the data you are using. Make sure to check “Use SSL” and “Trust Server Certificate” (most clusters require these options by default).

When ready, click “Next” and select the database you’ll be connecting to. Then click “Next” again.

Here you can see all of the tables you have access to, separated by schema. Navigate to the schema/tables you want to import, and select a few to start with. You can always add more later. When ready, click “Done” to add these tables to your model.

sisense2 Harnessing Streaming Data: Insights at the Speed of Life

Once you have tables to work with, it’s time to connect them. In this case, the tables link on “orderId.” Simply drag one table onto the other and select the linking field (the key) on both sides. When you see the line appear between the tables, you can click “Done.” Finally, click “Publish” in the upper right hand corner, and you’re ready to create a dashboard!

sisense3 Harnessing Streaming Data: Insights at the Speed of Life

Now you need to navigate over to the “Analytics” tab. This is where we’ll create a new dashboard to view and explore the data. In there, you’ll see a button to create a new dashboard.  Click it and select the live model you just published. You can give another name to the dashboard or it will default to the same name as the model.  

sisense4 Harnessing Streaming Data: Insights at the Speed of Life

Now, it’s time to build the dashboard and explore your data. In the following animation, we create a few different visualizations based on fields from both tables. Notice that we are selecting fields to use as both dimensions and measures from both tables in the model. Sisense is automatically joining the tables for us, and Upsolver keeps the data in both tables synced with the stream.

sisense5 Harnessing Streaming Data: Insights at the Speed of Life

Feel free to explore your data now. You can left-click on elements of the dashboard to place a filter and right-click to drill down. You can also interact with filters on the right hand filter panel. Again, you can filter on fields in both tables, and Sisense will determine the right queries for you.

sisense6 770x388 Harnessing Streaming Data: Insights at the Speed of Life

Getting your streaming data to work for you

Streaming data analytics is important for businesses to make critical decisions in real time. To get there, it’s necessary to solve several engineering complexities that are introduced with streaming and aren’t addressed with the batch technology stack. In this article, we showed how Upsolver, AWS, and Sisense can be used together to deliver an end-to-end solution for streaming data analytics that is quick to set up, easy to operate without coding, and scales elastically using cloud computing/storage. 

Click here to find out more about Upsolver. Visit this page to become a Sisense Platform Partner and here to learn  more about our partnership with AWS.

Ori Rafael has a passion for taking technology and making it useful for people and organizations. Before founding Upsolver, Ori performed a variety of technology management roles at IDF’s elite technology intelligence unit, followed by corporate roles. Ori has a B.A. in Computer Science and an MBA.

Mei Long, PM of Upsolver has held senior positions in many high-profile technology startups. Before Upsolver, she played an instrumental role on the teams that contributed to the Apache Hadoop, Spark, Zeppelin, Kafka, and Kubernetes project. Mei has a B.S. in Computer  Engineering.

Tags: streaming analytics

Let’s block ads! (Why?)

Blog – Sisense

Read More
« Older posts
  • Recent Posts

    • Rickey Smiley To Host 22nd Annual Super Bowl Gospel Celebration On BET
    • Kili Technology unveils data annotation platform to improve AI, raises $7 million
    • P3 Jobs: Time to Come Home?
    • NOW, THIS IS WHAT I CALL AVANTE-GARDE!
    • Why the open banking movement is gaining momentum (VB Live)
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited