Data Analytics Certificate (60 Hours)

---

Microsoft Excel is the leading spreadsheet program in the world. It is commonly used for both numerical and data analysis including calculations, graphs, statistical and database analysis. Excel Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting.

Excel Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

This course introduces SQL using Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. Learn how to do ad-hoc queries on a database to select the information you need. Understand how to write select statements and use wildcards, logical operators, and calculated columns. Learn to eliminate duplicates and work with date data. Learn how to aggregate data as well as group data, order data, and generate totals. Topics include SQL syntax, data definition language, and data manipulation language.

Discover how to glean insights and meaning from your data using the data visualization tool Tableau. Learn to connect to various data sources and gather data you need. Understand Tableau terminology and how to navigate the interface. Learn to manage Tableau worksheets, workbooks, and dashboards; set filters; and do basic calculations. Understand how to represent data with different visualization types and dashboard actions. Topics include terminology, data layout and formatting, organizing sheets, creating dashboards, analyzing data, working with geographical data, and basic chart types. Additional topics include managing data sources and visualizations, dimensions and measures, and sorting and filtering Tableau data. 

Build on your Tableau skills as you move into deeper analysis and more powerful visualization techniques. Discover how to aggregate data together from separate tables and disparate sources. Understand how to handle changes in your data source and join data sets. Learn how to connect various data sources, edit data connections, and blend data. Additional topics include adding reference lines to visualizations, working with shared and dual axis charts, creating combination charts, distributing and publishing data, interacting with the Analysis Menu, and creating data stories. 

Use Tableau Prep to prepare raw data now that you know how the Tableau Interface works. If you are responsible for accessing organizational data and transforming it for analysis in Tableau, cleaning and transforming data is one of the most time-consuming tasks of any data project, so make it pay off for users. By providing a visual interface so users can view their data after it is cleaned and transformed, it will make analysis quicker and easier. Processes can also be saved and replayed for each new download.

Power BI allows users to bring their business information to life. Visualize data through interactive tools designed to deliver fast, meaningful insights into the needs and goals of an organization. Discover how to connect to a wide variety of data sources. Learn the terminology associated with data analysis and explore the Power BI interface. Manage data in workbooks containing multiple worksheets, each displaying a different visualization. Explore ways to sort and filter a variety of data types. Manipulate date data to further enhance data analysis. Turn information into maps based on geographical data. Display data visualizations in interactive dashboards for a quick, easy view of what matters most. 

Improve your Power BI skills as you work with more complex data. Learn to use Data Modeling in Power BI to create the foundation for your reports and visualizations as well as to manage your data relationships. Understand naming conventions and best practices for importing your data. Use the Query editor to shape, cleanse, and query your data. Learn how to import Data Models from PowerPivot. Incorporate date and time intelligence to filter your data and discover how key metrics change over time. 

This course introduces Python, an interpreted, object-oriented programming language. Learn to design and write basic Python applications that incorporate fundamental programming concepts and accepted programming techniques. Understand basic Python syntax, variables and datatypes, scope, statements, and expressions. Learn control structures including conditionals and loops to control the flow of your application.