Research, Development & Production
DATA SCIENCE COURSE OUTLINE
Beginners
Week 1: Introduction to Data Science
• What is Data Science
• Overview of Tools use
• Opportunities & Salaries
• Course Structure
Week 2: Introduction to Excel
• Overview of Excel interface and navigation
• Understanding workbooks, worksheets, and cells
• Basic data entry and formatting techniques
• Introduction to formulas and functions
Week 3: Essential Formulas and Functions
• Exploring common mathematical and statistical functions (SUM, AVERAGE, MIN,
MAX)
• Understanding logical functions (IF, AND, OR)
• Working with text functions (CONCATENATE, LEFT, RIGHT, MID)
• Utilizing lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Week 4: Project 1: The Use of Excel for Simple Data Analysis
• Project description
• Submission criteria
Orbislabs Ltd 1
Week 5: Introduction to Python
• Overview of Python and its applications
• Setting up Python environment (Anaconda, Jupyter Notebook)
• Basic syntax, variables, and data types
• Working with strings and string manipulation
Week 6: Control Flow and Functions in Excel
• Introduction to Excel tables and structured references
• Sorting and filtering data
• Using PivotTables for data summarization and analysis
• Creating dynamic charts and graphs
Week 7: Advanced Data Analysis Techniques with Excel
• Understanding array formulas
• Performing what-if analysis with Goal Seek and Scenario Manager
• Using Excel's built-in statistical functions
• Introduction to Power Query for data manipulation and transformation
Week 8: Project 2: Advanced Data Analysis with Excel
• Project description
• Submission criteria
Week 9: Control Flow and Functions in Python
• Conditional statements (if-else) and loops (for, while)
• Working with lists, tuples, and dictionaries
• Functions and modular programming
• Error handling with try-except blocks
Orbislabs Ltd 2
Week 10: Data Visualization and Reporting with Excel
• Designing professional-looking dashboards
• Creating interactive charts with PivotCharts and slicers
• Customizing charts and graphs for effective storytelling
• Tips for presenting data effectively
Week 11: Python Data Structures
• Understanding and working with NumPy arrays
• Introduction to pandas for data manipulation and analysis
• Handling tabular data with DataFrames
• Basic plotting with Matplotlib and Seaborn
Week 12: File Handling and I/O Operations
• Reading from and writing to files (text files, CSV, Excel, JSON)
• Working with file objects and directories
• Serializing and deserializing data using pickle and JSON libraries
• Handling file exceptions and errors
Week 13: Introduction to Power BI
• Overview of Power BI and its features
• Understanding the Power BI ecosystem (Power BI Desktop, Service, Mobile)
• Getting started with Power BI Desktop
• Connecting to data sources (Excel, SQL Server, CSV, etc.)
Week 14: Data Preparation and Modeling
• Importing and transforming data using Power Query Editor
• Cleaning and shaping data for analysis
• Introduction to data modeling and relationships
Orbislabs Ltd 3
• Creating calculated columns and measures with DAX (Data Analysis Expressions)
Week 15: Data Visualization Basics
• Introduction to Power BI visuals (charts, graphs, maps, etc.)
• Customizing visuals with formatting options
• Creating basic reports and dashboards
• Adding interactivity with slicers, filters, and drill-through
Weel 16: Advanced Data Visualization Techniques
• Utilizing advanced visualizations (hierarchical slicers, custom visuals)
• Building dynamic reports with bookmarks and buttons
• Creating interactive tooltips and drill-down reports
• Designing visually appealing and effective dashboards
Week 17: Advanced Data Modeling and Analysis
• Understanding advanced data modeling concepts (many-to-many relationships,
role-playing dimensions)
• Implementing time intelligence calculations with DAX
• Using advanced DAX functions for complex analysis
• Incorporating external data with DirectQuery and Live Connections
Week 18: Data Integration and Collaboration
• Integrating Power BI with other Microsoft tools (Excel, SharePoint, Teams)
• Collaborating on reports and dashboards using Power BI Service
• Sharing and publishing reports to Power BI Service
• Implementing row-level security and managing access permissions
Week 19: Power BI for Business Intelligence
Orbislabs Ltd 4
• Leveraging Power BI for business analytics and insights
• Building predictive analytics models with Power BI and Azure Machine Learning
• Implementing advanced analytics features (AI visuals, Key Influencers)
• Incorporating advanced analytics into Power BI reports
Week 20: Advanced Topics and Best Practices
• Performance optimization techniques for Power BI reports
• Automation and scheduling of data refreshes
• Power BI deployment options (Power BI Report Server, Premium)
• Best practices for Power BI development and maintenance
Week 21: Final Project
• Project description
• Submission criteria
Week 22: Final Project Continues
• Progress tracking
Week 22: Conclusion and way forward
• What you learned so far
• How to get jobs/contracts
• Advancing your career
• Challenges
Prepared by:
Sulaiman Hamza Abdulwahab (Ibn Abdulwahab)
Orbislabs Ltd 5
