ABOUT US

ASK Infosystem specializes in comprehensive training and consulting services for data analytics, business intelligence, and digital transformation. Its consulting arm assists businesses and government agencies in automating processes and leveraging data for decision making. By seamlessly integrating teaching and consulting services, the company provides clients with holistic solutions tailored to their needs. Its key objectives include empowering individuals, fostering digital transformation, and enhancing Nigeria's global competitiveness through data-driven strategies.

Register Now

Launch Your Data Career

Master Data Analytics or Microsoft Excel Expertise in 12 Weeks

Why Microsoft Excel

  • Universal Application: Proficiency in Microsoft Excel is indispensable across various industries, serving as a foundational tool for data organization, analysis, and visualization.

  • Efficiency and Productivity: Mastering Excel enables individuals to streamline tasks, automate processes, and handle large datasets efficiently, thereby boosting productivity in both professional and personal endeavors.

  • Data Analysis and Visualization: Excel offers powerful features for data analysis, including pivot tables, functions, and charts, allowing users to derive insights and communicate findings effectively through visual representations.

  • Business Decision-Making: Excel skills are highly sought after by employers for roles involving financial modeling, budgeting, forecasting, and strategic planning, as it facilitates informed decision-making and drives business success.

  • Continuous Learning: Microsoft Excel is a versatile tool with a plethora of functionalities to explore, making it conducive to continuous learning and skill enhancement through online tutorials, courses, and practice exercises.

Why Data Analytics

  • Relevance in Today's World: Data analytics is pivotal in our data driven society, empowering individuals with skills to interpret vast amounts of information and extract meaningful insights.

  • Versatile Skill Set: Studying data analytics cultivates critical thinking and problem-solving abilities applicable across various domains, from personal finance to societal trends analysis.

  • Expansive Job Opportunities: The increasing reliance on data across industries translates into high demand for data analytics professionals, offering diverse career paths and stability.

  • Continuous Learning and Growth: The dynamic nature of data analytics ensures professionals are constantly challenged and engaged, with opportunities for lifelong learning and staying abreast of advancements.

  • Broader Impact: Integrating data analytics into our brochure not only showcases our commitment to innovation but also highlights the tangible benefits it offers to aspiring learners, from unlocking career prospects to fostering continuous growth and innovation.

How You Will Learn

100% Virtual

  • General Class

  • Private Class (extra charge)

Schedule

  • 8 Weeks of intensive learning (Weekends only)

  • 3 Business Case Capstone Project comprising of 2 personal Project and 1 Group Project for 4 weeks.

Bonus

  • Business Understanding and CV review Session

Data Analytics Bootcamp

Microsoft Excel

Week 1 to Week 3

Characters in Excel

  • Workbook & Worksheet

  • Cell naming, Understanding Excel

Basic Excel

  • Conditional Formatting

  • Data Transpose

  • Getting Data from different Sources

  • Data Cleaning, logical functions, Conditional Analysis

  • Vlookup, Hlookup

  • Pivot Table

  • Data Visualization with Excel

  • Revision and Assignment Review

SQL

Week 4 to Week 6

  • Downloading and Installing SQL

  • Understanding SQL

  • Revision of Data types and structure

  • Restoring Database

  • Basic SQL functions (Select, where, distinct, like, not like, wildcard, etc)

  • Aggregate functions (Count, Sum, Average, Min, Max)

  • Case, Group by, order by, Alias

  • Joins (Inner, outer, left and right)

  • Tables (Create, insert, Alter, Drop and truncate)

  • Views (Create, insert, Alter, Drop )

  • Revision and Assignment Review

Data Visualization

Week 7 to Week 8

  • Downloading and Installing Tableau Public and/or Tableau

  • Navigating the interface (Power BI and/ or Tableau)

  • Connecting to different data sources (Excel, CSV, Microsoft SQL Server)

  • Data Cleaning with Power BI and/ or Tableau

  • Data Modelling and relationships

  • Data visualization with Power BI and Tableau (pie, bar, donut, calendar)

  • Revision and Assignment Review

Week 8: Business Understanding

Advanced Microsoft Excel Bootcamp

Microsoft Excel

Week 1 to Week 3

Characters in Excel

  • Workbook & Worksheet

  • Cell naming, Understanding Excel

Basic Excel

  • Conditional Formatting

  • Data Transpose

  • Getting Data from different Sources

  • Data Cleaning, logical functions, Conditional Analysis

  • Vlookup, Hlookup

  • Pivot Table

  • Data Visualization with Excel

  • Revision and Assignment Review

Advanced Microsoft Excel

