Harnessing the power of Lumin and Streamlit in Snowflake: From data exploration and visualization to Decision Intelligence

Reading Time: 3 minutes

From the Author

As a data enthusiast myself, I understand the importance of data exploration, visualization, and decision intelligence in today’s data driven world. That is why I am thrilled to share with you how Lumin and Streamlit can revolutionize your data analysis experience in Snowflake, the leading cloud-based data warehouse platform. So, fasten your seatbelts as we embark on a journey to harness the true power of Lumin and Streamlit to unlock the potential of your data.

Understanding Lumin and Streamlit

Let us start by getting familiar with Lumin and Streamlit. Lumin by Fosfor, is a decision intelligence platform that seamlessly integrates with Snowflake, bringing enhanced data exploration and visualization capabilities. It allows you to dig deep into your data, uncover hidden patterns, and gain meaningful insights.

On the other hand, Streamlit is an open-source framework that enables you to build interactive data applications effortlessly. Its acquisition and integration with Snowflake allow you to pursue the principle of moving code to data instead of data to code.

Intuitive Application Program Interfaces (APIs), and the simple syntax of Streamlit enable you to iterate and experiment with your data apps seamlessly. It enables you to build native Snowflake apps, which means you can directly connect to Snowflake, access your data, and create real-time data visualizations and insights without the need for complex software integrations.

Why Lumin and Streamlit

  • Lumin empowers you to explore and analyze your data in Snowflake in an intuitively and efficiently.
  • Streamlit lets you create custom dashboards and data visualizations that showcase your data beautifully within the Snowflake environment.
  • Bringing in Lumin’s capabilities on Streamlit provides an enhanced Snowflake native experience to explore and analyze your data with ease.

Leveraging Lumin and Streamlit for data exploration

When it comes to data exploration, Lumin truly shines. Its robust features and seamless integrations with Snowflake make it a game-changer for data scientists, data engineers, and data analysts alike.

Here’s how Lumin can supercharge your data exploration journey:

  • Intuitive Data Analysis: Lumin offers a user-friendly data exploration interface that simplifies the process of analyzing your data in Snowflake. Lumin comes with a natural language interface to get the required insights rapidly and more intuitively. This interface is powered by a language model specifically trained for business use cases.
  • Powerful Visualizations: Lumin provides a wide range of visualization options to help you bring your data to life. From interactive charts to geospatial visualizations, Lumin has got you covered.
  • Data Storytelling: Lumin provides strong actionable data stories with clear insights and a shared canvas to build workspaces that curate intelligent decisions.
  • Seamless Collaboration: Lumin allows you to share your decision intelligence insights with colleagues or create and share workspace stories to collaborate in real-time. This fosters a data-driven culture within your organization.

Example 1: A real-world use case in the Retail and Consumer Packaged Goods (RCPG) Industry:

Imagine you are a data analyst working with a vast RCPG dataset in Snowflake. With Lumin, you can connect to Snowflake using the native Snowflake connector, configure the decision intelligence solution, and seamlessly start exploring the data to uncover valuable insights.

Using Lumin, you can easily analyze various aspects of your RCPG business, such as product performance, regional sales trends, and customer segmentation. The intuitive interface of Lumin enables you to ask questions and retrieve specific information effortlessly, like identifying the top 5 brands by units sold.

Visualizing your data is equally important, and Lumin provides a range of interactive charts, data explorations and visualization options to bring your insights to life. You can create visually appealing workspaces that showcase key metrics, regional comparisons, and product performances. These data stories enable decision makers to grasp the information quicker and derive actionable insights.

In the RCPG industry, understanding customer behavior and market trends is crucial for making informed decisions. With Lumin’s drill-down capabilities, you can explore the data at a granular level and uncover hidden patterns or anomalies that impact your business. For example, you can dive deeper into customer segmentation and identify high-value customer segments that drive revenue growth.

