HomeData Analytics Basic to Mastery Bootcamp

Data Analytics Basic to Mastery Bootcamp

In an era of extreme competition and immense economic disruption, having a winning strategy becomes a crucial advantage to growth and sustainability.

At Kedrus Consulting, we offer critical and creative solutions, formulated on the basis of deep-rooted insights, research, and data analytics.

Kedrus Strategy helps organizations develop measurable outcomes by making smarter choices on their most significant strategic issues. We use cutting-edge methodologies, tools, technologies, and capabilities embedded with sited industry knowledge and experience to develop and execute integrated, tailored strategies to embrace the future with utmost confidence.

Strategic Management Services

Advance Excel
  • Getting data from different sources
  • Data Cleaning in excel
  • Pivot tables
  • Slicers and Filters
  • Formulas in Excel
  • XLOOKUP
  • Conditional formatting
  • Functions in excel
  • Charts and graphs in Excel
  • Excel Dashboard
  • Capstone Project
Power Bi
  • Introduction to Business intelligence, Data analysis and data
  • visualization.
  • Installation of PowerBI
  • Overview of PowerBI functionalities and services
  • Connecting to different data sources
  • Clean, shape, combine and transform data with Power Query
  • Modelling data relationships
  • DAX Queries
  • Visualizing data in power BI
  • Applying slicers and filters in PowerBI
  • Data Storytelling and presentation
  • PowerBI Capstone Project.
Tableau
  • Installing Tableau
  • Connecting to various data sources
  • Data Preparation in Tableau
  • Using filters in Tableau
  • Joins, Unions and Relationships in Tableau
  • Aggregations in Tableau
  • Structuring data in Tableau
  • Using Pivots in Tableau
  • Calculated fields
  • Creating charts and graphs
  • Creating Maps in Tableau
  • Dashboard visualization and story telling
  • Tableau Capstone Project
Structured Query Language
  • Introduction of SQL programming
  • Installation of SQL Server Management Studio (SSMS) and SQL Server
  • Overview of SSMSCreating databases and tables
  • Populating tables with data
  • Using SELECT and SELECT DISTINCT query
  • WHERE, AND, OR, NOT query
  • ORDER BY and GROUP BY query
  • INSERT INTO, UPDATE, and DELETE query
  • SQL Joins (Inner, left, right, full joins)
  • SQL Capstone Project

Transformation strategy services

Corporate
Strategy

We take a portfolio approach to strategic decision making by looking across all of a firm’s businesses to determine how they can create the most value.

Business
strategy

We design sets of competitive moves and actions that our client business can use to attract customers, compete successfully, strengthening performance, and achieve organizational goals

Operational
Strategy

We help our clients specify policies and plans for using their organization’s resources to support its long-term competitive strategy in tandem to her business strategy

Turnaround
strategy

We formulate a restructuring strategy poised in transforming a loss-bearing company into a profit-earning company by implementing systematic efforts to change.

Strategy
Retreats

Our strategy retreat allows teams to recalculate, reformulate, and make adjustments, it’s an opportunity to kick off the redundant processes, gather feedback, and transition to implementation.

Strategy Planning
& Execution

Our Strategic planning and execution articulates the vision of the organization, defines its strategy, develop strategic initiatives, and deduct strategies for implementation

Our clients testimonials

Our Partners

LET US WORK WITH YOU

We collaboratively work with you to build, develop, and position your brands and organization for maximum profitability and growth with Proven
BUSINESS STRATEGIES

CONTACT US