Consuldata and Research Centre, Mwalimu International Hotel, Kisii-Kilgoris Road, Kisii (2025)

13/09/2023

As the market expands for individuals with data analytics and ML, most of persons from various field are seeking to grow their knowledge and skills. In the process learners make mistakes. Here attached, we are sharing possible mistakes that learners are making and solutions. Adjust and keep going!

11/09/2023

Definition and differences of Monitoring, Evaluation, Learning, and Adaptive management. It looks an ideal time to take our course...

06/09/2023

Self paced courses for September intake...

18/08/2023

Intuitive guide to simple linear regression

I am sure regression is not a new term to you. But, can you intuitively explain it to non-technical personnel (your task as data/ business analyst), show your work procedure in the world's widely used software, Ms. Excel?

Whether you are an expert in Statistics, or a student of data and business analytics, this guide is for you. Happy reading!

19/07/2023

Intuitive Guide to Correlation in R.

I love basics, I love details. In this session we are going introduce correlation, how to calculate correlation coefficient in R, how to calculate correlation coefficient for multiple pairs in R, how to test the correlation significance for a single pair, how to test correlation significance for multiple pairs, test the assumptions of correlation test, interpret the correlation significance using p-value, t-value and confidence level. We intuitively explain what we mean by "correlation does not imply causal". We explore the application of correlation. It is a complete note on correlation in R that I recommend and dedicate to you all.

You will have R file and data dictionary attached.

pdf notes: https://drive.google.com/file/d/1FiwrJOhoMdxcj6Xis_AhM6LK8raCzunT/view?usp=sharing

09/07/2023

Greetings from the Consuldata and Research Centre team. We have noted that learning data tools is not an event but a process. Our team of professionals wants to offer weekly, project-based learning for learners with basic to advanced Ms. Excel skills for a period of 4 weeks. The project will be a step- by- step guidance to business analytics. At the end of each week, the tutor will cover the projects in detail for learners to grab the content fully. This will improve the learners' skills and create a portfolio for them to share with their peers and prospect employers. Enjoy. Here is the registration form.

https://forms.gle/Kom9tKTwy7adpWLx5

Here is the the preview of the project. It requires you to be agile, passionate and ready to learn. https://drive.google.com/file/d/1MAJ09c7pn6iBdaNxeL511CffT6RnUOMa/view?usp=sharing

06/07/2023

Greetings from the Consuldata and Research Centre team. We have noted that learning data tools is not an event but a process. Our team of professionals wants to offer weekly, project-based learning for learners with basic to advanced Ms. Excel skills for a period of 4 weeks. The project will be a step- by- step guidance to business analytics. At the end of each week, the tutor will cover the projects in detail for learners to grab the content fully. This will improve the learners' skills and create a portfolio for them to share with their peers and prospect employers. Enjoy. Here is the registration form.
https://forms.gle/Kom9tKTwy7adpWLx5

Warm regards

02/07/2023

Greetings from Consuldata and Research Centre team. We have noted that learning data tools is not an event but a process. Our team of professionals wants to offer weekly project-based learning for learners with basic to advanced Excel skills for a period of 4 weeks. The project will be a step- by- step guidance to business analytics. At the end of each week, the tutor will cover the projects in details for learners to grab the content fully. This will improve the learners' skills and create portfolio for them to share with their peers and prospect employers. Enjoy

21/03/2023

Statistical Deceptions

Statistics play very important role in decision making. However, it has to be implemented by well defined objectives, right sampling techniques, scientific collection of data, appropriate assumption, right transformation, analysis and interpretation techniques, and clear communication for action. Scarcity in any of this, leads to wrong conclusion, poor decision and hence business losses.

Lets consider television advertisements. Many of the numbers about in this way do not represent careful statistical analysis. They can be misleading and push you into decisions that you might find cause to regret.

Examples;

Example 1: A new advertisement for J&J supermarket in early November last year result in 45% increase in household sales for the following month. Thus, the advertisement was effective.
A major flaw is that sales in household items generally increases in the month of November and December regardless of the advertisements. This is called a history effect and leads people to interpreted outcomes as a result of one variable when another variable (in this case, time) is actually responsible.

Example 2: The more churches in the city, the more crime there is. Thus, churches lead to crime.
A major flaw is that both increased churches and increased crime rates can be explained by larger populations. In bigger cities, there are both more churches and more crime. This is called third variable effect where a variable cause both situation. However, people erroneously interprate that there is a causal relationship between two primary variables rather than recognize the third variable that can cause both.

Example 3: 75% more interethnic marriages are occurring this year than 15 years ago in Kenya. Thus, our society accepts interethnic marriages.
A major flaw is that we don’t have the information that we need. What is the rate at which marriages are occurring? Suppose only 1% of marriages 15 years were interethnic and so now 1.75% (1.75 is 75% more than 1). But this latter number is hardly evidence suggesting the acceptability of interethnic marriages. In addition, the statistics does not provide fluctuations over the years, so this might not be the highest interethnic marriage.