The power of Lumin gets even better when combined with Streamlit as a native Snowflake app. By leveraging Streamlit, you can build custom data apps directly within the Snowflake environment. Using Lumin as a native application in Snowflake, decision makers in the RCPG industry can transform raw data into actionable insights, make data-driven decisions, and drive business growth.

To learn more about how Lumin can revolutionize decision-making in the Retail and Consumer Packaged Goods industry, check out our detailed use case here.

Fig 1 below illustrates the power of Lumin to not just visualize your data, but also offer invaluable insights that it intuitively presents based on your querying and querying pattern.

Fig.1.Lumin native snowflake app for RCPG use case

Enhancing Data Visualization with Lumin and Streamlit
Data visualization is a powerful tool for conveying complex information in a clear and concise manner. Lumin, combined with Streamlit, takes data visualization to the next level. Here is how this dynamic duo can elevate your data visualization game in Snowflake:

  • Customizable Dashboards: With Streamlit, you can build custom dashboards tailored to your specific needs. Showcase your data in a visually stunning way, and enable users to interact with the visualizations effortlessly with Lumin’s capabilities of seamless natural language interface within Streamlit.
  • Real-Time Updates: Streamlit ensures that your dashboards stay up to date with the latest data from Snowflake. This enables decision-makers to access real-time insights and make informed choices, all this within the Snowflake environment.

Example 2: A use case of incident management in ServiceNow.

As an Information Technology (IT) operations manager, you can leverage Lumin and Streamlit to create a dynamic dashboard that displays key metrics such as incident volume, resolution time, and priority distribution. With Lumin’s seamless ask and visualization capabilities, you can ask and create interactive charts or geographical representations to visualize incident trends and patterns. These insights can also be compiled and consumed as Lumin’s workspace stories. Streamlit’s native integration with Snowflake allows you to fetch and update incident data in real-time, providing stakeholders with up-to-date insights for efficient decision-making and resource allocation.

By visualizing incident data through Lumin and Streamlit, you can identify bottlenecks in incident resolution, track service level agreement (SLA) compliance, and prioritize resources effectively. This empowers your organization to proactively manage incidents, optimize workflows, and enhance overall service delivery, all within your Snowflake environment.

Read more about the ServiceNow use case here.

Enabling Decision Intelligence with Lumin and Streamlit

Decision intelligence is all about making data-driven decisions that lead to better outcomes. Lumin and Streamlit play a crucial role in enabling decision intelligence within Snowflake. Here is how they can help you make smarter decisions:

  • Advanced Analytics Integrations: Lumin allows you to use advanced analytics techniques and machine learning models seamlessly. This empowers you to leverage predictive analytics, forecasting and on-the-fly simulation capabilities to optimize your decision-making processes.
  • Real-Time Insights: With Streamlit, you can create native Snowflake apps that provide real-time insights and enable stakeholders to make informed decisions on the fly.

How decision makers can take advantage of Lumin:

Picture yourself as a marketing manager responsible for optimizing advertising campaigns. By utilizing intelligent softwares like Lumin and Streamlit, you can build a native Snowflake app that analyzes campaign performance in real-time. By incorporating sentiment analysis, Lumin’s natural language processing and predictive models, the app can predict the effectiveness of different advertising strategies. This enables you to make data-driven decisions on budget allocation, target audience selection, and campaign optimization, improving your return on investment.

Conclusion

By harnessing the power of Lumin and Streamlit in Snowflake, you can take your data exploration, visualization, and decision intelligence to new heights. Whether you are a data scientist, data engineer, data analyst or a decision maker, these data intelligence platforms offer a powerful combination of features that will revolutionize the way you work with data.

So, what are you waiting for? Dive into the world of Lumin as a native application in Snowflake, unleash the full potential of your data, and make smarter decisions like never before. Start your journey today and unlock a world of possibilities!

Author

Vishwas Jayarama

Senior Specialist, Fosfor.

