Display working knowledge of Excel for Data Analysis.

Perform basic spreadsheet tasks including navigation, data entry, and using formulas.

Employ data quality techniques to import and clean data in Excel.

Analyze data in spreadsheets by using filter, sort, look-up functions, as well as pivot tables.

Create basic visualizations such as line graphs, bar graphs, and pie charts using Excel spreadsheets.

Explain the important role charts play in telling a data-driven story. 

Construct advanced charts and visualizations such as Treemaps, Sparklines, Histogram, Scatter Plots, and Filled Map Charts.

Build and share interactive dashboards using Excel and Cognos Analytics.

Develop a foundational understanding of Python programming by learning basic syntax, data types, expressions, variables, and string operations.

Apply Python programming logic using data structures, conditions and branching, loops, functions, exception handling, objects, and classes.

Demonstrate proficiency in using Python libraries such as Pandas and Numpy and developing code using Jupyter Notebooks.

Access and extract web-based data by working with REST APIs using requests and performing web scraping with BeautifulSoup.

Play the role of a Data Scientist / Data Analyst working on a real project.

Demonstrate your Skills in Python - the language of choice for Data Science and Data Analysis.

Apply Python fundamentals, Python data structures, and working with data in Python.

Build a dashboard using Python and libraries like Pandas, Beautiful Soup and Plotly using Jupyter notebook.

Analyze data within a database using SQL and Python.

Create a relational database and work with multiple tables using DDL commands.

Construct basic to intermediate level SQL queries using DML commands.

Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Construct Python programs to clean and prepare data for analysis by addressing missing values, formatting inconsistencies, normalization, and binning

Analyze real-world datasets through exploratory data analysis (EDA) using libraries such as Pandas, NumPy, and SciPy to uncover patterns and insights

Apply data operation techniques using dataframes to organize, summarize, and interpret data distributions, correlation analysis, and data pipelines

Develop and evaluate regression models using Scikit-learn, and use these models to generate predictions and support data-driven decision-making

Implement data visualization techniques and plots using Python libraries, such as Matplotlib, Seaborn, and Folium to tell a stimulating story

Create different types of charts and plots such as line, area, histograms, bar, pie, box, scatter, and bubble

Create advanced visualizations such as waffle charts, word clouds, regression plots, maps with markers, & choropleth maps

Generate interactive dashboards containing scatter, line, bar, bubble, pie, and sunburst charts using the Dash framework and Plotly library

Apply techniques to gather and wrangle data from multiple sources.

Analyze data to identify patterns, trends, and insights through exploratory techniques.

Create visual representations of data using Python libraries to communicate findings effectively.

Construct interactive dashboards with BI tools to present and explore data dynamically.

Describe how you can use Generative AI tools and techniques in the context of data analytics across industries

Implement various data analytic processes such as data preparation, analysis, visualization and storytelling using Generative AI tools

Evaluate real-world case studies showcasing the successful application of Generative AI in deriving meaningful insights

Analyze the ethical considerations and challenges associated with using Generative AI in data analytics

Describe the role of a data analyst and some career path options as well as the prospective opportunities in the field.

Explain how to build a foundation for a job search, including researching job listings, writing a resume, and making a portfolio of work.

Summarize what a candidate can expect during a typical job interview cycle, different types of interviews, and how to prepare for interviews.

Explain how to give an effective interview, including techniques for answering questions and how to make a professional personal presentation.