Data Analyst BootCamp is an intensive education program designed to equip intending software developers and students with the skills required by industry employers. A university degree today is not the only way to get training in data analytics. With the growing number of data, skilled Data Analysts are needed to fill the gaps.
This course will teach predictive analytics in business environments and give you an edge in your career and everyday life. Data analysis uses different toolkits like Google Data Studio and PowerBI to turn data into informative, easy to read reports. After this course, you will develop an analytical mindset and be familiar with these analytics tools and techniques.
Prerequisites: Basic Computer Knowledge
Course Objectives:
By the end of this masterclass, you’ll be able to confidently:
Who is this course for?
This course is for anyone who wants to make sense out of their organization’s or public data in order to gain actionable insights that can aid business decision making as well as anyone looking forward to a career in Data Analytics such as Graduates, Analysts, Business Owners, Managers, Decision Makers etc.
Who is a Data Analyst?
Aim of the Data Analyst Masterclass - take home
Introducing the two Problem Cases (Data) for GDS and PowerBI
Data Analyst Toolkit
The Data Analyst toolkit
Typical Data analysis project lifecycle
Download: Data Analyst Bootcamp Slide Course Material
Who is a Data Analyst
Aim of the Data Analyst BootCamp
Tables
Sorting and Formatting
In-Report Data Formatting
Pivot Tables and Card Visualization
Other Visualizations
Visualization (Continuation)
Data Blending
Publishing and Sharing Interactive Dashboard
Introduction
Data Source
Overview of PowerBI
The Typical PowerBI Workflow
Quick Tour of PowerBI Desktop
Datasources and Datasource setting
Practical Activity - Creating the Project File & Recommended Settings
Power Query
Joining Data
Introduction to Power Query
Appending Queries
Transform Data
How we Use the Star Schema in our Project
Working with Columns - customised columns using M formula language
Applied Steps
Theory Time: The Star Schema & Understanding "Joins"
Joining Data
Performance Optimization
Practical Activity
Data Models and Relationships View
Active Vs Non-Active Relationships - differences and use cases
Reviewing the Star Schema
Understanding Relationships
Cardinality: Many-to-One and One-to-One
Cross Filter Direction & Many-to-Many
Active Vs Non-Active Relationships - differences and use cases
Practical Activity
Time Intelligence
Introduction to Time Intelligence
Creating a Date Table
Time Calculations and Functions
Advanced Time Calculations
Bonus: Time Forecasting
Practical Activity
DAX (Data Analysis Expressions)
Understanding and Applying CALCULATE and CALCULATETABLE
Understanding and Applying CALCULATE and CALCULATETABLE (Continued)
M vs DAX - Use cases
Understanding the DAX Basics
The DAX Syntax
Supported DAX Data Types
DAX Operators
DAX Functions - An Overview
Using Table Functions - EVALUATE, FILTER, VALUES, DISTINCT, ALL
Understanding and applying CALCULATE & CALCULATETABLE
Using CALCULATE modifiers such as USER RELATIONSHIP
Introducing Variables in DAX syntax
Calculated Columns vs Measures (Quick Measures)
Creating our First Measures
Practical Activity
Creating your First Visuals in PowerBI
Understanding Bookmarks, Tooltips & Interactions
Hierarchies & Drill Mode
Conditional Formatting
Formatting Report Pages and Visuals
Slicers Vs Filters
Default and App Visuals
Time to Practice - Visualizations
Exploring the Power BI Service Interface
Publishing Data and Data Refresh
Understanding Workspaces
Understanding Collaboration Workspaces
Workspaces vs Apps vs Content Packs
Creating Dashboards
Publishing an App
Working with Power BI Mobile
Creating and Using templates
AI Visuals - Decomposition Tree and Key Influencers
Template Apps
DirectQuery with DataFlows
External Tools
Download: Data Analyst BootCamp Course Material with Instructor Notes
Bonus Track - Template Apps
Resource
More Details
Due to global pandemic, we have reduced the pricing for the this Data Analyst BootCamp by 60% to encourage more graduates who want to participate in the program. Instead of $499, we are currently offering at the discounted price of $199. There is also an option to pay in two monthly instalments of $109 each. Please contact us on [email protected] to arrange a payment plan.
We are set to help as many of our candidates to success and secure new career opportunities and therefore data analyst bootcamp participants will get the following additional benefits.
Candidates will have lifetime access to the Data Analyst Bootcamp videos on the WayMaker Digital learning portal. At no extra costs, participants will have access to the WayMaker Digital online community on the learning portal. This allows for ongoing engagement, questions, tips and career support.
Our coaches will also review your CV at no extra cost and provide valuable feedback that will ensure you are putting your best foot forward. You will be able get support for interview preparation from our community of practice. Your digital footprint including LinkedIn profile will be analysed for comment / feedback.
Many clients and hiring managers are always looking for a portfolio in order to assess the potentials of a candidate. Participating in the Data Analyst Bootcamp will ensure you have access to our coaches to support as you build your digital footprint and portfolio. Participants are able to get a professional reference from WayMaker Digital in order to support their job applications.
Instructor & Coach
“Great learning centre and community of professionals. Enjoyed my time here & left with an improved and modern education in my study subjects. Would recommend!”
David
“I did the virtual Agile and Scrum bootcamp and the instructor was engaging and shared his slides, books and materials. There was also very useful discussion about real work scenarios. I would highly recommend.”
Nosa
“It's great and a wonderful opportunity to be part of this vision at WayMaker Digital. We are not stagnant, we are moving and climbing. Forward ever.”
Nelson
This course is designed to give you an overview of all the skills and tools you need to handle user research. It’s really a matter of getting out there, talking with people, and observing them as they complete tasks online.
This Agile Business Analysis course will give you hands-on experience with the latest proven techniques for defining a project’s scope, developing and discovering requirements and use cases and documenting them expertly.
Live access to professional coaching, career support, expert guidance with practical tips and strategies that will guarantee exponential career growth within digital technology, agile, lean and leadership areas.