Vishwas spearheads the Fosfor Decision Cloud’s expansion across multiple channels including mobile apps, SDKs and the cloud marketplace. With over a decade of experience in product and technology, he has a proven ability to transform ideas into successful ventures. His entrepreneurial spirit shines through in his impressive accomplishment of building a bootstrapped Urban Mobility startup, with a strong presence throughout India. Beyond his professional endeavors, he finds joy in playing badminton, immersing himself in music, and delving into the world of books.

More on the topic

Read more thought leadership from our team of experts

Revive retail sales with Fosfor + Snowflake + ServiceNow

There is no question that the COVID-19 pandemic has profoundly impacted the way traditional retailers or new-age eCommerce companies connect with and serve their customers—from capturing their attention online, to integrating service and delivery into a superlative customer experience.

Read more

The FDC + Snowflake - Empowering decision makers in the Pharma value chain

Brand analytics is crucial for any Pharma manufacturer’s success. During the drug research and development phase, Pharma manufacturers spend millions of dollars, and consume 10-15 years to bring much needed drugs to the market, with only 7-12 years of patented time available.

Read more

Lumin + Snowflake: Decision Intelligence on the Data Cloud

Enterprises today are on the lookout for approaches or decision intelligence technologies that will enable agile analytics in the data cloud and deliver more value with faster iterations and fewer resources.

Read more
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. View more
Cookies settings
Accept
Privacy & Cookie policy
Privacy & Cookies policy
Cookie name Active

What is a cookie?

A cookie is a small piece of data that a website asks your browser to store on your computer or mobile device. The cookie allows the website to “remember” your actions or preferences over time. On future visits, this data is then returned to that website to help identify you and your site preferences. Our websites and mobile sites use cookies to give you the best online experience. Most Internet browsers support cookies; however, users can set their browsers to decline certain types of cookies or specific cookies. Further, users can delete cookies at any time.

Why do we use cookies?

We use cookies to learn how you interact with our content and to improve your experience when visiting our website(s). For example, some cookies remember your language or preferences so that you do not have to repeatedly make these choices when you visit one of our websites.

What kind of cookies do we use?

We use the following categories of cookie:

Category 1: Strictly Necessary Cookies

Strictly necessary cookies are those that are essential for our sites to work in the way you have requested. Although many of our sites are open, that is, they do not require registration; we may use strictly necessary cookies to control access to some of our community sites, whitepapers or online events such as webinars; as well as to maintain your session during a single visit. These cookies will need to reset on your browser each time you register or log in to a gated area. If you block these cookies entirely, you may not be able to access gated areas. We may also offer you the choice of a persistent cookie to recognize you as you return to one of our gated sites. If you choose not to use this “remember me” function, you will simply need to log in each time you return.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
__cfduid Cloudflare Cookie associated with sites using CloudFlare, used to speed up page load times 1 Year
lidc linkedin.com his is a Microsoft MSN 1st party cookie that ensures the proper functioning of this website. 1 Day
PHPSESSID ltimindtree.com Cookies named PHPSESSID only contain a reference to a session stored on the web server When the browsing session ends
catAccCookies ltimindtree.com Cookie set by the UK cookie consent plugin to record that you accept the fact that the site uses cookies. 29 Days
AWSELB Used to distribute traffic to the website on several servers in order to optimise response times. 2437 Days
JSESSIONID linkedin.com Preserves users states across page requests. 334,416 Days
checkForPermission bidr.io Determines whether the visitor has accepted the cookie consent box. 1 Day
VISITOR_INFO1_LIVE Tries to estimate users bandwidth on the pages with integrated YouTube videos. 179 Days
.avia-table-1 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-1 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-1 td:nth-of-type(3):before { content: 'Description'; } .avia-table-1 td:nth-of-type(4):before { content: 'Retention period'; }

Category 2: Performance Cookies

