Karatun Binciken Bayanai da Zanen Bayanai
Overview
Wannan karatu na makonni takwas (8) an tsara shi domin koyar da mahalarta dabarun binciken bayanai da zanen bayanai (Data Analysis da Visualization) ta amfani da kayan aiki na zamani kamar Excel, Power BI, da SQL.
Wannan karatu yana ba da horo kai tsaye daga matakin farko har zuwa na gaba, inda za a koyi yadda ake nazarin bayanai, gina samfuri, da kuma gabatar da bayanai cikin sauƙi da inganci. Kowanne mako yana ƙara sabbin ilimi akan wanda aka koya a makon baya, tare da aiki da ayyukan da ke ba da gogewa ta zahiri, har zuwa babban aikin ƙarshe da zai nuna abin da aka koya.
Wannan karatu ya dace da masu farawa da ke son fara sana’a a fannin binciken bayanai, da kuma ƙwararru da ke son ƙara ƙwarewa wajen yanke shawara bisa bayanai.
Manufar Babban Karatun Nan
Fahimtar muhimman ka’idoji na binciken bayanai, ciki har da nau’ukan sa, muhimmanci, da yadda ake amfani da shi a fannoni daban-daban na rayuwa da masana’antu.
Nuna kwarewa wajen sarrafa bayanai, shigar da su, da kuma gyara su ta amfani da Excel don nazarin bayanai cikin tsari.
Amfani da dabarun ci-gaba na Excel don tsaftace bayanai, tabbatar da ingancin bayanai, da ƙirƙirar dashboard masu hulɗa.
Gina da sarrafa zane-zane da rahotanni masu hulɗa, da kuma fahimtar ka’idoji na Data Modeling.
Rubuta SQL queries don fitar da bayanai, sarrafa su, da nazari daga tsarin bayanai (Relational Databases).
Hada bayanai daga wurare daban-daban, inganta tambayoyi (queries), da amfani da dabaru don warware tambayoyin kasuwanci masu rikitarwa.
Course Outline
Week 1 - Introduction to Data Analysis
- Definition and types of data analysis
- Importance and overview of the data analysis process
- Introduction to Excel, Power BI, and SQL as tools
- Data collection/gathering techniques
- Assignment
Week 2 - Microsoft Excel Fundamentals
- Excel interface and navigation
- Data entry, formatting, and basic formulas/functions
- Sorting and filtering data
- Creating charts and graphs
- Assignment
Week 3 - Advanced Microsoft Excel for Data Analysis
- Data cleaning with Power Query
- Pivot Tables and Pivot Charts
- Data validation and conditional formatting
- Data modeling and building dashboards
- First project
Week 4 - Power BI
- Overview and components of Power BI
- Connecting to data sources and data modeling
- Creating visualizations and dashboards
- Basics of DAX (Data Analysis Expressions)
- Assignment
Week 5 - SQL for Data Analysis (Part 1)
- Relational databases
- Understanding SQL Syntax
- Querying Data with SELECT statements
- Assignment
Week 6 - SQL for Data Analysis (Part 2)
- SQL Aggregate Functions, GROUP BY, and WHERE Clauses
- Combining Data with JOIN Statements
- Assignment
Week 7 - Advanced SQL
- Practical Class
- Subqueries and Nested Queries
- Data Manipulation (INSERT, UPDATE, DELETE)
- Assignment
Week 8 - Capstone Project
- Capstone Project
- Capstone Project Presentations
- Review and Course Conclusion
Course Outcomes
By the end of this course, students will be able to:
- Be able to perform data cleaning, aggregation, and summarization tasks in Excel and Power BI.
- Develop functional and interactive dashboards that effectively communicate data insights.
- Master the fundamentals of SQL, enabling them to query and manipulate data within relational databases.
- Possess the ability to design and present data-driven projects, demonstrating their ability to analyze data, build visualizations, and tell a compelling story.
- Earn a certificate of completion, validating their skills in data analysis and visualization.
Expert Instructors
Zacham Happiness Kabantiok
Instructor
Praise Barnabas
Instructor
Frequently Asked Questions
When is the class starting?
We send all registered participants emails when classes are to commence.
Do you offer online mode?
Yes, we offer online mode of teaching as well as physical mode.
What's the fee for this course?
Our course fee is 40,000 naira
Can I make payment in Installments?
Yes, but only 80% deposit at first payment.
When is the next Cohort?
Our next cohort will be in July 2025
Do I need a Laptop for this course?
Yes you need a laptop for this course.