NB: Statistics is a process. So, make sure you are on the right track throughout the process.
Defined clear objectives (context literature review, conduct capture mission, stakeholder analysis, and key problem analysis), right sampling techniques, scientific collection of data, appropriate assumption, right transformation, analysis and interpretation techniques, and clear communication for action.

12/03/2023

Mid march. Get skilled with CRC- Oasis of Research, Data and Business Analytics Skills

11/03/2023

Power BI for Business Intelligence Analyst

Executive Summary
Would you like to create meaningful evaluations from large amount of available data that show you interactively certain development such as sales, production figures, financial data or other data?
Perhaps you would like to know which product or sales area is growing faster or slower than others, or how your products are developing in specific countries or what innovative power your company has (e.g., how large is the sales share of product that have not been in market for long).
Data analysis often entails pulling extensive amount of information from a wide variety of data sources which requires preparation. This is exactly where Power BI comes in. It will help you in preparing and analyzing data sources including data sets and models or relationship between tables, meaningful visualization of data, filters and slicers in addition to bookmarks.

What is Power BI
Power BI is a standalone Microsoft business intelligence product, which include both desktop and web-based application for loading, modeling, analyzing and visualizing data.
BI in Power BI stands for business intelligence (BI). Business intelligence is the art of extracting meaningful information from data. BI technologies can handle large amounts of structured and unstructured data to identify, develop and otherwise create new strategic business opportunities.

Why Power BI
i. Access to various databases as sources for data – business data is often as Excel spreadsheet but as databases. When it comes to evaluation, databases do not provide the tools you need to analyze the data. The database programs themselves often generate only list-based reports optimized for printing. Power BI can establish connection to various data sources regardless of where they are located on your local PC, on a file server of your company, or in the cloud (cloud service providers are like AWS, Microsoft Azure, Google cloud, Oracle cloud, IBM cloud etc.)
ii. Build relational models to blend data from multiple sources – business data are often in different tables and databases. Power BI enable users to create table relationships to analyze holistic performance across entire data models.
iii. Define complex calculation using Data Analysis Expression (DAX) – this enhances datasets and enable advanced analytics with powerful portable expressions
iv. Visualize data with interactive reports and dashboards – build custom business intelligence tools with best-in-class visualization and dashboard features.
v. In-demand industry leader.

Where to apply
i) Gauge effectiveness of business decisions
ii) Explore “what-if” scenarios
iii) Build customized visuals

Course Level
Beginner to advanced level Power BI Desktop version

Target Audience
 Business Intelligence Analyst
 Visualization specialist
 Business user
 Functional consultant
 Student

Learning Outcomes
After completing this course, you will be able to use Power BI to:
i. Connect and transform the row data
ii. Build relational data model
iii. Create calculated columns and DAX measures
iv. Design an interactive report and dashboard to analyze and visualize data.

Why choose us
We have professional trainers who will give you background theories and hands-on practical skills that will enhance your understanding and confidence in working with SQL. Moreover, we have blended training models that include live streaming classes where you interact with your tutor at personal level, recorded materials and pdf notes that you can access and learn at your own pace, without forgetting, assessments and hands-on practical that will help you to evaluate your understanding and application of various dimension of tasks in the job market.
Find the attached in here the course outline. We wish you a happy learning!

11/03/2023

Statistical analysis is collecting, organizing, and interpreting data meaningfully. Business statistics offers data to managers who help them to make successful decisions based on fundamental values rather than intuitions. Statistics is used to analyze the data and make interpretations, whether for sales estimation, introducing a new product line, making new production strategies, etc.

The primary purpose of business statistics is data collection, allowing managers to evaluate past performance, forecast future business practices, and run the organization profitably. Furthermore, it becomes the basis for risk navigation, sales prediction, market trends, changing consumer behavior, price determination, etc.

For businesses that envision gaining a competitive edge, data is the right tool they should invest in. The main reason behind the success of any big firm is its emphasis on data and research.

