{"id":1843,"date":"2022-10-05T17:09:48","date_gmt":"2022-10-05T21:09:48","guid":{"rendered":"https:\/\/www.bu.edu\/adminsc\/?page_id=1843"},"modified":"2022-10-06T09:28:27","modified_gmt":"2022-10-06T13:28:27","slug":"curriculum","status":"publish","type":"page","link":"https:\/\/www.bu.edu\/adminsc\/programs\/preparatory-labs\/ad100\/curriculum\/","title":{"rendered":"AD100 Curriculum"},"content":{"rendered":"
← Back to Preparatory Labs<\/a>← Back to AD100<\/a><\/div>\n

\"MET<\/p>\n\n\n\n\n
Skills Demonstrated<\/b><\/u>:<\/p>\n
    \n
  • Understanding of the Excel environment<\/li>\n
  • Creating Business Models in Excel<\/li>\n
  • Commonly used functions in Excel<\/li>\n
  • Visualization in Excel<\/li>\n
  • Using Analysis Toolpak<\/li>\n
  • Using Solver in Excel<\/li>\n
  • Using Power Pivot in Excel to summarize data<\/li>\n
  • Using Power Query in Excel to import data<\/li>\n
  • Creating Visualizations in Power BI Desktop<\/li>\n
  • Enriching Data in Power BI desktop using DAX<\/li>\n
  • Using SQL to query data<\/li>\n
  • Using SQL to alter data<\/li>\n<\/ul>\n<\/td>\n
Examinations Successfully Completed<\/b><\/u>:<\/p>\n
    \n
  • Unit Test #1: Introduction to Business Modeling and Building Models In Excel<\/li>\n
  • Unit Test #2: Basics in Power BI for Excel<\/li>\n
  • Unit Test #3: Advanced Functions with MS Power BI Tools for Excel<\/li>\n
  • Unit Test #4: Introduction to Power BI Desktop<\/li>\n
  • Unit Test #5: Data Analysis with Power BI and Power Pivot for Excel<\/li>\n
  • Unit Test #6: Introduction to SQL Server Concepts<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
AD100 <\/b><\/u>Prepares Students for<\/b><\/u>:<\/p>\n
    \n
  • AD571 (pre-requisite): Business Analytics Foundations<\/li>\n<\/ul>\n<\/td>\n
Lab Relationships<\/b><\/u>:<\/p>\n
    \n
  • AD100 is a pre-requisite for AD200. AD100 badge earners are automatically enrolled in AD200.<\/li>\n
  • AD100 is often taken in conjunction with ADR100.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    ← Back to Preparatory Labs← Back to AD100 Skills Demonstrated: Understanding of the Excel environment Creating Business Models in Excel Commonly used functions in Excel Visualization in Excel Using Analysis Toolpak Using Solver in Excel Using Power Pivot in Excel to summarize data Using Power Query in Excel to import data Creating Visualizations in Power […]<\/p>\n","protected":false},"author":19676,"featured_media":0,"parent":1739,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"page-templates\/no-sidebars.php","meta":[],"_links":{"self":[{"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/pages\/1843"}],"collection":[{"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/users\/19676"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/comments?post=1843"}],"version-history":[{"count":6,"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/pages\/1843\/revisions"}],"predecessor-version":[{"id":1859,"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/pages\/1843\/revisions\/1859"}],"up":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/pages\/1739"}],"wp:attachment":[{"href":"https:\/\/www.bu.edu\/adminsc\/wp-json\/wp\/v2\/media?parent=1843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}