FESTMAN
Tech Bootcamp
Business Intelligence and Data Analytics
Gain in-demand skills and hands-on experience in Business Intelligence, Data analytics, visual analytics and AI. No prior experience required.
✔ 100% online / in-person options
✔ Live instructor-Lead industry experts
✔ Cohort - Based Learning
✔ NEW! GenAI & prompt engineering
FestMan
certified
BI & Data Analyst
ASSOCIATE
Career Options after your Bootcamp
- Data Analyst
- Data Scientist
- Business Analyst
- BI Analyst
- Finance Analyst
- Marketing Analyst
- HR Analyst
CURRICULUM
What you’ll learn in this data analytics bootcamp
Master in-demand skills needed to succeed as a data analyst. Learn AI platforms to assist in uncovering patterns and extracting insights for decision making that will drive business decisions in your organisation.
COURSE 1
Data Analytics and Reporting with Excel
Master data analytics and reporting with Microsoft Excel: from data cleaning to advanced modeling. Learn to craft powerful insights using functions, PivotTables, charts, and Power Pivot—transforming raw data into actionable business intelligence.
Business Intelligence and Data Analytics
- Data analytics and Business Intelligence
- Becoming a BI and Data Analyst - Skills required
Microsoft Excel fundamentals
- Working with sheets and workbooks
- Excel formulas and functions
Advanced Excel formulas and Functions
- Using Defined names
- Dynamic Arrays
Analyzing Data with PivotTables and Charts
- Analyzing data with PivotTables and charts
- Slicers and Timelines
Introduction to Power Query
- Working with External Data sources such as Databases, folders, PDF etc
Cleaning and transforming Data
- Data transformation
- Merging and appending data
- Grouping and summarizing data
Data Modeling and Power Pivot
- Introduction to Data Modeling
- Dimensions and fact tables
- Primary and foreign keys
- Creating and managing relationships
Analyzing Data with DAX
- Analyzing Data with PivotTables with multiple tables
Designing automated reports and dashboards
KEY SKILLS
Hands-on and in-demand Excel skills
✔ Data Analytics
✔ Interactive Dashboard Design
✔ Data visualization
✔ Reporting automation
✔ Data transformation
✔ Data modeling
COURSE 2
Business Analytics with Power BI
Harness the full potential of Power BI to transform raw data into compelling visual narratives. Create impactful reports and interactive dashboards while mastering data preparation, modeling, and storytelling techniques.
What is Power BI?
Power BI is a business Intelligence platform allows you to create rich, interactive reports with visual analytics at your fingertips. Businesses leverage the advanced analytical and AI capabilities of Power BI to generate insights and tell compelling stories with their data.
Get started with Microsoft data analytics
- Getting started with Power BI
Importing Data into Power BI
- Work with external data sources such databases, excel workbooks, PDFs, Folder.
Cleaning and transforming Data
- Basic Data transformation
- Merging and appending data
- Grouping and summarize data
Modeling data in Power BI
- Design a data model in Power BI
- Schemas: Star and snowflake schemas
- Manage Relationships
- Cardinality and Cross Filter Direction
Analyzing Data with DAX
- DAX Functions
- Calculated Columns and Calculated Tables
- Aggregate functions and iterators
- Time Intelligence calculations
Visualize data in Power BI
- Work with Power BI visuals
- Improving users experience with Bookmarks, tooltips, drillthroughs and buttons
- Create a data-driven story with Power BI reports
- Creating reports and dashboards in Power BI
Financial Analytics and Reports
- Preparing financial reports
- Analyzing financial statements
Sharing and consuming Power BI Reports
- Sharing reports on Microsoft Teams
- Generating Power BI reports as PowerPoint slides for presentations
- Sharing report on the web
- Embedding reports on websites
KEY SKILLS
Hands-on and in-demand Power BI skills
✔ Data Analytics
✔ Data transformation
✔ Dashboarding
✔ Visual Analytics
✔ Data modeling
✔ AI
COURSE 3
SQL for Analytics and Reporting
SQL is one of the most in-demand skills for every data professional. Master this essential language to manipulate, analyze, and extract insights from databases.
Introduction to Databases, SQL, and Microsoft SQL Server
- Installing SSMS and Azure Data Studio
- SQL constraints
- Creating Databases and Tables
- Updating and managing databases
Data manipulation language
- Extracting data with SELECT
- Extracting data with conditions
Introduction to Aggregate functions
- Summarizing and aggregating data with aggregate functions
Grouping and Filtering Data
- GROUP BY with one column
- GROUP BY with multiple columns
- HAVING CLAUSE
Case Statement
- Creating conditional statements with CASE
SQL Joins
- Analyzing data from multiple tables with Joins
- Type of SQL Joins
Mastering SQL order of execution
- Creating complext queries with Subqueries
- Creating SQL Views
- Working with SQL Advanced Functions
Working with Window functions
- Partitioning data
- Ranking data with RowNum, Rank and DENSE Rank
- Time intelligence with LAG and LEAD
KEY SKILLS
Hands-on and in-demand Power BI skills
✔ Data Analytics
✔ Data transformation
✔ Data Management
✔ Databases Mgt
✔ Data modeling
✔ Data warehouses
COURSE 4
Generative AI for Business Analysts
Learn to craft prompts that extract meaningful analysis from your data, while mastering responsible AI practices and data privacy.
Introduction to Generative AI
- Introduction and Capabilities of Generative AI
- Applications and Tools of Generative AI
- Applications of Generative AI
- Tools of Text Generation
- Tools for Image Generation
- Tools for Audio and video generation
Prompt Engineering
- Introduction to Prompt Engineering
- Techniques and Approaches for Writing Effective Prompts
Generative AI for Data Analytics
- Generative AI Tools for Data Analytics
- Examples of Generative AI in Data Analytics
- Generative AI for Data Generation and Augmentation
- Generative AI for Data Preparation
- Generative AI for Querying Databases
- Generative AI for Data Insights
- Generative AI for Data Visualization
- Generative AI for Creating Dashboards
- Generative AI for slides and presentations
CHATGPT 4.O
FestMan Learning Hub is a digital learning platform that provides premium digital skills in Data Science, Business Intelligence, Data Analytics and Financial Modeling.
All rights reserved 2023
22 Independence Avenue, Accra
1st Floor, World Trade Centre
Accra - Ghana
support@festman.io
+233 54 123 9290