Certified AI & Business Intelligence Professional


Description

60 Days | SCORM | info@imacia.com


Course Description: This course integrates artificial intelligence (AI) and business intelligence (BI) through IMACIA’s Intelligence Power Fusion™ framework. Across nine modules, you follow one business case at Harbor Components. You use BI to prepare and verify data, build measures, and visualize performance. You use AI to help interpret the results, identify questions for further analysis, and draft a management briefing grounded in the evidence.

You work with SQL, Python and Jupyter, Excel, Power Query, Power BI and DAX, and ChatGPT. You build predictive models, compare forecasts, test a resource plan with Excel Solver, and use Power Automate to automate a reporting workflow with a review step. The capstone brings these skills together in a recommendation you support with data, documented assumptions, and checks for privacy, reliability, and governance.

Plan approximately 100 hours over 60–90 days. The course includes guided walkthroughs, hands-on assignments, and an 80-question certification exam with an 80% passing score. Practical software competency and the final project are assessed separately.

Content
  • Module 1 — Foundations of Artificial Intelligence
  • 01 Start ChatGPT and control the evidence
  • Start ChatGPT and control the evidence-Video
  • 02 Use AI to explain and check code without surrendering judgment.pdf
  • Use AI to explain and check code- Video
  • 03 Choose the right AI task.pdf
  • 03 Choose the right AI task — Video
  • 04 Select and prioritize high-value AI applications.pdf
  • 04 Select and prioritize high-value AI applications — Video
  • 05 Build a prompt with an evidence boundary.pdf
  • 05 Build a prompt with an evidence boundary — Video
  • 06 Test and improve AI output.pdf
  • 06 Test and improve AI output — Video
  • 07 Guided Harbor retail-demand planning illustration.pdf
  • 07 Guided Harbor retail-demand planning illustration — Video
  • 08 Module 1 Knowledge Check
  • 08 Module 1 Knowledge Check — Practice Walkthrough
  • 09 Module 1 Assignment — Verified AI Briefing and Demand Planning
  • Module 2 — AI for Business Decision-Making
  • M02_Handbook.docx
  • M02-F01 — Translate a management request into a data contract
  • M02-F02 — Calculate and challenge reporting economics
  • M02-L01 — Frame a decision and its measures
  • M02-L02 — Compare business scenarios
  • M02-L03 — Design a measurable pilot
  • Module 2 — Practical submission
  • Module 3 — Business Intelligence Fundamentals & Data Analytics
  • M03_Handbook.docx
  • M03-F01 — Start Excel with tables formulas and input validation
  • M03-F02 — Open SQLite and write your first retrieval query — Video
  • M03-F03 — Join aggregate and reconcile business data in SQL
  • M03-F04 — Start Jupyter and learn Python names — Video
  • M03-F05 — Prepare business data with pandas from SQL to clean records
  • M03-F06 — Analyze visualize and export with pandas
  • M03-F07 — Navigate Power Query and create a typed staging query
  • M03-F08 — Merge, refresh, and compare two independent outputs — Video
  • M03-L01 — Retrieve and reconcile with SQL — Video
  • M03-L02 — Build an auditable Excel analysis
  • M03-L03 — Create a repeatable Power Query preparation flow
  • Module 3 — Practical submission
  • Module 4 — Power BI, Dashboards & Data Visualization
  • 01 Start ChatGPT and control the evidence — Video
  • 02 Use AI to explain and check code — Video
  • M04_Handbook.docx
  • M04-F01 — Start Power BI Desktop and import controlled data
  • M04-F02 — Build relationships and a calendar — Video
  • M04-F03 — Learn DAX columns, measures, and evaluation context — Video
  • M04-F04 — Use CALCULATE and time comparisons — Video
  • M04-F05 — Construct and test an interactive executive dashboard — Video
  • M04-F06 — Share a report through a permitted delivery route
  • M04-L01 — Model sales with dimensions — Video
  • M04-L02 — Write and validate DAX measures
  • M04-L03 — Build a dashboard that supports a decision
  • Module 4 — Practical submission
  • Module 5 — Predictive Analytics & Machine Learning
  • M05_Handbook.docx
  • M05-F01 — Understand descriptive statistics and regression inputs
  • M05-F02 — Construct a preprocessing and classification workflow — Video
  • M05-F03 — Calculate model metrics and choose a threshold — Video
  • M05-F04 — Write an independent model notebook — Video
  • M05-L01 — Fit a regression baseline
  • M05-L02 — Train a late-shipment classifier — Video
  • M05-L03 — Choose a threshold using business cost
  • Module 5 — Practical submission
  • Module 6 — AI-Assisted Forecasting & Optimization
  • M06_Handbook.docx
  • M06-F01 — Run regression in Excel and reconcile it to Python
  • M06-F02 — Build forecast errors and planning scenarios — Video
  • M06-F03 — Define solve and independently verify a resource plan
  • M06-L01 — Compare a forecast with an honest baseline
  • M06-L02 — Optimize an assembly plan with Solver — Video
  • M06-L03 — Combine forecasts and constraints — Video
  • Module 6 — Practical submission
  • Module 7 — Intelligent Business Process Automation
  • M07_Handbook.docx
  • M07-F01 — Start Power Automate and create a flow — Video
  • M07-F02 — Handle conditions duplicates failures and recovery
  • M07-F03 — Build an event-triggered reporting flow — Video
  • M07-L01 — Map the reporting process and its controls — Video
  • M07-L02 — Build a scheduled private draft flow — Video
  • M07-L03 — Test recovery and measure actual improvement — Video
  • Module 7 — Practical submission
  • Module 8 — AI Governance, Ethics & Risk Management
  • M08_Handbook.docx
  • M08-F01 — Audit AI data access and analytical lineage
  • M08-F02 — Monitor model and workflow performance and make a release decision
  • M08-L01 — Protect data and resist untrusted instructions — Video
  • M08-L02 — Evaluate bias reliability and drift
  • M08-L03 — Make a release decision from evidence
  • Module 8 — Practical submission
  • Module 9 — Applied AI & Business Intelligence Professional Project
  • M09 Capstone Handbook and Guided Lessons
  • M09-F01 — Ingest a new month and prove the refresh bridge
  • M09-F02 — Refresh the BI solution and diagnose changes — Video
  • M09-F03 — Deliver a new planning decision — Video
  • M09-L01 — Scope the professional project
  • M09-L02 — Build and verify the integrated portfolio — Video
  • M09-L03 — Present and defend the recommendation — Video
  • Module 9 — Practical submission
  • IMACIA® AI & BI Professional — Certification Exam
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever