Categories
Marketing Analytics and Reporting

Grouping Data – Pandas | Python ~ Episode 8 [Video]

Hey Coders! Ready to take your pandas analysis skills to the next level? Grouping your data by a common value and then performing some kind of aggregation function on it is a common and powerful task. Almost exactly like the GROUP BY keywords in SQL, pandas groupby() method allows you to create a group object, which can be used to find things like average math score for each race/ethnicity or gender. In fact, you can even group by multiple categories at once, and pandas makes it so easy to do. In this video, we’ll learn how!Check out the source code on GitHub:https://github.com/davidtheweiss/pandas-tutorial❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! https://www.patreon.com/DavidWeissProgramming🧑‍💻 Pandas Documentation: https://pandas.pydata.org/docs/reference/index.html———————————————————————————————-🕒 Timestamps0:00 Intro0:51 Importing pandas and displaying our data2:10 Creating a group object with groupby()2:42 Simple properties and methods of the group object5:11 Aggregation functions on your group object7:55 Grouping by multiple columns———————————————————————————————-Other playlists:————————————-Python————————————-Pandas:https://www.youtube.com/playlist?list=PL42xwJRIG3xAfE7AJkO7sCIyMGVVgZu-i————————————-Flutter————————————-Basic Widgets:https://www.youtube.com/playlist?list=PL42xwJRIG3xDX1V8-sNHXk39qeSVy7W8JDart:https://www.youtube.com/playlist?list=PL42xwJRIG3xDhQj15rrsAxv_TNdv9PaqaFlutter Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xD4v1Xb8prXG89zZgSWND-p————————————-Google Cloud————————————-Compute Engine:https://www.youtube.com/playlist?list=PL42xwJRIG3xAjjZ3tY_zrZYEhStnIofzBApp Engine:https://www.youtube.com/playlist?list=PL42xwJRIG3xCtmOrJAQFR5sIJFKIJ9MEnGoogle Cloud Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xBGAOjrm9iZ3N5_eP_KRc34————————————-Apps Script————————————-Cache Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xCCAeJUuxtmr47NYC8sRQ2dJDBC Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xCFMS4-IyAQg-9bJGx7-226Data Studio Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBM88UgT79HKxO_u0ze3BZLMaps Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xAXgY2FksYt-kbKuXNmSUMAUtilities Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBnsGHi6fetv17uQ35NXm0SProperties Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDBj4s5WwO7sYUyA3H06BjsURL Fetch Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDormBAHLcxorCYpHlHa_IEDrive Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDbvnvgWOizjX6j1jYBn0zkForms Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBoKUA3zPkICMTAa_vu0QElLock Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDBPhvVrQdRi2Hdy9kMeb90HTML Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xAafvhn9eCubEdas3I2TrNhDocument Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBFGeUZCMubWlwrhUXDdaTASlides Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBknGu3JNdJqHCiPpaVxAuYCalendar Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xAqrGnc_o2NL4RH4jdyiHspScript Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDPE35v7e83rH7Uu4g_MfmCGmail Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xA5pkm04CY_WVZ9lE1Ju_JHSpreadsheet Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBZFP5wYh-OFb-CQmjz-Rn-Apps Script Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xCm6O85pd91tQxgxGcq82m4———————————————————————————————-

Categories
Marketing Analytics and Reporting

EP 8 FULL GUIDE to Report Sharing in Google Data Studio – PASSWORD PROTECTED FILE, AUTOMATED EMAIL [Video]

⭐️ Help me improve – (Survey) https://forms.gle/RCkUF8AroU8sL8Ke8Wonder how to share Google Data Studio report to your clients & stakeholders? In this tutorial, we’ll share how you could share and download the report using a few real-world scenarios.You’ll also learn the basic access control in Data Studio that helps you share the access securely within and outside of your organization.T I M E S T A M P00:00 What’s Covered ?00:14 Method #1 : How to Share Dashboard via Link ?01:57 Method #2 : How to Make GDS Dashboard Public04:42 Method #3 : Export Static Report as PDF File + Password Protected07:23 Method #4 : Automate Report DeliveryF R E E B I E SI used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There’s no extra cost to you.]𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A👉 Subscribe to my channel @ https://www.youtube.com/channel/UCDEJmST2OTrVDFbKCUdqbxw?sub_confirmation=1 #GoogleDataStudio #Danalyser #DataStudioNewUpdates————————————————————————————————————————–A B O U T M E👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.—————————————————————————————————————————💌 W A T C H N E X T⚈ Show current date in dashboard 👉 https://youtu.be/EVQ_nW19eq0⚈ Export Data from Data Studio👉 https://youtu.be/e7zRFvKHs08⚈ Automation in Data Studio (Email Delivery)👉 https://youtu.be/A_RRbgt3qjQ

