Big Data Analytics using Advanced MS. Excel & Powersuite

Explore the potential of Big Data and Analytics with Ms. Excel and Powersuite with this open class program. It is designed for professionals handling enterprise data. There are ways to leverage Excel along with other tools in the Microsoft Power Suite for more sophisticated data analytics.

Learn how to analyze and interpret large data sets using industry-standard tools and techniques to make informed and data-led decisions. It reduces your reporting time by 60% and your productivity! Here’s an overview of how you can use advanced MS Excel and Power Suite concepts for big data analytics:

1. Power Query:

Excel:

• • Use Power Query to connect, import, and transform data from various sources.
  • Cleanse and shape large datasets easily using the intuitive interface.

2. Power Pivot:

• Excel:
  • Utilize Power Pivot for data modeling and creating relationships between tables.
  • Handle larger datasets efficiently within the Excel environment.

3. DAX (Data Analysis Expressions):

• Excel:
  • Use DAX formulas for advanced calculations and aggregations within Excel.
  • Write DAX measures for complex calculations.

4. Machine Learning Integration:

• Power BI:
  • Use Power BI’s integration with Azure Machine Learning to incorporate machine learning models into your analytics.

5. Advanced Charting and Visualization:

• Excel and Power BI:
  • Create advanced charts and visualizations using the rich set of options available in both tools.
  • Utilize custom visuals and plugins for more specialized visualizations.

Date: 13th – 17th May, 2024

Venue: Nairobi, Kenya

Investment: Kes. 40,000 (Excl VAT) (USD 400)

Early Bird Offer: Sign up before 3^RD MAY 2024 to get 15% off the total Investment.

                          For full payments, sign up for 5 delegates for 4 before 3^RD MAY, 2024.

Call us or WhatsApp us at +254 726611805.

Email: info@inquestconsult.com

~Your Transformation & Impact Partner~

Open Class Programs Registration Form

Name *

Mobile Number *

Email *

Name of Organization

Designation

Reservation Details *

• Corporate
• Individual

Select the Program *

• Big Data Analytics using Advanced Ms. Excel– Basic | Intermediate | Advanced Excel
• Data Visualization & Interactive KPIs Dashboards Using Ms. Power BI
• New Manager Induction Program (Includes HR Skills For Non-HR Managers)
• Applied Human Capital Modelling and HR Analytics
• Selling Skills -The Art of Pitching (Pitch to Pay paradigm)
• Data Led Professional Bootcamp (Virtual | 10 weeks certified program)
• HR Budgeting
• Palladium XPP Balanced Scorecard Masterclass (Strategy Execution and Performance Management)
• Effective Business Communication and Presentation Skills
• Certified Data Led & Innovation Driven Manager (3-month certification Bootcamp)
• Workshop 3 days HR Skills for non – HR Managers
• Emotional Intelligence Masterclass
• Customer Experience Excellence Masterclass
• Financial Modelling Masterclass
• The Data & Innovation Driven Manager – An Evidence – Based Blackbelt Manager
• Sales Leadership Training and Coaching
• Choice 22

Register