Maven Analytics

???? IT’S HAPPENING!!! ???? Our Open Campus event is officially LIVE!!! A recap of what you can expect this week… ?? UNLIMITED LEARNING! During Open Campus week, anyone with a free Maven Analytics account can enjoy unlimited access to courses and platform features! ?? LIVE EVENTS! Join seasoned data experts to kick off your learning with 24 live learning sessions covering technical skills, career advice, AI in data, and more! ??EXCLUSIVE AWARDS & PRIZES! Compete to be named a Portfolio Powerhouse, Learning Legend, or Open Campus MVP and win prizes like Maven apparel and lifetime access! LEARN MORE AND REGISTER ?? https://bit.ly/4dwf418 #learn #data #analytics #live #opencampus #free #webinar

Are you trying to break into a data analyst career and learning one of these TOP 5 business intelligence tools? 1. Power BI 2. Tableau 3. Qlik 4. Domo 5. Excel Why? Why are you spending time learning these tools? Hopefully you're answer is something like, "There a lot of information out there, and I'm not quite sure where to start, so I'm trying to better understand what I'm interested in." Well, John has a great article that's all about a data analyst career path. He's got a ton of tips and insights to offer new and budding that are looking to break into a career in analytics like: "Just start learning about data. Learn on the job and outside of work. Learn as much as you can. Build valuable skills. Pay attention to the types of things you like doing and the things you don't like doing." I think this may be one of my favorite parts of the article - pay attention to the types of things you don't like doing. Often times people get hung up on figuring out "the perfect fit" when you can, often times, arrive at that place more easily by figuring out what isn't a good fit. Take a spin through the article, below... FULL ARTICLE: --> https://bit.ly/2RFaPwr #data #analytics #careers #businessintelligence

Learning Excel? The LAMBDA function is a game-changer… In a nutshell, the LAMBDA function lets you create custom formulas that you can use across your workbook (without VBA or macros!!) The syntax is simple: =LAMBA( parameter, [parameter], [...], calculation ) Parameters are inputs (like variables) for your formula The calculation, which must be the last argument, uses those parameters and evaluates them inside a formula that you define. For example: =LAMDA(x,y,x+y) In this case, “x” and “y” are the parameters and “x+y” is the calculation, which adds them together. However, you’ll notice that “x” and “y” don't have any values assigned. There are 2 ways to do this: 1. Explicitly within the formula: =LAMBDA(x,y,x+y)(A1,A2) -- this will sum the values of A1 and A2 2. Using name manager to create a new function Click CTRL+F3 and create a new name, like “XplusY” In the “Refers to” section, paste the function: =LAMDA(x,y,x+y) Press OK and call this function just like any other: =XplusY(A1,A2) -- this will sum the values of A1 and A2 This is an example meant to showcase how LAMBDA works, but the possibilities are endless! Do you have any preferred use cases for LAMBDA? Let us know in the comments! #excel #data #analytics #businessintelligence

Use Excel for data analysis? Wildcards are a great tool for working with text data. Here’s a new use case I discovered while helping out a friend… He had a product lookup table with alphanumerical SKUs (i.e. small_shirt-123), and wanted to see how many times each SKU appeared in a sales table. Easy… COUNTIF( sales_range, sku ), right? The problem was that the SKUs in the sales table were concatenated with other text strings (i.e. 210819&small_shirt-123.large_shirt-456&store-y), so he wasn’t getting any matches. Here’s where the wildcards come in :) Wildcards are special characters used for “fuzzy” text matching. --> The asterisk (*) represents zero or more characters --> The question mark (?) represents a single character For example: “*en*” will return “enrique”, “bend”, and “cement”, but “?en?” will only return “bend”. Therefore, wrapping a text string in asterisks (*) asks if that text string is contained within another, which gave us our solution: =COUNTIF( sales_range, “*” & sku & “*” ) If that SKU is contained within any cell of the sales_range, then it will count it. Problem solved! Have you encountered a similar scenario? #mavenquicktips #excel #data #analytics #businessintelligence #careers

Evan Scherr is a Data Analyst at NASA. He's sharing his journey from school teacher to an analytics career, and providing some great advice for folks looking to transition. He also talks about the pros and cons of joining a Master's program, which is really valuable to hear for folks who are considering this path. If you want to hear more about Evan's career pivot, you can see a longer form video here... EVAN SCHERR: FROM EDUCATOR TO ANALYST https://lnkd.in/e5NVG-Bb