For example- Amazon recommends their customers based on their past orders and buying behavior. They use machine learning and data analytics to drive their recommendation engines rather than blindly suggesting [products to customers.

Similarly, Starbucks uses an analytical approach to identify its future store locations. They partner with a location analytics company to find ideal store locations. They continuously use data to make informed decisions about finding new customers, acquiring customer insights, targeting marketing campaigns, spotting fraud, identifying other business risks, etc.

A business can benefit in myriad ways when they utilize accurate data. Let’s find out how.

1. Making more Confident Decisions.
With the collection and analysis of data, you can make any business decision confidently as it is based on specific patterns and trends evaluated. No matter whether it is related to the launch of a new product or its discontinuation, entering into a new market, and so on.

2. Continual Organizational Growth
Once you implement a strategy that was made using data, the next step you use is to check its outcomes. Businesses can apply their decisions to many functions, operations, and departmental activities. One after another, when they keep on implementing strategies will empower them to set actionable benchmarks that will result in continual growth and progress.

3. Hunting New Business Opportunities
With statistical analysis, businesses can have access to more opportunities. The timely evaluation of market trends and customer demands will enable them to gain insights before their rivals. Hence, with correct quantities of data, they can identify business opportunities and gain an edge over their rivals.

08/03/2023

Happy International Women's Day!

For the International Women’s Day coming up on the 8 of March, the theme is, ‘DigitalAll: Innovation and Technology for Gender Equality’. So, this particular International Women’s Day all actors are expected to look at ways whereby they can innovatively include women because when you talk about gender equality, you will talk about women and men working together. So in terms of technology, how can women be carried along in these spaces?

Allow us to do the small things we do in a bigger way, we are gifting you one of the most marketable course in the world today (50% off). Thank you and happy women's day from CRC family😍

07/03/2023

Monitoring and Evaluation

Monitoring and Evaluation (M&E) is used to assess the performance of projects, institutions and programmes set up by governments, international organizations and NGOs. Its goal is to improve current and future management of outputs, outcomes and impact. Monitoring is a continuous assessment of programmes based on early detailed information on the progress or delay of the ongoing assessed activities. An evaluation is an examination concerning the relevance, effectiveness, efficiency and impact of activities in the light of specified objectives

Monitoring and evaluation are critical for building a strong, global evidence base around projects for assessing the wide, diverse range of interventions being implemented to address it. At the global level, it is a tool for identifying and documenting successful programmes and approaches and tracking progress toward common indicators across related projects. Monitoring and evaluation forms the basis of strengthening understanding around the many multi-layered factors underlying projects and the effectiveness of the response at the service provider, community, national and international level.

At the programme level, the purpose of monitoring and evaluation is to track implementation and outputs systematically, and measure the effectiveness of programmes. It helps determine exactly when a programme is on track and when changes may be needed. Monitoring and evaluation forms the basis for modification of interventions and assessing the quality of activities being conducted.

Monitoring and evaluation can be used to demonstrate that programme efforts have had a measurable impact on expected outcomes and have been implemented effectively. It is essential in helping managers, planners, implementers, policy makers and donors acquire the information and understanding they need to make informed decisions about programme operations.

The course will enable you build basics to advanced understanding of monitoring and Evaluation!

06/03/2023

Greetings,

Allow us to assume you are preparing for data related job; to be a data administrator,
data analyst, business analyst, a data engineer or a data scientist. We are guessing
right, right? The number one skill that you must have after spreadsheet is proficiency
in SQL. Yes!

To demonstrate the importance of SQL for data-related jobs, we have analyzed more
than 68,000 job listings on LinkedIn, looking at key skills mentioned in job posts
with “data” in the title.

For data roles, SQL is the most in-demand skill, listed in a whopping 61% of job
posts. Therefore, if you want to become a data analyst, learning SQL should be at
the top of your to-do list.

Why choose us: We have professional trainers who will give you background
theories and hands-on practical skills that will enhance your understanding and
confidence in working with SQL. Moreover, we have blended training models that
include live streaming classes where you interact with your tutor at personal level,
recorded materials and pdf notes that you can access and learn at your own pace,
without forgetting, assessments and hands-on practical that will help you to evaluate
your understanding and application of various dimension of tasks in the job market.

Find the attached in here the poster. We wish you a happy learning!

05/03/2023

Applied Probabilities in Business Decisions with Python

In business analytics, probability theory is used in calculation of long-term gains and losses. It provides information on the uncertainties and help the stakeholders to make a better decision. For example, in insurance, what is the likelihood of all policy holders to make a claim this year, or none of them making a claim. by predicting the random variable X - say the number of policy holders making a claim and Y - the amount to be claimed this year the analyst can use the probability theory to calculate premium (amount paid for insurance) and reserves. The same concept applies to risk analysis at the financial institution; the predicted frequency of default and the amount of default. In this course, we cover this predictions from introduction to probabilities to building simple and friendly models in python. See the details on the attached poster!

16/02/2023

Data analytics has been identified as the most in-demand career of 21st centaury. Probabilities and statistics are the main background. Without forgetting statistical programming, data visualization and machine learning algorithms. Despite extensive classwork on the probabilities in both A- level and college course work, most of the students were not able to apply the knowledge of probabilities in enhancing business decision. In this webinar, we are going to discuss application of probabilities in decision making. Register here; https://forms.gle/ewY5HspeHurnrs5o9 see you there!

16/02/2023

Data is a valuable asset – so much so that it’s the world’s most valuable resource. That makes understanding the different types of data more important than ever. In the business world, more companies are trying to understand big numbers and what they can do with them. Expertise in data is in high demand. Determining the right data types and scales of measurement is among the important guide in deciding the type of analysis we are going to undertake for guiding business decision.

Would you love to learn more on data types and scales of measurement? Here is the valuable guide. https://drive.google.com/file/d/1BNIdHUJBO_qvAbUFzogqDKox26IkzWle/view?usp=sharing Enjoy learning!

Consuldata and Research Centre

13/09/2023

11/09/2023

06/09/2023

18/08/2023

19/07/2023

09/07/2023

06/07/2023

02/07/2023

21/03/2023

12/03/2023

11/03/2023

11/03/2023

08/03/2023

07/03/2023

06/03/2023

05/03/2023

16/02/2023

16/02/2023

Address

Telephone

Website

Alerts

Contact The Business

Shortcuts

Share