Categories
Marketing Analytics and Reporting

Accessing Rows, Columns & Cells – Pandas | Python ~ Episode 2 [Video]

Hey Coders! Printing out your pandas data to a jupyter notebook is nice and fine, but how do you actually access that data? If you wanted to perform an operation on an individual column, row, cell, or group of cells, how could you grab that data out of your source dataframe? In pandas, there are a variety of ways to accomplish these tasks, and in this video, we’ll examine the methods to do it. Bracket notation is always nice, but just wait and see what iloc and loc can do!Check out the source code on GitHub:https://github.com/davidtheweiss/pandas-tutorial❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! https://www.patreon.com/DavidWeissProgramming🧑‍💻 Pandas Documentation: https://pandas.pydata.org/docs/reference/index.html———————————————————————————————-🕒 Timestamps0:00 Intro0:57 Importing pandas and glancing at our data2:30 Bracket and dot notation for accessing a single column5:17 Accessing multiple columns6:30 iloc gets data based on index position7:44 loc gets data based on index name9:25 Accessing data given a row(s) & column(s)14:00 Faster data retrieval for a single cell of data———————————————————————————————-Other playlists:————————————-Python————————————-Pandas:https://www.youtube.com/playlist?list=PL42xwJRIG3xAfE7AJkO7sCIyMGVVgZu-i————————————-Flutter————————————-Basic Widgets:https://www.youtube.com/playlist?list=PL42xwJRIG3xDX1V8-sNHXk39qeSVy7W8JDart:https://www.youtube.com/playlist?list=PL42xwJRIG3xDhQj15rrsAxv_TNdv9PaqaFlutter Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xD4v1Xb8prXG89zZgSWND-p————————————-Google Cloud————————————-Compute Engine:https://www.youtube.com/playlist?list=PL42xwJRIG3xAjjZ3tY_zrZYEhStnIofzBApp Engine:https://www.youtube.com/playlist?list=PL42xwJRIG3xCtmOrJAQFR5sIJFKIJ9MEnGoogle Cloud Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xBGAOjrm9iZ3N5_eP_KRc34————————————-Apps Script————————————-Cache Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xCCAeJUuxtmr47NYC8sRQ2dJDBC Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xCFMS4-IyAQg-9bJGx7-226Data Studio Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBM88UgT79HKxO_u0ze3BZLMaps Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xAXgY2FksYt-kbKuXNmSUMAUtilities Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBnsGHi6fetv17uQ35NXm0SProperties Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDBj4s5WwO7sYUyA3H06BjsURL Fetch Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDormBAHLcxorCYpHlHa_IEDrive Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDbvnvgWOizjX6j1jYBn0zkForms Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBoKUA3zPkICMTAa_vu0QElLock Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDBPhvVrQdRi2Hdy9kMeb90HTML Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xAafvhn9eCubEdas3I2TrNhDocument Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBFGeUZCMubWlwrhUXDdaTASlides Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBknGu3JNdJqHCiPpaVxAuYCalendar Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xAqrGnc_o2NL4RH4jdyiHspScript Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xDPE35v7e83rH7Uu4g_MfmCGmail Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xA5pkm04CY_WVZ9lE1Ju_JHSpreadsheet Service:https://www.youtube.com/playlist?list=PL42xwJRIG3xBZFP5wYh-OFb-CQmjz-Rn-Apps Script Orientation:https://www.youtube.com/playlist?list=PL42xwJRIG3xCm6O85pd91tQxgxGcq82m4———————————————————————————————-

Categories
Marketing Analytics and Reporting

