- Видео 37
- Просмотров 70 999
DataAnts
США
Добавлен 30 мар 2019
A channel dedicated to providing insights, tips, tricks and how-to tutorials around data visualization, NetSuite ERP, and business intelligence.
Follow us for more:
LinkedIn:
www.linkedin.com/company/dataants
Get Started with our mentorship program:
rb.gy/wlld1
RUclips:
ruclips.net/channel/UClqCaokBYOMxbWIIROZuDzw
Facebook:
dataants/
Instagram:
dataants
Twitter:
mobile. data_ants
Get the Free NetSuite Career guide here:
NetSuite ERP Career Guide (gumroad.com)
Saved Searches to Excel/Power BI automation guide here:
Automate NetSuite Saved Searches to Power BI/Excel (gumroad.com)
#DataInsights #ERP #NetSuite #Tableau #PowerBI #DataViz #BusinessIntelligence #CloudComputing #ArtificialIntelligence #MachineLearning #DataAnalytics #DataScience #Productivity #Collaboration.
Follow us for more:
LinkedIn:
www.linkedin.com/company/dataants
Get Started with our mentorship program:
rb.gy/wlld1
RUclips:
ruclips.net/channel/UClqCaokBYOMxbWIIROZuDzw
Facebook:
dataants/
Instagram:
dataants
Twitter:
mobile. data_ants
Get the Free NetSuite Career guide here:
NetSuite ERP Career Guide (gumroad.com)
Saved Searches to Excel/Power BI automation guide here:
Automate NetSuite Saved Searches to Power BI/Excel (gumroad.com)
#DataInsights #ERP #NetSuite #Tableau #PowerBI #DataViz #BusinessIntelligence #CloudComputing #ArtificialIntelligence #MachineLearning #DataAnalytics #DataScience #Productivity #Collaboration.
Transcribe Video files locally using AI
Process OBS recordings or any video/audio files with AI-based transcription and summarization locally on your machine.
Features
AI transcription using Whisper.
Summarization using Hugging Face Transformers.
File selection, resource validation, and error handling.
Installation
Clone the repo. git clone [github.com/DataAnts-AI/VideoTranscriber.git cd VideoTranscriber
Install dependencies: pip install -r requirements.txt
Notes: Ensure that the versions align with the features you use and your system compatibility. torch version should match the capabilities of your hardware (e.g., CUDA support for GPUs). whisper might need to be installed from source or a GitHub repository if it's not available on P...
Features
AI transcription using Whisper.
Summarization using Hugging Face Transformers.
File selection, resource validation, and error handling.
Installation
Clone the repo. git clone [github.com/DataAnts-AI/VideoTranscriber.git cd VideoTranscriber
Install dependencies: pip install -r requirements.txt
Notes: Ensure that the versions align with the features you use and your system compatibility. torch version should match the capabilities of your hardware (e.g., CUDA support for GPUs). whisper might need to be installed from source or a GitHub repository if it's not available on P...
Просмотров: 68
Видео
Transform Your Data Management with NetSuite File Cabinet Downloader | Custom Solution
Просмотров 112Месяц назад
Are you tired of manually downloading files from NetSuite? Say goodbye to the hassle and hello to efficiency! Introducing the NetSuite File Cabinet Downloader - your ultimate solution for automated file retrieval. Reach out here for a demo - forms.gle/PZkVuXG5EbRxeajb8 🔍 Key Features: Custom Criteria Downloads: Tailor your downloads based on specific criteria, ensuring you only get the files yo...
Build a Python Web App to Retrieve NetSuite Data via SuiteQL | AI
Просмотров 2743 месяца назад
Welcome! In this tutorial, we’re diving into NetSuite SuiteQL to build a fully functional web app for querying NetSuite data using Python. This is a free solution using NetSuite's Rest API and you can deploy it internally on your local machine or on the cloud -Build a query interface using Flask & Flask-SocketIO. - Use SuiteQL for powerful SQL-based queries in NetSuite. - Deploy the app locally...
NetSuite Solutions | Automate Your Currency Exchange Rate files daily to File cabinet or Email them
Просмотров 1114 месяца назад
Tired of manually tracking currency exchange rates? Our powerful SuiteScript solution is here to automate the entire process! The solution extracts daily currency exchange rates, generates a professional Excel report, and sends it directly to your email inbox or places them in a folder in your File Cabinet of your choice. saisunkara.gumroad.com/l/netsuiteexchangerates With our solution, you can...
Integrate NetSuite Saved Searches with Google Sheets via SS Connect tool - Save on licensing costs
Просмотров 3225 месяцев назад
Advantages of Saved Search Connect Tool (SS Connect): - Save NetSuite licensing cost - Create dynamic pivot tables - Custom trends - Better customizability - Schedule refreshes of saved search data Reach out to us here with any questions you have for pricing/implementation: forms.gle/dYGgzxYhyWraGWma8 or Email: support@dataants.org Script to connect Saved Searches to Google Sheets: docs.google....
Step-by-Step NetSuite JDBC Integration with DataGrid Using SuiteAnalytics Connect
Просмотров 4987 месяцев назад
Unlock the full potential of your NetSuite data with JDBC integration to DataGrid or any IDE using SuiteAnalytics Connect! In this tutorial, we'll walk you through the step-by-step process of setting up a seamless connection between NetSuite and DataGrid. Learn how to leverage JDBC drivers to access and analyze your NetSuite data efficiently. Whether you're a NetSuite administrator, developer, ...
Integrating Online Leads into NetSuite - Easy Route
Просмотров 2138 месяцев назад
Learn how to streamline your lead management process by capturing online leads directly into NetSuite! In this comprehensive training video, we guide you through the step-by-step process of setting up and integrating lead capture data on your website or landing pages with a NetSuite form. Need help with NetSuite training or help with optimizing your NetSuite instance, reach out to us here: docs...
Discussion - NetSuite Data Model and Data Extraction
Просмотров 1,6 тыс.9 месяцев назад
If you want further help with your NetSuite data, fill out this form and my team will reach out to you to assist: -Analysis of your NetSuite data -SuiteQL queries to build Custom Reports -Business Intelligence Tool Consultation -NetSuite Training docs.google.com/forms/d/15nx8elytSxnO81LIpU7bTEdI72RE4V1RMYRXUY23ctM/edit Reach out to us at support_dv@dataants.org Section 1: Understanding the NetS...
Learn SuiteQL: Guide to Understanding and Querying NetSuite Data
Просмотров 1,9 тыс.11 месяцев назад
Do you want to learn how to use SuiteQL to create custom reports, dashboards, and integrations with NetSuite data? Do you want to discover the best practices and tips for writing efficient and effective SuiteQL queries? Get the SuiteQL guide here: saisunkara.gumroad.com/l/suiteql What is included: SuiteQL basics: What is SuiteQL, how it differs from SQL, and what are the syntax and data types o...
How to Build a Cash Flow Statement in Power BI using NetSuite SQL
Просмотров 830Год назад
Learn step-by-step how to create a comprehensive cash flow statement using Power BI and NetSuite data. Increase financial visibility and make informed business decisions. Install the SuiteQL query tool in your NetSuite instance: ruclips.net/video/aOye-az-FVk/видео.html Save 40% off DataAnts product - Auto Connect Saved Searches to Power BI: saisunkara.gumroad.com/l/kapzz/idv3d0k SuiteQL query t...
Understanding NetSuite Analytics Warehouse: A Comprehensive Overview
Просмотров 1,2 тыс.Год назад
A Closer Look at NetSuite Analytical Warehouse: How It Can Benefit Your Business NetSuite Analytical Warehouse is a powerful business intelligence tool that can provide you with valuable insights into your business. In this video, we'll take a closer look at its benefits and how it can help you make better decisions. Whether you're looking to improve your operational efficiency or boost your sa...
How to reduce NetSuite User licensing costs | Saved Search to Excel automation
Просмотров 302Год назад
We're helping NetSuite clients save user licensing costs through automated Saved Search export to Excel, Google sheets, Power BI and other BI tools. - Reduce Licensing Costs - Create Key KPIs, visuals and reports to share with your Executive team - Schedule refreshes at the frequency required - Seamless Integration Reach out here for a demo and get started: lnkd.in/gZSYEGm2 #netsuiteerp #saveds...
NetSuite Saved Searches | Send an email alert when a bill is rejected
Просмотров 841Год назад
Stay tuned for more sessions where we'll delve deeper into NetSuite's functionalities, customization, and integration possibilities. Make sure to like, subscribe, and hit the notification bell to stay updated on our upcoming tutorials. Sign up here if you're interested in our training program or need help with NetSuite customization or reporting: forms.gle/jiDFPdy59BhDEcH98 📢 Don't forget to LI...
NetSuite fundamentals 101 - Comprehensive overview to get started for an Admin
Просмотров 1,4 тыс.Год назад
📚 NetSuite Fundamentals: Session 1 - Introduction to NetSuite, User Interface, and More! 📊 Welcome to our comprehensive NetSuite Fundamentals tutorial series! In this Session 1, we're diving into the basics of NetSuite, the cloud-based ERP system that's transforming businesses worldwide. Whether you're a newbie or looking for a refresher, this video is your gateway to understanding NetSuite's c...
Day in the Life of a NetSuite Administrator
Просмотров 1,4 тыс.Год назад
We are starting a comprehensive NetSuite training and mentorship program! Whether you're a beginner looking to master the fundamentals or an experienced user aiming to optimize your NetSuite career, we've got you covered. Sign up here docs.google.com/forms/d/1CT1U_lU9v7FFDdYv7V-qCEz0Dzq8U1p2rrcjaQOLoBY/edit To pay for the program: saisunkara.gumroad.com/l/netsuitementor or reach out to support_...
NetSuite Role Management: Mastering Access Reset and Role Differences
Просмотров 377Год назад
NetSuite Role Management: Mastering Access Reset and Role Differences
SS_Connect : 'Automate Saved Searches to Power BI' - A DataAnts Product
Просмотров 850Год назад
SS_Connect : 'Automate Saved Searches to Power BI' - A DataAnts Product
Excelling in NetSuite: The Top 5 Tips for Administrators
Просмотров 1 тыс.Год назад
Excelling in NetSuite: The Top 5 Tips for Administrators
Automate NetSuite Saved Searches with Power BI/Excel: Streamline Your Data Analysis
Просмотров 4,6 тыс.Год назад
Automate NetSuite Saved Searches with Power BI/Excel: Streamline Your Data Analysis
Unleash the Power of your NetSuite Data with SuiteQL: An Introduction to the Query Tool in NetSuite
Просмотров 7 тыс.Год назад
Unleash the Power of your NetSuite Data with SuiteQL: An Introduction to the Query Tool in NetSuite
ChatGPT with NetSuite - Suitescript/SuiteQL from scratch?
Просмотров 6 тыс.2 года назад
ChatGPT with NetSuite - Suitescript/SuiteQL from scratch?
Connect Power BI with NetSuite via SuiteAnalytics Connect [ODBC drivers]
Просмотров 12 тыс.2 года назад
Connect Power BI with NetSuite via SuiteAnalytics Connect [ODBC drivers]
5 ways To Export NetSuite Data - Free vs Paid options
Просмотров 4 тыс.2 года назад
5 ways To Export NetSuite Data - Free vs Paid options
Advanced Formulas in NS Saved Searches - MTD, QTD, YTD
Просмотров 1,6 тыс.2 года назад
Advanced Formulas in NS Saved Searches - MTD, QTD, YTD
Transaction Searches in NetSuite - How to create, monitor and share?
Просмотров 1,3 тыс.2 года назад
Transaction Searches in NetSuite - How to create, monitor and share?
SuiteAnalytics - NetSuite workbook guide
Просмотров 1,3 тыс.2 года назад
SuiteAnalytics - NetSuite workbook guide
Connect NetSuite to Power BI/Excel via WebQuery with refresh capability
Просмотров 11 тыс.2 года назад
Connect NetSuite to Power BI/Excel via WebQuery with refresh capability
NetSuite Saved Searches - introduction part 1
Просмотров 6552 года назад
NetSuite Saved Searches - introduction part 1
Tips to crack the NetSuite Administrator interview
Просмотров 3,9 тыс.2 года назад
Tips to crack the NetSuite Administrator interview
Introduction to SuiteAnalytics - NetSuite - Datasets and Workbooks
Просмотров 6522 года назад
Introduction to SuiteAnalytics - NetSuite - Datasets and Workbooks
Hey Good job, I would recommend to try to zoom in on what you are doing when you edit your video, hard to see steps.
Hola, me aparece error 500 al tratar de conectame al URL de netsuite,
Can U connect ns using OAuth2.0 in datagrip? I have generate access token(M2M), and add the prop: OAuth2Token=xxx. But it dosen't work
Hi everyone, I'm facing an issue in NetSuite where I cannot find the 'Set Up SuiteAnalytics Connect' option in the Settings Portlet or anywhere in the setup menus. I've already checked the following: SuiteAnalytics Connect feature is enabled under Setup > Company > Enable Features. I'm using a role with full Administrator permissions. I've searched through the menu and tried the Global Search feature but still can't find the setup option. I’ve also verified my subscription should include SuiteAnalytics Connect, and I’ve tried switching to the classic UI to see if it makes a difference. Has anyone experienced a similar issue? Any help or advice on what I might be missing would be greatly appreciated! Thanks in advance!
The suite Analytics that you have created should be assigned to and Administrator role. Then we will be able to see the option under Settings portlet. This worked for me. If there are any other options that needs to be considered apart from assigning it to administrator role, please mention. Thank you @DataAnts for this useful video.
Good video! Can you share GitHub repository?
Haven't uploaded to GitHub yet, will paste the link here once done
Hello, Can we have a discussion on this? Will i need to generate the url everytime?
You generate it once and the link is available for reuse. You can reach out to developer@dataants.org if you want to have a demo
Is there a way to pull saved searches or custom reports via this ODBC connection?
Not possible via ODBC but you can pull saved searches via REST API, and certain custom reports via Web query. With ODBC you will have to rebuilt those saved searches/reports
Hi, I dont see webquery in my netsuite even I have admin. rights
It's not available for all reports, try looking for a custom non financial report to see the web query option
"Access Denied" - of course it is. 😮💨
hello can you do a video about netsuite developer
Hello - I was watching your following video and was trying to figure out how to generate CSV file url. When I open my saved search it has excel icon and it straight away downloads the data into excel. Can you please clarify how to get the url or a file link from Netsuite?
Not working after following your workaround, system shows error "Suitelet is invalid, disable or no longer exists".
¡¡¡¡Thanks!!!! Just in case, do you know of any way to mass delete roles per employee?
hey, i am getting error after installing suiteQL.Error is "module doesn't exist".
Love it, thanks!
Thank you! Your instructions were spot on and I have successfully installed the SuiteQL Query Tool. The only issue I have is that even though I set permissions for it to "Everyone", so far nobody else on my team is able to access the tool due to perms.
You can grant permissions to users/roles on the script deployment page. If it still doesn't show up, they probably have a different center than you so the menu is different. You can always send them the deploymentURL of the tool to access the SuiteQL query page
way too small = illegible
Thanks for this video and really helpful.
Is this accessible via Power BI Online, or only Power BI Desktop? And can it automatically refresh on Power BI Online?
It can work with both Power BI desktop and Online with refresh capability on Power BI online
Hi, i hope you are doing good, Please let me know from where we can enable external ID for item, I am not able to find the option to make it enable. Although I can update external ID using SOAP.
wi-see-wig wi rhymes with "it" a short vowel: WYSIWYG what you see is what you get
I have already connected netsuite to excel using odbc. But I am not able to get data in powerbi from netsuite. Does this need some separate settings?
It is the same ODBC connection you use to pull the data in Excel or Power BI. Make sure to test it directly on the ODBC settings to see if there's any issue with the username/password combination
Thanks. Do you mentor people, if yes how do I get in touch with you?
How external systems connect to the data in NSAW? I don't see any external connectors connecting to NSAW?
There are a few prebuilt connectors that can bring external data into NSAW
Hii i am not getting the data . It's showing unauthorized access in browser and it's also not fetching data in power bi
It has been reprecated. No longer working
@@shinanigans1992 Now I am able to get the data. It's working now.
@@shinanigans1992 still working for me
@@shinanigans1992 what would be the new alternative if this approach no longer works?
Is it a typical analytics warehouse? Can you connect it to other third party tools?
Yes, can be connected with third party tools. It is a typical warehouse but in the NetSuite ecosystem
Thank you for the video. I was able to successfully connect ODBC, however I find the tables are empty. I tried querying by limiting dates, still outputs empty table with table headers only. Can you help me why this is happening.
You need to have the right role/permissions connected with the Suite Analytics Connect (ODBC) driver in order to view the data under the tables. Make sure the role permissions are relevant for the data you're trying to pull
Thank you for this video. This video is very helpful in getting more knowledge to connect NetSuite with Power BI
firrreeee!! thank you so much!!!!! soo clear, easy, and efficient! let's gooo!
Great content. But can not see anything. The text is toooooooooooooooooo small to be helpful.
Connection has been build up successfully.. But there is a huge volume of data (let's say lacs of rows are there in the table), how to restrict/put filter & load only the limited rows while loading the table at the very first stage. Please let me know.
You need to filter on the Power BI side where you can limit by writing a Suite QL query when connecting to the data source and use where clauses.
Hi Sai, This is really amazing. Day to day I've to do lots of data analysis and sometimes running queries through third party tools is very slow. Thank you for making this video and sharing with us. Also, thank you for the author of script who developed it.
if I have products orders with product images, how to export to excel and images rendered in each cell of products ?
Can you create a video to show how to convert the text columns to numbers. It is giving me an error
Thanks mate
No wonder so many people dump netsuite and go for D365, this power bi connection is insanely complicated and costly
If netsuite doesn’t fix this in 5 years the whole brand will gone
Is it possible to execute an update query when using SuiteQL in Postman? @dataants
Hey there! Thanks for the video! Would you say it is possible to create results to be displayed by week, ordered from Monday to Sunday? For example: - One column which shows sales of last Monday until today (current week). - Other column which shows last ended week sales (from previous Monday to last Sunday) - Other column which shows (for eg) last 4 closed weeks.
Can you please send me the file? I want to try it Out first.thanks.
how to enable suiteql tab in menu bar in netsuite?
Go to the script deployment page for the SuiteQL suitelet, and under Links tab - choose the center, section and category to show the SuiteQL option in the menu bar
what to do when we have more than 10k rows I have active scripting error ?
Try to break it into two reports using date filters to see if the error goes away when importing the web queries. You can always merge the datasets in Power BI/Excel for your analysis.
@@dataants Yes, this is what I do, actually but do you have any idea of the limitations ? or any other solution ?
@@karimderouich Other alternatives would be: Via saved search - ruclips.net/video/pUK6npJQIds/видео.html Paid - ODBC connector (SuiteAnalytics connect) - write SuiteQL to retrieve the data you want into Power BI/Excel
I am getting An unexpected error has occurred. Please click here to notify support and provide your contact information. when i try to go to lists customer suitqql test, I have set the permissions.
Make sure when you upload the script file to create the Suitelet/Restlet, the extension is set to .js - Try redoing the steps following the video and it should work
@@dataants thank you that worked.
Hello data ants this is shivam actually i'm trying the web query process its shows me "unexpected exit " and i'm follow the same process according to that your video. can you please guide me on that drop me mail on the same
We have noticed some issues when connecting with Web queries in the latest version of Power BI. I would suggest trying the approach in the video below using Excel to see if it works - ruclips.net/video/RWBbTd2Umes/видео.html
Man! you should zoom in. Not everyone has a wide screen to view.
Will keep that in mind for future videos, thanks for the feedback.
@@dataants Yeah it's pretty useful information but i am squinting with my face against the screen to see it. Just change your monitor resolution before you hit record.
I've also tried working with suitescripts by taking help from chatgpt... It displays wrong informations and suggestions, no matter how many times I try to break up and explain the question to it.
Agreed, I think GPT 3.5 version or higher is better for Suitescript but without prior knowledge it’s better to use Chatgpt to debug errors than to write code from scratch.
This is super helpful. Thank you!
The video i was looking for... quick question if my report has filter range dates how i can get delete those filter so BI upates with the latest info?
Use the relative date filter on the NetSuite report (ex: this year) so you can get the latest data upon refresh in Power BI
r u giving training for netsuite admin
Planning on doing paid training sessions - group and individual in the near future. You can sign up here - forms.gle/kBq85tcdJKVTvyrm7
Hello Sai. Thank you for the video. I have a quick question please. Once the query is run and the results are shown, is there a way to export the results into an Excel sheet and have it downloaded locally?
Yes, there’s an option on the right in the Suite QL query tool page where once the results are shown you can export it to a CSV/excel format
How much it cost SuiteAnalytics for month?
It starts from $500 I believe, but varies based on your license with NetSuite