- Видео 30
- Просмотров 209 472
Aimpoint Digital
США
Добавлен 15 апр 2020
We deliver results, period. Aimpoint Digital focuses on being the trusted advisor for companies looking to extract tangible value from data, and develop into analytics-driven organizations. Our deep industry, technical, and analytic expertise has enabled us to construct an extensive client roster across multiple industries; From early-stage startups to Fortune 500 companies, our solutions are tailored based upon our clients' specific data / analytic needs and transformational aspirations. We pride ourselves in executing an approach that combines expert advice with actionable results and integrity.
Snowflake Cortex AI | How to Use the FINETUNE Function
In the next part of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. This video focuses on the FINETUNE function.
To learn more about what makes Aimpoint Digital a Snowflake Elite Services Partner, visit us online: www.aimpointdigital.com/partners/snowflake
To learn more about what makes Aimpoint Digital a Snowflake Elite Services Partner, visit us online: www.aimpointdigital.com/partners/snowflake
Просмотров: 91
Видео
Snowflake | How to Use Document AI
Просмотров 17914 дней назад
Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Document AI. To learn more about what makes Aimpoint Digital a Snowflake Elite Services Partner, visit us online: www.aimpointdigital.com/partners/snowflake
Snowflake Cortex AI | How to Use the VECTOR Function
Просмотров 6814 дней назад
In the next part of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. This video focuses on the VECTOR function. To learn more about what makes Aimpoint Digital a Snowflake Elite Services Partner, visit us online: www.aimpointdigital.com/partners/s...
Snowflake Cortex AI | How to Use the SENTIMENT Function
Просмотров 4114 дней назад
In the next part of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. This video focuses on the SENTIMENT function. To learn more about what makes Aimpoint Digital a Snowflake Elite Services Partner, visit us online: www.aimpointdigital.com/partner...
How to Translate Any Language in Snowflake with Cortex AI | Snowflake Tutorial
Просмотров 2313 месяца назад
In this video, we continue our Snowflake Cortex AI series with a tutorial on using Snowflake's Cortex Translate function to summarize and translate movie plot summaries into multiple languages. We'll walk you through the process of using the summarize function to condense lengthy plots and then translate them into French, Spanish, and German-all within a simple SQL query. We'll cover: - Uploadi...
Snowflake Cortex AI | How to Use the SUMMARIZE Function
Просмотров 3614 месяца назад
In part 3 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. This video focuses on the SUMMARIZE function. For additional insights and to access the dataset used in this video, visit the following links: movies file: 5527549.fs1.hubspotuserconten...
Snowflake Cortex AI | How to Use the COMPLETE Function
Просмотров 2,3 тыс.4 месяца назад
In part 2 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, delivers a tutorial on the COMPLETE function in Snowflake Cortex. This function allows you to integrate large language models (LLMs) into your SQL queries, offering a new level of AI-driven data interaction within Snowflake. Christopher...
Snowflake Cortex AI | How to Use (EXTRACT_ANSWER)
Просмотров 9995 месяцев назад
In part 1 of our Snowflake Cortex AI series, Christopher Marland, a Snowflake Solutions Architect at Aimpoint Digital and a recognized Snowflake Data Superhero, presents an in-depth tutorial on Snowflake Cortex. The tutorial focuses on the powerful (EXTRACT_ANSWER) function. This function allows you to analyze unstructured data, such as surveys, reviews, or emails, by feeding a simple prompt wi...
Add Decision Making to Your Databricks Toolkit With Mathematical Optimization | Webinar Replay
Просмотров 356Год назад
Explore the Intersection of Data Science and Decision Making in 'Add Decision Making to your Databricks Toolkit with Mathematical Optimization' - Watch the On-Demand Webinar Now! Presented by Gurobi Optimization and Aimpoint Digital, this webinar is an essential resource for anyone looking to tackle complex decision intelligence challenges through mathematical optimization. Discover the transfo...
QuickEntry: The Native Manual Data Entry App for Snowflake
Просмотров 755Год назад
QuickEntry is your path to hassle-free, accurate, and efficient Snowflake data management. Its intuitive interface, real-time updates, and seamless Snowflake integration simplify the complexities of manual data entry, making your workflow smoother and more productive. You can download the QuickEntry app for free in the Snowflake Marketplace now! Your Snowflake journey will never be the same. ap...
Data-Driven Growth: Aimpoint Digital + PetScreening
Просмотров 537Год назад
Discover how Aimpoint Digital has empowered PetScreening to harness the power of data for business growth. Learn about our strategic approach to data analytics, the role of Snowflake's data warehouse, and the use of Tableau for data visualization in PetScreening's data infrastructure. See how we've helped PetScreening to build a large advertising business, launch the country's largest free Ambe...
Using Snowpark in Dataiku | An In-Depth Guide & Review
Просмотров 770Год назад
Explore the potential of combining Snowflake's Snowpark with Dataiku in this comprehensive video guide hosted by Alaisha Alexander, an Aimpoint Digital Data Engineer. Learn how to transform and model data using Dataiku's intuitive recipes and Snowflake's cloud-based data platform, all within Snowpark's developer framework. Alaisha thoroughly explains the details of Dataiku recipes, Python recip...
Advanced Data Transformations in SnowPark | Snowflake Tutorial
Просмотров 6 тыс.Год назад
In this RUclips video, Aimpoint Digital’s Snowflake Solutions Architect, Christopher Marland, explains how we can move from ad-hoc data transformations to more professional, scalable, and automated transformations. The video covers topics such as permanent UDFs, MERGEs, reading data from internal stages, and automating Snowpark for Python data transformations using stored procedures and tasks. ...
ServerPAHL: Personal Insights | Alteryx Server Reporting
Просмотров 198Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant, will be discussing the Personal Insights component of “PAHL”. This component enables developers to review and gain insight into their content's performance and usage. Bonna will be giving a de...
ServerPAHL: Audit | Alteryx Server Reporting
Просмотров 147Год назад
If you're interested in learning more about Aimpoint Digital’s ServerPAHL reporting suite for Alteryx Gallery, then you've come to the right place! In this video, Bona Wang, a senior analytics consultant, demonstrates the audit capabilities of “PAHL”, starting with the log and entity tables, followed by the permission audit. The log and entity tables provide information on user and asset activi...
ServerPAHL: Health Check | Alteryx Server Reporting
Просмотров 209Год назад
ServerPAHL: Health Check | Alteryx Server Reporting
ServerPAHL: Lineage | Alteryx Server Reporting
Просмотров 180Год назад
ServerPAHL: Lineage | Alteryx Server Reporting
ServerPAHL: The Ultimate Alteryx Server Reporting Tool
Просмотров 295Год назад
ServerPAHL: The Ultimate Alteryx Server Reporting Tool
Intermediate Data Transformations in Snowpark for Python | Snowflake Tutorial
Просмотров 7 тыс.Год назад
Intermediate Data Transformations in Snowpark for Python | Snowflake Tutorial
Dataiku Vlog: How to Correct Data Inconsistencies | DEMO
Просмотров 488Год назад
Dataiku Vlog: How to Correct Data Inconsistencies | DEMO
Snowpark for Python | Snowflake Tutorial
Просмотров 36 тыс.Год назад
Snowpark for Python | Snowflake Tutorial
What Is a Digital Twin? | Aimpoint Digital
Просмотров 2032 года назад
What Is a Digital Twin? | Aimpoint Digital
Our Approach to Data Analytics | Aimpoint Digital
Просмотров 3582 года назад
Our Approach to Data Analytics | Aimpoint Digital
Our Approach to Data Engineering | Aimpoint Digital
Просмотров 2652 года назад
Our Approach to Data Engineering | Aimpoint Digital
Our Approach to Data Science | Aimpoint Digital
Просмотров 1742 года назад
Our Approach to Data Science | Aimpoint Digital
Quantum Computing in Alteryx: The Future of Logistics
Просмотров 5933 года назад
Quantum Computing in Alteryx: The Future of Logistics
Untangling the Data Mesh to Enable Domain-Driven Analytics - LinkedIn Live Webinar
Просмотров 3233 года назад
Untangling the Data Mesh to Enable Domain-Driven Analytics - LinkedIn Live Webinar
Is there way this function can be moved from one environment to another environment? Like to dev to prod ?
Getting internalframework error while submitting the finetuning job
This is really painful to use. There appear to be better ways of doing this in a Streamlit app.
just want to say thank you for this video. this is solved my issue.
Alteryx is easier than google maps at finding pubs?
doesn't recognize my config module from config import * ModuleNotFoundError: No module named 'config' what should i do? thanks in advance
Hi Where I can find the snowflake account id?
great video and series. i got stuck on the website udf. turns out on my set-up, the 'html' column was saved as 'binary' instead of 'string', had to add binarytype() to my snowflake.snowpark,types import and use input_types=[BinaryType()] instead of StringType()
So snowpark code is just like databricks pySpark code :D . Thanks It's clear now that Snowpark and Databricks are for spark processing.
Same feeling. I’ve been using apache spark. And I found very similar.
Good. Keep doing more
Amazing content, thanks for sharing. I have a few doubts 1. What are the pros & cons of Snowpark vs SageMaker 2. If we want to redo SageMaker codes with Snowpark are there limitations? 3. Are there data type challenges of using Snowpark? 4. Quickest way to ramp up on Snowpark?
what would you do if you;re getting your data from snowflake
how do we cast date to string or string to date in snowpark?
i have a grouped snowpark df i am trying to calculate a median of target column can u pls help currently i am trying df.groupby(columns).agg(median(targetcol)) its not completing
Hey, great introductory video, can you advice how I can access a nested column while selecting them from a table?
Do you have the full course of the alteryx? I am looking for it.
what ide are you using?
13:28 what is F.Col ?
did you get ? i have same qs
Not sure if its still a question, but F is an alias for Snowpark Functions that are imported. Similar to how we write import pandas as pd and then do pd.read_csv(), etc.
whats the IDE?
Visual Studio Code
This is one of the best snowpark video I have found among RUclips. So easy to understand and point to point.
I have a SQL problem which I want to solve. Able to achieve half the way but another part is pending, pls help in this. Thank you for so beautiful simple explanation
Great series of videos!!! Well explained.. Thanks! BTW, I don't see a .sql file in the zipped folder... Am I missing something?
Thank you so much for your support! The zip file has now been adjusted and should have everything you need.
Hi, Thanks for the great content. I recently got a chance to work on Snowpark python. I am pretty much new to this. Can you please make a video on "Working with python worksheet on snowflake UI" and how to deploy it also I want to how to get arguments to that python script to take user inputs. Keep posting such great videos.
Source control?
Thanks for this video. I create my dataframes using the snow_session.sql('select * from table') format. Is it possible to convert this snowpark dataframe to a pandas dataframe. The reason I am asking this is because I would like to save my snowpark dataframe to a csv file.
Great Video!! Can you please create a video on how to design the Session Configs section so that it can connect to Snowflake that has Single Sign On and also how to move this code in QA and production environments ( CI/CD)? you can also create a Udemy course for that I will buy that :)
Very useful. Thank you!
Very nice. So basically, snowpark is "async" by design in a way.
snowpark is good imo, the only things I dont like it much is snowpark only supports only python 3.8.
This is one of the best Snowpark tutorials out there! Thanks @Aimpoint Digital!! Will be tuned in for future videos.
Wow! Very simple to understand and love the combination of coding and theory explanation. Chris, you got the gift to convey a complete message in an easy one. Please don't stop as there a not a lot of clear snowpark videos on RUclips. One thing I was hoping to see is the initial setup and connection to snowflake also importing snowflake connection. Liked, subscribed immediately, and even pushed the bell so I won't miss any future videos
Quantity was applied to just the discount which is how this ended up with the negative revenues. Quantity should have been applied to the whole equation. Enjoyed the video though. Good walkthrough
nice explanation
Can you u use alteryx for biology?
No, Its used for physics in aerodynamics
Python is actually quite easy to learn. Learn Python, and you won't be hamstrung by the limitations of a graphical substitute for actual programming. Moreover, you'll be able to take your Python skills with you from job to job, as opposed to building a career around the narrow set of employers who are using this or that proprietary alternative. If you're the sort of person who likes logical abstractions, then you will do well with Python. If you're not that sort of person, then you shouldn't be doing doing data cleaning and analysis work anyway. Cleaning and analysis is all about clear logical thinking. People that do well with that sort of task don't need a dumbed down alternative to actual programming.
And if you do happen to want a drag-and-drop view for your pipeline, just install the free app Orange from your Anaconda dashboard. If the tool already exists for free then why make it a paid service?
@@maxfinnian The future of drag-drop quasi-programming likely going to be free tools that do baby-Python tasks and blend well with Python itself.
What you say resonates with me, thanks for sharing your opinion!
Orange in anaconda
Orange in anaconda
I really like it !
Thanks, a good watch and very appropriate foundation for modern analytics.
Thanks Dan!
then who needs ML engr. , data scientist and data analytics anymore? if we have this software? Were those position I mentioned created this Alteryx? or is it the software engr. ? Either way, they dug graves for those positions except software engr.
Good insight, have the same questions as you, been living the transformation to a similar tool in my current position and makes me wonder if they will cut down on headcount because of this
Love the cat !
This is an absolutely brilliant introduction to Designer! Fun, informative and a great production! Well done! Can you make APA as easy and clear to understand?
That's a great suggestion!
So I buy a bunch of Alteryx stock, give it a few years and I retire RICH?
Yes i would like to know too lol
Aimpoint Digital don't offer financial advice, but only invest what you're prepared to lose and a diversified portfolio is key to reducing risk.
@@AimpointDigital THATS A YES! I do actually own some at 120 or so.
@@bernardthefourth lmao
Don't think that investment has paid off
Hi there. This was a quick helpful video. Meanwhile, is Incremental loading possible in Alteryx and how is this handled?
This would require filtering out data that is already in your target. To do this, join your source data with the target dataset on a key field. The unmatched records will be the delta for loading. You can leverage the power of your database to make this process quicker by using the In-Database Tools in Alteryx. Please reach out to the Alteryx Community for more help.
etl, ml, reporting . Wow it can do a lot!