Note Application using Sqlite database part 1 (android studio) | android tutorials | | 2022 | [Video]

in this video we are going to learn how to create note application using sqlite database;more videos to watch;1) SQLite database insertion: https://www.youtube.com/watch?v=kKnZD6-Mnbc2) add lottie animation: https://www.youtube.com/watch?v=-61bIx9zCb0&t=243s3) add recycler view: https://www.youtube.com/watch?v=5YvnZhJLlvc&t=36s4) add custom toolbar: https://www.youtube.com/watch?v=8ap-HWBbc3U&t=287s5) add navigation drawer in empty activity: https://www.youtube.com/watch?v=718G9myrOW4&t=3s6) add google style input text: https://www.youtube.com/watch?v=CI6WRPApUPo&t=132sPlease subscribe to our channel.

Categories
Marketing Analytics and Reporting

Installing 3rd Party Apps on the RC Pro [Video]

This tutorial covers how to Install 3rd Party Apps on DJI’s new Remote Controller – The RC Pro. This controller comes in the Mavic 3 Cine package and is also available for separate purchase. It is currently only compatible with the Mavic 3, Mavic 3 Cine and the Air 2S. The methods used here should also work on the original DJI Smart Controller.Covered in this video:00:00 Introduction00:40 Important Disclaimer00:59 Installing Apps Using Google Play Store 05:20 Method TwoLink to Stylus used by MiddleLoop for the RC Pro*: https://amzn.to/36fWBchLink to Google Play Site: https://play.google.com/google-playGoogle Play and the Google Play logo are trademarks of Google LLC.Link to the APK Downloader used in this video: https://apps.evozi.com/apk-downloader/[ Please be Advised ] This site may have Daily or Hourly download limits. Also, there might be some ads that are for adult eyes only. [ Disclaimer ]Installing 3rd Party Apps introduces risk of virus and other security threats to your device. Middleloop Video and Photography, LLC and its employees are in no way responsible for anything may occur should you choose to install a 3rd party app. We recommend that you only install apps from a trusted source and we in no way endorse any of the apps or sites mentioned in this video.Your RC Pro and Personal data are more vulnerable to attack by unknown apps. By following these instructions and installing apps, you agree that you are responsible for any damage to your device(s) or loss of data that may result from its use. This video was produced by MiddleLoop Video and Photography, LLC. MiddleLoop got started producing Training and other sorts of videos for corporations. We specialize in step-by-step instructional videos. For a complete look at all the services MiddleLoop offers, check out the website (www.middleloop.com)If you find this video helpful, please take a moment to subscribe. It helps a lot. Thank you. Subscribe using this link: https://www.youtube.com/channel/UCpbGXlWN7EWsrug-ual3X_A?sub_confirmation=1Music:Yah Yah by josh pan is licensed under a YouTube Audio Library License.Products used in creating this video* :- RC Pro: Remote Controller for M3 https://amzn.to/3qe2nS4- Audio Interface: Zoom L-8 https://amzn.to/39JhQS4- Microphone: Electro-Voice RE20 https://amzn.to/3kNgVql- Microphone Shock Mount for EV RE20 https://amzn.to/2WElYjs- Adobe Creative Cloud Suite https://amzn.to/3m52Zay- Fiber Tip Touch Screen Stylus https://amzn.to/36fWBch* PRIVACY POLICY and FULL DISCLOSURE:MiddleLoop is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com. If you purchase something from my affiliate links I will get a small commission with no extra cost to you. This makes it possible for me to make more videos. I periodically update my links to the current version of the product so they may not be the exact product used to produce this video.Thank you so much for participating and helping me out. I DO NOT collect, store, use, or share any data from or about you during your participation with affiliate links.Because people have asked, here’s a complete listing of products used by Middleloop in the studio and in the field, go here: https://www.middleloop.com/ProductLinks.aspEnjoy and Happy Flying!

Categories
PPC Advertising

Google Sheets Tutorial For Beginners – 2022 Edition [Video]