Week 4 to Week 8

  • Power Query

  • Power Pivot

  • Forecasting

  • Financial Modelling

  • Connecting Excel to Microsoft SQL Server

  • VBA- MACRO

Week 8: Business Understanding

Expectations

SET GOALS

Clearly define your goals and expectations

PREPARATION

Familiarize yourselves with key concepts

HARDWORK

Demonstrate a strong commitment to this training by attending sessions consistently.

DEDICATION

Actively participate and dedicate time and resources to maximize your learning experience

TECHNICAL REQUIREMENTS

Ensure your computer/device meets the technical requirements for seamless participation

ENGAGEMENT/COMMITMENT

Participate actively in discussions, exercises and hands-on projects or tasks.

NETWORKING

Take advantage of networking opportunities with instructors and fellow participants.

QUESTIONS

Feel free to ask questions and seek clarifications to enhance your understanding of the materials.

FEEDBACK

Provide feedback on the training content and delivery to help improve the learning experience.

APPLICATION OF SKILLS

Apply the skills gained during the training in practical, real-world scenarios.

RECTIFICATION UTILIZATION

Leverage the certification received to enhance your professional credibility.

CONTINUOUS LEARNING

Engage In continuous learning and stay up-to-date with advancements in Data Analytics and Microsoft packages.

OB SEARCH OR ADVANCEMENT

If applicable utilize your enhanced skills to pursue new job opportunities or advance your current role.

Our Services

TRAINING SERVICES

The focus of our training will be on Advanced Microsoft Excel, Data Analytics/ Business Intelligence. We will also be adding Project Management, Business Analysis, Web Design, Data Engineering, and Data Science in the future.

CONSULTING SERVICES

The focus of our consulting service is helping businesses, and government agencies automate their business process and using data to help solve their problem.

TRAINING AND CONSULTING SERVICES

For each company that avails itself of our consulting services, we seamlessly integrate the aforementioned teaching service, creating a comprehensive package. Our consulting service is inherently interconnected with the teaching component, ensuring a holistic and integrated approach, with the consulting service never standing alone.

Our Alumni Review

What they are saying about us

The Data Analytics Class I signed for was interesting. I started the class not having knowledge on any of the courses such as Power BI, Tableau and SQL. Now I am happy I started and finished the program for 8 weekends as the Instructors took time to teach and explain in details. I have upskill and can now complete different tasks thanks to the instructors. Also, Ask Infosystem has people in mind as the fee charge is relatively small compared to other programs with the same course outline. I am looking forward to starting the April Class and improve my skills with Advanced Excel

Samson Alo

My experience at the data analytics training program organized by ASKinfosystem was a comprehensive and enriching one, covering a wide range of topics from basic concepts to advanced techniques. The program had a structured curriculum, allowing beginners to learn from the fundamentals of data analytics, gradually progressing to more complex topics in the field. The emphasis on hands-on learning allowed participants to apply concepts and techniques to real-world datasets, solidifying our understanding and gaining experience with various analytics tools and software. The expert instructors (Samuel and his team) provided clear explanations of complex concepts, making the learning process interactive, enjoyable and engaging. I can now boastfully handle any case on Microsoft excel, Power BI, Tableau, and SQL. Most importantly, the practical projects provided valuable experience and a sense of community, allowing participants to expand their professional network. For me, ASKinfosystem is the main deal.

Adeola

As a beginner, I found the training to be comprehensive yet easy to follow, making it accessible for newcomers to the field. Initially, I thought I would drop out but you people made it so simple. The instructors are cool and understanding. They provided practical examples and exercises that allowed me to apply the concepts learned in real-world scenarios, helping to solidify my understanding of the training. The fact that the instructors were knowledgeable and engaging, made the learning experience enjoyable. They were always available to answer questions and provide guidance, creating a supportive learning environment for all participants. By the end of the course, I felt confident. I highly recommend this data analysis training for beginners looking to gain a solid foundation in the field. Whether you're new to data analysis or looking to enhance your skills, this training provides an excellent learning experience that is both informative and engaging. Looking forward to advance learning

Temitayo

Yeah to be honest. It was amazing. An eye opener to data analysis actually and with frequent practice one should stand well.

Tosin Amusa

Team

Our hard working team

Samuel Aikulola

Facilitator

Bilkisu Ibrahim

Strategy Lead

Gbadebo Joel

Facilitator

Oyeyemi Fagbuaro

Facilitator

Seye Odebiyi

Facilitator

Contact

Contact Us

Address

Abuja, Nigeria

Call Us

+234 806 024 4226

Email Us

info@askinfosystem.com

Open Hours

Monday - Friday
9:00AM - 05:00PM

Loading
Your message has been sent. Thank you!