Maven Analytics

This badge is earned by successfully completing all of the courses in the Machine Learning Foundations path at Maven Analytics. PATH HOURS: 15.0 PATH DESCRIPTION: This path is for data analysts or BI professionals looking to develop a strong, foundational understanding of popular machine learning tools and techniques. Unlike most data science or ML courses, this is NOT about learning how to code with Python or R. Instead, we'll use familiar, intuitive tools like Microsoft Excel to break down complex models and visualize exactly how they work. We'll start by introducing the machine learning landscape and workflow, and exploring common univariate & multivariate data profiling techniques like frequency tables, histograms, heat maps, scatter plots and more. Next we'll dive into the world of supervised learning, and review key concepts like dependent vs. independent variables, feature engineering, splitting and overfitting. In course #2, we'll introduce powerful classification models, including decision trees, logistic regression, and K-nearest neighbors. From there we'll cover the building blocks of regression modeling and time-series forecasting, and explore powerful techniques for identifying seasonality, predicting nonlinear trends, and measuring the impact of key business decisions using intervention analysis. Last but not least we'll introduce the world of unsupervised learning, and break down powerful unsupervised techniques including cluster analysis, association mining, outlier detection, and dimensionality reduction. COURSES INCLUDED: • Machine Learning Part 1: Data Profiling • Machine Learning Part 2: Classification • Machine Learning Part 3: Regression • Machine Learning Part 4: Unsupervised Learning

This badge is earned by successfully completing all of the courses in the MySQL Specialist path at Maven Analytics. PATH HOURS: 46.0 PATH DESCRIPTION: This path is for database administrators or data analysts looking to build expert-level MySQL skills, and practice applying them to real-world projects and case studies. We'll start with an introduction to database administration, where you'll learn how to design, optimize and manage relational databases with MySQL Workbench. You'll learn how to create and edit tables and schemas, insert and delete records, manage users and permissions, and apply advanced tools like triggers and stored procedures. From there we'll review core techniques for single and multi-table analysis, including SELECT and CASE statements, table unions and joins, and database normalization best practices. You'll apply your skills to a number of advanced case studies, including website traffic analysis, measurement and testing, channel mix, product performance, user analysis, and more. COURSES INCLUDED: • MySQL Database Administration • MySQL Data Analysis • Advanced MySQL Data Analysis • Advanced MySQL Database Administration

This badge is earned by successfully completing all of the courses in the Power BI Specialist path at Maven Analytics. PATH HOURS: 60.5 PATH DESCRIPTION: This path is for users looking for a comprehensive, hands-on guide to self-service business intelligence with Power BI Desktop, Power BI Service & Advanced DAX. You’ll learn how to connect and prep data from external sources, build relational data models and DAX calculations, and design custom, interactive reports and dashboards with Power BI Desktop. From there you’ll publish your work to the cloud with Power BI Service, create new apps and workspaces, and explore advanced tools like gateways, dataflows, row-level security, data-driven alerts, and more. Finally, you'll build expert-level BI skills and solve real-world projects with advanced Data Analysis Expressions (DAX). COURSES INCLUDED: • Microsoft Power BI Desktop • Microsoft Power BI Service • Advanced DAX for Power BI • DA-100 Certification Prep

This badge is earned by successfully completing all of the courses in the Tableau Specialist path at Maven Analytics. PATH HOURS: 59.5 PATH DESCRIPTION: This path is designed to help you build expert-level data prep, analysis and visualization skills using Tableau Desktop and Tableau Prep. Our Intro to Tableau Desktop course is designed to get you up and running with the Tableau Desktop platform. You'll learn how to connect and transform datasets, explore sorting, filtering and grouping tools, define custom calculations and parameters, and tie everything together with dynamic, interactive dashboards. From there we'll introduce Tableau Prep, and explore tools for combining, shaping, and cleaning raw data for analysis. You'll learn how to connect and configure sources, group, split and clean data, create custom LOD and analytic calculations, and use tools to join, aggregate and transform tables. Next we'll dive into advanced, expert-level visualization topics in Tableau Desktop, ranging from data relationships and advanced calculations to predictive analytics and dynamic design techniques. Our Tableau Speed & Performance course is all about building fast, scalable, and user-friendly dashboards by optimizing source data, filters, calculations, and visual design. Finally, our Tableau Certification Prep course will review the exact skills you need to ace the Tableau Desktop Specialist and Certified Associate exams, with project-based demos, exam tips, and full-length practice tests. Whether you’re an aspiring BI professional or just looking to take your Tableau skills to the next level, this path is for you. INCLUDED COURSES: - Intro to Tableau Desktop - Intro to Tableau Prep - Advanced Tableau Desktop - Tableau Speed & Performance - Tableau Desktop Certification Prep

