Maven Analytics

If you’re looking to use AI to support your work, here’s something critical for you to know: The quality of the output is only as good as the quality of your input. …So, what does that mean? You need to get really, really good at prompt engineering! In this video, Chris Dutton gives tips for quality AI prompt engineering, a valuable skill for any analyst looking to leverage the power of AI to accelerate their workflow. 📽️: https://lnkd.in/eTUFhwmK This is an excerpt from our FREE Data Literacy Foundations course, which is a great asset for anyone who works with data – not just the “data pros”! Have you checked it out yet? #learn #data #analytics #dataliteracy #ai #chatgpt #promptengineering

🌟 UPDATE: Maven Rewards Challenge 🌟 This one is really starting to connect! Check out the awesome work we've seen already from these entrants… Abdelrahman Gamal, Cherry Aye Mya Mya Tun, Romina Stefan, Ferdinand Fojtlin, Chris Thomas, Srishti Puri, Biswarup Santra, Lin Zhu, James McFadden, Ahmed Shoaib, Kendrick M., Manoj Ramesh, Subhasis Das, Luca Poit ...and more! Great job everyone 👏👏 For those who are still waiting to join, you've got plenty of time to dive into this cafe marketing data and add a great project to your portfolio. And if this rich data set alone isn't enough incentive… For more chances to win, we'll be crowning 3 separate winners for each challenge! 🏆 A general "Challenge Winner" (like always) 🏆 A "First-time Entrant" winner 🏆 A "Fan Favorite" winner (based on project likes on Showcase) Challenge closes 9/8. Check out the full details here: 👉 https://bit.ly/3ylbIzD #mavenrewardschallenge #data #analytics #dataviz #portfolio

LAST CHANCE TO SECURE OUR OLD PRICING! Our subscription pricing will be changing TOMORROW to reflect evolving costs and recent enhancements to our product and services. - Individual Monthly: new price is $49 per month (from $39) -> You can secure current monthly pricing here: https://bit.ly/3SuPeTz - Individual Annual: new price is $399 per year (from $349) -> You can secure current annual pricing here: https://bit.ly/3SvFqc3 If you are a Paid Subscriber: We will continue to honor your current subscription price, and the cost of your plan will not change as long as your subscription remains active (no action needed). If you are NOT a Paid Subscriber: You can take advantage of current prices ($39 monthly or $349 annual) through Wednesday, August 13th, 2024, after which the new pricing will take effect. And don't miss our new offer: You can now secure LIFETIME Access to our platform! If you are a lifelong learner, this is the perfect opportunity for you. Lifetime Access means you pay once and never again, and get access to all current and future Maven Pro content for LIFE. Founder Chris Dutton is sharing more about these updates, and why they're happening now, at the Maven Blog. Take a look: https://bit.ly/4dkL7kM

How do you catch the attention of your CEO? Aleksandar Malic knows the secret! Now a Data Analyst in the gaming industry, when Aleksandar was getting started as an analyst he had very little experience with Excel. A little internet sleuthing brought him to one of Chris Dutton’s Excel courses on Udemy, and it ended up being a pivotal moment in his career! “I must say that Maven is the best thing that ever happened to me.” In this video, Aleksandar is sharing: ✅ How he gained the support of his CEO from that first course ✅ What he did next (hint: it starts with a Learning Path!) ✅ How he displays his certifications and skills growth ✅ Why he’s had companies scouting him on LinkedIn Check it out! 👉 https://lnkd.in/dR-7dCwQ #learn #data #analytics #Excel #upskill

LIVE SHOW with Albert Bellamy: How to Build a Winning Data Analyst Resume! 📅 Wednesday, August 21, 2024 @ 12 PM ET You'll learn:    👉 Why resume writing is such an important skill for data pros at all levels 👉 How employers review resumes and how you can stand out 👉 Albert’s top resume tips and pitfalls to avoid You can join a new live show every week to hear amazing perspectives and actionable advice from some of your favorite data experts. Register here: https://bit.ly/3WEimds #learn #data #careers #live #mavensofdata #free #webinar

Learning Excel? There may be times when you want to “hide” the text in a cell. Don’t make the font white! Do this instead... There is a way you can actually hide the text using custom number formatting. Remember, custom formats can contain up to 4 conditions, separated by semicolons (A;B;C;D) A: Format for positive numbers B: Format for negative numbers C: Format for zeros D: Format for text But what if the format for all of these is left blank? --> ;;; You get “invisible” values! A custom number format of three consecutive semicolons keeps the underlying value in a cell but prevents it from displaying. PRO TIP: Use this with conditional formatting color scales to create heatmaps! #mavenquicktips #excel #data #analytics #businessintelligence #careers

Learning SQL for data analysis? Make sure you know the Big 6. These simple and intuitive concepts are a great place to start learning. They are fairly easy to pick up, and will unlock so much for your SQL game. https://lnkd.in/etX4eDhn What else would you recommend newbies tackle early in their SQL journey?

You always work with clean, highly formatted data right? (ha!) Here are Aaron's top 5 steps to clean up messy data: 1. Reshape the file or table structure as needed 2. Diagnose the quality of data in each column 3. Replace missing, blank, and omitted values as necessary 4. Set/update column data types 5. Structure dates in a consistent and ingestible way What else would you add? #data #analytics #powerbi #businessintelligence

Learning Excel? Here's a quick tip that will make your life easier... Working with numbers in the millions can be visually overwhelming. Here’s how you turn 1,230,000 into 1.23 M… Excel has an entire syntax dedicated to custom number formatting. Even though there is a wide variety of predefined options, we are going to define our own using the custom syntax. 1. With the numbers you’d like to format selected, press CTRL+1 2. In the “Format Cells” dialog box, go to the “Custom” category 3. In the “Type:” text box, write the following: 0,,.00 "M" 4. Press OK! How does this work? --> The first 0 forces excel to include a digit before the decimals --> Each comma removes 3 “zeros” from the number --> The .00 forces excel to include two decimal numbers --> The space and the “M” add exactly that… a space and an “M” Here are some more examples of the result: 950,000 = 0.95 M 5,500,000 = 5.55 M The best part? Excel still reads them as the full number under the hood, so you can do any kind of calculation on them! #mavenquicktips #excel #formatting #data #analytics #businessintelligence

Looking for a well-rounded data tool to add to your stack? Whether you’re a data professional or just getting started, Excel provides a user-friendly interface for working with data in every phase of the analytics process: data cleaning, prep, analysis, and visualization. And the best part? ANYONE can learn the foundations of Excel in just a matter of minutes – for free! In this demo, we’ll play the role of an entry-level data analyst for a local toy store 🧸 We’ve been given access to a spreadsheet with ~15,000 sales records for 35 different products, and our task is to use that data to understand things like weekday vs. weekend revenue, monthly trending, and top products. Using Excel, we’ll transform the raw data into a user-friendly, interactive dashboard to help our manager better understand revenue patterns across product categories. Along the way, we’ll walk through key steps of the analytics workflow: ✔️ Create calculated columns using formulas & functions ✔️ Perform exploratory data analysis with pivot tables ✔️ Visualize data with charts & graphs ✔️ Build a stunning, interactive dashboard …all in less than 20 minutes! Take a look 👉 https://lnkd.in/egsHJX-B If you’re excited to learn more and build job-ready, expert-level skills, check out our best-selling Excel courses and learning paths at Maven Analytics, including Excel Formulas, Charts, Pivot Tables, Dashboard Design, MO-201 Certification Prep, and more. #learn #excel #dashboard #tutorial