Performance cookies, often called analytics cookies, collect data from visitors to our sites on a unique, but anonymous basis. The results are reported to us as aggregate numbers and trends. LTI allows third-parties to set performance cookies. We rely on reports to understand our audiences, and improve how our websites work. We use Google Analytics, a web analytics service provided by Google, Inc. (“Google”), which in turn uses performance cookies. Information generated by the cookies about your use of our website will be transmitted to and stored by Google on servers Worldwide. The IP-address, which your browser conveys within the scope of Google Analytics, will not be associated with any other data held by Google. You may refuse the use of cookies by selecting the appropriate settings on your browser. However, you have to note that if you do this, you may not be able to use the full functionality of our website. You can also opt-out from being tracked by Google Analytics from any future instances, by downloading and installing Google Analytics Opt-out Browser Add-on for your current web browser: https://tools.google.com/dlpage/gaoptout & cookiechoices.org and privacy.google.com/businesses
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
_ga ltimindtree.com Used to identify unique users. Registers a unique ID that is used to generate statistical data on how the visitor uses the web site. 2 years
_gid ltimindtree.com This cookie name is asssociated with Google Universal Analytics. This appears to be a new cookie and as of Spring 2017 no information is available from Google. It appears to store and update a unique value for each page visited. 1 day
_gat ltimindtree.com Used by Google Analytics to throttle request rate 1 Day
.avia-table-2 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-2 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-2 td:nth-of-type(3):before { content: 'Description'; } .avia-table-2 td:nth-of-type(4):before { content: 'Retention period'; }

Category 3: Functionality Cookies

We may use site performance cookies to remember your preferences for operational settings on our websites, so as to save you the trouble to reset the preferences every time you visit. For example, the cookie may recognize optimum video streaming speeds, or volume settings, or the order in which you look at comments to a posting on one of our forums. These cookies do not identify you as an individual and we don’t associate the resulting information with a cookie that does.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
lang ads.linkedin.com Set by LinkedIn when a webpage contains an embedded “Follow us” panel. Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in. When the browsing session ends
lang linkedin.com In most cases it will likely be used to store language preferences, potentially to serve up content in the stored language. When the browsing session ends
YSC Registers a unique ID to keep statistics of what videos from Youtube the user has seen. 2,488,902 Days
.avia-table-3 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-3 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-3 td:nth-of-type(3):before { content: 'Description'; } .avia-table-3 td:nth-of-type(4):before { content: 'Retention period'; }

Category 4: Social Media Cookies

If you use social media or other third-party credentials to log in to our sites, then that other organization may set a cookie that allows that company to recognize you. The social media organization may use that cookie for its own purposes. The Social Media Organization may also show you ads and content from us when you visit its websites.

Ref links:

LinkedInhttps://www.linkedin.com/legal/privacy-policy Twitterhttps://gdpr.twitter.com/en.html & https://twitter.com/en/privacy & https://help.twitter.com/en/rules-and-policies/twitter-cookies Facebookhttps://www.facebook.com/business/gdpr Also, if you use a social media-sharing button or widget on one of our sites, the social network that created the button will record your action for its own purposes. Please read through each social media organization’s privacy and data protection policy to understand its use of its cookies and the tracking from our sites, and also how to control such cookies and buttons.

Category 5: Targeting/Advertising Cookies