Learn how to use Google Sheets in this updated 2022 Google Sheets tutorial for beginners. In this video, you will learn how to create your first spreadsheet, sort values, through to filtering, formulas, and adding visualizations. Download the example file at https://lovesdata.co/ufG7WzJUMP TO A TOPIC IN THIS VIDEO:○ 0:00 Introduction○ 1:34 How to create a new spreadsheet○ 2:48 How to import data into a spreadsheet○ 4:38 Understanding columns and rows○ 5:30 How to freeze the header row○ 5:54 Text wrapping in spreadsheet cells○ 6:31 Formatting values and text in cells○ 8:40 Sorting values in a spreadsheet○ 8:44 How to use conditional formatting○ 9:45 Calculating new values in Google Sheets○ 13:46 Inserting extra columns in a spreadsheet○ 14:25 Using functions in Google Sheets○ 16:49 How to use filters in Google Sheets○ 17:41 Validating data in Google Sheets○ 18:28 Visualizing data in your spreadsheet○ 20:12 Sharing and collaborating○ 20:35 ConclusionWHAT TO WATCH NEXT:○ Creating charts and graphs in Google Sheets – https://youtu.be/IFX9e9SqGlw○ Google Sheets tips – https://youtu.be/Pn8ZIM0My9I○ Google Data Studio tutorial – https://youtu.be/KouK1INq7GgMy email updates: https://www.lovesdata.com/email-newsletterMy courses: https://www.lovesdata.com/coursesMy book: https://amzn.to/2FTQ8SXSAY HELLO!○ My blog – https://www.lovesdata.com/blog-welcome○ Contact me – https://www.lovesdata.com/contact-usTOOLS I USE AND RECOMMEND:○ Email platform – https://lovesdata.co/zrLd7○ Course platform – https://lovesdata.co/2Zzfq○ Data connector – https://lovesdata.co/oOWkI#googlesheetstutorial #googlesheetsSubscribe for more videos: http://www.youtube.com/subscription_center?add_user=lovesdata

Categories
Marketing Analytics and Reporting

Active Data Studio Crack v17.1.0 + with Registration Key [Latest Version] 2022 [Video]

Download link : https://cutt.ly/POIn78v,active data studio 17,active data studio 17 serial key,active data studio crack,[email protected] boot disk,active partition,active boot disk key,active boot disk registration name and key,active boot disk 15.0 6 keyactive data studio,google data studio,data studio,[email protected] data studio,active data studio 14,[email protected] data studio 2018,bla bla [email protected] data studio,google data studio tutorial,studio,active @ data studio,active data studio 8,active,active data studio full,active data studio 13 key,active data studio crack,active data studio setup,active data studio 16.0.0,[email protected] data studio 2019,active data studio 14 crack,[email protected] data studio guide,The EaseTech, The Ease Tech, theeasetech, Active @ data Studio, recovery software, best recovery, windows data recovery, active data recovery, partition data recovery, complete HDD erase software, complete Disk Wripe, Disk Monitore, active data Burns, Windows Password changer, [email protected] data studio guide, Wripe or Kill Disk, ISO manager, Deleted File Recovery, windows data recovery tools, data recovery, permanent data recovery, shift deleted data recovey,apps and soft, Apps and soft, Active Data Studio 16.0.0, [email protected] Data Studio 16.0.0 Portable, Active Data Studio, Portable 2020, [email protected] Boot Disk, Active Boot Disk V16, Active password Recoery, active file frecovery, Active Data Studio 16.0.0 with Crack, Active Data Studio 16.0 (x64) Portable 2020 | File, Partition, Password Recovery,crack [email protected] data studio, [email protected] Data Studio, How To Crack [email protected] Data Studio, comment cracker [email protected] Data Studio, [email protected] Data studio 2018, [email protected] Data Studio 2019, get [email protected] data studio for free, avoir [email protected] data studio gratuitement, [email protected] data studio la dernière verision, [email protected] data studio last verision, bla bla [email protected] data studio, bla bla bla,apps and soft, Apps and Soft, [email protected] Data Studio overview, How to recover files with, [email protected] File Recovery, Download Active Data Studio 13.0.0.2, Active Data Studio Free Download, [email protected] Data Studio, software tools and utilities, Active Data Studio, Active Data Studio.v13 : Backup, Recovery and Restore all Windows system,

