OVERVIEW

In most organizations now, many lack knowledge about AutoCAD which prevents an organization from running smoothly.

This is because, every small change to a drawing will take several days to complete. This is because they have to wait for the drafting part or people who are skilled in the use of AutoCAD software to change each of these changes.

With this course, it can help students/ course participants to be more productive at work and can change a drawing more quickly.

OBJECTIVE

• Strengthen skills in the use of AutoCAD Software in work and learning matters.

WHO SHOULD ATTEND

• To anyone who wants to use AutoCAD software for the first time or who has some knowledge of AutoCAD such as Draftsman, Assistant Engineer, Engineer and Architect.

OVERVIEW

This course provides attendees with information on how to build Microsoft Excel Dashboards to present information in a clear and easy to understand view.

The course outline below lists the topics that trainees will be competent in performing on completion of this course.

OBJECTIVE

Those attending should have an understanding of Microsoft Excel to an intermediate level, be competent Windows users and be familiar with the basics of file and disk management.

Prior completion of Citrus Training & Consulting’s Excel Intermediate course would be beneficial but not compulsory.

METHODOLOGY

The teaching approach contains a mix of lectures and practical examples and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

A large part of each course is spent with a set of specially prepared exercises and projects so that those attending gain firm foundations through their own practical experience. Professionally presented course notes are provided and these may be retained for reference afterwards.

OVERVIEW

This course is designed for those delegates who have the basic skills and bring further their knowledge to use Excel tools effectively.

OBJECTIVE

On completion of this course, attendees will be able to create a spreadsheet, format text and numbers, perform basic calculations and present data in a graphical format.

PREREQUISITES

Attendees do not need any previous experience of Excel but must have a basic understanding of PC’s, including familiarity with a keyboard and mouse.

OVERVIEW

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

OBJECTIVE

After completing this course, students will be able to:

• Create an Excel report
• Create an Excel table
• Create a pivot table and pivot chart
• Create a dashboard and analyze data
• Create Hierarchies
• Create an Excel data model and connect to external data

WHO SHOULD ATTEND

• This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

OVERVIEW

Data is all around us – from our schools, to our workplaces, and internet habits. Data storytelling recognizes that data on its own is often not enough to move people to action. Instead, we need to build narrative stories to engage audiences with data and provide value that serves a purpose.

In this 2-Days training, participants will be shared with insights and resources about data storytelling and how it is used in a variety of industries, organizations, and settings.

OBJECTIVE

• To understand about Data Storytelling
• To Learn the steps and methods in telling stories with Data
• To manage bad charts and inspire action
• To be effective in communication

METHODOLOGY

This is designed as a highly participative workshop, utilizing a variety of proven adult learning styles to ensure maximum understanding, comprehension and retention of the information presented. These include:

• Interactive Presentations and Input
• Discussions and opportunities for participants to share experience
• Application of key principles to realistic case studies
• Quizzes and Exercises
• Group Presentation and Projects

PREREQUISITES

Before attending this course, students must have:

• Excellent knowledge of relational databases and reporting
• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
• Some exposure to basic programming constructs (such as looping and branching)
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
• Familiarity with Microsoft Office applications – particularly Excel

OBJECTIVE

• Perform Power BI desktop data transformation
• Describe Power BI desktop modelling
• Create a Power BI desktop visualization
• Implement the Power BI service
• Describe how to connect to Excel data
• Describe how to collaborate with Power BI data
• Connect directly to data stores
• Describe the Power BI developer API
• Describe the Power BI mobile app

WHO SHOULD ATTEND

• The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

OVERVIEW

If you’re not already familiar with it, Power BI is a powerful business intelligence tool that enables you to create visually appealing and interactive reports and dashboards. With this tool, you can easily analyse your business data and gain insights that will help you make more informed decisions.

The aim of this training program is to provide beginners with a comprehensive understanding of Power BI and its features.

OBJECTIVE

• Develop proficiency in Power BI for data analysis
• Learn how to create data models, visualizations and reports using Power BI
• Incorporate effective data story-telling in reports
• Understand how to manage and maintain Power BI solutions at scale

WHO SHOULD ATTEND

• This training program is intended for individuals with little or no experience in Power BI who are looking to gain the necessary skills to effectively use the tool for data visualization and business intelligence purposes