Ready to take your Excel game to the next level? Learn to combine Excel’s hands-on nature with Python’s machine learning capabilities to get the best of both worlds with Python in Excel! In this demo from Enrique Ruiz, you’ll learn how to fit, interpret, and visualize a K-Means Clustering model in an Excel workbook with less than 15 lines of Python code. Along the way, you’ll use Python in Excel to: ?? View column distributions using pair plots ?? Scale data using normalization ?? Find the right number of clusters using inertia plots ?? Fit a K-Means clustering model ?? Interpret the cluster centers ?? Visualize the clusters to share your insights …all in less than 20 minutes! Check it out: https://lnkd.in/gj6JNZma #Excel #Python #tutorial #data #analytics #machinelearning

?? WIN Exclusive Awards & Prizes @ the Open Campus Awards! ?? Our Open Campus event is kicking off next week, and with it the chance for you to win exclusive awards and prizes! With three titles (and bragging rights!) up for grabs, you’ll get the chance to go head-to-head with your peers in the data space: ??PORTFOLIO POWERHOUSE Create an outstanding Maven portfolio and showcase your skills with everyone at Open Campus. This award goes to the portfolio that receives the most likes during our Open Campus event! ??LEARNING LEGEND Supercharge your skills during Open Campus and become a learning legend! This award goes to the person with the most earned badges during Open Campus. Complete courses, projects, or milestones to become a legend! ??OPEN CAMPUS MVP Join live sessions, engage with the community, showcase your skills, and complete courses and projects for a chance to earn the coveted Open Campus MVP award. The Maven team will select the MVP recipient, who will be rewarded with LIFETIME access to the Maven Analytics platform! Leaderboards will be updated daily on the Maven website, and we’ll be posting updates periodically throughout Open Campus on LinkedIn. This is an awesome opportunity to interact with the data community and make your mark. LEARN MORE ??https://bit.ly/4dyYA8k Hope to see your name on the list! #learn #data #analytics #live #opencampus #free #webinar

???? LAST CALL: Maven Halloween Challenge ???? There's still time to enter! This one closes on Sunday, October 20th. Check out the strong work from these entrants… Bhautik Trambadia, Jithil John, Kevin Webster, MBA, Sajid Shaikh, Minautee Minautee, Santanu Jha, Minh Phan, Ivona Aleksovska, FMVA?, Muhammad Salman, Sonia Margaretha S., John Blandford, Mikias Engye, Andy Behar ...and more! You've got plenty of time to dive into this sweet Halloween candy data and add a great project to your portfolio. And if this 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) To enter: 1?? Create your data viz 2?? Submit your entry to the Halloween Challenge on Maven Showcase 3?? Post your entry on LinkedIn, tagging us and using #mavenhalloweenchallenge (Quick note: Project likes from fake accounts will not count towards the Fan Favorite vote) Check out the full details here: ?? https://bit.ly/3ZFDDpe #mavenhalloweenchallenge #data #analytics #dataviz #portfolio

BIG NEWS ?? We just launched our complete DATA CAREER ROADMAP… …and we’re making it FREE through the end of October! We’ve taken our best career courses and content and turned them into a brand new learning path, designed to give you the EXACT roadmap you need to land your data dream job. With courses from Chris Dutton, John Pauler, Aaron Parry, and Enrique Ruiz, we’ll cover practical tips & proven frameworks to help you: ? Find your perfect path ? Optimize your resume ? Build your personal brand ? Create a world-class portfolio ? Network & apply for jobs ? Ace the analyst interview This path is for anyone looking to launch or accelerate their data career, including: ?? Aspiring analysts, data scientists or engineers trying to break into the field ?? Mid-career professionals transitioning into a data role ?? Anyone looking for a hands-on guide to resume writing, portfolio building, interview prep and more By the end of the journey, you’ll have the exact skills you need to impress recruiters, showcase your strengths, interview with confidence, and launch a successful career. Check it out:?https://bit.ly/3U8kx7B #gethired #data #careers #datajobs? #roadmap #careertips

Looking for a great project to practice your Excel skills and add to your portfolio? Check out our HR Survey Analysis Guided Project! In this intermediate-level guided project, you’ll follow along with Chris and use Excel to visualize survey response data from ~1,500 city employees in Washington state. Here’s your brief: You’ve just been hired as a Human Resources (HR) Associate for the Seattle Department of Public Works. The city recently surveyed ~1,500 public works employees to measure job satisfaction and identify opportunities to keep staff motivated and engaged. You’ve been asked to analyze the survey response data, and prepare a visual summary for the HR leadership team. Along the way, you’ll… 1?? Profile and QA the data 2?? Prepare the data for visualization 3?? Visualize the data and summarize findings Sound interesting? Head to the website to get started! ?? https://bit.ly/484nCeq This project may be a Maven Pro exclusive, but we're offering access for FREE for one week! Don't miss your chance to dive in! #excel #learn #data #analytics #guidedproject #portfolio