Categories
Marketing Analytics and Reporting

Prepare Your Excel Data For BI Tools | 5 Common Mistakes to Avoid | Data Prep Tutorial [Video]

If you’ve ever tried to load your Excel data into a data analysis tool but got an error message or you’ve found that the data you loaded isn’t working as you thought it would. Then it’s probably down to the way it’s structured or formatted. In this video, I’m going to talk about the 5 most common mistakes to avoid and how to prepare your data for analysis in BI tools.🎓 MY DATA STUDIO ONLINE COURSEhttps://geni.us/vbi-edu🎥 USEFUL VIDEOS7 Steps to Your 1st BI Analyst Job – https://youtu.be/0zN0MM1SJMwLearn Basic SQL in 15 Minutes – https://youtu.be/kbKty5ZVKMYBI For Beginners Playlist – https://www.youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWE⚙️ DATA HUBS FOR DATA STUDIO:Power My Analytics: https://geni.us/YLc9ReSupermetrics: https://geni.us/5SNnData Slayer: https://geni.us/dataslayer🧰 BI TOOLSPower BI – https://powerbi.microsoft.com/Tableau – https://www.tableau.com/Data Studio – https://datastudio.google.com/📊 DATA WEBSITESKaggle – https://www.kaggle.com/Statista – https://www.statista.com/Data World – https://data.world/NYC Open Data – https://opendata.cityofnewyork.us/UN Data – https://data.un.org/🎓 ONLINE LEARNING→ SkillshareGet a 14 day free trial and 30% off your 1st year of Premiumhttps://skillshare.eqcm.net/c/2534277/677296/4650→Udemyhttps://geni.us/udemy_vb→Courserahttps://geni.us/coursera_analytics📕 FREE EBOOKS TO DOWNLOAD7 Top Tips For Better Dashboard Design – https://mailchi.mp/vitaminbi/dashboard-design-top-tipsThe Skills You Need To Succeed In Business Intelligence – https://mailchi.mp/vitaminbi/bi-skillsDisclaimer: Some of the above links are affiliate links where I’ll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏✅ LET’S CONNECT:For business inquiries visit https://learnbi.online/contactSign up for my mailing list to be the first to hear about new videos and special offershttps://geni.us/PSgRsF#exceldata #dataanalysis #datapreparation

Categories
Marketing Analytics and Reporting

Learn Basic SQL in 15 Minutes (PART 3) | SQL Functions Tutorial [Video]

In this third and final part of the Learn Basic SQL in 15 minutes series, we’re going to be learning how to use different SQL functions to both clean data and create new fields from existing data.THANK YOU TO OUR SPONSORLearnSQL.com – https://geni.us/learnsqlJOIN THE LEARNBI.ONLINE FACEBOOK GROUPhttps://www.facebook.com/groups/816317545978660WATCH PARTS 1 & 2 HERE:Part 1 – https://youtu.be/kbKty5ZVKMYPart 2 – https://youtu.be/gm6tNK_iOHsTIMESTAMPS00:00 Intro01:22 Tutorial start02:28 TRIM, LTRIM & RTRIM functions04:08 LEFT & RIGHT functions05:15 LPAD & RPAD functions06:30 SUBSTRING function07:22 LENGTH function08:58 LOCATE function09:37 Separating first & last names12:08 UPPER & LOWER functions12:34 CONCAT function13:20 Conditional Expressions13:50 CASE statements16:11 Outro🎥 OTHER USEFUL VIDEOS7 Steps to Your 1st BI Analyst Job – https://youtu.be/0zN0MM1SJMwBI For Beginners Playlist – https://www.youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWENAVICAThttps://navicat.com/GET THE CHEAT SHEEThttps://mailchi.mp/learnbi/functionscheat⚙️ DATA HUBS:Power My Analytics: https://geni.us/YLc9ReSupermetrics: https://geni.us/5SNnData Slayer: https://geni.us/dataslayer🧰 BI TOOLSPower BI – https://powerbi.microsoft.com/Tableau – https://www.tableau.com/Data Studio – https://datastudio.google.com/📊 DATA WEBSITESKaggle – https://www.kaggle.com/Statista – https://www.statista.com/Data World – https://data.world/NYC Open Data – https://opendata.cityofnewyork.us/UN Data – https://data.un.org/🎓 ONLINE LEARNING→ Ultimate Guide to Google Data Studiohttps://geni.us/vbi-edu→ SkillshareGet a 14 day free trial and 30% off your 1st year of Premiumhttps://skillshare.eqcm.net/c/2534277/677296/4650→Udemyhttps://geni.us/udemy_vb→Courserahttps://geni.us/coursera_analytics📕 FREE EBOOKS TO DOWNLOAD7 Top Tips For Better Dashboard Design – https://mailchi.mp/vitaminbi/dashboard-design-top-tipsThe Skills You Need To Succeed In Business Intelligence – https://mailchi.mp/vitaminbi/bi-skillsDisclaimer: Some of the above links are affiliate links where I’ll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏✅ LET’S CONNECT:For business inquiries visit https://learnbi.online/contactSign up for my mailing list to be the first to hear about new videos and special offershttps://geni.us/PSgRsF#sqltutorial #sqlfunctions #learnsql

