Course Description

Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world.
​In this course, you will learn how to use Tableau or Microstrategy, as well as Excel and SQL to manipulate data so as to be able to provide insights. You’ll develop skills and a perspective that will make you more productive faster and allow you to become a valuable asset to your organisation.

Takeaways

• Learn how to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Microstrategy/Tableau and SQL to analyse data, create forecasts, design visualisations, and present your insights.

• You will get an introduction to Data Analytics and its role in business decisions, How “Big Data” is used, a methodology for conducting Data Analysis and what tools and techniques are commonly used by experts.

• Finally, you'll have a chance to put your knowledge to work in a simulated business case.

What background knowledge is necessary?
No prior experience with analytics or programming is required. This Specialization is intended for anyone with an interest in data analysis and its applications in business decision-making.
We've designed this course for learners who are new to the field of data and analytics.

Important Information

Course Dates: 8 & 9 September 2018
Price: £650
Course Hours: 9:30 am to 5:30 pm (1 hour lunch break and coffee breaks)
Location: Central London 5 minute walk from Oxford circus station
What you need for the training: We recommend that attendees to bring their personal laptops to the session with Excel installed, the excel Analysis Toolpack ad-in and the latest version of Tableau.​

Should you have any questions please contact sam@business-discovery.co.uk ​

Reviews from Students

"Very good course. I totally recommended it. I could learn and practice SQL code. I could understand how to do a deeply navigation into the data."

"Amazing course. As a beginner, it was very easy for me to understand and practice SQL and visualization tools. The examples we worked on were very good too, letting you understand what could be done and how."

"Your training gave me the confidence and credit to change career. And I still check your slides sometimes! I really love my new job :)"

Agenda
Unit 1
​
Introduction to Data Analytics
This section will expose you to the data analytics practices executed in the business world. We will explore such key areas as the analytical process, how data is created, stored, accessed, and how the organisation works with data and creates the environment in which analytics can flourish. What you learn in this section will give you a strong foundation in all the areas that support analytics and will help you to better position yourself for success within your organisation.

Exploring your Dataset
This section covers the essential exploratory techniques for summarising data. These techniques are typically applied before formal modeling commences and can help inform the development of more complex statistical models.

Business Metrics for Data-Driven Companies
You will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. Digital companies like Amazon, Uber and Airbnb are transforming entire industries through their creative use of big data. You’ll understand why these companies are so disruptive and how they use data-analytics techniques to out-compete traditional companies.

Understanding Your Data: Analytical Tools
Explore the tools you need to analyze and interpret the results of the datasets you collect as a data analyst.

Mastering Data Analysis in Excel
This section will prepare you to design and implement realistic predictive models based on data. We will give you enough practice with Excel to become familiar its most commonly used business functions, and you’ll be ready to learn any other Excel functionality you might need in the future. You will emerge with practical knowledge of how to apply business data analysis methods based on numerical and categorical data and linear regression all using no software tools more complex than Excel.

​
​
Unit 2
Managing Big Data with SQL
This section is an introduction to how to use relational databases in business analysis. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. No more waiting days for someone else in the company to provide data to you or your team – you will be able to get the data by yourself !

​

Unit 3

Visual Analytics
We’ll drill deeper into what a visualization tool offers in the areas of charting, dates, table calculations and mapping. We’ll explore the best choices for charts, based on the type of data you are using. We’ll look at specific types of charts including scatter plots, heat map, line charts and several others, and we’ll address charting guidelines. We’ll also introduce maps and explore how you can use different types of geographic data, how to connect to multiple data sources and how to create custom maps.

Data Visualization and Communication
In this section you will learn how to become a master at communicating business-relevant implications of data analyses. Learn how to structure your data analysis projects to ensure it yields results for your stakeholders. You will also know how to streamline your analyses and highlight their implications efficiently using a visualization tool. You will be able to make effective visualizations that harness the human brain’s innate perceptual and cognitive tendencies to convey conclusions directly and clearly. Finally, you will be practiced in designing and persuasively presenting business “data stories” that use these visualizations, capitalizing on business-tested methods and design principles.

What is included ?
Apart from the contents of the course, Business Discovery will provide the participants with the following:

Course Manual including all presentation slides, tutorial datasets, a list of reference books and online resources.
* additional home exercises and all data sets available to download
* Wi-Fi access
* Coffee Break
* Central London location zone 1 (5 minute walk from oxford circus station)
* networking

The Training will be provided by Sam Dal Pont who has more than 10 years of experience in Data. Sam has worked in different industries like Banking, Insurance, Digital Media and Ecommerce and has provided training in other academies in London for the past 2 years.

By purchasing a place on one of our courses you agree to the Terms and Conditions. Please read the Terms and Conditions before making a booking.