Business Analytics

Launch your career as a business analyst. Build job-ready skills for an in-demand career in business analytics. No prior experience required.

✔ 100% online / blended

✔ Live instructor-Lead industry experts

✔ Cohort - Based Learning

✔ NEW! GenAI & prompt engineering

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.

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

Financial analytics and reporting

• What-if analysis
  
• Automated financial reporting
  
• Financial analysis
• Variance analysis

KEY SKILLS

Hands-on and in-demand Excel skills

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 Visualization with Tableau

Harness Tableau to transform raw business data into compelling visual insights, enabling you to craft potent business intelligence reports that drive strategic decision-making.

What is Tableau?

Tableau is a visual analytics platform transforming the way we use data to solve problems—empowering people and organizations to make the most of their data.

Get Started with Tableau

Learn the foundational skills you need to begin your Tableau Desktop journey. Learn core data literacy and Tableau concepts, and get guidance for creating your first Tableau workbook.

Connect to and Transform Data

Learn how to connect to data sources, revise the properties of a data source, and save those customizations. You'll also get the tools and knowledge to clean, shape, and combine data.

Create Views and Dashboards

Learn how to create views, dashboards, and stories using basic and advanced chart types. Structure your data by using groups, bins, and hierarchies, and apply sorting and filtering techniques to reveal additional insights. Learn how to design dashboards that incorporate visual best practices.

Explore and Analyze Data

Use calculations, LOD expressions, and table calculations to create new views and insights. Create parameters and user controls, and show data trends and forecasts, as well as data distributions.

KEY SKILLS

Hands-on and in-demand Tableau skills

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 SQL skills

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
  

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

Programs

Bootcamps

Short courses

Self paced courses

Free courses

22 Independence Avenue, Accra

1st Floor, World Trade Centre

Accra - Ghana

support@festman.io

+233 54 123 9290