Nathan Patrick Taylor
Nathan Patrick Taylor
  • Видео 104
  • Просмотров 1 178 033
Faster Data Loads with Change Data Capture
We left off the series talking about incremental loading, but if we are pulling data from a Microsoft SQL Server database, we can take advantage of the Change Data Capture (CDC) feature to make the data load faster.
Chapters
00:00 Intro
01:11 Enable CDC in SQL
04:03 Review CDC in Panoply
04:34 Show Results
06:18 Recap
Link to CDC instructions for SQL Server: learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-data-capture-sql-server?view=sql-server-ver16
#NPT #Panoply #DataWarehouse
Просмотров: 10 925

Видео

Crazy Easy Incremental Loading with Panoply
Просмотров 11 тыс.Год назад
When you have large amounts of data to refresh, it may make more sense (and be MUCH faster) to only load changes and new data. That's where incremental loading comes in handy. Let's jump back into the Panoply platform and demo how incremental loading works. Chapters 00:00 Intro 00:43 Data Review 02:49 Setup 05:14 Data Collection & Update 07:46 Collect Changes 09:21 Outro #NPT #Panoply #dataware...
Panoply - My Story and Intro to the Platform
Просмотров 11 тыс.Год назад
I'm SO excited to bring you my story and experience with Panoply, a managed ELT Cloud Data Warehouse platform. This is the first video in a series of content about the platform and how I use it. Rock on 😎🤘 Check out the Proof of Value and sign-up for a free 60-day trial: blog.panoply.io/exploring-panoplys-new-60-day-proof-of-value platform.panoply.io/#/signup Scalability Paradox Webinar: blog.p...
Alteryx - Auto Insights: Stop Creating Dashboards Manually
Просмотров 17 тыс.Год назад
I've been using Auto Insights for several months now. I'm super excited to start creating content around this new add-on for the Alteryx Platform. Back in my day, we created dashboards from scratch! Now we can have "insights" automatically created and delivered to users on a recurring basis. Watch and learn. Chapters Storytime 00:00 Back in my Day 01:12 The Data 02:21 Uploading to Auto Insights...
Alteryx - Four Methods and Tools to Fix Missing Data
Просмотров 2,4 тыс.2 года назад
Thanks to Harshit Gola for this week's video suggestion! I'll walk you through four methods for computing or handling missing data in columns. Chapters 00:03 Intro 00:18 Dataset 00:56 The Goal 02:12 First Method 02:49 Second Method 04:35 Third Method 06:54 Fourth Method 08:18 Outro #NPT #alteryx #analytics
Panoply - Easily Load Data from SQL Server
Просмотров 15 тыс.2 года назад
I love to just dive right in! Let's quickly run through the process of loading data from a Microsoft SQL Server database. Chapters 00:21 - From Home Page 01:16 - Completing the Form 01:13 - Whitelisting 02:08 - IP Address 03:30 - Changing the Name 03:50 - Advanced Settings 05:12 - Primary Key 06:54 - Save and Collect 07:37 - Collection Complete 08:01 - Workbench 09:08 - Schedule Collection 09:4...
Alteryx - Auto Insights Interview at Inspire 2022
Просмотров 7362 года назад
Link to Auto Insights page: www.alteryx.com/products/auto-insights The three coolest subs: Angela Smith Shawn Sundaram Nanjappan Nick D'Allesandro Chapters 0:00 Intro 2:35 Interview 7:20 Outro
Alteryx - Format Numbers as Text
Просмотров 2,9 тыс.2 года назад
Sometimes you just want to output a numeric field in a specific text format for easier user readability. You can use a combination of the Formula Tool and the ToString function to make it happen! Help Guide for ToString Function: help.alteryx.com/20214/designer/conversion-functions Help Guide for DateTime Function: help.alteryx.com/20214/designer/datetime-functions #NPT #Alteryx #Formatting
Alteryx - Power BI Output Tool Revisited!
Просмотров 6 тыс.2 года назад
I've been sitting on this video for several weeks while working on uncovering the various hints and tips for using the Power BI Output tool. The tool itself is super easy to use. Most of the video is geared toward the data prep component of using the tool successfully. Chicago Data Portal - Food Inspections: data.cityofchicago.org/Health-Human-Services/Food-Inspections/4ijn-s7e5/data ISO 8601 D...
Alteryx - Fixing Server File Not Found Error
Просмотров 2,1 тыс.2 года назад
Several people have asked similar questions about files errors on the Alteryx Server Gallery. The most likely cause is an incorrect path within the workflow once posted to the Server. I'll show you how to define a UNC path to fix the issue. #NPT #Alteryx #Server #Gallery
The Lost Prezy! Will Robots Take My Job?
Просмотров 1922 года назад
Pre-pandemic I put together a presentation for a client that (due to the pandemic) never saw the light of day. Their loss is your gain. What can we learn from the past to prepare for job automation? #NPT #Automation #RobotApocalypse
Alteryx - Concatenate (Combine) Strings using the Summary Tool
Просмотров 4,6 тыс.2 года назад
Whenever I run into an interesting solution, I wonder if it'll make for good content. In this case, concatenating strings is a GREAT subject. I'll walk you through the process of combining strings using the Summary Tool. #NPT #Alteryx #Concatenate
Reverse ETL - 🚩 Census Event 🚩 Sync a Swag 👕🧦👜
Просмотров 3722 года назад
Excellent news! Census is hosting a "Sync a Swag" event. Simply sign up for an account and sync your contact info to receive a sweet SQL shirt. Event link: www.getcensus.com/sync-a-swag #NPT #Census #ReverseETL
Reverse ETL: Tableau Actions (Why we're not crazy 🤪😜)
Просмотров 2022 года назад
Reverse ETL: Tableau Actions (Why we're not crazy 🤪😜)
Reverse ETL - Setting Census 🔔🚨 Alerts and Triggers 🚨🔔
Просмотров 1022 года назад
Reverse ETL - Setting Census 🔔🚨 Alerts and Triggers 🚨🔔
Why Even Use Reverse ETL? 🤯🧐😱
Просмотров 5802 года назад
Why Even Use Reverse ETL? 🤯🧐😱
Reverse ETL - Using Census to Update Salesforce via Redshift
Просмотров 3082 года назад
Reverse ETL - Using Census to Update Salesforce via Redshift
What Even is Reverse ETL? 🤷‍♂️🤷‍♀️
Просмотров 26 тыс.2 года назад
What Even is Reverse ETL? 🤷‍♂️🤷‍♀️
Reverse ETL - Using Census to Update Salesforce Referrals from Custom SQL
Просмотров 1422 года назад
Reverse ETL - Using Census to Update Salesforce Referrals from Custom SQL
Reverse ETL - Using Census to Update Mailchimp Via Google Sheets
Просмотров 1532 года назад
Reverse ETL - Using Census to Update Mailchimp Via Google Sheets
Alteryx - Using the Render Tool to Format Excel Files
Просмотров 21 тыс.2 года назад
Alteryx - Using the Render Tool to Format Excel Files
Alteryx - Run Command Like a Boss
Просмотров 10 тыс.2 года назад
Alteryx - Run Command Like a Boss
Alteryx - How to use the Block Until Done Tool
Просмотров 10 тыс.2 года назад
Alteryx - How to use the Block Until Done Tool
Alteryx - Take a Side Trip with the Detour Tool
Просмотров 2,9 тыс.2 года назад
Alteryx - Take a Side Trip with the Detour Tool
Alteryx - Browse Tool Revisited
Просмотров 1,7 тыс.2 года назад
Alteryx - Browse Tool Revisited
Alteryx - Dynamically Pass a Value to SQL Stored Procedure
Просмотров 7 тыс.2 года назад
Alteryx - Dynamically Pass a Value to SQL Stored Procedure
Career Advice from the Joker
Просмотров 1812 года назад
Career Advice from the Joker
New Series Teaser - September 2021
Просмотров 992 года назад
New Series Teaser - September 2021
Excel for Biostatistics - Proportion Using Normal Distribution Formula
Просмотров 1,4 тыс.3 года назад
Excel for Biostatistics - Proportion Using Normal Distribution Formula
Excel for Biostatistics - Probability of Success Using Binomial Distribution Formula
Просмотров 2 тыс.3 года назад
Excel for Biostatistics - Probability of Success Using Binomial Distribution Formula

Комментарии

  • @yyz619
    @yyz619 7 дней назад

    How to send the output table as an attachment to email?

  • @valerie702
    @valerie702 7 дней назад

    This was the best Alteryx tutorial on RUclips that i have ever seen. You saved me hours of work! Thank you for your service.

  • @marcandreMT
    @marcandreMT Месяц назад

    thank you very much all I can to do is to subscribe :)

  • @NathaliaSolisKlein
    @NathaliaSolisKlein Месяц назад

    Is there a way to change the shape of the boxes based on inputs from the data? For example, I want everyone that is based in the US to be in a circle instead of a square.

  • @SkyHighBlueSky
    @SkyHighBlueSky 2 месяца назад

    Get on with it you muppet

  • @madhavireddy6593
    @madhavireddy6593 2 месяца назад

    Hi Nathan...i have a workflow where i use two server api tools one is to get all workflows list and the other is to match the users list wrto the workflows and i join these two with a join tool and a browse tool at the end..i get the required data but how to download this to a file like xlsx...

  • @TheSiNnEr734
    @TheSiNnEr734 3 месяца назад

    What about if I get an error on the input tool

  • @soniaevwoja6535
    @soniaevwoja6535 3 месяца назад

    5yrs after and I got the job done. Thank you Nathan

  • @robtop2364
    @robtop2364 3 месяца назад

    This helped a lot. I was stuck with this same issue but now it’s solved thanks to you.

  • @jonwlawley
    @jonwlawley 4 месяца назад

    Can I use TRIMRIGHT to remove a space and a character? If not what do you do you recommend? Appreciate the help!

  • @tgvrreddy9867
    @tgvrreddy9867 4 месяца назад

    Can you please make a video macros.

  • @raviranjansingh5527
    @raviranjansingh5527 4 месяца назад

    Hi Sir, my problem resolve on this video .thank you

  • @murrowboy
    @murrowboy 4 месяца назад

    Using Dynamic Input tool, I'm getting an error too much records #1.. I have no idea what that means..

  • @murrowboy
    @murrowboy 4 месяца назад

    Is this a "control" tool. The idea that this tool even exist makes me believe processes just run on their own times and you can have bad data if some finish prematurely.

  • @sagardasa176
    @sagardasa176 5 месяцев назад

    Can u ping the link for part 3

  • @photomaster1
    @photomaster1 5 месяцев назад

    Thank you for keeping it simple...

  • @janys2604
    @janys2604 5 месяцев назад

    thank you so much, that is very useful. I already subscribed to your channel

  • @user-ht9ct4ih8p
    @user-ht9ct4ih8p 5 месяцев назад

    Without ctrl keyword can we do multiple select on multiple bar chart

  • @sunithach766
    @sunithach766 5 месяцев назад

    Hi... When we are using dynamic input how to choose the sheets inside xlsx file??

  • @ssidhpura05
    @ssidhpura05 6 месяцев назад

    Im new to Alteryx and spent several hours today for parsing json data. Thank you for making this video , I followed as you mentioned and was able to get my work done.

  • @surajgaikwad1093
    @surajgaikwad1093 6 месяцев назад

    Is persistent filters work for embed reports ?

  • @BrianGarside
    @BrianGarside 6 месяцев назад

    Great demonstration of this tool. Love to see the SQL: Spatial Filter as this pertains to a project Im working on.

  • @user-be7kp2nu1l
    @user-be7kp2nu1l 6 месяцев назад

    Great video Nathan! Are you planning to make a REST API with OAuth 2.0 video anytime soon? Thanks!

  • @jonathanlee3776
    @jonathanlee3776 6 месяцев назад

    Thank you for this video! I often need to grab the same data from different data warehouses due to the frequency at which certain data is updated by certain departments, and dynamic inputs have been a lifesaver for combining that data efficiently. Will definitely be watching more of your Alteryx videos to learn more!

  • @user-ge7gn7km7q
    @user-ge7gn7km7q 6 месяцев назад

    thank you so much

  • @user-ge7gn7km7q
    @user-ge7gn7km7q 6 месяцев назад

    thank you so much, this helped me so much

  • @rajm5349
    @rajm5349 7 месяцев назад

    thanks for ur explanatin, can u xplain any healthcare data

  • @rajm5349
    @rajm5349 7 месяцев назад

    thanks for nice explanation, can explain any health care project

  • @andreashagemann6660
    @andreashagemann6660 7 месяцев назад

    Perfect that solved it! Thanks mate

  • @PP-dv5gf
    @PP-dv5gf 7 месяцев назад

    HI NATHAN, CAN YOU PLEASE SHARE THE DATASETS/INPUTS WHICH YOU USED HERE IN THE WORKFLOW? THANK YOU!

  • @user-ys9ig5om3l
    @user-ys9ig5om3l 7 месяцев назад

    Hey Nathan, thanks for your videos which are really helpful for new bees in Alteryx. But I have noticed that you did not update new videos since one year ago. I hope everything is good at your side!

  • @Commonopeople
    @Commonopeople 7 месяцев назад

    Grt work

  • @Lephaswi
    @Lephaswi 7 месяцев назад

    Is there a way to pass a table type or a list as a parameter to a stored proc using Alteryx?

  • @arpitsirohi8095
    @arpitsirohi8095 7 месяцев назад

    Great Video

  • @beingrishi6450
    @beingrishi6450 8 месяцев назад

    THUNDER ALTERYX

  • @brandonwarfield5611
    @brandonwarfield5611 8 месяцев назад

    Finally found something I understand but can't use because app no longer exist in power bi. 😭😭

  • @davecummins4605
    @davecummins4605 8 месяцев назад

    i love this message and completely agree with the concept of get er done. my one criticism is, that employers often foster an environment that sucks this initiative out of these good men. if men like this were rewarded and taken care of, we would see more of them.

  • @xriotte
    @xriotte 9 месяцев назад

    I faced this problem today... Disabling the 1904 data system option won't solve your problem. Alteryx will be able to read it but it will change the dates to the 1900 system. So instead of adding the number of days to 1904-01-01 it will add it to 1900-01-01. So all your dates will be four years earlier! The solution I found was the following: - Ensure the dates are stored in numbers in Excel. - Input the Excel file as it is. - Add the following formula tool to get the right date: DateTimeAdd("1904-01-01",[DATE_IN_1904_NUMBER_FORMAT],"days")

  • @elrober5575
    @elrober5575 9 месяцев назад

    @Nathan, I am struggling to generate a single e-mail to one recipient attaching an Excel Spreadsheet with multiple tabs. Would you shed some light? Thanks!

  • @user-lw7sz8qv3c
    @user-lw7sz8qv3c 9 месяцев назад

    Hi If we have comments in a json file how can we pass in alteryx because if i pass i couldn't able to get the output

  • @ossamaahmed6028
    @ossamaahmed6028 10 месяцев назад

    really great guide and to the point. but even after converting the inspection date column using the datetime tool in Alteryx I still receive the parsing error! the dates after formatting are in this format and of the date type 2023-08-31!

  • @user-yz6ie2qv6p
    @user-yz6ie2qv6p 10 месяцев назад

    Hi does anyone know when i create an analytical ap with a text box i would need to enter the text using quotation marks...dont know why i get a 'parse error' message

  • @sm1291
    @sm1291 10 месяцев назад

    how to use detour for more than 2 stream? Could you please explain. For eg user has to be give 3 or maybe more calculation options, then how can we configure the workflow? Could you share and example if possible?

  • @nelson_k_d
    @nelson_k_d 10 месяцев назад

    Hi Nathan, Please create a video on how to import multiple excel files from a folder dynamically, each excel file having multiple sheets (say sheet1 & sheet2). Data of sheet1 needs to be appended from all excel files. How to do that? Thanks in advance.

  • @ashwinkumar5223
    @ashwinkumar5223 11 месяцев назад

    Please share the dataset file

  • @nikakalichava8012
    @nikakalichava8012 11 месяцев назад

    Thanks.

  • @shamalchavan08
    @shamalchavan08 11 месяцев назад

    1) how to use IQR or z score with date data type ? is there any way to detect outlier in date data type in power bi/ power query ? 2) the scatter chart u used to showcase the outlier is this same as normal scatter chart or it is specifically design for outliers ? plz guide

  • @PujaKiPyaariDuniya
    @PujaKiPyaariDuniya 11 месяцев назад

    I have sheet(Y) in Excel which has formulas(cell referencing to other cell values from another sheet).let's say (X) Every day the another sheet(X) count increases and I have to copy paste formulas to new rows manually Can we automate this ?

  • @angelmaravilla4708
    @angelmaravilla4708 Год назад

    That visual (Power Bi Outliers Detection) is not longer available in Power Bi, do you knwo why or what can I do to get it??? PD: Great video