![Analythical by Stephen Tracy](/img/default-banner.jpg)
- Видео 15
- Просмотров 68 811
Analythical by Stephen Tracy
Сингапур
Добавлен 30 май 2017
Analythical is a place where you can learn and develop your skills in the fields of data analytics, research and storytelling. On this channel I cover everything from crash courses in research methods, to hands-on tutorials with tools like Google Analytics and Data Studio. We're all about demystifying data to help people and businesses make smarter, data-driven decisions.
Analythical is owned and operated by Stephen Tracy.
You can visit the Analythical blog by visiting:
www.analythical.com
Analythical is owned and operated by Stephen Tracy.
You can visit the Analythical blog by visiting:
www.analythical.com
Automate Hundreds of PowerPoint Slides With Charts in Seconds
In this tutorial, I'll show you how to use Python and ChatGPT to automatically create hundreds of slides with charts in seconds!
Looking to beef up your data skills? Check out my marketing analytics course ➡️ bit.ly/3Z7D4RO
What to watch next? ruclips.net/video/HqK_uCEa1tk/видео.html
----------------------------------------------------------------------------------
Links to downloadable resources from this tutorial:
----------------------------------------------------------------------------------
✓ Blog post tutorial - bit.ly/3PvvIVh
✓ Github repo for placeholder index checker - github.com/stephotee/pptx-print-index
✓ Github repo for full script - github.com/stephotee/auto-slides-with-charts
✓ St...
Looking to beef up your data skills? Check out my marketing analytics course ➡️ bit.ly/3Z7D4RO
What to watch next? ruclips.net/video/HqK_uCEa1tk/видео.html
----------------------------------------------------------------------------------
Links to downloadable resources from this tutorial:
----------------------------------------------------------------------------------
✓ Blog post tutorial - bit.ly/3PvvIVh
✓ Github repo for placeholder index checker - github.com/stephotee/pptx-print-index
✓ Github repo for full script - github.com/stephotee/auto-slides-with-charts
✓ St...
Просмотров: 2 069
Видео
How To Code a Web App With ChatGPT (Tutorial For Beginners!)
Просмотров 1,2 тыс.5 месяцев назад
Learn how to build apps with ChatGPT in less than 30 minutes! No coding required. Looking to beef up your data skills? Check out my marketing analytics course ➡️ bit.ly/3Z7D4RO Note that this tutorial does require GPT-4 on a paid plan with ChatGPT. What to watch next? ruclips.net/video/HqK_uCEa1tk/видео.html Check out my online courses to start or grow your career in data: ⚡️ Marketing Analytic...
6 Ways Data Analysts Can Use ChatGPT
Просмотров 13 тыс.5 месяцев назад
Interested in using ChatGPT for data analysis? In this video I share 6 ways that data analysts (or aspiring DA's) can use ChatGPT to work smarter and more efficiency. You can copy/paste the prompts covered in this video from my blog post - analythical.com/blog/6-chatgpt-prompts-for-data-analysis? 0:00 - Introduction 0:30 - Using AI for data analysis 2:03 - Creating mock datasets 5:03 - Learning...
How To Change Chart Granularity in Google Analytics 4
Просмотров 1,2 тыс.6 месяцев назад
Struggling to adjust the time granularity of your charts in Google Analytics 4 (GA4) from daily to weekly or monthly? You're not alone! While this was a breeze in Universal Analytics (UA), it's a bit trickier in GA4. Don't worry, though - this video is here to guide you. I'll demonstrate how to locate and use the time-series chart toggle in GA4 using the data Explorer, giving you more control o...
What HBO's Chernobyl Can Teach You About Public Speaking
Просмотров 2,7 тыс.8 месяцев назад
The season finale of HBO’s hit miniseries features a master class in public speaking and storytelling. In this video, you'll learn what every public speaker and storyteller can learn from Jared Harris’s depiction of Valery Legasov in the final episode of the series. 0:00 - Introduction 1:49 - Why Chernobyl? 2:48 - 4 lessons on public speaking 3:13 - Demonstrating expertise 5:06 - Show your audi...
How to Animate Scatter Plot Charts in PowerPoint
Просмотров 2,5 тыс.8 месяцев назад
Looking to elevate your PowerPoint presentations with animated charts? In this step-by-step guide, I'll walk you through a technique for animating scatter plot charts for your live presentations. 0:00 - Introduction 2:41 - Dataset source 3:37 - Reviewing the dataset structure 5:18 - Prepare the data in Excel 5:54 - Create charts in Excel 6:31 - Set chart min and max ranges 8:14 - Paste charts i...
How to Create Custom Reports in Google Analytics 4 (GA4)
Просмотров 9 тыс.10 месяцев назад
It's no secret that Google Analytics 4 (GA4) is not liked by many. The transition from Universal Analytics (UA) has been rocky, as GA4 not only introduced a brand new measurement model but an entirely new interface. But it doesn't have to be so hard, and I'm here to help! In this video, I'll show you everything you need to know about how to customize the GA4 interface and create custom dashboar...
How To Create A Customer Journey Map
Просмотров 4,8 тыс.Год назад
A customer journey map is a visual representation of the stages your customers will go through as they interact with your brand, from awareness to conversion. In this video tutorial, I will walk you through the steps to create a customer journey using my own methodology, known as a Marketing Activation Plan, or MAP. This template is available for you to clone on Miro.com's creator community, th...
How To Choose Better Marketing Metrics
Просмотров 314Год назад
Selecting meaningful metrics for your marketing campaign can be a challenge. From user sessions in Google Analytics to post impressions and reach on Facebook, it can all get a little overwhelming. In this video, I share a marketing measurement framework I've developed over the course of my 10 years of experience working in the field of marketing and data analytics. So if you need help finding a...
How to use ChatGPT for Market Research
Просмотров 22 тыс.Год назад
In this video I demonstrate how you can leverage the power of ChatGPT to streamline the process of designing and executing an online market research project (e.g. surveys) 0:00 - Introduction 1:10 - Getting started 1:36 - Designing a survey 4:43 - Creating brand lists 7:05 - Creating attributes lists 9:33 - Open end data analysis Want more great content about data analytics and data storytellin...
Animating Charts in PowerPoint for Better Data Storytelling
Просмотров 6 тыс.Год назад
Looking to improve your data storytelling skills? Look no further! In this video I'll walk you through several different techniques for animating charts in PowerPoint, which can be especially useful when you have to give live presentations that heavily feature data. 0:00 - Introduction 1:27 - Chart 1: Multi-series bar chart 6:20 - Using transitions to reveal data 8:25 - Chart 2: Stacked bar cha...
Making Sense of Facebook Business Page Analytics
Просмотров 2362 года назад
Measuring the impact of the content you publish on a Facebook business page can get confusing. From Facebook Page Insights to the newer Business Suite reports, you will find data spread out across a number of different tools and sources within Facebook, making it confusing to know where to focus. In the video I break down the various sources where you can pull data, and share some of the metric...
How to Setup Both Universal Analytics & GA4 Properties
Просмотров 3,4 тыс.2 года назад
There's a lot to love about Google Analytics 4. These new types of web/app properties from Google Analytics are now the default, and although they are incredibly powerful and much more scalable than the traditional Universal Analytics tag, I find that they can be harder to get started with for more novice to casual Google Analytics users. So in this video, I'll show you how to set up both a Uni...
5 Google Analytics Tips for Beginners
Просмотров 2354 года назад
When you're starting out in Google Analytics it can be a hard to know where to start. In this video, I share 5 useful tips for beginners when using Google Analytics. For more posts about data analytics, research and data visualization, visit my blog: analythical.com/
Survey Questionnaire Design for Beginners
Просмотров 6654 года назад
Designing a questionnaire for online research is as much an art as it is a science. In this video tutorial, we'll cover the basics of survey design to help you avoid common mistakes that can muddy your data. For more posts about data analytics, research and data visualization, visit my blog: analythical.com/ More tutorials on survey design: Lessons in Survey Design: Using Rating Scales Effectiv...
LOVE this so much! This is exactly what I was looking for. Thank you!
You’re very welcome!
Thank you for an excellent tutorial. Learned more f rom you than a dozen Googles academy videos
You’re welcome, and thanks for the kind words
My labels move but my dots just fade then reappear inthe new location - any ideas??
I believe it's not possible to save a report with a specific searched item, is it? Example Use case: I have a report of the events in my app. I want to filter out every event that starts with "practice_". If I save the report, everything is saved, except the search filter. Using the filter option doesn't show the option to filter out by event name
I am wondering if this can be done with a stacked bar chart. I use it it a lot for work but my coding skills are somewhat limited.
Absolutely fantastic thanks so much
You are very welcome
Hi Stephen! I used a World Bank data (GDP simplified to 15 countries and clean) to repeat your Summarize steps, and absolutely nothing worked! It's the first time in so long that I've seen the chat rave. He simply ignored the data and gave me a summary that had nothing to do with my selected countries. I tried in several ways, restarting the conversation from scratch with different prompts, indicating in detail what the data was about and it remained lost...
thank you
Welcome!
Great learning resource! Keep up the good work!
Thank you!
Great content! Keep up the good work!!! Thanks alot!
Thanks for watching!
Dope! Thank you so much for sharing the huge experience and knowledge for us. 🙏❤ We are waiting another great videos from you ✌
Thanks! More content will be coming soon!
Hi Stephen! Thx so much! I learned a lot 😊 I was just curious further about feeding wireframes. I can build out interfaces with html/css and wondering if instead of uploading a wireframe image, could I just upload a zip file containing the website files and ChatGPT could somehow figure out where to insert the code needed with the design. Thanks!
Google runied GA with version 4
I get the sentiment/frustration. The transition to GA4 from UA has been rocky and the Google product team definitely sacrificed a lot of ease-of-use for advanced measurement features that only power users need. It's unfortunate, but at the same time, the learning curve to make sense of and get value from GA4 is still probably lower than moving to a paid alternative.
This was really helpful! Thanks!
Glad it was helpful!
Watched a 10 minute video and still no answer for how to show monthly granularity! Disappointing from Google ☹
Unfortunately Google hasn't released support for monthly charts yet (no idea why), and you can only apply hourly, daily or weekly granularity to charts in data explorations. But seeing as the "monthly" option is available (but ghosted), I think it will be available at a later date
Great video! Thank you. Is there anyway to customize the overview cards (not overview reports)? Say eg. you want to add (or delete) another metric next to "New users" at the overview card shown at 2:45. Is that possible?
Been watching Googles academy videos to learn GA4 and learned (pretty much) nothing about how to use it. THIS taught me! THANK YOU! The only thing I missed is if the changes I make affect only my view in GA4, or every user in this GA account.
Thanks, and my pleasure! And yes, any custom reports you create, or any changes you make to existing reports will be visible to all users of your GA property.
A big THANKS, at last I see it.
You’re welcome!
Stephen, thank you for the video! I’ve just been promoted to middle business analyst and given a task to develop metrics for future marketing campaign, and this is very useful!
Glad it was helpful!
great presentation
Thank you!
Thank you for the informative video. So is there a way to edit the overview summary cards (The one with time series data with multiple metrics on the top, at the top of overview pages). Or create similar summary cards for my custom overview report?
Thanks, and my pleasure. Regarding your question, I’m not quite sure if you’re referring to editing the "overview report" cards or the charts found at the top of the "detail reports", so I’ll cover both here. But the short answer is yes, there is some customisation that can be done (but it’s limited). 1) Editing charts in detail reports - You can customize the charts that appear at the top of a “detail report” via the right side menu (that appears when you're editing a report). So after you create (or edit) a detail report, look to the right side menu and scroll down to “CHARTS”. From here, you can change the chart type (i.e. line, bar or scatter) and you can choose whether to display 1, 2 or no charts. That’s basically it, it’s pretty limited. However, one question I get asked a lot is how to display a line chart that only shows a single line / data-series. By default, line charts will display a line / data-series for each attribute of the dimension selected (e.g. one line for each page on your site, etc) which can be frustrating. There’s a hacky way to solve this which is to use a dimension with only a single attribute. For example, try editing the report, click on Dimensions > add dimension and search for the dimension called “Year”. If your date range is within a single calendar year then the chart will only display a single line. Another dimension you can consider using is “Stream name” as this will only have a single attribute unless you’ve created multiple data streams under your property. 2) Creating custom cards for overview reports - Another option is to create custom cards, which are displayed on the “overview reports”. However, these are first created via the detail reports. To do this, got to Library > Create detail report, then add the metrics and dimensions you want. Once this is done, scroll to the bottom of the right side menu where it says “Summary cards” and click “Create new card”. From here you can create custom cards which have more visualisation options than the charts on the detail report. Once you create a card, you need to make sure that you add the detail report to a published report collection. Once that’s done, go and create an overview report, and you should be able to add your custom cards to it. I wrote a step by step article about this on my website as well, which you can view here: analythical.com/blog/custom-reports-in-google-analytics-ga4 I hope this helps, but let me know if you have any more questions.
Stephen you are legend!! I loved your analytics course on Udemy!! you explain everything in details with examples and in a systemic way where we can see the full picture! I really appreciate the effort and time you put into this! what made me happy the most is that am learning from someone who have been in the most reputed agencies globally 😍 I saw that some people left reviews on your course saying that they want you to be concise, please don’t listen to them. keep it up 💪🏻🎉 your youtube channel is also a blessing because we can stay updated on your latests findings 🙌🏻
Thanks so much for the kind words and encouragement, I appreciate it!
This video was great! Where would I post my surveys?
Thanks, glad you enjoyed it. On your question, I assume you mean where to post it to get survey responses, and not what tool to use to build your survey? If so, then there are a few ways to get responses, but the first and most important thing is to start by defining your target audience, as this may impact where you source responses. Once you've defined your target audience, you can consider the following places to get respondents: 1) Panel providers - This will require you to have a material budget (usually at least $2K or more, but this is usually the easiest/fastes way to get survey responses at scale. Some of the global firms that provide online samples include Pollfish, Dynata, and Toluna (but there are many more) 2) CRM / customer database - If you work at a company that has a customer database / email contact list, you can consider blasting the survey to your customers. You may need to consider offering an incentive to encourage survey completes. 3) Social media - You can try publishing your survey on social networks like Facebook and X/Twitter. Depending on the size of your audience, you can also put a small budget aside to boost your post as a way to get more survey responses. 4) Online forums / communities - You may be able to find targeted responses via online forums, Reddit or Discord communities. You may need to consider offering an incentive to encourage users to complete the survey (e.g. a small reward for everyone, or a chance to win a bigger reward, etc). Also, if you post on reddit forums check the community guidelines or with the admins first to make sure you're allowed to do so.
@stephentracy Thank you for you response! This will be extremely useful in my research
Excellent
Just erase ChatGPT, all Ai are useless programs. If they are integrated in to everything then it’s bye bye tech.
Do not use chat gpt to run your data analysis. For the love of god, make it write you python code! No spss needed! And you avoid the language model hallucinating datapoints (it absolutely will!)
@krazoe6258 Yes, I use ChatGPT, GitHub Copilot, and Codellama and to write code, where I often leverage Python libraries like pandas, nltk, etc. But you don’t always need to write a python script for every DA/DS use case. In fact, in some cases you might end up spending more time troubleshooting code with ChatGPT than writing your own code or just feeding it data. So there are plenty of cases where you may want to upload data and have GPT-4 interrogate a data file, and then there are cases where you’ll want it to write code. Both can work.
@@stephentracy We might come from different backgrounds here. I've just handed in my doctoral thesis, and for one of the analyses I thought I would try chat gpt. But I of course also did the same analysis in python and got totally different beta coefficients. Most likely, chat gpt hallucinated some data or whatever. But if you don't need the results to always be 100% accurate, by all means, go ahead. I'm not the data analysis police
A respectful blend of comments herein. Kudos to all for civility.
Excellent video!
Thank you!
Great job, very informative
Thank you!
Great tips, thanks for this. Can I ask what custom instruction do you use for market researcher/data analyst?
Thanks. I actually don't use any custom instructions with ChatGPT. However, I use PromptPerfect from time to time, as I find it helps get me better output when it comes to more complex prompts.
Wow great! Just tried, it's free too. Thanks@@stephentracy. Yu may want to create content how to apply PP...
Just upload it, I'll play around it@@stephentracy . You may want to create a content on how to apply it :)
Thanks so much for this. Can you add custom explorations into a report? At the moment I have loads and they all just sit in "Explore". I'd like to add them to the cards or reports or something.
Unfortunately no, at this time there's no way to bring your explorations into the standard reports. I also think it's unlikely Google will add this fucntionality becuase these tools leverage different types of data (i.e. Explore leverages user/event level data, while Reports leverage aggregated data). That said, I'm hopeful that the GA product team will roll out better organization and foldering features for explorations in the future, and perhaps some dashboarding functionality as well.
Thanks a million. Amazing tips Stephen
My pleasure!
Unbelievable. I've been looking for a way to change granularity for weeks. Thanks a lot for this tip, even if this incomplete. I still don't understand why GA4 lacks so much features from UA, but it's a massive disappointment...
You’re welcome. And yes, a lot of people aren’t happy with GA4 in its current state. There are a lot of cool things you can do with its new measurement model, but the product team at Google really dropped the ball on ease of use and basic functionality like chart granularity. I have another video on my channel about customising reports that may also be of interest to you.
Great video, thanks. How do you display data weekly?
Thanks, glad you enjoyed the video On weekly charts, unfortunately you can’t change the granularity of charts in the Reports section at this time. But you can do this in the Explore table builder. I have a video and blog post on this coming out soon, but in the meantime here are the steps to follow: 1. Click on Explore from the left side menu 2. Click “Blank” to create a new data exploration 3. Under the “Variables” column, scroll down to “METRICS”. Click the + sign, then on the next screen you can use the search bar at the top to search for a metric (or metrics) that you want to add. Try searching for “sessions”, then check the box to the left of the metric and click Import (in the top right corner). 4. Now look to the “Settings” column. Under “VISUALISATION” click on the Line chart option (it will default to the table view). Once you choose line chart, you should notice some of the options in this column change. 5. Under “GRANULARITY” you can now select the desired chart frequency (i.e. hour, day, week, month). Since you’re interest in weekly data, select “Week” from the drop down list. Again, if you can’t see the “GRANULARITY” option it’s likely because you haven’t selected Line chart under “VISUALISATION” 6. Now scroll toward the bottom of the “Settings” column, and under “VALUES” select “Sessions” (or whatever metric you imported). 7. Now a chart will appear with your weekly data. Note that you can change the granularity any time if you want to aggregate up to monthly, or drill down to daily or hourly. 8. You can also add multiple time series to your chart by adding dimensions to the “BREAKDOWNS” section. I hope this helps. I’ll update this comment again when my video/blog post are ready. But for now, let me know if you have any further questions.
Update: Here's a step by step article for changing chart granularity in GA4 @stefanpeters5043 analythical.com/blog/change-granularity-in-google-analytics-4 Hope this helps
Amazing video dude. Wish more people would see it
Thank you!
Really insightful and clearly explained. Thanks so much.
Thank you for this video! Was incredibly helpful and straight to the point
You’re welcome!
great stufff
Stephen: Truly awesome. Thank you so much.🙂
You’re welcome!
best video on custom reports! Thanks Stephen
Thank you!
Great tips Stephen!
❤❤❤
Good video
ruclips.net/video/v5lAISL_mus/видео.htmlsub_confirmation=1
Thank you for this!!!
Tell me if I have created GA4 first, then there is option to create universal analytics or not.
Yes, you can start with a GA4 property, and create a UA tag at the same time. To do this, when you go to create a new property (using GA4), under the "Property Setup" page click on "Show advanced options", then you can toggle "Create a Universal Analytics property". This will automatically create a single code snippet that includes both the GA4 and UA property ID.
So you can have two separate google analytics script codes? I thought you had to combine them.
I thought the same too.
Hi Haley, my apologies for the slow reply. So it is technically possible to have 2 separate tags, one for UA and GA4. However it's not really necessary to drop in 2 separate code snippets. There are actually many different ways to dual tag your site. If you are starting with a brand new web property, you simply create a GA4 property, then under the "Property Setup" page click on "Show advanced options", then you can toggle "Create a Universal Analytics property". This will automatically create a single code snippet that includes both the GA4 and UA property ID. On the other hand, if you have an existing website with UA tags, there are a number of ways to add in the GA4 tag, from upgrading your UA tag within the GA admin to adding a new config directive. See sample code below for the latter: <Some Property ID A>"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', '<Some Property ID A>'); gtag('config', 'G-XXXXXXXX'); <--------- THIS IS WHERE YOU ADD THE GA4 TAG </script> You can read more about the various methods for dual tagging here - support.google.com/analytics/answer/11091026?hl=en#zippy=%2Cin-this-article
Hey sir, can you provide Indonesian for your course on udemy? I want to take your class. I hope you can help 😇