We use tracking and targeting cookies, or ask other companies to do so on our behalf, to send you emails and show you online advertising, which meet your business and professional interests. If you have registered on our websites, we may send you emails, tailored to reflect the interests you have shown during your visits. We ask third-party advertising platforms and technology companies to show you our ads after you leave our sites (retargeting technology). This technology allows us to make our website services more interesting for you. Retargeting cookies are used to record anonymized movement patterns on a website. These patterns are used to tailor banner advertisements to your interests. The data used for retargeting is completely anonymous, and is only used for statistical analysis. No personal data is stored, and the use of the retargeting technology is subject to the applicable statutory data protection regulations. We also work with companies to reach people who have not visited our sites. These companies do not identify you as an individual, instead rely on a variety of other data to show you advertisements, for example, behavior across websites, information about individual devices, and, in some cases, IP addresses. Please refer below table to understand how these third-party websites collect and use information on our behalf and read more about their opt out options.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
BizoID ads.linkedin.com These cookies are used to deliver adverts more relevant to you and your interests 183 days
iuuid demandbase.com Used to measure the performance and optimization of Demandbase data and reporting 2 years
IDE doubleclick.net This cookie carries out information about how the end user uses the website and any advertising that the end user may have seen before visiting the said website. 2,903,481 Days
UserMatchHistory linkedin.com This cookie is used to track visitors so that more relevant ads can be presented based on the visitor’s preferences. 60,345 Days
bcookie linkedin.com This is a Microsoft MSN 1st party cookie for sharing the content of the website via social media. 2 years
__asc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Day
__auc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Year
_gcl_au ltimindtree.com Used by Google AdSense for experimenting with advertisement efficiency across websites using their services. 3 Months
bscookie linkedin.com Used by the social networking service, LinkedIn, for tracking the use of embedded services. 2 years
tempToken app.mirabelsmarketingmanager.com When the browsing session ends
ELOQUA eloqua.com Registers a unique ID that identifies the user’s device upon return visits. Used for auto -populating forms and to validate if a certain contact is registered to an email group . 2 Years
ELQSTATUS eloqua.com Used to auto -populate forms and validate if a given contact has subscribed to an email group. The cookies only set if the user allows tracking . 2 Years
IDE doubleclick.net Used by Google Double Click to register and report the website user’s actions after viewing clicking one of the advertiser’s ads with the purpose of measuring the efficiency of an ad and to present targeted ads to the user. 1 Year
NID google.com Registers a unique ID that identifies a returning user’s device. The ID is used for targeted ads. 6 Months
PREF youtube.com Registers a unique ID that is used by Google to keep statistics of how the visitor uses YouTube videos across different web sites. 8 months
test_cookie doubleclick.net This cookie is set by DoubleClick (which is owned by Google) to determine if the website visitor’s browser supports cookies. 1,073,201 Days
UserMatchHistory linkedin.com Used to track visitors on multiple websites, in order to present relevant advertisement based on the visitor’s preferences. 29 days
VISITOR_INFO1_LIVE youtube.com 179 days
.avia-table-4 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-4 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-4 td:nth-of-type(3):before { content: 'Description'; } .avia-table-4 td:nth-of-type(4):before { content: 'Retention period'; }
Third party companies Purpose Applicable Privacy/Cookie Policy Link
Alexa Show targeted, relevant advertisements https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: http://www.bluekai.com/consumers.php#optout
Eloqua Personalized email based interactions https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: https://www.oracle.com/marketingcloud/opt-status.html
CrazyEgg CrazyEgg provides visualization of visits to website. https://help.crazyegg.com/article/165-crazy-eggs-gdpr-readiness Opt Out: DAA: https://www.crazyegg.com/opt-out
DemandBase Show targeted, relevant advertisements https://www.demandbase.com/privacy-policy/ Opt out: DAA: http://www.aboutads.info/choices/
LinkedIn Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://www.linkedin.com/legal/privacy-policy Opt-out: https://www.linkedin.com/help/linkedin/answer/62931/manage-advertising-preferences
Google Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Facebook Show targeted, relevant advertisements https://www.facebook.com/privacy/explanation Opt Out: https://www.facebook.com/help/568137493302217
Youtube Show targeted, relevant advertisements. Show embedded videos on LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Twitter Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://twitter.com/en/privacy Opt out: https://twitter.com/personalization DAA: http://optout.aboutads.info/
. .avia-table tr {} .avia-table th, .flex_column .avia-table td { color: #343434; padding: 5px !important; border: 1px solid #ddd !important; } .avia-table th {background-color: #addeec;} .avia-table tr:nth-child(odd) td {background-color: #f1f1f1;}
Save settings
Cookies settings