Categories
Marketing Analytics and Reporting

GDS Course # 2 Connect to Google Sheets with Google Data Studio Data Connector + 🆓 Practice Dataset [Video]

In this video, we’ll learn how to import and connect Google Sheets data to Google Data Studio. This is the very first step if you wish to transform a spreadsheet into an interactive dashboard. In addition, some basic concepts related to data source connection in Data Studio would also be covered! :)✅ Watch the complete tutorial here: https://bit.ly/datastudiocourse2022✅ Free dataset for download: https://bit.ly/danalyser-sample-data✅ How to create report with Template (Youtube Analytics) – https://www.youtube.com/watch?v=ydauaDeXUmo (PS: Course Modules would be released over time.)T I M E S T A M P00:00 Overview00:18 How to Get your Free Data Studio Account ?00:40 🧭 GDS Landing Page Navigation 01:17 Where to Find Free & Professional Templates? 01:54 Let’s Start with Creating an Empty Report02:29 Data Source Connectors04:47 How to Connect to Google Sheets Data | Method # 105:15 How to Connect to Google Sheets Data | Method # 208:16 Best Practice10:05 Metrics vs Dimension (With Example)12:41 Data Refresh FrequencyF R E E B I E SI used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There’s no extra cost to you.]𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A👉 Subscribe to my channel @ https://www.youtube.com/channel/UCDEJmST2OTrVDFbKCUdqbxw?sub_confirmation=1 #GoogleDataStudio #Danalyser ————————————————————————————————————————–A B O U T M E👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.—————————————————————————————————————————💌 W A T C H N E X T⚈ Show current date in dashboard 👉 https://youtu.be/EVQ_nW19eq0⚈ Export Data from Data Studio👉 https://youtu.be/e7zRFvKHs08⚈ Automation in Data Studio (Email Delivery)👉 https://youtu.be/A_RRbgt3qjQ

Categories
Marketing Analytics and Reporting

Google Data Studio (GDS) Free Training 2022 for Beginners – Course Overview [Video]

Helo! This is a free tutorial course for anyone who wants to learn Google Data Studio to build interactive reports. Check this video out if you want to get an idea what topics will be covered before you decide to invest your time :)✅ Watch the complete tutorial here: https://bit.ly/datastudiocourse2022✅ Free dataset for download: https://bit.ly/danalyser-sample-data(PS: Course Modules would be released over time.)F R E E B I E SI used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There’s no extra cost to you.]𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A👉 Subscribe to my channel @ https://www.youtube.com/channel/UCDEJmST2OTrVDFbKCUdqbxw?sub_confirmation=1 #GoogleDataStudio #Danalyser ————————————————————————————————————————–A B O U T M E👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.—————————————————————————————————————————💌 W A T C H N E X T⚈ Show current date in dashboard 👉 https://youtu.be/EVQ_nW19eq0⚈ Export Data from Data Studio👉 https://youtu.be/e7zRFvKHs08⚈ Automation in Data Studio (Email Delivery)👉 https://youtu.be/A_RRbgt3qjQ