This badge is earned by successfully completing all of the courses in the Excel Specialist path at Maven Analytics. PATH HOURS: 88.0 PATH DESCRIPTION: This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more. We'll start with a deep dive into some of Excel's core capabilities, including formulas, charts & graphs, and PivotTables. You'll learn how to explore and analyze raw data, build custom visuals and interactive reports, and quickly expose patterns and insights with user-friendly pivots. From there we'll dive into more advanced tools like Power Query, Power Pivot & DAX, introduce advanced dashboard design principles, and explore tips and techniques to help you maximize your productivity. Finally, we'll wrap up with an exam prep course to help you earn your official MO-201 Excel Expert certification from Microsoft. COURSES INCLUDED: - Excel Formulas & Functions - Excel Charts & Graphs - Excel Pivot Tables & Pivot Charts - Power Query, Power Pivot & DAX - Advanced Excel Dashboard Design - Excel Pro Tips: Productivity - Excel Pro Tips: Formatting - Excel Pro Tips: Formulas - Excel Pro Tips: Visualization - Excel Pro Tips: Pivot Tables - Excel Pro Tips: Analytics - Excel MO-201 Exam Prep

This badge is earned by successfully completing all of the courses in the Data Visualization path at Maven Analytics. PATH HOURS: 79.0 PATH DESCRIPTION: This path is about bringing your data to LIFE, with project-based courses featuring some of the most popular data visualization platforms, including Excel, Power BI and Tableau. We'll start with Thinking Like an Analyst, a crash course designed to help you build a strong foundation for a successful career in data. Next we'll review key data visualization and design principles, explore 20+ common chart templates, and introduce powerful techniques for building dynamic, interactive reports and dashboards in Microsoft Excel. From there we’ll shift gears into Power BI Desktop, where we’ll build an entire data model and dashboard from the ground up. You'll learn how to bring your data to life with tree maps, gauges, KPI cards, slicers, parameters, and AI-driven visuals like key influencers and decomposition trees. Finally we'll dive into one of the world's most popular data visualization platforms: Tableau Desktop. Using a hands-on and project-based approach, we'll transform raw data into stunning, interactive reports and dashboards. COURSES INCLUDED: • Thinking Like an Analyst • Excel Charts & Graphs • Excel Pro Tips: Data Visualization • Excel Pro Tips: Formatting • Advanced Excel Dashboard Design • Microsoft Power BI Desktop • Intro to Tableau Desktop • Advanced Tableau Desktop

This badge is earned by successfully completing all of the courses in the BI Analyst path at Maven Analytics. PATH HOURS: 177.0 PATH DESCRIPTION: This path is for aspiring analysts and BI professionals looking to master a powerful stack of self-service business intelligence tools, including Excel, Power BI, MySQL and Tableau. We'll start with Thinking Like an Analyst, a crash course designed to help you build a strong foundation for a successful career in data. From there we'll dive into Excel's most powerful analytics tools (PivotTables, Power Query, Power Pivot & DAX), then shift into Power BI to design and publish a full-scale data model and dashboard from the ground up. Next we'll explore Tableau, one of the world's most popular data visualization platforms, and learn how to use Tableau Desktop and Tableau Prep to transform raw data into stunning, interactive dashboards. We'll cover one of the most versatile and practical database languages (MySQL), and learn how to build, manage and explore databases by applying SQL to unique, real-world projects and case studies. Finally, we'll wrap with Launching Your Data Career, a step-by-step guide to finding your path, building your brand, acing the interview, and landing your analytics dream job. COURSES INCLUDED: • Thinking Like an Analyst • Excel PivotTables & Pivot Charts • Excel Pro Tips: PivotTables • Excel Pro Tips: Analytics • Advanced Excel Dashboard Design • Power Query, Power Pivot & DAX • Microsoft Power BI Desktop • Microsoft Power BI Service • Advanced DAX for Power BI • Intro to Tableau Desktop • Intro to Tableau Prep • Advanced Tableau Desktop • MySQL Database Administration • MySQL Data Analysis • Advanced MySQL Data Analysis • Launching Your Data Career

This badge is earned by successfully completing all of the courses in the Python Specialist path at Maven Analytics. PATH HOURS: 67.5 PATH DESCRIPTION: This path is for BI analysts or data scientists looking to build job-ready Python skills and master the most popular libraries for data analysis and visualization. We'll start by mastering the core building blocks of Python for analytics, including data types, properties, and foundational tools like variables, numeric and string operators, conditional logic, loops and functions. Next we'll dive into NumPy & Pandas, two of the most popular Python packages for data analysis. We'll introduce arrays and array properties, common operations like indexing, slicing, filtering and sorting, and powerful methods for exploring, analyzing, aggregating and transforming dataframes. From there we'll explore data visualization methods using Matplotlib & Seaborn. We'll introduce data visualization frameworks and best practices, review tools and techniques for building and customizing basic charts, then explore advanced formatting options and custom visuals. Last but not least we'll use Plotly & Dash to build and deploy interactive visuals, dashboards, and web applications. COURSES INCLUDED: • Python Foundations for Data Analysis • Data Analysis with Python & Pandas • Data Visualization with Matplotlib & Seaborn • Interactive Dashboards with Plotly & Dash

This badge is earned by successfully completing all of the courses in the Python for Data Science path at Maven Analytics. PATH HOURS: TBD PATH DESCRIPTION: TBD COURSES INCLUDED: • TBD

This path is for anyone looking to build foundational data literacy and analytical thinking skills, and learn how to interpret, manage, analyze and communicate with data.